PROFESSIONAL SUMMARY:

• Around 10 years of Experience Quality Assurance, testing process, Testing methodologies and strong experience on STLC and overall testing approaches
• More than 6 years of experience in Data Warehouse/Data mart implementations teamed with Analysis, requirements gathering, Effort Estimation, ETL Design, development, System Integration testing, Implementation and UAT support
• Strong in Data Warehousing concepts as well as methodologies, Star Schema and Snowflake Schema dimensional models .
• Experience in Insurance and Healthcare domain.
• Experience in testing of various data sources like database,Teradata, xml, Excel and Text files.
• Experience in ETL automation using QuerySurge/DVO.
• Worked on Liberty Mutual Insurance’s inhouse ETL automation tool DVR tool
• Good Knowledge on Oracle, Teradata, SQL Server Database and Greenplum
• Experienced in testing reports using Business Intelligence (BI) Tools like MicroStrategy, Cognos, SSRS.
• Expertise level knowledge in entire software development life cycle (SDLC) process from business analysis to development, testing, deployment, documenting, maintaining and user training, experience on AGILE and SCRUM design methodologies
• Strong ETL testing experience and SQL testing experience.
• Excellent experience in preparing Test plan document which includes test strategy.
• Expertise in creating the test data for Extraction and Transformation processes and resolved critical data issues by following the data standards of the project.
• Involved in end to end QA artifacts Preparation from Master Test Plan to Test Closure Summary
• Working closely with Business team for deploying solutions and sound experience in working closely with client for UAT validation.
• Woked on a POC of Big Data.

TECHNICAL SKILLS:

Databases: Oracle 10g, Oracle 11g, SQL Server 2005, SQL Server 2008, Greenplum

ETL Tools: Informatica, Micro strategy and MSBI

Reporting Tools: Cognos, Microstrategy

MS Office: Word, Access, Power Point, Excel

Operating Systems: Windows 95/98/2000/XP

ETL Automation Tools: Platinum ( Confidential in - house tool)

Testing Management Tools: HP Quality Center, ALM

PROFESSIONAL EXPERIENCE:

Confidential, USA

ETL QA Lead

Responsibilities:

• Excellent Coordination in managing multiple project teams from onshore.
• Providing QA estimates for all the Test deliverables
• Expertise in QA artifacts preparation from Master Test Plan (Contains the overall Testing Activities and testing strategy to be covered) till Test Closure Summary.
• Extracting Data from Heterogeneous Sources and processing them to staging layer.
• Extensively tested ETL part, using SQL queries for consistency and errors while extracting and transforming/ loading the data.
• Validated the data at each stage, from source table to staging tables and then finally to destination tables.
• Worked in both Data Warehouse Models (Star and Snowflake Schema)
• Sound Experience in implementing ETL automation using QuerySurge
• Validating the data by applying all business rules and processing data till the BASE layer.
• Creating SQL scripts to be executed on SQL Developer and doing a source to target validation
• Posting the issues identified to all the stakeholders
• Keeping Track of Defects
• Communicating with Dev. Leads, BA’s, Project manager, offshore team and onshore regularly and ensuring project deliverables or on Track
• Good experience of working in onshore offshore model
• Participation in daily QA scrum meetings.
• Preparing the daily status, defect reports and reviewing them with stake holders
• Experience in all QA life cycle testing.

Environment: Teradata, Informatica, JIRA.

Confidential, USA

ETL QA Lead

Responsibilities:

• Coordination in managing multiple project teams.
• Providing QA estimates for all the Test deliverables
• Expertise in QA artifacts preparation from Test Plan (Contains the overall Testing Activities and testing strategy to be covered) till Test Closure Summary.
• Involved in all phases of testing (System, UAT, Prod checkout)
• Extracting Data from Heterogeneous Sources and processing them to staging layer.
• Extensively tested ETL part, using SQL queries for consistency and errors while extracting and transforming/ loading the data.
• Experience in ETL automation using DVO
• Validated the data at each stage, from source table to staging tables and then finally to destination tables.
• Worked in both Data Warehouse Models
• Sound Experience in validating high volume of XML data.
• Validating the data by applying all business rules and processing data till the BASE layer.
• Creating SQL scripts to be executed on SQL Developer and doing a source to target validation
• Posting the issues identified to all the stakeholders
• Keeping Track of Defects
• Good experience of working in onshore offshore model
• Preparing the daily status, defect reports and reviewing them with stake holders
• Experience in all QA life cycle testing.
• Participated in Daily QA Scrum with QA manager to discuss the QA updates.
• Experienced with ALM for managing the defects and querying the ALM for pulling Defect status reports.

Environment: Oracle, SSIS, Microstrategy, HP ALM.

Confidential, USA

Senior ETL tester

Responsibilities:

• As an ETL QA Analyst, tested ETL (Informatica) mappings for each extract in the Informatica Designer
• Extensively tested ETL (Informatica) part, using SQL queries for consistency and errors while extracting / transforming / loading the data.
• Validated the data at each transformation. From source table to staging tables and then finally to destination tables.
• Developed SQL queries to validate data in IODS, Data warehouse and Data mart.
• Validated report data by writing and executing SQL queries against the data base.
• Created Test Plan, Test cases and Test Scripts using Rational Test Manager.
• Validated the data at each stage, from source table to staging tables and then finally to destination tables.
• Worked in both Data Warehouse Models (Star and Snowflake Schema)
• Developed SQL queries to validate data in Data warehouse and Data mart.
• Validated reports generated from Hyperion Essbase.
• Validated report data by writing and executing SQL queries against the Mart data base.
• Performed System Integration, User Acceptance and Regression Testing.
• Tested the drill through functionality by writing SQL queries and match it against the fact tables

Environment: Teradata SQL Assistant, HP ALM, Informatica and Microstrategy.

Confidential

Senior ETL tester

Responsibilities:

• Expertise in QA artifacts preparation from Master Test Plan (Contains the overall Testing Activities and testing strategy to be covered) till Test Closure Summary.
• Extracting Data from Heterogeneous Sources and processing them to staging layer.
• Validating the data by applying all business rules and processing data till the BASE layer.
• Creating SQL scripts to be executed on Teradata SQL Assistant and doing a source to target validation
• Posting the issues identified to all the stakeholders
• Keeping Track of Defects
• Communicating with Dev. Leads, BA’s, Project manager, offshore team and onshore regularly and ensuring project deliverables or on Track
• Participation in daily QA scrum meetings.
• Writing the test cases covering the complete requirement logic.
• Preparing the daily status, defect reports and reviewing them with stake holders

Environment: Teradata SQL Assistant, Greenplum, Microstrategy, HP Qulaity Center, Cognos and Informatica.

Confidential

ETL Tester

Responsibilities:

• Designed Test cases based on the Business functional definition documents and also reviewed the test cases written by the peers. (Also referred Source to Target Detailed mapping document & Transformation rules document).
• Extensively performed DATA validation using SQL queries and back-end testing
• Used SQL for Querying the database in UNIX environment
• Developed test cases for ETL process and reporting.
• Performed various levels of testing in all stages of the SDLC, Involving Requirements, Design, and Development teams to implement the requirements.
• Developed and Performed execution of Test Cases manually to verify the expected results
• Used Quality Center for creating defect and reviewing defects. Also pulling the defect report status and analyzed it.
• Preparation of various test documents for ETL process in Quality Center.
• Optimizing/Tuning several complex SQL queries for better performance.
• Created and executed test cases for ETL jobs to upload master data to repository.
• Involved in providing training to the team members on the enhancements in the application
• Create and execute test scripts, cases, and scenarios that will determine optimal system performance according to specifications.

Environment: SSIS, SSRS, SSAS, SQL Server 2008, HP Quality Center.

Confidential

Test Analyst

Responsibilities:

• Writing test plans and test scripts
• High Level Test Case Design and writing detailed test cases
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Involved in functional, system, integration and regression testing.
• Used JIRA for creating defect and reviewing defects. Also pulling the defect report status and analyzed it.
• Defined the Scope for System and Integration Testing
• Prepared Test summary documents from the test results recorded and escalating and troubleshooting if any issues.
• Reported periodic project status and updates to the QA Lead and QA Manager

Environment: Windows XP, SQL Server 2003, Manual Testing.