SUMIT KUMAR
Kolkata
Summary
Mainframe and IBM DB2 Database Specialist with 13 years of experience in enterprise banking, insurance, and retail domains, delivering scalable database solutions, modernizing legacy systems, and supporting mission-critical mainframe applications. Experienced in IBM DB2 Administration, performance tuning, version upgrades, database architecture, and production support across large-scale z/OS environments. Skilled in designing database solutions, implementing business transformation logic, and building enterprise data products through source-to-target data mapping, data transformation, and integration using IMS DB, CDC/MQ, Kafka, and cloud-enabled architectures. Proven ability to bridge traditional mainframe platforms with modern data engineering practices while ensuring high availability, security, and operational excellence.
Overview
1
1
Certification
13
13
years of professional experience
Work History
Associate Consultant
TCS
Kolkata
08.2025 - Current
Business Data Mapping
- Collaborated with business stakeholders to gather requirements and executed source-to-target data mapping for 9 enterprise data products, achieving delivery of 3 products and advancing 6 in development.
- Defined transformation rules and mapping documents that served as the foundation for implementing business logic, ensuring consistent and accurate data flow across 3 business domains.
- Owned DB2 transformation layer, developing and maintaining 30+ stored procedures and 40+ database objects (tables, DDLs, indexes) to implement business transformation logic.
- Built and maintained data pipelines that process approximately 2.5 million records daily, integrating data from IMS DB and IBM DB2 using CDC/MQ and Spring Boot services.
- Developed transformation logic to convert raw legacy data into business-ready datasets and published the processed data to 8 Kafka topics, enabling near real-time consumption by downstream applications.
- Facilitated production rollout of 3 enterprise data products while supporting 6 additional products in various development and testing stages.
Associate Manager
Accenture
Kolkata
10.2018 - 07.2025
- Optimized IBM DB2 databases for high-availability systems to ensure reliability.
- Designed critical database objects, including tables, views, triggers, and stored procedures across IBM DB2 and SQL Server platforms.
- Led upgrades from IBM DB2 v12 to v13FL100, conducting health checks via Omegamon and DB2PD.
- Supported backup/recovery processes and compliance initiatives for banking and insurance clients, enhancing data integrity and regulatory adherence.
- Contributed to cloud integration projects for IBM DB2 workloads in Microsoft Azure, facilitating seamless data migration and application performance.
- Administered RACF user IDs, profiles, and dataset permissions to ensure secure access control across multiple systems.
- Ensured compliance with company security rules through RACF settings and successful audits.
- Exposure to mainframe modernization, including application assessment, integration with distributed systems(multiple LPARs), and migration planning.
Team Leader
Accenture
10.2018 - 07.2022
- Led development and enhancement of core banking systems using IBM DB2 and COBOL.
- Managed IBM DB2 change deployments through Change Manager (ADBL) to ensure system stability and compliance.
- Provided end-to-end support for IBM DB2 databases (L1–L3) to ensure continuous high availability and performance.
- Integrated dataset profiling access via RACF to strengthen data security and control access.
Software Engineer
HSBC Software Development
07.2015 - 10.2018
- Managed development, deployments, and production support for mainframe systems on IBM DB2, ensuring system reliability.
- Developed and optimized SQL queries for daily business reporting and performance troubleshooting on IBM DB2, enhancing data accuracy.
- Delivered critical hotfixes and rapid response resolutions for IBM DB2-based systems, minimizing downtime.
Software Developer
NTT Data GDS Ltd
01.2014 - 07.2015
- Developed core COBOL programs integrated with IBM DB2 database, supporting system functionality.
- Contributed to enhancements and testing of Mainframe applications using COBOL, JCL, VSAM, and IBM DB2 following foundational training.
- Developed software applications using modern programming languages and frameworks.
- Collaborated with cross-functional teams to define project requirements and timelines.
- Implemented automated testing procedures to enhance code quality and reliability.
Education
B.Tech/B.E. - Computer Science
Gandhi Institute for Technology Advancement
01-2013
12th -
Andhra Pradesh Board
01-2009
10th -
CBSE Board
01-2007
Skills
- DB2 mainframe expertise
- SQL and database management
- Cloud Database Integration
- Data pipeline management
- Performance monitoring
- Data visualization
- COBOL and JCL programming
- VSAM and data storage solutions
- RACF security management
- Job scheduling
- Automation Scripting
Certification
- Microsoft Azure Fundamentals, AZ-900
- MongoDB Basics, M001
Languages
- English
- Hindi
Phone
+91, 9703879038
Timeline
Associate Consultant
TCS
08.2025 - Current
Associate Manager
Accenture
10.2018 - 07.2025
Team Leader
Accenture
10.2018 - 07.2022
Software Engineer
HSBC Software Development
07.2015 - 10.2018
Software Developer
NTT Data GDS Ltd
01.2014 - 07.2015
B.Tech/B.E. - Computer Science
Gandhi Institute for Technology Advancement
12th -
Andhra Pradesh Board
10th -
CBSE Board