Kshitij Bhardwaj
Senior Oracle PL/SQL Developer
Noida,UP
Summary
Seasoned and results-focused Oracle PL/SQL Developer with 8.9 years of experience architecting, developing, and optimizing enterprise-grade database solutions across finance, payroll, and life sciences domains. Expert in PL/SQL, Oracle 11g–19c, and ETL processes, with a proven record of driving performance improvements, automation, and operational excellence. Adept in Agile methodologies, production support, cross-functional collaboration, and end-to-end SDLC ownership. Trusted by Fortune 500 clients including Mastercard, Citi, ADP, and UBS.
Overview
9
9
years of professional experience
2015
2015
years of post-secondary education
Work History
PL/SQL Developer
NTT Data
09.2023 - Current
- Company Overview: Client: Mastercard
- Spearheaded development of PL/SQL procedures, packages, and functions supporting Mastercard Prepaid Management Services (MPMS).
- Delivered highly optimized code for critical payment modules, ensuring reliability, scalability, and data accuracy.
- Partnered with QA and Business Ops to troubleshoot live database issues and minimize downtime.
- Participated in cross-functional ceremonies including design walkthroughs, deployment planning, and status reporting.
- Client: Mastercard
Senior Database Engineer
IRIS Software
01.2021 - 09.2023
- Project: ADP International Money Movement
- Designed batch processing systems for global payroll disbursement and control-level reporting.
- Led successful migration from Oracle EBS to modern UI architecture, enhancing system agility.
- Project: Citi Compliance For You (CoFY)
- Built a unified global compliance platform used by thousands of employees across geographies.
- Automated due diligence and onboarding workflows, reducing manual effort and compliance risks.
- Conducted query tuning and optimization, resulting in up to 70% performance improvement.
- Wrote and reviewed technical specs, UAT cases, and deployment documents.
PL/SQL Engineer
JOY IT Consultancy Pvt. Ltd
08.2019 - 01.2021
- Developed high-volume ETL pipelines for client security data ingestion and transformation (CDI).
- Handled multi-stage data processing, error logging, and schema validation for top banking clients (UBS, SSBT, BNYM).
- Led performance tuning efforts that improved data loading times by over 50%.
- Wrote UNIX-based scripts and analyzed logs for debugging large-scale production issues.
Analyst Software Engineer
Accenture Solutions Pvt. Ltd
03.2016 - 07.2019
- Member of Application Retirement Team for a leading US pharmaceutical client.
- Used IBM Infosphere Optim for archival processes and executed complex SQL queries for reporting.
- Created critical database objects (tables, views, synonyms) and contributed to legacy data migration initiatives.
- Liaised with business users for demonstration, validation, and support.
Education
B.Tech - Electronics & Communication Engineering
Ajay Kumar Garg Engineering College
Senior Secondary (CBSE) - undefined
AECS Narora
Secondary School (CBSE) - undefined
AECS Narora
Skills
- Oracle 11g
- Oracle 12c
- Oracle 19c
- DB2
- MS SQL Server
- PL/SQL
- SQL
- Python
- C
- Oracle Data Integrator (ODI)
- OBIEE
- BIRT Reports
- SQL Loader
- Exp/Imp
- Postman
- Toad
- SQL Developer
- Eclipse
- VS Code
- Splunk
- Autosys
- Bitbucket
- IntelliJ
- Jira
- Rally (ALM)
- Remedy
- Confluence
- Star Schema
- Snowflake Schema
- Fact-Dimension Tables
Accomplishments
- Drove 70%+ performance improvements in mission-critical PL/SQL queries through advanced tuning techniques, resulting in faster processing and reduced resource consumption.
- Led end-to-end migration of payroll processing modules from Oracle EBS to a modern UI platform with zero data loss and zero downtime.
- Recognized by leadership at Mastercard and ADP for exceptional handling of high-priority production issues, ensuring uninterrupted business continuity under tight SLAs.
- Developed 100+ reusable PL/SQL packages and stored procedures, significantly reducing development time and enabling modular architecture.
- Played a key role in launching Citi's global compliance platform (CoFY) used by thousands of employees globally, enhancing policy automation and regulatory adherence.
- Created and optimized multi-terabyte ETL workflows handling millions of records with high accuracy and minimal latency for top-tier clients like UBS and SSBT.
- Acted as Technical Lead for ETL Optimization Projects, mentoring junior developers and driving knowledge sharing across geographically distributed teams.
- Consistently delivered 100% defect-free releases across multiple Agile sprints by maintaining rigorous unit testing and peer review standards.
- Automated manual data loading processes, reducing operational effort by 40% and improving SLA adherence.
- Received internal awards for 'Outstanding Contribution to Database Stability' and 'Customer Impact' at IRIS Software and JOY IT.
Timeline
PL/SQL Developer
NTT Data
09.2023 - Current
Senior Database Engineer
IRIS Software
01.2021 - 09.2023
PL/SQL Engineer
JOY IT Consultancy Pvt. Ltd
08.2019 - 01.2021
Analyst Software Engineer
Accenture Solutions Pvt. Ltd
03.2016 - 07.2019
Senior Secondary (CBSE) - undefined
AECS Narora
Secondary School (CBSE) - undefined
AECS Narora
B.Tech - Electronics & Communication Engineering
Ajay Kumar Garg Engineering College
Similar Profiles
Pankaj NathPankaj Nath
Director - Cloud & Infrastructure Services at NTT DATA Services (Previously NTT/Netmagic)Director - Cloud & Infrastructure Services at NTT DATA Services (Previously NTT/Netmagic)
Adibus SholehAdibus Sholeh
Solution Architect at PT NTT Indonesia Technology (NTT DATA)Solution Architect at PT NTT Indonesia Technology (NTT DATA)
GAZI MAMOONUR ALAMGAZI MAMOONUR ALAM
SENIOR NETWORK ENGINEER at NTT GLOBAL PVT. LTD(NTT DATA)SENIOR NETWORK ENGINEER at NTT GLOBAL PVT. LTD(NTT DATA)
Yashika SureshbabuYashika Sureshbabu
Service Desk Analyst / Acting Shift Lead at NTT GDC India Private Limited / NTT DataService Desk Analyst / Acting Shift Lead at NTT GDC India Private Limited / NTT Data
SHIPRA YADAVSHIPRA YADAV
Accreditation Officer at Quality & Accreditation Institute (QAI)Accreditation Officer at Quality & Accreditation Institute (QAI)