Platform and Technology Capabilities
5 Tips: How Private Equity Firms Can Use Technology to Drive Value
Synoptek Partners with NPWR Group to Extend Salesforce Capabilities
Building Temporary COVID-19 Care Facilities for the U.S. Army Corps of Engineers
SupplyChainBrain: Three Ways to Reinvent Your Business Post-COVID-19
Home / Case Studies / Process Automation Helps an Insurance Aggregator Save Substantial Man-hours on Daily Data Gathering and Reporting Process
March 31, 2020 - by Synoptek
Services: Process Automation
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:
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.
© 2021 Synoptek, LLC. All Rights Reserved.