Skip to content

ALLSERV's Data Enrichment: Improving Inventory Master Data Quality by Nearly 600%

ports and terminals

Industry

Ports and Terminals

Challenge

A leading Marine Ports Operator contracted ALLSERV to validate, optimize, and enrich their inventory master data for a major ERP migration project. Spreadsheets, custom databases, and legacy ERP systems were used to track their existing master data. It also included poor and non-standardized records in foreign languages. The client needed a partner with data enrichment experience, boots on the ground, proven process, and subject-matter expertise. risks throughout the relocation process.

Results

ALLSERV deployed a suite of solutions, including initial data analysis and validation, classification, schema mapping and attribute extraction, on-site data collection and verification, post-processing, data enrichment, data deduplication, and data export and migration.

Key Service

Inventory Management

600%
Overall data quality improvement
25
Integrated data from 25 countries
450K
Collected 400K pictures & 450K attributes
ports and terminals (1)

The customer, a global provider of ports and inland service networks, faced challenges due to poor master data from its legacy terminal inventory systems. Each terminal was using its own systems and processes, and it was identified that none of the native data met the client's high global standards. This resulted in a lack of visibility, inefficient procurement processes, and missed opportunities for cost savings.

The Challenge

The client needed a comprehensive inventory management system that would provide clear visibility into their inventory, enable efficient procurement, and take advantage of volume procurement discounts. However, the poor quality of their master data made it difficult to create a global inventory master data catalog for their ERP system.

 

The Solution

ALLSERV deployed a team of analysts and inventory specialists to

  • Understand existing inventory master data at each terminal.
  • Establish a master data standard and identify gaps in the data shared by terminals.
  • Utilize tools for data collection and project monitoring.
  • Deploy resources to validate and collect required data.
  • Perform data consolidation and deduplication
  • Use data enrichment technology to process data through multiple iterations to provide integrated master data.

ALLSERV worked closely with the client to understand the project scope and expectations. We received the inventory master data from each terminal to analyze and estimate the initial data quality. We then mapped the parts to ALLSERV's standard schema to classify them.

Next, we worked with the client's project schedule to mobilize suitable resources from our global pool who had strong subject matter expertise and could speak the local language. The collected data were de-duplicated and enriched at the terminal level and subsequently at a global level.

In summary, ALLSERV deployed a suite of solutions, including initial data analysis and validation, classification, schema mapping and attribute extraction, on-site data collection and verification, post-processing, data enrichment, data deduplication, and data export and migration.

The Results

Physical Inventory Count
  • ALLSERV's data enrichment solution resulted in a significant improvement in the overall data quality increasing it from 12% to 76%.

  • The solution supported the identification of the original manufacturer of several parts to optimize procurement.

  • The solution helped identify duplicates across terminals providing opportunities for cross-terminal collaboration.

Ready to get started?