P Marsden Analytics

Projects

Full data platforms, built end to end, when I pick the problem.

FPL Pipeline & Squad Optimiser

An end-to-end Fantasy Premier League decision engine.

A full data platform for Fantasy Premier League, with a live API poller feeding PostgreSQL, a dbt mart layer, and a two-stage machine-learning model (LightGBM and Random Forest) that predicts each player's points per gameweek. An integer-programming optimiser then picks the best squad within the game's budget and formation rules, backtested by replaying whole seasons a gameweek at a time: 2,392 points across 2025-26, against the average manager's 1,895. The 2026-27 season is being played live, with every pick committed before the deadline. Served through a FastAPI backend and a React dashboard.

Solgard Guardians

A real-time event tracker for a mobile guild game.

A live event tracker for a mobile guild game with no public API. It captures game events by intercepting the app's HTTPS traffic through a man-in-the-middle proxy running on a permanent cloud Android session, then posts live notifications to Discord as they happen.

Have an interesting problem you want to solve?Get in touch