RETAIL MASTER DATA MANAGEMENT

ORGANIZATION

The Client is leading privately held grocery supermarket chain operating over 300 stores in 3 states across the south-eastern United States. The retail grocery chain operation is spread over multiple categories including grocery, drugs, fresh produce and baked goods.

The Client wanted to implement a Master Data Management solution across multiple enterprise systems for standardizing, harmonizing and stabilizing the global Master Data elements.

CHALLENGE

The Client had previously implemented a large number of business systems that each needed to individually access the most recent and accurate version of the enterprise wide master data. This resulted in different and often inaccurate values for the same copies of master data, and adversely impacted the efficiency of business processes, data reporting and related analytics. As a part of the Information Management Program, a strategic initiative to address the management of four key master data elements – Item, Vendor, Store, and Warehouse was chartered. The key challenges that the business users experienced included:

 
  • Business users working with incorrect set of data attributes
  • Business users working with incomplete master data
  • Business users working simultaneously on different data values for the same Master Data entity
  • Individual departments using different systems to obtain information on the same item

The lack of master data management ultimately resulted in additional costs and potential revenue loss remained high across the enterprise.

CURRENT TECHNICAL LANDSCAPE

The client did not have a centralized system of record for the creation, storage, usage and maintenance of master data elements across the varied enterprise systems. Individual business units had the same type of master data stored in different systems for example, the Item Master for the business units was stored in 3 primary systems.

  • Product merchandising management
  • Legacy system
  • Direct to store delivery system

Each individual system played the role of Gatekeeper for different attributes of a given master data element. Existing state for the master data was as follows:

  • 100+ applications containing Master Data
  • 300+ Item attributes managed in nearly 30 applications
  • 200+ Vendor attributes managed in nearly 14 applications

SOLUTION

XTIVIA employed a comprehensive Master Data Management (MDM) strategy for the client based on the approach of each organization employing a single source of truth. The MDM strategy implemented the approach – leveraging Enterprise Application Integration and Service Oriented Architecture (SOA), in lieu of implementing a single product-based MDM solution.

The MDM solution further predicated these points for each attribute of the given master data:

  • A Single Data Owner
  • A Centralized Application
  • A Unified Data Management Process

The deployed solution was characterized by:

  • Designating master systems for different attributes for a particular master data entity
  • Utilizing Services for master data management
  • Synchronizing master data across individual business systems

The following types of Services were designed and implemented to realize the solution:

PUBLIC SERVICES

Available for any application to invoke. They provided transparency to the consumer applications, from the data ownership systems and the underlying business logic. They provided the users with the right set of data values for different department and different systems.

PRIVATE SERVICES

Built on the individual applications, provided the master data attributes for those attributes it effectively owned. These private data services provided the relevant attributes to the public service that invoke it. The end user applications had no direct access to the private services. These private services provided the decoupling from the public service, providing flexibility to change the underlying implementation.

SYNCHRONIZATION SERVICES

Synchronized the master data attributes once the data owner authorized the content for public consumption across all the required enterprise systems.

RESULTS

The deployment and adoption of the MDM solution brought about numerous benefits:

  • Providing relevant, accurate and complete set of data attributes in a timely manner thereby greatly reducing and eliminating costly manual errors
  • Enabled analytical reporting on historical data (ranging from just days up to 5 years)
  • Providing flexibility to change ownership for various data attributes for a given master data
  • Deploying reusable services that could be used by various applications – thus reducing future costs in implementing the same functionality
  • Adopting a set of standards for master data access in lieu of each application building a customized and costly data access mechanism

KEY COMPONENTS

TECHNOLOGY USED

TIBCO™ – BusinessWorks; EMS; Hawk

TIBCO™ – Teradata Adapter; File Adapter

TIBCO™ SDK

TIBCO™ Administrator

Teradata®

Download the Case Study PDF here