Modern Data Warehouse Infrastructure Case Study
Based in Keasbey, New Jersey, ShopRite consists of 50 individually owned and operated affiliates with over 300 stores, all under its corporate and distribution arm, Wakefern Food Corporation. Wakefern itself owns and operates 28 of the locations through subsidiary ShopRite Supermarkets and is the largest affiliate within the cooperative. Several Wakefern members own and operate single ShopRite stores, while most own multiple locations. The average Wakefern member operates six stores.
ShopRite has been the largest retailer of food in New Jersey for close to 70 years and is also number one in the entire New York metropolitan area. Since 2011, ShopRite is also the largest retailer of food in Greater Philadelphia, pushing long-dominant Acme Markets to second place and, in 2013, to third place. As of 2011, Wakefern was ranked 17th by sales among all supermarket operators in the United States.
Use case: We helped ShopRite build a Centralized Data Platform that Enabled Advanced Analytics and Reduced Operational Costs.
Saved millions in TCO: With its legacy data warehouse running on SAP, the company struggles with scaling up as the business grows. We helped ShopRite migrate its data warehouse and pipelines to Google Cloud and saved millions in its TCO.
Demand forecasting: For a retailer, the ability to forecast demand is crucial to maximizing profit. We developed a model that accurately predicts SKU-level demand for ShopRite 100+ supermarkets and 2000+ convenience stores.
Inventory optimization: With the demand forecasting model running for each store and each SKU, we helped ShopRite optimize inventory movements.
Anomaly detection: With many stores, it is hard to know what’s going on and where to turn attention to. We developed a notifier, which will send out alerts to management on anomalies across our 30+ store metrics.
About JOON SOLUTIONS
Joon Solutions was founded with the Vision of providing unparalleled experience, thought leadership, and toolsets to help clients launch into the 4th industrial revolution. We specialize in helping clients select, implement and manage organizational changes related to their data and IT infrastructure. More than products, we have solutions.