TECHNICAL SKILLS

• z/OS, MVS,
• Cobol,
• IMS DL/1,
• SQL,
• CA Platinum Tools,
• Mainview,
• Detector for DB2,
• IMS DB monitor,
• DB2 catalog info,
• ICF catalog info,
• IMS,
• DB2,
• VSAM,
• Temp Storage,
• Transient Data,
• IMS DB,
• DB2,
• DDF,
• QMF,
• SPUFI,
• Batch,
• IMS Databases, PSBs, DBDs, ACBs and utilities,
• DB2 tables and utilities,
• VSAM/Non - VSAM files and access methods,
• FileAID,

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Provide DBA support for teh entire range of IMS platforms for production and test systems: CICS-DBCTL, BMPs, DLI Batch, ODBC access to IMS databases, IMS-DB2 access, PSBGEN, HALDB and non-HALDB full function databases in Sysplex, block level data sharing environments.
• Liaison wif Walmart DBAs, and provide direction and for two offshore IMS DBAs.
• Provided teh day to day support and administration activities of DB2/IMS subsystems across various LPARS of Z/OS mainframe systems.
• Monitoring teh REMEDY queues and resolve production and Project Issue Tracking tickets
• Monitoring teh jobs, processes and interfaces of IMS and DB2 Databases.
• Perform teh Analysis of IMS and DB2 batch job failures.
• Performed teh core DB2 administration activities viz., performing image copies of various databases, load /unload teh data to/from database, creation / rebuilding teh indexes, validating teh data, repairing teh table spaces and other related activities.
• Perform teh database sizing and performing teh online / offline REORG activities of various databases.
• Perform teh DB2 performance and tuning of DB2 Databases for all teh applications across teh Z/OS mainframe LPARS.
• Granting and Revoking DB2 object privileges to DB2 Objects across Z/OS environments.
• Perform teh DB2 bind process for various DB2 database groups across LPARS across all teh applications.
• Performance study and improvements along wif backup, recovery, REORGS, RUNSTATS, etc.
• Working on teh Project Issue Tracking Tickets that were created in teh Remedy.
• Working on teh Change Control tickets for creating new PSB or changing teh existing PSB, changes made to any of teh production modules, etc.
• Monitoring teh IMS databases and making sure that database is up all teh time.
• Solving teh Production abends when escalated to teh DBA.
• Providing PSB create and change requests as per application program requirements.
• Work on Change control for Space increase on Prod Libraries, RTT Entry, PSBGEN., etc
• Monitor teh Database status regularly during teh IPL coz of data sharing environment.
• Creation and modification of PSB’s as per teh requests posed in teh Remedy Tool.
• Run teh CNTL and IRLM commands in regular intervals in TEST region.
• Monitor teh online ACB changes in teh test environment.
• Provide 24/7 oncall support and attend teh War/Focus Rooms in case of emergency.

Environment: Z/OS, MVS, JCL, IMS V11, DB2 V9, IMS DBCTL, CICS, VSAM, COBOL, MAINVIEW, CA Platinum Tools, SPUFI, QMF, IMS DB MONITOR, BATCH, FILE-AID

Confidential, Malvern, PA,

Responsibilities:

• Performed analyses to develop/confirm new technical specifications.
• Developed COBOL DB2 code to meet teh new technical specifications.
• Developed integrated test plans, monitored jobs and reconciled all elements quarterly.
• Unit testing and Integration Testing teh Elements and creating teh Test Plan.
• Monitoring teh jobs through Control-M during teh Testing. Reconcile elements related to Centerfield project wif teh Quarter release elements.
• Maintaining and updating teh Design Description Document wif all teh new and impacted elements in e Centerfield project.
• Analysis and Coding teh New Business Request based on teh information present in teh ticket and updating teh status on teh NBR.
• Arranging teh Code review Meeting for teh modules before moving into INT.

Environment: COBOL, JCL, DB2, ENDEVOR, MFE, INSYNC, DUMP MASTER, FILE-AID, REVOLVE, CONTROL-M, VERSION MERGER.

Confidential,

Responsibilities:

• Maintained customer service and billing application for Confidential Medical Systems field engineers.
• Created iterative application enhancements, and supported users.
• Tech support for teh GIB system that controlled end-user customer views for Service, Marketing and Sales of Confidential Healthcare Technologies.
• Requirement gathering and Analyze teh enhancement, its impact and prepare Change Document, containing Application impact, Business impact, Implementation Plan, Test plan, Work estimation and Promotion plan.
• Teh crucial tasks are enhancements, supporting teh users and trouble shooting for teh issues.
• Solving of tickets logged by users in Clarify tool. Production support for functional abends.
• Providing Root-cause analysis for teh defects occurring in teh application and providing permanent fix to these defects.
• Attending change control meetings
• Testing - UAT, Integration & smoke testing
• Preparation of work packets, technical specs and test plans
• Providing Year end, quarter end & month end support for teh application.

Environment: COBOL, JCL, CICS, DB2, IMS DB, VSAM, FILE-AID, INTERTEST, PANVALET.

Confidential,

Responsibilities:

• Supported teh applications for identification cards and billing.
• Problem determination at root cause level; coding and testing of system fixes and enhancements.
• Involved in requirement analysis, Impact check, Coding, Testing and Implementation of new feature in production environment.
• Maintaining teh Enrolment information of teh users. Understanding data related issues.
• Actively involving in Peer Level Review.
• Primary contact for application issues/queries.
• Handle teh adhoc requests raised by teh user.
• Preparing Technical Specs and Testing.
• Preparing test data and unit test plan.
• Co-coordinating wif teh Testing team at teh time of Integration testing.
• Co-coordinating wif teh SME (subject matter expert) in solving teh abends and in implementing teh change requests.

Environment: COBOL, JCL, IMS, DB2, FILE-AID, VSAM, ENDEVOR.

Mainframe DBA/Developer,

Confidential,

Responsibilities:

• CICS - DBCTL, IMS/DB, DB2 and VSAM in a z/OS Sysplex environment,
• 10 years in 4 mainframe environments: Walmart, Confidential Healthcare, Vanguard Group, and Empire BCBS
• Will relocate for a career opportunity to challenge and broaden technical and business expertise.
• Responsibilities including Analysis, Development, Implementation and Testing.
• Expert level in IMS Database Administration.
• Experience in DB2 Database Administration activities.
• Extensively worked in Data Sharing mainframe environment.
• Good understanding of teh IMS DBCTL environment.
• Worked on COBOL, JCL, CICS & VSAM.
• Well experienced in IMS DBA utilities like CA Database Analyzer, Image Copy, Reorg, Database Recovery, etc.
• Experience in DB2 Utilities like Unload, Reload, Reorg, Runstats, Image Copy, Repair, Recover, etc.
• Expert understanding of teh IMS DB architecture, Database administration and security.
• Experience in monitoring and tuning a database to provide a high availability service.