SUMMARY:

• 10 years of strong experience in carrying out Manual and Automation End to End Functional testing
• Worked on different Domains BNFS, Logistics and Healthcare.
• Excellent understanding of SDLC and STLC Concepts.
• Experience in preparing Traceability Matrix, Test plan, Test estimation.
• Having experience in automation testing using QTP, Selenium.
• Experience in Functional Testing, ETL Testing, GUI Testing, Regression Testing, UAT.
• Done data validation of the raw data getting from different sources.
• Good experience in ETL testing, Desktop Application.
• Good Experience in Defect Management Tools - Quality Center 10.0/ALM.
• Well-versed with all the stages of Defect Tracking Life Cycle.
• Good Knowledge of Data Warehouse & ETL Concepts and worked as ETL tester, having 5 years of relevant experience in ETL testing.
• Participated in the Review meetings to discuss about ongoing project with Team Members and Test Manager.
• Quick learner and excellent team player, ability to deliver on time and work efficiently.
• Working as a Test Lead and handling a team of 5 resources.
• Task allocation to the team members on daily basis and monitoring of tasks and reporting the status to onsite coordinators and managers.

TECHNICAL SKILLS:

Hardware: IBM Compatible PC, Mainframe, UNIX

Operating System: Windows 98, Windows XP

Programming Languages: C, C++, Java

Databases & Tools: Oracle 9i, SQL, Informatica cloud, JCL, DB2

Other Utilities: HP Quality Center, ALM, IBM Clear quest

PROFESSIONAL EXPERIENCE:

Confidential

ETL Test Lead

Responsibilities:

• Worked as ETL Test lead and handling team at offshore
• Compare data from source files & data stores to the target Data Warehouse or Big Data store.
• Validate different transformation logics as per the mapping document, if found any discrepancy then log defect in ALM
• Write store procedures
• Testing using soap UI
• System testing
• Attending stand up meetings
• Well versed with agile methodologies.
• ETL automation using informatica DVO

Environment: ETL/ Informatica cloud, Windows XP, Java, SQL, Oracle10, HP ALM

Confidential, Mclean VA

ETL Test Lead

Responsibilities:

• Worked as ETL QA on Mortgage domain
• Loan origination and Functionality covering (Loan processing, verification of Mortgage, Credit checking, Enquiries.
• Underwriting guidelines Mortgage Insurance
• Compare data from source files & data stores to the target Data Warehouse or Big Data store.
• Validate different transformation logics as per the mapping document, if found any discrepancy then log defect in ALM
• Write store procedures
• Done with Perl scripting so as to compare the source and target files,
• Onshore- offshore coordination
• Defect and test case management in ALM
• Requirement analysis of the new tasks
• Preparation of traceability matrix, Test plan and test case point estimation
• Creation of Test Scenarios and Test cases
• System testing

Environment: ETL/ Informatica cloud, Windows XP, Java, SQL, SQL server, Oracle10, Toad, ALM

Confidential, Charlotte, NC

Test Lead

Responsibilities:

• Compare data from source files & data stores to the target Data Warehouse or Big Data store.
• Validate different transformation logics as per the mapping document, if found any discrepancy then log defect in ALM
• Onshore- offshore coordination
• Defect management
• Requirement analysis of the new tasks
• Preparation of traceability matrix, Test plan and test case point estimation
• Creation of Test Scenarios and Test cases
• System testing
• Reporting Daily and weekly status of ongoing projects with team members, Onsite coordinators, Project Leads and Project Managers.
• Executing the test cases in ALM (Application life cycle management)

Environment: ETL/ Informatica cloud, SQL, Windows XP, Java, Talend, ALM

Confidential

ETL Test lead

Responsibilities:

• Worked as test lead and handle team of 5
• ETL testing using SQL and Informatica cloud as tool
• Validate the target output in Informatica cloud and check if the transformations used displays the correct output as required in Target table
• Validate different transformation logics as per the mapping document, if found any discrepancy then log defect in ALM
• Clean the data into common data format
• Done data validation (finding duplicate, null and blank spaces) from the raw data received.
• Compare the source and target data using data comparator tool.
• Execute the ETL job(s)/transformation(s).
• Requirement analysis of the new tasks
• Preparation of traceability matrix, Test plan and test case point estimation
• Creation of Test Scenarios and Test cases
• System testing
• Reporting Daily and weekly status of ongoing projects with team members, Onsite coordinators, Project Leads and Project Managers.
• Executing the test cases in ALM (Application life cycle management)

Environment: ETL/Informatica cloud, Windows XP, Java, SQL, SQL server, Oracle10, Toad, ALM

Confidential

ETL module lead

Responsibilities:

• Work as module lead and have individual module working on.
• ETL testing using SQL and Informatica as tool
• Validate the target output in Informatica and check if the transformations used displays the correct output as required in Target table
• Execute the ETL job(s)/transformation(s).
• Done data validation (Duplicate, null and blank spaces) from the raw data received.
• Clean the data and convert that data in common data format
• Requirement analysis of the new tasks
• Preparation of traceability matrix, Test plan and test case point estimation
• Creation of Test Scenarios and Test cases
• Integration Testing
• System testing
• Reporting Daily and weekly status of ongoing projects with team members, Onsite coordinators, Project Leads and Project Managers.
• Executing the test cases in QC
• Executing the Regression scripts using QTP 10.0

Environment: Informatica, ETL / Web, Windows XP, Java, Quality Center, QTP 10.0, SQL server, JIRA

Confidential

Test Analyst

Responsibilities:

• Work as individual contributor and handle a module independently
• ETL testing using SQL and Informatica as tool
• Validate the target output in Informatica and check if the transformations used displays the correct output as required in Target table
• Execute the ETL job(s)/transformation(s) and validate by writing SQL queries.
• Validate reports in Cognos and verified as per the requirements
• Requirement analysis of the new tasks
• Preparation of traceability matrix, Test plan and test case point estimation
• Creation of Test Scenarios and Test cases
• Integration Testing
• System testing
• Reporting Daily and weekly status of ongoing projects with team members, Onsite coordinators, Project Leads and Project Managers.
• Executing the test cases in ALM

Environment: Informatica, ETL / Web, Cognos, SQL Queries, Windows XP, Java

Confidential

Test Analyst

Responsibilities:

• Work as team member and have a team of 7 people
• Handle the task assign and report to my client manager
• Requirement analysis of the new tasks
• Preparation of traceability matrix
• Creation of Test Scenarios and Test cases
• Integration Testing
• System testing
• Reporting Daily and weekly status of ongoing projects with team members, Onsite coordinators, Project Leads and Project Managers.
• Executing the test cases in QC

Environment: Mainframe / Web, Windows XP, C# .Net, Quality Center, ETL, QTP