Summary
Overview
Work History
Education
Skills
Websites
Accomplishments
Timeline
Generic

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
Kshitij BhardwajSenior Oracle PL/SQL Developer