Case · Master data cleansing · Oilfield services

12,000 MRO records cleansed and a new catalogue process

An oilfield services company kept a 12,000-record material master with no clear structure or classification, poor data quality and duplicates. This led to extra purchases and excess stock, and there was no agreed way to create and change records.

  • Oilfield services
  • 2021
  • 12,000 records
  • ERP
  • 12,000records classified and cleansed
  • 600items confirmed as duplicates
  • 3levels in the new taxonomy, with a template for each class
  • ERPmodule for new records, built by the client on our SOP and tool

The task

A structured catalogue and one way to add new items

The client needed the catalogue cleansed and classified, and a clear process for creating and changing records, so that duplicates do not come back.

What we did

Cleansing and process

  • Catalogue cleansed with automated tools and manual review, duplicates identified
  • Current processes analysed and managers interviewed
  • A new process designed, with a written catalogue maintenance SOP
  • All items placed in a three-level taxonomy, with a naming template for each class
  • A tool for creating new records

Scope

One catalogue, one standard

  • Oilfield services company
  • 12,000 MRO records
  • Three-level taxonomy and naming templates
  • New process and tool for creating records

Results

A catalogue process the client runs on its own

  • A new master data process in place

  • 12,000 records classified and cleansed to the new standards and templates, 600 items confirmed as duplicates

  • The new SOP and tool became the basis for the client's IT team to build a new-record module in its existing ERP

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.