Professional Summary:

• Having 14 years of IT experience in Mainframe and DB2 DBA experience in Analysis, Development, testing and implementation of IBM Mainframe projects.
• Database Administration in DB2 on Z/OS and OS/390 Mainframe.
• Extensive experience in Database design, Analysis, developing physical database, production implementation and support.
• Extensively worked on DB2V8.1, DB2V7.1 and good exposure in DB2V9.1
• Good experience in Catalog Manager for DB2, DASD Manager Plus for DB2, Change Manager for DB2, Recovery Manager and utilities like COPY, LOAD, UNLOAD, CHECK DATA, QUIESCE, RECOVER, REPAIR REORG, RUNSTATS, MODIFY etc.
• Good hands on experience in OMEGAMON for DB2, DETECTOR, XPEDITOR, File-Aid's, SPUFI, and QMF.
• Wide experience in implementing Backup and Recovery Strategies.
• Performance Tuning of DB2 on Z/OS and OS/390 systems, responsible for Performance Monitoring, database maintaining activities, data loading, unloading, recovery, refresh test database and tuning complex SQL queries with Plan table and DB2 Explain.
• Proficient in COBOL, JCL, DB2, IDMS, VSAM and CICS and has also worked on tools like XPEDITOR, INTERTEST.
• Good Team Player having strong analytical and problem solving skills with excellent written, verbal and interpersonal communication skills.

Technical Skills:

• OS : IBM OS/390, Z/OS, WINDOWS NT/XP, UNIX
• Language : VS COBOL II, JCL, SQL, Rexx, PL/I, EASYTRIEVE
• DB2 Utilities : IBM Load, Check, Copy, Runstats, Recover, Reorg, Quiesce, Modify and restore, BMC Utilities LoadPlus,
• UnloadPlus, ReorgPlus, CopyPlus, BMCSTATS etc
• DB2 Tools : SPUFI, QMF, Admin Tool, DASD Manager, Catalog Manager, Change Manager, FILE-AID for DB2,
• OMEGAMON for DB2, RC- UPDATE for DB2.
• Others : TSO/ISPF, VSAM, IDMS, IMS-DB, SAS, JES2, CICS
• Mainframe Tools : EXPEDITER, ABEND-AID, VIASOFT, ENDEVOR, CA-7,
• CHANGEMAN, CICSPLEX, FILE AID, CA-LIBRARIAN, SCLM,
• SYNC SORT, SDF, IDCAMS.

Work Summary:

DB2 DBA Application Support Confidential

• Department of health and mental hygiene DHMH has three major divisions - Public Health Services, Behavioral Health and Disabilities, and Health Care Financing serves.
• Public Health Services Division oversees vital public services to Maryland residents including infectious disease and environmental health concerns, family health services and emergency preparedness and response activities. The Behavioral Health and Disabilities Division focuses on assisting Maryland residents who have developmental disabilities, mental illnesses and dependency on alcohol and drugs. The Health Care Financing Division implements the Medicaid program, which features the department's HealthChoice and Children's Health Program along with other initiatives, including those that help people with the cost of prescription medications

Responsibilities:

• DBA for Applications consists of 9 production databases, 9 System and UAT databases and 10 Development/test in 4 LPARs.
• DBA for Emedicaid system which is running on windows.
• Responsible for Production support/maintenance and consulting of large DB2 data based application ion Z/OS platform.
• Monitoring the production batch cycles, resolved various abends, ensure smooth execution of the production batch cycles and availability of the databases.
• Responsible for backup, restore of production and test databases, table spaces.
• Developed routines for disaster recovery.
• Data maintenance activities like REORG, RUNSTATS, Quiesce and recover of different database objects.
• Design and implemented different utility modules of Load, Unload, Copy, Reorg and Runstats Process.
• Worked as project DBA for various projects, assisting Application teams for new programs using embedded SQL's. Created and maintained new tables, generated different business related reports etc
• Involved in problem management activities and resolving critical problem tickets.

Environment : DB2V8.X on Z/OS,DB2V9 on LUW, IBM DB2 Admin Tools, File-aid for DB2, Omegamon, QMF, SPUFI, TSO-ISPF, JCL, VSAM, File-aid for VSAM, Xpediter, Strobe.

DB2 DBA Application Support in Z/OS -

Confidential

UPS is one of the largest logistics company has numerous applications running in Z/OS and OS/390. Working in the DBA team for their package tracking applications.

Responsibilities:

• DBA for Applications consists of 5 production databases, 6 QA and 10 Development/test in 4 LPARs.
• Responsible for Production support/maintenance and consulting of large DB2 data based application ion Z/OS platform.
• Monitoring the production batch cycles, resolved various abends, ensure smooth execution of the production batch cycles and availability of the databases.
• Responsible for backup, restore of production and test databases, table spaces.
• Developed routines for disaster recovery.
• Data maintenance activities like REORG, RUNSTATS, Quiesce and recover of different database objects.
• Design and implemented different utility modules of Load, Unload, Copy, Reorg and Runstats Process.
• Worked as project DBA for various projects, assisting Application teams for new programs using embedded SQL's. Created and maintained new tables, generated different business related reports etc
• Involved in problem management activities and resolving critical problem tickets.
• Environment : DB2V8.X DB2V9.X on Z/OS, BMC Tools, IBM DB2 Admin Tools, CA-7,
• RC-Update for DB2, Detector, Changeman, QMF, SPUFI, TSO-ISPF,
• JCL, VSAM, File-aid for VSAM, Xpediter, Strobe.

DB2 DBA Application Support

Confidential

• CVS, one of the biggest pharmacy retailers, has different applications running on
• OS/390. Was working as a DBA for their claims processing system.

Responsibilities:

• Responsible for Production support/maintenance and consulting of large DB2 data based application ion Z/OS platform.
• Monitoring the production batch cycles, resolved various abends, ensure smooth execution of the production batch cycles and availability of the databases.
• Responsible for backup, restore of production and test databases, table spaces.
• Data maintenance activities like REORG, RUNSTATS, Quiesce and recover of different database objects.
• Design and implemented different utility modules of Load, Unload, Copy, Reorg and Runstats Process.
• Migrated Database Schemas and data from one test environment to another and eventually into production.
• Performance tuning and monitoring for DB2 databases.
• Worked as project DBA for various projects, assisting Application teams for new programs using embedded SQL's. Created and maintained new tables, generated different business related reports etc.

Environment : DB2V8.X on OS/390, BMC Tools, IBM DB2 Admin Tools, CA-7, Detector, Endevor, QMF, SPUFI, TSO-ISPF, JCL, VSAM, File-aid for VSAM, and DB2, Xpediter.

DB2 DBA Mid Level Confidential

• GSI Commerce is a leading provider of outsourced e-commerce solutions for
• approximately 50 partners. By partnering with GSI Commerce, companies can grow
• their e-commerce businesses more quickly and more cost-effectively than they
• could on their own.
• Technology and Information Services TIS is responsible for product development, product management and production support.

Responsibilities:

• Responsible for Production support/maintenance and consulting of large DB2 data based application ion Z/OS platform.
• Monitoring the production batch cycles, resolved various abends, ensure smooth execution of the production batch cycles and availability of the databases.
• Review and implement table changes in Test, Integration and Production regions.
• Responsible for backup, restore of production and test databases, table spaces.
• Data maintenance activities like REORG, RUNSTATS, Quiesce and recover of different database objects.
• Design and implemented different utility modules of Load, Unload, Copy, Reorg and Runstats Process.
• Involved in Performance and Tuning of Complex SQL Statements.

Environment : DB2V7.X on OS/390, BMC Tools, IBM DB2 Admin Tools, CA-7, Detector, Endevor, QMF, SPUFI, TSO-ISPF, JCL, VSAM, File-aid for VSAM,

and DB2, Xpediter.

Tech Lead Confidential

The Common Ledger System - Financial Data Warehouse CLS-FDW is the single application used by all IBM systems around the world. The system ran in four different processing locations Portsmouth UK , Poughkeepsie US , Tokyo Japan , and Sydney Australia . Several of these installations were partitioned into separate 'clones' for processing groups of countries independently for improved performance. CLS-FDW included functions to support revenue/cost matching and accruing, and contract accounting. Only a subset of the countries is using these functions currently the others continue to use local functions or queries to meet requirements.

Responsibilities:

• As a Tech Lead, responsible for
• Project Management
• Performing analysis as per the client requirement.
• Preparing High Level design and Low Level design documents.
• Preparing Logical Database design, Interacting with DBA's to setup the Databases.
• Data maintenance activities like REORG, RUNSTATS, Quiesce and recover of different database objects.
• Design and implemented different utility modules of Load, Unload, Copy, Reorg and Runstats Process.
• Involved in Monitoring the production batch cycles, resolved various abends.

Environment : DB2V7.X on OS/390, BMC Tools, IBM DB2 Admin Tools, CA-7, Detector, Endevor, QMF, SPUFI, TSO-ISPF, JCL, VSAM, File-aid for VSAM,

and DB2, Xpediter.

Tech Lead Confidential

• BHW Bausparkasse AG, one of the leading Home finance and insurance company in Germany has 70 of its applications in mainframes. The applications run in IDMS and DB2 databases.
• This project was aimed at integrating an existing OS/390 application named as Business Partner module with SAP using MQSI as a middle ware. MSB MVS-SAP BRIDGE was used as an interface in this project. Mapping functions and copybooks, creating queues and maintaining data-flows were done using MQSI V2.1. Deploying them and testing them for proper functioning were also performed.
• Along with this work, Maintenance of a part of BHW insurance modules was also undertaken. These Insurance modules had around 42 jobs, which include daily, weekly, monthly, quarterly and yearly jobs.

Responsibilities:

Project Management

• Effort Estimation, Cost management
• Mapping copybooks, Creating main flow, sub flows and queues
• Testing for proper Data Transfer, Abend solving , Adhoc reports generations
• Quality Reviews Internal, Team Management
• Onsite-offshore Coordination
• Client Communication, Acceptance Testing
• Quality Review.

Environment : TSO/ISPF, VS COBOL II, IDMS, DB2 Stored Procedures, CICS, JCL, VSAM, CA-LIBRARIAN, ENDEVOR, EXPEDITOR, FILEAID FOR DB2, SAS, MQSI V2.1, MQJEXPLORER V0.13,

Tech Lead Confidential

• Lexis is a LAN and Mainframe system, which provides policy booking and issuance for Lexington Business. It had 267 users at 22 locations and was implemented in 1986. This system had Visual Basic, Windows for C windows for data in their front end and VS COBOL II, DB2, JCL at the back end. Apart from this there were many CICS maps also.
• Lexis had 25 jobs that run on daily, monthly, quarterly and annual basis. This system also had some Ad hoc report generating jobs. The project aimed at maintaining all these jobs. The offshore team handled issues like ABEND solving, Job scheduling and sending reports. Enhancement was done on both front end and back end, depending upon the client requirements and user requirements.

Responsibilities:

• Performing analysis as per the client requirement.
• Preparing High Level design and Low Level design documents.
• Preparing Functional Specification details, Technical documents.
• Managing team members, monitoring Work flow
• Project Management activities, Quality related works
• Testing, debugging and report Generation.
• In charge of the Back end system

Environment : TSO/ISPF, VS COBOLII, EASYTRIEVE, DB2, CICS, VSAM, IDMS, JCL, ENDEVOR, CA-LIBRARIAN, EXPEDITOR, VISUAL BASIC 5.0, NDM, FILEAID FOR DB2 and CA-INTERTEST.

Tech Lead Confidential

• The Sales Mortgage System SMS maintains lessees' and loan information of sold properties such as HDB and HUDC flats. Some of the main functions were:
• Process property information updates with regard to accounts creation and updates.
• Update and maintain lessees' and loan information
• Provide online enquiry and updating of lessees' and financial information to Branch Office, Sales Unit, Resale Unit and HAD.
• Process account balancing Process final payment of loan
• Process financial balancing to ensure the monthly balances are in order generate monthly financial reports. Generate reports for management and statistical purposes.
• There were 28 internal Systems Interfaces and one external interface to CPF board. All these were interfaced among themselves. This project aimed at analyzing, designing and developing new systems as per the client requirement and also aimed at maintaining the existing system.

Responsibilities:

• Analyzing and providing solutions to production problems related to system.
• Preparing function specification documents and High Level design documents for coding.
• Developing online and batch programs in VS COBOL II and PL/I
• Maintaining and testing online and batch programs
• Provide assistance during user testing.

Environment : MVS, TSO/ISPF, VS COBOL II, CICS, DB2, VSAM, JCL, SAS, PL/I, ASP, XML, HTML, JavaScript, ENDEVOR, Expeditor, CA-Intertest, Visual Interdev

Module Lead Confidential

This particular project aimed to modernize the New Business System NBS , by adding functionality for SVUL Survival variable Universal Life product. In the ongoing Enhancements for Term Elite Term Lite products, Stream Unification changes were included. However due to changed priorities, Stream Unification changes were done as part of this project also. Both IMS and DB2 databases were available in this project. Numbers of IMS calls were coded. Testing was done and various quality measures were checked through out the life cycle of the project.

Responsibility:

• Performing Current State Analysis to determine requirements
• Creation of Functional Specifications Document
• Preparation of unit Test Plans
• Code construction for both COBOL/DB2/CICS COBOL/IMS type programs.
• Unit Testing, Preparation of reports, Monitoring Team activities

Environment : TSO/ISPF, VS COBOL II, CICS, DB2, JCL, VSAM, REXX, ENDEVOR, Expeditor