Personal / Project / MCNF, Hungarian ALG, PuLP / July 2026

I took a linear programming course recently and got hooked because there's an actual best answer sitting in the numbers, and we can find it without guessing. I've also always loved airports and airlines, how much invisible coordination it takes to get a plane, a crew, and a gate to line up on time, thousands of times a day, without anyone in the terminal ever seeing it. Airlines run something close to this for real, in a network operations center, where dispatchers make these calls live when something breaks. I wanted to see if I could formalize that into math.

ALTO plans a full day of Alaska Airlines' gates at Seattle-Tacoma using a year of real BTS flight data, about 139,000 flights. I built it two ways: a fast network flow solver that plans a day in under a second, and a slower, exact integer program, taking up to a minute, that I ran against it day by day to make sure the fast one wasn't cutting corners. It prices out what a delay or a closed gate actually costs, and how much a re-plan gets back.

Synapse Soltuions / Client / Dyanamic Arrays, XLOOKUP / Dec. 2025

The problem at the restaurant for the past two years had been the consistent underpayment of an employee by a total of $20,000 -- and the oversight was not discovered until further investigation. This was not just an isolated incident but a natural consequence of a system that operated on a process of manual reconciliations, good intentions, and no checks whatsoever. The re-build was done from scratch – a weighted tip pool which pays out proportional earnings based on role and hours worked in FOH, BOH, and Bar, separate tracking for OT and regular hours worked, maximum visibility, sales information integrated within the POS system, and a labor cost dashboard which provides key performance indicators such as cost as % of sales and sales per labor hour. The effect was the saving of 60+ manager hours monthly and labor costs visibility for the owners. Built with the intention to build a system that works for the people who use it.

Personal / Students / Nested FILTER, Apps Script / Aug. 2024

College is a constant flood of deadlines, decisions, and days that disappear before you've tracked what happened in them -- so I built the infrastructure to run mine. A single-backend Google Sheet serving a live productivity dashboard, paginated assignment views filterable by course and week, a monthly calendar, mood and sleep logging with daily auto-logic, and a course planner handling both semester and quarter systems -- every view a formula, nothing templated, designed and built from scratch

Synapse Soltuions / Client / BYROW, LET, LAMBDA / July 2025

A consignment store owner spent 45 minutes shuffling through paper records to figure out what he owed one vendor -- cross-referencing handwritten logs, printed reports, and receipts from three different months. This system replaced all of it: a single Google Sheet trained on real Square POS data, giving any consignment store complete visibility into every transaction, every consignee, and every item -- from the business and consignee dashboard down to what a single client is owed in any period.

Systems Manager / Project / XLOOKUP, FILTER / Mar.  2026

An engineering organization was spending money on merchandise it already owned — ordering duplicates, handing things out with no record, and discovering shortages only after the fact. This system replaced the guesswork: a live dashboard tracking every item, quantity, and cost in real time, with structured check-in and check-out workflows, automatic archiving, and active adjustment logic that keeps the ledger honest as inventory moves — built on a clean named range architecture that makes it as precise as it is maintainable.

Academic / Project / Mixed-Integer Programming, AMPL / Spring 2026

Academic / Project / Engineering Statistics, Python & Numpy / Spring 2026