zach.dev

// projects

Built & shipped

Tools, dashboards, and systems from recent work.

01

League Island — Multi-Tenant Tournament Management Platform

Full-stack SaaS for esports and sports leagues: branded host sites, tournament lifecycle (registration, brackets, scheduling, live scores), Riot API integration for League of Legends, pickleball live scorekeeping, Discord automation, broadcast overlays, and Stripe Connect for paid team registration.

  • Next.js
  • React
  • TypeScript
  • Tailwind CSS
  • Supabase
  • PostgreSQL
  • NextAuth.js
  • Stripe
  • Riot Games API
  • Discord
  • Server-Sent Events
  • Recharts
  • Jest
  • Zod
  • Vercel
read_case_study

02

Amazon Ads Automation System

Built a Python-based advertising automation system to analyze Amazon Ads performance, estimate profitability, and recommend bid and placement modifier changes across millions in annual ad spend.

  • Python
  • pandas
  • Amazon Ads API
  • PostgreSQL
  • Supabase
  • Excel
  • CSV
  • dotenv
read_case_study

03

COGS & SKU Profitability Engine

Designed a cost calculation system that supported thousands of standard SKUs and hundreds of thousands of dynamically generated custom SKUs, enabling SKU-level profitability tracking and better pricing decisions.

  • Python
  • PostgreSQL
  • Supabase
  • SQL
  • Next.js
  • TypeScript
  • pandas
read_case_study

04

Executive Scorecard Dashboard

Built a business intelligence dashboard that consolidated ecommerce channel performance, profitability, advertising spend, margins, and trend grades into a weekly executive scorecard.

  • Next.js
  • TypeScript
  • Supabase
  • PostgreSQL
  • Tailwind CSS
  • SQL
  • React
  • Python
  • CSV
read_case_study

05

UPS Shipping Optimization Tool

Built a shipping analysis system that compared UPS rates and transit times across distribution centers to identify faster and more cost-effective fulfillment options.

  • Python
  • UPS API
  • Supabase
  • PostgreSQL
  • pandas
  • SQL
  • CSV
  • Plotly
read_case_study

08

ChannelAdvisor & Shopify Data Import System

Built data import workflows to standardize ecommerce order data from ChannelAdvisor and Shopify for reporting, profitability analysis, and dashboard generation.

  • Python
  • ChannelAdvisor API
  • Shopify GraphQL
  • Supabase
  • PostgreSQL
  • Next.js
  • TypeScript
  • pandas
read_case_study