Design of Master Data Management

The Goal:

The MDM frame that will provide the organization with a single, accurate set of data populated across multiple systems.

  • Have quality data you can trust
  • Have a single source of truth
  • Answer Fundamental Business questions
    • 360-degree view of the Customer
    • 360-degree view of the Product
    • 360-degree view of the Supplier

The Context:

The current environment of data quality demonstrates existence of more than one definition of the same key data elements, with different understanding at user level or if these are shared across organization there are driven to different level of usage of the same data. Therefore, it is considered that the current status has a high impact on business trustworthy data as a fundamental ingredient of the critical analysis.

  1. There are a few (if none) common clear and/or simple definitions/standards of key data elements that are shared across organization
  • There is no common Customer definition
  • There is no common Item/Product definition
  • There is no Standardized data (format, same understanding)
  1. No common processes for managing and ensuring the integrity of critical data exists
  • Standardized data (format, same understanding, duplication)
  • Periodic data maintenance and updates
  • Complete, secure and accurate information
  • The amount of redundant information
  1. No trust in data which may bring an integrated view of the critical data – i.e.: to proactively ensure customer’s experience, by building a trust based relationship, counselling opportunities and customer inactivity or likelihood of a customer cancelling accounts
  2. No formal ownership and governance rules of data/systems to assure continuous data quality
  3. No formalized management of the existing knowledge about data – existing silos of knowledge that are not documented or formalized and may bring value added services to Customers and Distributors, regarding a common understanding of the global and local data

In order to provide a more comprehensive and trusted information – complete, timely, accurate, consistent, and insightful – Master Data Management implementation becomes an opportunity to deliver more guidance and instruction based on common approaches and techniques inherent to the MDM discipline. The strategic decision is to assure data quality together with data governance to the people and processes that needs it, applied in the same time and in the same way, everywhere.

Estimated Project value of £10m

My role(s):

Hands-on Project Manager, including Business Process Analyst, Product and Process Owner

Areas covered:

All global business areas : Finance, Customer Operations, Sales, Marketing, Manufacturing, Product Management

Systems to be synchronised, developed and/or integrated:

  • Oracle EBS
  • The online store
  • Data Warehouse
  • Force.com (ServiceMax, Service Cloud)
  • Agile R&D

Achievements:

  • Prepared the Master Data Management strategy, wireframe and road-map
  • Defined and documented Critical Data – structured, transactional and non-transactional
  • Defined and documented the 360-degree view of the Customer
  • Defined and documented the Product Lifecycle,
  • Developed and documented the Glossary and Governance wireframe
  • Created the Structured Data framework for global Digital Transformation – concept and modelling, strategy and road-map
  • Defined the global MDM organisation structure, roles and profiles
  • Defined and designed MDM UX and UI

This slideshow requires JavaScript.

My Tasks:

Assisted the “The Domino Way” Global Business and Digital Transformation Program of Domino Printing Science by managing the MDM definition project.

Project Management:

  • Defined and documented Scoping
    • Prepared and held Scoping meeting (workshop) to identify critical data and definitions
    • Identified the goal, objectives and vision
    • Identified the project team, Key constituencies, and decided Steering Committee
  • Gathered business requirements and definitions agreement
    • Held multiple workshops and interviews with Stakeholders and business subject matter employees
    • Documented all business requirements
    • Identified all systems involved and analysed data extracts to evaluate discrepancies
  • Prepared high level plan
    • Used Smartsheet for planning definition
    • Defined the project phases, milestones, deliverables,
  • Agreed critical data and definitions
  • Prepared Project documentation and Budget estimation
  • Defined multiple projects that need to be integrated within MDM
  • Prepared and presented the budget estimation
  • Organised meetings and facilitated workshops with Stakeholders and business subject matter employees, according to the plan
  • Identified project members, and RACI matrix
  • Created project organisation, roles and responsibilities
  • Proposed Communication plan
  • Defined Project planning,Gantt chart and road-map – used Smartsheet tool
  • Prepared and presented periodic Project status reports, presentations, dashboard to Steering Committee, project members and Stakeholders

Business Process Analyst

  • Analysed business and systems processes, created SIPOC and streamlined at high level by overlapping data and process over related systems to impact the Customer Journey
    • Investigated business processes and identified processes containing structured data
    • Investigated management reports to find the most important data
    • Assessed data found and defined the critical data that would be considered Master globally
  • Defined the 360-degree view of the Customer, 360-degree view of the Product, 360-degree view of the Supplier
  • Created value stream process for each of the 3 views, validation rules and high level governance
  • Mapped critical data over each of the 360-degree view processes
  • Defined the Customer lifecycle process

 

! This project has been postponed for Digital Transformation programme change of strategy.

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s