SUMMARY:

• Having 11 years of experience exclusively in the field of ETL Testing and Cognos & QlikView Reports Testing for Data warehousing & Business Intelligence across Health care and BFSI Domains
• Leading the offshore ETL testing team for a DW&BI project of a major Insurance client operating in agile environment.
• Involved in various phases of Data Warehousing projects and has experience in complete software engineering life cycle from requirements gathering through testing and maintenance
• Proficient in creating the Test Plan, Test Evaluation Summary, Test cases, Test scripts, Test Data and analyzing the Test Results
• Has gained expertise in functional testing methodologies that include Systems Integration Testing, User Acceptance Testing Support, Regression Testing, Release Testing and Post Production Validations for the ETL/BI systems
• Experience in Data Validation, Data Verification and has strong defect analysis and problem solving skills
• Comprehensive knowledge of ETL testing, Reports Testing, SQL and Agile practices.
• Worked on validations of SAS Extracts / Cognos & QlikView Reports generated on Data Ware house
• Expert in writing Complex SQL queries
• Worked with databases like Teradata, Oracle and DB2 and ETL tools like Informatica
• Mentored the newly joined resources about Agile Life cycle and about working in Agile environment
• Self - motivated and has the ability to go to the core of the problem, having good work ethics with good communication & interpersonal skills
• Has received several appreciation mails from both my Managers / Supervisor and the clients
• Optimized the Production checkout with the automation tool ‘Monthly Checkout Optimization (MCO)’ which reduced the manual efforts from 10 hours to 2 hours
• Trained the resources from other projects about Data warehouse Testing concepts and SQL writing
• Has been one of the Interview panelist for level 1 screening of candidates for ETL Testing openings
• Owned the process activities for Defects leakage prevention and Senior Management Review reports on monthly basis

TECHNICAL SKILLS:

Databases: Teradata V 12.0, Oracle 10g, Teradata Studio

ETL/BI Tools: Teradata SQL Assistant 12.0, Cognos 10.2, QlikView, Informatica Power Center 9.1, SAS Enterprise Guide 4.3, Oracle Sql Developer (Oracle 11g), Toad

Programming Languages: SQL, UNIX Shell scripting Basics

Operating Systems: Windows 2000/XP/Vista/7

Testing Management Tools: HP Quality Center, Application Life Cycle Management (ALM), Rally - Agile Test Management Tool

Domain: HealthCare, BFSI

PROJECT EXPERIENCE:

Confidential

Tools: Cognos, QlikView, Teradata Studio, HP QC, Rally, QTP

Responsibilities:

• Leading the offshore team and ensure all deliverables are met on time across all phases of testing right from Requirements gathering till Test closure.
• Reviewing Test plan and identification of Test scenarios for Integration Testing
• Responsible for reviewing every work done by Offshore team (test cases, Queries, validation logs, defects raised by team,.. etc)
• Identifying validations that could be automated andcome up with the action plan for developing the QTP script for the same by conducting discussions with the automation resources in the team
• Came up with the automation initiative to optimize the Production checkout ETL validations by merging the queries and making them run through the automation suite. This automation approach significantly reduced the QA manual efforts from 10 hours to 2 hours
• Providing testing estimates for the test items.
• Creating Test Execution Metrics to report the SIT Status day to day.
• Co-ordinate with Onsite counterpart and lead the daily status calls and discuss about upcoming milestones, bring up the issues / risks foreseenif any and follow up for the resolutions.
• Participate in the daily stand up call to update the status and discuss the issues if any.
• Following up on defects raised by team until closure.
• Preparation of KT plan for newly joined resources in the Team.
• Mentored the newly joined resources about Agile Testing practices
• Owning theprocess activities Defects leakage prevention and Senior Management Review

Confidential

Tools: Toad, Teradata Studio, ALM

Responsibilities:

• Involved in Requirement & Understanding phases across all Releases
• Involved in providing testing estimates for the test items.
• Involved in creating Test plan.
• Preparation of Test Cases and execution query.
• Involved in running the Informatica session and monitoring it.
• Identified the Test scenarios for Integration Testing
• Executed Oracle and Teradata SQL test queries to validate Referential Integrity between tables for each subject area across all phases of Data Movement.
• Responsible for reviewing every work done by System testing team (test cases, validation logs, defects raised by team and etc)
• Logged all defects in ALM that were encountered during manual validation and followed up until closure
• Attending daily status call to discuss the issues and to update the status.
• Created Daily Dashboard in ALM to report the SIT Status day to day.

Confidential

Tools: Teradata SQL Assistant, SAS

Responsibilities:

• Performed validations for Production loads on Daily, Weekly and Monthly basis using SAS Enterprise application
• Involved in Requirement & Understanding phase for Enhancements
• Executed Teradata SQL test queries to validate transformation rules used in source to target mapping.
• Extensively worked ETL scripts using Informatica/Teradata and Validating the data in the Teradata target DB.
• Created bug report to log all defects encountered during manual validation

Confidential

Tools: Oracle SQL Developer

Responsibilities:

• Involved in Requirement & Understanding phase
• Executed Oracle SQL test queries to validate transformation rules used in source to target mapping.
• Extensively worked ETL scripts using Informatica/Oracle and Validating the data in the Oracle target DB.
• Created bug report to log all defects encountered during manual validation

Confidential

Tools: Teradata SQL Assistant

Responsibilities:

• Involved in Requirement & Understanding phase
• Executed Teradata SQL test queries to validate transformation rules used in source to target mapping.
• Extensively worked ETL scripts using Informatica/Teradata and Validating the data in the Teradata target DB.
• Created bug report to log all defects encountered during manual validation

Confidential

Tools: Oracle SQL Developer

Responsibilities:

• Understanding the functionality using the Functional Specification Documents, Data Model, Data Mapping Specifications and Low level design and raising clarifications present if any in the clarification tracker and response updation through discussions with Onsite.
• Preparation of Test Cases by decomposing of requirements into testable functions, Execution templates to validate the accurate Upload of data from listed source systems (Core & Transactional data) through verification of data in the staging area and Query(taking in to consideration the transformation logics if any) for extraction of Data to feed the execution Templates.
• Preparation of queries for reconciliation of Data from source to target based on the Quantitative testing approach.
• Completion of planning effectively with good quality of Test wares.
• Day Zero verification with a checklist to ensure the expected resources to be in place in the test environment for start of test execution.
• Executing the test cases with proper sampling data meeting all the required scenarios of different permutations and combinations.
• Preparing defect report and tracking defects till closure.