Results-driven PL/SQL Developer with 3+ years of experience in SQL query optimization, database troubleshooting, and secure framework development, committed to enhancing operational efficiency and data integrity.
Overview
4
4
years of professional experience
1
1
Certification
Work History
PL/SQL Developer
Tata Consultancy Services
Mumbai
07.2021 - Current
Collaborated with team members to troubleshoot database issues effectively.
Maintained a turnaround time (TAT) under 4 hours for 95% of incidents, service requests, and problem tickets, ensuring SLA compliance, and high service reliability.
Developed stored procedures and functions as per the project requirements.
Modified existing procedures and functions as per the project requirements.
Developed complex SQL queries using joins and subqueries to extract and analyze transactional data.
Analyzed PL/SQL code to troubleshoot incidents by interpreting application logs, identifying impacted logic, and fetching relevant database records for root cause analysis and resolution.
Built a secure PL/SQL framework for L2 operations, enabling controlled data access and preventing unauthorized or accidental changes to critical records.
Participated in code reviews to ensure quality standards were met.
Collaborated with other teams such as DBA's, Data Architects and System Administrators for resolving any issues related to Oracle databases.
Received 'On the Spot Award' at TCS for spontaneous contribution to the project.
Awarded TCS Digital Profile by clearing TCS Internal Wings1 examination.
Projects
Order Management System – PL/SQL
Developed a backend database project in PL/SQL for an order management system, simulating a real-world use case.
Created relational tables (customers, orders, order log) with primary and foreign key constraints Designed a package with procedures (place_order) to insert orders and log high-value orders (above ₹1,000) using conditional logic Implemented exception handling and integrity constraint management to maintain data consistency.
Tested procedures with various transaction values and verified updates using SELECT queries.
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services