← ham's website resume
Selected Work

Case Studies

Product Case Study


Product Management & UX Case Study · 2026

Responsive Menu UI for Stretched Resolutions

Independent VALORANT case study using player interviews, product requirements, solution tradeoffs, and a planned usability test to improve Shop and Settings access on 5:4 and 4:3 resolutions.

Technical Projects


Excel Data Project · 2026

Slug Gaming Operations Dashboard

An anonymized Excel dashboard analyzing community growth, event performance, 500+ recorded esports room uses, budgets, recruitment, program activity, and external company partnerships.

Technical Project · 2025

Dependency-Aware Scheduler

Python scheduling system that models tasks, blockers, prerequisites, redo logic, and alternate dependency paths for launch-style project planning.

Data Project · 2025

SFO Flight Capacity Analysis

SQL case study using joins, filters, aggregates, and grouped results to analyze flight capacity by route and aircraft type.

Strategy Projects


Strategy Project · 2026

Startup Product Strategy + Financial Analysis

Project collection connecting product concept design, market strategy, NPV cash-flow analysis, ownership and dilution, and startup launch planning.

Strategy Project · 2026

Cisco Systems - ERP Implementation

Analysis of Cisco's ERP replacement decision, vendor selection process, and the causes of the post-launch system failure.