Summary
Overview
Work History
Education
Skills
Languages
Training
Timeline
Generic

S LEKHA

Chennai

Summary

Dynamic and enthusiastic professional having 8+ years of experience in application development in IT Industry with 2+ years of experience in optimizing Oracle database performance to ensure efficient and effective operations. Proficient in diagnosing performance bottlenecks, implementing performance tuning strategies, and enhancing system scalability. Seeking to leverage expertise in Oracle database management and performance optimization.

Overview

6
6
years of professional experience

Work History

Senior Software Engineer (PostgreSql, Oracle PLSQL and Performance Tuning)

GAVS Technologies
08.2022 - 04.2025
  • Developed Packages, Triggers, Procedures and functions to implement Business Logic using Oracle SQL / PLSQL.
  • 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 client and users to resolve live performance issues.
  • Analyze tests results and work with Developers and Engineers to improve performance or perform defect fixes.
  • Strong understanding of Oracle database architecture and internals.
  • Involved in creating complex queries for BI and Reporting tools like Power-BI.
  • Designing and implementing database schemas, indexes, and partitions for optimal performance.
  • Involved in SQL Query tuning and provided tuning recommendations for time/CPU consuming queries in scheduled jobs and thereby reduced the execution duration.
  • Clients: Apollo Hospitals, Chennai, India, Premier Healthcare Associates USA

Senior Software Engineer

GLIBWARE SOFT SOLUTIONS
06.2022 - 01.2019
  • Involved in the development of projects in BFS domain, HRMS and Integration of third-party applications like Payment gateway.
  • Gathering requirements and understanding the functionalities involved in the application.
  • Developed Packages, Triggers, Procedures and functions to implement Business Logic using Oracle PL Sql.
  • Designed database components including tables and coordinated with frontend design team to provide them with required database components and necessary insight into data.
  • Involved in preparing unit test case, unit testing and bug-fixing.
  • Worked with issue tracking and project management tool - JIRA.
  • Client: Asirvad Microfinance Ltd

Software Engineer

Manappuram Finance Ltd.
12.2018 - 08.2016
  • Involved in Web and Windows based application development with Microsoft technologies like VB .Net, C# .Net etc.
  • Exposure in Financial and Accounting application domain.
  • Involved in design, development, testing and implementation phases of application development in Agile methodology.
  • Involved in extracting data for various departments of the company for the business planning and decision making.
  • Created scheduler jobs for the EMI Processing, Accrual processing etc and monitored the execution results to make it stable.
  • Client: Manappuram Finance Ltd.

Education

Bachelor of Science - Computer Application

Manonmaniam Sundaranar University
03.2014

Skills

  • ORACLE/PLSQL
  • Performance Tuning
  • PostgreSQL
  • C#, VB, Net
  • Project leadership
  • Team Building
  • Time Management
  • Calm Under Pressure

Languages

Tamil
English

Training

  • Microsoft Business Intelligence –Undergone internal training in Azure Data Factory (ADF).
  • Awarded best performer during Oct 2024 - Dec 2024.

Timeline

Senior Software Engineer (PostgreSql, Oracle PLSQL and Performance Tuning)

GAVS Technologies
08.2022 - 04.2025

Senior Software Engineer

GLIBWARE SOFT SOLUTIONS
06.2022 - 01.2019

Software Engineer

Manappuram Finance Ltd.
12.2018 - 08.2016

Bachelor of Science - Computer Application

Manonmaniam Sundaranar University

Similar Profiles

CREATE PROFILE
S LEKHA