Product Portfolio
Political Window|Sole Founder & Developer|View Project↗
Political advertising intelligence platform
- Designed and built a full-stack web application that parses FCC public file PDFs into structured data, enabling political media buyers to identify LUR violations, track candidate ad spend, and navigate FCC compliance windows across all 210 U.S. DMAs
- Architecture: Neon PostgreSQL → Express/Node.js API (Railway) → JavaScript frontend (GitHub Pages) with Claude Sonnet-powered PDF extraction pipeline, JWT/bcrypt authentication, and FEC + FollowTheMoney API integrations
- Features include a 50-state interactive election map with FCC window countdowns, an FCC rate explorer, LUR violation detection engine (the platform’s core strategic differentiator), and a multi-source candidate ad spend tracker
Live Sports CTV Package Platform|Solo Build @ Spectrum Reach|View Project↗
Sales enablement product for streaming ad packages
- Designed and built a web app that calculates streaming ad packages for live sports, enabling 50+ reps across 10+ properties to configure rate-class, DMA, flight dates, and budgets to create branded proposal decks
- Architecture: zero-dependency single-file HTML app (no build step, no server) with SheetJS and JSZip bundled inline; dataset and PPTX templates embedded as JavaScript constants for fully client-side proposal generation
- Features include a multi-property package builder with real-time CPM calculation, rate-class toggling, max-imps enforcement against live inventory caps, an embedded base64 master template for branded PPTX deck generation, and a self-rewriting “Save Updated File” flow that regenerates the HTML with refreshed embedded data for distribution
RSN Yield Platform|Solo Build @ Spectrum Reach|View Project↗
Inventory, rate, and yield management platform for live sports RSNs
- Designed and built a Next.js web application that consolidates booked spots, schedules, and inventory data into a unified decision-support layer used daily by yield, sales, and revenue assurance teams to manage allocation across $57MM in annual ad revenue for the Lakers and Dodgers RSNs
- Architecture: Next.js single-page application with a server-driven data layer feeding a six-view product framework — Inventory, Rates, Heatmap, Booking Matrix, Yield Summary, and About — covering every angle of yield decisioning from per-game capacity to portfolio-level revenue decomposition
- Features include a per-game inventory view with capacity, avails, sellout, and net revenue by date, matchup, and inventory type; a weekly rate card of open avails and dynamic rates; a per-game sellout heatmap; a client x date booking matrix of EQ30 by spot status; and a LOB-group yield summary with EUR (Net), AUR, and sellout per game