PROFESSIONAL SUMMARY

• Over 10 years of experience in Information Technology with extensive experience in Installation, Migration and Configuring database, performance and tuning of DB2 operations, resolving DB2 issues, monitoring data security and integrity, assessing data models to ensure technical accuracy for DWH and OLTP systems, and supporting application development issues.
• Experience in various phases of software development including System Study, Analysis & Design, Development, Integration, Testing, Implementation, database administration, User Training and Documentation.
• Sound knowledge in MVS, OS/390, z/OS applications.
• Experience in Migrating legacy IMS database to DB2 UDB on z/Os.
• Good knowledge of DB2 Relational Connect and IBM Web Sphere Application Server.
• Installation of DB2 UDB for AIX/NT server, administration tools like control center, command line processor, script center, alert center, IBM Data Studio, IBM Optimization Service Center for DB2 for z/OS
• Have more than three year working knowledge in BMC DB2 RDBMS Suite and six years strong experience in CA PLATINUM RDBMS Suite
• Experience in application modernization from z/OS to Micro Focus Rehost.
• Expertise in Creating and changing application databases, Tablespaces, tables and indexes in DB2 UDB running on z/OS, Linux/Windows NT.
• Expertise in executing DB2 IBM Native utilities like Load, Unload, Runstats, Reorg, Copy, Modify and Spufi.
• Experience in working with large database environment with DB size more than 2 TB.
• Expertise in DB2 tools such as DB2 Connect, SQL Visual Explain, DPROP, Index Advisor, Query Optimizer, Health Monitor, Content manager, and text extenders.
• Expertise in creating database objects like views, trigger, aliases, indexes etc.
• Strong Exposure to Data Design, Data modeling, Relational database applications using client server Internet computing model and mission.
• Develop and review stored procedures for Web Enabled applications.
• Expertise in Platinum Unicenter DB2 products.
• Designs, Tests and implements database security measures consistent with the needs of the organization.
• Providing 24 x 7 Oncall Production support on rotation basis

TECHNICAL SKILLS

OS: MVS/XA, MVS/ESA, Z/OS, UNIX, AIX V 5.x/4.x, Linux, MS-DOS
DBMS: DB2 UDB V9.5/ 9.0/ 8x/ 7.x/ 6.x, ADABAS, Oracle, SQL Server, IMS/DB
Tools: DB2 Recovery Expert, DB2 Everyplace, QMF, XML Extender, BMC Catalog Manager, Mainview, BMC Patrol, SQLGUY, DB2 Connect, Data Propagator, JCL, CLIST, Endevor, Expeditor, CICS, IMS/DC, ISPF/PDF, TSO, VSAM. OPC/ESA, CA-7, CA-11, AbendAid, INTERTEST, SPUFI, QMF, PRO EDIT, PLATINUM CDB2, FILE-AID, GSAM, IDCAMS, MF-REVOLVE, MS-OFFICE, MS-PROJECT, NEON SHADOW, BMC and IBM Utilities, MQ Series, NDM, WLM, FILE-AID for DB2, OMEGAMON for DB2 Performance monitoring, CA Insight, IOF, CA View, Visual Explain, ERWIN, IBM Data Studio 2.1, IBM Optimization Service Center for DB2 for z/OS, Clear Quest
Business Intelligence Business Objects,IBM Cognos 8
App Servers: IBM WSAD V5.1/6/6.1
Hardware: RS/6000, p670, p690, IBM 370/390, OS/390, z/OS, 3270 Emulation, Windows NT
Languages: Shell Scripting, PL/1, Natural, COBOL, REXX, JCL, SQL
Web Technologies: XML, HTML, Web Sphere Application Server 5.1/6.1, Java 1.4/1.5, IBM RAD, JSP, JNDI, Java
Script, MVC Struts 1.1, Spring 2.0, Hibernate 3.0, IBM WSAD, Eclipse, Java Beans, Servlets, JDBC, Web Services, CVS, IBM E-Forms

Education

• MS(Engineering)
• BS (Engineering)

CERTIFICATIONS

• IBM Certified Database Administrator DB2 9 for z/OS
• IBM Certified Database Administrator DB2 Universal Database V8.1 for z/OS
• IBM Certified Database Administrator DB2 Universal Database V8.1 for Linux, Unix and Windows
• IBM Certified Specialist DB2 UDB V6.1/V7.1 User

Trainings

• DB2 UDB Administration for Distributed Platforms(LUW) - Themis Inc. March 2009
• Microsoft Solution Frame Work - Merrill Lynch Feb 2002
• Requirement Analysis using Rationale Tool - Merrill Lynch. Dec 2002
• TCS Corporate ITP (Initial Training Program) on Software Engineering which includes (Software Development Process, Requirement Specifications, System Design Overview, Effective Presentation, Review Walk-Through & Inspection, Testing & Debugging, Working in Teams Effectively, Database Management Systems, Object Oriented Methodology, Software Maintenance etc) Mumbai April 1999 - July 1999

PROFESSIONAL EXPERIENCE

Confidential, Denver CO Jul 2009 - Till Date
DB2 DBA for z/OS

Confidential, provides consumers fast, reliable and convenient ways to send and receive money around the world, as well as send payments and purchase money orders. It also supports C-Pay which allows the consumers to pay their utilities bills easily through Western Union systems.

Responsibilities:

• Provides DB support to the application team
• Monitors and Improves database performance.
• Designs, codes, implements and maintains database objects
• Primary 24x7 on call production support for DB related issues.
• Work with users and management to determine data storage and access requirements as well as capacity planning issues.
• Develop and implement application migration plans.
• Migrating z/OS application databases to Linux on Micro Focus rehost.
• Develop system wide policies, procedures, standards and naming conventions for the use of DB2.
• Review all applications and jobs for conformance to standards.
• Configure and connect to z/OS to generate business reports using Business Objects.
• Monitoring and Tuning the SQL that run on DB2 9 for z/OS using IBM Optimization Service Center.
• Run and interpret the DB2 Explain on SQL statements to evaluate and perform access path analysis.
• Designs, Tests and implements database security measures consistent with the needs of the organization.
• Troubleshoots database problems.
• Physical and Logical database modeling, development and Implementation of DB systems.
• Assist application programmers in evaluating the impact of access paths and physical design on performance.
• Work with QA team to develop strategies for testing purposes and help execute those strategies.
• Performance tuning of various applications and roll them to production environments.
• Monitor DB2 resource utilization using CA-Insight.
• Create and Test stored procedures using IBM Data Studio.
• Develop, evaluate and execute project plans regarding database development, modifications, upgrades and maintenance.
• Used extensively BMC Catalog Manager to create/drop DB objects, Bind/free plans, Execute SQL, prepare DDL/DCL
• Maintaining the database changes using BMC Change manager in different regions.
• Supported the Performance testing team and environment. Resolved several performance issues with suggesting efficient SQL to the developers.
• Participated with the business analyst in analyzing business requirements and designed databases to support the business requirements
• Resolve application problems when necessary.
• Maintained databases in the following regions
• Development region
• QAT
• Production
• Perform sizing requirements for all databases
• Helping application programmers tune their SQL and also giving guidance in effective use of the database features and design of new systems
• Managing database backups and when needed performing restorations and loads
• Maintaining availability and integrity of databases.

Environment
IBM/Dell O/s-Application Server, Windows XP, DB2 V8.0/9.0 for z/OS, UDB DB2 V9.0/9.5 EE/ EEE, COBOL, JCL, MVS, QMF, CICS, SPUFI, ERWIN, MS-VISIO, CA-PLATINUM, BMC Catalog Manager, Mainview, Change Manager, IBM Utilities, LINUX, SQL Server, DB2 Connect, Control Center, IBM Data Studio V 2.2, IOF, NDM, CA-7, CA-11, File-Aid, Space Finder, IBM OSC for DB2 for z/OS, Business Objects, Micro Focus Enterprise Server

Confidential, Columbus OH Nov 2004 - Jun 2009
DB2 DBA for z/OS and LUW

Confidential, is unique in the state and local governments finance and manage different health care system for people with mental illness in OH. This public system serves as a safety net, providing care for the uninsured and compensating for inadequate benefits in commercial health insurance plans. Ohio's public mental health system includes the Ohio Department of Mental Health (ODMH), 50 county and multi-county boards, and nearly 500 community mental health agencies. Patient data exists in different layers with Hospitals, Primary care centers in IMS and relational database systems. Designs and operates computer systems for community mental health information, hospital patient care data, cost accounting, reimbursement, civil service and contract personnel and related mental health data.

Responsibilities:

• Provides DB support to the application team
• Installation, Configuration and Maintenance of Database Software Systems.
• Database Design and data modeling using automated tools.
• Migrating Legacy IMS database into DB2 UDB on z/Os.
• Generating PSBs for IMS applications.
• Migrating DB2 version 7.0 to Version 8.0
• Designs, Tests and Implements a database back up strategy and disaster recovery plan.
• Loading data into IMS database from production using File-Aid for IMS.
• Supporting the application team to create IMS PSB/ACBs
• Develops and provides requested reports to management.
• Monitors and Improves database performance.
• Designs, codes, implements and maintains database objects.
• Plan and Implements Database version upgrade changes.
• Performs database Conversions.
• Developed Unix shell scripts using KORN for automatic maintenance of backup strategies.
• Develop and review stored procedures for Web Enabled applications.
• Work with users and management to determine data storage and access requirements as well as capacity planning issues.
• Maintaining multiple UDB databases that support the middle wear applications.
• Designs, Tests and implements database security measures consistent with the needs of the organization.
• Troubleshoots database problems.
• Physical and Logical database modeling, development and Implementation of DB systems.
• Provides technical support and training to the support team.
• Implemented Quality Standards using CMM guidelines
• Worked with QA team to develop strategies for testing purposes and help execute those strategies.
• Performance tuning of various applications and roll them to production environments.
• Tune and rewrite complex SQL SQL's.
• Tuned SQL's to improve performance by over 40%.
• Develop, evaluate and execute project plans regarding database development, modifications, upgrades and maintenance.
• Supported the Performance testing team and environment. Resolved several performance issues with suggesting efficient SQL to the developers.
• Participated with the business analyst in analyzing business requirements and designed databases to support the business requirements
• Collaborated with developers to devise DDL and DML, in addition to contribution of code walk-thru\'s to analyze SQL code efficiency
• Worked with system architects to design the data warehouse.
• 24x7 on call rotation support.
• Created MQT's on database for optimum performance.
• Supported ETL team , during load issues and for general testing of DataStage load process
• Creation and implementation of triggers and stored procedures to access the data from IMS.
• Creation of database / nodegroups / tablespaces and various objects.
• Optimized a long-running Java-based data file load process, to use UDB load utility and reduced the insert time by 99 %

Environment
IBM/Dell O/s-Application Server, Windows XP, DB2 V7.1/8.0 for z/os, UDB DB2 V9.0 EE/ EEE, COBOL, CICS, JCL, MVS, QMF, IMS, SPUFI, FILEAID DB2, ERWIN, PLATINUM, IBM Utilities, LINUX, Datastage, IBM Cognos 7, UDB DB2, IMS DB, SQL Server, DB2 Connect, Control Center , T-MON, File Aid for IMS, EJB, IBM WSAD, Java, JSP.

Confidential, Merrill Lynch NJ Oct 2000 - Oct 2004
Programmer Analyst Lead

Enhancements, maintenance and Production support for AM Systems.USPC-CAT (Core Application Technology) group owns Account Maintenance Systems (AM Systems), which deals with AM Core Accounts activation, Cards, Checks, Funds, Features and ATM Cards of Merrill Lynch clients worldwide. AM systems primarily responsible to maintain Asset Management Account features which includes Visa Cards, Checks, Funds, Loan, FTS, DDS. There are numerous feature and feature compositions which differentiates AM Product. AM systems interact with front end application CIS to get the data and writes into pending tables and during the batch run all the pending data copied into active table after validations.

Responsibilities:

• Managed a team of three (TCS consultants) at Merrill Lynch Pennington, NJ and co-coordinated with a team of Five (TCS offshore consultants). Work involved understanding business requirements from the users and interpreting it into technical term and sending it to offshore for development. Review of the software and final inspection before implementation in production. Has excellent track record in making defect free deliveries without any schedule slippage and effort slippage
• Visa Suppression Project Development and Implementation
• Requirement and problem analysis, preparation of Impact Analysis, Design Document and Unit test specifications
• Implemented batch and online applications using Endevor.
• Reviews and walkthroughs to make sure software has been coded as per established software quality standards and guidelines.
• Weekly System Testing of AM systems.
• Coding LE compliant VS COBOL II programs, designing CICS screens interface and embedding DB2 SQL in COBOL programs. Responsibilities also included online and batch maintenance and enhancement work using COBOL, DB2, CICS, MQSERIES, VSAM, and JCL. Used INTERTEST for debugging online applications and Expeditor for debugging batch applications. Created online applications with MQSeries for Merrill Lynch loan management application to process loan accounts as and when they are created on the system.
• Reviews and walkthroughs to make sure software has been coded as per established software quality standards and guidelines.
• Conducted end-user training sessions for exercising full use of application. Conducted and facilitated training sessions for project team members defining business functionality of AM Systems application, business requirements and user acceptance testing standards.
• Code Release from development to testing and testing to production environments (Configuration management).
• Dataset up for online users in test enviroment
• Specialized in Merrill Lynch Visa cards applications. Identified gaps in current systems and designed numerous tools for Visa customer's data management. Designed new screens to assist business users fix urgent problems in no time.
• Converted business requirements into software requirements.
• Worked with QA team and helped in creation of Test plans/ Test Scenarios/ Test Cases/Test Matrix. Documentation of Test Procedures and Test cases for user acceptance, functional and integration testing using Rational Test Manager. Defects were reported using Clear Quest and followed up with developers to discuss updates about the defect status. Facilitated meetings to gather business requirements from department managers. Facilitated meetings to gather requirements from end-users
• Created test scripts for Unit testing and system testing. Executed Unit tests.
• Data Migration & Data Conversion
• Research & analysis of critical production problems
• Performance fine tuning and monitoring production system
• Implemented changes in Development Regions based on Change Request form from App team
• Co-ordinated with CMA Priority One, Merrill Lynch Services Network, Client account services, Consumer banking group for the resolution of Critical production support issues and generated reports to drive critical business decisions
• Responsible for data population from OS/390 production database to Windows NT Model production database
• Responsible for data population from production IMS/VSAM/DB2 to Test regions
• Coding maintenance utilities in DB2 and documentation of maintenance procedures.
• Created test scripts with business requirements and tested it into the development, unit testing, system integration testing, user acceptance testing and production environments
• Monitoring and maintaning database objects for performance efficiency using OMEGAMON
• Large-scale data analysis in response to business questions
• Providing 24 x 7 Oncall Production support
• Monitored several jobs for performance check, identified bottleneck situations and fixed it
• Worked in Endevor tool for code version maintenance and build maintenance
• Developed an application for message processing using MQ Series
• Worked in Intertest Test tool for online modules and used CEDF tool for debugging the code.
• Design test cases and validated against the code changes.

Environment:
OS/390(Mainframe), Windows NT, DB2 V 7.1 for OS/390, PL1, Natural, FTP, QSAM, BMC Tool for DB2 V7.0, IMS, JCL, Intertest, VSAM, JCL, Syncsort, Visio, FILE-AID, XPEDITOR, Endevor, ISPF Edit Macros, QMF, SPUFI COBOL, CICS, Easy Trieve, MQ Series, Platinum Query Analyzer, XML.

Major Achievements:

• Saved Merrill Lynch thousands of dollars by performance tuning time consuming batch COBOL, DB2 jobs. This DB2 performance tuning has resulted in major savings because it saved numerous CPU minutes.
• Analyzed the CICS production support requirements and designed, coded and implemented numerous tools using COBOL, DB2 & CICS in production which automates majority of manual production support. Since DB2 data is fixed systematically there are no chances of data inconsistency and errors. These tools are currently being used to resolve major production problems in minutes which temporarily halted production.
• Identified time consuming manual work in the project and automated using combination of batch and CICS (online) applications which resulted is saving of enormous time in the project. As part of this initiative fixed recurring production problems which caused manual intervention and replaced it with automated tools and macros.
• Reduced the response time of re-issuing new Visa cards for high-net-worth Merrill Clients by analyzing and identifying the pieces of code already existing in production and re-using them. This in-turn reduced the development and implementation time and saved millions of dollars of possible fraud on high net-worth Merrill Client accounts.
• Taken several initiatives to improvise current legacy system design to make it better from performance perspective.e.g. Automated creations of reports for business users enabling them take critical business decisions.
• Recognized as an innovator by Merrill Lynch managers because of the ability to create new ideas to meet the most complex client needs and challenges.
• Achieved service excellence appreciations from Merrill Lynch clients, branch offices, CAS representatives, CMA Priority One managers, Merrill Lynch Service Network managers, Merrill Lynch managers(AM Core, AM Cards).

Confidential, Mumbai -India. Jul 1999 - Oct 2000
DB2 Programmer

NSDL is the first depository system in India jointly promoted by three premier financial institutions of India, namely, Unit Trust of India (UTI), Industrial Development Bank of India (IDBI) and National Stock Exchange of India Ltd. (NSEIL). This system, primarily designed to enable scriptless trading of securities consists of two major parts viz., the Depository Module and the Depository Participant Module. The Depository Module is a centrally located IBM ES/9000 system performing the core functionality while the Depository Participant Module runs on MS-SQL server on Windows NT 3.51, the two being connected through TCP/IP. This system provides electronic depository facilities for securities traded in debt as well as capital markets and wide range of securities related services such as:

Providing dematerialization and dematerialization of securities. Maintaining beneficiary holdings through depository participants. Effective book entry transfers of securities. Provide pledging and hypothecation of securities. Provide securities lending and borrowing facilities. Provide inter-depository transfers

Responsibilities:

• Maintenance of production databases, performance fine tuning and monitoring production system
• On call Production Support
• Strong attention to detail and problem solving skills.
• Ability to work within cross-functional teams.
• Creation of data migration scripts
• Involved in data setup for regression testing requirements during application releases
• Responsible for data migration from OS/390 production database to Windows NT production database
• Created Physical design and implemented it into the development, unit testing, system integration testing, conversion, user acceptance testing, pre-production, training and production environments
• Implemented changes in Development Regions based on Change Request form from App team
• Migrated Database changes and data to testing environments till production environment based on the Build. Data Migration and Data Structure Migration across different regions.
• Monitoring and maintaining database objects for performance efficiency using OMEGAMON
• Development of specifications, coding & testing of the programs.
• System testing and support during acceptance testing
• Querying production database for on line information
• Production support/ Trouble shooting
• Providing 24 x 7 on call Production support
• Did several performance fine tuning for major systems.
• Assisted application programmers in Preparing Data, Test Cases
• Worked in SAS for report management
• Worked in File-Aid for extracting data from VSAM

Environment:
OS/390, Windows NT, DB2 V 6.1 for OS/390, OMEGAMON for DB2, JCL, COBOL, REXX, CICS, JCL, MVS