MRO Material Master

Data Cleansing

Developed and refined over 28 years of business, IMA’s industry leading MRO Material Master Data Cleansing services ensure the highest level of data quality and consistency.

As pioneers in MRO (Maintenance, Repairs and Operations) data management, IMA offers a data cleansing service unlike any other. IMA understands that each customer and industry is unique, therefore, materials data must be cleansed accordingly. Using a strategic combination of automated and manual procedures, along with industry best practice standards, IMA is able to tailor data to the specific business and system requirements of each customer. Throughout the process, IMA standardizes, enhances, and validates raw data to provide a material master that is consistent, attribute-rich, and free of duplication. Once clean, materials data is then formatted to meet the specific configuration requirements of the chosen ERP/EAM/CMMS, including field type, character limitation, and data arrangement.

Service Levels

 

In an effort to meet the business requirements, objectives and budgetary constraints of each customer, IMA offers three Data Cleansing service levels: 

Example:  Ball Brg 25mm 62052rs Skf

Level 1 | Cosmetic Cleanse

Standardize Manufacturer Name and Part Number, Assign Noun-Modifier Naming Convention

Example:  BEARING, BALL, 6205-2RS, SKF

Level 2 | Standardization

Standardize Manufacturer Name and Part Number, Assign Noun-Modifier Naming Convention, Standardize and Validate Existing Part Description

Example:  BEARING, BALL, 25MM ID, 6205-2RS, SKF

Level 3 | Enhancement

Standardize Manufacturer Name and Part Number, Assign Noun-Modifier Naming Convention, Standardize and Validate Existing Part Description, Enhance Description with Additional Attribute Information

Example:  BEARING, BALL, 25MM ID, 52MM OD, 15MM WD, CONRAD, SINGLE ROW, LIGHT DUTY, 2 SEALS, STEEL, 6205-2RS, SKF

Tools and Methodology

 

IMA utilizes a proven combination of proprietary software, manual subject matter expertise and industry best practices. Throughout 28 years of business, IMA has developed and continues to refine an internal cleansing toolset, which includes the proprietary IMA Noun-Modifier Dictionary, Master Parts Library and Data Mining Software. 

The IMA Noun Modifier Dictionary is an internally developed best practice naming convention for MRO parts and services. The Dictionary is comprised of 2,200 Noun-Modifier pairs, each with 5 to 7 (or more) descriptive attributes. The IMA Noun Modifier Dictionary may be modified and customized as required based on customer and industry requirements.

The IMA Master Parts Library is a dynamic and continuously growing data repository, which contains millions of MRO and OEM part records, each with consistent, validated, attribute-rich descriptions. The IMA Master Parts Library is one of IMA's most valuable intellectual assets, which is used exclusively for internal data cleansing services, and is not available to the market. 

MRO Product Classification

 

IMA is proud to support various international and custom MRO product classification systems to suit the unique requirements of each customer. Based on the business objectives, industry, and application, IMA is able to accurately implement and maintain product group (class) codes and descriptions for each individual material record, enabling maximum spend visibility and leverage opportunities. What that means is that Procurement professionals can spend less time sorting through data and more time establishing preferred vendor programs to achieve spend reduction targets.   

 

IMA Product Group Classification
IMA provides best-practice MRO Product Group Classification based on a simple Category/Sub-Category schema, which enables high level spend visibility. In total, there are seven parent MRO product groups, which are further segmented into detailed sub-categories.

  • Category / Sub-Category Structure

  • 4-Digit Code Format 

  • 7 Parent Categories

  • Over 75 Sub-Categories

  • Customizable to suit business requirements

UNSPSC Classification

The United Nations Standard Products and Services Code (UNSPSC) provides an open, global multi-sector standard for efficient, accurate classification of products and services. IMA will utilizes the most recent version of the UNSPSC codeset (unless advised otherwise by the customers) and maps MRO parts to the 4th level. UNSPSC levels include:

 

XX – Segment

XXXX – Family

XXXXXX – Class

XXXXXXXX – Commodity

Custom Classification

IMA is able to provide Custom Coding as requested by the customer. Custom Coding may include country-specific tax coding, various industry-specific classification systems, and any custom classification or coding system that has been developed and utilized internally by the customer.

Features

  • Utilizes a proven combination of software, manual subject matter expertise and industry best practices

  • Tailored to customer preferences and business requirements 

  • Follows a comprehensive project workflow with milestones and KPIs 

  • Weekly progress meetings held via GoToMeeting™

  • Multi-lingual translation capabilities

  • Duplicate Identification and Consolidation

  • Efficient Part Search Ability

  • Avoidance of False Stock-Outs

  • Increased Maintenance Productivity

  • Maximized ERP/EAM/CMMS Functionality and Reporting

  • Improved Spend Visibility

  • Enable Inventory Optimization

  • Enable Efficient Asset Management 

Benefits

BEFORE

ITEM NUMBER

 

MANUFACTURER

PART NUMBER

 

DESCRIPTION

123456 

 

 

 

 

25mm Ball Brg, 62052rs Skf

 

                       

AFTER

ITEM NUMBER

 

MANUFACTURER

PART NUMBER

 

SHORT DESCRIPTION

LONG DESCRIPTION

IMA PRODUCT CODE

UNSPSC

ECL@ASS

123456 

 

SKF

6205-2RS

 

BEARING, BALL, 6205-2RS, SKF

BEARING, BALL, 25MM ID, 52MM OD, 15MM WD, CONRAD, SINGLE ROW, LIGHT DUTY, TWO SEALS, STEEL, SKF, 6205-2RS

0101 - BALL BEARINGS

31171504 - BALL BEARINGS

23-05-08-01 - DEEP GROOVE BALL BEARINGS

 

                       

No Cost, No Obligation

MRO Data Evaluation

Submit a data sample today and receive a comprehensive data evaluation report, which will highlight critical data statistics and provide detailed cleansing samples, formatted specifically for your EAM / ERP system.