Canada
Puerto Rico
USA
Belgium
France
UK
India
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
Client Need
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
Solution
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
Realized 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
Trending Success Stories
Accelerating Claims Adjudication Through Gen AI–Enabled Pend Code Automation
Optimized QE Time Up to 40% Using an Intelligent, AI-Powered Test Automation Approach
Redefining Payments with Azure-Powered Intelligence
Driving Innovation in Generating Evidence Using Real-World Data
Ready to Innovate with Us?
Let’s Talk!
Connect with us on social media
Write to us at
[email protected]