Data Harmonization Solution

Preconfigured templates, Auto Assignment of Class & Characteristics, ISO 8000 and UNSPSC compliant

About Data Harmonization Solution

Data Harmonization solution is aimed to automate the process of standardization, cleansing & harmonization of unstructured/free text data by utilizing ASA (Auto Structured Algorithms) built on PiLog’s taxonomy and the catalog repositories of master data records.

Data Harmonization Capabilities includes but not limited to

  • Analyze the source data content for completeness, consistency, redundancy, standardization, richness, etc
  • Auto Assignment of Class & Characteristics from the PiLog’s Taxonomy to each record
  • Extract the characteristic values & UOM's from the source descriptions for each record
  • Extract reference data from the source descriptions such as Part#/Model#/Drawing#/Mnfr/Vendor etc for each record
  • Bulk review of materials (QC Tools & DQ Assessment)
  • Auto mapping of source data with PiLog repositories & other reliable sources
  • Assign the data sets to relevant user groups based on various criteria
  • Capture additional information (or) Validate processed/structured data
  • Provision to collect the field data & update (Physical Walk down)
  • Auto-generation of Short & PO text based on User configured
  • Identification of redundant records
  • Export the data to be migrated to a Target system(s)
  • Integrate in real-time with other systems
  • Data Quality assessment & progress reports

Spares Data Acquisition

Criteria MM VM CM SM PM HR
Count 2,182 Classes Completed - - - 2K+ Classes Completed -
Validation ERP Fields validation General, Taxation, Banking Details Validation General, Taxation, Banking Details Validation ERP Fields validation ERP Fields are validated Address Fields Validation
Verification ERP Fields verification General, Taxation, Banking Details Verification General, Taxation, Banking Details Verification ERP Fields verification ERP Fields verification Address Fields Verification
S.No Scope of Work [PiLog: Customer = 30:70]
SOW Description PiLog Customer
1 Data Extraction from SAP Systems (Master Data, Base Data, Configuration Data, KDS etc), Templates, Values & Business validations C & I R & A
2 Analyzing the client's taxonomy with PiLog’s Global templates R & A C & I
3 Analyze the material master records and determine the Key data structure (KDS) fields in accordance with SAP, other 3rd party systems R & A C & I
4 Configuring the Algorithms specific to customer data, preprocessing the data and uploading in the Harmonization tool in the same format as provided model template R & A C & I
5 Running data analysis algorithms and providing analysis details on source descriptions and on SAP fields (KDS) R & A C & I
6 Initiating cleansing process by grouping the records based on commodity, category and UNSPSC R & A C & I
S.No Scope of Work [PiLog: Customer = 30:70]
SOW Description PiLog Customer
7 Allocating Material records to cataloguers either group wise or category wise(Done by Manager) C & I R & A
8 Cataloguers to review allocated groups in Data Automation Process and correct / validate / update records R & A C & I
9 Process records through Automation to get the records segregated into various categories such as A, B, C & D R & A C & I
10 Process the Records with Reference details to ping against the Pilog repository (PPR) and fetch the characteristics & additional details based to Part/Model number R & A C & I
11 Review the records segregated into the categories mentioned in Point:9 above and assess the data quality (correctness, completeness, relevance, mandatory requirements etc), transfer the data to next steps R & A C & I
13 Run QC tools to establish consistency, standardization across the batch or set of records R & A C & I
S.No Scope of Work [PiLog: Customer = 30:70]
SOW Description PiLog Customer
13 Consolidate approved records and move them to next step or assign for enrichment in case of insufficient/inadequate information C & I R & A
14 Run the duplicate check, validate the results once all the records are approved & finalized per commodity or plant or batch R & A C & I
15 Merge the confirmed duplicates or common items, consolidate the records within ERP system with appropriate cross-references R & A C & I
16 Upload the data into Governance solution or ERP system with updated associated data R & A C & I
17 Prepare close-out reports, extract all the data & archive R & A C & I