ETL Testing, QTP, Maual Testing, Quality Center

Ilavarasi

602-***-****(M)

************@*****.***

Professional Summary:

Having 7+ years of professional experience in Software Quality assurance on

various domains like Finance, Healthcare, Insurance and Retail. Expertise

in Manual, Automation, ETL&BI testing, which includes Functional,

Regression Testing, System Integration and End to End testing of enterprise

and web-based applications.

. Expertise in developing Test Strategy, Test Plan, Test Scenarios, Test

Case Design, Test Reports using business/functional requirements.

. Thorough knowledge in Functionality Testing, GUI Testing, Regression

Testing, Integration Testing, database testing, System Testing.

. Having knowledge in Hadoop and Hive.

. Experience in Developing Test Matrix to give a better view of testing

effort

. Expertise in designing/developing test frameworks using automation tool

QTP (Quick Test Pro).

. Tested the ETL mappings and other ETL Processes (Data Warehouse Testing).

. Performed data validation testing writing SQL queries

. Created test data for all mapping rules to test the functionality of

various ETL systems and BI tools.

. Expertise in defining QA Strategy, Estimates and future roadmaps in

onsite & offshore working model.

. Specialized in analyzing the functional requirement specifications and

writing detailed test cases.

. Experience assessing testing processes, creating and implementing testing

strategies in UAT phase

. Experience in working with waterfall, V-model, and Agile with scrum

methodologies.

. Experience in Mobile Testing [iOS and Android] for the applications

functionality.

. Involved in Cross browser Testing as well as Internet Explorer, Firefox

and Safari.

. Involving in writing SQL queries and Database Checkpoints to verify data

quality and calculations, reviews

. Supported the extraction, transformation and load (ETL) for a Data

Warehouse from their legacy systems using Informatica.

. Performed root cause analysis of data quality issues to provide accurate

and timely data to client datamart applications.

. Experienced in Agile Scrum model, involving in daily road maps and sprint

meetings.

. Extensive experience in Manual Testing, Black Box, Functional,

Regression, System Integration, E2E, Ad-hoc, Cross Browser, Compatibility

and Regression testing

. Strong experience in Application Testing, Web applications & .Net

applications

. Experience in working with HP Quality Center.

. Responsibilities include identification of test scenarios, test case

creation, identifying test data requirements, test data creation, Quality

Center upload and test coverage activity vs. requirements, SIT execution,

defect tracking and resolution.

. Have experience in Tools QTP, CA LISA

. Excellent interpersonal and communication skills.

. Interacted with multiple clients across various disciplines.

. Excellent Knowledge in SDLC, STLC, Defect Life Cycle.

. Quick learner and excellent team player having ability to meet tight

deadlines and work under pressure.

. Good interpersonal skills, committed, result oriented, hard working with

a quest and Zeal to learn new technologies.

Technical Skills:

. Scripting/Markup : HTML, CSS, .Net,VBScript, Shell Script

. Operating Syst ems : Windows 8, 7, XP, NT/2000, 95/98, UNIX, DOS

. Databases : Oracle 10/11g, DB2, MS-SQL Server, T-

SQL, WinSQL,

MS Access

. Package : MS Office (Excel, Word, Outlook,

Access), MS FrontPage

. Test Automation Tools : QTP 10.0, 11.0, CA LISA

. Test Management tools : QC10 (Quality Center),JIRA, MTM,TFS,ClearQuest

. ETL tools : Informatica, TalenD and Ssis

. Reporting Tools : Ssrs and Business object.

Education Qualifications:

. M.Sc. in Computer Science from Madurai Kamaraj University, TN, India.

Professional Experience:

Client: Best Buy, MN

May12 - Till date

Domain: Retail

Role: QA Analyst/ETL and Report Tester

Project Description:

BestBuy Inc. is an American multinational consumer electronics corporation.

Best Buy sells consumer electronics and a variety of related merchandise,

including software, video games, music, DVDs, Blu-ray discs, mobile phones,

digital cameras, car stereos and video cameras. In 2013, Best Buy operated

1,056 Best Buy and 409 Best Buy Mobile stand-alone stores in the US Best

Buy also operated; 140 Future Shop, 72 Best Buy and 49 Best Buy Mobile

stand-alone stores in Canada; 211 Five Star stores in China; and 14 BestBuy

stores in Mexico. BestBuy exited the European market in April 2013.

Responsibilities:

. Managed onsite and offshore team and made sure that deliverables are

tested with in timelines.

. Creating Automation Scripts (VBScript) in the sprints and stored them in

the Test-Plan module of Quality Center.

. Developed automated test scripts for upgrading the application using QTP.

. Involved in ETL and Reporting process testing using Informatica ETL tool

and Business Objects.

. Performed data validation testing writing SQL queries.

. Experience assessing testing processes, creating and implementing testing

strategies in UAT phase

. Developed Manual test cases by analyzing use cases for specific

functional requirements.

. Developing Test Matrix to give a better view of testing effort

. Interacted with Business teams and Developers to understand business

requirements and bug fixes.

. Worked with Business Analysts to define and design test scenarios and

test data.

. Enrolling Claims as per the requirement and verifying E2E Data.

. Made recommendations for manual and automated testing scenarios related

to various functionalities.

. Performed Regression testing to make sure that build is tested

comprehensively.

. Performed Cross browser testing across different browsers like Internet

Explorer, Firefox and Google Chrome.

. Worked on Quality Center 10.0 to manage bugs, test reports and

statistics.

. Performed Integration testing to verify the data interface between

various application modules.

. ETL data validation through BAM and excel reports.

. Interacted with developers to reproduce defects and resolve software

anomalies.

. Coordinated communication between various teams to ensure consistency and

accuracy across test plans, user manuals and training materials.

. Worked with collaborative testing with developers as per the SCRUM

meeting.

. Created automated scripts using QTP to test functionalities.

. Created Reusable functions by using QTP.

. Used Component based approach to develop automation scripts; this

approach reduces the cost of maintenance and maximizes the re-use of

existing test scripts.

. Data Driven Test with Quick Test Professional (QTP) to test the

application for different sets of data.

. Created recovery scenarios for pop-up messages wherever necessary.

. Involved in reviewing the automation test scripts and functional test

cases.

. Executed and modified test Scripts to suite different version of the

application.

. Currently storing some kind of Unstructured data into HDFS format by

using Hadoop and Hive.

Environment: QTP 11.0, Quality Center ALM, Informatica9.1, Business object

3.1 Xi, Oracle 11G, HTML, SQL, UNIX, Windows, Hadoop, Hive, HDFS

Architecture.

Client: CITI, NJ

Feb11 to Apr12

Domain: Banking

Role: QA Analyst

Project Description:

Citibank is the consumer banking division of financial services

multinational Citigroup. Citibank was founded in 1812 as the City Bank of

New York, later First National City Bank of New York. As of March

2010[update], Citigroup is the third largest bank holding company in the

United States by total assets, after Bank of America and JPMorgan Chase.

Responsibilities:

. Developed business use cases, user interface specifications, and user

requirement specification documents

. Coordinated communication between various teams to ensure consistency and

accuracy across test plans, user manuals and training materials

. Functional Validation of applications for the IOS Devices (iPhone,

iPad)

. Coordinated with Business teams and Developers to understand business

requirements.

. Maintained bug lists for critical issues using Quality Center 10.0, for

bug tracking.

. Experience assessing testing processes, creating and implementing testing

strategies in UAT phase.

. Allocated work to the offshore team and conducted meetings on a regular

basis to track the progress.

. Developing Test Matrix to give a better view of testing effort

. Integration testing to verify the data interface between various

application modules

Environment: JIRA, SQL Server 2008, SSRS, SSIS, Legacy System, MS Office

Suite, Windows XP, Unix, HTML, SQL, Windows

Client: Esurance, CA

Nov09 to Jan11

Domain: Insurance

Role: QA Analyst

Project Description:

Esurance Insurance Services, Inc. is an American auto insurance provider.

The company, which is a wholly owned subsidiary of Allstate, sells car

insurance direct to consumers online and over the phone offering services

to nearly 90 percent of the U.S. population in 40 states. Esurance has more

than 2,500 employees in 16 offices nationwide. Responsibilities:

. Lead Manual and Automation teams.

. Vast experience with systems integration testing applications developed

for the .NET platform

. Good understanding of Appropriate scripts, test data requirements and

base data requirements

. Executed the scripts on current releases and sustaining releases

. Executed localization scripts as per client needs

. Reported Manual and Automation execution status to clients using QC

dashboards on a regular basis

. Used QC to map requirements in order to maintain traceability matrix for

Business Process Records

. Testing Web Plugins based on XML.

. Creation of bug Reports and reviewing the bug fixes for the test strategy

using QC 10.

. Participated in Bug tracking and Traceability matrix meetings

. Review Test Plan and test cases developed by team members

. Participated in SCRUM meetings.

. Interacted with clients and updated the status on a regular basis.

. Understanding the new requirements and new features

. Highlighting the potential risks to the client which might affect the

project schedule

Environment: Quality Center 10.0, SQL Server 2005, .Net,web Methods, MS

Office Suite, Windows XP, Oracle9i, TOAD

Client: Medstart, VA

Oct 07 - Oct 09

Domain: Health Care

Role : QA Engineer

Project Description:

MedStart Health is a not-for-profit healthcare organization. It operates

more than 120 entities, including ten hospitals in the Baltimore-Washington

metropolitan area of the US is the employer with the largest number of

local employees in that area.

Responsibilities:

. Understanding the new requirements and new features

. Developed Manual test cases by decomposing use cases for specific

functional requirements.

. Tested applications developed using .Net framework

. Using HP Quality Center for storing, maintaining the test repository, bug

tracking and reporting

. Responsibilities include identification of test scenarios, test case

creation, identifying test data requirements, test data creation, Quality

Center upload and test coverage activity vs. requirements, SIT execution,

defect tracking and resolution

. Interacted with Business teams and Developers to understand business

requirements and bug fixes.

. Analyzing the specifications provided by the client

. Understanding the new requirements and new features

. Writing the functional test cases, Prepare Test Reports

Environment: Quality Center 10.0, .Net, MS Office Suite, Windows XP

Contact this candidate