A clean, reliable MRO material master (i.e., spare parts catalog) is critical to EAM software performance and to the overall success of the asset management operation.

Bad MRO data can delay maintenance work and drive up maintenance costs. A well-developed MRO catalog, on the other hand, creates value across the organization. It increases maintenance productivity by ensuring that critical parts are available when needed. It frees up working capital by enabling storeroom managers to eliminate duplicate and excess inventory. It enables smarter MRO procurement by giving buyers the information they need to negotiate contracts and reduce MRO costs.

SwainSmith helps organizations develop a clean, structured and comprehensive MRO material master. We work with all of the major CMMS and EAM software systems, including IBM Maximo, Infor EAM, Oracle eAM, and SAP. We bring deep domain expertise, industry-accepted data conventions, and rich proprietary data libraries to every client engagement.

Material Master Development

SwainSmith’s MRO database development service has four parts: MRO Data Modeling & Standards Development, MRO Data Collection & Preparation, Material Master Database Development, and Material Master Data Management.

Master Data Development

MRO Data Modeling & Standards Development

Before cataloging your MRO parts and materials, we help you to develop models and standards for your MRO data. We determine required fields; establish enterprise-wide naming conventions; build a library of common class and commodity codes; create item records to use as models; and so on. This step makes the data collection process go more smoothly and ensures that your MRO data will be standardized across the enterprise. We use industry-proven naming conventions and coding structures, including:

  • Standard modifier dictionary (SMD) naming.
  • UNSPSC codes and descriptions.
  • SwainSmith’s proprietary library of class and commodity codes.

MRO Data Collection & Preparation

After establishing MRO data standards, we’re ready to catalog your MRO parts and materials. We can do a full storeroom walk-down to identify items and gather data. Or, if you have an existing MRO catalog, we can import that information into your current EAM software system. In either case, we will validate the information and put it through our rigorous data preparation process, which includes cleansing, deduplication, standardization, and enrichment.

  • Site Walk-Down & Item Identification
  • Data Migration
  • Data Cleansing, Normalization, Deduplication
  • Data Enrichment
Material Catalog Entries
Click to see an example of our cleansed and standardized item records.

Material Master Database Development

Once we have gathered and cleansed the raw item data, we build it into a robust MRO catalog in your EAM software system. We analyze and assign criticality rankings for spare parts. We link parts to equipment bills of materials (BOM) and vendor records. We walk through the storeroom again and label items and locations with barcodes. If desired, we can also help you to design the storeroom layout, organization, and location scheme.

  • Criticality Assignment
  • BOM Assignment
  • Barcode Tagging
  • Storeroom Design
  • Materials Organization
  • Location Scheme Development
Materials Master Storeroom
SwainSmith helps clients develop world-class MRO storeroom operations.

Material Master Data Management

Developing the material master is only half the battle. If you don’t maintain it, the catalog will quickly become bloated and out-of-date. SwainSmith helps organizations establish a material master data management (MDM) process to control how MRO item records are managed and who has the authority to edit them. Implementing an MDM process will ensure that your material master stays clean, accurate, and up-to-date.

  • MDM Process Development
  • EAM/CMMS User Groups & Security Controls
Master Data
Basic overview of an MDM process for managing MRO master data.

Build a world-class material master with SwainSmith.

We can build your organization a complete and optimized MRO material master from the ground up. Our service includes:

  • Standards development.
  • Data collection or migration.
  • Data cleansing and optimization.
  • Database development.
  • Storeroom organization and location scheme development.
  • Barcode tagging.
  • Material master data management (MDM) process development.

Some clients engage us only to establish MRO data standards, and then they take over the task of building the material master. If you choose this option, we will develop a small section of your material master—e.g., for a single class of items—and show you how we do it. Then you can use that as a template for what your MRO data should look like across the rest of the plant or enterprise.

Get a complimentary data evaluation.

We’ll take a look at your material master data and give you some ideas for improving it. No charge or obligation—just a quick and friendly assessment.