|Customer: An insurance aggregator||Profile: A membership-based leading insurance aggregator|
Services: Process Automation
|Region: The United States of America|
The client, a leading insurance aggregator serving world’s top 50 insurance carriers, accesses multiple carrier websites every day for data gathering and reporting. Agents who are responsible for these tasks manually log-in to each carrier website, filter daily records, generate reporting logs in PDF format, and send logs for further processing to the corresponding backend teams. On average, each agent downloads over 30-50 files, segregates them based on file types, and sends the data to the intended recipients.
The client wanted to fully automate the data gathering and reporting process so that they can:
Solution and Approach
Synoptek began the engagement by assessing the existing data gathering and reporting process. We analyzed videos and workflows documents provided by the client to understand how each carrier website works. We also spoke to relevant stakeholders to identify roadblocks that brought down the efficiency of the process.
Based on the client’s requirements and our assessment of the challenges, we developed an automation script that enables the client to automate the data gathering and reporting process.
To develop the automation script, we analyzed each carrier website one by one and estimated the effort required to automate the process for each of them. After approval from the client on the plan and effort hours, we started work on the automation script. The automation script was written in the programming languages – Python and Java, and executed on the automation platform – Selenium.
The script, coupled with a Windows scheduler, automates the end-to-end data gathering and reporting process. It also triggers the automation script for each website daily at defined intervals. With the script in place, the following tasks are completely automated:
Synoptek is now working with the client to create an automation script for fetching records uploaded on a carrier website after the bot has already fetched data for the defined period.
Using the Process Automation script, Synoptek has completely automated the data gathering and reporting tasks for 22 websites so far. The automation assignment, which was completed in less than 6 months, has a considerable impact on the business.