SUMMARY:

Highly motivated professional with over 12 years of contribution in individual and leadership roles involving Enterprise software and consulting services, catering to a variety of different areas across many industry verticals, including business intelligence/data warehousing, data integration, master data management, supply chain, Insurance, Healthcare and Pharmaceuticals.

• Project leadership and full life cycle management for complex engagements; Complete software life cycle activities from requirement collection, resource planning, delivery, implementation to support
• More than 12 years of experience in Data Warehousing (Dimensional Data Modeling/Database Design, ETL and Databases)
• The Data warehousing experience involves end-to-end life cycle of a Supply Chain Analytics Product Design, Development and implementation
• Data modeling (Conceptual, Logical, Physical) experience involves building Star Schema {Dimension (Slowly Changing, Snowflake, Conformed Dimensions), Fact, Metrics, and KPI} on Erwin with Domain Knowledge of Supply Chain, Inventory, Procurement, Distribution, Manufacturing, Retail, Insurance, Reinsurance and Health Care.
• ETL experience involves architecting mapping design, Error Logic Design and Workflow Design on Informatica Power Center 5x, 6x, 7x, 8x. Worked on Informatica, SSIS, SSRS, SSAS, Power Connect for SAP r/3. Worked on Databases like Oracle 9i, Oracle 10g, SQL Server 2005, SQL Server 2008 DB2.
• Lead the Implementation and development of Cognos 8.4.1 and Cognos 10.1. Installed and configured Cognos BI server, Cognos Statistical server, Cognos Go! Mobile, Cognos Go! Office and Framework Manager.
• Lead the development of TM1. Implemented Sales Forecasting application on TM1 and migrated from TM1 9.4.1 to TM1 9.5.1
• Strong expertise as solution architect designing and delivering solution deployment architecture, hardware and database sizing, performance and scalability options, benchmarking & tuning (application, database and hardware) for test, development and production environment
• Worked with high performance teams developing and implementing state-of-art data warehouse applications. Ability to understand (or get the customer to articulate) the business needs in terms of business value
• Single handedly completed end to end Design, development and implementation of data warehouse applications at OTIS.
• Technical Architect of a Supply Chain BI Reporting and Analytical Tool which is successfully installed at many client sites like Dell, Sprint, Texas Instruments, Gap.

TECHNICAL SKILLS:

Data warehousing Concepts: Dimensional Modeling - Star, Snowflake, Fact Table, Dimension Table, Slowly Changing Dimension, Metrics, KPIs, OLAP

Domain Expertise: Demand Analysis, Distribution Analysis, Financial Analysis, Fulfillment Analysis, Inventory Analysis, Procurement Analysis, Allocation Analysis, and Resource Analysis, Transportation Analytics
Insurance, Reinsurance, Health Care, SAP r/3 Data Model (SD and MM)

Languages: Java/J2EE, UML, SQL, T-SQL, PL/SQL, HTML, XML, JavaScript.

ETL Tools: Informatica Power Center 5x 6x 7x, 8x, 9x Informatica Power Connect 7x, SQL Server Integration Services(SSIS)

Data Modeling Tool: Erwin 4x, 7x, Model Mart

Source Control Tool: Visual Source Safe, Rational Clearcase, Harvest.

Databases: Oracle 8.x/9.x/10g, SQL Server 2000, SQL Server 2005, Teradata, MS Access, DB2

Application Server: Weblogic 6.0, 6.1 SP3, 8.1 SP1

Project Management: MS Office Suite, MS Project, MS Visio 2003

Reporting and Analytical Tool: Cognos 8.4.1, Cognos 10.1, TM19.4.1 and 9.5.1, Business Objects XI(Desktop Intelligence, Designer, Data Integrator), Business Objects Web intelligence SDK, Informatica Power Analyzer 3.5.2, 4.1.1, SQL Server Reporting Services(SSRS), SQL Server Analysis Services(SSAS), Report Builder, i2 CAS

Data Management Products: i2 MDM.

EXPERIENCE:
05/11 to Confidential,Collegeville, PA
9/11 Solution Architect PAH Europe
The project was to implement Sales Data mart across 10 different European countries in which Pfizer operates. The project was closed because of Pfizer decision to divest their Animal Health Business.

• Conducted and participated requirements sessions.
• Lead the Data Modeling, ETL Architecture and mapping development effort in the project.
• Dimensionally Modeled Sales Data Mart. Created Data warehouse Design, ETL Design and mapping document.
• Lead/developed Informatica mappings to extract and load data into the Data warehouse.
• Collaborated with different team in Europe and within Pfizer to extract data from different sources for the data mart.
• Managed a team of 4 developer offshore and 1 resource onsite.

Key Technologies: Data warehousing Concepts, Informatica 9.1, Oracle 11g, Erwin 7x (Model Mart)

03/10 to Confidential,Malvern, PA
5/11 BI Solution Architect
Joined Orthovita to lead the Business Intelligence effort in the company. The entire Business Intelligence effort involved building Data warehouse, implementing cognos 10.1 and building planning and forecasting application (Sales Forecasting, Production Planning and Gross Margin Analysis) on TM1.

• Conducted user sessions for the requirements.
• Created Data Architecture Layout incorporating Stage, Operational Data Store and Data warehouse.
• Dimensionally Modeled Sales and Marketing Data Mart. Created Data warehouse Design, ETL Design and mapping document.
• Installed and configured Cognos 10.1.
• Lead and developed SSIS mappings to extract and load data into the Data warehouse.
• Provided guidance for SSIS and Cognos best practices and troubleshot mapping difficulties that the team faced
• Developed standards for Data Model, Mapping transformations, workflows and cognos Framework models.
• Lead the SSRS report migration from one architecture to another.
• Architected and developed Sales Forecasting application for OUS (Outside US) data on TM1.
• Upgraded TM1 9.4.1 to TM1 9.5.1 and migrated Sales Forecasting application.
• Architecting and Developing Production Planning application on TM1 currently
• Involved in SSRS and Cognos report migration to Sharepoint.

Key Technologies: Data warehousing Concepts, Sql Server 2008 R2, T-SQL, SSIS, SSRS, Cognos 10.1, TM1 9.5.1, Erwin 7x.

03/09 to Confidential,Collegeville, PA
02/10 ETL Developer/Architect
The Clinical Drug Exchange (CDX) division of Wyeth has new development infrastructure in which they decided to have Informatica 8.1.5 as their primary ETL development tool and Business Objects XI R2 as their reporting tool for their Clinical Data warehouse. The division is also developing enterprise data warehouse from scratch.

• Analysis of requirement, data sources and Clinical Data.
• Designing Data marts (Logical and Physical Data model) for the clinical data warehouse and Vaccines.
• Creating ETL strategy and architecture for extraction of data from various clinical systems like IMPACT, CMF, and Oracle Clinical.
• Create proof of concept (POC) for Data mart and Users reports.
• Guiding the team with best mapping practices.
• Troubleshooting mapping difficulties that the team faces.
• Coming out with standard naming conventions for transformations, mappings, workflows etc
• Performance tune Informatica mappings and Oracle instances.
• Designed a reusable Error logic component which is used across all Informatica mapps.
• Documenting Design/ETL Architecture and mapping document.
• Coming out with a strategy to provide secure reporting environment using Business Objects for CDX research data.
• Working on Informatica mapping, mapplet, transformations and using latest transformations like JAVA Transformation.
• Creating Universe and reports.

Key Technologies: Data warehousing Concepts, Oracle 10g, SQL, Informatica Power Center 8.5, Business Objects XI R2. Erwin 7x.

04/08 to Confidential,Farmington, CT
03/09 Data warehouse Architect (Database Designer/ETL Architect/Project Lead)
Data Mart for O Billing Application and Open Orders
The O Billing application of OTIS is all about their Maintenance Contracts, Discount on the Contracts, Invoice associated with the Contracts and Price Adjustments related to the Contract. The application is on Mainframes. The client generated paper Invoices with no historical electronic copies of those invoices. This project was to create a data mart for their O Billing system which would accomplish two needs

• Reporting
• Storing electronic copies of historical invoices associated with Discounts and Price Adjustments
• Carried out the whole project, right from requirements to Data Modeling to Writing ETL, single handedly
• Interacted with Users and Owner of O Billing and Open Order System to gather requirements
• Created documents like Business Requirement Document, Technical Requirement Document and ETL Mapping Document
• Created Proof of concepts (POC) for the Data Mart.
• Created specs to transfer the data from Mainframes to flat files
• Created the data model using concepts of Dimensional data modeling(Conformed Dimension, Type 2, Dimensions, Fact table, metrics, Attributes and KPI)
• Wrote stored procedure using TSQL and SSIS Data Flow Tasks/mappings to transfer data from the flat files to stage tables and from stage tables to Data warehouse tables
• Used the CLR Integration functionality of SQL Server 2005 to invoke dot NET DLL for Cyclic Redundancy checks.
• The CRC concept was used to find out changed rows if the same row already existed in the database
• Incorporated functionality of Type 2, Type 1 and Insert while writing TSQL
• Helped the BO XI developer to build the Universe, Context, remove Loops through aliases and unwanted joins and achieved conformity through the shared dimensions.
• Carried out system testing and also the UAT
• Made the system stable by solving all the concerns and problems of the users w.r.t data

Key Technologies: T-SQL, SQL, SSIS, PL/SQL, SQL Server 2005, Windows XP, Business Objects XI, Passport/ Mainframes, Visio 2008

Customer Portfolio System
CPS is a in house .NET application build to support OTIS marketing and sales team. Objective of this project is to link all the sales representative and managers of different location/region. It provides features which help users to analyze customer data, helps in creating proposals faster by calculating amounts automatically, based on current rates.

Tasks

• Created the data model using concepts of Dimensional data modeling(Conformed Dimension, Type 2, Dimensions, Fact table, metrics, Attributes and KPI)
• Wrote stored procedure using TSQL and SSIS Data Flow Tasks/mappings to transfer data from the flat files to stage tables and from stage tables to Data warehouse tables
• Designed, developed, deployed and maintained Universes using Business Objects Designer.
• Resolved the loops using Aliases and Contexts.
• Checked the Integrity of the Universes and Exported the Universes to Repository for making available to users.
• Created report template by inserting cells and blocks and sections
• Created the report by defining user defined calculations in each cell.
• Defined breaks, Filters and prompts
• Formatted the table to hide the filtered column.
• Sliced and diced query objects to create cross tab reports.
• Tested the report by writing similar SQL query for correct result.
• Shifted the development universe after testing to UAT environment via Import Wizard tool in BO.

Key Technologies: T-SQL, SQL, SSIS, PL/SQL, SQL Server 2005, Windows XP, Business Objects XI, Visio 2008

08/07 to Confidential,Portsmouth NH
03/08 Data Architect
LIUCAN (LIU Canada)
This project was all about porting LIU Canadian Claim from an external platform to existing LIU Schemas/Tables

• Interacted with the users to gather requirements
• Carried out the complete analysis about LIU Claim data, external platform and existing LIU Schemas
• Created Technical Architecture Document, ETL Mapping Document
• Created Staging tables to store the external (LIU Canadian Claim) data
• Created views and wrote PL/SQL on top of staging tables to transform Claim data in a structure very similar to existing LIU Tables
• Transferred Claim Data into LIU Data Warehouse using the ETL Mapping written in SSIS. Only the incremental claim records were written into the warehouse
• The slowly changing Dimensions were loaded first and then the Fact tables were loaded in the warehouse
• Carried out Unit and System Testing of the whole process
• Implemented the entire solution in the existing environment

Ah Hoc Reporting Infrastructure using SSAS, SSRS

• Communicated with all the users to collect requirements
• Prepared Business Requirement Document
• Created Views on top of existing warehouse
• Created Cube (Defined Dimension, Fact, Cube Partition, MDX Queries) on top of the views using SSAS.
• Created Report Model using SSRS on top of Cube
• Delivered the full reporting environment consisting of Views, Cubes and Report Builder
• Whole of the project was done single handedly

Key Technologies: SSIS, T-SQL, PL/SQL, SSAS, SSRS (Report Builder), SQL Server 2005, Windows XP.

10/06 to Confidential,Quincy MA
08/07 Data Modeler

• Communicate with all stakeholders to collect the business data
• Map data requirement to the Enterprise Logical Data Model (ELDM).
• Compile Business Definitions for new attributes Map data.
• Define data domains, Update Subject Area Life Cycles and define entity state transitions Document.
• Map data requirement to the Operational Data Store (ODS) the Data Warehouse, (DWH) and the Enterprise Data Warehouse (EDW).
• Conduct impact analysis to ODS, DWH and the EDW Size estimates for incoming requests including data mapping, specs & data QA Provide specification
• Support to ETL development, mapping target table columns to source fields
• Provide specification support to Report development

National Provider Identification (NPI)

• Worked on the National Provider Identifier Project. As a Data Modeler, provided Data Model for the Pre NPI Staging area
• Worked on mapping ELDM (Enterprise Logical Data Model) with the NPI Physical model
• Worked on the Data Packets: A process of collecting Business requirement for Reinsurance Project

NDC Data Format Issue (DRUGS)

• Worked on the NDC(National Drug Code) Data Format issue of Express Scripts
• Carried out detailed analysis of converting Xpress Scripts NDC format into 11 digit format of 5-4-2.

First Data Bank Data Implementation (DRUGS)

• Created Data Model of the First Data Bank Drugs Data
• Carried out detailed analysis of the effect of bringing FDB Data into HPHC environment

Plan to Plan Reconciliation (Medicare Part D)

• This project dealt with Medicare Part D data
• P2P Reconciliation leverages existing Prescription Drug Event (PDE) data flow and reporting to resolve situations when Part D plans paid claims in good faith for beneficiaries officially enrolled in another plan (i.e. the plan of record)
• Carried out detailed analysis of P2P data from CMS
• Involved in creating a data model to store the CMS P2P data in HPHC databases

Key Technologies: Erwin 4x, Oracle 9i, Health Care Domain Knowledge, Teradata, SQL Server 2005, Oracle Discoverer, PL/SQL, SQL, MS Access

05/06 to Confidential,Trumbull/CT
10/06 Data warehouse Architect
Billing and Claim Data Mart

• Interaction with the users to understand and collect their requirements.
• Develop Conceptual, Logical, Physical data and process models using Erwin.
• Identified and designed the slowly changing Dimension, snowflake dimension, Fact tables, Metrics and KPIs.
• Documentation (Data Architecture, BUS Matrix, Requirement Specifications, Fact Analysis Matrix, ETL Architecture Document)
• Interaction with the DBA for warehouse configuration
• Developing the ETL Architecture and the concept of incremental updates.
• Designed and developed complex ETL mappings which included data merging from flat files, relational tables. Used mapplets, expression, normalizer, update strategy, aggregator transformations to create the mapping.
• Involved in performance tuning of the mapping and database so that the reporting could be done faster and also the write through put of the database could be increased
• Created Oracle data base specific to data warehouse. Analyzed the average row size to define the DB Block Size, Created different table spaces for data and Index. Turned off the logging in order to increase the write through put of the database. Defined Indexes on Dimensions and Facts.
• Providing Solution and Architecture for the Integration between different modules.
• Created Universe using the warehouse tables. Defined context, solved loop problems by creating table aliases. Also incorporated user defined calculations in the universe.

Key Technologies: Informatica 8, Business Objects 6.5, PL/SQL, Erwin 4x, Oracle 9i, DT Studio, XML, Solaris

04/02 to Confidential,
04/06 TeamLead / Technical Architect

i2 Technologies now acquired by JDA software was global leader in supply chain softwares.
I was a part of the team who build i2 Performance Manager, a product which provided analytics and decision support framework for all of the i2 planning engines, from scratch. The data warehouse which was serving as a backend of the product was built on the principles of Dimensional Modeling. Informatica was used as an ETL tool to populate the Data warehouse. The front end Analytics and Reporting was done on Informatica Power Analyzer. The entire solution was built in phases which encompassed building several Analytical solutions like SCM Analytics, Order Execution Analytics, Transportation Analytics, and Inventory Optimization Analytics.

• Designed and developed ETL for data transfer between SAP r/3 and i2 planning engines.
• Resolved production issues in the product at Sprint, Kansas. I was present onsite for 3 months.
• Implemented i2 Performance Manager at Texas Instruments, Plano TX. I was present onsite for 7 months
• Created several Data marts with the principles of Dimensional Modeling.
• Involved in Requirement Analysis, Functional Specification, Design Document, Project Planning, Coding Standards, Standard Templates, Data Flow Diagrams, E-R Diagrams, Building Data marts, Implementing Quality Procedures.
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source (i2ODS) to Target (i2PM Warehouse) systems using Power Center of Informatica. Involved in data base design and interface design
• Developed complex mappings using mapplets, reusable transformations and other Informatica transformations like Router, Normalizer
• ETL Designs for the Business Adapter in Informatica Power Center 5x, 6x for many Dimension and Fact tables needed for the analytic reporting of the Inventory analysis, Demand analysis, BOM analysis, dimensions like different kinds of Products (All Items, Supplier products, Manufacturing product etc.,) Site, Resource, Scenario, Customer, Seller etc. over the i2 Operational Data Store
• Created Oracle data base specific to data warehouse. Analyzed the average row size to define the DB Block Size, Created different table spaces for data and Index. Turned off the logging in order to increase the write through put of the database. Defined Indexes on Dimensions and Facts

Key Technologies: Informatica Power Center 7.1.2, Erwin, PL/SQL, Oracle, Db2, Informatica Power Analyzer 4.1.1, i2 SBO, i2 MDM, i2 SIM, AIX, Solaris, HP UX