OBJECTIVE:

• A data architect, data modeler, or database designer position to build and implement either operational or analytic databases.

PROFESSIONAL EXPERIENCE:

Confidential

Business Intelligence/Data Warehouse Data Architect

Responsibilities:

• Unified Data Warehouse logical data model
• Based on Teradata’s Healthcare Industry Logical Data Model
• Ingenix Sales, Marketing and Product Analytics Logical Data Model
• UHG Common Grouper & Quality Monitoring Repository
• Conceptual Data Model
• Logical Data Models
• Premium Designation Logical Data Model
• Foundational Services
• Data Modeling Framework
• Industry Data Model
• Data Modeling Standards & Procedures
• Model Management Process

Confidential

Business Intelligence/Data Warehouse Data Architect Consultant

Responsibilities:

• Ovations Command Center Requirements Gathering
• High Level Command Center Information Requirements
• High Level Data Model
• Ovations Part D Analytics
• Data dictionary
• Data models

Confidential

Business Intelligence/Data Warehouse Data Architect

Responsibilities:

• SAP Financial database design (star schema) - refine existing structures to replace SAP/BW
• S905
• Special Purpose Ledger
• CO-PA (Profitability)
• SAP Sales & Distribution database design (star schema)
• Sales Order, Shipment, Schedule Line, Delivery & Handling Unit
• Distributor Sales Invoice & Inventory database designs for personal data source, staging, ODS, and data warehouse (star schema)

Confidential

Data Warehouse Data Architect Consultant

Responsibilities:

• Finalized Claim Business Event/Process analysis, source, database design (star schema) and program specifications.
• Business Event/Process analysis, source, database design and program specifications.
• Medicare Data Staging analysis, source, database design and program specifications.

Confidential, Richfield, MN

Enterprise Data Architect Consultant

Responsibilities:

• Analytic Requirements (enterprise-wide) for Teradata data warehouse.
• Business Operating Blueprint (enterprise-wide process model) analysis (business metrics) for Teradata data warehouse.
• Confidential data warehouse logical data model to Teradata Retail Logical Model mapping for Teradata data warehouse
• Customer operational and analytic database usage analysis to support data integration.

Confidential, Richfield, MN

Enterprise Data Architect

Responsibilities:

• System of Record specification (enteprise-wide application and databases) to support identification of original, master and variant data sources for a variety of operational and data warehouse projects
• Network Integrated Confirguration Management data model (database design) to support application package selection and implementation.
• Integration - Canonical Models.
• Metadata Models
• Confidential data warehouse logical data model
• Tools
• MS/Office - Outlook, Word, Excel, Powerpoint, Visio, Access, Project
• Sybase - Powerdesigner Data Modeling Tool
• Oracle

Confidential, Minnetonka, MN

Enterprise Data Architect

Responsibilities:

• Credit Risk 3.0 & 4.0 releases of the Proprietary Database Design (star schema).
• Enhancement Services Application Database Design (operational).
• Collections MIS operational data store (operational) and data mart database design (star schema).
• Internet application lookup database design (operational).

Confidential, St, Paul, MN

Data Modeler / Data Architect

Responsibilities:

• Enhance and maintain two separate large financial services company operational data store and data mart (star schema) database design.
• Metadata repository logical and physical data models for a large financial services company to support their decision support systems at Confidential, Isaac. This metadata repository was implemented in Oracle with a Business Objects front end.
• Large car manufacturer operational data store (operational) and data mart database designs (star schema)

Confidential, Minneapolis, MN

Data Modeler / Data Architect

Responsibilities:

• Loan origination logical data model to support application package selection.
• High level data mart and warehouse requirements to assist business identify the first data mart to be built in the overall enterprise data warehouse architecture.
• Data warehouse architecture for Confidential defining hardware and software tools and technologies used for the data warehouse.
• Six iteratins of operational data store for Confidential .

Confidential, Wayzata, MN

Data Modeler / Data Architect

Responsibilities:

• Sales Order Management business process and logical data models for the Molasses Division.
• Worldwide Finance project data model for JD Edwards financials to promote the enterprise-wide data sharing initiative within Confidential .
• Navigator Systems Series information engineering methodology and ADW case tool rollout to Confidential divisions.
• Confidential Data Warehouse Development Methodology based on Navigator Systems Series and HP best practices.

Confidential, St. Paul, MN

Data Modeler / Data Architect

Responsibilities:

• Customer Information System logical data model for Abrasives Division.
• Leads & Contact Management System logical data model for Sales Reps.
• Human Resources Benef Confidential logical data model for HR.
• Receivables Management System logical data model for Finance.
• Global Import Management System logical data model for Global Imports.
• Sale Order & Shipment History Data Warehouse for Logistics and Finance.
• Product Information System logical data model.