Client background: Leading provider of global logistics solutions

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