MSH helps a leading logistics company with $4B+ in revenue based out of South Florida migrate data warehouse infrastructure to AWS cloud.

The Challenge

  • Ad hoc technology investments during a period of rapid business growth, lead to dysfunctional IT landscape
  • Data silos for inventory, demand planning, sales and merchandising, and logistics
  •  Data warehouse that could not scale up to emerging business needs
  • Prolonged back-up schedule and frequent hardware failures

The Solution

  • Cloud-based solution through an ecosystem approach
  • Deployment of AWS Data Engineers to empower business users with relevant data, and drive advanced data analytics, BI and reporting
  • Complete migration from on-premise systems to AWS Redshift using the Amazon EMR platform through PySpark
  • Create Data orchestration solution by leveraging AWS services – Lambda, EMR, data pipeline, and Aurora DB

The Results

  • Optimized capital expenditure and maintenance cost for timely & relevant infrastructure investments
  • Re-engineered Informatica-based ETL solution for loading 1000+ tables and 1200+ mappings
  • Data Orchestration Solution created along with enabled failure notifications enablement through Amazon SNS alerts
  • 7,000 scheduled reports and 2,000+ ad hoc reports with data from 10 business-critical enterprise applications

MSH designed a system to meet the exponential growth in business and corresponding increase in data to be stored, harvested and distilled for business insights.  At an enterprise level, the new system is delivering compelling business benefits which improves supply chain operations, increases transparency, enhances deliveries, and manages production costs. The system allows for a high degree of self-service data capabilities as well as collaboration among users across the enterprise.