Keerthika Chinnathambi
Salem
Summary
PL/SQL Developer with 6.6 years of experience in designing, developing, and supporting Oracle database applications in enterprise environments. Proven expertise in writing efficient PL/SQL code, developing complex stored procedures, and optimizing SQL queries for performance. Skilled in handling end-to-end development as well as L2/L3 production support, with hands-on experience in job monitoring, incident management, and root cause analysis. Proficient in tools like SQL Developer, Microsoft SQL Server and experienced in Agile and ITIL-based environments. Known for strong problem-solving skills, code quality, and cross-functional collaboration.
Overview
7
7
years of professional experience
Work History
Senior Developer
Wipro
Kochi
09.2022 - Current
- Designed and developed complex PL/SQL packages, procedures, functions, and triggers for high-volume enterprise applications.
- Wrote and optimized complex SQL queries for reporting, data validation, and business intelligence.
- Developed reusable code libraries and standardized naming conventions across modules.
- Improved query execution time by up to 60% through indexing, query refactoring, and partitioning strategies.
- Led L2/L3 support for critical production systems, ensuring 24/7 availability and fast issue resolution.
- Analyzed production incidents, performed root cause analysis, and implemented permanent fixes.
Support Engineer
TCS
Chennai
06.2018 - 08.2022
- Provided L2 support for Oracle-based applications, handling production incidents, service requests, and user queries.
- Analyzed and resolved PL/SQL code defects and data-related issues raised by business users.
- Maintained SLA compliance by resolving high-priority incidents within agreed timelines.
- Investigated recurring production issues using logs and SQL query analysis.
- Performed root cause analysis (RCA) and implemented permanent fixes in coordination with L3/development teams.
- Documented RCA findings and contributed to the knowledge base for faster resolution of repeat issues.
- Monitored daily batch jobs through Control-M and fixed failures by analyzing log files and debugging PL/SQL code.
- Coordinated with upstream and downstream teams to resolve data mismatches and interface failures.
- Automated monitoring scripts and alerts to proactively detect job anomalies.
Education
Bachelor of Arts - B.COM
Vivekananda College of Arts And Sciences For Women
Thiruchengode05-2018
Skills
- Oracle PL/SQL Development
- SQL Query Optimization
- Stored Procedures, Functions, Triggers,Packages
- Performance Tuning
- Exception Handling & Error Logging
- L2 / L3 Production Support
- Incident Management & RCA (Root Cause Analysis)
- SQL optimization
- Technical support
Languages
Tamil
First Language
English
Advanced (C1)
C1
Malayalam
Beginner (A1)
A1
Timeline
Senior Developer
Wipro
09.2022 - Current
Support Engineer
TCS
06.2018 - 08.2022
Bachelor of Arts - B.COM
Vivekananda College of Arts And Sciences For Women