SUMMARY

• Over 8 years of experience in IT Industry and has been involved in all phases of SDLC (Analysis, Design, Development and Implementation) of various Data Warehouse.
• Extensively worked in Extraction, Transformation and Loading of data and in Cognos reporting.
• Worked extensively in Test management tool HP Quality Center.
• Involved in all phases of testing: Functional testing, System testing, Regression testing and UAT.
• Experienced in developing Test Strategies, Test Scenarios, Test cases based on the Business and System Requirements.
• Involved in managing offshore team and assigning work to the offshore team in daily basis and involved in conducting requirement traceability meeting.
• Experience in Unit, Integration, Interface, Functional, Regression, Compatibility, Acceptance, System Testing using Black Box and White Box methods.
• Expert in documentation, preparing Test Plans, Test Data, Test Scenarios, Requirements Traceability Matrix, and Bug Status reports from the Design Requirements Document and functional specifications.
• Involved in Ensuring Quality standards for the Cognos reports and validating the formatting features of the Cognos reports.
• Involved in validating complex Informatica transformation logics.
• Experience in different domains like Banking and Financial Services and Health Care.
• Experienced with Multiple Relational Databases including SQL, Oracle and MS Access.
• Tested complex Cognos reports in Report Studio and prepared test scripts..
• Experience in programming and debugging skills in SQL.
• Worked with different Databases like Oracle 10g/9i, MS Office.
• Quick learner and adaptive to new and challenging technological environments.

TECHNICAL SKILLS

BI Tools: Cognos 8.4(Report Studio, Query Studio)

ETL Tools: Informatica Power Center.

Languages: C, C++, Visual Basic V 6.0, HTML, JavaScript, PL/SQL, XML.

Test Management Tools: HP Quality Center 9.2

Documentation Tool: MS Office, Doors, Adobe Tools, MS Project, Visio Technical

Database Technologies: Oracle 9i/10g/11g, SQL Server, MS - Access

Operating Systems: Windows 95/98/NT/2000, MS-DOS

PROFESSIONAL EXPERIENCE

Confidential, Chicago

ETL QA Analyst

Responsibilities:

• Writing test cases for all the Informatica transformations logics and Business rules mentioned in the Business requirement document and Data Dictionary.
• Weekly Test case walkthrough with the business and incorporating the suggestions/modifications given by the business.
• Follow up with the business for getting the test approval before the test case execution for each source systems.
• Validating the target database after the first time History load and Daily Incremental load.
• Ensuring all the Subscribers cancelled before 3 years are purged in the target database after the weekly purge process.
• Preparing a weekly status report on every Fridays for tracking the effort spent in ETL testing and forwarding it to the business.
• Assigning the defects if any to the ETL development team and data architect team after the History and Incremental load.
• Attending the weekly defect tracking meeting with the business, ETL development team and data architect team and getting the ETA for the open defects.
• Creating the System Integration Testing and Regression Testing scripts for all the scenarios and uploading it in HP Quality Center.
• Updating the results of the test cases executed in HP Quality Center and validating the requirements traceability.
• Suggesting various solutions with respect to implementation approach and performance issues.

Environment: Informatica Power Center V6, Oracle 9i/10g/11g, HP Quality Center, Windows XP.

Confidential, Chicago

Data Warehousing QA Analyst

Responsibilities:

• Preparation of system and regression test cases for the Cognos reports.
• Validating the Cognos generated report against the Transaction Manager (TM) to make sure the Claims processed in the TM got populated in the report.
• Preparation of complex SQL queries to validate the report data against user requirements.
• Uploading test cases in Quality Center.
• Execution of test cases and tracking test case results.
• Performed regression testing and front end navigation testing for the reports.
• Updating the results of the test cases executed in Mercury Quality Center and validating the requirements traceability.
• Tracking the defect which rises in each phase in HP Quality Center and fixing the defect within the stipulated timing.
• Ensuring Quality standards for the reports.
• Reporting and updating the status of the project to the Business / IT SME on daily basis.

Environment: Cognos 8.4.1 (Cognos Report Studio, Query Studio), Oracle 9i/10g/11g, Transaction Management, HP Quality Center, Windows XP

Confidential, AZ

Data Warehousing QA Analyst

Responsibilities:

• Analysis on business requirements for testing purpose.
• Test case preparation for testing data sources and Cognos reports.
• Preparation of Oracle SQL queries to validate the report data against user requirements.
• Uploading test cases in Quality Center.
• Execution of test cases and tracking test case results.
• Updating the results of the test cases executed in Mercury Quality Center and validating the requirements traceability.
• Tracking the defect which rises in each phase in Mercury Quality Center.
• Ensuring Quality standards for the reports.
• Reporting and updating the status of the project to the Onsite Leaders on daily basis.

Environment: Cognos 8.3 (Cognos Report Studio, Query Studio), Oracle 10G, 11G, HP Quality Center, Windows XP

Confidential

Data Warehousing QA Analyst

Responsibilities:

• Analyzed the requirements, understood the functionality and documented the same for reference and future follow-through.
• Involved in preparing the unit test cases, system test cases and procedures, and testing all the components.
• Wrote SQL queries to validate the report data with respect to the user requirements.
• Involved in testing of reports developed in Cognos.
• Ensuring Quality standards for the reports which include Review Checklists.
• A key member in identifying the bottle necks involved in running the reports with respect to performance and data accuracy.
• Followed defect management procedures using quality center.

Environment: Cognos 8.3 (Cognos Report Studio, Query Studio), Oracle 10G, 11G, HP Quality Center, Windows XP