SUMMARY:

• 11 years of experience in ETL/Datawarehouse Testing, Mainframe testing, DB testing, SOA testing, Manual Testing(GUI)
• Consultant for Mainframe and ETL testing within the Organization.
• Core member in Mainframe/ETL testing technical interview panel
• Excellent Leadership skills and effective managing power.
• Expertise in Effort Estimation, Test planning, Test Strategy, approach, Resource planning and loading
• Hands on experience in managing large teams and multiple projects
• Expertise in Risk management, Issue Management, Defect management, report creation in project
• Expertise in SOA testing - Using SOAP UI tool
• Test planning and Test execution for mainframe, ETL/DW and GUI projects.
• Onsite offshore coordination with Status Calls, Metrics, Preparation of Daily, Weekly Execution status reports.
• Involved in preparing test environment and test data
• Expertise in writing/analyzing complex SQL queries
• Trained the team on ETL Testing & Mainframe Testing
• Mainframe coding(FTAL jobs) & prod deployment using Changeman
• Ensure that Quality of testing deliverables from Offshore Testing Team .Review and certify the testing artifacts for the project during the QA signoff
• Having excellent communication, Interact effectively with the Clients and documentation skills with interpersonal experience and ability to provide adequate guidance as required.
• Quick learner with an ability to rapidly achieve organizational integration, assimilates job requirements and employs new methodologies
• Comprehensive problem solving abilities, willingness to Learn, Team facilitator.
• Extensive skills in executing ETL scripts.
• Exposure in ETL automation tools like DVO, QuerySurge
• Strong Experience in System Testing, Data flow validation in Teradata/Data Stage and Destination DB, Regression Testing and giving support for UAT and production Implementation.
• Exposure in Automation Testing using QTP, MQ validation
• Involved in code analysis, coding standards and debugging.
• Exposure in SSAS and Cube Validation
• Work under CMMi Level 5 Guidelines.

TECHNICAL SKILLS:

• HP QC/HP ALM
• Teradata
• DB2
• SQL Server
• Informatica
• SAS
• DataStage
• SSIS(BIDS)
• SOAP UI
• JCL
• COBOL
• RQM
• RCQ
• Active Batch
• Quick Test Professional(QTP)
• Oracle
• Xpediter FileAid SPUFI TSO/ISPF VSAM
• Unix
• DVO
• QuerySurge

PROFESSIONAL EXPERIENCE:

Confidential

Test Lead

Responsibilities:

• Team management and proper task allocation
• Creation of Test strategy.
• Prepared Test Estimation
• Status Reporting, Preparation of Daily, Weekly Execution status reports.
• Onsite and Offshore co - ordination.
• Reviewing the Test cases & Defect Report.
• Trained the team on how to execute ETL jobs and its data setup
• Involved in Running ETL jobs
• SOA(Webservice) validation using SOAP UI tool
• Mainframe coding(FTAL jobs) & prod deployment using Changeman
• Involved in DB testing by writing complex SQL queries and validating the data in the backend using SQL queries
• Ensure that Quality of testing deliverables from Offshore Testing Team .Review and certify the testing artifacts for the project during the QA signoff

Confidential

Test Lead

Responsibilities:

• Handled multiple QA projects under ASDA(6 projects namely AMS K - Interface, CASH MI,OSCA MI, SUSI, Dynamic Waste Dashboard and ASP Web App Migration)
• Handled a team of size of 11 members
• Understanding the requirements.
• Creation of Test Plan and Test strategy.
• Involved in Test Design Estimation and Test Execution Estimation
• Onsite and Offshore co-ordination.
• Conducting Defect Triage meeting
• Task allocation and follow-ups
• Involved in environment setup.
• Status Reporting, Preparation of Daily, Weekly Execution status reports and Test Summary Report Preparation
• Reviewing the Test cases & Defect Report.
• Trained the team on how to execute Stored Procedures/ETL script and its data setup.
• Trained the team on how to execute Packages using Active Batch tool and SSIS tool.
• Trained the team on how to validate Cube using SSAS tool.

Confidential

Test Lead

Responsibilities:

• Understanding the requirements.
• Creation of Test Plan and Test strategy.
• Involved in Test Design Estimation and Test Execution Estimation
• Onsite and Offshore co - ordination.
• Involved in environment setup, Unix Testing, Database Testing & Mainframe Testing.
• Status Reporting, Preparation of Daily, Weekly Execution status reports.
• Test Summary Report Preparation.
• Reviewing the Test cases, Defect Report & Defect Tracking Process.

Confidential

Test Lead

Responsibilities:

• Understanding the requirements.
• Creation of Test Plan and Test strategy.
• Involved in Test Design Estimation and Test Execution Estimation
• Onsite and Offshore co - ordination.
• Involved in environment setup.
• Status Reporting, Preparation of Daily, Weekly Execution status reports.
• Reviewing the Test cases, Defect Report & Defect Tracking Process.

Confidential .

Senior Software Engineer

Responsibilities:

• Understanding the requirements.
• Creation and Execution of test cases for functional testing.
• Involved in writing the BATCH test cases
• Involved in Running mainframe jobs, Database testing and UI validation
• Onsite and Offshore co - ordination.
• Involved in environment setup.
• Status Reporting, Preparation of Daily Execution status reports.
• Reviewing the Test cases, Defect Report & Defect Tracking Process.

Confidential

Senior Software Engineer

Responsibilities:

• Understanding the requirements.
• Creation and Execution of test cases for functional testing.
• Involved in writing the BATCH test cases
• Involved in Running mainframe jobs, Database testing and UI validation
• Onsite and Offshore co - ordination.
• Involved in environment setup.
• Status Reporting, Preparation of Daily Execution status reports.
• Reviewing the Test cases, Defect Report & Defect Tracking Process.

Confidential

Test Analyst

Responsibilities:

• Understanding the requirements
• Creation and Execution of test cases for functional testing and Regression test.
• Involved in Code analysis.
• Involved in writing the BATCH test requirement
• Involved in Running jobs
• Onsite and Offshore co-ordination.
• Reviewing the Test cases
• Status Reporting, Preparation of Daily and Weekly reports.
• Reviewing the Test cases and Scenarios.

Confidential

Test Analyst

Responsibilities:

• Understanding the client requirements.
• Creation of test requirement.
• Creation and Execution of test cases for functional testing and Regression test.
• Involved in Code analysis.
• Involved in writing the BATCH test requirement
• Onsite and Offshore co-ordination.
• Reviewing the Test cases
• Status Reporting, Preparation of Daily and Weekly reports.

Confidential

Test Analyst

Responsibilities:

• Understanding the client requirements.
• Creation and Execution of test cases for functional testing and Regression test.
• Prepared test data and executed the test cases.
• Database Testing
• Involved in XML file validation.
• Onsite and Offshore co-ordination.
• Reviewing the Test cases, Defect Report & Defect Tracking Process
• Status Reporting, Preparation of Daily and Weekly reports.

Confidential

Test Analyst

Responsibilities:

• Understanding the client requirements.
• Creation and Execution of test cases for functional testing and Regression test.
• Prepared test data and executed the test cases.
• Database testing.
• Involved in Code analysis.
• Involved in BATCH job testing.
• Validating report and feeds in File Aid utility
• Involved in manual and automation testing.
• Onsite and Offshore co-ordination.
• Reviewing the Test cases, Defect Report & Defect Tracking Process
• Status Reporting, Preparation of Daily and Weekly reports.

Confidential

Test Engineer

Responsibilities:

• Understanding the client requirements.
• Creation and Execution of test cases for functional testing and Regression test.
• Prepared test data and executed the test cases.
• Database Testing
• Involved in Code analysis
• Involved in BATCH job testing
• Onsite and Offshore co-ordination
• Reviewing the Test cases, Defect Report & Defect Tracking Process
• Status Reporting, Preparation of Daily and Weekly reports