When ever we start to learn any new tools, it is always a big question what would be the practical use of any tool. It is useless if we have knowledge of any tools but not aware what is practical use of that tool in industries.
So I thought to start this post where I will share the case studies I have implemented in our company using RPA tools.
1. Data Comparison Automation
One of our big US based insurance customer had to compare his insurance rates on monthly basis on various different competitors site. There were many different insurance parameters i.e. age, state, risk coverage etc had to fill on competitors portal to compare the price. They had around two thousand combinations of parameters which they had to search on competitors sites to adjust their price to make them competitive.
In order to achieve this, customer outsourced this process to another data collection agents, who used to extract the data manually on competitors site. This process was very time consuming and also too much error prone. This process used to take around 6 to 8 days to create the comparison report.
We studied their process, competitors sites and various parameters they had to submit on competitors site to understand how RPA (Robotic Process Automation) can help them to eliminate the manual process. After studying the process we created a list of various inputs and parameter to submit on each site and using UI Path data scraping method, we have been able to extract the data points needed for comparison.
After test various parameters thoroughly we have deployed the solution, now they just need to put various parameter to be searched in excel file and deployed robot extract all the data from competitors site.
Before automation it used to take 6 to 8 days to create comparison report and error prone as well
After automation this report can be developed in 3-4 hours only.
As I can not add the name of actual customer here and the sites we used to scrape, but I will create video of data extraction using UI path by taking example of another site.