3+ Years of Experience in ETL Testing

Girish T.B

Test Engineer Email ID: *************@*****.***

Mobile No: +91-973*******

Professional Summary:

Having 3+ years of experience in ETL/Database Testing

Good Exposure to Data Warehousing concepts

Hands on experience in writing and executing SQL Queries

Good experience on ETL/Database Testing

Has testing experience in Informatica 8.6 Power Centre

Involved in various Manual Testing types like System testing, Regression.

Having Extensive knowledge on Verification and Validation process.

Experienced on Quality Center Test Management tool.

Involved in preparing, reviewing and executing Test Cases.

Good knowledge of Defect Logging, Tracking and Analysis.

Conceptual Knowledge on UNIX.

Involved in complete Testing Life Cycle (Test Planning, Test Design, Execution and Publish Test Results).

Good communication and Interpersonal skills. Flexible to learn advancements in the IT Industry.

Quick Learner, Team player, willing to learn new technologies, flexible, Hardworking, Detail- Oriented, Positive Attitude.

Professional Experience:

• Working as Software Engineer for Signet Info Solutions, Bangalore since November 2008 to till date.

Professional Qualification:

• B.E (E&C) from NMIT, Karnataka affiliated to Visveswaraiah Technological University passed out in 2008.

Technical Skills:

• BI Tools : Informatica 8.6

• Databases : Oracle 10g/11G,MS SQL-2008

• Operating Systems : Windows 2000/NT/XP & UNIX

• Programming Languages : SQL,PL/SQL

• Test Management Tool : Quality Center 9.2

Project Experience:

Project # 1:

Project Name : SUD

Client : Star Union Dai-ichi Life Insurance Company Ltd,Japan

Environment : Oracle 10G, Informatica 8.6

Role : Tester

Project Description:

SUD Insurance is a full-service of insurance, financial, and auto registration agency has been in business since 1988. This is a Claim Data warehouse (CDW) providing Policy Transactions by credit cards, Premium and Claims Transactions data to the business users. Users want to measure profit over time by coverage, coverage item type, and geographic, demographic and sales distribution channels. The system is fully integrated, enabling the entry and sharing of policy and claims data among all components of the system and capturing data to complete policy administration, claims administration, policy issuance, billing, reinsurance accounting, and bureau reporting and management reports.

Responsibilities:

Running the Jobs/Workflow for ETL process

Checking data completeness

Data quality and transformation rule

Verifying the data in target database after ETL process

Performed column data mapping between source & target database.

Prepared test data for testing

Verifying the data which is loaded into target database

Interactions with BA & Dev teams to resolve the issues.

Reporting daily testing status report

Project #2:

Project name : Sustaining data for various subject areas

Environment : Oracle 9i, Informatica 8.6

Role : Tester

Project Description:

The objective of this project is to sustain the data for the clients and providing the information for the employer (client) paid amount and claims analysis on monthly and quarterly basis. The claims data from various vendors for different subject areas like medical, pharmacy, dental, disability, worker compensation, vision etc and the enrollment data from the client will be given monthly/quarterly depending on client requirement .This will also help client to analyze fraud claims.

Responsibilities:

Involved in functional study of the application

Running the Jobs/Workflow for ETL process

Verifying the data in target database after ETL process

Performed column data mapping between source & target database.

Prepared test data for testing

Verifying the data which is loaded into target database

Interactions with BA & Dev teams to resolve the issues.

Reporting daily testing status report

Project#3 : Re-Enrollment

Client : UNUM Insurance

Database : Oracle9i

Project Description:

Simply Unum is the product offered by Unum under Voluntary Workforce Benefit system. This product is delivered through a suite of applications which performs various functionalities like Acquisition, Issue, Enrollment, Sold Case Management, Administration, Contact Management, Claims Management etc.

Reenrollment Project leverages existing Simply Unum functionality/systems (by enhancement) whenever possible and develop new functionality only as needed. Immediate opportunities for re-use include the Quote & Proposal, Sold Case, and Initial Enrollment processes.

Re-Enrollment is an integrated, rules based process allowing enrollment for any voluntary product available through Simply Unum. The process leverages current processes/applications that support initial enrollment for Simply Unum products and enhance or create new functionality specific to the Re-Enrollment process.

Re-Enrollment supports all actors defined within the initial enrollment process including the sales consultant, underwriter, sales support consultant, sales coordinator, Simply Unum Service representatives, Enrollment Entity contacts, Case Managers, Enrollment Managers, and Simply Unum Account Managers.

Roles and Responsibilities:

Involved in database Testing

Testing of DB objects Procedure, Function

Functionality Testing

Prepared Business Scenarios, Traceability Matrix and Test data.

Involved in System Testing and Regression testing.

Executing Test cases

Tracking Defects using Quality Center.

PERSONEL PROFILE

Father’s Name : Bise Gowda

Date of Birth : 24th October, 1984

Marital Status : Single

Address : K R Puram,N C Palya,B-36

Contact this candidate