PROFESSIONAL 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 the area of Software Quality Assurance including system analysis, system design, documentation and implementation; As a QA Analyst I have worked closely with the 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 with 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 with development team and the client.
• Have used Pair Wise testing technique to reduce the 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 the ETL validation through QTP
• Experience in validating the 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 the requirements and preparing the Test strategy.
• Estimating the testing efforts and coordinating with project manager to track the testing activities in project plan
• Providing Test plan and Test Case walkthrough to the project team and getting their signoffs
• Involving in the Source to Target(ETL) validation by writing SQLs in Teradata based on the Mapping document provided by the System Analyst team
• Validating the GUI application functionalities and Cognos reports against the database to make sure the data displays correctly by writing SQLs
• Automating the GUI and Cognos report validation thru QTP 10.0
• Sharing the Test Execution metrics, project health, defect details with the project team on a daily basis during the test execution phase
• Conducting Defect triage meetings with the SMEs and BAs to facilitate the development team to fix the defects quickly and track the defects till closure
• Coordinating with the Performance Testing team and get the application tested with the required number of users using Load Runner
• Supporting Release Management team by representing QA and supported the production checkout process during deployments and provided QA signoffs
• Coordinating with Offshore team to make them understand the system better and accomplish the 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 with business users, business analysts, data modelers and database administrator to understand the business process, functional requirements and design of the data mart in the warehouse.
• Designed the Test Strategy and formulated the Test plan having analyzed the business model and the system requirements.
• Involved in Smoke Testing the application.
• Documented the 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.
• Effectively used HP Quality Center as the Test Management tool for Test Execution and the Defect management.
• Conducted Defect Triage meetings and supported developers in identifying defects and performed defect retests
• Co-ordinated with offshore team by assigning tasks and get the deliverables

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

Confidential, Princeton - NJ

Sr. Quality Analyst

Responsibilities:

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

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

Confidential, GA

Software Engineer

Responsibilities:

• Understanding the requirement and creating test cases in QC using the different techniques like Boundary value analysis, pair wise etc.,
• Creating Requirement Traceability matrix to ensure all the requirements are covered in the 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 with the Management team.
• Creating Change Requests for defects found, Using Star Team.