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 validate information 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, and business rules 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.
BOT 1
The engine checks each entry in the first file and compares them to the second file.
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.
BOT 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 validate information 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, and business rules 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.
BOT 1
The engine checks each entry in the first file and compares them to the second file.
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.
BOT 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.