Professional Summary:

• Having around 4.3 Years of experience in ETL/DWH/MDM testing with Data Analysis
• Extensive knowledge on Data Warehousing concepts & ETL process
• Worked on Healthcare, Insurance, Retail domains mainly involved in Functional/Regression Testing/Data Analysis
• Experience in Data Analysis and Test Plan Preparation.
• Good Experience in Exact and Fuzzy match rules analysis.
• Experience on JIRA.
• Experience on MDM tool (Reltio).
• Hands on experience in SQL Queries to validate all the data scenarios.
• Involved in Preparing, Reviewing and Executing Test Cases.
• Good knowledge of Defect Logging, Tracking and Analysis.
• Basic Knowledge on UNIX
• Ability to handle multiple tasks and work independently as well as in a team

Work Experience:

• Associated with LKQ India Pvt Ltd, Bangalore as a Software Test Engineer from July-2018 to till Date.

Education:

• Post-graduation completed from SV University in 2015.

Technical Skills:

• Testing : ETL/DWH/Data Testing
• ETL : Informatica 8.6.2/9.1
• RDBMS Packages : Oracle 9i/10g
• MDM Tools : Reltio
• Data Access Tool : Oracle, SQL Server
• Operating Systems : Windows 2000/XP/NT/7 and UNIX
• Languages : SQL
• Test Management Tool : JIRA

Project Summary:

1) PROJECT NAME

Client

Santen

Solution Environment

Informatica, SQL and Unix

Role

Individual contributor

MDM Tool

Reltio

Description:

This ETL testing performed to test EDW Data Warehouse process that loads the source systems files (STI,TSA,XPO,HCRS,CRMMI) from various source system and this source files are moved to staging Queue(S3) , And its loaded into UI after match/merge based on MDM rules data will generate a OV values. After this process through ETL jobs OV records will extract.

Responsibilities:

• Requirement Analysis
• Involved in preparation of Test approaches
• Involved in Data analysis and SPEC writing
• Coordination with onshore team for addressing offshore issues
• Reviewing all offshore artifacts(Test plans & results)
• Test plan preparation with detailed test cases using SQL Queries
• Execution of Test Cases (Oracle, SQL server)& results documentation
• Identifying test cases for Regression testing
• Defect Analyzing and Reporting in QC
• Attending daily standup meetings

2) PROJECT NAME

SIQP (Sales Incentive Quota Performance)

Client

UCB

Solution Environment

Informatica 9.5, Oracle 11g, Unix

Role

ETL Tester

Description:

This ETL testing performed to test EDW Data Warehouse process that loads the source systems files (DDD,DDDMD,XPO,HCRS,CRMMI) from various source system and this source files are moved to staging Queue(S3) , And its loaded into UI after match/merge based on MDM rules data will generate a OV values. After this process through ETL jobs OV records will extract.

Responsibilities:

• Requirement gathering and analysis
• Involved in Data Profiling, Data analysis and SPEC writing
• Involved in preparation of Test Plan with approaches
• Coordination with onshore team for addressing offshore issues
• Technical walkthrough’s for offshore team
• Preparing daily workloads for the offshore team
• Reviewing all offshore artifacts (Test Cases& results)
• Test plan preparation with detailed test case’s using SQL Queries
• Execution of Test Cases & results documentation
• Defect Analyzing and Reporting in QC
• Attending daily standup meetings
• Presenting DEMO’s to the client every sprint ending day

3) PROJECT NAME

HC278 - Care Management System Replacement(CMSR)

Client

BCBSNC

Solution Environment

Informatica Power center, My SQL assistance and Unix

Role

Individual contributor

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 and SPEC writing
• Coordination with onshore team for addressing offshore issues
• Reviewing all offshore artifacts(Test plans & results)
• Test plan preparation with detailed test case’s using SQL Queries
• Execution of Test Cases (Oracle, SQL server)& results documentation
• Identifying test cases for Regression testing
• Defect Analyzing and Reporting in QC

Place: Bangalore (Sasidhar B)