Client background: Leading provider of global logistics solutions

RPA solution for a leading logistic vendor

Business Challenge

  • Tracking thousands of shipments (both truck- based & ocean liners) simultaneously

  • Manual tracking of shipments for ocean liners is time consuming

Business Solution

  • Designed the solution to capture Tracking Number/BOL Number, Carrier SCAC Code from a list of containers/ shipment, along with and other container related information

  • Automated the following tasks:

    • Extract containers file data from FTP server & store them into the database
    • Data scrapping using the configuration set & store the tracking information into the database
    • Periodically to prepare the file with all tracking information for containers & place it on the FTP server in a Data Lake compatible format
  • Provide single view of the shipment status

Business Benefits

  • Fully automated shipment tracking

  • Minimized manual data entry and associated labour costs

  • Easy access for customers and thereby improving customer satisfaction

  • Improves the accuracy of orders and trouble reports

Environment

  • UI Path | UI Path Studio to record & map carrier websites