Will Piwowarski

Shipped an installable, offline-capable PWA now serving 200+ weekly users, replacing the attendance and check-in tracking residence hall leadership had been doing by hand. Cross-hall access is structurally impossible: every read routes through a single data layer that filters on the signed-in user's hall, with server-only imports that fail the build if it's ever pulled into the browser.

Leading a student team building a spoofing detector for aircraft broadcasts — a protocol where any transmitter can claim to be any aircraft. Flags reports that contradict their own physics while designing around what breaks naive detectors: coverage handoffs, clock drift, holding patterns, and a neighbor check that separates GPS jamming from a single spoofed target. I own the live feed off a software-defined radio and Raspberry Pi.

Built a CLI that maps every function call in a TypeScript project through the compiler's type checker, resolving overloaded methods, renamed imports, and inherited overrides that a text search gets wrong. The call graph is stored as adjacency maps in both directions, making caller lookups, change-impact analysis, and shortest path between two functions constant-time queries.

Built an AI dataset-exploration app: upload a CSV, XLSX, or JSON file and Auralith profiles every column, surfaces KPIs and plain-English insights, generates charts from natural-language prompts, and lets you chat with your data. The chart endpoint asks Gemini for JSON only, validates it against a strict schema, retries once with the failure reason, and rejects any column the dataset doesn't have.