Contact us

Case · Master data cleansing · Oil producer

150,000 MRO records cleansed and master data processes rebuilt

An oil producer with assets in two countries kept one central material master with more than 150,000 records. With no classification, no naming templates and weak processes, it caused excess stock and unjustified purchases.

  • Oil producer
  • Assets in two countries
  • 2022
  • 150,000 records
Discuss your catalogue Master data cleansing
  • 140,000records cleansed and standardised
  • 950naming templates for the whole catalogue
  • 5,600potential duplicates found and resolved
  • $0.9Mprocurement savings potential over 18 months

The task

One catalogue, structured and maintained by clear rules

The client needed a cleansing methodology, a classification for every record type and new master data processes, so that the catalogue stays clean after the project.

What we did

Methodology, templates and cleansing

  • Cleansing methodology developed and agreed with the client
  • A taxonomy and noun-modifier naming templates for each record type
  • The whole catalogue cleansed: standardisation, deduplication, error detection, classification and 40-character short descriptions
  • New master data processes, with documentation and staff training

In numbers

What changed in the catalogue

  • 10,000 records removed as unused or obsolete
  • 140,000 materials cleansed and standardised to templates and cleansing rules
  • 950 templates for the whole catalogue
  • A three-level taxonomy that covers all records

Results

A clean catalogue and processes that keep it clean

  • 5,600 potential duplicates found and resolved

  • Master data processes optimised, documented and handed over to trained staff

  • $0.9M procurement savings potential identified over 18 months

Contact

Let's look at your material master

Tell us the size of your catalogue and your systems. We will propose a cleansing plan and the first steps.

  1. 1
    Task and systems

    What you have now and what you need

  2. 2
    Quick assessment

    Data, processes and IT landscape

  3. 3
    Work plan

    Stages, timeline and scope

0
200000
We use your details to respond to your request. See our Privacy Policy.