Case Study: Cloud-Powered Serverless Inventory Management for Catering & Ad-Hoc Food Ordering

In today’s fast-paced food service industry, where speed, accuracy, and scalability define customer experience, inventory management often becomes a bottleneck. Traditional systems relying on manual updates or batch-processing databases struggle to handle real-time order flows, especially when multiple fulfillment channels—airline catering, private charters, event services, and e-commerce—operate simultaneously.

SkySync Technologies implemented a Serverless Inventory Management System leveraging AWS Lambda, DynamoDB, API Gateway, SNS, and SQS to create a cloud-native, cost-optimized, and near real-time inventory tracking system. The solution powered seamless inventory synchronization for FoodCraft, an ad-hoc food ordering platform, while integrating additional supply chain operations for airlines, charter services, and event catering businesses.

Project information

  • Category: E-Commerce & Catering Supply Chain
  • Client: Emirates Flight Catering(EKFC)
  • Project start date: 13th February 2024

Technology Used

  • Database: DynamoDB
  • Cloud: Azure Database for PostgreSQL, Azure Kubernetes Service, Azure Traffic Manager, Azure IoT Hub, Azure Stream Analytics, Azure Data Lake
  • IoT: Siemens IoT2050 Gateways
  • Security: VPN Gateway, Site to Site VPN, Azure Virtual Network Gateway, TLS encryption, compliance storage policies

Challenges

The client’s original system was an MS Access desktop application with its own database. Over time, it presented multiple challenges:

  • Severe Performance Issues – Generating a single receipt took up to 4 hours, delaying client operations.
  • Dependency on Legacy Software and Technical Debt – The tool only worked with specific MS Office versions, making upgrades impossible.
  • Compliance Risks and restrictions – No proper logs or restricted user access, increasing vulnerability and prohibited moving the production database directly to public cloud infrastructure.

The system had become a bottleneck, preventing the company from scaling and staying compliant with financial regulations.

Our Solution

We designed and implemented a modern hybrid solution combining the cloud’s scalability with on-premise compliance safeguards:

  • Web Application – Built using Python (Django framework), hosted securely on Microsoft Azure Cloud.
  • Hybrid Database Strategy:
    • Primary Data stored in Azure SQL Database for scalability and high availability.
    • Local On-Premise SQL Database dedicated to logs and compliance records, ensuring audit data remains under the client’s direct control.
  • Security Enhancements:
    • Set up a VPN tunnel between your on-prem firewall/router and Azure Virtual Network Gateway.
    • Traffic between Django (in Azure) and Local DB stays encrypted and goes over private IP space.
  • Configured the Python Django + OPC UA application for dual-environment awareness, ensuring IoT and automation functions remained operational in DR mode.

Results & Impact

The modernization brought immediate and measurable improvements:

  • 99% Faster Processing – Critical operations reduced from hours to minutes.
  • Compliance-Ready Logging – Secure local storage of all activity logs, with backups, met regulatory requirements.
  • No Legacy Dependency – Independence from outdated MS Office versions.
  • Scalable, Secure and Compliant – Hybrid cloud + local architecture provided the best of both worlds. Web-based access for authorized users on designated networks and proprietary Financial data stays secure on prem DB