SUMMARY:

• 10 years of experience in the IT industry as ETL - DW-BI QA Test Lead/ETL Test Automation QA / ETL Tester/Quality Assurance Tester
• 10 years’ experience in Software Quality in ETL, DW, BI testing and ETL Testing Automation in DWH projects
• 10 years’ experience in defect tracking and management tools like JIRA, TFS, ALM and Quality Center
• 2 years’ experience in working in Agile environment
• 8 years’ experience in database testing using SQL queries in Oracle, MS SQL Server, Teradata, Sybase
• 4 years’ experience in ETL testing automation using Saturn (in-built) tool for Confidential
• 1-year experience in Python for creating automated scripts for file comparisons
• 6 years’ experience of managing offshore teams
• 5 years’ experience of leading the team and managing resources on aggressive and ever-changing time schedule.
• Expertise in defining Test Scenarios and developing Test Cases, analyzing bugs , coordinating with development team and track the bug fixes till closure
• Expertise in designing and executing test cases for Regression and Integration Testing
• Experience in Test Estimation based on functional requirements.
• Understanding of the entire Software Development Lifecycle (SDLC)
• Involved in the entire software test lifecycle - monitoring and improving the QA process, and making sure that any agreed-upon standards and procedures are followed.
• Provided guidance on process improvements and optimization to the team members.
• Involved in created automated Status reports using ALM

TECHNICAL SKILLS:

ETL Tools: Informatica, Data Stage

BI tools: Microstrategy, SAP Business Objects, Cognos, Actuate, Telerik

Databases: SQL SERVER 2012, Oracle 10g, Sybase, DB2, Teradata

Test Management tools: JIRA, HP Quality Center, TFS, ALM

Defect Tracking Tools: ALM, HP Quality Center, TFS

Operating Systems: Windows, Unix, Python

Project Methodologies: Agile-Scrum, Waterfall

PROFESSIONAL EXPERIENCE:

Confidential, New York, NY

ETL/DW/BI QA Lead

• Validating the Data Vault process and the existing Data flow from the multiple source systems into the Data Warehouse
• Validating the Legacy reports migration to the new Microstrategy reports by verifying the data completeness
• Created the comparison scripts for comparison the reports using python
• User story, Sub-tasks, test case and defect management in JIRA
• Documentation management in SharePoint
• Involved in creating the Test plan and Test approach for the project
• Actively participated in Daily Standup meeting, Sprint Planning meeting, Sprint Review meeting and Retrospective meeting
• Client Weekly Meetings to discuss the on-going testing status and to update the roadblocks.
• Report test status and results to stakeholders, collect metrics around test effectiveness and user stories/test cases execution.
• Work closely with management teams, development teams, business teams and other partner teams
• Define and manage quality assurance processes such as error/problem identify, root cause analysis, risk management, complexity analysis
• Expert in writing SQL queries through Oracle SQL Developer, SQL Server, Sybase

Environment: Oracle, SQL Server, Actuate, Cognos, Microstrategy, JIRA

Confidential, New York, NY

ETL QA Lead

• Created the Test Approach, Test plans, Test Estimations for the various projects in HRDW.
• Support the Project Stakeholders and involve in meetings.
• Knowledge sharing and status updates with offshore team members.
• Review the Test scenarios, Test cases and execution results done by the Offshore team.
• Involved in preparing Test Automation for Regression Suite and Data reconciliation using the Saturn tool
• Involved in Test Data preparation to be entered in Workday
• Worked in Data governance using Collabera on collecting the data of HRDW system and verified the workflow process on the creation and approvals
• Involved in verifying the performance testing of the existing Informatica jobs
• User story, Sub-tasks, test case and defect management in JIRA
• Documentation management in SharePoint

Environment: Sybase, Teradata, Workday, Business Objects, Unix putty, Collabera, Informatica

Confidential

ETL QA Lead

• Created the Test Approach, Test plans for the various projects in HRDW.
• Involved in preparing Test Automation for Regression Suite and Data reconciliation using the Saturn tool
• Involved in Test Data preparation to be entered in Workday
• Work with the offshore team members on the task tracking etc.
• User story, Sub-tasks, test case and defect management in JIRA
• Documentation management in Sharepoint

Environment: Sybase, Teradata, Workday, SAP Business Objects, Unix putty, Collabera, Informatica

Confidential

ETL Tester

• Worked in creating Test cases and involved in Test execution
• Involved in Test scenarios preparation
• Analyzed Business Requirements and developed test cases for complete end-to-end testing.
• Experience in writing SQL queries.
• Defect tracking until resolution and maintaining test data for the project.
• Detecting, classifying and reporting bugs through Defect Tracking System.
• Responsible for providing test status to management.
• Involved in Test Data Preparation and Optimization.
• Tracking & communicating test plans, test results, analysis, & unresolved problems.

Environment: Oracle, SQL Server, Informatica

Confidential

DWBI Tester

• Worked in creating Test cases and involved in Test execution
• Involved in Test scenarios preparation
• Analyzed Business Requirements and developed test cases for complete end-to-end testing.
• Experience in writing SQL queries.
• Defect tracking until resolution and maintaining test data for the project.
• Detecting, classifying and reporting bugs through Defect Tracking System.
• Worked on Data Stage upgrade for the projects
• Responsible for providing test status to management.
• Involved in Test Data Preparation and Optimization.
• Tracking & communicating test plans, test results, analysis, & unresolved problems.

Environment: DataStage, Sybase, HP ALM

Confidential

DWBI Tester

• Worked in creating Test cases and involved in Test execution
• Involved in Test scenarios preparation
• Analyzed Business Requirements and developed test cases for complete end-to-end testing.
• Experience in writing SQL queries.
• Defect tracking until resolution and maintaining test data for the project.
• Detecting, classifying and reporting bugs through Defect Tracking System.
• Worked on Data Stage upgrade for the projects
• Responsible for providing test status to management.
• Involved in Test Data Preparation and Optimization.
• Tracking & communicating test plans, test results, analysis, & unresolved problems.

Environment: Teradata (Toad), Oracle, Informatica