SUMMARY

• 7 years 8 months of extensive experience in the area of Data warehousing and ETL QA and Web based Testing which consists of strong knowledge and experience in all SDLC and STLC layers.
• 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, Job Aids, 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 Confidential 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)

ETL Tools: Informatica Powercenter8.6, Abinitio GDE 3.1.7.3

BI Tools: Cognos 8Open source: Jira

Other Tools used: Bugzila, ALM, IBM Clear Quest, MS Office, Star Team Toad, Putty, UC4 (Job Scheduling tool), Aqua Studio

DBMS: Oracle, DB2, Teradata

PROFESSIONAL EXPERIENCE

Confidential, Foster City CA

RESPONSIBILITIES:

• Effort estimation of the forecasted work based on High level scope.
• Managing effort and task distribution between team Members.
• Mentoring Team members.
• 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.
• Contribution to Knowledge Management initiatives.

Confidential

RESPONSIBILITIES:

• Effort estimation of the forecasted work based on High level scope.
• Managing effort and task distribution between team Members.
• Mentoring Team members.
• 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.
• Contribution to Knowledge Management initiatives.
• Contributed to the testing of JIRA implementation

Confidential, Cincinnati OH

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, Detroit MI

RESPONSIBILITIES:

• Web based Testing for the GM applications
• Cognos Report Testing
• 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.
• SPOC for the lessons learned and issues encountered in all the projects across GM (Center of Excellence)