Lokesh Lucky

System Engineer

Tata Consultancy Service•  February 2022 - Present•  bangalore

Worked as part of the Parameterization and Data Migration team. Developed and optimized complex SQL queries and PL/SQL scripts for Oracle and PostgreSQL databases to support data migration activities. Hands on experience in Creation of Indexes, Views, Synonyms, Materialized views, Sequences, Temporary tables and Object-Oriented PL/SQL Programming. Exposure writing complex SQL Queries and involved in creating Tables, inserting Rows, adding Relations, Primary and Foreign Key and setting Default Values to columns. Collaborated with cross-functional teams to parameterize various banking modules, ensuring seamless integration and operation. Automated data migration processes using Java and shell scripting on Linux, significantly reducing manual intervention and increasing efficiency. Utilized Git for version control and Jenkins for continuous integration, ensuring smooth and error-free deployment cycles. Analysed and resolved database performance issues, ensuring optimal system performance during peak operations.