RPA FOR CUSTOMER DATA VERIFICATION

Client
Healthcare and Pharmaceutical Corporation

Industry
Pharma 

Location
UK 


❝ Comidor has improved the quality of data that my team receives and processes saving valuable time.❞

Company Employee


❝ Comidor has improved the quality of data that my team receives and processes saving valuable time.❞

Company Employee

Client Business Challenge

Our client needed to verify the contact details of pharmacies it conducts business with. The details included information on postcodes, addresses, phone numbers, etc. The verification process, executed manually once a month, was time-consuming since the responsible employee had to verify information correctness for every pharmacy through Excel files and multiple websites and then update the company’s database, if necessary.

The Comidor Solution

By implementing an RPA-enabled workflow, the verification process is now fully automated. Customer data are retrieved, synchronised, and verified using RPA components, web scrapers and Excel processors, to minimise completion time and maximise data accuracy.   

The process starts by uploading an Excel file with the latest ERP contact information and another Excel file containing the latest correct contact information, downloaded from a central hub or acquired by email from an external source.

RPA bot | Comidor Digital Automation PlatformBOT 1

The engine checks each entry in the first file and compares them to the second file.

RPA bot | Comidor Digital Automation Platform

BOT 2

If a contact is not found in the second file, the system tries to find the contact information in a list of websites depending on the customer type. If the contact is found, it fetches back the correct contact information.

RPA bot | Comidor Digital Automation PlatformBOT 3

The process produces three files: a file with contacts with matching information, a file with contacts with no matching information, and a file with contacts that were not found in either the Excel file or relevant website.

A Leading Pharmaceutical company

One of the oldest and largest healthcare companies in the world. Covering more than 15 countries, the pharmaceutical company provides health and well-being solutions that make a difference to customers and patients lives every day. 

A Leading Pharmaceutical company

One of the oldest and largest healthcare companies in the world. Covering more than 15 countries, the pharmaceutical company provides health and well-being solutions that make a difference to customers and patients lives every day. 

Client Business Challenge

Our client needed to verify the contact details of pharmacies it conducts business with. The details included information on postcodes, addresses, phone numbers, etc. The verification process, executed manually once a month, was time-consuming since the responsible employee had to verify information correctness for every pharmacy through Excel files and multiple websites and then update the company’s database, if necessary.

The Comidor Solution

By implementing an RPA-enabled workflow, the verification process is now fully automated. Customer data are retrieved, synchronised, and verified using RPA components, web scrapers and Excel processors, to minimise completion time and maximise data accuracy.   

The process starts by uploading an Excel file with the latest ERP contact information and another Excel file containing the latest correct contact information, downloaded from a central hub or acquired by email from an external source.

RPA bot | Comidor Digital Automation PlatformBOT 1

The engine checks each entry in the first file and compares them to the second file.

RPA bot | Comidor Digital Automation Platform

BOT 2

If a contact is not found in the second file, the system tries to find the contact information in a list of websites depending on the customer type. If the contact is found, it fetches back the correct contact information.

RPA bot | Comidor Digital Automation PlatformBOT 3

The process produces three files: a file with contacts with matching information, a file with contacts with no matching information, and a file with contacts that were not found in either the Excel file or relevant website.

Read More

Read More

Read More