Projects

Restaurant POS System

Private Client

20232024

The restaurant POS system is a web-based application that allows restaurant staff to take orders, manage reservations, and process payments. The system also includes a dashboard for restaurant managers to view sales data and manage staff schedules.

Skills: Data Schema Design, Microservice Architecture

Technical details

The system is built using a microservice architecture, with each service responsible for a specific area of functionality (e.g., order management, reservation management, payment processing). The services communicate with each other using RESTful APIs. The data schema is designed to be flexible and scalable, allowing for easy addition of new features and services in the future.

Scaling Data Visualization During a Global Crisis

QSR

20202020

A high-profile public data visualization site developed during the COVID-19 pandemic to track percent-change in restaurant attendance across the United States.

Skills: Vue.js, D3.js, AWS Redshift, JSON, .NET Core

Technical details

Built a custom automated pipeline to generate daily aggregate data from Redshift into optimized JSON files. These files were served to a Vue.js frontend which utilized D3.js for complex geographical data visualization and heatmap rendering.

Kitchen Data Monetization Pipeline

QSR

20162020

An enterprise-scale big data architecture designed to ingest thousands of events per second from restaurant kitchens across the US and Europe to enable advanced analytics and reporting.

Skills: C#, .NET Core, AWS SQS, AWS S3, AWS Redshift, Grafana

Technical details

Engineered .NET Core microservices to ingest high-throughput asynchronous data from SQS. Developed preprocessing services to populate Redshift for complex reporting and built a schema-update process to ensure consistent deployment across environments.

Pay Monitor Global System

Mercer

20062008

A global benefits and salary analysis platform used for multi-national data points and large-scale compensation tracking.

Skills: .NET 1.1/2.0, Oracle, SQL, Unit Testing

Technical details

Optimized a specialized Oracle-based query system using a custom SQL superset to aggregate multi-national datasets. Introduced unit testing and code metric tracking to the development lifecycle to ensure global data integrity.

Maker’s Mark Ambassador CRM

Doe Anderson

20002005

A custom-built Customer Relationship Management system designed specifically to manage the global Maker’s Mark Ambassador program and its complex data workflows.

Skills: C#, .NET, SQL Server, HTML, CSS, JavaScript

Technical details

Engineered a dynamic SQL generation engine that allowed the system to scale and manage high-capacity performance requirements for enterprise-level data.