SUMMARY:

• Solutions - focused BI QA Lead with 9+ years of experience in the area of ETL Testing, Data Analysis, Report testing and Data Warehousing, which consists of strong knowledge and experience in SDLC and STLC.
• Combined technical qualifications with expertise in Test management, Testing and Quality improvement.
• Strong foundation in SQL Server, Oracle, UNIX, Teradata and good knowledge of ETL tools like AB INITIO and Informatica.
• Experience in Data analysis, Business requirements gathering and documentation.
• Experience in various domains including insurance, banking and telecommunication.
• Experience in Waterfall as well as Agile methodologies.
• Extensive testing experience including System Integration, End-to-End, User Acceptance Testing (UAT) and Report testing (GUI Testing, Field Validation Testing, and Functionality Testing). Experience in documenting all phases of QA process and Release management and supporting UAT.
• Involved in preparation of Requirement Traceability Matrix (RTM), Defect Report, and Weekly Status Reports, Checklists, Test Readiness Review Documents, Test Summary Reports and RCA document.
• Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts and Execution.
• Experience in leading teams with up to 10 members in an onshore-offshore model.
• Proficient in Black Box/White box testing techniques.
• Expertise in test management using HP Quality Center (ALM now)
• Excellent analytical, facilitation skills together with good written and verbal communications and time management skills

TECHNICAL SKILLS:

Hardware / Platforms: Windows 98/XP/ 2000/2003/2007 , Unix.

Technology: Informatica 8.6.1, Sales force, Micro Strategy, Cognos, Enterprise Architect, Ab Initio

Test Management Tools: HP QC, Rally, Microsoft ePMO

Programming Languages: Java, PLSQL

Databases: Oracle 9i, Netezza, Teradata, SQL Server

Scripting Languages: HTML, XML, Unix MS Visual Source Safe (VSS), Tortoise SVN.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• Leading a team of 6 testers Confidential offshore and working with business and development team to understand the business, functional and technical requirements.
• Ownership of preparing Functional/UAT Test Strategy, Test Plans, Test estimation and walkthrough the same with Business and Project Stakeholders for Approvals
• Analysis and understanding of source data for business requirement documentation. Creating report requirement document.
• Creating data mapping document based on analysis of pattern and correlation amongst the various data elements
• Participate and provide views in the preliminary and detail design reviews.
• Managing effort and task distribution between team Members and monitoring their work.
• Developing Risk Mitigation plans for various Test cycles
• Creating Test Closure report for various release for sign-off.
• Analysis and Management of Test Data to be used for Testing across the flow.
• Conducting Functional and Regression testing.
• Defect Reporting and Metric Analysis and RCA document.prepration.
• Presentation of Test Results and Test findings Report to the Project and Business Teams.
• Use available tools for automation of testing activities.
• Status reporting and co-ordination with multiple customers and project team

Confidential

Responsibilities:

• Leading a team of 4+ testers and working with business and development team to understand the business functional and technical requirements.
• Ownership of preparing Functional/UAT Test Strategy, Test Plans, Test estimation and walkthrough the same with Business and Project Stakeholders for Approvals
• Managing effort and task distribution between team Members and monitoring their work. Participate and provide views in the preliminary and detail design reviews.
• Review test cases and test scripts for the defined requirements.
• Presentation of the above stated deliverables to the Project and Business Teams.
• Conducting Functional and Regression testing to ensure defect free release.
• Defect Reporting and Metric Analysis RCA document.prepration..
• Presentation of Test Results and Test findings Report to the Project and Business Teams.
• Status reporting and co-ordination with customers and project managers.
• Use available tools for automation of testing activities.
• Conducting Knowledge transfer sessions.

Confidential

Responsibilities:

• Leading a team of 6+ testers and working with business and development team to understand the business functional and technical requirements.
• Managing effort and task distribution between team Members and monitoring their work. Providing estimates for the deliverables planned.
• Participate and provide views in the preliminary and detail design reviews.
• Creating Test strategy and Test Plan documents to ensure coverage of entire scope.
• Creating test cases and test scripts for the defined requirements.
• Review test cases and test scripts.
• Presentation of the above stated deliverables to the Project and Business Teams.
• Conducting Functional and Regression testing to ensure defect free release.
• Defect Reporting and Metric Analysis.
• Presentation of Test Results and Test findings Report to the Project and Business Teams.
• Status reporting and co-ordination with customers and project managers.
• Conducting Knowledge transfer sessions.

Confidential

Responsibilities:

• Requirement understanding and identifying QA scope.
• Effort estimation of the forecasted work based on High level scope.
• Participate and provide views in the preliminary and detail design reviews.
• Writing Test Plan, Test Cases and ensure coverage of entire scope.
• Conducting Functional, regression and Integration testing to ensure defect free release.
• Testing the transformation logic and finding the root cause of reported failures of ETL mappings.
• Defect Reporting and Metric Analysis.
• Presentation of Test Results and Test findings Report to the Project and Business Teams.
• Testing of Post production change requests and emergency fixes.
• Status reporting and co-ordination with customers.
• Contribution to Knowledge Management initiatives.

Confidential

Responsibilities:

• Requirement understanding and identifying development and QA scope.
• Planning for deliverable and providing estimations.
• Writing SQL procedure for data migration from legacy system to Oracle DB.
• Writing Test Cases and ensure coverage of entire testing scope.
• Conducting Functional, regression and Integration testing to ensure defect free release.
• Defect Reporting and Metric Analysis.
• Presentation of Test Results and Test findings Report to the Project and Business Teams.
• Testing of Post production change requests and emergency fixes.
• Status reporting and co-ordination with project management.
• Creation of documents for Project team and Knowledge sharing.

Confidential

Responsibilities:

• Requirement understanding and identifying scope.
• Analyzing various source application to identify the root cause of the issue.
• Providing high level solutions to the identified issues.
• Writing Test Cases and ensure coverage of entire testing scope.
• Conducting Functional, regression and Integration testing to ensure defect free release.
• Defect Reporting and Metric Analysis.
• Testing of Post production change requests and emergency fixes.
• Status reporting and co-ordination with project management.
• Creation of documents for Project team and Knowledge sharing.