Supply Chain Quality Assurance

O BJECT I V E

To pursue a progressive career in a Business IT environment, capitalizing on acquired skills

and personal traits pertaining to critical thinking and analytical skill sets.

S UM MARY

More than 7 Years of experience in i n IT industry in Analysis, Design, Development, Production

Support, Maintenance, and Enhancements & Testing of M ainf rame applications and E T L

I nformatica i ncluding 1 year of experience in leading and managing projects. And having very good

k nowledge on B anking domain, Financial Domain, medical health care and Retail services

A nd p layed major role as Sr. Developer.

Involved in every phase of Software Development Life Cycle processes in a large enterprise

environment.

Worked on front end C ICS Screens using B MS (maps).

Expertise in batch process using J CLs and screens using C ICS .

Extensive programming knowledge on IBM utilities like I DCA MS, I EBGENER, I EBCO MP R,

D FSORT and M E RGE etc.

Experience in t rouble shooting the problems and debugging tools like X PE D I TOR B atch and

O nline and ABEND AID.

Experienced in working on Databases like DB2 and IDMS.

Well exposed to Software Quality Assurance using Tools – X peditor, File Aid, SPUF I, QM F and

i nvolved in Functionality / Integration Testing / System Testing.

Proficient in E T L testing (I nformatica ) and Good experience on Web services while mainframe

system interfacing with M Q-Series, H T M L, X M L, and I N FOR MAT ICA reports

Experience in managing the project source code using Microsoft VSS.

Participated in Business Requirement Gathering and Analysis, Incident and Defect Management.

Strong ability in communicating with Development Teams and ability to work on multiple projects

and prioritize workload.

Experienced in Onsite-Offshore model projects execution.

Implemented various projects in production, prepared and reviewed several implementation scripts

and backup plans.

Created Processing Flow diagrams and Architectural diagrams for various applications.

Strong knowledge in Testing methodology and QA processing.

Involved in U nit testing, System Testing, I n tegration Testing and functional testing.

Proficiency in automating the systems, which can improve the performance.

Experience in preparing conceptual and functional design documents.

Demonstrates excellent troubleshooting and analytical abilities, outstanding interpersonal and

communication skills.

Excellent Coordination through Client and User interactions, experienced in Requirement Analysis

& Design, and Mapping of Business Processes to Technical Requirements.

• Hands on experience with documentation in different stages of SDLC.

• Excellent communication skills and can able to coordinate with Business Analysts and QA teams.

E D UCAT IO N & CERT I F ICAT IO NS:

• Certified I B M Mainf rame T raining from HTMT, Bangalore India.

• Bachelor of Technology i n Computer Science Engineering, JNTU, Andhra Pradesh, India.

• DB2 Universal Database V8.1 Family

TEC H N ICAL SK I L LS

Languages : C OBOL, VS COBOL I I, J CL, I nformatica Power Center

Front End/GUI : C ICS, ADSO

Access Methods : V SAM

Operating Systems : Mainframe, Windows, MVS,

Database : D B2, SQL, PL/SQL, I D MS, I MS

Configuration Management : Change man

Software/ Tools : T SO, ISP F/PDF, Z/OS, File Aid, Xpeditor (Batch & Online), QMF,

SPUFI, Sync Sort, CA7 Scheduler, P ROC, MQ Series, Control-M,

U tilities/ Clists, RACF, S DLC, Abend-Aid, Send, FTP, VPN, File

M anager, MS Office.

PROFESSIONAL EXPER I ENCE:

Client : Target

Location : Bangalore India and Minneapolis, M i nnesota

Du ration : November 2010 – March 2013

In the current environment, TCOE determines the amounts to be paid to schools annually and

t hese payments are issued on check forms specific to the TCOE program. TCOE assigns check

n umbers and then interfaces the payment requests to the Paybase application used to print

checks and send the positive pay file to US Bank. TCOE also processes voids and reissues for

school checks on a monthly basis. US Bank sends check status information back to TCOE to

confirm whether checks have been cleared, void, etc.

R esponsible for:

• Gathering requirements from business users.

• Identify scope, business and functional requirements and create process f lows.

• Involved in writing Technical design documents.

• To manage and maintain Three Data warehouses which cater to Target Organization.

• Ensuring Timely Runs and debugging the same in case of failures.

• Looking After Informatica Administration.

• To Manage Oracle and Teradata Database which host these Warehouses.

Software/Tools : I nformatica 7.1.3, Informatica 8.6 Teradata, Unix shell scripting, Appworks, Oracle

P l Sql, Informatica Administration.

Client : Prudential, ABC

Location: Bangalore, I ndia

Du ration : J uly 2008 – July 2010

Prudential is one of the largest life insurance and financial services institution in the United

States of America. Prudential Retirement is a business unit coming under Prudential

I nvestment division, and focusing on providing quality retirement services for various types of

retirement plans. Types of retirement plans include defined benefit plans and defined

contribution plans. ABC application (Annuitant Benefit Consolidation) deals with the defined

benefit segment of Prudential Retirement for record keeping and payment processing for all

participants.

Defined Benefits are t raditional pension plans that promise participants a specific monthly benefit at

retirement. The amount of the benefit is known in advance and is usually based on factors such as age,

earnings, and years of service. The benefits from a pension plan are usually paid out to the employee in

t he form of an Annuity.

An annuity is a contract between an individual and an insurance company, which states that in

exchange for payment by the individual, the company agrees to pay the individual an income in the

f uture.

Responsible for:

• Reviewing the requirement sent by the Client / Onsite coordinators.

• Preparing test case as per the SRS/developer design document

• Doing data validation testing using both source & target system.

• Writing & Executing SQL queries for Data validation testing for fact & dimensions tables in

t arget DB (warehouse & data mart).

• Doing functional testing, regression testing & re-testing of our ETL testing process.

• Doing testing of informatica workflow & monitoring the workflow log when job is running.

• Executing test case & reporting defects in QC.

• Attending review meeting with team.

Software/Tools : TSO, ISPF/PDF, COBOL I I, OS/ JCL, PROC, DB2, SQL, SDLC, CICS, VSAM,

SPUFI, File Aid, CA7, Xpeditor Online and Batch, FTP, MS-Office, IBM Utilities.

Client : TESCO, UK

Location : B i rmingham, U K

Du ration : October 2007 – July 2008

Service Area - 1: D istribution Finance and miscellaneous users.

T he DSR Focus application receives data from Oracle GL (journals) and SD systems (stock losses) and

formats this for reports detailing and summarizing stock loss and costs for Distribution Finance. The

Depot Stock Results system is a reporting tool that allows depots to analyze their weekly stock

loss/gain and damage/recoup figures.

A sub-system (SD SMAUDSUM) provides weekly extract files of costs for Assembled Volumes, Carrier

Bags and retail Expenses on a weekly and periodic basis.

Service Area - 2: Supplier Conformance, Supply Chain, Store Ordering.

Supplier Performance Management System is used to monitor deliveries to Distribution Centers and

supplier performance data, used by Supply chain and Supplier Conformance to manage suppliers.

The SPMS Focus application receives data from Denver Goods In, and provides a selection of reports

detailing and summarizing arrival, unload and Turn-around times for deliveries to DCs. I t also

p rovides extracts of the tu rnaround time details to Store Ordering. The functionality allows reporting

of data across all ROI or all UK sites (for certain high level users) are permit ted.

Responsible for:

• Working as a single point of contact for the above mentioned two service areas which

i ncludes direct interaction with all of UK and ROI users.

• Creating new distribution centers.

• Preparing the jobs to generate reports.

• Unit Testing and logging the results.

• Delivering of the generated and tested reports to the service manager.

• Coordinating in moving them to production.

Software/Tools : TSO, ISPF/PDF, COBOL I I, Z/OS, JCL, PROC, DB2, SQL, SDLC, CICS, VSAM,

SPUFI, File Aid, CA7, Xpeditor Online and Batch, FTP, MS-Office, IBM Utilities.

Client: AMEX, BruiceLettle

Location: Chennai, India

Du ration : November 2006 – October 2007

This overview describes and illustrates the internal system architecture of GNST. I t focuses on the

system architecture as a function of the business relationship between GNS and its business partners

or participants. In addition, it also briefly describes the working relationship between the GNST

i nternal system architecture and external systems such as CAS, etc.

The primary goal of GNS is to help American Express become the global payments systems provider of

choice to the most desirable card issuers, their customers or card-members, their merchant acquirers

and service establishments or merchants. Long term goals of GNS include increasing card charge

volume and pre-tax income from current levels, expanding its Partner base to several hundred and

t ripling the number of establishments in the American Express merchant network.

R esponsible for:

• Reviewing the requirement sent by the Client / Onsite coordinators.

• Preparing the Design documents and Estimation documents.

• Coding and changing the Programs/ jobs according to requirement.

• Unit Testing and logging the results.

• Delivering of the changed software elements to Onsite coordinators who will be

coordinating in moving them to production.

Software/Tools : TSO, ISPF/PDF, COBOL I I, OS/ JCL, PROC, DB2, SQL, SDLC, CICS,

VSAM, SPUFI, File Aid, CA7, Xpeditor Online and Batch, FTP, MS-Office, IBM Utilities.

Client : MEDCO, USA

Location: Bangalore, India

Du ration : A ugust 2004– October 2006

Medco Health is a pharmacy benefit management company (PBM) in United States that focuses

specifically on the cost-effective and appropriate delivery of prescription medications to the Patients.

Medco is ranked #1 in mail order prescription processing customer satisfaction for 5 years in a row.

Medco has built one of the nation's largest Internet pharmacies, handling 13.8 million new and refill

p rescriptions, representing nearly $2 billion in drug spend. With almost 60,000 retail pharmacies in

Medco’s network, they offer comprehensive service across the United States.

Responsible for:

• Reviewing the requirement sent by the Client / Onsite coordinators.

• Preparing the Design documents and Estimation documents.

• Coding and changing the Programs/ jobs according to requirement.

• Unit Testing and logging the results.

• Delivering of the changed software elements to Onsite coordinators who will be coordinating

i n moving them to production.

Software/Tools : TSO, ISPF/PDF, COBOL I I, OS/ JCL, PROC, DB2, SQL, SDLC, CICS, VSAM,

SPUFI, File Aid, CA7, Xpeditor Online and Batch, FTP, MS-Office, IBM Utilities.

Contact this candidate