Diptee Yerkhede

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%.

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.

B.E. - Electronics & Telecommunication Engineering - Yashwantrao Chavan College of Engineering, Nagpur (2018 - 2021)