Experience Summary

• Around 7 years of industry experience in requirement analysis, KPI Designing, Data Modeling and Data Development and Implementation of business application systems for Health care, Insurance and Retirement Solution sector

• Familiar with Ware House Data model IIW Data Model

• Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.

• Strong working experience in Data Modeling using Relational and Dimensional Data modeling, Star Schema/Snow flake schema, FACT Dimensions tables, Conceptual, Physical logical data modelling.

• Strong Data Warehousing ETL experience of using Informatica 9.1/8.6.1/8.5/8.1/7.1 PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools Informatica Server, Repository Server manager.

• Expertise in analyzing, architecting, designing and modeling data warehouses and star schema data marts for various business verticals like Financial, Insurance, Property and Causality and Pharmaceuticals.

• Strong experience on build and load data from external sources like ERP using Informatica Power Exchange.

• Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0, UDB, MS Access and Teradata.

• Strong experience in Extraction, Transformation and Loading ETL data from various sources into Data Warehouses and Data Marts using Informatica Power Center Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger , Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.

• Experience in resolving on-going maintenance issues and bug fixes monitoring Informatica sessions as well as performance tuning of mappings and sessions.

• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, Transactional Design experience and interpersonal skills with a strong desire to achieve specified goals.

• Have clear understanding of Business Intelligence and Data Warehousing Concepts with emphasis on ETL and Life Cycle Development, SDLC, Quality analysis, change management, compliance Disaster recovery.

• Experienced in OLTP/OLAP system study, analysis and ER modeling, developing Database schemas like Star schema and Snowflake schema used in relational and multidimensional modeling by using Erwin,

• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts and EnterpriseDB PostgreSQL database design and support.

• Involved in different database modeling techniques like Object Oriented Design and Modeling, Database Design and Modeling, etc.

• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.

• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.

• Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Teradata, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.

• Good academic credentials.

Technical Skills:

• Operating Systems: Windows 2008/2007/2005/NT/XP, UNIX, MS-DOS
• ETL Tools: Informatica Power Center 9.1/8.6/8.5/8.1/7.1 Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server
• Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005, DB2 v8.1, Teradata.
• Data modeling tools: Erwin, MS Visio
• Languages: SQL, PL/SQL, UNIX, Shell scripts, C

Technical Experience:

Confidential

Role Team Lead and Onsite Co-ordintaor

Overview:

SIL-SID project is middle layer between MassMutual Retirement Services' Strategic Information Delivery SID and Service Integration Layer SIL . It is part of the Data Integration program in the RS Technology Strategy that is responsible for providing services based Integration platform for all the application components in the RS Technology Strategy architecture landscape that have services integration needs.

Role and Responsibilities

• Participated in requirement analysis and analyze the different requirement documents to create the design document.
• Gathering the requirements from onsite and giving to offshore
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.

Parsed high-level design specification to simple ETL coding and mapping standards.

Designed and customized data models for Data warehouse supporting data from multiple sources on real time

Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.Participated in the preparation of the status reports and CR documents to be submitted to the client.

Created mapping documents to outline data flow from sources to targets.

Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.

Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.

Developed mapping parameters and variables to support SQL override.

Created mapplets to use them in different mappings.

Developed mappings to load into staging tables and then to Dimensions and Facts.

Used existing ETL standards to develop these mappings.

Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.

Checked for all the modeling standards including naming standards, entity relationships on model and for comments and history in the model. Conducted design walk through with project team and got it signed off.

Created integrity rules and defaults.

Created Technical Mapping documents for the development team to develop mapping workflows.

Interacted with project manager and management team to define business requirements.

Conducted several meetings with business and systems regarding project.

Interacted with ETL developers for making them understand the movement of required data.

Technologies: Informatica, Teradata and Erwin

Confidential

Role Data Modeler and ETL Developer

Overview:

The Core Data Analytics project will consolidate a core policy and claim data set of no more than 300 unique data elements initially in this first phase, for North America and Rest of World RoW Data terms will be catalogued and defined in a data dictionary, the data consolidation will be delivered in an IIW based policy and claim data model. The project will harvest existing data quality rules from within Chartis, and define additional rules as required, so as to establish a core data quality rule library to verify the core data set consolidation. The IIW warehouse is modeled and generated using Erwin data modeler. Data from North America and Rest of World are extracted, transformed and loaded into IIW by Datastage jobs. Once the data is loaded, business specific reports are generated in Cognos.

Role and Responsibilities

Participated in requirement analysis and analyze the Source Data for creating different mapping specs.

Participated in the creation a mapping document from Pre-staging to Common Source Template.

Participated in the creation of IIW data ware house design and mapping documents from source to IIW.

Providing the inputs to the team on different mapping documents and IIW data modeling

Generated the scripts and Images of the different data models

Using Informatica PowerCenter Designer analyzed the source data to Extract Transform from various source systems oracle 10g,DB2,SQL server and flat files by incorporating business rules using different objects and functions that the tool supports.

Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules.

Used various transformations like Source Qualifier, Joiner, Lookup, sql, and router, Filter, Expression and Update Strategy.

Implemented slowly changing dimensions SCD for some of the Tables as per user requirement.

Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools

Documented Informatica mappings in Excel spread sheet.

Tuned the Informatica mappings for optimal load performanceVerify data model/schema designs against the business requirements.

Performed highly complex data analysis for a business intelligence solution.

Created Source to Target mappings for moving data from one platform to the other.

Created Data Flow diagrams for better understanding of data flow within the applications.

Created Business Information Models.

Reviewed Data Models with Business and Systems Analysts.

Technologies: Erwin, Informatica and DB2

Confidential

Role Data Modeler and ETL Developer

Overview:

Care Management is the Sliver initiative for providing member centric application service in Healthcare industry. Where in Members are tracked and identified continuously based on their episodes of care, program adherence, benefit information etc. All members are enrolled and tracked through one of the programs Wellness or Disease or Case management. Members are scored for health risk and potential of recovery continuously. Changes to health risk/recovery scoring triggers enrollment in a more appropriate program. Potential program enrollees are assessed before admission to a program.

Among other functionality, our software will enables laypeople e.g. nurses, physicians, schoolteachers, medical directors, business analysts, etc. and power users alike to build, automate, and manage any imaginable consumer-focused workflow.

Various Components Modules of the Product:

The care management product consists of the following five modules

Patient Identification Stratification

Care Management Analytics

Workload/Workflow/Decision Support collectively Care Management

Utilization Management Software Services

Engagement Behavior Change

Roles and Responsible in the Project:

Created Data models depending on the requirements by using ER-Diagram and IBM InsfoSphere Data Architect

Created scripts from Data Model and created the data base.

Developing and Testing Oracle Stored Procedures

Designed ETL specification documents for all the projects.

Created Tables, Keys Unique and Primary and Indexes in Oracle

Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source. Applied business logic to load the data into Global Data Warehouse.

Extensively worked on Facts and Slowly Changing Dimension SCD tables.

Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.

Used various transformations like Filter, Router, Expression, Lookup connected and unconnected , Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in the Informatica Designer.

Extensively used the Add Currently Processed Flat File Name port to load the flat file name and to load contract number coming from flat file name into Target.

Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.

Performance tuning Optimization of queries in Oracle SQL and PL/SQL.

Suggested effective implementation of the applications, which are being developed.

Environment: Informatica, Erwin and Oracle

Confidential

Role Data Modeler and Mapping

Overview:

Claim Sphere, Analytical Reporting Framework, is built around the payer data model, which helps tracking and analyzing information across the organization. It is used to simplify the reporting mechanism through an array of systematic and extensive reports and easy-to-assimilate graphical representations.

Claim Sphere Provides a high-level view of claims along the dimensions of Total claims cost/Total claims Paid, Member Months, Per claims cost, PMPM Cost, and No. of claims PMPM for all medical and pharmacy claims through absolute value, variance, and drill-down analysis through Aggregate Cost Analytics.

Through Detailed Cost Analytics, Claim Sphere provides a high-level view of claims along the dimensions of analysis over a time period and facilitates drill down analysis to various levels.

Claim Sphere provides a high-level view of claims along the dimensions of claims, utilization, and membership systems through absolute value, variance, and drill-down analysis using Utilization Management Analytics.

Using Pharmacy Cost Analyst it provides a high-level view of major sources of data which include drugs, employer, prescriber, plan, pharmacy claims, and membership systems of claims along the dimensions of claims, and membership systems through absolute value, variance, and drill-down analysis.

Roles and Responsibilities in the Project

Participated in requirement analysis and prepared KPIs depending on functional requirements

Preparing the queries depending on business requirements and briefing them to Development and BI-Squad team.

Did the Data validation of the Reports along with BI-Squad, on business requirements

Directed the data warehouse meta data capture and access effort.

Involved in Database administration support in relation to Business Intelligence and Data Warehousing.

Defined technical requirements, technical and data architectures for the data warehouse.

Defined and directed the implementation of security requirements for the data warehouse.

Reviewed information systems requirements to provide the best and most cost effective solutions for the organization.

Worked on Data Modeling with Erwin involving complex conformed dimensions

Guided IT development teams in implementing industry best practices into application, data, infrastructure architecture, design, and programming activities.

Supported customers with services related to strategies and implementation of SOA based solutions

Worked with technical team on implementing prototypes related to SOA, EIM and related technologies.

Environment: Oracle and Excel

Confidential

Role Team Member

Overview:

PICIS solutions target the core business areas of a hospital where costs and revenues are greatest and patients are most vulnerable, providing advanced, business-transforming functionality to today's HealthCare Industry. Care Suite is one of the primary products of PICIS. PICIS' CareSuite is divided into two major modules: Admin Module and Clinical Module. PICIS-Cognizant tie-up will mainly deal with Admin Module focusing especially on OR Operation Room Manager Application, which automates all aspects of Pre and Post operation processes of a Provider. It is a part of the CareSuite products provided by PICIS.

The various Applications involved are OR Manager, SmarTrack, Quality Manager OR, Quality Manager Enterprise, Security Manager, Credentialing Manager, and Bed Manager. All these applications assist in Provider Operations to a great extent. The applications can be TPA or Non-TPA Applications. TPA is mainly for activities involved when a patient goes for surgery.

Roles and Responsibilities in the Project

Product consultant and understanding the requirements from the business

Explain the functionality of the product for users and clarified their doubts on the same.

Environment: SQL Server