EXPERIENCE SUMMARY:

• Project Manager with 18 years of progressive experience covering project management, ETL & Business intelligence architecture, system design & development, team performance monitoring and management for projects under Property & Casualty, Underwriting, Policy Administration & Claims, Reinsurance and Web - analytics (Online Audience measurement systems).
• Project management experience (Indicative)
• Managed Datahub program to help the customer to meet the objective to transform the organization into Customer centric and data driven organization (18 months, Team size - 30)
• Managed Data simplification program to consolidate data from 5 ecosystems into enterprise data warehouse (20 months, Team size - 35)
• Implemented roadmap to replatform Information management applications from Legacy to modern platforms - Confidential Insurance (24 Months, Team size - 20)
• Developed foundational components to build Information factory using (Informatica, Teradata, FSLDM) - MassMutual Insurance (Agile)
• Managed delivery of ETL & BI projects for a large Reinsurance company ( Confidential ) thru Onsite/Offshore delivery model (30 Months, Team size - 20)
• Data modeling experience (Indicative)
• Developed Data model for Annuity & Life Insurance using Teradata FSLDM model - MassMutual Insurance
• Developed Data model for Data warehouse in Teradata platform for P&C insurer using ERWIN - Confidential
• Developed Data model for Surety Policy admin system using ERWIN/SQL Server - Confidential Insurance
• Developed Data model for Information management reporting applications (UK based Insurance company) - ERWIN/Netezza - Confidential Insurance
• Architect experience (Indicative)
• Developed Metadata management solution using Mediawiki to enable crowd sourcing
• Developed Data simplification strategy and ETL architecture to build active data warehouse - Confidential Insurance
• Designed ETL architecture to build Information factory for a leading US based Insurance company (Informatica, Teradata, FSLDM) - Confidential
• BI reporting application conversion assessment (Cognos, Microstrategy) - Confidential
• Designed ETL architecture & reusable framework to convert Information management systems from legacy to Informatica, Netezza, Cognos platform - Confidential Insurance
• Had owned and executed development projects in various technologies including Data warehousing, Business Intelligence, Oracle applications, J2EE, Mainframe, .net & Content Management services (Documentum - EMC2)
• Has coding experience on Informatica, Cognos, Teradata (BTEQ), ERWIN, Oracle PL SQL, Mainframe, Java technologies
• Has exposure to Big data platforms such as Hadoop, Cassandra, Python, & R language

CORE COMPETENCIES:

• Project Management
• Business Intelligence
• Teradata
• Data Modelling
• Data Warehousing
• Insurance, Reinsurance
• Java, Mainframe technologies
• Application Development & maintenance
• Big data

PROFESSIONAL EXPERIENCE:

Confidential, Springfield, MA

Technical Project Manager

Responsibilities:

• Develop roadmap, high level, & low level project plans to build Data hub
• Conduct workshops to review data, & reporting requirements with business sponsors, SME, & Business analyst
• Budget planning (Estimation of cost & effort to complete the project)
• Process management (Definition of governance process, test strategy, acceptance criteria, templates finalization etc)
• Risk & Issue management – Risk monitoring and identification of mitigation plan. Issue tracking and resolution to address the issue
• Design data model for DW based on Teradata FSLDM (Highly normalized 3NF model)
• Design ETL architecture to develop data integration process
• Design reusable ETL framework to develop ETL components
• High level design of data integration process
• Discuss & walk thru documentation (Architecture, data model, ETL design) with Tech leads, Business and analysts

Technology: ERWIN, Teradata, Informatica MDM, Informatica Power center & power exchange

Confidential, Springfield, MA

Data architect

Responsibilities:

• Review requirements with Business sponsors and business analyst
• Design structures for Metadata pages (MediaWiki, MySQL, ERWIN)
• Design processes to validate, integrate & load metadata
• Develop & unit test integration process (Python, MySQL)
• Design processes to automate data validation
• Discuss & walk thru documentation (Architecture, data model, ETL design) with Tech leads, Business and analysts

Technology: MediaWiki, Python, MySQL, PHP

Confidential, Dover, NH

Architect

Responsibilities:

• Collet and review future reporting requirements with Business users & business analyst
• Perform current state assessment (Inventory collection, reports usage analysis, complexity analysis, gap analysis)
• Define approach to migrate reporting application
• Develop high level road map

Technology: Cognos, Microstrategy

Confidential, Dover, NH

Technical Project manager

Responsibilities:

• Conduct workshops to review data, & reporting requirements with business sponsors, SME, & Business analyst
• Review data requirements with SME
• Budget planning (Estimation of cost & effort to complete the project)
• Process management (Definition of governance process, test strategy, acceptance criteria, templates finalization etc)
• Risk & Issue management – Risk monitoring and identification of mitigation plan. Issue tracking and resolution to address the issue
• Design of data model for the Data warehouse (3NF model)
• Design of DataMarts (Snowflakes model)
• Perform Data analysis, data profiling of the source data and identification of data translation and standardization rules
• Design reusable ETL framework to develop ETL components
• Design ETL processes to migrate and consolidate the data from 5 different echo systems
• Design ETL processes to produce data extraction feeds to the downstream systems
• Provide SME support to the enterprise data management to set up data governance process
• Provide SME support to build APIs to exchange data

Technology: ERWIN, Teradata, Informatica Power center & power exchange

Confidential

Technical Project Manager

Responsibilities:

• Conduct workshops to review future reporting data requirements with Business users, SME, &
• Perform gap analysis and provide recommendations
• Budget planning (Estimation of cost & effort to complete the project)
• Process management (Definition of governance process, test strategy, acceptance criteria, templates finalization etc)
• Risk & Issue management – Risk monitoring and identification of mitigation plan. Issue tracking and resolution to address the issue
• Design datamodels for DW (3NF) & Datamart (Star schema)
• Perform Data analysis, data profiling of the source data and identification of data translation and standardization rules
• Design reusable ETL framework to develop ETL components
• Design ETL process to migrate historical data
• Design ETL process to integrate real time data
• Provide SME support to design Framework model for reporting applications

Technology: ERWIN, Netezza, Informatica, Cognos, MSBI technologies

Confidential

Data modeler

Responsibilities:

• Conduct discussions with Business sponsor to review the system requirements
• Design conceptual model, logical & physical data model using ERWIN (3NF model)
• Design data mapping specifications
• Conduct knowledge sharing sessions with Tech lead, & SME on the data model

Technology: ERWIN, SQL Server, .Net

Confidential, Sunnyvale, CA

Project manager

Responsibilities:

• Scope Management
• Budget Management
• Activity Planning and Execution
• Team Building and Management
• Progress Monitoring and Status Reporting,
• Risk Identification and Management,
• Allocation of Work to Team,
• Work Monitoring, Work Tracking & Deliverance
• Process Definition & Improvement for Requirements

Technology: Netezza, Unix, Shell scripts, Java, SQL Sever

Confidential, Trumbull, CT

Project Manager / Data architect

Responsibilities:

• High level ad low level project planning, status tracking and reporting, and resource management
• Process management (Definition of governance process, test strategy, acceptance criteria, templates finalization etc)
• Risk & Issue management – Risk monitoring and identification of mitigation plan. Issue tracking and resolution to address the issue
• Review data requirements for the document management systems
• Design data model for the Metadata reference layer (Star schema)
• Perform data profiling to identify data anomalies
• Conduct workshops with SME to identify rules to scrub the data
• Design ETL process to load data to reference layer
• Develop & unit testing ETL components

Technology: ERWIN, Informatica, DB2, EMC2 Documentum

Confidential, Trumbull, CT

Data architect

Responsibilities:

• High level ad low level project planning, status tracking and reporting, and resource management
• Process management (Definition of governance process, test strategy, acceptance criteria, templates finalization etc)
• Risk & Issue management – Risk monitoring and identification of mitigation plan. Issue tracking and resolution to address the issue
• Conduct workshops to review the data requirements and future reporting requirements with business users, application SMEs & Business analyst
• Designed Data model (Conceptual, Logical, & Physical data models) for the Data warehouse (Relational model)
• Design reusable ETL framework to build data integration components
• Design data migration components to migrate historical data from ODS (one time)
• Design high testing strategy

Technology – ERWIN, Informatica, DB2, Oracle

Confidential

Project manager/Data modeler

Responsibilities:

• High level ad low level project planning, status tracking and reporting, and resource management
• Process management (Definition of governance process, test strategy, acceptance criteria, templates finalization etc)
• Risk & Issue management – Risk monitoring and identification of mitigation plan. Issue tracking and resolution to address the issue
• Design Data model (Conceptual, Logical, & Physical data models) for the Unified Facultative system (OLTP)
• Design data mapping specifications
• Design, Develop, & test data migration components to migrate the historical data

Technology: ERWIN, DB2, J2EE, Informatica

Confidential

Data modeler/Tech lead

Responsibilities:

• Design Data model (Conceptual, Logical, & Physical data models) for the Unified Facultative system (OLTP)
• Design data mapping specifications
• Develop & Unit test batch programs to migrate the historical data from existing Mainframe applications

Technology: ERWIN, Mainframe, DB2 Stored procedures, Informatica

Confidential

Data modeler/Tech lead

Responsibilities:

• Design Data model (Conceptual, Logical, & Physical data models) for the Claims reporting mart (Star Schema)
• Design data mapping specifications
• Design, Develop, & Unit test ETL components using Informatica
• Demonstrate tool capabilities to customer

Technology: ERWIN, Informatica, SQL Server, Business objects