Big Data Architect And Data Governance Lead Resume
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:
Data Warehousing: 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
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
Privacy Policy
Resume Categories
- .NET Developers/Architects Resumes
- Java Developers/Architects Resumes
- Informatica Developers/Architects Resumes
- Business Analyst (BA) Resumes
- Quality Assurance (QA) Resumes
- Network and Systems Administrators Resumes
- Help Desk and Support specialists Resumes
- Oracle Developers Resumes
- SAP Resumes
- Web Developer Resumes
- Datawarehousing, ETL, Informatica Resumes
- Business Intelligence, Business Object Resumes
- MainFrame Resumes
- Network Admin Resumes
- Oracle Resumes
- ORACLE DBA Resumes
- Other Resumes
- Peoplesoft Resumes
- Project Manager Resumes
- Quality Assurance Resumes
- Recruiter Resumes
- SAS Resumes
- Sharepoint Resumes
- SQL Developers Resumes
- Technical Writers Resumes
- WebSphere Resumes
- Hot Resumes
