LEKHA S
PLSQL Developer
Chennai
Summary
Oracle Database Developer with 8.6 years of professional experience specializing in Oracle 11g/12c, PL/SQL, Informatica PowerCenter, and Unix. Strong expertise in designing, analyzing, and managing databases, as well as developing applications. Proficient in database optimization, performance tuning, and ETL data integration using Oracle and Informatica. Skilled in all phases of the Software Development Life Cycle (SDLC) and experienced in 24/7 production support. Excellent problem-solving skills and a proven ability to collaborate in Agile environments.
Overview
8
8
years of professional experience
3
3
years of post-secondary education
Work History
Online Payment Gateway Interface System
Datamatics
01.2023 - Current
- Change and creation of new PL/SQL Packages and Stored Procedures, Functions, Triggers as per business requirement
- Worked on developing a financial application system to handle all the bank transactions
- Developed and modified PL/SQL Code to make new enhancements or resolve problems as per customer requirements
- Utilized Cursors to through large result sets, improving performance and reducing memory consumption
- Created Records, Collections for improving Query performance by reducing Context Switching
- Used Pragma Autonomous Transaction to avoid Mutating problems in database
- Handled errors using Exception Handling extensively for the ease of debugging and displaying error messages in the applications
- Creating Indexes on tables to improve the performance by eliminating the full table scans and Views for hiding the actual tables and eliminating the complexity of the large queries
- Developed and optimized PL/SQL Code Utilizing Ref Cursors for data retrieval and manipulation, resulting in improved performance and reduced response time for critical database operations
- Utilized PL/SQL Control Statements such as If then, Else and Case to handle conditional logic and decision-making process
- Used UTL_File to load data from flat files, modified data according to the business logic and saved back into flat file or into table
- Optimized the oracle PL/SQL queries by Performance Tuning, involved in generating Explain Plan to check the cost of the queries
- Written complex SQL (Sub queries and Join conditions) in PL/SQL
Senior Software engineer (Oracle & PostgreSql PLSQL and Performance Tuning)
GAVS Technologies
08.2022 - Current
- Company Overview: CLIENT NAME : APOLLO HEALTHCARE HOSPITALS
- Developed and customized various types of reports and forms to meet functional business requirements using advanced SQL queries
- Created entity relational & dimensional relational data models (star schema & snowflake schema)
- Created complex source-target, type 1, type2 mappings which involved slowly changing dimensions, transformation rules, and necessary indexes in the target tables
- Involved in production support experience with scheduling of database scripts and workflows
- Involved in code migration, backup, maintain and restoring informatica repository & server process
- Involved in the development and conversion of code objects as part of migration to PostgreSql from Oracle
- Supported in validation of code objects and storage objects migrated to PostgreSql
- Troubleshoot performance issues, analyze bottlenecks and make recommendations to improve performance of the solution
- Worked directly with clients and users to resolve live performance issues
- Responsible for the management of the Performance, backup, replication, capacity and security of the database and to perform several diagnostic tests to keep a check on server and database
- Created and modified tables with appropriate constraints using SQL commands (DDL and DML Statements) and for Data validation
- Employed Constraints like Foreign Key to enforce a link between the two tables which enable us to store different type of data in different table which avoid data redundancy
- Extensively used String functions and Date functions in data cleaning and shaping to convert data in the desired format to load into database
- Worked on mapping documents from source to data mart
- Created Indexes on the tables for faster retrieval of the data and enhance the database performance
- Developed Views, Synonyms, Sequences and Materialized view for secured accessibility of database object and query and to improve the performance of a SQL query
- Acquired expertise in all types of Joins, Subqueries, Windows functions and CTE tables to write complex queries that can fetch a lot of insightful data
- Used SQL
- Loader as an ETL tool to load data from the source CSV files into Staging tables
- CLIENT NAME : APOLLO HEALTHCARE HOSPITALS
Risk Remediation and Management
Datamatics
01.2020 - 12.2022
- Involved in the continuous enhancements and fixing of production problems
- I have good knowledge on DML operations like insert, update, delete and merge
- Worked on the DDL operations like create, alter, truncate, drop and rename on the database tables
- Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan, including the effective utilization of Sub Queries for data retrieval and manipulation
- Created scripts to Create New Tables, Views for new enhancement in the application using TOAD
- Created Indexes, Joins, Null functions, Character Functions, Date Functions, SQL Plus Commands on the tables for faster retrieval of the data to enhance database performance
- Expertise in using Group Functions, Analytical Functions to identify patterns and trends in large datasets, enabling strategic decision-making and process improvement
- Wrote sequences for automatic generation of Unique keys to support Primary and Foreign key Constraints in data conversations
- Creation of database objects like Materialized Views, Sequences, Set Operators, Case & Decode and Synonyms using Toad
- Converted open purchase orders from legacy system to oracle purchasing using SQL
- Loader, PL/SQL
- Having experience on Work Request (WR) and Change Request(CR)
- Data loads are been performed by using the SQL Loader, Imports and UTL_ Files based on file formats
Software Engineer (Oracle PL/SQL Developer)
Glibware Soft Solutions
08.2017 - 07.2022
- Company Overview: CLIENT NAME : Lloyds Banking Group, UK
- Created custom Stored Procedures, Functions and Packages to load/extract the data from Oracle Application and Legacy systems
- Documented the whole Process flow, PL/SQL packages, log files, locations and descriptions, log tables and possible error messages, process codes and descriptions
- Deployed Triggers to scrutinize the database objects capture information about the triggering event like DDL and DML transaction
- Extensive used of Collection datatype (nested table, varrary), Object , Record and Ref cursor datatype in PL/SQL blocks
- Used Pragma Autonomous Transaction to make the subprogram independent and customize the sequence of execution
- Used Bulk Collect which enable bulk insertion and processing of huge data to avoid context switching
- Handled errors using Exceptions for the possible to avoid run time error and to complete the PL/SQL procedure
- Troubleshooting complex business issues, proposing long-term solutions
- Deployed user defined exceptions such as SQLCODE and SQLERRM for the documentation of error details to identify the bug and debug it as well as for future references
- Done code deployment to higher environments with code repository software Bitbucket and connected Bitbucket Cloud to on-prem CI/CD tools like Jenkins
- Created Dynamic SQL scripts in PL/SQL to build SQL statements dynamically in the runtime based on the user input
- CLIENT NAME : Lloyds Banking Group, UK
Education
Bachelor of Computer Science -
Manonmaniam Sundaranar University
01.2011 - 01.2014
B.E - Automobile Engineering
The Kavery College of Engineering
Skills
Oracle 11g
Oracle 12c
SQL
PL/SQL
PostgreSQL
Informatica PowerCenter
Unix
Windows
Unix Shell Scripting
Autosys Job Scheduling
SQL Developer
TOAD
Oracle SQL Loader
UTL_FILE
Explain Plan
Indexing
Bulk Binds
Bulk Collect
Table Partitioning
Tables
Views
Materialized Views
Indexes
Sequences
Synonyms
Database Links
Data Normalization
Exception Handling
Dynamic SQL
Ref Cursors
Disclaimer
I hereby declare that the above furnished information are true to my knowledge and belief.
Personal Information
- Father's Name: Athimoolam A
- Date of Birth: 05/05/98
- Marital Status: Single
Timeline
Online Payment Gateway Interface System
Datamatics
01.2023 - Current
Senior Software engineer (Oracle & PostgreSql PLSQL and Performance Tuning)
GAVS Technologies
08.2022 - Current
Risk Remediation and Management
Datamatics
01.2020 - 12.2022
Software Engineer (Oracle PL/SQL Developer)
Glibware Soft Solutions
08.2017 - 07.2022
Bachelor of Computer Science -
Manonmaniam Sundaranar University
01.2011 - 01.2014
B.E - Automobile Engineering
The Kavery College of Engineering