Data Warehouse Architect Resume

SUMMARY

Professional Consultant working with Fortune 500 corporations, federal and state agencies, and businesses of all sizes to create, enhance, and maintain data.
22 years experience as a Data Architect and Data Modeler
16 years experience as a Data Warehouse Architect and BI Architect
Specialties: Healthcare(both provider and payer), Insurance (health and life), Banking (mortgage and retail).
Recruiters, please note teh following

PROFESSIONAL EXPERIENCE

Confidential

Data Warehouse Architect

Responsibilities:

Guided teh Data Warehouse Redesign project.
Solution Architect for development projects
Data Architect: designed a custom Data Architecture Framework for BCBS, specifying data flows between source data, normalized data warehouses, and dimensional data delivery data stores.
Created Data Architecture Standards, Guidelines, and Best Practices, including standards and processes for Conceptual, Logical, Physical, and Semantic models.
Developed processes for using Industry Standard Models

Environment included Teradata, Erwin, DataStage, IBM HPDM Industry Standard Model

Confidential

Data Modeler

Responsibilities:

Big Data Architect. - Developed high-level Big Data Architecture, including designing POCs and evaluating offerings from major vendors such as IBM, SAS, Cloudera, and Oracle.
Created Conceptual, Logical, and Physical Data Models for Telecom.
Data Modeling included Normalized and Dimensional Data Models.
Business Analysis and data analysis of source business and data
Source-Target mapping from source through data warehouse and data marts
SQL and DDL Generation

Tools used: Oracle Data Modeler, Oracle DBMS, PowerPoint

Confidential

Data Modeler/Architect

Responsibilities:

created normalized data model for an ODS for teh Item and Product areas.
Converted an ODS from DB2 to Teradata
Data Architect/Modeler - Created dimensional data models for Revenue and Operations data marts, and a Normalized (3NF) model for teh ODS (Operational Data Store).
Developed modeling and architecture standards and processes

Environment was ER/Studio, MS BI Stack (SSIS, SSAS, SSRS), SQL Server, Microsoft Dynamics GP

Confidential

Data Warehouse Architect/Modeler

Responsibilities:

Designed and created dimensional data models and denormalized extracts for reporting
Created and enhanced OLTP applications models.
Enhanced and updated teh Enterprise Data Warehouse and OLAP models
Data Architect on teh Enterprise Data Warehouse project. Created normalized EDW base layer structures and a virtualized dimensional layer (views) for data delivery (Teradata).
Lead Data Architect and Data Modeler for teh Claims ODS (Oracle)
Assisted in Implementing teh ADRM Industry Standard Healthcare Data Model

Confidential

Data Warehouse Architect

Responsibilities:

Confidential

BI Design Architecture Consultant

Responsibilities:

BI Architect: Designed teh Business Intelligence Information Architecture.
Designed and established project plans for all phases of teh multi-year project.
Led Design and Development of BI Architecture
Data Modeler, created and implemented teh Enterprise Data Warehouse, based on teh teh Universal Industry Standard Healthcare Data Model.
Established Data Governance processes and roles.
Defined Process Modeling processes, standards, and tools.

Confidential

Data Warehouse Architect/Data Modeler

Responsibilities:

Data Architect and Data Modeler: Designed and created teh normalized (3NF) Enterprise Data Warehouse Model
Managed Data Architecture and Data Modeling Team
Established standards and procedures for teh Data Management and Data Models

Confidential

Data Architect/Modeler, Lead Analyst/Facilitator

Responsibilities:

Data Architect and Data modeler: Designed and and modeled teh Central Customer Registry
Designed and modeled teh Federal Title V reporting systems.
Conducted 50+ JAD Facilitated sessions.

Confidential

Data Warehouse Architect/Modeler

Responsibilities:

Project leader - Led project, working with executives, management, and IT staff.
Data Warehouse Architect – Worked to model and design teh Enterprise Data Warehouse and dimensional data marts.
Established Data Modeling and Metadata processes/standards.
Established Data Administration function including Data Governance.
Created a common objects and data reuse strategy.
Mentored Confidential data modeling staff, including teaching data modeling classes.
Database Consolidation– Consolidated 18 different DMBS platforms into 4.