Ryan Condon headshot

Ryan Condon

Portfolio

Across contexts, my work seeks to take a complex system, build a framework for understanding it, and make it accessible — in writing and in software.

Coding Projects

Things I've designed and shipped with AI pair-programming tools — from data pipeline to deployed product.

Daily Web Game · Live

7-0

A free daily Magic: The Gathering puzzle game. Follow a real 7-0 (trophy) draft from a top-ranked 17lands player pick by pick, predict each pick, and share your Wordle-style results. I built the whole pipeline: filtering 4.5M rows of public draft data down to curated puzzles in Python, a React/Next.js front end with daily and quick-play modes, and automated deploys on Vercel.

  • Python
  • Next.js / React
  • Vercel
  • Supabase
Play 7-0 →

Team Platform · In Use

PT Hub

A multi-tool platform I built and run for my Pro Tour testing team — everything the team needs to prepare for one tournament, in place of a Discord server nobody can search. One account follows you across every season and every tool:

  • Deck Board — everyone's live odds on what they'll register, against the team average.
  • Metagame — the field's archetype share from published results, grouped by what decks actually play.
  • Set Review — a discussion page per card in a draft set, with agreement voting.
  • Decklists — the team's lists, filed by archetype and searchable, with sideboard plans.
  • Meetings — availability grids that find a time and chase whoever hasn't answered.
  • Expenses — splits the testing house by who stayed which nights, in the fewest payments.
  • Survey — asks the logistics questions once and tracks who still owes an answer.
  • Node.js
  • Vanilla JS
  • Supabase
  • Vercel
Private team tool — happy to demo!

Writing: Data Infrastructure & Documentation

Modeling

Customer LTV Model

A framework for calculating customer lifetime value at Qeepsake, built to inform retention strategy and marketing spend decisions.

View PDF →

Documentation

How to Use Sigma

Internal onboarding documentation I wrote to teach non-technical teammates how to navigate Qeepsake's data warehouse using Sigma Computing.

View PDF →

Live Communication about Data Architecture

Journal Entries & Sent Questions: A Data History

A live recounting of how Qeepsake's core engagement tables evolved through two major schema changes — and how I stitched them back together to create a full, working history. [Note: This is a sample of live written communication, not permanent documentation].

View PDF →

Writing: MTG Strategy & Competitive Systems

Teamwork & Soft Skills

On Empathy as a Skill in High Level Magic

On the value of "soft skills" in a strategy game where players compete as individuals, but must work together & learn from each other to prepare effectively.

Read on Patreon →

Strategy & Ethics

Proactive Ethics in Tournament Magic

An argument for a more active ethical standard in competitive play — not just following rules, but taking responsibility for the environment you create for others.

Read on Patreon →

Performance & Wellbeing

Body-Mind Integration Through Chronic Pain

Connecting athletic and analytical performance — how my journey with chronic pain changed the way I think about competitive preparation and physical sustainability.

Read on Patreon →

Curiosity & Engagement

Balancing Intellectual Curiosity with Personal Engagement

On the tension between going deep on a problem and staying present with the people around you — and why I think both matter in competitive and professional environments.

Read on Patreon →