PROFESSIONAL SUMMARY:

• An accomplished Data Warehouse testing professional, who has demonstrated success in testing various complex ETL projects, developed using Informatica and DataStage. I possess strong technical background with proven ability to test technologies that increase performance and positively affect the business. I have always delivered projects consistently meeting deadlines, exceeding the defined quality and performance.
• 12 plus years of cumulative experience in Information Technology and worked on various software testing projects which includes testing Database migration, Data warehouses and projects involving ETL applications.
• Have extensively worked on Data Warehouse/Data Mart/Data migration testing involving various databases like Oracle, Teradata, DB2, SQL Server and Netezza.
• Have been working on ETL and Data warehouse testing projects involving tools like Informatica, IBM DataStage and Microsoft SSIS.
• Worked on projects requiring Reports testing using tools like Business Object.
• Worked on Data warehouse testing where it is loaded by data from Operational data to ODS and Target DW tables.
• Data Warehouse/Data Mart/Data migration testing experience in HealthCare, Telecommunications, Retail, Supply Chain and Automobile domains.
• Excellent knowledge of Data Warehousing concepts including Dimension Modeling and different types of Slowly Changing Dimensions
• Expertise in running and monitoring DataStage and Informatica jobs.
• Expertise in writing complex SQL to test various transformations of ETL.
• Involved in EDW Enterprise Data warehouse projects from the conceptual, logical, physical modelling, creating Test strategy, Test Estimation and Test Plans/Test Cases based on Functional requirement documents, High Level Requirements, ETL data mapping and Data modelling documents covering all positive and negative testing scenarios.
• Extensive experience in Functional, System, Integration, Regression, Database Testing and User Acceptance Testing.
• Worked on Test management applications and defect tracking tools HP Quality Center, Rational Manual Tester and Rational Clear Quest.
• More than 7 years of experience in being a core resource in the team at onsite and leading offshore teams, Defect triaging, daily, weekly and sprint level status communication to stakeholders like Project Management, Business Analysts, Developers and Architects.
• Worked in different Testing Process like Agile testing process, Risk Based Testing, Component based Test modeling.

TECHNICAL SKILLS:

DBMS: MS SQL Server 2000, Oracle9i, DB2, MS Access, Teradata, Netezza.

Tools: Informatica, Data Stage, Clear Quest, HP Quality Center, TOAD, SQL Developer, PL/SQL Developer, SQL DBX, Teradata SQL Assistant, WinSCP, PUTTY, BO Reports.

Office Applications: MS - Visio, MS-Word, MS-Excel, MS-PowerPoint.

OS/Environment: Window, UNIX

Domain: Telecommunications, HealthCare, Retail, Supply chain and Automobile.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Quality Assurance Consultant

Environment: Windows XP, JIRA, SQL Server, Oracle, Microsoft Office, Pasa Logger, CDA (Chrysler Diagnostic Application)

Responsibilities:

• Test Planning and Effort Estimation. Actively involved during the Design phase of the project to be able to capture the test requirements with maximum coverage.
• Preparation of Test Strategy.
• Coordinate with the peer teams regarding testing activities and resolve issues.
• Participation in reviews and reporting review comments.
• Responsible for readiness of test environment.
• Triage the defects logged by test engineers, authoring test cases.
• Task allocation among team members to make sure team is optimally and efficiently utilized.
• Application knowledge transfer session to new team members at onsite.
• Stood as point of contact to client, Generated test execution/defects reports and participated in weekly / daily testing status meetings.
• Co-ordination for System Integration Testing including multiple Applications.
• Maintaining Process documents in SharePoint and making sure we do not have any non-conformances.
• Working in joint integration testing session with infrastructure providers such as Panasonic, Sirius XM and FCA IT team.

Confidential

Senior Quality Assurance Consultant

Environment: Windows XP, JIRA, SQL Server, DB2, Oracle, Informatica, Microsoft SSIS ETL tool, Microsoft Office

Responsibilities:

• Test Planning and Effort Estimation. Actively involved during the Design phase of the project to be able to capture the test requirements with maximum coverage.
• Preparation of Test Strategy and Test Artifacts.
• Data Validation using SQL.
• Preparation of Test completion report with the results of Data Validation.
• Coordinate with the different teams regarding testing activities and resolve outstanding test data issues.
• Participation in reviews and implementing the review comments.
• Triage the defects logged by test engineers, Test environment preparation and authoring test cases.
• Task allocation among team members to make sure team is optimally and efficiently utilized
• Application and Business knowledge transfer session to new team members at onsite.
• Generated test execution/defects reports and participated in weekly / daily testing status meetings.
• Present the validation report to the business users to acquire approval.
• Integration Testing of CPDM and EDW.
• Maintaining Process documents in SharePoint and making sure we do not have any non-conformances.

Confidential

Test Lead

Responsibilities:

• Test Planning and Effort Estimation. Actively involved during the Design phase of the project to be able to capture the test requirements with maximum Functional and Non Functional coverage.
• Preparation of Test Strategy and Test Artifacts templates.
• Coordinate with the different teams regarding testing activities and resolve outstanding test data issues.
• Participation in reviews and reporting review comments.
• Responsible to make sure the test environment is built to suit the project needs
• Triage the defects logged by test engineers, Test bed preparation and authoring test cases.
• Overseeing the task allocation among team members to make sure team is optimally and efficiently utilized
• Application and Business knowledge transfer session to new team members at onsite.
• Stood as point of contact to client, Generated test execution/defects reports and participated in weekly/daily testing status meetings.
• Having one on one with the team members and taking care of their appraisals
• Co-ordination for System Integration Testing including multiple Applications
• Maintaining Process documents in SharePoint and making sure we do not have any non-conformances.

Environment: Windows XP, HP Quality Center, DataStage, Mainframe, DB2, Netezza, UNIX.

Confidential

Test Lead

Responsibilities:

• Gathering and Analysis of Software Requirements and found gaps in requirements and design.
• Test Planning and Effort Estimation.
• Map the test scripts with requirements, Requirements Traceability in Rational Requisite Pro.
• Track and manage team’s productivity by different tracking tools and Metrics.
• Preparation of Test Strategy and Test Artifacts templates.
• Coordinate with the different teams regarding testing activities and resolve outstanding test data requirements.
• Participation in reviews and reporting review comments.
• Triage the defects logged by test engineers, Test bed preparation and authoring test cases.
• Distribution of test activities among team members.
• Attended QA Walk through meetings with team Member which includes technical specifications review, functional specifications review and defects tracking.
• Application and Business knowledge transfer session to new team members at onsite.
• Stood as point of contact to client, Generated test execution/defects reports and participated in weekly/daily testing status meetings.
• Involved in one on one to hear and resolve test engineers’ concerns and stood responsible in giving regular appraisal feedback to my Supervisor.
• Test execution and status reporting to project management on daily basis.

Environment: Windows XP, SQL Server, Teradata, Business Objects, Rational Manual Tester, DataStage

Confidential

Test Lead

Test Management Tool: Rational Clear Quest.

Responsibilities:

• Testing has been done to ensure the transformation rules required by the client have been properly applied in etl flow.
• Testing of various loading patterns such as delta loads and on- demand loads.
• Integration testing has been done to test the ETL jobs function in conjunction to its related jobs and systems.
• Responsible for the Test planning, Requirement analysis, Test case development, Test Script development, Test Reviews, Test execution and reporting.
• Created SQL test scripts based on the ETL mapping documents. Extensively worked on SQL Server and Oracle.
• Worked with various managers, business users, application owner, application support team and stakeholders to ensure the successful delivery of projects.
• Identified testing needs (application, environment, database etc.) before each testing and contacted responsible person/department/managers to provide all required access to team before testing get started.
• Participated in test plan reviews, test execution and test, reporting. Carefully understood the requirement and define the scope of testing based on resources and time line.

Environment: Windows XP, SQL Server 2005, Oracle, DB2, SAP, Rational Manual Tester, Informatica.

Confidential

Tester

Test Management Tool: Rational Clear Quest.

Responsibilities:

• Testing to ensure that the transformation rules required by the client have been properly applied in etl flow.
• Ensured various data load patterns such as delta loads and on demand loads.
• Integration testing to test the ETL job functions in conjunction to its related jobs and systems.
• End-to-End testing has been done to ensure the business requirements been applied in ETL.
• Executing the test scripts by validating source and target tables with the given transformation logic by using tools like SQL DBX, TOAD.
• Responsible for the Test planning, Requirement analysis, Test case development, Test Script development, Test Reviews, Test execution and reporting.
• Created SQL test scripts based on the ETL mapping documents. Extensively worked on SQL Server and Oracle.
• Working with various managers, business users, application owner, application support team and stakeholders to ensure the successful delivery of projects.
• Environment set up (application, environment, database etc.) before each testing and contacted respective person/department/managers to provide all required access to team before testing get started.
• Participated in test plan reviews, test execution and test status reporting.
• Carefully understood the requirement and define the scope of testing based on resources and time line.

Environment: Windows XP, Oracle, DB2, Rational Manual Tester, Informatica.

Confidential

Tester

Test Management Tool: Rational Clear Quest.

Responsibilities:

• Responsible for Test planning, Requirement analysis, Test case development, Test Script development, Test execution and reporting.
• Executing the test scripts by validating source and target tables with the given transformation logic by using tools like SQL DBX, TOAD.
• Testing has been done to ensure the transformation rules have been applied by data stage and it complies with the ones in Informatica.
• Ensuring various loading patterns such as delta loads, on demand loads, and various command tasks behaves the same way as they did in Informatica.
• End to end data validation is being done to ensure the transformation rules compliance by data stage jobs.
• Participated in test plan reviews, test execution and test status reporting.

Environment: Windows XP, Oracle, DB2, DataStage, Rational Manual Tester, Informatica.

Confidential

Tester

Test Management Tool: Rational Clear Quest.

Responsibilities:

• Requirement study and Analysis, Test Scenario preparation
• Test Case preparation based on design and requirements documents using Mercury Quality Center
• Peer - Review of Test Case, Test Data Preparation, Regression Test Plan Development and Test Lab creation using Mercury Quality Center
• Triaging Defects with the DEV team and Architects.
• Defect reporting and tracking using rational clear quest
• Participation in Knowledge Sharing session, requirement analysis and review meeting with client
• Generating test execution and defects reports from Quality Center and proving testing status to client on regular basis
• Participated in weekly team meeting to discuss test execution status and issues/blockers.
• Perform Post Migration Testing in Production environment after Production deployment

Environment: Windows XP, Oracle, SQL Server 2000, Rational Manual Tester, UNIX.

Confidential

Tester

Test Management Tool: Rational Clear Quest.

Responsibilities:

• Played tester as well as offshore Lead for a 4 member QA team.
• Responsible for Test planning, Requirement analysis, Test case development, Test Script development, Test Reviews, Test execution and reporting.
• Setting up of environment (application, environment, database etc.) and contacted responsible person/department/managers to provide all required access to team before testing get started.
• Co-ordination with onsite counterpart, Client Interaction on phone, mail and chat to understand new changes and rectifying doubts.
• Provided and knowledge transfer to the team on ETL Backend Testing.
• Identified Risk and Issues and resolved most from my level and escalated very few risk & issues to upper management.

Environment: Windows XP, Oracle, SQL Server 2000, Rational Manual Tester, Informatica.

Confidential

Tester

Test Management Tool: Rational Clear Quest.

Responsibilities:

• Played tester as well as offshore Lead for a 4 member QA team.
• Responsible for Test planning, Requirement analysis, Test case development, Test Script development, Test Reviews, Test execution and reporting.
• Setting up of environment (application, environment, database etc.) and contacted responsible person/department/managers to provide all required access to team before testing get started.
• Co-ordination with onsite counterpart, Client Interaction on phone, mail and chat to understand new changes and rectifying doubts.
• Provided and knowledge transfer to the team on ETL Backend Testing.
• Identified Risk and Issues and resolved most from my level and escalated very few risk & issues to upper management.

Environment: Windows XP, MS Access, Oracle, SQL Server 2000, Rational Manual Tester, Informatica.

Confidential

Tester

Test Management Tool: Rational Clear Quest.

Responsibilities:

• The testing activity was carried out by validating the transformation rules on the data loaded into various stages and target. All these stages were an integral part of SAP BI. Hence the testing was done by accessing the SAP BI and BEx-Analyser.
• Responsible for Test case development, Test Script development, Test Reviews, Test execution and reporting.
• Worked with managers, stakeholders to ensure the successful delivery of projects.
• Setting up of environment (application, environment, database etc.) and contacted responsible person/department/managers to provide all required access to team before testing get started.
• Quickly learnt and adapted to the SAP BI testing flow.
• Worked closely with peers at onsite on flexible timings to ensure the successful delivery of projects.

Environment: Windows XP, Oracle, SAP BI-BW, Rational Manual Tester, Informatica.

Confidential

Tester

Test Management Tool: Rational Clear Quest.

Responsibilities:

• Data Validation Testing of data from source database to Target application.
• Data Validation by referring to table mapping document and the business rule document. Data Completeness by row count validations. ETL Mapping Correctness by verification of data mapping from source to the target systems. Business Rule conformance by validation of source to target transformation rules.
• Responsible for Test cases development, Test Scripts development, Test Reviews, Test execution and reporting.
• Identified testing needs (application, environment, database etc.) before each testing and contacted responsible person/department/managers to provide all required access to team before testing get started.
• Provided / knowledge transfer to the fresher in team on ETL Backend Testing.

Environment: Windows XP, Oracle, Rational Manual Tester, Informatica.

Confidential

Tester

Test Management Tool: Rational Clear Quest.

Responsibilities:

• Data Validation Testing of data from source db to Target application.
• Data Validation by referring to table mapping document and the business rule document. Data Completeness by row count validations. ETL Mapping Correctness by verification of data mapping from source to the target systems. Business Rule conformance by validation of source to target transformation rules.
• Responsible for Test cases development, Test Scripts development, Test Reviews, Test execution and reporting.
• Identified testing needs (application, environment, database etc.) before each testing and contacted responsible person/department/managers to provide all required access to team before testing get started.
• Provided / knowledge transfer to the fresher in team on ETL Backend Testing.

Environment: Windows XP, Oracle, Rational Manual Tester, Informatica.

Confidential

Developer

Responsibilities:

• Understand Business Requirement Documents in terms of ETL data mappings.
• Developed ETL mappings to load Business Data warehouse.
• I was responsible for doing Unit testing for each developed module before merging it with application and fixing any Bug assigned by development manager.
• I was responsible for all backed and ETL related changes and Fixing issues.
• Responsible for Code review for own and Peers.

Environment: Windows XP, SQL Server, Informatica.

Confidential

Developer

Responsibilities:

• Understand Business Requirement Documents in terms of ETL data mappings.
• Developed ETL mappings to load Business Data warehouse.
• I was responsible for doing Unit testing for each developed module before merging it with application and fixing any Bug assigned by development manager.
• I was responsible for all backed and ETL related changes and Fixing issues.
• Responsible for Code review for own and Peers.

Environment: Windows XP, SQL Server, Informatica.

Confidential

Developer

Responsibilities:

• Understanding the Business Requirement Documents and break them to low level requirements.
• Responsible for coding, Unit testing of the modules before merging it with application, and fixing any bugs assigned by the development manager.
• Responsible for defects fixes.
• Perform Code review for self and Peers.
• Creation of requirement documentation and system maintenance document drafting.
• Work with project stakeholders to ensure the successful delivery of projects.

Environment: Windows XP, SQL Server, Java, J2EE