Diptee Yerkhede
PL/SQL Developer | Application Support Engineer
Hire this person
Send a job offer directly to this candidate
About
Oracle PL/SQL Developer and Application Support Engineer with 4 years of experience in banking and financial services (State Street via HCL Technologies). Skilled in building and optimising PL/SQL stored procedures, packages, and triggers for high-volume NAV data processing, alongside L2/L3 incident management, batch monitoring, and ITIL-aligned change management. Resolved 90%+ of incidents within SLA and reduced unplanned downtime by 20%.
Experience
PL/SQL Developer & Application Support Engineer - HCL Technologies - Banking & Financial Services
(2021-11)
Client: State Street | Oracle PL/SQL | L2/L3 Production Support | NAV Data & File Delivery
- Developed and maintained 30+ PL/SQL stored procedures, functions, and packages to automate NAV data processing and file delivery, reducing manual effort by ~35%.
- Resolved L2/L3 production incidents end-to-end — triage, PL/SQL investigation, data fix, and deployment — achieving 90%+ SLA compliance.
- Optimised 15+ slow SQL queries and PL/SQL procedures using EXPLAIN PLAN and bulk collect/FORALL, improving execution time by up to 40% on 10M+ row tables.
- Wrote PL/SQL triggers and DBMS_SCHEDULER jobs to enforce data integrity and automate nightly reconciliation, eliminating recurring NAV data mismatch incidents.
- Monitored batch jobs via JCI and Cloud App Controller, identifying failures in real time and executing runbook recovery steps to maintain SLA compliance.
- Implemented centralised exception handling and error logging in all PL/SQL packages, cutting average root cause analysis time by ~25%.
- Proactively monitored application health via Splunk and Dynatrace, preventing outages and improving uptime by 15%.
- Deployed DDL/DML scripts to PROD and UAT following CAB-approved change procedures — zero post-deployment errors across all releases.
- Applied ITIL framework: raised ServiceNow incidents, authored problem records, submitted change requests, and attended CAB meetings.
- Maintained runbooks for the 20 most common database incidents, reducing MTTR across the support team.
- Received formal appreciation from State Street onsite and offshore managers for SLA delivery and PL/SQL automation work.
Education
B.E. - Electronics & Telecommunication Engineering - Yashwantrao Chavan College of Engineering, Nagpur (2018 - 2021)
