SUMMARY:

• Over 25 years experience as a Consultant, working with customers to define solutions, identify and capture requirements, and design data models and databases that provide those solutions.
• Primarily a D ata   Architect , with strong skills as a Data  Warehouse  Architect and   Data   Modeler. Also extensive experience as a Technical Trainer. Clients are mostly Fortune 500 firms and large Governmental entities.

EXPERIENCE SUMMARY:

Data Architect: 22 years’ experience designing data architecture frameworks and databases.

Data Warehouse Architect - 19 years’ experience designing and building standards complaint Data Warehouses. This includes Overall Design, ETL Workflows, normalized DW databases, Data Marts, and specialized BI structures..

Data Modeler, 25 years’ experience creating Conceptual, Logical, and Physical data models, both Dimensional and Normalized. Senior enough that he has taught Data Modeling many times.

BI Architect - 16 years’ experience implementing effective BI infrastructure and architecture.

BUSINESS EXPERTISE:

Financial Services - Experience working in retail banking, mortgage lending, and corporate finance. See Saxon Mortgage client below, and previous employer First National Bank.

HealthCare - Experienced in healthcare systems, data, and informatics in both the Payer and Provider areas. See Blue Cross & Blue Shield, Aetna, and Sutter Health experience below.

Retail - Experienced in retail merchandising, product development, supply chain, inventory management, POS systems, and distribution. See Anheuser-Busch and JCPenney below.

Wholesale Distribution - Experience with products, SKUs, distribution systems, inventories, and logistics.

Manufacturing - Supply-chain redesign and Data Warehouse design for major manufacturer;

TECHNOLOGY EXPERIENCE:

• Expert-level skills with Erwin and ER/Studio data modeling tools.
• 5 years experience working with Informatica as a Data Warehouse Architect (NOT a developer)
• 10 years BI Architecting experience with reporting tools: Cognos, Microstrategy, Business Objects
• 25 years database experience, using DB2, Oracle, Teradata, and SQL-Server primarily

CLIENT WORK HISTORY:

Confidential

Lewisville, TX

Data Architect

Responsibilities:

• Designed Customer model for Installed Base project
• Integrated data from Siebel into Salesforce

Dallas, TX

Data Warehouse Architect

Responsibilities:

• Guided the Data Warehouse Redesign project
• Served as Solution Architect for development projects

Dallas, TX

Data Architect

Responsibilities:

• Designed Data Architecture Framework
• Created Data Architecture Standards, Guidelines, and Best Practices
• Developed processes for using Industry Standard Models

Irving, TX

BI Architect, Data Architect

Responsibilities:

• Big Data Architect. - Developed high-level Big Data Architecture,
• Vendor Liaison – Worked with Oracle, IBM, Teradata, and other vendors
• BI Architect – Standardized BI approach, established consolidated BI architecture.
• Data Architect – Analysis, design, data modeling, source-target maps, DDL Generation

Plano, TX

Data Architect/Modeler

Responsibilities:

• Data Modeling and analysis in the Product and Item business areas.
• Analysis included produc hierarchy, SKU reconciliation across lines of business, and Retail Item consolidation.

Irving, TX

Data Warehouse Architect, Data Architect

Responsibilities:

• BI Architect: designed BI Architecture, created standards and processes
• Data Architect – Designed and modeled Revenue and Operations ODS and Data Marts

Irving, TX

Data Warehouse Architect

Responsibilities:

• BI Architect: created BI architecture, standards and processes.
• Data Architect: designed and modeled BI reporting data, and supported OLTP applications.

Confidential

Durham, NC

Data Warehouse Architect

Responsibilities:

• Data Architect on the Enterprise Data Warehouse .
• Lead Data Architect and Data Modeler for the Claims ODS

Austin, TX

Data Warehouse Architect

Responsibilities:

• EDW Architect: designed the EDW architecture
• Data Architect/Modeler: Designed and modeled the EDW Data Warehouse and Data Marts
• JAD facilitator, data analysis and requirements sessions, including Corporate KPI Analysis

Sacramento, CA

BI Design Architect

Responsibilities:

• BI Architect: Designed and built out the Business Intelligence Information Architecture.
• Designed and established project plans for all phases of the multi-year project.
• Designed and implemented the Enterprise Data Warehouse,
• Established Data Governance processes and roles.
• Defined Process Modeling processes, standards, and tools.

Dallas,TX

Data Warehouse Architect

Responsibilities:

• Data Architect and Data Modeler: Designed and built the Enterprise Data Warehouse
• Manager, Data Architecture
• Established standards and procedures for the Data Management, and Data Governance.

Austin, TX

Principal Data Architect

Responsibilities:

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

Data Warehouse Architect, Project Lead

Responsibilities:

• Supply Chain Project Redesign – Led, in partnership with Price Waterhouse, the teams in redesigning the supply chain to make int more efficient and reduce costs.
• Worked extensively with suppliers, distribution facilities and partners, and product marketing teams to define the optimum supply chain.
• Worked with product to define clean hierarchies for Products, including assemblies/subassemblies, packaging, and customer-level variations.
• Data Warehouse Architect - Designed the Enterprise Data Warehouse and Datamarts.
• Established Data Management, Governance, and Metadata processes/standards.
• Database Consolidation– Consolidated 18 different DMBS platforms into 4.