Candidates About

 

Bharath Reddy Cheruku Moolinti

 

Accomplishments:

·         Certifications: Informatica Corporation Certified – Informatica Basics v9.1, Teradata Corporation Certified – Teradata V12 Basics, IBM Certified Specialist – IBM Datastage 9.1, Cognizant Internal Certified – AHM250 and General Insurance.

·         Received Scope award for outstanding contribution as an ETL Informatica Developer towards WellPoint HMC EDW Integration Project.

·         “I Appreciate having Bharath on the team very much. He is dedicated to our Projects and Processes. He has been Vital to the success of our team as we have worked with Business partners to complete Company initiatives. Bharath is Good Communicator, Great Teammate and a Pleasure to work with. I enjoy having him on the team” – appreciation from CareSource Client Manager.

 

Professional Summary:

·         BharathReddy CherukuMoolinti has 8.5 years of experience in the Information Technology Industry with specific focus on DW&BI Technologies with specialized in DW ETL. As part of his assignments, he has been in Data Analysis, Flow Diagram, Solution Design and Development of Data Warehouse applications on Relational Database (RDMS) using ETL Tools.

·         Extensively worked on Teradata Database and ETL tools Informatica, Datastage and SSIS in Development, Testing and Production Environments in Healthcare domain in delivering best in class business, data warehouse solutions and actionable insights for Clients like – WellPoint, Blue Shield of California, CIGNA and CareSource.

·         Expert in working with cross functional teams including Solution architects, Data Management teams, Business Analysts, Quality Assurance and Program Sponsors.

·         Extensively worked on Healthcare: Medicaid, Medicare, Facets, Value Based Program, Claims and Member Data warehouse designs.

·         Demonstrated expertise in Designing, Developing and Deploying Business Intelligence solutions using Informatica, Tortoise SVN and Tidal Process.

·         Experience in Performance Tuning of large/long running Queries thereby optimizing Query execution plan using efficient coding standards.

·         Profound knowledge and ability to write Complex Queries including Correlated Queries with Complex Joins and Aggregate functions and to create Temporary Tables, Views, Indexes.

·         Expertise with DDL and DML statements, RDBM’s data dictionaries, excellent understanding of Relational Database Systems, Normalization, logical and Physical Data modelling for OLTP and Dimensional modelling for OLAP.

·         Experience in enhancing and Deploying the Informatica XML’s from development server to production server by creating the Production Implementation or Deployment Guide.

·         Knowledge in ER Modelling, Star Schema/Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).

·         As a team member, have excellent inter-personal and client interfacing skills and the ability to quickly understand technical scenarios and formulate efficient solutions.

·         Outstanding ETL Informatica developing skills coupled with excellent Teradata database skills to facilitate tangible results. Innovative thinker and diagnostic problem-solver, ensures the product development within the agreed project timeframes.

·         Worked throughout the SDLC Life Cycle of a project and contributed the best towards successful execution of the Project. Quick Learner in adopting new tools and work out solutions independently and in leading teams.

·         Hands on Experience in building SSIS packages (.Dtsx) involving ETL Process, Extracting data from various flat files, legacy Systems and Migrating Teradata/Informatica Components into SQL Server.

·         Worked in SDLC Life Cycle and Agile Methodologies in CareSource.

 

Technical Skills:

ETL Tool                                                : Informatica Power Center 8.6, 9.1, 9.6.1 and Datastage 7.5,   9.1, SSIS 2008/2012

Databases & Tools                           : Teradata, SQL Server 2005, Oracle 11G

Programming Languages              : SQL, PL/SQL, UNIX

Scripting Languages                        : UNIX Shell Scripting

Hardware                                            : Windows 98/XP/2000/2007, UNIX

 

Career History & Performance:

Project Profile 1:

Client: CareSource – Dayton, Ohio                        Project: Value Based Reimbursement Program

Duration: April 2016 – Till Date

Environment: Informatica Power Center 9.1, 9.6, SSIS, Teradata, SQL Server

 

Project Objective:

VBR or Value Based Reimbursement programs are designed essentially to pay the providers for the

Value they bring in for the Quality of Care over the traditional fee-for-service (FFS) Quantity approach.

This program is targeted towards Healthcare Quality Improvement and Cost Reduction.

Project Description:

As the theme of the these Programs is value creation, these are creating a win-win situations for the Healthcare Industry -  Providers, Members, Patients, Payers and State Governments etc.

VBR Program enhance the Accountability, Shared Savings, Individual Profiling, Quality of Care and overall Member/Patience Experience.

Operational maintenance includes the new projects, enhancements, bug fixing, performance improvement and Critical business support. Regular ETL Jobs which loads the data from various Source systems like Members, Providers, Claims, Eligibility and HEDIS etc., and Jobs are running in different frequencies daily, monthly and quarterly. All jobs are been tracked and data is being verified frequently in order to make sure of the data consistency. The failures of scheduled jobs are handled in an efficient way.

 

Role and Responsibilities:

1.       Interaction with business team regarding technical and functional requirements.

2.       Design and Implementation of ETL Informatica jobs and modifying the existing jobs as per the requirements. Developing delta jobs for transactional and additional data using Informatica Mapping Designer.

3.       Scheduling and monitoring the sequences and the flow in Tidal Scheduler.

4.       Involved in Performance Tuning of Teradata Queries and Informatica long running jobs by running the Explain Plan and Defining Indexes and Collecting Stats on tables.

5.       Testing all the business needs by having Unit and Integration testing techniques.

6.       Taking care of Backup Process and Documenting the Backup sequences for Production deployment.

7.       Preparing the Production implementation Handover documents for deploying the Database and Informatica Components into INT/CRT/PROD environments.

8.       As a Technical Lead Developer, guiding the team with best coding solutions possible and approach with zero or negligible defects.

9.       Setting up the environment for Informatica/SSIS ETL Designer, Monitor & Administrator for INT/CRT/PROD deployments.

10.   Trained Junior ETL Developers/Interns in Informatica Coding Standards and Code reviewed to meet the Business requirements.

11.   Supporting the Business team and walk through the User Acceptance Test results for better understanding.

 

Key Achievements:

·         Successfully completed Phase 1 and Phase 2 of the VBR Program.

·         Mentored the team in meeting the Informatica Coding Standards and Performance Tuning the long running jobs to reduce the runtime.

·         Co-ordinate with Application team and Business to generate the Monthly and Quarterly reports for external Provider systems using EDW Data.

·         Effectively Implemented the Error Handling Scenarios for Informatica jobs to succeed though Source data is wrong.

·         Implemented the Attribution Config Engine Automation to reuse the code for future Attribution types.

·         Successfully prepared a plan for VBR Teradata EDW Migration to SQL Server and trained the Junior ETL Developer.

 

Project Profile 2:

Client: CIGNA – Chennai, India                                                  ETL Informatica/ Datastage Developer

Duration: Jan 2014 – March 2016

Environment: Informatica Power Center 9.1, Teradata, Data stage 7.5 & 9.1, Oracle

 

Project Objective:

The Consumer Centric Data Repository (CCDR) provides an integrated, member-centric information environment in support of Health Advocacy, Consumerism, and Informatics strategies.  The analytical repository serves as an authoritative source of derived clinical data presenting a holistic longitudinal and 360 degree view of an individual (internal and external membership) across medical, behavioral, pharmaceutical, disability, vision, and dental product lines.

 

Role and Responsibilities:

1         Interaction with On-shore Business team and Clients for Technical and functional requirements.

2         Design and Implementation of Informatica and Data stage jobs and modifying the existing jobs as per the requirements.

3         Worked with Cross functional teams and multiple vendors like TCS Testing team for CIGNA.

4         Creating PL/SQL queries Procedures and Functions in SQL/Oracle 11G.

5         Created Complex Stored Procedures, Functions, tables, Views, Indexes, SQL Joins and statements for applications by using SQL.

6         Involved in Performance tuning of SQL Queries and Stored Procedures using SQL Profiler.

7         Preparing the Production Implementation Handover documents & Runbooks for deploying the Database and ETL Components into INT/CRT/PRD environments.

8         Testing all the business needs by having Unit and Integration testing techniques.

9         Supporting the Testing team and walk through the Unit testing results and Peer reviewing the QA Test cases to cover all the ETL Scenarios.

 

Project Profile 3:

Client: Blue Shield of California – Chennai, India                                                ETL Informatica/ Oracle Developer

Duration: July 2012 – Dec 2013

Environment: Informatica Power Center 9.1, 9.6, Oracle.

Project Objective:

Blue Shield of California, an independent member of the Blue Cross Blue Shield Association, is a non -profit health plan. Shield Advance is the name of an enterprise wide program that will improve the way BSC service their customers – from bringing new products to market and enrolling members, to processing claims and managing their network of providers.

 

Role and Responsibilities:

1. Worked with Business Analyst and Business users to clarify requirements and translate the requirement into technical specifications.
2. Responsible for Analyzing, Designing and developing ETL strategies using Informatica.
3. Developed standard and re-usable mappings and mapplets using various transformations.
4. Developed complex Interfaces or Change requests independently by working closely with On-shore Counter parts who sits at client location in California (USA) by understand the technical requisites.

5.       Scheduling and monitoring the Job sequences through the Tidal flow.

6.       Testing all the business needs by having Unit and Integration testing techniques.

 

Project Profile 4:

Client: WellPoint – Chennai, India                                            ETL Informatica/ BI System Analyst

Duration: March 2012 – June 2012

Environment: Informatica Power Center 9.1, 9.6, Teradata, UNIX

 

Project Objective:

To get an understanding of client requirements and then analyze the system impact and propose the corresponding solutions by analyzing the existing BTEQ scripts, mappings and tuning them to improve the performance to provide the data to downstream systems with in time.

 

Role and Responsibilities:

Liaise with client to gather business requirements, analyze the system impact and identify solutions. Also document the requirements and coordinate with the client for requirements walk-through and sign-offs and ensure that the requirements document accurately portray specific business needs. Based on the Changes recommended by Mr. C.M. Bharath Reddy, who is a part of RIM analysis team, the development team would incorporate the changes in Edward database, to fulfill the business requirements.

 

Project Profile 5:

Client: WellPoint – Chennai, India                                                ETL Informatica/Teradata Developer

Duration: Sep 2011 – March 2012

Environment: Informatica Power Center 9.1, 9.6, Teradata, UNIX

 

Project Objective:

The objective of this project is to refresh the VA history data and loading incremental data. After loading the data, we should compare the members count (medical members count and pharmacy member’s count) from source to EDW.

 

 

Roles & Responsibilities:

 

1. Analysis of Functional documents and Technical Specifications.
2. Writing queries to meet business requirement and developing Teradata BTEQ scripts using Teradata Utilities.
3. Developing BTEQ Scripts to pull data from Source to EDW Target tables.
4. Building Informatica mappings to pull data from Source to Landing/Staging Zones.
5. Involved in Performance Tuning of Teradata Queries and BTEQ Scripts by running the execution Plan and Collecting Stats on recommended tables.
6. Scheduling and monitoring the Informatica/BTEQ Job Sequences using the WLM/Tidal Flow.
7. Testing all the Business needs by having Unit and Integration testing techniques and analyzing the data if found any issue.

 

Project Profile 6:

 

Client: WellPoint – Chennai, India                                                ETL Informatica/Teradata Developer

Duration: May 2011 – Sep 2011

Environment: Informatica Power Center 8.6, Teradata, UNIX

 

Project Description:

 

Healthy Returns System (HRS) is the current Care Management platform used by Comprehensive Health Solutions/HMC clinical teams to deliver 360 Health services. This data consists of case information, including: member goals, results, charting, and comprehensive Case notes (Social Worker, Pharmacist, Dietitian, Exercise Physiologist, and RN).  

 

Roles & Responsibilities:                                                                                          

1. Analysis of Functional Specification documents and creating Technical Specifications for the ETL Flow.
2. Creating Mappings for Target tables using the Flat file source system and performing unit testing.
3. Creating various test cases documents like UTC etc. with Positive and Negative Scenarios.
4. Involved in Performance Tuning of Teradata Queries and BTEQ Scripts by running the execution Plan and Collecting Stats on recommended tables.
5. Scheduling and monitoring the Informatica/BTEQ Job Sequences using the WLM/Tidal Flow.
6. Testing all the Business needs by having Unit and Integration testing techniques and analyzing the data if found any issue.

 

 

 

 

Project Profile 7:

 

Client: WellPoint – Chennai, India                                                ETL Informatica/Teradata Developer

Duration: Feb 2011 - May 2011

Environment: Informatica Power Center 8.6, Teradata, UNIX

 

Project Objective:

The purpose of the WDS Claims Extraction project is to develop a detailed approach for migrating WellPoint Dental and Vision claims data directly to the EDW base model. WDS Claims data that is adjudicated from January 2004 and forward will be loaded into the target EDW tables and in the incremental load, only the new/updated records data from the source will be loaded EDW tables.

 

Role and Responsibilities

1. Developing Informatica mappings for extraction of data from source files.
2. Preparation of Detail Design document and ETL specification document
3. Involved in Data profiling and Performance Tuning of Teradata BTEQ Scripts.
4. Preparation of Teradata BTEQ scripts using Teradata Utilities based on the Attribute Mapping sheet provided by the Technical Business team.
5. Code review of Teradata BTEQ scripts and providing the comments on performance improvement steps.
6. Unit testing of the BTEQ scripts and Informatica Mappings.
7. Preparation of WLM set up sheet to execute the BTEQ Scripts/Informatica mappings.

 

Project Profile 8:

 

Client: WellPoint – Chennai, India                                                ETL Informatica/Teradata Developer

Duration: Aug 2009 – Jan 2011

Environment: Informatica Power Center 8.6, Teradata, UNIX

 

Project Objective:

MCP (Master Consumer Profile) combines the latest technology with immense data for specifically targeting services to WellPoint members according to their health needs and lifestyle habits.  The data model will support complex analytical workloads along with fast access for small transactional queries/data sets.  The 360 view of the member presented by the MCP will benefit various business stakeholders as the strategy is built out. 

 

Roles & Responsibilities:

1. Analysis of Functional documents and Technical Specification documents.
2. Creating documents of ETL Specifications for Informatica/BTEQ Scripts.
3. Developing Informatica Mappings for various tables from source to Landing zones and Unit testing.
4. Involved in Data Profiling and Performance Tuning of Teradata BTEQ Scripts.