Impact of Service Oriented Architecture on Data Modeling: A Case Study

In an enterprise with multiple data sources resulting in an environment where multiple interpretations of similar meaning data exist, data modeling is a challenge. Supporting services adds to this challenge. We will discuss how data modeling was affected by service oriented architecture using a case study of building an operational data store and an operational data mart.

Attendees will learn:

• How to support service oriented architecture initiatives to provide common derivations and common hierarchies to multiple consumers such as integration, application development, and end-users
• How to enable common services through rationalization, common name space, and common codes in data modeling
• How to leverage and extend solutions into larger problem spaces

Mirza has over twenty years of experience in Information Technology. At Allstate Financial, he is the Data/Integration Architect on a wide variety of strategic projects. He has lead enterprise efforts to support service oriented architecture in modeling data sourced from multiple legacy systems.

Dyuti has over ten years of experience in Information Technology including data modeling and business intelligence. At Allstate Financial, she is actively involved in various strategic projects that focus on enhancing the business intelligence initiatives of the company. She is working on starting a Dimensional Modeling Community of Practice within the organization, which will serve as a forum to establish and share enterprise-wide best practices. Before starting at Allstate, she worked as a consultant on various BI projects involving data modeling, OLAP, scorecards, dashboards, and corporate performance management.