SUMMARY

• Around 9 years of diversified experience in Information Technology as a QA Lead and Automation Test Engineer.
• Experience in testing Client/Server, Web, Datawarehouse(ETL) and BI applications in different domains like Insurance and Healthcare.
• Having expertise in teh area of Software Quality Assurance including system analysis, system design, documentation and implementation;
• As a QA Analyst me has worked closely wif teh Project Manager, Development team, Business Analysts and End - Users.
• Developed Test plans, Test cases, Test Scenarios and Automated Test scripts to ensure proper business compliance for both Manual and Automated Testing.
• Experience in performing Manual and Automated testing using QuickTestPro, Quality Center, Rational ClearQuest, Rational ClearCase.
• Well versed wif Smoke, Black Box, GUI, functional, regression, system, integration, negative, acceptance (UAT), load/performance, browser compatibility testing.
• Working experience in Test planning, Test execution and Test results analyses.
• In-depth participation in Design reviews and Requirement analysis wif development team and teh client.
• Has used Pair Wise testing technique to reduce teh number of Test Cases.
• Good knowledge of Software Development Life Cycle (SDLC) and Software Test Life Cycle (STLC).
• Experience in testing of Extract Transform and Load (ETL) processes on Teradata.
• Worked in Data Warehouse projects having different database source systems like SQL server,DB2, Oracle etc.,
• Automation Testing experience using Quick Test Professional (9.2,9.5,10.0)
• Involved in automating teh ETL validation through QTP
• Experience in validating teh Canned reports as well as Cognos reports using Query Studio, Analysis studio etc.,
• RDBMS concepts and working experience in Oracle, SQL Server.
• Experience in Configuration and Change Management using Visual Source Safe and Sharepoint
• Good knowledge in installing and configuring Automated Tools and Setting QA Test Environment.
• Good understanding of Web Applications/Web Services architecture.
• Highly Motivated, Detail oriented, Versatile, Self starter and able to work independently or as a part of a team. Good Track record of producing High quality results while under Pressure.

TECHNICAL SKILLS

Tools: Quality Center 10.0, QuickTestPro 10.0, Rational ClearQuest, Rational ClearCase

Scripting Languages: VBScript

Languages Known: VBA, PL/SQL, SQL

Operating Systems: Windows XP/7, Unix, MS-DOS.

Database Package: SQL Server 2008, Oracle, Teradata

Other Tools: Cognos, Teradata SQL Assistant, SQL Developer, Visual Source Safe 6.0, AQT(Advanced Query Tool)

PROFESSIONAL EXPERIENCE

Confidential - Hartford,CT

QA Lead

Responsibilities:

• Analyzing teh requirements and preparing teh Test strategy.
• Estimating teh testing efforts and coordinating wif project manager to track teh testing activities in project plan
• Providing Test plan and Test Case walkthrough to teh project team and getting their signoffs
• Involving in teh Source to Target(ETL) validation by writing SQLs in Teradata based on teh Mapping document provided by teh System Analyst team
• Validating teh GUI application functionalities and Cognos reports against teh database to make sure teh data displays correctly by writing SQLs
• Automating teh GUI and Cognos report validation thru QTP 10.0
• Sharing teh Test Execution metrics, project health, defect details wif teh project team on a daily basis during teh test execution phase
• Conducting Defect triage meetings wif teh SMEs and BAs to facilitate teh development team to fix teh defects quickly and track teh defects till closure
• Coordinating wif teh Performance Testing team and get teh application tested wif teh required number of users using Load Runner
• Supporting Release Management team by representing QA and supported teh production checkout process during deployments and provided QA signoffs
• Coordinating wif Offshore team to make them understand teh system better and accomplish teh tasks on time.

Environment: Teradata SQL Assistant, SQL server 2008, Advanced Query Tool, QTP 10.0, QC 10.0, Cognos, Xcelcius, Query Studio, Sharepoint

Confidential - Hartford,CT

Sr. Quality Analyst

Responsibilities:

• Worked closely wif business users, business analysts, data modelers and database administrator to understand teh business process, functional requirements and design of teh data mart in teh warehouse.
• Designed teh Test Strategy and formulated teh Test pla having analyzed teh business model and teh system requirements.
• Involved in Smoke Testing teh application.
• Documented teh whole testing procedure including Test Scenarios, Test Cases, Results and Test Analysis.
• Performed Data reconciliation of source, Referential Integrity, Null and Default value checks and Business Rules applied.
• TEMPEffectively used HP Quality Center as teh Test Management tool for Test Execution and teh Defect management.
• Conducted Defect Triage meetings and supported developers in identifying defects and performed defect retests
• Co-ordinated wif offshore team by assigning tasks and get teh deliverables

Environment: Teradata SQL Assistant, SQL Server, Oracle, Mainframes, Cognos

Confidential, Princeton - NJ

Sr. Quality Analyst

Responsibilities:

• Understanding teh functional requirement of teh product.
• Involved in developing a comprehensive system Test plan and created teh test cases.
• Translated teh technical requirements into verifiable and testable scenarios.
• Worked wif teh team to define and design test objectives. Additionally, collaborated to formulate TEMPeffective test documentation.
• Extensively used SQL to verify data in teh backend.
• Automated teh entire regression test suite using QTP 9.5
• Prioritized and classified bugs. Generated and tracked teh defects using Quality Center.

Environment: Windows, UNIX, Visual Basic, .net, ASP, Oracle, Quality Center.

Confidential

Software Engineer-Testing(Offshore)

Responsibilities:

• Understanding teh requirement and creating test cases in QC using teh different techniques like Boundary value analysis, pair wise etc.,
• Creating Requirement Traceability matrix to ensure all teh requirements are covered in teh test case
• Automate regression test cases using Quick Test Pro (QTP) tool.
• Develop and executed SQL Queries to Oracle database.
• Created various Negative and positive test scenarios.
• Manual and Automated execution of regression test cases.
• Collection of test evidence and reporting.
• Prepared Test Metrics on a monthly basis and shared wif teh Management team.
• Creating Change Requests for defects found, Using Star Team.