SUMMARY:

• A technically competent professional with 12+ years of experience in end - to-end Data Warehousing (ETL, DWBI) and Business Intelligence, data conversion, data migration Testing projects.
• Strong expertise in testing data warehouses.
• Experience working in different domains like Retail,Banking, finance, Life Science .
• Managed projects with peak size of 11.
• Experienced in all phases of the project life cycle including Requirements gathering, Test Planning, Test Design and Implementation.
• Proficient in Relational database Oracle, MS SQL Server SQL, Teradata, DB2, Data Warehousing concepts and ETL Concepts, Data quality and Data management.
• Extensive ETL testing using Data stage, SSIS and Informatica.
• Proficient in creating the Test Strategy, Test Plan, Traceability matrix, Test case and analyzing the Test result.
• Thorough knowledge on job scheduling tool Control M which includes running the jobs, validating the dependencies between jobs.
• Strong skills in back end testing using SQL queries to ensure data integrity and validate business rules.
• Extensive Experience in Quality Center which includes Release management, Requirement uploading, Preparation of Test cases, Execution of Test Cases, Logging Defects, Preparation of Metrics and Status reports and basic admin activities.
• Experience in JIRA, Microsoft Test Manager Tool set and ALM.
• Good understanding of testing using Agile/Scrum methodologies, Quality Assurance life cycle - test development, scheduling, execution, automation and test defect management.
• Coded complex SQL to properly test the approved test cases for assigned projects.
• Communicated and interacted effectively and professionally with co-workers, management, customers.
• Complied with Diversity Principles, Corporate Integrity, Compliance Program policies and other applicable corporate and departmental policies.
• Experience in creating Source to Target Mapping documents.
• Experienced in planning and executing System, Integration, Functional Testing, Regression Testing, Performance, usability testing, batch testing, bug tracking and reporting and UAT Testing.
• Expertise in complete Software Testing Life Cycle (STLC) which includes test strategy preparation, test plan development, test case creation, test execution and bug tracking.
• Proficient in different types of testing - black box testing, white box testing, system integration, regression and performance testing.
• Good experience in preparing estimates, resource planning for projects and Internal Audits.
• Provided technical training on DW Concepts.
• Excellent organizational, analytical, problem solving and communication skills
• Demonstrated strong communication and interaction with the Clients, developers and business analysts.
• Proven skills in leading and mentoring teams, test management and meeting the testing deadlines.
• Experience managing, leading and testing multiple projects using Agile Scrum and waterfall methodology.
• Experience leading teams towards automation and performance using risk-based testing approach
• Has complete knowledge of testing-related artifacts, such as Test Plan, Test Strategy, Test Metrics, Test Summary Report, Defect Summary Report, and Design and Execution Status Reports. Preparing and facilitating the implementation of test plans.
• In depth Knowledge about Agile/SCRUM environment.
• In depth knowledge in troubleshooting and problem solving.
• Experience testing OLAP data warehouse and integrations/BI processes.
• Extensive Experience in Quality Center which includes Release management, Requirement uploading, Preparation of Test cases, Execution of Test Cases, Logging Defects, Preparation of Metrics and Status reports and basic admin activities.
• Expertise in Data warehouse concepts and technologies like OLTP, OLAP, Normalization/De-normalization, Data Models (Star/ Snow Flake Schemas), DataMart (Dimensions and Facts) and Reporting.
• Good understanding of Dimensional modelling, Dimensions, Facts, Star/Snowflake schemas, Online Transaction Processing Systems (OLTP), Online Analytical Processing Systems (OLAP), data mining and data migration capabilities.

TECHNICAL SKILLS:

Conceptual knowledge: Data warehouse Concepts

ETL Tools: Data stage, Informatica Power center,Oracle Warehouse Builder,SSIS.

Reporting Tool: Business Objects, Cognos, Microstartegy

Test Management Tool: Quality Center

Database: Oracle, MS SQL server,DB2,T SQL, Teradata,MY SQL

Scheduling Tool: Control - M Enterprise Manager

Other Tools: AQT, TOAD

Methodologies: Agile,Scrum, Waterfall

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Datawarehouse Test Lead (DWBI/ETL)

Responsibilities:

• Preparing detailed test strategy, test plan, test scripts and test cases by understanding the business logic and user requirements.
• Coordinated testing readiness effort, including creation of test plans, test cases and test scripts.
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution writing complex SQL.
• Work with process team to confirm business requirements associated with testing effort
• Analyzed the System Design Document, Software Specification Document and prepared System test plan by dividing the application into manageable units.
• Documented the requirements in the Requirements Module of Quality Center.
• Performed Traceability Matrix to fix discrepancies in BRD and Test plan.
• Clarified QA team issues and reviewed test plans and test scripts developed by development team and QA team to make sure all requirements have been covered in scripts and tested properly.
• Delegated QA meetings with the team and Project Management.
• Prepare RTM, Test Plan, Defect report status
• Conduct defect review meetings.
• Identifying and analyzing quality risks.
• Determining testing scope using risk-based testing approach.
• Ability to react to changing project plans and come up with creative alternatives.
• Preparing, managing time estimates and fixed bid deliverables (SOW).
• Reviewing supplier deliverables and providing feedback and direction.
• Assessing Risk to schedule, cost, or quality on project and testing engagement.
• Preparing and managing the project testing schedule
• Preparing and facilitating the implementation of test plans
• Participated in walkthrough meetings and defect report meetings periodically with the client.
• Recommended finely-tuned changes to meet all guidelines.
• Used strong time-management skills to juggle around multiple projects simultaneously.
• Initiated Defects review meetings with Developers and communicated with them for whole defect life cycle until the logged defect is closed and verified.
• Mentored new QA resources to understand the business process and our test methodologies.

Environment: Datastage8.5,Teradata 12.0,DB2,SSIS,Business Objects, Quality Center.

Confidential

ETL/BI Test Lead

Responsibilities:

• Requirements study in testing perceptive, understanding the functionality and scope of the application.
• Worked as lead for entire release.
• Involved in analysis of end user requirements and business rules based on given preliminary design documentation and working closely with tech leads and data analysts in understanding the current system.
• Involved in rigorous meetings with offshore testing team and DWH Lead to plan and implement the testing efforts.
• Functioned as the Onsite / Offshore coordinator and Team Lead
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution using Datastage.
• To understand the functionalities of the Business/Transactions
• Prepare RTM, Test Plan, Defect report status
• Conduct defect review meetings.
• Authoring Test cases for mapping functionality of the designed warehouse.
• Involved in complete verification of Data Harmonization/Migration.
• Identification and Management of Defects using Quality Center.
• Done active participation in conference-calls and meetings.
• Handled entire responsibility of verifying the code in Test environment by testing them in different environments before deployment of code in Production.
• Reviewed test results, issues and defects related to business units.
• Organized the timelines for executing jobs to refresh data across all databases .
• Provided support to offshore QA team by giving them knowledge transfer and helping them with closure of the defects.
• Established the process to load data from different sources.
• Drafted the complete systems testing plan, created all possible business scenarios with efficient data results.
• Designed automated test cases, test plans and executed tests using HP Quality Center.
• Maintained latest version of test cases in Quality Center and ensured that was well communicated within the team.
• Issue analysis and defect assignment to the development teams.
• Trained new team members and also mentored them to understand the business process along with testing of data.

Environment: DB2, Data stage, Microstartegy, HP Quality Center.

Confidential, New York, NY

DWH Test Lead

Responsibilities:

• Designed the entire testing plan, test case scenarios and test cases for the business application based on functional documents and user stories.
• Requirements study in testing perceptive, understanding the functionality and scope of the application.
• Authoring Test cases for mapping functionality of the designed warehouse.
• Involved in complete verification of Data Harmonization.
• Involved in complete verification of Data Migration.
• Identification and Management of Defects using Quality Center.
• Written SQL Queries extensively for Data validation.
• Done active participation in conference-calls and meetings.
• Created test cases for Staging area.
• Involved in complete verification of Staging area..
• Developed test plan and test lab for the projects to create and access requirements, defects, test cases and reports for the status.
• Report the current status of each module of testing phase to the client, highlighting the work completed along with the outstanding issues.
• Created and executed detailed test cases with step by step procedure and expected results and maintained the test logs, test reports, test issues, defect tracking using Bugzilla.
• Conducted test case reviews and presented the test cases/test scenarios to the team members for all iterations.
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Written complex SQL queries for data validation for verifying the ETL Mapping Rules.
• Tested Metadata of tables including the data types, constraints and default values on the columns.
• Involved in maintaining the test environments; with activities like requesting data loads, data base backups, restarting the servers, requesting the deployments, trouble shooting issues.
• Participated in daily SCRUM meetings and demonstrated the daily status of testing to the team.
• Inserted checkpoints where needed, to compare the current behaviour of the application being tested to its behaviour in the earlier version .

Environment: Oracle 10g,Teradata12.0,Informatica 8.6.1,Cognos, Quality Center.

Confidential

Sr ETL/BI tester

Responsibilities:

• Reviewed Business Requirement Documents (BRD) for accuracy and completeness of business requirements.
• Participated in preparation of test plans and updated bug status reports.
• Expertise in automating test cases.
• Wrote test cases and test plans for client based reporting application and its related data.
• Involved in Smoke, Integration and Functional Testing.
• Provided reliable, timely support of integration and performance testing processes.
• Involved in gathering, analyzing, distilling and clearly conveying complex information to business and project team members.
• Involved in analyzing the requests for new, enhanced, and modified systems, against user and business requirements.
• Conducted discussions and facilitate requirements gathering, process analysis, and application design sessions with company staff across all levels and functions
• Enhanced existing test scripts, provided documentation including QA reports.
• Created test scripts, performed System Integration testing, Regression testing and reviewed test results.
• Expertise in writing SQL queries, SQL scripts and performing Database testing.
• Exposure to all stages of SDLC, STLC and Defect Tracking.
• Created test plans and testing strategies.
• Actively participated in project status meetings.

Environment: Oracle, Datastage,Cognos,Quality Center.

Confidential

Sr ETL/BI tester

Responsibilities:

• Requirements study in testing perceptive, understanding the functionality and scope of the application.
• Authoring Test cases for mapping functionality of the designed warehouse.
• Created test cases for ODS, ETL to Fermat staging area and Reporting.
• Worked as module lead for entire release.
• Involved in complete verification of ETL and DQM modules.
• Preparation and updation of RTM and other internal tracking documents.
• Identification and Management of Defects using Quality Center.
• Written SQL Queries extensively for Data validation.
• Done active participation in conference-calls and meetings.
• Involved in Saudit check point meetings.
• Used Quality Center as defect tracking tool.
• Support the Business users for UAT once the SIT is completed.
• Created test cases for ODS, ETL to Fermat staging area and Reporting.
• Executing Queries on AQT (Advance Query Tool) to verify the Data.
• Written SQL Queries extensively for Data validation.
• Used Quality Center as defect tracking tool
• Wrote test cases and test plans for client based reporting application and its related data.
• Provided reliable, timely support of integration and performance testing processes.
• Testing Data stage ETL jobs using complex SQL queries.
• Used Data Stage Director to run and monitor the ETL job status.
• Reviewed log files for ETL jobs in Data Stage Director.
• Involved in gathering, analyzing, distilling and clearly conveying complex information to business and project team members.
• Used Mercury Quality Center to document issues found during the test automation process, suggested appropriate solutions and prioritized defects for resolution in coordination with the development team.
• Coordinated with the developers to resolve defects.
• Involved in documentation in order to maintain and run scripts for future enhancements.
• Participate in weekly meeting with the management team and walkthroughs.

Environment: Oracle,Datastage,Hyperion, Quality Center.

Confidential

ETL /BI Tester

Responsibilities:

• Analyzed the Business requirements and developed Test cases based on functional requirements, general requirements and system specifications
• Exclusively involved in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results.
• Worked as ETL/BI Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project
• Experienced in writing complex SQL queries for extracting data from multiple tables
• Tested to verify that all data were synchronized after the data is troubleshoot and also used SQL to verify/validate test cases.
• Wrote SQL queries to validate source data versus data in the data warehouse.
• Authoring Test cases for mapping functionality of the designed warehouse.
• Involved in complete verification of ETL,BI module.
• Preparation and updation of RTM and other internal tracking documents.
• Created test cases for ODS, ETL, BI module.
• Exporting test cases to Test Director
• Preparation of Data Requirements.
• Updated Test Cases with respect to requirements.
• Uploaded all test cases and test steps to Test Director for maintaining centralized repository.
• Validated and verified the applications against business rules and product specifications.
• Extensively involved in System and Regression Testing.
• Full filled Requirement Traceability Matrix using Test Director.

Environment: Oracle,Datastage,Crystal Reports,Test Director.