Data Warehouse

Data Warehouse

  • 18 Nov 2017

Created a cloud-based consolidated enterprise reporting system for Fatbrands, the corporate parent for several US-based restaurant brands including Fatburger, Buffalo’s Cafe, Hurricane Grill & Wings, Hurricane BTW, Bonanza and Ponderosa. The database is used to provide consolidated performance reports for management, NASDAQ, SEC and external auditors.

The database is built on MySQL running on AWS’s RDS service, redundantly deployed in multiple data centers in USA. The database is loaded by multiple employees, external regional brand consultants, and franchisees from various source systems including Aloha enterprise restaurant point-of-sale software, proprietary point-of-sale systems and manual data entry.

The project also includes a web-based data upload tool for all of these users. the upload tool is developed in Angular5, AWS API Gateway and AWS Lambda functions written in Python.

  • Ad hoc SQL reporting system based on MySQL database
  • Amazon Web Services Infrastructure
  • AWS Lambda
  • AWS API Gateway
  • AWS Relational Database Service (RDS)
  • Angular5 + Bootstrap