Problem Statement:
UPL has one lac plus Material master data for Bharuch Plant for PM and PS module which has
following issues,
Looking for master data cleansing for Material Master
Facing difficulty in creating a new master record?
Suffering with various quality issues?
Suffering from inconsistencies in the descriptions?
Suffering with lack of information?
Want to eliminate duplicates within the data?
Looking for standard technical dictionary/taxonomy?
Looking for Extension or Supersede of materials in various plants?
Want to reduce time?
Looking for more accurate purchase order descriptions?
Features Needed
Best Quality & Standardized Data
Elimination of duplicate material items
Best Taxonomy/Dictionary with best templates
Accurate class assignment in material creation
Auto mapping of material master record with UNSPSC/eCl@ss or any other classification
Assigning HSN Codes to the materials
Classes are divided into different disciplines like Electrical, Mechanical, Automobile, Food &
Beverages, Chemicals, etc
Industry proven ISO compliant abbreviations (Class, Characteristics, Characteristic Values,
UoM's)
Reduction in cost of creating new material items
Improved inventories of material items and reduction of inventory variances with unique and
accurate materials descriptions
Utility for Web Based tool to create Material avoiding duplication.
Enforced governance rules to improve consistency & data quality using approved characteristic
values
If MDM is not available, then suggested procedure for master data cleansing should be MS Excel,
which is easy to manage for considerable size.
The Data Cleansing Process-Genisys Roadmap to Material Master Data Quality
Step 1. Perform Pre-Cleanse Data Evaluation
Assess Current (Raw) Data Condition
Calculate Data Quality Score Based On:
Duplicate Percentage
Review Item Percentage
Number of Manufacturer Names Populated
Number of Manufacturer Part Numbers Populated
Number of Nouns
Number of Modifiers
Description Length – Avg. Number of Words/Characters
Prepare Before and After Data Cleansing Samples
Determine Cost Savings Opportunities and ROI
Step 2 Establish Corporate Data Standard
• Standard Naming Convention
• Define Noun-Modifier Dictionary
• Standard Abbreviations & Policies
• Develop Standard Abbreviation List
• Define Standard Cleansing Policies
• Standard Data Format
• Define Enterprise System Specifications (fields, features, character limitations, contents)
• Develop Data Formatting Template
• Product Classification System
• Select and define Product Classification System
• Example: UNSPSC, eCl@ss, Custom, etc.
Step 3 Review and Approve Test Data
• Prepare 500-1000 SKU Test Data Sample
• Implement Pre-Defined Data Standards
• Utilize Pre-defined Data Formatting Template
• Review Test Data Sample
• Review and Critique Data Cleansing Deliverable
• Perform Test Upload in Non-Production Environment
• Modify Corporate Data Standard and Format as Required
Step 4 Pre-Cleanse Data Mining
• Identify, Standardize and Populate Manufacturer Name & Part Number
• Assign Valid Noun-Modifier Naming Convention Raw Data
Step 5 Standardize and Validate
• Standardize and Validate Existing Information by Attribute Raw Data
Step 6 Research and Enhance
• Research and Enhance Description
• Utilize internal information resources, online sources, and Manufacturer, OEM or Vendor Catalogs
Step 7 Assign Product Classification Codes
• Typically based on Noun, Modifier, Type, and Material
Step 8 Identify & Consolidate Duplicates
• Identify Duplicate Records and Assign Common Corporate Part Number
• Duplicates may be identified by Exact Match and Fit-Form-Function Equivalent
• Duplicates may be consolidated (merged) into a single item number (material record) while
Maintaining history of old item numbers
Step 9 Identify and Address “Review” Items
• Identify Items Containing Insufficient Information
• Compile List of All Item Requiring Review
• Perform Physical Part Review, Identification and Data Collection
• Obtain Adequate Information for Cleansing
Step 10 Perform Quality Control Review
• Ensure Each Cleansed Record Meets the Service Level Agreement
Step 12 Final Delivery and Upload
• Upload Final Cleansed File into Live Enterprise System
• .xls, .csv, .txt, .db and other supported formats ENTERPRISE SYSTEM
Post-Cleanse Data Governance
• Implement Data Governance Strategy to Maintain Data Quality
• Select and Implement a Data Governance Solution
• Establish a Data Governance Team with Restricted System Access
• Define the Data Governance Process (Workflow)
• Implement Pre-Defined Corporate Data Standards for All New Item Creations, Modifications,
Extensions, and Suspensions (Deactivations)
• Prevent Duplication
• Maintain Ongoing Data Integrity and Consistency
Business Benefits
Elimination of duplicate material items
Reduction in cost of creating new material items
Reduction in cost of using current descriptions through improved efficiency, reliance and
assurance of accurate and unique descriptions by Engineers, operations personnel, material
warehousing, logistics, finance and purchasing
Improved purchase contracting and reduced material cost by elimination of duplicate items and
reliance on volumes used and needed
Improve logistic delivery times by creating internal efficiencies with correct material
descriptions
Improved inventory receipt process with complete and accurate material descriptions
Improved warehousing control and management with unique and accurate materials
descriptions
Improved inventories of material items and reduction of inventory variances with unique and
accurate materials descriptions
Reduction of Excess and obsolete through accurate, unique and complete descriptions used in
the purchase, receipt and warehousing of items
Improved material item availability and reduction of operation stoppage and or rush order
shipping through elimination of duplications and proper minimum and maximum stock levels
Reduced cost to set up new material items. Cost moved from fixed internal cost to variable
external cost
ISO compliant content and standardization processes
Create standardized Short and Long Descriptions for all items to ensure purchasing accuracy
Update the UNSPSC codes to the correct/latest version
Resources Required:
ABAP for writing upload Program/BDC – 10 days ( 80 hrs)
PM/PS Consultant for Validating data – 10 days ( 80 hrs)
