Home What A Single Bot Can Do For A Fortune 500 Company

What A Single Bot Can Do For A Fortune 500 Company

by sol-admin
115 views

Jones Lang LaSalle Incorporated (JLL) is a global commercial real estate services company, founded in the United Kingdom with offices in 80 countries. The company also provides investment management services worldwide, including services to institutional and retail investors, and to high-net-worth individuals. The company is ranked in the first half of the Fortune 500.

Challenge
After winning a large contract to appraise an extensive portfolio of properties, JLL needed quick access to clean structured research data and analytics on the portfolio’s real estate assets to provide an accurate appraisal. Further, as a condition of the contract, JLL was responsible for collecting all information relating to the properties from an online resource. However, this had no API for digital data extraction; and the property information was not available in a CSV file. Upon review of the task at hand, JLL realized that the project would require 18 extra staff members, 45-60 days to hire and onboard these employees, and a further five days for training. This did not seem feasible within the required timeline.

Vendor
Upon extensive research on the potential of Robotic Process Automation and its feasibility for the project, JLL partnered with UiPath and rapidMATION to develop an intelligent automation solution to address their data challenge.

Solution
RapidMATION configured a UiPath software bot that was able to automate tasks and retrieve data with no need for API integration. UiPath runs automation under locked screens and uses the TLS 1.2 protocol to assure privacy and data integrity. All property data remained within JLL’s highly secure server environment, and rapidMATION was never privy to any property data.

Running 24 hours a day, the software bot was able to:

  • Automatically open the Excel spreadsheet and iterate through each property
  • Open the portal and securely authenticate
  • Browse to the relevant property page and extract data to a secured JLL storage location
  • Retrieve images and store these in the same location using specific naming conventions
  • Hand over to JLL staff to securely upload the data into the JLL Valuation Advisory workflow tool

Outcome by Numbers

  • 1 UiPath bot, working 24-7 to complete the data entry task
  • 6.9 Days, taken for the UiPath bot to complete the task
  • 99% Data management accuracy increased

____________________________________________