SUMMARY:

• Solutions - focused QA tester with 9 years of experience in the area of Data Warehousing and ETL QA and Web based Testing which consists of strong knowledge and experience in SDLC and STLC layers .Strong foundation in Abinitio, Informatica, DB2, Oracle, Unix, Teradata, Sql Server and Web based testing
• Leading a team of 5 testers at offshore and working with business and development team to understand the business requirements and POC for the Integration and E2E testing. Fully involved in Estimation and Business walkthroughs, creating Test Strategy for the project and reviewing Test Plan and Test Cases by offshore team.
• Good business knowledge in domains Electronic Payments (Banking), Retail, Automobile, Insurance.
• Strong hands on experience on ETL tools like Abinitio and Informatica.
• Proficient in testing AB Initio continuous graphs which interact with Federated Query layer via XML.
• Experience in leading teams with up to 10 members to ensure quality and defect free deliverables.
• Involved in preparation of Requirement Traceability Matrix (RTM), Defect Report, and Weekly Status Reports, Checklists, Test Readiness Review Documents, Test Summary Reports.
• Experience in Data Analysis, Test Data generation, Data Validation, Data Cleansing, Data Verification and identifying Data Mismatch.
• Proficient in Unix Shell Scripting, SQL, PL/SQL, complex Stored Procedures, Triggers.
• Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts and Execution
• Proficient in Black Box/White box testing techniques.
• Experienced in bug tracking using Clear Quest and JIRA for reporting the modification requests and collecting Test Metrics in order to keep track of the test progress and test execution.
• Expertise in test management using HP Quality Center (ALM now)
• Excellent analytical, multi-tasking, problem-solving, time-management & communication skills with particular emphasis on clearly communicating & documenting detailed Test Requirements & Tests.

TECHNICAL SKILLS:

Operating Systems: Windows 2003 server, UNIX (AIX ), HP UNIX

ETL Tools: Informatica Powercenter, Abinitio GDE

BI Tools: Cognos 10.2

SDLC Models: Waterfall, Agile

Other Tools used: ALM 12, IBM Clear Quest, Jira, MS Office, Star Team, Toad, Aqua Studio

DBMS: Oracle, DB2, Teradata and Sql Server

Confidential

QA Team

ROLES AND RESPONSIBILITIES:

• Leading a team of 5 testers at offshore and working with business and development team to understand the business functional and technical requirements.
• Managing effort and task distribution between team Members and monitoring their work.
• Estimation of the projected work.
• Participate and provide views in the preliminary and detail design reviews.
• Involved in Cognos Testing (The user Dashboard to generate reports).
• Writing Test strategy, Test Plan, Test Cases and ensure coverage of entire scope.
• Creating Test Closure report for every release for sign-off.
• Presentation of the above stated deliverables to the Project and Business Teams.
• Analysis and Management of Test Data to be used for Testing across the flow.
• Conducting Functional and Regression testing to ensure defect free release.
• Coordinating with performance and infra team for the big releases.
• Raising pre prod and prod tickets for code migration for every release.
• Involved in complex query preparation to pull data from production to qa environment and also to generate test data for functional, integration, regression and E2E testing.
• Defect Reporting and Metric Analysis.
• Presentation of Test Results and Test findings Report to the Project and Business Teams.
• Taken initiative to apply some automation script to do the Regression Testing.
• Status reporting and co-ordination with customers.

Confidential

QA Team

ROLES AND RESPONSIBILITIES:

• Leading a team of 4 testers at onshore and working with business and development team to understand the business functional and technical requirements.
• Managing effort and task distribution between team Members and monitoring their work.
• Participate and provide views in the preliminary and detail design reviews.
• Writing Test strategy, Test Plan, Test Cases and ensure coverage of entire scope.
• Presentation of the above stated deliverables to the Project and Business Teams.
• Analysis and Management of Test Data to be used for Testing across the flow.
• Conducting Functional and Regression testing to ensure defect free release.
• Involved in complex query preparation to pull data from production to qa environment and also to generate test data for functional, integration, regression and E2E testing.
• Testing the application using UNIX job scripts with database to dig out the minute most defects present in the code.
• Created a checklist for the smoke test to check the graph versions the patch of the graph and dependency on the graph.
• Defect Reporting and Metric Analysis.
• Presentation of Test Results and Test findings Report to the Project and Business Teams.
• Creating Data compare and data aggregation tools for data analysis
• Status reporting and co-ordination with customers.

Confidential

QA Team

ROLES AND RESPONSIBILITIES:

• Leading a team of 5 testers at offshore and working with business and development team to understand the business functional and technical requirements and POC for the integration testing.
• Effort estimation of the forecasted work based on High level scope.
• Managing effort and task distribution between team Members and monitoring their work.
• Participate and provide views in the preliminary and detail design reviews.
• Writing Test strategy, Test Plan, Test Cases and ensure coverage of entire scope.
• Presentation of the above stated deliverables to the Project and Business Teams.
• Analysis and Management of Test Data to be used for Testing across the flow.
• Conducting Functional, regression and Integration testing to ensure defect free release.
• Involved in complex query preparation to pull data from production to qa environment and also to generate test data for functional, integration, regression and E2E testing.
• Testing the application using ABINITIO GDE and UNIX job scripts with database to dig out the minute most defects present in the code.
• Created a checklist for the smoke test to check the graph versions the patch of the graph and dependency on the graph.
• Defect Reporting and Metric Analysis.
• Presentation of Test Results and Test findings Report to the Project and Business Teams.
• Presenting UAT packages to customer Finance Teams.
• Testing of Post production change requests and emergency fixes.
• Creating Data compare and data aggregation tools for data analysis
• Status reporting and co-ordination with customers.
• Contribution to Knowledge Management initiatives.

Confidential

QA Team

R OLES AND RESPONSIBILITIES:

• Effort estimation of the forecasted work based on High level scope.
• Participate and provide views in the preliminary and detail design reviews.
• Writing Test strategy, Test Plan, Test Cases and ensure coverage of entire scope.
• Presentation of the above stated deliverables to the Project and Business Teams.
• Analysis and Management of Test Data to be used for Testing across the flow.
• Conducting Functional, regression and Integration testing to ensure defect free release.
• Responsible for handling Change Request for existing ETL flows and testing the changes made on existing mappings and workflows which include transformations like lookups, sorter, aggregator, joiner, expression, update strategy, filter etc. through Informatica 8.6
• Testing the transformation logic and finding the root cause of reported failures of ETL mappings.
• Defect Reporting and Metric Analysis.
• Presentation of Test Results and Test findings Report to the Project and Business Teams.
• Testing of Post production change requests and emergency fixes.
• Creating Data compare and data aggregation tools for data analysis
• Status reporting and co-ordination with customers.
• Contribution to Knowledge Management initiatives.
• Contributed to the testing of JIRA implementation

Confidential

QA Team

ROLES AND RESPONSIBILITIES:

• Responsible for handling Change Request for existing ETL flows and testing the changes made on existing mappings and workflows which include transformations like lookups, sorter, aggregator, joiner, expression, update strategy, filter etc. through Informatica 8.6
• Testing the transformation logic and finding the root cause of reported failures of ETL mappings.
• Participate and provide views in the preliminary and detail design reviews.
• Writing Test strategy, Test Plan, Test Cases and ensure coverage of entire scope.
• Presentation of the above stated deliverables to the Project and Business Teams.
• Analysis and Management of Test Data to be used for Testing across the flow.
• Conducting Functional, regression and Integration testing to ensure defect free release.
• Defect Reporting and Metric Analysis.
• Presentation of Test Results and Test findings Report to the Project and Business Teams.
• Presenting UAT packages to customer Finance Teams.
• Testing of Post production change requests and emergency fixes.
• Creating Data compare and data aggregation tools for data analysis
• Status reporting and co-ordination with customers.

Confidential

QA Team

R OLES AND RESPONSIBILITIES:

• Web based Testing for the GM applications
• Cognos Report Testing
• Was given responsibility of the module lead in a project which consisted of 70 testing members.
• Participate and provide views in the BRS and SRS documents reviews.
• Writing Test strategy, Test Plan, Test Cases and ensure coverage of entire scope.
• Presentation of the above stated deliverables to the Project and Business Teams.
• Analysis and Management of Test Data to be used for Testing across the flow.
• Conducting Functional, regression and Integration testing to ensure defect free release.
• Defect Reporting and Metric Analysis.
• Presentation of Test Results and Test findings Report to the Project and Business Teams.
• Presenting UAT packages for customer and Finance Teams.
• Testing of Post production change requests and emergency fixes.
• Creating Data compare and data aggregation tools for data analysis
• Status reporting and co-ordination with customers.
• SCM Lead of couple of projects using Star Team and SVN
• SPOC for the lessons learned and issues encountered in all the projects across GM (Center of Excellence)