MRO Material Master
Data Cleansing
MRO Material Master
Data Cleansing
Developed and refined over 30 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
Unless otherwise specified we strive the achieve a Level 3 Item Enhancement on every item within your material master. If we are unable to do so we perform a Level 2 Standardization or Level 1 Cosmetic Cleanse. Accordingly we charge only for the work performed. 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 from data schema
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
