SUMMARY:

• Extensive experience in Enterprise Data Strategy, Data Architecture, Data Integration, Big Data Technology and Data Modeling. Designed and Implemented several large projects utilizing a variety of methodologies, and technology design approaches providing a full range of enterprise services and solutions for relational, NoSQL, and multi - dimensional platforms. In-depth knowledge and expertise for
• Information Management in areas of Enterprise Architecture Planning, Big Data/Analytics, IoT, MDM, Data Governance and Data Warehousing. Worked on several large consulting engagements in both private/public sectors: Financial Services, Manufacturing, Insurance, Retail, Energy Services, Pharmaceuticals, CPG,, Aerospace, Telecommunications and Government sector.

TECHNICAL SKILLS:

Project Life Cycle: Requirements definition, Big Data & IoT technology assessment, define future state strategy and roadmap, system design, coding/testing, database tuning and DB Admin

Data Warehousing: EDW relational/dimensional design, star schema/cube design, MDM hub design and BI

Data Base Platforms: Hadoop, HBase, HANNA, Netezza, Gem-Fire, MongoDB, Oracle, Teradata, SQL Server, UDB

Data Modeling: Relational, Dimensional, Canonical,NoSQL, Data Vault, MDM Hub, UML, Structured/Unstructured

Operating Systems: Linux, UNIX - Sun Solaris, Dec Alpha, HP-UX, NT, OS2, MVS

Methodologies: Zachman Framework, TOGAF-V9, Inmon, Kimball, Data Vault, IDEF, IE, Six-Sigma

Management: Director/Manager Practice Lead, Chief Data Architect/Data Modeler, DBA and Project Lead

Other Products/Tools: Erwin Workgroups, ER/Studio, Power Designer, IBM Rational Software Architecture, Data Stage, Informatica, Toad, MS Project, Tableau, Business Objects, Cognos. Hyperion Essbase

PROFESSIONAL EXPERIENCE:

Confidential, Manchester, NH

Senior Solution Architect (contractor)

Hardware/SoftwareOracle, Teradata, Hadoop, MongoDB, Hive, Composite Data Virtualization, Erwin, Informatica, Cognos, Toad

Responsibilities:

• Data Architect for the North East Division of Confidential ’s strategic data team tasked with creating a comprehensive universal data platform supporting structured/unstructured data with standard, consistent, and trusted views of business performance data across the enterprise
• Conducted top-down/bottom-up requirements analysis surveys for client’s enterprise data requirements
• Created POC data models for document and column-oriented databases
• Design/implemented technical operations data mart reporting solutions for tracking technician compliance/performance
• Created conceptual/logical/physical data models using Erwin Workgroups Data Modeler
• Designed an MDM data model for maintaining complex hierarchy structures (balanced, unbalanced and ragged)
• Authored a workshop storyboard approach with use-case illustrations for data modeling reviews

Confidential, Milwaukee, WI

Senior Enterprise Data Architect (contractor)

Hardware/SoftwareHadoop, HBase, Oracle, SQL Server MS-SSIS/SSAS, Erwin, FSLDM, Tableau, Toad

Responsibilities:

• Lead Modern Woodmen’s effort to implement an integrated Logical Data Warehouse and data lake architecture solution that supports both their structured and unstructured data.
• Utilized Zachman Framework providing foundation blueprints for future project development initiatives
• Collaborated with SME to strategize, analyze, and document requirements for life and annuity insurance products
• Created conceptual, logical and physical data models using Erwin Workgroups including POC models for HBase
• Coached teams of data architects and analysis using industry leading practices for an enterprise architecture solution

Confidential, San Jose, CA

Big Data Strategy Architect

Hardware/SoftwareHadoop (HDFS), HBase, MongoDB, Oracle, Tableau

Responsibilities:

• On-Shore Big Data Architect Involved in use case technology assessment
• Participated in multiple requirements interviews and workshops to Identify a comprehensive view of client’s technology stack, data structures, KPI’s, pain points, and a big data technology roadmap vision for a data lake platform
• Created POC conceptual data models for document and column-oriented databases
• Member pre-sales responding to RFI for Big Data, & DV solutions utilizing Hadoop, MongoDB and HANNA platforms
• Responded to an RFP data management solution using an enterprise strategy approach and CMM maturity assessment
• Created Intellectual capital for the practice i.e., data modeling primer and industry models (FSLDM) for the banking industry. Participated in developing an IoT methodology approach for the firm.

Confidential

Hardware/SoftwareOracle, HDFS, SQL Server, SAP, Sybase Power Designer, Erwin Workgroups

Responsibilities:

• Lead the architecture planning strategy effort for Chevron’s chemical division
• Implemented an enterprise data architecture framework/approach (Zachman) for client’s future state big data foundation
• Authored top-down/bottom-up requirements analysis and technology assessment approach for clients Preventative Maintenance & Repair requirements including a comprehensive architecture roadmap for the final readout
• Designed conceptual/logical data models for Hbase and Oracle supporting structured/unstructured data requirements
• Developed star schema data models in support of client’s core M&R Metrics for predictive analytics

Confidential, Washington DC

Enterprise Data Strategy Architect (Consulting Contractor)

Hardware/SoftwareOracle, Gem-Fire (NoSQL in-memory database), ER/Studio, IBM Rational Software Architecture 9.0

Responsibilities:

• Senior member of the Architecture Review Board carrying out comprehensive reviews of Capital Management Integration & Securities Asset Management enterprise design patterns
• Ensured deliverables meet standards for enterprise architecture design, structured/unstructured data, databases, relational and dimensional models, hardware/software technology, data exchange, data governance and data security
• Established scoring criteria checklists and advised with recommendations to the director on corrective action.

Confidential, Atlanta, GA

Manager

Hardware/SoftwareOracle, Erwin8, Informatica

Responsibilities:

• MDM Solution Architect for Merck’s Global customer complaints project.
• Designed the enterprise data foundation layer for the Manufacturing Div. supporting current/future initiatives
• Created Semantic/Conceptual Data Models that support transactional & master data structures for customer complaints
• Develop a data dictionary that included a traceability matric that mapped objects to the data foundation blueprints
• Coach a team of analysis and data architects using data integration best practices

Confidential, Pittsburg, PA

Hardware/SoftwareSQL Server, MS-SSIS/SSAS, Erwin9.2 (workgroups), PPDM, Zachman, TOGAF-V9

Responsibilities:

• Senior Data Strategy Solution Architect for Chevron Upstream Appalachian Michigan Business Unit
• Championed an enterprise architecture planning effort outlining the client’s future state business model for data, process and technology. The plan included a 3-5-year road map for project development initiatives
• Design MDM hub for Well Master including conceptual, logical/physical models for a future Data Foundation Strategy
• The MDM hub supports client’s goal to improve Well exploration, development, production and field management and complies with regulatory policies

Confidential, NYC

Hardware/SoftwareOracle, Erwin7, Teradata FSLDM

Responsibilities:

• MDM Data Architect for Credit Suisse’s client data change program within the investment bank
• Develop a methodology/approach that provided the framework for ongoing data model creation
• Create LDM’s for the MDM Hub including Party, Portfolio, Document, Location and complex Hierarchy structures
• The design accommodates a Hybrid Coexistence style MDM hub for client master data
• Developed work shop use-case data model reviews for business users, IT developers and data architects
• Mentored the data modeling team in the art of data modeling employing industry leading practices

Confidential, Peoria, Ill

Hardware/SoftwareTeradata, Oracle, Erwin

Responsibilities:

• MDM Solution Architect for Caterpillar’s Product Electronic Data Warehouse
• Conducted top-down/bottom-up requirements analysis surveys for client enterprise data requirements
• Designed integrated data model solutions enabling client to establish a single point of truth
• Presented a data integration proposal with comparisons (pros/cons) between Kimball and Inmon approaches

Confidential, Charlotte, NC

Hardware/SoftwareOracle, Toad, Power Designer15

Responsibilities:

• Data Architect for Confidential Global Corporate, Commercial, and Investment Banking Technology organization
• Decommission 2 data marts and extended the Oracle DW models used as their Data Mining and Metrics repository.

Confidential, Minneapolis, MI

Enterprise Data Modeler (contractor)

Hardware/SoftwareTeradata UNIX MP-RAS, FSLDM, Oracle, Toad, Power Designer15

Responsibilities:

• Data Architect for Confidential ’s Home Mortgage servicing DW redesign
• Design supports Integrated Data Environment providing a single source of truth against which data can be reported
• Designed conceptual/logical data models (over 500 entities) in Power Designer using Teradata’s FSLDM template

Confidential, Dallas, TX

Sr. Manager Consultant

Hardware/Software Netezza Linux, Erwin, Model Manager, Power Designer, SAP, Business Objects

Responsibilities:

• Solution Architect for Kimberley Clark’s EDW initiative that supports their strategic capabilities roadmap for innovation measurement, trade promotion, customer relationship management and talent management
• Developed processes, practices, data standards and a data modeling methodology (Data Vault) that associates standard content, structure and format to the appropriate layers of the architecture
• Created relational data models over 1000 entities across 15 data subject areas of the business
• Designed dimensional models and integrated new data mart projects supporting click stream activities
• Defined, implemented and centrally governed data modeling standards and tool nomenclature including tool evaluations.

Confidential, Mclean, VA

Hardware/SoftwareOracle 11g, ER/Studio

Responsibilities:

• Data Architect for Freddie Mac’s financial DW initiative
• Designed the Integrated Data Repository including conceptual/logical data models leveraging their Canonical Data Model with 800 entities supporting over 40 legacy application systems
• Created star schema data models for Single Family Credit, and Forecast Planning

Hardware/SoftwareOracle 10g, Oracle Designer

Responsibilities:

• Enterprise Data Architect for Qwest Communications global enterprise DW for sales, marketing, and overall churn
• Created standards and techniques for load performance, CDC, and history tracking
• Developed data models supporting staging, integration and data mart layers

Confidential, New Haven, CT

Hardware/SoftwareOracle 10g, SQL Server, Erwin, Toad, Hyperion System 9 and Brio IR

Responsibilities:

• Solution Architect for the Universities Capital Management & Budget planning initiatives
• Created conceptual/logical models and translated analytic requirements to dimensional designs
• Solution extends the current Yale EDW & Data Mart environment landscape
• Develop data standards, data mappings, load strategies, CDC, and history tracking solution.

Confidential, Fort Worth, TX

Hardware/SoftwareAIX Server, Oracle, Erwin, Data Stage Enterprise, Hyperion System 9

Responsibilities:

• MDM/Enterprise Solution Architect supporting the DW/BI and MDM solutions for client’s financial services and retail LOB’s
• Developed MDM, ODS and EDW conceptual/logical/physical data models (over 1000 entities)
• Created dimensional models for loan activity, check cashing, collections, customer portfolios and sales