Palak Garg
Bengaluru
Summary
Dynamic DB2 System Programmer with extensive experience in IBM and Kyndryl India Pvt. Ltd., specialising in CA Database Management Solutions and the SMPE process. Proven track record in leading successful DB2 migrations and upgrades, while excelling in problem-solving and documentation. Skilled in JCL and ServiceNow, driving efficiency in large-scale environments.
Overview
10
10
years of professional experience
5
5
Certifications
Work History
DB2 System Programmer
IBM India Pvt.Ltd. & Kyndryl India Pvt. Ltd.
07.2015 - Current
- Led various DB2 Migrations/ RSU Maintenance/Patching/Early code upgrades etc.
- Executed version upgrades/maintenance for CA Database Management Solution for DB2 for z/OS(Broadcom), RLX version upgrades and maintenance. Also familiar with complete SMPE process with CA CSM Tool to download and maintain CA software.
- Experienced in complete SMPE process to download ISV tools for DB2 and IBM DB2 new versions and new maintenance.
- Experienced 2-6 way Data sharing environments.
- Led Db2/ISV Tools upgrade/Maintenance for large systems with multiway Data sharing and stand alone systems - approximately 56 data sharing systems and 28 standalone DB2 systems to be precise.
- Backup & Recovery for the DB2 objects/Tools objects as part of the upgrades.
- Support for IBM DB2 TLS Installation from DB2 System's end. Led BSDS update for production environments to enable and setup secport for application teams.
- Major cleanup for old datasets including important backups.
- Have experience in migration/maintenance for DB2 Administration Tool, Automation Tool, CA, RLX, File Manager, IBM Query Management Facility (QMF), ASG Manager Products.
- Supported CICS Tools upgrades for Informatica Power Exchange Tool/Install/1 Tool as Db2 System Programmer, performed Binds, analyzed Plans/Packages/COLL Ids etc as part of the Tools migration.
- Worked on various IBM utilities - Load, Unload, Copy, DSNTIAUL, DSN1COPY, DSN1PRNT, Reorg, DSNJU003, DSNJU004, Run-stats, CATNFM, CATMAINT, Check-data.
- Support for Disaster Recovery Projects and audits yearly for large systems as a DB2 System Programmer.
- Create and Maintain huge guides/documentation for a Telecom client.
- Performed Root cause analysis for recurring issues, worked on Problem Tickets.
- Experienced working on ticketing tools like SERVICE NOW, Maximo, Remedy, HP ALM, OR Autofix, MUI for ticketing/Service Requests/Change creation/Approval etc.
- Good exposure in DB2 L1 & L2 support activities, Broadcom support for CA DBMS, RCP (Risk Based Continuous Patch).
- Exposure to Kyndryl bridge and AI ops
Education
B.Tech - Computer Science (CSE)
SRM University
Chennai06-2015
Diploma - Computer Science (CSE)
Fr. Agnel Polytechnic
Delhi05-2012
Skills
- CA Database Solution for DB2 for z/OS
- SDSF
- Job Control Language(JCL)
- IBM DB2
- DB2 Administration Tool
- DB2 Automation Tool
- Db2 Omegamon Tool
- IBM Query Management Facility (QMF)
- IBM File Manager
- IBM SPUFI
- ServiceNow
- kyndryl bridge & AI Ops
- Problem solving
- SMPE process
Certification
IBM Agile Explorer/Advocate/Achiever
Interskill - Mainframe Operator - DB2 Operations
Interskill - Mainframe Application Programmer - DB2 Programming - Experienced
IMS 15 Operations-Experienced
Data Science Foundations - Level 1
Interskill - Mainframe Systems Programmer - IMS 15 - Experienced
Interskill - Mainframe Security - RACF-Foundations
Interskill - Mainframe Operator - DB2 Operations
Interskill - Mainframe Application Programmer - DB2 Programming - Experienced
IMS 15 Operations-Experienced
Data Science Foundations - Level 1
Interskill - Mainframe Systems Programmer - IMS 15 - Experienced
Interskill - Mainframe Security - RACF-Foundations
Honors And Awards
- Rewarded & Recognized by one of the Clients for excellent support & performance.
- IBM Certified Master Blue - Senior level Certification for Mainframe System Programmers.
- Recognized for the best performance and Client appreciation.
Timeline
DB2 System Programmer
IBM India Pvt.Ltd. & Kyndryl India Pvt. Ltd.
07.2015 - Current
B.Tech - Computer Science (CSE)
SRM University
Diploma - Computer Science (CSE)
Fr. Agnel Polytechnic