Aditya Kumar Singh

Project 1

PL/SQL Developer - Tata Consultancy Services

(2025-03)

Project 1

• Wrote and debugged PL/SQL stored procedures and cursors — optimized CASE-based conditional logic and fine-tuned cursor loops, significantly improving batch execution speed and data processing efficiency.
• Built JSON objects for Control-M DB batch scheduling and managed frontend cron jobs — ensured zero batch failures across automated workflows.
• Handled Excel datasets exceeding 1 lakh rows using VLOOKUP and Advanced Excel — built Tableau dashboards for stakeholder reporting.
• Coordinated with foreign clients on requirements and defects — tracked and closed deliverables end-to-end on JIRA within sprint timelines.

Backend Developer - Tata Consultancy Services - Onsite(Tata Main Hospital-Jamshedpur)

(2023-01 - 2025-03)

Project 2

• Took KT on HMS application, owned L2 support across OPD/IPD and billing modules — performed RCA at Oracle DB layer, debugged PL/SQL packages, cursors, and exception handlers to resolve SNOW incidents within SLA.
• Delivered client enhancements end-to-end — modified stored procedures, triggers, and functions, coordinated UAT with hospital stakeholders, and deployed to production with zero rollbacks, reducing ticket backlog by 40%.
• Identified recurring SNOW ticket patterns, built reusable PL/SQL fix scripts and documented SOPs — cut repetitive L2 escalations by 35% and improved first-call resolution across the team.

Masters in Computer Application - Computer Application - Sastra University (2023 - 2025)

Bachelors in Computer Application - Computer Application - Shri Ramswaroop Memorial College of Engineering (2019 - 2022)