EXPERIENCE SUMMARY:

• Have 11.5+ years of experience in IT industry and worked in all lines of insurance business (Life, Confidential ) and Retail Healthcare and Pharmaceutical Industry
• Worked extensively in Data Warehousing and Business Intelligence areas in the roles of Data Architect, Data Modeler, Data Integration/ETL Architect and BI / System Analyst of Information systems
• Designed Information/ Data Architecture for Insurer belong to North America adhering to the architectural standards of Confidential
• Modelled data models for Enterprise Data Warehouse, OLAP, OLTP and MDM (Master Data Management) systems adhering to industry standards for data warehouses
• Have designed data models using both dimensional modelling and relational modelling techniques
• Have strong expertise in customization of Insurance standard data models like Confidential ’s IIW (Insurance Information Warehouse), ACORD LAH data model, Teradata’s Financial Services Logical Data Model, Healthcare and Retail Data Models.
• Have done extensive data profiling for source system data to identify the data quality issues up - front
• Worked in complete Software Development Life Cycle (SDLC) using both waterfall model and Agile methodologies
• Have strong exposure to insurers belong to diverse regions across USA, Confidential and worked with various stakeholders and in multi-vendor environment
• Highly enthusiastic and energetic professional with ' Confidential ' attitude and successfully led many larger and complex IT programs
• Excellent interpersonal skills, oral and written communications skills. Ability to think strategically to gain business insight and create a competitive advantage for an organization

TECHNICAL SKILLS:

Industry Data Models: Confidential ’s IIW Data ModelTeradata FSLDM, Retail and Healthcare ModelsACORD LAH Model.

Databases: Teradata V15, V14, V13.10, V13Oracle 11g, 10g Oracle Exadata

Data Modeling Tools: Erwin Data Modeler MS Visio

Informatica Products: Informatica PowerCenter 9.1/9.0/8.6Informatica B2B and Analyst. Informatica MDM

Programming Languages: SQL, PL/SQL, Java 5.0, C, C++, COBOL

Other Industry Leading Tools: HP QualityCenter, HP QuickTestPro

Industry Leading Admin Systems: Oracle’s AdminServer Admin System, FASAT Agency Admin System, Data Masketeer

PROFESSIONAL EXPERIENCE:

Data Architect, Modeler

Confidential

Responsibilities:

• Part of Data Architecture team, executed multiple projects ranging various projects in Teradata, Oracle and Exadata warehouses.
• Formulate Principles & Guidelines that forms the core for the Data Warehouse
• Document Architecture Design Document that includes Data Flow, ETL specification, Data Models and non-functional requirements.
• Have worked and maintained the data models of data warehouse platforms present in both Teradata 14, 15 and Oracle 11g, Exadata databases
• Built Enterprise Data Warehouse data objects in Relational Data Model following CIF methodology and Reporting Layer/ Data Marts in Dimensional Modeling
• Adhered to and customized Industry Data Models Teradata Retail and HealthCare Data Models using CA Erwin Data Modeler
• Have involved in Requirement Analysis, Data Integration / Ingestion (ETL) Strategy for end-to-end data flow, Logical and Physical Data Models, documentation of mapping specification and deployment of DDLs in Non-Production and Production environments
• Create Physical Data Models that provide excellent performance for reporting environment and do Performance Tuning of existing reporting queries
• Have involved in Data Retention and Purging framework of historical and inactive data
• Been part of two large migration projects that involved infrastructure migration and platform migration.

As Data Architect, Modeler and ETL Architect:

Confidential

Responsibilities:

• One of the assignment is to lead and executed the decommission of existing legacy data warehouse present in Mainframe DB2 database and migrate both Policies and Quotes of Personal LOBs Homes, Motor and Travel to a new database on Teradata platform. Also decommissioned existing DB2 marts and build new data marts over new database to meet business user needs for reporting.
• Designed an agnostic data model designed to fit all lines of businesses of Insurance such as both Personal and Commercial lines of business.
• In other assignment, built Integrated Data Store for Guidewire Policy Center and Claim Center following Teradata FSLDM model, and provide data to downstream applications for finance and compliance purpose.
• Used Informatica B2B for reading XML messages generated from Guidewire System
• Have worked and maintained the data models of data warehouse platforms present in Teradata
• Built data models for both Enterprise Data Warehouse and Data Marts in Dimensional Modeling using Erwin Modeler
• Designed Data Acquisition and integration of 8 source systems
• Have involved in Requirement Analysis, Data integration (ETL) Strategy for end-to-end data flow, Logical and Physical Data Models, documentation of mapping specification, deployment of DDLs in Non-Production and Production environments and Onshore-Offshore coordination for smooth delivery

As Data Architect, Data Modeler:

Confidential

Responsibilities:

• Designed a Data Model for MDM Broker Data Hub which provides a single (golden) source of truth for master data of all broker information that will be accessible across the enterprise, multiple applications and business units. Used Informatica ( Confidential ) MDM tool, Informatica PowerCenter and Erwin Data Modeler on Oracle Platform
• Used Informatica Data Analyst for data profiling of various sources contributing MDM Broker Data Hub.
• Prepared Data Architecture and interaction Diagrams following Confidential (The Open Group Architecture Framework) for North America Life, Annuity and General Insurance company to adhere to Solvency II regulation
• Performing fitment test of IIW V8.3 and V8.4 against Solvency II Data Elements and prepare due-diligence report
• Preparing Conceptual Data Model (CDM) in ERWin Model as per Confidential ’s IIW Business Model V8.4
• Designed Logical and Physical Data Model for storing Contingent Profit Commission component from existing Insurer systems as part of Solvency II regulation.
• Designed Conceptual, Logical and Physical Data Model for Confidential of Insurance Company adhering IIW v8.3 to Confidential the risk exposure of insurance company as part of Solvency II regulation
• Have involved in Requirement Analysis, Data integration (ETL) Strategy for end-to-end data flow, Logical and Physical Data Models, documentation of mapping specification, deployment of DDLs in Non-Production and Production environments and Onshore-Offshore coordination for smooth delivery

Data Modeler, Business System Analyst, ETL Designer

Confidential, Des Moines, IA

Responsibilities:

• Played a critical role in design of Enterprise Data Warehouse on Teradata platform as part of Reporting and Analytics initiative of Leading US Insurer
• Modelled various subject areas such as Party, Agreement, Money Provision, Financial transaction, Contact Point and Preferences, Communication, Account etc, adhering Confidential ’s IIW for both Life and Annuity business using Erwin Modeler and following IIW roadmap
• Designed Data Acquisition and Integration strategy using Informatica Powercenter and provide Mapping Specifications for various source systems
• Designed Information System that reconciles Financial Transactions from Source Systems against General Ledger transactions from Oracle E-Business Suite.
• Also designed Operation Data Store (ODS) using ACORD LAH Data Model to serve various downstream systems and standardise and integrate all source systems into one single layer as both Data Modeler and ETL Designer
• Also player as Business System Analyst in gathering the functional requirements and converting them to technical specifications

As ETL Developer

Confidential, Des Moines, IA

Responsibilities:

• Performed the role ETL developer creating mapping specifications in Informatica PowerCenter tool
• Build and test reusable codes following modular design approach
• Perform unit testing and support Testers in Defect Management

As Developer, Tester

Confidential, Des Moines, I A

Responsibilities:

• Played a critical role in migration of the legacy application ‘Select Universal Life’ in DOS environment to Windows 2003 Server environment. The Character User Confidential (CUI) screens in DOS environment were converted to Graphical User Confidential using Confidential Screen IO. The existing flat file database BTRIEVE was upgraded to Pervasive SQL 9.0. Reports which were being reported from EZPage were converted to be generated using Report Writer.
• Mask production data using TCS Masketeer tool for using in development and testing environments
• Involved in end-to-end activities for entire life cycle of migration project
• Also played as DEV lead in successful completion of various developer assignments