SUMMARY:

• Over 11+ years of QA experience including 8 Years as a Quality lead
• QA lead in Pacific life Insurance project for 2.5 years
• Experience working in Onsite - Offshore model
• 2.5 Years Experience in ETL Testing (Informatica Powercenter Tool)
• Knowledge in Informatica Data Validation Tool
• Worked as  ETL Tester  responsible for the requirements gathering ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project. 
• Tested mapping for extracting, cleansing, transforming, integrating, and loading data using Informatica ETL Tool. 
• Experience in both Agile Project Environment and Waterfall (Software Development
• Life Cycle -SDLC).
• Professional experience in Integration, Functional, Regression, System Testing, Load Testing, UAT Testing, Black Box and GUI testing.
• Exposure in Oracle Documaker Tool, Enterprise Application Integration using HL7.
• Exposure in HP UFT Automation Tool
• Worked as a Quality Engineer in Dot Net, Documaker based Projects
• Experience in using  JIRA, Mantis, Change Synergy   and  HP Quality Center  for Bug Tracking and Defect Reporting.
• Experience with comprehensive understanding of all phases of Test Life Cycle,
• including requirements gathering test planning, scheduling, testing, defect tracking
• and reporting. 
• Good knowledge of analyzing and understanding the Domain and Business Logic.
• Expertise in back end testing and writing SQL queries using SQL Server. 
• Providing clear feedback in scrum retrospective meeting and discuss different
• problem in scrum meeting
• Ability to adapt to new environment quickly, strong team player, good communication, good analytical and computation skills, enthusiastic learner, confident, sincere and committed.
• Summarized the test results for complete Test Report and prepare report for management.
• Ability to work in a highly Agile environment and work on multiple projects or tasks at the same time.
• Experience with comprehensive understanding of all phases of Test Life Cycle, including requirements gathering test planning, scheduling, testing, defect tracking and reporting. 
• Extensive experience with Software Quality Assurance Testing on Web UI application

TECHNICAL SKILLS:

DOMAIN KNOWLEDGE: Insurance, Healthcare Provider & Retail Domain

RDBMS: SQL Server 2005 & 2008

HEALTH CARE ANALYSIS STANDARDS: HL7

ETL TOOLS: Informatica Powercenter 9.1

AUTOMATION TOOLS: Knowledge in HP UFT, TAF (Test Automation Framework)

DEFECT TRACKING TOOLS: JIRA, Mantis, Change Synergy, Visual Studio 2010

TEST MANAGEMENT TOOL: Test Rail, Microsoft Test Manager, HP Quality Center

Confidential, Aliso Viejo, CA

Senior QA Analyst

 Responsibilities:

• Leading QA Team
• To Coordinate between the Client Team and Offshore QA Team
• Performing project estimation based on the requirement.
• Participating in the Business walkthrough for the new products
• Implementing new ideas to improve testing process and to deliver the requirements with good quality
• Mentoring and training project members to enable them to perform their activities
• effectively.
• Analyzing the requirement with the team to provide clear idea on what needs to be tested.
• Exploring the Software requirement and preparing Check list document.
• Reviewing and Baselining the Test Plan, Test cases with the team.
• Used ‘Test Rail (Test Management Tool) to manage test case.
• Performing multiple Test Runs using the Test rail tool
• Performing Smoke Testing when the Test environment is ready.
• To perform Test case preparation and Test Execution.
• Reporting Defects in JIRA (Defect Tracking tool) and to review the defects raised by the Team.
• To define the Target date for test completion based on the UAT testing date provided by the client.
• Tracking the defects by sending the Defect Summary report on daily basis.
• Developed Traceability Matrix which is a proof of document to ensure that all the specifications are been tested and has no defect
• To Enhance and Execute the Regression Test cases for every release
• To perform Stage test before the product moves into production
• Reporting the Test Summary Report to the clients using the Test Rail tool
• Performing Test Case review and production release meetings
• Responsible for defect reporting, Triage and tracking till closure.
• Preparation of weekly status report and presenting it to the clients
• Preparation of monthly status report and presenting it to the clients.
• To organize Daily Status meeting with the team to track the progress.
• Preparing the UAT support document.

Environment: SharePoint, JIRA, Test Rail, Oracle Documaker tool, Cyberlife Browser, MS Excel, Win 7.

ETL Tester

 Responsibilities:

• Created test cases and test plans for user acceptance testing and system testing based on functional specifications. 
• Designed and executed various well described Test scripts for System testing based on the Functional Design Document. 
• Worked on ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Assisted in gathering the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project 
• Developed Data warehouse ETL test cases for various lines of businesses based on ETL mapping document. 
• Backend testing of the Data Base by writing SQL queries and PL/SQL scripts to test the integrity of the application and Oracle databases. 
• Expertise in writing SQL Statements in database to make sure whether the data is populated in Data Mart/Data warehouse According to Business Rules. 

Environment: Informatica Powercenter 9.1, JIRA, Test Rail, SQL Server 2008, MS Excel, Win 7.

Senior Quality Engineer

 Responsibilities:

• Leading QA Team
• Performing project estimation based on the requirement.
• Implementing new ideas to improve testing process and to deliver the requirements with good quality
• Analyzing the requirement with the team to provide clear idea on what needs to be tested.
• Exploring the Software requirement and preparing Check list document.
• Reviewing and Baselining the Test Plan, Test cases with the team.
• Understanding the functional requirement and manage functional testing.
• Preparation and Execution of Test cases
• Performing Automation to Reverse and Rekey of the policies specifically for which MVA is calculated wrongly
• Reporting defects in HP Quality Center
• To define the Target date for test completion based on the UAT testing date provided by the client.
• Tracking the defects by sending the Defect Summary report on daily basis.
• Developed Traceability Matrix which is a proof of document to ensure that all the specifications are been tested and has no defect
• To Enhance and Execute the Regression Test cases for every release
• To perform Stage test before the product moves into production
• Reporting the Test Summary Report to the clients using the Test Rail tool
• Performing Test Case review and production release meetings
• Responsible for defect reporting, Triage and tracking till closure.
• Tracking the progress of Defect Reports
• Preparation of weekly status report and presenting it to the clients
• Preparation of monthly status report and presenting it to the clients.
• To organize Daily Status meeting with the team to track the progress.
• Preparing the UAT support document.

Environment: HP Quality Center, Browser, MS Excel, Windows 7.

Senior Quality Engineer

 Responsibilities:

• Leading QA Team
• Performing project estimation based on the requirement.
• Participating in the Business walkthrough for the new requirements
• Participating in Test Plan preparation
• Implementing new ideas to improve testing process and to deliver the requirements with good quality
• Analyzing the requirement with the team to provide clear idea on what needs to be tested.
• Exploring the Software requirement and preparing Check list document.
• Reviewing and Baselining the Test Plan, Test cases with the team.
• Performing Smoke Testing when the Test environment is ready.
• To perform Test case preparation and Test Execution.
• Reporting Bugs in Change Synergy (Defect Tracking tool)
• Preparation of Defect & Test Summary Report on daily basis
• Expertise in back end testing and writing SQL queries, Joins, Procedures using SQL Server. 
• Preparation of weekly status report and presenting it to the clients.
• Preparation of monthly status report and presenting it to the clients.
• Documenting release notes
• Participating in estimating the Story points for the user stories
• Participating in Sprint planning meeting and providing the feedback
• Providing clear feedback in scrum retrospective meeting and discuss different problem in scrum meeting
• Providing demo to the clients during Sprint Review meeting

Environment: Change Synergy, SQL Server 2005 & 2008, Visual Studio 2010, MS Excel, Windows XP.

Quality Engineer

Responsibilities:

• Participating in the Business walkthrough for the new requirements
• Analyzing the requirement with the team to provide clear idea on what needs to be tested.
• Exploring the Software requirement and preparing Check list document.
• Performing Smoke Testing when the Test environment is ready.
• Preparation and Execution of Test cases
• Reporting Bugs in Defect Tracking tool like Mantis, Change Synergy, Visual Studio 2010
• Preparation of Defect & Test Summary Report
• Tracking the defects by sending the Defect Summary report on daily basis.
• Involved in preparing Traceability Matrix which is a proof of document to ensure that all the specifications are been tested and has no defect
• To Execute the Regression Test cases for every release

Environment: Mantis, SQL Server 2005, MS Excel, Windows XP, Change Synergy.