Sesha Mandla

210-***-**** (Cell)

abhj6l@r.postjobfree.com

Professional Summary

. More than 10 yrs of Professional experience in analysis, design,

development, Testing, Implementation and Production Support.

. Over 4 years of experience in Quality Assurance Methodologies and

Testing.

. Expertise in COBOL,MF Cobol, PL/1,NATURAL,Pacbase, DB2, ADABAS,

IMSDB/DC, JCL, CICS, EASYTRIVE, MQ Series, IBM Optim,MQT, HDC & Web

Services

. Experience developing Test Plans, Test Cases, Test Data.

. Very good experience working with Onsite/Offshore Model as a Lead

Analyst.

. Extensively worked on manual testing and Expertise in White Box and

Black Box Testing.

. Working experience on HP Quality Center (QC) and proficient with

System Testing on IBM Mainframe and Client/Server Applications.

. Very Good working experience using IBM Optim to browse the Data, Join

& Compare data from DB2 tables.

. Very good working experience working on IBM Optim to Archive the data,

Reload the Data & Purge the Data.

. Proven experience in project and team leading with zero defect

delivery. Equally comfortable working independently as well as in a

team environment.

. Very good experience on Batch Processing and Production Support.

. Good exposure on evaluation of Insurance, Banking, Telecom &

Manufacture domain applications.

. Expertise in Requirement gathering and Design document preparation.

. Proficient in creating Test Plans and Test scenarios.

. Involved in all phases of SDLC.

. Implemented large-scale and small projects as a Lead Analyst also

supported delivery of projects as a primary support.

. Developed Project Schedule as an Onsite Project Lead. Supervises and

coordinates projects and track progress of projects and also providing

timely and accurate project progress reports to management.

. Excellent working relationship with Customer.

. Adhering to the quality standards of both Customer and Employer.

. Expertise in SPUFI, QMF, FILEAID, DATAVANTAGE, IBM Optim's as testing

tools and for data manipulation and Data cleaning.

. Proficient in IBM utilities and Tools like CNTL-M, XPEDITER, BTS, SCM,

ENDEAVOR, PANVALET, ELIPS, SYNC SORT, FILEAID FOR DB2/IMS.

. Very Good working experience on ZEKE & CA7 schedulers.

. Lead a System Testing team and well experience in writing test cases,

review and testing of the applications on IBM mainframe and

Client/Server Technologies.

. Excellent technical and analytical problem solving skills.

. Outstanding communication, interpersonal and presentation skills.

. Organized and hardworking

. IBM Certified Professional on DB2.

. Brain Bench Certified Professional on NATURAL.

Technical Skills

Programming COBOL, MF Cobol, NATURAL, Pacbase, PL/1, JCL,

Languages EASYTRIVE

Web Technologies MQ Series, Web Services

Database DB2, IMS DB, ADABAS

Configuration ENDEVOR,SCM,SDLM

Management Tools

Operating Systems MVS/ESA, OS/390, Z/OS

Tools IBM Optim,TELON,FILE-AID, XPEDITOR,

PANVALET,ELIPS,CA7,ZEKE

Hardware IBM ES-9000, IBM S/390, IBM 3270

Utilities ISPF/PDF, TSO/E, SPUFI, QMF, BMC, PEEK,MQT, Data

Vantage for IMS

OLTP CICS, TRANSFORM(IMS DC)

Miscellaneous HP Quality Center, STAR TEAM, Remedy, Share Point

Professional Work Experience

Project 1:-

Claims Cycle Time Analytics - USAA, San Antonio August

2010 to till date

Technical/QA Lead

United Services Automobile Association (USAA) is one of the leading

Insurance, Banking and Investment Company founded by military personal to

serve military personal and their family members. The purpose of this

project is, the claims business doesn't have access to reliable data for

key claims cycle times. Cycle times have proven to be a key metric to

measure and improve not only business efficiency, but member satisfaction.

A cycle time is duration between two events on a claim. "First Notice of

Loss" and "Claim Close" are two separate "events" during a claim. To

accomplish this requirement there are many claims operational sources that

need to be acquired and integrated. This project will acquire those sources

and load them into the Data warehouse. This project is linked with a

second, interdependent project that will, create critical path cycle time

dashboards and related analytics, also provide additional reporting on the

critical path events.

Responsibilities:

. Worked closely with Business Analysts to gather the requirements by

interacting with Business users.

. Participating in the requirements review meeting to review and refine

requirements gathered in the pre work.

. Provided estimates for each task and also prioritized the tasks

accordingly.

. Coordinating with Offshore team and Business users.

. Allocation of task to team members.

. Ensured that all the tasks are reviewed.

. Ensured that all tasks are properly tracked to closure and delivered

as per schedule.

. Ensured that all the tasks delivered from offshore are of good quality

and had gone thorough testing and does not impact any of the existing

business process.

. Ensured that all the tasks adhere to the process defined.

. Extended help to all team members in case of any issues and provided

the necessary technical assistance.

. Preparing the analysis and design documents by analyzing the business

requirements.

. Created High level test cases and high level scenarios for each task

in Quality center.

. Mentored Offshore Team for developing Test cases and preparing Test

Data

. Created Traceability between Requirements and Test Cases in Quality

Center

. Developed the new programs, to extract the data from DB2 / IMS

database using COBOL & Easytrieve.

. Using IBM Optim to browse the Data, Join & Compare data from DB2

tables.

. To test the various scenarios, using IBM Optim to Archive the data,

Reload the Data & Purge the Data.

. Creating new jobs using JCL.

. Preparing the Unit / Integration Test Plans, conducting the Unit /

Integration Testing and capture the Test results.

. Took part in all the client meetings, weekly status meetings with

onsite and offshore.

. Provided timely and accurate project progress reports to track and fix

any deviations from the project schedule.

. Performed system testing support as well as Production rollouts as per

the agreed schedule with the client IT team as well as Business team.

Environment: COBOL, EZYTRIEVE JCL, DB2, IMS DB, SCM, ELIPS, IBM's Optim,

SPUFI, QMF, Data Vantage for IMS, Borland Star Team, MS Office

SharePoint,Mercury Quality Center & Informatica Power Center.

Project 2:-

Property Insurance - USAA, San Antonio June 2007 to July

2010

Technical / QA Lead

United Services Automobile Association (USAA) is one of the leading

Insurance, Banking and Investment Company founded by military personal to

serve military personal and their family members. The project constituted

building a web front end for the legacy mainframe property application.

This was done for different lines of business. The conversion of valuable

personal property has been completed by our team. Also in the current

environment user is not able to complete the mortgagee selection within the

.com application. We have provided the capability to search and select

mortgagee information with the flow of the Homeowners .com application.

This feature allows the user to complete the issue process themselves on

.com. The property business does not have access to reliable data to know

how many transactions are done for the given period of time. The

infrastructure provided in this effort, acquire detailed analytical data to

be used to create dashboards. The property business service team also

provided MSR and member's access to the simplified Homeowner and Renters

products. The simplified property insurance programs primary benefit is the

upgrading of the property legacy underwriting and pricing infrastructure

with more robust and agile platforms. The infrastructure provided in this

effort, enables the development of a sophisticated pricing model and

improved risk assessment tools for the new simplified Homeowners and

Renters products.

Responsibilities:

. Worked closely with Business Analysts to gather the requirements by

interacting with Business users.

. Participating in the requirements review meeting to review and refine

requirements gathered in the pre work.

. Provided estimates for each task and also prioritized the tasks

accordingly.

. Coordinating with Offshore team and Business users.

. Being a Technical Lead and Test Lead at Onsite, I was responsible for

managing the development team and testing team.

. Allocation of task to team members.

. Ensured that all the tasks are reviewed.

. Ensured that all tasks are properly tracked to closure and delivered

as per schedule.

. Ensured that all the tasks delivered from offshore are of good quality

and had gone thorough testing and does not impact any of the existing

business process.

. Ensured that all the tasks adhere to the process defined.

. Extended help to all team members in case of any issues and provided

the necessary technical assistance.

. Preparing the analysis and design documents by analyzing the business

requirements.

. Enhancement of the existing system by customizing the code as per user

requirements.

. Created High level test cases and high level scenarios for each task

in Quality center.

. Mentored Offshore Team for developing Test cases and preparing Test

Data

. Created Traceability between Requirements and Test Cases in Quality

Center

. Developed the new programs using COBOL,PL/1,IMS DB /DC,DB2,Easytrieve

& JCL.

. Using IBM Optim to browse the Data, Join & Compare data from DB2

tables.

. To test the various scenarios, using IBM Optim to Archive the data,

Reload the Data & Purge the Data.

. Good exposure on Data Masking using IBM Optim.

. Preparing the Unit / Integration Test Plans and System Test Plans,

conducting the Unit / Integration Testing and System Testing and

capture the Test results.

. Took part in all the client meetings, weekly status meetings with

onsite and offshore.

. Provided timely and accurate project progress reports to track and fix

any deviations from the project schedule.

. Performed system testing support as well as Production rollouts as per

the agreed schedule with the client IT team as well as Business team.

Environment: PL/1, COBOL,MF Cobol,JCL, TSO/ISPF, DB2, IMS

DB/DC,EZYTRIEVE,SCM, ELIPS, IBM's Optim, Data Vantage for IMS, SPUFI, QMF,

BTS Testing, Borland Star Team, MS Office SharePoint & Mercury Quality

Center.

Project 3:-

OTTP - Pitney Bowes, Stamford

October 2006 - June 2007

Technical / Onsite Lead

Pitney Bowes has manufacturing and leasing of postage meters, Xerox

machines, fax machines and other office automation. Pitney Bowes sells

different Products. Pitney Bowes is now offering Purchase Power options to

their customers. Purchase Power is an account that allows you buy now and

pay later for postage, supplies, and other purchases.

Responsibilities:

. Analyzing the business requirements for the OTPP (Other Transaction

Purchase Power)

. Preparing the estimates for the project

. Coordinating with Offshore team and Business users.

. Allocation of task to team members

. Ensured that all the tasks are reviewed

. Ensured that all the tasks are properly tracked to closure and

delivered as per schedule.

. Ensured that all the tasks are delivered from offshore are of good

quality and had gone through

testing and does not impact any of the existing business process.

. Preparing the analysis and design documents by analyzing the business

requirements.

. Developed the new programs

. Analyzed Pacbase programs to re write and documented the Business

rules.

. Developed New programs from Pacbase to COBOL as per the business

requirements.

. Derive the Test Plan / Test Cases.

. Prepared test data with proper data to perform various scenarios.

. Reviews code to find causes of errors and revises programs

. Preparing the System Test Cases and conducting the System Testing.

. Supporting the User Acceptance Testing.

. Providing timely and accurate project progress reports to track and

fix any deviations from the project schedule.

. Providing the necessary technical assistance to the offshore team when

needed.

Environment: COBOL II, Pacbase,JCL, TSO/ISPF, DB2, IMS DB/DC, TRANSFORM,

DCLGEN, ENDEVOR, EZYTRIEVE,PANVALET, FILE AID,QMF.

Project 4:-

Pitney Bowes, Stamford

November 2004 - October 2006

Technical Member

Pitney Bowes has manufacturing and leasing of postage meters, Xerox

machines, fax machines and other office automation. Pitney Bowes sells

different Products. These products require maintenance with respect to part

replacements. One of the module in the PB is OTC. The primary role is to

support OTC. Whose main functionality involves the processes that affect

customers, from the time an order is taken until receipt of payment. OTC

includes 30 different applications. The major applications are Order Entry,

Billing, Invoice generator & Accounts receivables (A/R).

Responsibilities:

. Preparing the analysis and design documents by analyzing the business

requirements

. Provided estimates for each task and also prioritized the tasks

accordingly

. Interacting with customers as per project requirements.

. Enhancement of the existing system by customizing the code as per user

requirements.

. Analyzed Pacbase programs to re write and documented the Business

rules.

. Developed New programs from Pacbase to COBOL as per the business

requirements.

. Preparing the Unit / Integration Test plan,testing the application and

capture the Test results.

. Preparing the System Test cases and conducting the System testing.

. Supporting the User Acceptance Testing.

. Problem solving on existing modules.

. Providing the necessary technical assistance to the other developers

when needed.

. Documenting the Issue Logs and Updating the System Change Document for

future reference.

Environment: COBOL II,Pacbase, JCL, TSO/ISPF, DB2, IMS DB/DC, TRANSFORM,

DCLGEN, ENDEVOR, EZYTRIEVE,PANVALET, FILE AID,QMF.

Project 5:-

JPMorgan Chase, Bournemouth,UK

December 2002 - Oct 2004

Technical Member

JPMorgan is one of the world's leading investment banks, provides a full

range of investment banking and commercial banking products and services.

It has its head quarters located in New York and its branches spread across

different parts of the world. The Shared Technology Operations, referred to

as STO, is the Technology and Operations wing of the JPMC. STO has been

developing several applications under which Cash Management is one of the

applications.Cash Management system is one of the critical systems in JPMC.

This helps the international treasury to fund its money in the Nostro

account. Cash Management consists of four systems CMPS, CMWS, CMRec and

CORS. These are the set of systems that helps users to see the predicted

position of the Nostro account. Gets it reconciled at the end of the day

and sends the errors across. Responsibilities:

. Problem solving on existing modules.

. Preparing the analysis and design documents by analyzing the business

requirements

. Coordinating with customers as per project requirements.

. Enhancement of the existing system by customizing the code as per user

requirements.

. Preparing the Unit / Integration Test plan,testing the application and

capture the Test results.

. Preparing the System Test cases and conducting the System testing.

. Supporting the User Acceptance Testing.

. Documenting the Issue Logs and Updating the System Change Document for

future reference.

Environment: NATURAL, ADABAS,JCL, TSO/ISPF, SDLM,PEEK.

Project 6:-

AT&T, New Jerssy January 2000

- November 2002

Technical Member

AT&T is the world's finest purveyor of voice, video and data

communications, which runs the largest, most sophisticated communications

network. They are the leading supplier of data and Internet services and

offers telecom outsourcing, consulting and network-integration to large

businesses. Today, AT&T is rapidly evolving from a company that handles

mostly long-distance voice calls to a company that provides data and voice

communications over any distance through its two operating units, AT&T

Business and AT&T Consumer. One of the modules in AT&T is AP(Account

Processing).The primary role was to support AP, whose main functionality

was to do provisioning and processing of new orders and existing orders. AP

gets millions of order information from internal & external Systems of

AT&T. They are passed through a series of treatment cycle and validate and

updated in Database

Responsibilities:

. Problem solving on existing modules.

. Preparing the analysis and design documents by analyzing the business

requirements

. Coordinating with customers as per project requirements.

. Enhancement of the existing system by customizing the code as per user

requirements.

. Preparing the Unit / Integration Test plan, testing the application

and capture the Test results.

. Preparing the System Test cases and conducting the System testing.

. Supporting the User Acceptance Testing.

. Worked as a Data Specialist.

Contact this candidate