SUMMARY

• Over TWELVE years of QA Experience including EIGHT years as a Quality lead
• Experience working in Onsite - Offshore model
• Over THREE Years of Experience in ETL Testing
• Experience in working with Database DB2, SQL Server
• Experience in working on Rally, Version One tool for Agile Scrum Management.
• Experience in using Autosys job scheduling tool
• Experience in using basic UNIX commands for ETL Testing
• Experience in using TDM tool to mask and bring down production data to lower environments
• 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.
• Experience in working closely with Business Analysts and Data Architects to know the exact functionality of the Stories and also to know the Data flow between different tables in the system which has to be shared with the entire QA team before every iteration of the release.
• Experience in discussing with the team members and client about the defects raised in a daily basis by conducting Defect Triage meetings and finalizing the defect's priority, severity with the business and the date fix and retest from the Development team.
• 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.
• 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.
• 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
• 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: Finance, Mortgage, Insurance, Healthcare Provider & Retail Domain.

RDBMS: DB2, MS SQL Server 2005 & 2008.

Health Care Analysis Standards: HL7.

ETL Tools: Informatica PowerCenter 10.4

Automation Tools: Knowledge in HPE UFT 12.0.

Defect Tracking Tools: JIRA, Mantis, Change Synergy, Visual Studio 2010.

Test Management Tools: Test Rail, Microsoft Test Manager, HP ALM, TDM

Agile Management Tool: Rally, VersionOne.

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, Arizona

ETL QA Lead Tester

Responsibilities:

• To work closely with business user in understanding, designing and documenting the functional testing plan and then writing, executing and documenting the results and logging defects.
• Used TDM to Mask and bring down the production data to lower environments, in order to load data in SIT and UAT environments
• Working on ETL Test specifications including Test source data preparation, writing Testcases for Test data completeness, data transformations, data quality, performance and scalability, data aggregation (match Aggregated data against staging tables or ODS and granularity of data is as per specification).
• To Analyze and Validate the ETL data mappings by writing complex SQL queries and also using Data Validation Option (DVO) Automation Tool.
• To work with Application/Development teams to debug and resolve any defects/Issues that arise out of the testing process, Schedule triage meetings to keep track of severity defects and communicating it to Project Managers.
• To execute ETL Workflows using UNIX Commands and monitor the workflows in Workflow monitor.
• Responsible for data loaded in Target systems within prescribed and expected Timeframes to confirm improved performance and scalability

Confidential, McLean, VA

ETL QA Tester

Responsibilities:

• Developed Test Cases /Test Scripts to verify the data completeness and transformation rules for ETL
• Extensively used SQL queries to check accuracy of data in the database verification testing.
• Extensively used HP ALM to Create and Execute the Test cases and for Defect Management.
• Used 'Version One' for Agile Scrum Management
• Used ’Microsoft Share Point' for managing the project related Documents
• Analyzed System specifications, design, development and execution of Test Plans and Test Cases for User Acceptance testing
• Involved in various phases of functionality, regression testing, integration testing and User Acceptance testing.
• Used HP ALM for Identifying the Full Test Coverage. Tested the Web Application for all the functionalities. Organized and managed planning and execution of Test Cases and tracking and fixation of the errors/defects using Quality Center.
• Interacted with the developers and other team members to ensure high quality software. Played a key role in timely delivery of the product.
• Involved in Data Analysis and actively participated in Data Model of the system and its legacy systems with the Business and participated in the sessions used to write the stories with the team.
• To Attend 'Business Review' Meeting to review the Test Results and for final UAT Signoff.

Environment: DB2, IDERA Rapid SQL, VersionOne, HPALM, SharePoint, Windows 7, MS Excel.

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.

Confidential

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)
• Experience in using Autosys tool for scheduling the mapping jobs
• 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.
• Experience in using basic UNIX commands
• 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 both UNIX and Windows environment 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.