SUMMARY

• Skilled professional having 9 Years of experience in IT industry with experience in Manual Testing and ETL Testing.
• Excellent Testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies and disciplines.
• Good understanding of Data Warehousing concepts, Data Model (Star Flake and Snow - Flake Schemas).
• Expertise in ETL/DWH testing concepts and good understanding of the ETL tool (Datastage, Informatica).
• Proficient in Designing Test Cases, Execution of Test Cases, Logging bugs, tracking of bugs with module wise till closure.
• Good knowledge on Bug/Defect life cycle, Defect tracking and management.
• Types of Testing involved for various projects are Sanity Testing, Functional Testing, Regression Testing, Integration Testing, GUI Testing, Compatibility Testing and UAT.
• Involved from the Initiation of the Testing Project to the Closure Reports.
• Involved in the creation of Test plans and Test schedules.
• Proficient in coding using SQL.
• Knowledge on UNIX environment.
• Quick learner and excellent team player with good communication skills.
• Experience in validation of the Cognos Report/Query/Analytical Studio Report.

TECHNICAL SKILLS

ETL Tools: DataStage, Informatica

BI Tool: Cognos

Operating Systems: Windows XP/NT/2000, UNIX (HP, Solaris, AIX)

Databases: Oracle 10g/9i/8i, SQL-Sever

Testing Tools: Quality Centre (HP ALM), Beyond Compare

Web Languages: HTML & XML

Order Management System: IBM sterling commerce

PROFESSIONAL EXPERIENCE

Confidential, Cumberland, RI

Senior ETL QA Analyst

Responsibilities:

• Understanding the Business Requirements.
• Written the High level test scenarios and test cases to meet the business Requirement.
• Involved in Peer Review of the test cases, test condition and test scenarios.
• Execution of Test Scripts, Defects reporting and tracking by using ALM.
• Running the Batch jobs using the Control-M.
• Test Data preparation as per requirement.
• Preparation of SQL scripts to check the Data flow from the Source to Targets.
• Attended the triage calls with stake holders.
• Preparation of WSR/DSR
• Off shore /on site Co-Ordination.
• Used API's to validate IBM Sterling Commerce and validated Inventories in IBM Sterling Commerce web console.
• Coordinated the business team for UAT testing.

Environment: Informatica 9.0.1, Oracle 10g, HP ALM, Control-M, Oracle SQL Developer, UNIX, IBM Sterling Commerce

Confidential, Buffalo, NY

ETL /Data warehouse Test Analyst

Responsibilities:

• Understanding the Business Requirements and writing the test scenarios and test cases based on the business Requirement.
• Interacting with BA’s for any clarifications on the functionality.
• Involved in Peer Reviewing the test cases, test condition and test scenarios.
• Execution of Test Scripts, Defects reporting and tracking by using QC.
• Running the Batch jobs using the Control-M.
• Preparation Of Test data as per business scenario's.
• Preparation of SQL scripts to check the Data flow from the Source to Staging, Staging to Target Tables.
• Validated Cognos reports by preparing SQL queries.
• Preparation of WSR.

Environment: Data Stage 8.1, Cognos, Oracle 10g, QC 11(HP ALM), Control-M, Toad, UNIX

Confidential

ETL /Data warehouse Test Analyst

Responsibilities:

• Reviewed the HLD and BRD Documents to understand the Requirements.
• Prepared the test plan and Test Schedule Documents.
• Created and Executed Test cases using QC.
• Prepared complex SQL Queries to validate source and target Tables.
• Validate the source (SAS) Interface Files by using Unix Commands.
• Prepared reports such as status report, defect report for Project manager to track the project progress.
• Interacted with the development team to get the Defects resolved.
• Regular interaction with Onsite Coordinator to update testing status.
• Performed the Sanity, Regression Testing after every code release.
• Conducted team meetings to resolve issues during testing.
• Created Test Data to cover all the functional/Business test scenarios.

Environment: Data Stage 8.1, DB2 9.5, QC 9.2, Citrix Client, UNIX.

Confidential

Manual Test Engineer/ Database Tester

Responsibilities:

• Understanding Use Case Scenarios of Project UNO
• Prepared Business and Test Cases/Scripts.
• Created simple and complex SQL queries to validate Source and Target tables.
• Executed TC scripts using QC.
• Managed Defect life cycle and follow up in QC
• Interacted with onsite people on regular basis for project updates.
• Conducted the system testing successfully.
• Given KT to the new team members.

Environment: Aqua Data Studio 4.5, IBM DB2 8.1, IBM Data Studio 2.2.1, QC 9.2

Confidential

Manual Test Engineer

Responsibilities:

• Involved in writing the test scenarios and test cases against the business Requirement.
• Involved in Peer Reviewing the test cases, test condition and test scenarios against the business Requirement.
• Execution of Test Scripts and Preparation of Daily status Report.
• Defect Management.
• Responsible for providing training at client site, also provide the timely training on new functionalities received in change Request to team members.
• Running the SOD and EOD jobs using the UNIX.
• Prepared SQL scripts to check the back end database.
• Interacting with BA for any queries related to functionality.
• Interacting with Development team for timely resolve of issue.
• Query resolving of UAT team.

Environment: Oracle 9i, QC 9.2, Citrix Client, Toad, UNIX.

Confidential

ETL/Data Stage Test Engineer

Responsibilities:

• Understanding Functionalities as per the Client.
• Verifying the data in target database by ETL process
• Verified column mapping between source and target
• Prepared test data for functional & Integration testing
• Interactions with BA & Dev teams to resolve the issues.
• Reporting daily testing status.
• Designed, Reviewed & Executed Test cases.
• Identified Test cases for Regression testing
• Defect Analyzing and Reporting in QC
• Communication with client for Data management.
• Test case execution.

Environment: Data Stage 7.5.1EE, Oracle 9i, Sun Solaris, Quality Center 9.2

Confidential

ETL/Data Stage Test Engineer

Responsibilities:

• Analyzing the ETL Job flows and preparing test cases
• Running the jobs in Datastage6.0 and 7.5.1 versions taking screenshots
• Prepared TPD (Test plan document) and Test Cases
• Preparing Test plan based on Source to Target mapping sheets
• Involved in generating Test Scripts for System Testing, Integration Testing, Regression Testing and Acceptance Testing.

Environment: Ascential Data Stage EE 7.5.1(PX), Oracle, UNIX Script, Citrix Client, Quality Center 8.2