RPA FOR CUSTOMER DATA VERIFICATION

Client
Healthcare and Pharmaceutical Corporation

Industry
Pharma 

Location
UK 

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

❝ Comidor has fully digitalised all the tasks that the team performs.❞

Company’s Employees

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

❝ Comidor has fully digitalised all the tasks that the team performs.❞

Company’s Employees

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