SUMMARY:

• Software professional with 3 years of experience as Data warehouse & Business Intelligence (DWBI) Tester for Insurance Industries
• Worked on different new initiatives, existing project enhancement for various data warehousing projects.
• Expertise on Unit Testing, Functional Testing, System Integration Testing, Regression Test (SDLC).
• Responsible for Reports/Dashboard deliverables for the reporting projects which falls in Business Insurance, Bond & Financial Product and Personal Insurance Business Division.
• Good understanding of the Insurance Domain.
• Have good knowledge in “Cognos Report” Testing including Query Studio/Analysis Studio, Cube.
• Have good knowledge on various Data warehouse concepts like Data Extraction, Data Cleaning, Data Transformation, Data Loading, Refreshing, OLAP, OLTP, Schemas, Meta Data and Data Mart.
• Have good knowledge of “informatica” ETL tool, used it for data loading and mining.
• Used “Informatica” for database reporting.
• Have worked on “ETL” projects involving Cognos report which involve complete validation from source to target using Teradata.
• Performed Smoke Testing, System Integration Testing and Regression Testing of tables.
• Validation of Smoke Testing included DDL check, DUP check and Primary Key check to ensure tables are loaded correctly.
• Validation of source table by writing and executing queries in Teradata to ensure that data is populated correctly as per RDEM or business rules.
• Validation of target tables (facts and dimension tables) by writing and executing queries in Teradata to ensure data flows correctly from source to target based on business rules.
• Validation of the Cognos report by writing and executing queries to ensure data is populated correctly or through cross validation of reports.
• Validation of UI as well as data validation which included individual values and summation of data.
• Used RADAR (In house tool - Data testing framework (DTF)) which involves comparison of data across various platforms.
• Excellent Team player to work in conjunction with developers and other team members in validation and testing of complex project scenarios and in the maintenance of Quality Standards of projects.
• Have good knowledge on Test Management Tools such as HP Quality Center v 11.0.
• Automated validation of report with backend by modifying an existing tool.
• Ability to interpret business objectives, integrate industry best practices and understand technology, functions and systems, helping to accurately map user requirements towards application development and customization
• Understanding the client requirements by studying Business Requirement Document (BRD), Functional Requirement (FR) document, RTM.
• Preparing ROM and HLE based on Requirement Analysis.
• Preparing Test cases, SQL using Teradata and reviewing the Scripts and suggesting modification of scripts for validating workflows from source to target and Cognos Report validation.
• Preparing Query Log and having discussion with BA, DEV, Technical lead, SA.
• Preparing and conducting Walkthrough of Test Plan.
• Managing QC with all the necessary uploading to ensure everything is set before testing starts.
• Performing Smoke Test, System Integration Testing and Regression Testing.
• Validation of fact, dimension tables using SQL queries in Teradata.
• Validation of Front End UI and various Cognos Report against Backend.
• Analyzing and evaluating data issues and performing data analysis and reporting bugs in QC.
• Reporting to the business stakeholders about the status of the test activities on a daily
• Reported issues on an existing code running in production since a long time.
• Monthly Validation of tables and Report using automation (Production Checkout).
• Knowledge Sharing.

TECHNICAL SKILLS:

Functional Areas: Data Warehouse (Insurance)

Programming Languages: C,C++,SQL, Oracle, Object script,, JavaScript, XML PL/SQL

Operating System: Windows XP, Windows 7,Linux, Unix, Windows 95, 98, XP

Tools/ DB/ Packages: Cognos8.4,Cognos10.1, INFORMATICA,TERADATA, HP ALM(Quality Center), XL Comp, RADAR(DTF) - In house Tool, various other in house tools.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Test Engineer

• Consolidation of the enterprise wide data in one common warehouse to support management reporting and analysis.
• Release of monthly Management reports generated in Cognos 10.1 through Web BIIG Portal to the customers.
• Analytical tool interface (SST & SSC) to support data analysis for advanced business users.

Confidential, CT

ERA-Batch Cycle Redesign

• Team Member
• Onsite offshore coordination
• Prepare test cases
• System testing and Regression Testing,
• Defect Raising
• Testing, Discussion with BA, Dev Team, Onsite Co-ordinator.

Confidential

• Team Member
• Onsite offshore coordination
• Prepare test cases
• System testing and Regression Testing,
• Defect Raising
• Testing, Discussion with BA, Dev Team, Onsite Co-ordinator.

Confidential

• Team Member
• Onsite offshore coordination
• Prepare test cases
• System testing and Regression Testing,
• Defect Raising
• Testing, Discussion with BA, Dev Team, Onsite Co-ordinator.

Confidential

• Team Member
• Onsite offshore coordination
• Prepare test cases
• System testing and Regression Testing,
• Defect Raising
• Testing, Discussion with BA, Dev Team, Onsite Co-ordinator.

Confidential

• Team Member
• Onsite offshore coordination
• Prepare test cases
• System testing and Regression Testing,
• Defect Raising
• Testing, Discussion with BA, Dev Team, Onsite Co-ordinator.

Confidential

• Team Member
• Onsite offshore coordination
• Prepare test cases
• System testing and Regression Testing,
• Defect Raising
• Testing, Discussion with BA, Dev Team, Onsite Co-ordinator.

Confidential

Team Member

Responsibilities:

• Onsite offshore coordination
• Prepare test cases
• System testing and Regression Testing,
• Defect Raising
• Testing, Discussion with BA, Dev Team, Onsite Co-ordinator.