Client Profile & Challenge
Our Client is a $1B Regional Airline, serving United States domestic markets for United, American, and Delta Airlines
Challenge: Our Client’s Operational systems were running 24/7 and their Supply Chain group was unable to gain timely access to parts, orders, and issues data resulting in inefficiencies and overspend on parts inventory.
The Supply Chain group struggled with timely access to parts inventory and maintenance data. They experienced difficulty and lost valuable time tracking down issues, identifying the availability and location of parts in real-time, and monitoring and measuring usage, replacement, and failure trends. This led to inefficiencies in inventory levels or warehouse locations. Supply Chain and Maintenance data integration was an additional step in the multi-year partnership with our Client to create value and operational efficiencies by building and all of their enterprise data into an Azure data lake.
Azure Data Factory, Azure Data Lake, Synapse, Data Bricks, and Power BI
Messina utilized a blended team of resources from both our Client and our team. Our team consisted of a senior solution architect, data architect, and visualization expert.
“After” Business Value Creation
With the new solution in place, our Client’s Supply Chain group is now able to visualize inventory and parts consumption trends by location and maintenance facility so they can better manage their multi-million dollar parts expenditure. Our Client now has the data-driven insights they need to make better decisions, enabling them to anticipate and manage the appropriate levels of parts inventory, optimize the locations of their warehouses, and decide where their inventory should be located in order to significantly reduce downtime waiting for or procuring appropriate parts.Republic Airlines