Project Quality Assurance

SUMMARY

. *+ years of IT Experience in Development, Software Analysis, design

and Quality assurance.

. Familiar with all phases of SDLC (Software Development Life Cycle) and

Quality Assurance methodologies (Waterfall, Agile)

. Involved in validating the data that has been populated into Data

warehouse Fact and dimensional tables using Ab Initio Data Warehouse

tool.

. Extensively worked on Application development using COBOL, JCL, DB2,

IMS.

. Involved in Maintenance and Software testing under Mainframe

environment.

. Responsible for individual day to day communication with Client for

ON-call Support from offshore and also weekly conference call direct

with customer at onsite.

. Good Knowledge in using automation tools like QTP, Load

Runner,Selenium.

. Good Experience with Quality Center.

. Good SQL skills and understanding of Unix Shell Scripting.

CERTIFICATION

COBOL II BrainBench Certified.

IBM DB2 7.1 Certified

TECHNICAL SKILLS

Operating Systems Windows 98/2000/XP/Vista, UNIX, IBM MVS

Languages COBOL, C, JCL, SQL

Automation Tools/Testing ETL (Ab initio),Quick Test Professional

Tools (QTP), Quality Center

Automation Tools/Testing SQL, Visual Basic

Tools

Browsers Internet Explorer, Netscape, Mozilla

FireFox

Database Management Oracle, SQL Server, DB2, Acess '2000

Other Tools Endevor, QMF, INFOMAN

Utilities ISPF/PDF, TSO

PROFESSIONAL EXPERIENCE

Servotech Consultants Nov 2010 - Feb 2011

Project Name: PLCB ETL Testing

Client: Tri-Bry Business Technology Solutions

Duration : 3months

Project Description: PLCB store Management required building an Oracle data

warehouse to store sales and pricing information of their beverage

products. Tri-Bry's expert consultants help integrate traditional business

practices with the latest developments in technology. The result is a

scalable and flexible infrastructure that is capable of handling on-demand

business needs. Tri-Bry has the skill, experience and knowledge to build

open-standards based solutions capable of streamlining your business which

will result in increased productivity throughout all aspects of business

critical operations.

Role: Test Engineer

Responsibilities:

. Analyzed source data and gathered requirements from the business

users.

Prepared technical specifications to develop ETL mappings to load data

into various tables confirming to the business rules.

Study and analysis of the mapping document indicating the source

tables, columns, data types, transformations required, business rules

to be applied, target tables, columns and data types.

. Preparing the Test Data (mock up data) to test the ETL code.

Developing the ETL code/ SQL script to come up with the expected

results.

Develop the test cases along with test script and expected result.

. Upload the test cases into Quality center using the excel add in.

. Created the test graphs using Ab intio to mock up the complex data

files.

. Develop and test the comparison graph to compare the actual result set

with the expected result set.

. Log the defects in clear quest incase for any shakeout related issues.

Checking whether the data has been populated in the appropriate table

by executing our own DB scripts.

. Execute the ETLs with proper test data and create the actual results.

Compare the actual result set against the expected results by running

the comparison graph and discuss any deviations with the developer.

. Map the defect ID in against the related test case in the quality

center.

Communicating with the Business Analysts, DBAs, System Admins, and

Development Team incase of any issues or policy related questions.

Environment: Ab Initio GDE 1.12, Oracle 8, Quality Center, SQL

Tools.

Servotech Consultants Sep2009 - Mar 2010

Project Name: PLCB Store Automation

Client: Tri-Bry Business Technology Solutions

Duration: 6 months

PLCB Store Automation project will help PLCB maintain real time inventory

of its item sold online as well as in stores. It will help users get a real-

time in stock status as well as a tentative timeline if the items are not

in stock presently or if the item is available in a different store. The

aim was to provide integrated access to the whole set of systems using

Service Oriented Architecture (SOA). Types of testing involved in the

project are Manual, Automated testing using QTP.

Role: Test Engineer

Responsibilities:

. I was involved mostly with Automated testing using QTP.

. Involved in developing the automation test plan.

. Develop the scripts in Keyword view according to test case/ Test

scenario.

. Debug the scripts and execute the scripts.

. Performed Data Driven Tests for both positive and negative sets of

data.

. Performed back-end testing of database using database check-point.

. Analyze the result, and log the defects in bug tracking tool (Quality

Centre).

Environment: QTP (9.2), Quality Center 9, Oracle 10g, MS SQL Server 2005

Servotech Consultants Jan 2009 - May 2009

Project Name: GGI Website Migration

Client: Tri-Bry Business Technology Solutions

Duration: 3 months

Project Description: Tri-Bry's expert consultants help integrate

traditional business practices with the latest developments in technology.

The result is a scalable and flexible infrastructure that is capable of

handling on-demand business needs. Tri-Bry has the skill, experience and

knowledge to build open-standards based solutions capable of streamlining

your business which will result in increased productivity throughout all

aspects of business critical operations.

General Glass International (GGI) website migration project will help GGI

maintain users have a look at real time glass designs and patterns, get

stock inventory of its item and let users experience the various colors and

patterns available in different varieties of glass.

Role: Test Engineer

Responsibilities:

. Identified test cases after going through the documents provided and

developed systematic procedure for each test case and reviewed the

test cases.

. Reviewed the requirements from the documents provided.

. Attended regular project meetings and weekly team meeting to discuss

the project milestones.

. Performed manual testing for the GUI functionality of the application.

. Log system errors where the results are not as expected. Produce

testing documentation

. Worked closely with developers to help them in Unit Testing.

Melstar Inf. Technology Ltd. Sep 2002 - Jan 2006

Client ADP (Automated Data Processing),

New

Jersey

ADP deals with the ACM(Automated Cash Management ) and Reinvestment

Module.The main objective of the project is to extract business logic for

converting the application from VSAM to DB2.

Responsibilities:

. Extraction of Business Logic by Analysis and Documentation.

. Writing the Business Logic using company standards.

Environment: IBM MVS,COBOL-II, SQL,DB2

April 2001 - Aug 2001

Client Fingerhut,Minneapolis, USA

Fingerhut deals with processing of mail orders received by customers. The

main objective of the project involves development, maintenance and

solving issues requested by the client.

Responsibilities:

. Development and Enhancement of programs using COBOL-II.

. Manual testing of the application using JCL.

. Preparing Test cases for the requirements using Quality Center.

Environment: IBM MVS, COBOL-II, SQL,DB2

Hexaware Technologies LTD. August-2000 - March-2001

Client Hexaware

Hexaware is a consulting company which needed a user friendly and menu

driven package developed in MS ACCESS'97 to track the progress of any

project, which has systematic Management approach.The system is developed

to assist project managers/leaders in monitoring the progress of their

project status.

Responsibilities:

. Design,coding using Visual Basic.

. Back End coding using SQL .

. Manual testing of the application.

Environment: MS-ACCESS '97, Visual Basic, SQL

Silverline Technologies Ltd. June'99 - August-2000

Client First Data Resources Inc. Omaha,

Nebraska, USA

FDR ( First Data Resourses) deals with different types of credit/debit

cards i.e. it maintains all the details regarding the cardholder.Some of

its Functions are post monetory/non monetory Transactions, Account

transfers, Month end /Year end processing. The main objective of the

project is solving Y2K problem.

Responsibilities:

. Responsible for Anaysis,coding and testing of Programs for Y2K

compliance.

. To verify that the changes done for Y2K compliance in different

applications have been done correctly.

. Responsible for individual day to day communication with Client.

Environment: IBM MVS, COBOL, JCL, ENDEVOR, QMF

Contact this candidate