SUMMARY:

• Certified Tester having 10+ years of experience in Software Testing.
• Having 9+ years of experience in ETL & Report testing
• Domain Experience in Retail, Restaurant & Banking.
• Extensive experience in Preparation of Test Estimation, defining test strategy and test plan for DW projects.
• Hands on experience in white box testing.
• Extensive experience in test data setup based on business requirement.
• Extensively performed ETL (Informatica & AbInitio) Testing.
• Good understanding and experience of every phase of QA Life cycle, beginning with planning to the release of the product.
• Good analytical & problem solving skills & a quick - learner.
• Strong knowledge in databases (SQL SERVER, ORACLE,TERADATA)
• Possess good Experience in
• ETL Testing
• SAP Business Objects Report testing
• Functional Testing
• Manual Testing
• Database Testing
• SQL, UNIX, HP ALM,HP QC 10,ALM, Jira, TOAD, SQL Server, TeraData, Oracle

TECHNICAL SKILLS:

Database: Oracle, SQL Server, Teradata

Test Tools: HP Quality Center 10,HP ALM Jira, Putty, SQL Developer

Operating System: Windows, UNIX

ETL: AbInitio, Informatia, Business Objects 4.0

PROFESSIONAL EXPERIENCE:

Confidential

Tester/Test Lead

Responsibilities:

• Coordinating with Business & management teams in requirement gathering
• Involved in Requirement Analysis
• Come up with QA Estimation and QA planning for the releases
• Designing the test strategy and test plan
• Design & execution of test cases
• Creation of test data based on business requirement
• Validating Mapping designed - Transformation rules, Count & date mismatch.
• Entirely responsible for Planning & prioritization.
• Responsible for Test Plan & Test Strategy preparation
• Involved in tracking/resolving environmental and other issues
• Weekly Test status reports/updates to all the stakeholders
• Timely escalations on critical issues.
• Responsible for QA completion report & QA Sign off
• Test metrics collection & project postmortem & implementation of lesson learned
• Logged and tracked defects through Test Track
• Prepared the Daily status & weekly status Report
• Testing covered functionality and regression testing for the entire release.
• Actively participated in all phases of the testing cycle including reviews, inspections and Project status meetings

Tester/Test Lead

Responsibilities:

• Coordinating with Business & management teams in requirement gathering
• Involved in Requirement Analysis
• Come up with QA Estimation and QA planning for the releases
• Designing the test strategy and test plan
• Design & execution of test cases
• Creation of test data based on business requirement
• Validating Mapping designed l- Transformation rules, Count & date mismatch.
• Entirely responsible for Planning & prioritization.
• Responsible for Test Plan & Test Strategy preparation
• Involved in tracking/resolving environmental and other issues
• Weekly Test status reports/updates to all the stakeholders
• Timely escalations on critical issues.
• Responsible for QA completion report & QA Sign off
• Test metrics collection & project postmortem & implementation of lesson learned
• Logged and tracked defects through Test Track
• Prepared the Daily status & weekly status Report
• Testing covered functionality and regression testing for the entire release.
• Actively participated in all phases of the testing cycle including reviews, inspections and Project status meetings

Tester/Test Lead

Responsibilities:

• Coordinating with Business & management teams in requirement gathering
• Involved in Requirement Analysis
• Come up with QA Estimation and QA planning for the releases
• Designing the test strategy and test plan
• Design & execution of test cases
• Creation of test data based on business requirement
• Validating Mapping designed by Informatica tool- Transformation rules, Count & date mismatch.
• Entirely responsible for Planning & prioritization.
• Responsible for Test Plan & Test Strategy preparation
• Involved in tracking/resolving environmental and other issues
• Weekly Test status reports/updates to all the stakeholders
• Timely escalations on critical issues.
• Responsible for QA completion report & QA Sign off
• Test metrics collection & project postmortem & implementation of lesson learned
• Logged and tracked defects through Test Track
• Prepared the Daily status & weekly status Report
• Testing covered functionality and regression testing for the entire release.
• Actively participated in all phases of the testing cycle including reviews, inspections and Project status meetings

Environment:: Test Track, Informatica 10, SQL Server 2012, Teradata 15

Tester / Test Lead

Responsibilities:

• Coordinating with Business & management teams in requirement gathering
• Involved in Requirement Analysis
• Come up with QA Estimation and QA planning for the releases
• Designing the test strategy and test plan
• Design & execution of test cases
• Creation of test data based on business requirement
• Validating the Business reports against the source data systems.
• Entirely responsible for Planning & prioritization.
• Responsible for Test Plan & Test Strategy preparation
• Involved in tracking/resolving environmental and other issues
• Weekly Test status reports/updates to all the stakeholders
• Timely escalations on critical issues.
• Responsible for QA completion report & QA Sign off
• Test metrics collection & project postmortem & implementation of lesson learned
• Logged and tracked defects through Test Track
• Prepared the Daily status & weekly status Report
• Testing covered functionality and regression testing for the entire release.
• Actively participated in all phases of the testing cycle including reviews, inspections and Project status meetings

Environment:: Teradata 15.0, SAP Business Objects, HP ALM

Test Lead

Responsibilities:

• Coordinating with Business & management teams in requirement gathering
• Involved in Requirement Analysis
• Come up with QA Estimation and QA planning for the releases
• Designing the test strategy and test plan
• Design & execution of test cases
• Creation of test data based on business requirement
• Validating Mapping designed by Informatica tool- Transformation rules, Count & date mismatch.
• Entirely responsible for Planning & prioritization.
• Responsible for Test Plan & Test Strategy preparation
• Involved in tracking/resolving environmental and other issues
• Weekly Test status reports/updates to all the stakeholders
• Timely escalations on critical issues.
• Responsible for QA completion report & QA Sign off
• Test metrics collection & project postmortem & implementation of lesson learned
• Logged and tracked defects through Test Track
• Prepared the Daily status & weekly status Report
• Testing covered functionality and regression testing for the entire release.
• Actively participated in all phases of the testing cycle including reviews, inspections and Project status meetings

Environment:: Test Track, Informatica 8.6.0, SQL Server 2008

Test Lead

Responsibilities:

• Coordinating with Business & management teams in requirement gathering
• Involved in Requirement Analysis
• Leading a team of 10 resources and was responsible for overall QA deliverables of the team
• Come up with QA Estimation and QA planning for the releases
• Designing the test strategy and test plan
• Design, execute and review the test cases designed by the team
• Creation of test data based on business requirement
• Creation and execution of white box test cases for validation Abinitio Mappings.
• Validating Mapping designed by Abinitio tool- Transformation rules, Count & date mismatch.
• Feed file validation against Database Source by writing complex SQL Queries.
• Feed generation in UNIX environment
• Entirely responsible for Planning, prioritization and allocation of testing tasks to team members
• Project tracking and resource management
• Involved in User support activities
• Providing guidance to team members on project scope & day today testing activities
• Responsible for Test Plan & Test Strategy preparation
• Involved in reviewing test artifacts
• Involved in tracking/resolving environmental and other issues
• Weekly Test status reports/updates to all the stakeholders
• Timely escalations on critical issues.
• Responsible for QA completion report & QA Sign off
• Test metrics collection & project postmortem & implementation of lesson learned
• Logged and tracked defects through Quality Center
• Prepared the Daily status & weekly status Report
• Testing covered functionality and regression testing for the entire release.
• Actively participated in all phases of the testing cycle including reviews, inspections and Project status meetings

Environment:: SQL Developer, Quality Center 10, Putty, Abinitio, Win SCP, Teradata

Test Lead

Responsibilities:

• Coordinating with Business & management teams in requirement gathering
• Involved in Requirement Analysis
• Come up with QA Estimation and QA planning for the releases
• Designing the test strategy and test plan
• Design, execute and review the test cases designed by the team
• Creation of test data based on business requirement
• Creation and execution of white box test cases for validation Abinitio Mappings.
• Validating Mapping designed by Abinitio tool- Transformation rules, count &data mismatch.
• Feed file validation against Database Source by writing complex SQL Queries.
• Feed generation in UNIX environment
• Involved in User support activities
• Responsible for Test Plan & Test Strategy preparation
• Involved in reviewing test artifacts
• Involved in tracking/resolving environmental and other issues
• Weekly Test status reports/updates to all the stakeholders
• Timely escalations on critical issues.
• Responsible for QA completion report & QA Sign off
• Test metrics collection & project postmortem & implementation of lesson learned
• Logged and tracked defects through Quality Center
• Testing covered functionality and regression testing for the entire release.
• Actively participated in all phases of the testing cycle including reviews and Project status meetings

Environment:: SQL Developer, Quality Center 10, Putty, Abinitio, Win SCP, Oracle

Test Lead

Responsibilities:

• Validating Mapping designed by Ab Initio tool- Transformation rules, count mismatch, data mismatch.
• Feed file validation against Database Source by writing complex SQL Queries.
• Feed generation in UNIX environment
• Involved in the Test case preparation and execution Test Scenarios and Test Cases.
• Prepared Test Data for SIT Environments.
• Provided Clarifications to business users in terms of the functionality flow.
• Coordinating with Onsite Business & management teams in requirement gathering
• Involved in Requirement Analysis
• Come up with QA Estimation and QA planning for the releases
• Entirely responsible for Planning, prioritization and allocation of testing tasks to team members
• Responsible for Test Plan & Test Strategy preparation
• Involved in reviewing test artifacts
• Involved in tracking/resolving environmental and other issues
• Weekly Test status reports/updates to all the stakeholders
• Timely escalations on critical issues.
• Responsible for QA completion report & QA Sign off
• Test metrics collection & project postmortem & implementation of lesson learned
• Logged and tracked defects through Quality Center
• Prepared the Daily status & weekly status Report
• Testing covered functionality and regression testing for the entire release.
• Actively participated in all phases of the testing cycle including reviews, inspections and Project status meetings

Environment:: Jira, DTF, SQL Developer, Abinitio, Unix, SVN, Win SCP, Putty

ETL Tester

Responsibilities:

• Involved in the Test case preparation and execution Test Scenarios and Test Cases.
• Logged and tracked defects through Quality Center
• Prepared Test Data for SIT Environments.
• Provided Clarifications to business users in terms of the functionality flow.
• Prepared the Daily status Reports
• Testing covered functionality and regression testing for the entire release.
• Actively participated in all phases of the testing cycle including reviews, inspections and Project status meetings

Environment:: Abinitio, UNIX, SQL Server, Oracle, HP Quality Center 10

Tester

Responsibilities:

• Involved in the Test case preparation and execution Test Scenarios and Test Cases.
• Logged and tracked defects through Quality Center
• Prepared Test Data for SIT Environments.
• Provided Clarifications to business users in terms of the functionality flow.
• Prepared the Daily status Reports
• Testing covered functionality and regression testing for the entire release.
• Actively participated in all phases of the testing cycle including reviews, inspections and Project status meetings

Environment:: AS400, HP Quality Center 10

Tester

Responsibilities:

• Involved in the Test case preparation and execution Test Scenarios and Test Cases.
• Logged and tracked defects through Quality Center
• Prepared Test Data for SIT Environments.
• Provided Clarifications to business users in terms of the functionality flow.
• Prepared the Daily status Reports
• Testing covered functionality and regression testing for the entire release.
• Actively participated in all phases of the testing cycle including reviews, inspections and Project status meetings

Environment:: QC 9.2, SVN, Putty, SQL Developer

ETL Testern

Responsibilities:

• Validation of both Business Intelligence Reports and Actuate reports from backend.
• Validating Swift Messages (MT940 and MT942) and BAI messages against database.
• Validating Transformation rules, Count & data mismatch.
• Validating Stored Procedure (SP) and Views.
• Tested EOD, Intraday data for more than 200 Citi Bank branches across globe.
• Involved in the Test Case preparation and execution.
• Logged and tracked defects through Quality Center
• Prepared Test Data for SIT Environments by processing the feed file
• Module Tested -Security Warehouse, AML (Anti Money Laundry), PIP
• Daily interaction with the New Jersey Client and New Jersey Development Team.
• Provided Clarifications to business users in terms of the functionality flow.

Environment:: QC 9.2, Toad 7.6, Informatica 8.6.0, Ab Initio 1.13, BO XI, Putty, SQL Developer

Tester

Responsibilities:

• Involved in the test case preparation and execution Test Scenarios and Test Cases.
• Logged and tracked defects through Quality Center
• Prepared Test Data for SIT Environments.
• Tested Loan Origination, Management and Collection modules.
• Provided Clarifications to business users in terms of the functionality flow.
• Prepared the Daily status Reports
• Testing covered functionality and regression testing for the entire release.

Environment:: SVN, Putty, SQL Developer, Oracle, HP Quality Center 9.2

Tester

Responsibilities:

• Involved in the Test case preparation and Execution
• Involved in Defect analysis
• Tested the first Release of LL (Leverage Lending) for Functionality and Regression Testing.
• Carrying out back-end validation using SQL queries to validate the Results
• Prepared the Daily status Reports
• Actively participated in all phases of the testing cycle including reviews, inspections and project status meetings
• Carried out System integration for the release
• Testing covered functionality and regression testing for the entire release.

Environment:: SVN, Putty, SQL Developer, Oracle, HP Quality Center 9.2