Industrial Distribution company resolves Data Management challenges with Oracle MDM PIM solution

Highlights
  • Industry

    Industrial distribution

  • Business units:

    Facilities

    Maintenance

    Waterworks

    Power solutions

    White Cap

  • Employees

    15000

  • Solution Footprint

    Implemented MDM PIM solution using Oracle E-Business Suite

Customer Overview

Our client is a leading distributor of specialty hardware, tools and safety materials for professional contractors. The company offers an extensive product inventory, combined with will-call, site delivery and direct-ship options. Employing the most knowledgeable pros in construction supplies, including hundreds of outside account managers, our client ensures professional solutions and unmatched customer service.

Business Challenges

The company intended to establish Master Data Management (MDM) and Product Information Management (PIM) governance within their current ERP inventory operations and new product introductions to further publish good quality product data to various product data channels.

The customer had these key MDM needs:

  • Establishing single Master product data governance subsequently after ERP inventory process
  • Product data stewardship and management of daily product data updates
  • Incorporating independent New-Product-Build-In product data
  • Complex governance by functional roles of Environmental Health & Safety, Pricing, Data custodians & Data steward groups
  • Migration and consolidation of manual source item data and conversions of unstructured product content and classifications
  • Single source view and management of specific product ERP data
  • Supporting enriched quality product data for superior and growing ecommerce and print catalog systems
Birlasoft Solution

Birlasoft successfully implemented the MDM PDH system for the needs and challenges of the customer with the following solutions:

  • Implementing an MDM PIM system within the framework of Inventory ERP using Oracle EBS
  • Configuration of product hierarchy, item data schema and metadata into PDH
  • Conversion, cleansing and normalization of source item data catalogs with enhancement of item data schema through modular PDH object import and rules
  • PDH configuration of the Master taxonomy and item data schema with attribute groups and attribute rules
  • PDH functional configuration of product governance and workflows for various department reviews and approvals
  • Implementation of specialized PDH forms and functionality for New-Product-Build-In using change management customization in EBS PDH
  • Implementation of ERP Organization level field management in single view using customized Oracle PDH forms and underlying EBS package functionality
  • Implementing the publishing of Master Product data to specific content needs and templates for the WebSphere Commerce system
Benefits
  • Integrated, seamless and controlled product data flow and management in ERP, MDM PIM and ecommerce operations has allowed organization to provide more product data and increase business
  • Prevention of product data errors and reduction in time of product data management with 1+ million attribute values
  • Reduction in time to market of new, updated and enriched product data to ecommerce
  • Ability to introduce and market more products for ecommerce with increased sales of 43% in first year!
  • Reduction in time and effort for Introduction of New-Product-Build-In products for immediate use allowing resource to increase product introductions
  • Reduction in time and effort for Product ERP data management by 75%
  • Master product data readily available for additional on-demand channels
Pre-mdm-architecture
 
Post-mdm-architecture