S.Manjunath

': +91-973*******

*: acp5w7@r.postjobfree.com

Professional Summary:

Having around 3.8 Years of experience in ETL/DWH/DATA QUALITY testing

Extensive knowledge on Data Warehousing concepts & ETL testing process

Good exposure to Agile Methodology (SDLC)

Worked on Insurance, Healthcare, Retail domain’s, mainly involved in Functional/Regression Testing

Involved in Sprint Planning’s, Visuals & Burn down chart preparations, Retrospectives

Hands on experience in Framing and Tuning the SQL Queries to validate all the data scenarios

And for backtracking the transformation logic

Involved in Preparing, Reviewing and Executing Test Cases

Good knowledge of Defect Logging, Tracking and Analysis

Work Experience:

Currently working with NTT DATA GDS LTD, Bangalore as a Senior Software Engineer from july -2011 to till date

Education:

Bachelor of Science in Computers from Sri Venkateswara University, Tirupati-2009

Technical Skills:

Testing : ETL/DWH/Data Quality Testing

ETL : Informatica

RDBMS Packages : Oracle 10g, Teradata 13.10/14

Data Access Tool : Teradata SQL Assistance, TOAD, SQL Developer

Schedulers : Control-M, TIDAL

Code Promotion Tool : EME

Operating Systems : Windows 2000/XP/NT/7 and UNIX

Languages : SQL.

Test Management Tool : Quality Center 10.0

Project Summary:

1) PROJECT NAME

HC2324 - maxMC Upgrade to Care Radius

Client

BCBSNC

Solution Environment

Informatica,Oracle 10 g, Toad

Role

Off-Shore QA Member

Description:

The goal of this project is to successfully move BCBSNC’s maxMC to the CareRadius product suite in tact; replicating current functionality without prohibiting BCBSNC’s adoption of CareRadius functionality in future phases. In phase 1, the project aims to “lift and shift” today’s functions from maxMC into CareRadius. Additional functions specific to CareRadius will be handled as part of later phases as needed.

Responsibilities:

Requirement Analysis

Involved in preparation of Test approaches

Involved in Data analysis

Coordination with onshore team for addressing offshore issues

Attending Technical walkthrough’s

Reviewing all offshore artifacts(Test plans & results)

Test plan preparation with detailed test case’s using SQL Queries

Execution of Test Cases (Teradata, Oracle, SQL server) & results documentation

Identifying test cases for Regression testing

Defect Analyzing and Reporting in QC

Attending daily standup meetings

Presenting DEMO’s to the client every sprint ending day

2) PROJECT NAME

HC278 - Care Management System Replacement (CMSR)

Client

BCBSNC

Solution Environment

Informatica, Oracle 10g,,TOAD, EME

Role

Off-Shore QA Member

Description:

The goal of this project is to replace the current Care Management system of BCBSNC, MaxMC. BCBSNC has entered into a Vendor agreement to replace MaxMC with Trizetto’s Care Advance Enterprise (CAE). The CAE application comprises of the following components:

CCA – Clinical Care Advance (Access to Nurses/Business Users)

CAP – Care Advance Provider (Access to Providers for Authorization and Referral data)

PCA – Personal Care Advance (Access to Members)

Responsibilities:

Requirement Analysis

Involved in preparation of Test approaches

Involved in Data analysis

Coordination with onshore team for addressing offshore issues

Attending Technical walkthrough’s

Reviewing all offshore artifacts(Test plans & results)

Test plan preparation with detailed test case’s using SQL Queries

3) PROJECT NAME

SALES DATA MART (SDM)

Client

Honeywell

Solution Environment

Informatica 8.6, Oracle 10g, TOAD

Role

ETL Tester

Description:

Honeywell is one of the leading Safety product dealers in the world that sells variety of Safety product across the world.

This project is to create sales data mart that plays a major role in enabling various stores to view the data at a lowest level and help them to make decision to bring more revenue to company with new polices.

Responsibilities:

Requirement Analysis

Executing the jobs using the Control-M tool

Test Data preparation to validate all possible scenarios

Test case preparation with detailed test case’s using SQL Queries

Verifying the ETL data in target database

Verified column mapping between source and target

Interactions with BA & Dev teams to resolve the issues

Reporting daily testing status.

Contact this candidate