Raghava

ABOUT ME

Over Fifteen years of IT experience in Design, Development, Analysis and support of Enterprise level Data Integration, Data Warehouse (EDW) Business Intelligence (BI) solutions using Operational Data Store (ODS) Data Warehouse (DW)/Data Mart (DM), ETL, OLAP, ROLAP Client/Server and Web applications on Windows and Unix platforms.
Managed multiple projects as a Technical Development Lead supporting Analysis and Testing teams. Submitted and managed new IT project estimations and change controls.
Strong working experience on DSS (Decision Support Systems) applications, directly responsible for the Extraction, Transformation and Load (ETL) of data from Legacy Systems using Informatica and Reporting using SAP BI.
Strong experience in Health care sector dealing with HIPPA standards, EDI files, ICD10 codes.
Experience with Trizetto’s Facets front end tool and back-end database structure and Facets upgrades.
In-depth knowledge of Data warehousing concepts with emphasis on Project Management, ETL, Software Development Life Cycle (SDLC) including requirement analysis, design, development, testing, implementation & support.
Worked extensively with Dimensional modeling, Data migration and skilled in Data modeling using Star Schema and Snowflake Schema.
Implemented Slowly Changing Dimensions-Type I, II in Dimension tables as per requirements.
Extensively used Enterprise Data warehousing ETL methodologies for supporting data extraction, transformation and loading processing, in a corporate-wide-ETL Solution using Informatica Power Center.
Experience in Data Warehousing Data Integration and Data Conversion Projects with ETL experience using Informatica Power Center 10.1/9x, Informatica MDM 10.1, IDQ 10.1.
Developed complex mappings in Informatica using various transformations Joiner, Aggregator, Update Strategy, Rank, Router, Lookup - Connected & Unconnected, Sequence Generator, Filter, Sorter, Stored Procedure transformation etc.
Well acquainted with Performance Tuning of sources, targets, mapping and sessions to overcome the bottlenecks in mappings.
Experience with reporting on Billing, Finance, Claims and Membership data
Expertise in Data Integrator 6.5/Data Services XI (ETL) – creating work flows, data flows and DI scripting
Highly proficient in the integration of various data sources involving multiple relational databases like Oracle 11g/10g/9i, MS SQL Server and Flat File.
Worked with SQL/PL-SQL to write Complex SQL queries, Stored Procedures, Triggers, Functions & PL/SQL packages.
Experience in writing UNIX shell scripts.
Involved in Production support.

SKILLS