SUMMARY:

• Enterprise Architect with 17+ years of IT experience
• 5+ years of P&C Insurance with Confidential, AAA, and Firemans Fund Insurance
• Certified Project Management Professional (PMP)
• Experienced in Data Warehousing, Business Intelligence and Analytics applications
• Proficient in Big data hadoop technologies
• Solution Architect for Firemans Fund’s MDM (Master Data Management) implementation
• Experienced in all phases of the Data warehouse project life cycle including Requirements Analysis, Data Modeling, ETL and Business Intelligence.
• Excellent Experience in Data Integration - Informatica, SAS DI, Data stage, Microsoft SSIS
• Proficient in Cognos BI Suite - Framework Manager, Query studio, Report studio, Analysis studio
• Extensive experience in Data Modeling, Design, Development and Master Data Management(MDM) .
• Proficient in Ralph Kimball’s Methodology, Bill Inmon Methodology and Hub and spoke architecture

TECHNICAL SKILLS:

BIG DATA: Hadoop, Hive, HBase

INFORMATICA: Informatica Power Center

COGNOS: Query studio, Report studio, Analysis Studio, Metrics studio

SAS: SAS DI, SAS Visual Analytics

Databases: MySQL, Oracle, Netezza, Teradata, UDB/DB2, Informix, SQL Server

Design Tools: Erwin, Sybase Power Designer

PROFESSIONAL EXPERIENCE:

Confidential

Big Data Architect and Data Governance Lead

Responsibilities:

• Data Governance Strategy and Design using Collibra
• Data Quality Strategy and Design
• Target Data Architecture integrating Big data layer, and Teradata MPP
• Roadmap to lead to Target Data Architecture
• Data architecture for Local Media
• Semantic layer design for Business Objects and Tableau Visualizations

Environment: Teradata, Erwin, Informatica Data Quality, Collibra, Hortonworks, Tableau, Business Objects

Confidential

MDM Data Architect

Responsibilities:

• Requirements analysis and design for Customer MDM
• Solution architecture for Customer MDM
• Data Model for Customer, Vehicle, Dealer, Part subject areas
• Data Quality Design
• Data Integration Design
• Cognos metadata layer design

Environment: Oracle Exadata, Erwin, Informatica PowerCenter/IBM Datastage, Cognos 10.x

Confidential

Enterprise Architect Lead, Data Strategy

Responsibilities:

• Requirements analysis and design for Firemans Fund MDM (Master Data Management) program
• Solution architecture for IBM Infosphere MDM
• Designed enterprise solution for addresses scrubbing
• Designed target data architecture for Firemans Fund, and associated roadmap
• Designed consolidation strategy for Claims reporting applications based on Cognos Suite
• Evaluated Data visualization technologies - Tableau, SAS Visual Analytics
• Evaluating Data masking technologies - IBM, HP, TCS
• Project management for Data center consolidation program communications team
• Performed security assessment for Books and records application as part of ACE Integration

Environment: DB2, IBM Infosphere MDM, Erwin, Informatica PowerCenter/IBM Datastage, Cognos 10.x

Confidential

Data warehouse architect/lead

Responsibilities:

• As Data warehouse/Data integration architect/lead, designed and implemented multiple data warehouses including studio operations, ad sales, local media, and home entertainment. As part of Big data task force, created Big data road map for enterprise data warehouse. Established the first hadoop cluster in the enterprise.

Environment: Teradata, Erwin, Informatica PowerCenter 9.1, Business objects, Hadoop, Hive, HBase

Confidential

Data warehouse architect/lead

• As Data warehouse/Data integration lead, designed and implemented best practices and reusable components. Setup the ETL architecture and environment for Customer Data Environment (CDE). Mentored developers and offshore team members on dimensional modeling, and archtectural improvements. Implemented closed loop campaign history data mart to monitor performance of campaigns.

Environment: HP Neoview, SQL server 2012, Erwin, Informatica PowerCenter 9.1, SAS Enterprise Guide

Confidential

Data warehouse architect

Responsibilities:

• Requirements analysis for Enterprise Finance Business Intelligence (EFBI) Auto growth data mart
• Designed Dimensional model for Auto growth data mart
• Optimized the data model for performance, given the large amount of data
• Designed and implemented regression framework for proactive data quality management
• Assisted with business objects metadata layer design and development

Environment: Informatica PowerCenter 8, IBM DB2, Erwin, Business objects XI R3.

Confidential

Data warehouse architect and technical lead

Responsibilities:

• Design of Hub-and-spoke architecture
• Dimensional modeling for spokes such as Travel, Customer Retention, and Claims
• ETL development for Travel data mart on Informatica Powercenter platform
• Mentoring of team members on dimensional framework
• Negotiation with vendors for ETL, Data federation, and Data warehouse appliance
• Designed a customer hub using MDM best practices
• Designed a customer retention data mart to address customer churn

Environment: Informatica PowerCenter, Microsoft SQL Server, Teradata, HP-UX, Erwin, Business objects

Confidential

Data warehouse Architect

Responsibilities:

• Architected d imensional m odel for KPI Metrics
• Requirements analysis and design for POQ Manufacturing Dashboard (PMDB)
• Architected dimensional models for three phases of POQ Manufacturing Dashboard (PMDB)
• Architected and Developed Informatica ETL for the above 3 phases
• Designed and implemented interfaces to and from SAP BI 7
• Designed and implemented POC with Informatica Powerconnect for TIBCO
• Designed and implemented Master Data Management (MDM) framework from the ground-up
• Vendor evaluation for Metadata management tools

Environment: Informatica PowerCenter, Oracle, Sun Solaris, Erwin, SAP BI Netweaver, TIBCO