• Worked on creating Logical & Physical Data models Premium Mart, Loss Mart & Profitability Mart.• Worked on Creating Data Vault Policy Admin system and Claim Center in the Enterprise Data Warehouse for Snowflake Data Warehouse as a platform.• Worked design, architecture and development of the Data integration using PowerCenter.

Worked on enhancing Guidewire data model to fit the business requirements.Worked on fit gap analysis between legacy systems and Guidewire application (Policy & Claim Center)Working providing MDM Solution using IDQ to de-duplicate and mastering the Data.Worked on integrating Data from various source systems to the Data Hub.Deeply involved in design of the MDM solution using Informatica MDM Tool.

• Worked on implementing Client MDM using informatica IDQ in remediating the legacy Client systems called Corporate Client.• Worked on Data Modeling with Data Vault methodology .• Worked on remediating Policy Admin and legacy systems in to the Guidewire application.• Deeply involved in implementing Guidewire policy Center, Billing Center, DataHub & InfoCenter. Also, worked deeply on Data remediation • worked on building Data lake using AWS S3.• Extensively worked on Data Modeling to build EDW on Redshift Cloud platform.

Worked as Information Architect. Worked on a migration project for Agency Data as part of sun setting legacy system and integrate with SAP BP/IO to maintain the Agency Hub.Also worked on Encompass Data warehouse in designing NewEra Data warehousing on a Hadoop platform. As a part of this project, AtScale tool has been used to create cubes from Hive Database and same is used for Data Analytics.

American Family Insurance – Information Domain Architect, Madison, WI Responsibilities and Key Successes• Created Solution Design (SAD) & Dimension Model to build the DataMart for Brokerage & Alliance business Entity with in AmFam, to bring the Data in to the Enterprise Data Warehouse. Involved deeply in to the design of ETL Architecture.• Worked as IDA (Information Domain Architect) to implement the Clarabridge Vendor Application to integrate with AmFam Business Applications and CDH (Customer Data Hub).• Worked on enhancing Guidewire data model to fit the business requirements.• Worked on fit gap analysis between legacy systems and Guidewire application (Policy & Claim Center)Environment: Guidewire, ClaraBridge, Oracle, SQL Server, GreenPlum Databases and Informatica 9.6.

Working as Enterprise Data Architect at Zebra Technologies on SalesForce.com platform. Working on project with migrating SFDC instance of Motorola to SFDC Zebra instance and working on implementing Cloud MDM for Account, Contact, Partner & Partner etc..,

Worked as Data/ETL Architect in enhancing and supporting 340B Program at Walgreens.

Currently working on implementing Master Data Management in Enterprise Data Warehouse. Working as ETL Architect for the implementation of MDM to UCM, SIM, Item and RMI in Enterprise Data Warehouse. •Working as ETL Architect to implement the MDM for “CUSTOMER”, “SUPPLIER”, “ITEM” and “RMI (Raw Material Inventory) dimensions and maintain the Golden (De-Duplicated Data) in to the EDW.•Involved in Defining Source Data Integration Mechanism and involved in reviewing Data mapping between Source and Existing EDW Entities.•Involved in defining and preparing EDW Framework to implement the MDM and integrate the Golden (De-Duplicated) Master Data in to the EDW.•Designed and implemented the Re-usable component to build the Cross-reference between Master (De-duplicated) Entities and Existing EDW Master Entities.

 Worked at HSBC for almost 11 years in various roles including ETL/Bi Architect,Solutions Architect, Application Architect (OLTP & OLAP), Technical Lead and Data Architect.  Extensive experience in Database design, Data Modeling, Application design and development. Lead and delivered several critical flagship projects for the Consumer Lending division of HSBC.  Extensively involved in PeopleSoft Application design and as a Lead for major module of the extra large finance application (FTP). Played major role as Lead in Data Warehouse/Migration and BI Projects  Application Design and development experience using PeopleSoft, Power Builder, ETL, OBIEE and Databases such as Oracle 11g, 10g,9i ,Sybase ASE 11, MS SQL Server. Lead the design sessions, worked with Functional users, stakeholders and/or IT staff to define application requirements, ETL/reporting requirements. Played a major role in building business Applications, Business intelligence reports for large user communities Proficiency in gathering Business, Data requirements and converting them into conceptual, logical data models. Experienced in Analysis, Design, Development, Implementation in Supporting of OLAP, OLTP and Legacy Systems Strong knowledge and experience in Dimensional Data modeling (Star/Snowflake) and Relational modeling using Erwin and Power Designer.