Data Cleansing & De-duplication

The project focuses on transforming unstructured data into structured formats and identifying duplicates using PROSOL. It involves data cleansing and de-duplication of the material master, correcting errors, incomplete entries, and formatting issues, as well as creating and maintaining service master data.
data cleansing deduplication

About the client

Our client is a leading global specialty generic pharmaceutical company with revenues of $5.4 billion. With 43 manufacturing facilities, they provide high-quality, affordable medicines to over 100 countries. Originating in 1983, they have grown to be a major player in the pharmaceutical industry, ranking as the largest pharmaceutical company in India and a top competitor in the US generic dermatology market. Their extensive presence includes key emerging markets like Brazil, Mexico, and Russia, as well as major markets in Western Europe, Canada, Australia, Japan, and China.

Challenges

  1. Some of the codes submitted offline were flagged as errors, and these issues may persist in the live system.

  2. As a result, we are facing challenges when duplicating items.

  3. We frequently receive a mix of both small and large requests, adding complexity to our processes.

Business need

Improve business revenue growth through better asset utilization and cost reduction.

Implement scientific techniques for material management, focusing on the planning, organizing, and controlling the flow of materials from initial purchase to final destination.

Enhance the logistics process, particularly in managing tangible assets effectively.

Project Scope

  1. The scope of the project is cleansing the unstructured data into structured data and to
    find the duplicates with the help of PROSOL.
  2. Material master -> Data Cleansing & De-duplication
  3. It is the process of amending or removing data in a database that is incorrect,
    incomplete, improperly formatted
  4. Creation of service master data
  5. Maintenance and updating of master data database for generated codes
  6. Checking for duplicates in the Service master

 

Work Strategy

Leverage technologies like AI, machine learning, and automation for enhanced MDM capabilities.
Ensure MDM strategy aligns with business objectives and supports organizational goals.
To check the duplicates of internal requests every morning before assigning.
To check the pending request every 2 or 3 hours.
To Maintain the SLA.

Material Master Workflow – Prosol

workflow - master data management tool - prosol
Facebook
Twitter
LinkedIn
Pinterest

Thank you for your interest in CODA's offerings! To get started on your journey to success, please complete the form below

Our dedicated team will be in touch shortly to discuss your specific needs and ensure you get the most out of CODA’s solutions.