Kasturi Redkar
Mumbai
Summary
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.
Education
Bachelor of Engineering - Information Technology
University of Mumbai
Mumbai05-2021
Skills
- PL/SQL programming
- SQL query optimization
- PL/SQL: Stored Procedures, Triggers, Packages, Cursors, Exception Handling
- Advanced SQL: Joins, Subqueries, Window Functions, CTEs, Set Operators, Indexing, Query Optimization
- Data Modeling
- Git
- Root cause analysis
- Microsoft Word
- Microsoft Excel
Accomplishments
- 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.
Certification
- Microsoft Certified: Azure Fundamentals (AZ-900)
- HackerRank: SQL certificate
- Advanced Python : Working with Data
Timeline
PL/SQL Developer
Tata Consultancy Services
07.2021 - Current
Bachelor of Engineering - Information Technology
University of Mumbai
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
Suraj SethSuraj Seth
Assistant Manager – Direct Tax at CBV & Associates LLPAssistant Manager – Direct Tax at CBV & Associates LLP