2400 Meadowbrook Parkway, Duluth, GA 30096 | +1 770-493-5588 Follow Us
Select Page

Enabling a 3PL logistics company to predict the arrival time (on-time, lead-time) of carriers


Client Background

The client is a 3PL logistics company which manages shipments and provides services like optimizing routes, invoice auditing etc. They use a tracking management system to provide these services. The data from this application flows to the data warehouse


  • The client onboards customers frequently and each customer onboarded needs a data extract as well as on-time and lead-time rules setup in their data warehouse. Each extract needed a new package to be written
  • Existing ETL packages needed changes for new requirements or additions for new customers
  • The current DWH processes were outdated and needed process improvements


  • Created views, packages and shell scripts to provide data extracts for customers on a daily, weekly or monthly basis as per the requirements
  • Created packages with on-time and lead-time rules and logic to estimate whether carriers are on time or late to the location
  • Made changes to the existing ETL packages and created new ones wherever required
  • Wrote a generic package which can be used by all extracts to save time and effort

Tools & Technologies

Oracle Database

Key benefits

  • Data extracts are sent to customers without any issues or delays
  • On-time and lead-time counts are made available to BI team for reporting and offer better insights
  • Reduced report generation time owing to removal of redundant logic
  • Improved ETL processes with new package for new ETL requirements
  • Reduced development time for resources as the generic package can be used for all the extracts
Case Study KeyPoints



    Digital Product Engineering

    Cloud Services

    Data & Analytics

    Intelligent Automation

    Cyber Security

    Build Operate Transfer

    Talent Solutions


    Banking & Financial Services

    Communication, Media
    and Technology

    Energy and Utilities


    Life Sciences



    Transportation and Logistics

    Travel & Hospitality

    Innovation @ Work

    Blogs and Insights

    Research and Whitepapers

    Case Studies


    About Us


    Strategic Partnerships

    Office Locations

    News and Events

    The Foundation


    Open Positions

    Life @ Innova Solutions
    Candidate Resource Library

    Let's Connect