SUMMARY:

• 16+ years of experience in the IT industry, it includes 9 years of experience as z/OS DB2 DBA, 7 years as IMS DBA, Systems Analyst, 4 years as Endevor Admin and 5 years experience in Development, Maintenance, Enhancement and Production Support projects on z/OS, OS/390, MVS. Areas of expertise include DB2, IMS, COBOL, CICS, VSAM, JCL, IBM, BMC and CA / Platinum utilities.

TECHNICAL SKILLS:

Operating Systems: MVS/ESA, OS/390 2.10, z/OS 2.3, DCE IMS Application Servers, UNIX,MS - DOS, MS-Windows

DBMS: DB2, IMS

Languages: COBOL, JCL, CICS, VSAM, CLIST, REXX

Utilities / Tools: IBM, CA, BMC utilities, Platinum products- RC/QUERY, RC/MIGRATOR, RC/UPDATE, RC/SECURE, Log Analyzer, CA-Insight, CA-Detector, RACF, BCV5 Cloning tool, Rocket Software Shadow Servers, Embarcadero Data Model, DB2 Connect, TSO/ISPF, SPUFI, QMF, TSO/ISPF, IMSXPERT, DELTAPLUS, FILE- AID for IMS & DB2, MQs, GUTS, COPE, ENDEVOR, PANVALET, CHANGEMAN, TMS, CA-7, CA-1, ACF, MERVA, XPEDITOR, INTERTEST

PROFESSIONAL EXPERIENCE:

Confidential

DB2 DBA

Software: z/OS, DB2, IMS, CICS, VSAM, COBOL, Stored Procedures, IBM Utilities, CA Products - RC/QUERY, RC/MIGRATOR, RC/UPDATE, RC/SECURE, Log Analyzer, CA-Insight, CA-DETECTOR, RACF, BCV5 Database Cloning tool software, Rocket Software Shadow Servers, Embarcadero Data Model, CA-7, CA-1, SMS, Windows, Attachmate Extra

Responsibilities:

• Database objects creation / alter
• Database backups and recovery
• Performance tuning
• Analyze and correct problems that occur in the DB2 environment
• Monitor Disk space and management
• Database access requests
• Database objects maintenance - Reorgs, Runstats, Data Unloads, Loads
• Database cloning
• Package binds, rebinds
• Build databases for various new environments
• Implementing batch schedules with the appropriate DB2 utilities
• On-call support for database problems
• Resolve Incident / Service Now tickets / requests
• Provide change management and documentation for database changes

Systems Analyst

Software: z/OS, DB2, IMS, CICS, VSAM, COBOL, Stored Procedures, MQs, IBM, CA Utilities, CA-7, Windows, Attachmate Extra

Responsibilities:

• Analyze database requirements for Batch, OLTP
• Develop and execute Data Definition Language (DDL) to support projects
• Perform database backup and recovery
• Responsibility for database monitoring and tuning of database
• Responsibility for database provision and capacity planning for adequate database storage
• Provide query performance monitoring and tuning recommendations

Systems Analyst

Software: DB2, IMS, BMC Catalogue Manager, Change Manager, Mainview, IBM and CA Tools and Utilities, COBOL, CICS, JCL, VSAM, Stored Procedures, MQ Series, TSO/ISPF, SAR, CA-7, CA-1, DELTAPLUS, z/OS, UNIX, Windows

Responsibilities:

• Defined IMS Transactions, PSBs and DBD’s
• Experience on DBDGEN, PSBGEN, ACBGEN and MODBLK gen process
• Handling all database issues includes Space Management and Backup / Recoveries
• Involved in Disaster Recovery exercise
• Built IMS Message Process Regions (MPR’s) for Auto and Home Owners
• Support for IMS and CICS regions
• Monitoring IMS, CICS transactions and MQ’s
• Involved in DB2 binds
• Back filling the regions and coordination with different teams to complete the tasks.
• Request Real Time Support (RTS) team for setting up new MQ’s
• Release coordination plan

IMS DBA, DB2 DBA, ENDEVOR ADMIN

Software: IMS, DB2, CICS, COBOL, ENDEVOR, PANVALET, SAS, CLIST, COPE, DELTA IMS, GUTS Tables, RMDS, DFDSS/ABARS, CA-7, CA-1, SAR, TMS, IBM, BMC and CA Tools and Utilities, z/OS, AIX, UNIX, Windows

IMS DBA

Responsibilities:

• Defined and Created Databases, PSB’s and Transactions
• Experience on DBDGEN, PSBGEN, ACBGEN and MODBLK gen process.
• Performance Tuning, Monitoring and Maintaining IMS databases.
• Handling all database issues including Space Management and Backup / Recoveries
• Involved in Disaster Recovery exercise.
• Implemented Database structure changes, PSB changes.
• Handled request to delete the database segments using IMSXPERT.
• Experience on COPE/DELTA IMS products.
• Processed ACF access to Level-3 function odes.
• IMS v8.1 upgrade testing and standardized DBRC.
• Cost Saving measures by altered IMS Database objects to other packs to release the packs.
• Support Application releases and maintain all production utility procs, control cards and JCL.
• Coordinate with IBM to acquire and release DASD.
• Year End activities.
• Post go-live support

DB2 DBA

Responsibilities:

• Well-versed with Platinum products/ Unicenter DB2 products - RC/Query, RC/Migrator, RC/Update, RC/Secure, Batch processor, DB2 Command Processor, Utility Manager, RI Manager, IBM, BMC utilities
• Create/Alter/Drop/Recover database objects
• Monitored DB2 extents and dealt with space management issues
• Analyze access paths and tune SQL queries to improve SQL performance
• DB2 Access/Authorizations process to users
• Coordinate with IBM to acquire and release DASD
• Installation/configuration of DB2 Connect on AIX
• Support of IMS application servers on mainframe for DCE
• Involved in Performance tuning, Upgrades, Disaster Recovery support.
• Responsible for performing periodical database backup and recoveries.
• Database/ACF access process to users and Application teams
• Coordinate with IBM, &Application teams for Database, Utilities upgrade.
• 24/7 DBA and Technical Support to users and application teams.

Programmer Analyst

Software: COBOL, VSAM, CICS, JCL, MERVA, ENDEVOR

Project Support area: Foreign Exchange / Money Market

Responsibilities:

• Gap Analysis, Coding, Testing, UAT support.
• Enhancements to the existing batch programs using COBOL, VSAM and JCL
• Reviewing and Maintaining a good quality standards of deliverables.
• Involved in supporting the system, resolving the bug reported by the users.
• Abide to all quality process.

Team Lead

Software: COBOL, DB2, IMS, CICS, JCL, Endevor, Xpeditor

Project Support area: CSX - AWS

Responsibilities:

• Enhancement of the system catering to new business requirements.
• Maintenance and Production support.
• Job monitoring, monitoring of batch cycles
• Handling of job failure, long running jobs, job restart, force-ok
• Ensuring that production batch completes successfully on expected time
• Deliverable of components
• Coordination of conference call with offshore/onshore

Software Engineer

Software: MVS, COBOL, EASYTRIEVE, IMS, DB2, CICS, JCL, CHANGEMAN, XPEDITOR

Responsibilities:

• Enhancement and maintenance for the projects
• Analysis, code changes and code walk through
• Unit, Integration, System and User Acceptance Testing
• Version control the programs
• Quality Assurance and Documentation of applications software