Enterprise data modeling is a critical component to an overall enterprise architecture, metadata management, knowledge management and information taxonomies, data warehouse design and legacy system replacement.  OCG’s consultant roster includes some of the industry’s best enterprise and project data modelers.

At Starbucks, OCG has provided services for the Supplier Master Data area. The deliverables included a Conceptual Data Model, a Logical Data Model, a State Transition Diagram, Business Rules, and Data Mapping from source to target and logical data model to target.

Other OCG contributions to Starbucks include:

Analysis of store master data requirements and architecture for the Retail Materials Management track of Starbucks’ Global Business Systems Solutions (GBSS) program and creation of artifacts in support of the future management of that data.

Profile & analyze current attributes

Current system documentation

Data Dictionary creation

Validate/Extend Oracle data model and data definitions

Create State Transition Diagrams

Business Rule documentation

Current Physical/Extended API Data Mapping

Conduct Model reviews

Create & Maintain Item Data Enrichment DB Environment with BeIV, Oracle EMEA, Oracle North America, JDA and 5th Source Conversion Data

Data analysis for clean-up

Created Oracle 10g database to store staging area, analytic and new product data tables for data analysis, cleanup & conversion

Browse OCG’s success stories from our valued clients.  Back  Next