Leading Food Service Specialist reduces product returns & enhances customer satisfaction with Cloud-native Solution
Our client had an IT infrastructure in place which was built around Microsoft technologies. To make their business process more efficient and intelligent, they wanted to revamp this existing PDA based system to a more modern and powerful solution. It wanted to deliver goods with the assistance of IoT-connected mobile devices with Bluetooth printers and Bluetooth temperature sensors mounted in the trucks. Further it also wanted to be able to gather intelligence about customers’ shopping behavioral patterns so that it could provide them with the most relevant goods and services.
One of the core challenges in this project was to develop a system that could handle these multiple connected devices which were expected to generate million events every single day. Further the system needed to be scalable so that it can handle large data from thousands of trucks. The system also needed to have provisions for storing and analyzing this huge amount of collected data so that patterns could be identified within it.
Windows Phone 8.1, SQLite, Azure Mobile Services, Cloud Services, Cloud Storage, Event Hubs & Stream Analytics, Microsoft Power BI
Saviant built the solution by leveraging several Azure cloud components. In our architecture, SQL Azure DB was used as a storage platform to store the data generated by the multiple temperature sensors deployed in the client’s delivery trucks. This system provided the ability to scale up and down on demand, and also made it possible to efficiently synchronize the data from the SQLite via Azure Mobile Storage. Service Bus Queues were used to transmit messages to the Cloud Services which attributed further scalability and resiliency to the system architecture. Cloud Services like Worker roles enabled communication between Azure SQL DB and the Restful API on the client premise web server.
A site-to-site VPN was used to connect the Cloud Services to the on premise server. The real-time data was sent to the Event Hub which is capable of handling millions of events per second at almost real-time. It was chosen to act as an intermediate storage for logging real-time data. We have used Power BI to send real-time data, which allowed the user to track this data through graphical representations in the form of Dashboards.
Saviant leveraged Microsoft Azure Cloud services for delivering food items to 30,000 customers, handling 60,000 orders/month, and processing 2.5 million events every day.
A Glimpse of the Mobile Application