Professional Experience Test Cases

Manoj Kaveri

Mainframe Technical Lead/Certified IMS DBA

E-mail: actjdv@r.postjobfree.com, Contact no.: +91-944******* Location: Bengaluru

Experience Summary

Over 9 years of Information Technology experience in Development, Production support, Testing, Systems analysis, Analysis and Design on Mainframe, and database administration environment.

I have worked with Tata Consultancy Services, IBM India Private Ltd and currently working with Hewlett Packard Enterprise, Had worked for clients likes Bank of America, Xerox and AK Steel Client. And currently working with Blue Shield California health insurance project; technical skills involve Mainframes with COBOL, JCL, and DB2 IMS DB/DC, IMS DBRC.

Excellent understanding of technical processes, knowledge of Software Development life cycle and Structured Programming Methodology.

Thorough experience on technological skills on Mainframes with COBOL, JCL, DB2 and IMS DB/DC, IMS DBRC.

Hands on experience with IMS Performance Tuning, Index Build and creating Image-Copy.

Accomplished expertise on Online Re-org, Delete/Def OSAM File HALDB Partitioning and also worked frequently on IMS Utilities –IBM, BMC, CA, and Monitoring HALDB Partition Storage Space with Pointer Checker Utilities.

Specialisations

Mainframe Specialist

Mainframe Technical Analyst

System study

Analysis of client supplied components

Preparation of Impact Analysis Document.

Requirement Analysis for enhancements/changes.

Prepare test plan, design specifications.

Creating/Modify of JCLs, PROCs, PARMs, PSB, IMS SEG, DB2 tables,PLI.

Unit testing of changed components.

System Integration Testing/Regression Testing for different markets.

Illustrate debugging and troubleshooting skills on prod.

Coding practices such as link decks, multiple versions, multiple entry points, pattern JCL, DBDS

User Acceptance Testing based on clients provided test conditions.

Rollout Activities/Package Promote, Demote

Update system Docs.

Used Microfocus Enterprise Analyzer Tool for locating dead and redundant code, to plan refactoring.

Review of System Test Results as part of EQA, IQA, and FI.

Present new methodologies and mentor other team members

IMS Database Administration

DB2 Administration

Expanding IMS Database Size.

Creating DBRC setup for production and test region

Migration of IMS BMC Utilities to IBM Utilities.

Recommending IMS Performance Tunning Suggestion to Clients.

Re-org, Image-copy, Batch-back out etc.

VSAM to OSAM Conversion.

Designing the Conversion Program for expanded database.

Monitoring IMS Database Storage.

Designing IMS Conversion Program for Expanded Database.

Migration of ARC Check-point to IBM IMS Check-point.

Logical Relationship Database Expansion.

Presenting IMS Database Arch. To clients.

Supporting Multiple IMS Projects.

Providing Training on IMS Topics.

Monitoring and execution of Imagecopy and Reorg.

Resolving the abends and resubmission of abended jobs.

Preparation of jobs for Load and Unload and its execution.

Termination of utilities and maintaining the status of databases.

Tuning of SQLs in the applications based on the recommmendations from the Explain tool.

Troubleshooting DB2 related issues such as BIND errrors,database space related errors, contention issues.

Perform DB2 DRA activities-recovery, image copy.

Perform DB2 Re-org,RUNSTATS,Image-Copy, Recovery and

Unload,Reload.

Trained and Certification:

IMS DBRC

Duration

IMS DBRC (CM20)

1 Week

IMS DBRC (CM21)

1 Week

IMS Performance Tuning (CM30)

1 Week

IMS HALDB Database (CM46)

1 Week

IMS SOA

1 Day

Certification

Paper Presentation

IMS DBA Master Certification

( Graded By IMS labs)

Presented Paper on IMS Buffer Pool Tuning in AMS Share-Net Kolkata 2010

Professional Experience

Client:

Blue Shield of California, Bangalore,India

Project Details:

RTMS Blue Shield of California

Role:

DB2/IMS DBA

Environment

IBM Utilities, BMC Utilities,CA Utilities, DB2, JCL, COBOL,, Mercury quality center, TSO, ISPF, Fileaid,, MVS, Endevor, Usecases, CA-7,

Dates:

August 2015- Till now

Responsibilities:

Maintain DB environment, Application environment, Database physical structures, Change management process, Incident Management process, Access to the system, Security access and maintenance, Job Schedules, Software tools used to support IMS database environment, Disaster Recovery, Work US work hours and Attend regular meetings with account and client

Creating DBRC setup for production and test region

Migration of IMS BMC Utilities to IBM Utilities.

Rec-org, Image-copy, Batch-back out etc.

Monitoring IMS Database Storage.

Implement and maintain production databases based on approved designs.

Create and maintain database structures for access by applications and users.

Monitor Performance and space usage for databases in production environments.

Resolve database problems.

Implement and update User access as directed by client.

Ensure database integrity and recoverability.

Perform customer problem/abend resolution & general consulting.

Troubleshooting DB2 related issues such as BIND errrors, database space related errors, contention issues.

Perform DB2 DRA activities-recovery, image copy.

Perform DB2 Re-org,RUNSTATS,Image-Copy, Recovery.

Provide 24x7 oncall support.

Support upgrades and patching.

Consult and direct application teams in support of upgrades.

Participate in disaster recovery drills (no more than two per calendar year).

Restore/repair databases.

Create and maintain application data base disaster recovery plans.

Create or maintain database-related application documentation.

Recommend IMS enhancements, features or software that will enable more efficient support or cost savings to client.

Experience using IBM and CA Tools and utilities

HP EON, HP eNOTE, Service Manager.

Other Professional Experience

Client:

AKSteel, U.S.A

Project Details:

AKSteel AMS

Role:

Mainframe Team Lead

Environment

Cobol, DB2, IMS DB/DC, JCL, Mercury quality center, TSO, ISPF, Fileaid, SQL, QMF, SPUFI, DB2 Connect, Stored Procedures, CA7, Xpediter, VSAM, VISGEN. Microfocus Enterprise Analyzer Tool

Dates:

June 2011- July 2015

Responsibilities:

Developed and Installed JCL to run COBOL, DB2 and IMS programs .

Created Job, PROCS, and Control Cards in Test and production environment

Developing, Analyzing and Enhancing programs using COBOL, JCL, CICS DB2,IMS.

Experienced in using SPUFI tool for executing queries in DB2

Experienced in using IBM Utilities for getting the usages as per the BSD’s requirements for further testing

Worked on Easytrieve tool for browsing, editing, allocating, comparing and extracting the usages with different scenarios for processing.

Experienced in creating PCB’s and PSB’s for IMS database.

Strong debugging and troubleshooting skills

All executable statements must be tested using EXPEDITOR, expected results documented

Experienced in working with REXX tool for creating JCL's and for weekly and monthly recurring jobs

Participated in system requirements and design, developed programs, and testing

Worked on IMS,DB2 production databases using File-Aid IMS, DB2

Used File-Aid, Batch SPUFI, Online SPUFI and QMF for SQL Queries

Gathering and analyzing business requirements, translated into functional requirements to create technical design.

Reload of DB2 databases and tables with different data capture and unloads.

Worked on SDSF for viewing the status of the batch jobs .

Performed Business analysis and created specs for business applications

Preparing Use Case Specification Document and Software Architecture Document for AKSteel project

Participate in workflow walkthroughs, peer reviews and team meetings

Coordinate and execute quality assurance against Usecase requirements and specifications

Coordinated the meetings with the development groups and database groups

Developed Test Plan, Test Cases based on Usecase requirements

Developed and Executed Positive and Negative Test cases for unit testing.

Other Professional Experience

Client:

Xerox, U.S.A

Project Details:

Expanding IMS Database

Role:

IMS DBA/ Team Lead

Environment:

IBM Utilities, BMC Utilities,CA Utilities, DB2, JCL, COBOL, CICS, Mercury quality center, TSO, ISPF, Fileaid, QMF, SPUFI, SQL, MVS, Endevor, Usecases, CA-7, Eztrieve, Microfocus Enterprise Analyzer Too

Dates:

February 2010 – June 2011

Responsibilities:

Expanding IMS Database Size.

Creating DBRC setup for production and test region

Migration of IMS BMC Utilities to IBM Utilities.

Recommending IMS Performance Tunning Suggestion to Clients.

Rec-org, Image-copy, Batch-back out etc.

Monitoring IMS Database Storage.

Designing IMS Conversion Program for Expanded Database.

Migration of ARC Check-point to IBM IMS Check-point.

Logical Relationship Database Expansion.

Strong debugging and troubleshooting skills

Coding practices such as link decks, multiple versions, multiple entry points, pattern JCL, DBDS

Presenting IMS Database Arch. To clients.

Strong debugging and troubleshooting skills

Coding practices such as link decks, multiple versions, multiple entry points, pattern JCL, DBDS

Supporting Multiple IMS Projects.

Providing Training on IMS Topics.

Reduce application outage due to routine database reorganization, and RECON reconfiguration to allow IMS systems to potentially run continuously without the need for a weekly outage.

IMS Data Base Administrator responsible for the integrity and performance of the IMS and DB2 systems in production and test environments .Implemented production database and utility changes. Handled developer requests of IMS and DB2 databases.

Other Professional Experience

Client:

Bank of America, U.S.A

Project Details:

Global Wealth Management-PACE.

Role:

Mainframe Technical Analyst

Environment:

JCL's, ISPF, TSO, QMF, MVS, DB2, IMS DB/DC, SQL, Cobol, mainframe utilities, Platinum, Test Director, Xpediter, Changeman, CA7, Mercator, Fileaid, Synchsort, Visio, JAVA, CICS, JES, Abendaid, SDSF, Microfocus Enterprise Analyzer Too

Date:

March 2007 – Feb 2010

Responsibilities:

System study

Analysis of client supplied components

Preparation and maintenance of Project related documents

Requirement Analysis for enhancements/changes using REVINE

Performed coding, testing and implementation for upgrade conversion of Omni Plus retirement recordkeeping system from version 5.02 to version 5.20 using Micro Focus Mainframe Express as the primary debugging and development tool.

Performed extensive enhancements, maintenance and production support for Omni Plus 5.20 retirement recordkeeping system using COBOL II and CICS and VSAM and DB2 including the addition and maintenance of numerous mainframe-AS and 400 trading interfaces which also involve the use of DB2 tables. Also created and maintained numerous fee and balance calculation programs. Micro Focus Mainframe Express was the primary debugging and development tool used for these tasks

Prepare design, design specifications & update IRIS with revised estimates and schedule

Creating of JCLs, PROCs, PARMs and Loads for banking application.

Strong debugging and troubleshooting skills

Coding practices such as link decks, multiple versions, multiple entry points, pattern JCL, DBDS

Involved in Testing, System Analysis, Business Analysis

Developed and modified Copybooks, JCLs and Procedures

Performed unit testing, system testing and integration testing of all lines of businesses

Strong debugging and troubleshooting skills

Coding practices such as link decks, multiple versions, multiple entry points, pattern JCL, DBDS

Developing Master test plan, test data inputs Scenarios, test cases, and test scripts for test cases to cover all requirements and business Scenarios.

Extensively worked on SQL queries for back end testing

Coordinated with the DBA’s to resolve the defects

Utilized Test Director to enter the defects in testing

Analyzed and validated the test results both in front end and back end through the reports .

Update system Documentation

Review of System Test Results

Code review by the tool ASSENT Ensure the standardization of the code using ASA

Demand Management Initiatives

Conduct Quality reviews of Test plans by using IPMS to carry out EQA, IQA, FI

Collect various metrics on process and product quality and update the same in IRIS

Highlight :

Bank of America, one of the leading banks in the United States provides financial products, services, ideas and solutions to customers and clients in over 48 states, the District of Columbia and 38 countries around the world. It has $621 billion in total assets, including loans and leases totalling $329 billion at year-end 2001. The bank has four main business segments, viz. Consumer Banking, Commercial Banking, Global Corporate and Investment Banking and Asset Management.

Contact this candidate