Full-stack · Data · Systems

I build software that real organizations actually run on.

I'm Edwin, a computer science graduate in Costa Rica, now finishing a systems engineering degree. I've built a church management platform used across the country, a football data pipeline with a prediction model, and an AI tutor that 100+ kids used in one day. I'm moving into data and technical roles.

B.Sc. Computer Science · NCU, 2021 Systems Eng. · UNADECA, in progress English & Spanish

Featured work

Two projects, two sides of the work

One is a production web app with real users and strict access rules. The other is a data pipeline that cleans messy inputs, models them and tests the results.

Presencia Líder

3 developers + faculty advisor · web & backend lead

A platform where Adventist churches in Costa Rica track weekly small-group meetings, attendance and activities, from the local group up to the national union. It replaces paper reports that leaders often never turned in. Built by three student developers (Android, iOS, and me on web and backend) with a faculty advisor.

188database migrations
52pages in the web app
7roles, each with its own scope
296real congregations loaded
Next.js 14TypeScriptTailwindPostgreSQLSupabaseRow-level securityMetabaseVercel
  • Access control in the database. Row-level security policies and a helper function walk church → district → conference → union, so each role only sees its own scope. The rules live in Postgres, not in app code.
  • Reports across the whole hierarchy. Attendance, studies, visits and offerings by week, month, quarter or year, compared across conferences, districts, churches or groups, with PDF, Excel and CSV export.
  • Faster queries, same results. Moved report summing into the database and cut the yearly report from 930 ms to 155 ms (6×) and the quarterly one from 190 ms to 70 ms. Old and new outputs were compared with EXCEPT ALL: zero rows differ.
  • Shared backend for mobile. Defined the data contracts the Android and iOS apps build on, so all three clients work from one schema.
  • Analytics layer. A separate analytics schema with materialized views and at-risk snapshots (members drifting away, inactive groups, lapsing visitors), feeding Metabase dashboards that read from a replica synced by cron, never from production.
  • Approved for rollout. Signed off by UNADECA and the union for all three Costa Rica missions plus UNADECA's theology students.

Fantasy Predictor

Started as a Data Structures course project

An end-to-end data project built on a fantasy football API: a Postgres backend under real load, an ETL that cleans messy department data into a reporting layer, dashboards on top, and match predictions.

ExpressTypeScriptPostgreSQLETLData martMetabaseDockerTerraformk6Poisson model
  • ETL from messy data. Pulled deliberately inconsistent sources (an Excel ledger, a SQLite database and Notion JSON exports) through a custom ETL into a mart layer, logging every run and every rejected row.
  • Dashboards on top. Four Metabase dashboards read from the mart, so every number comes from one cleaned source.
  • Infrastructure as code. Terraform defines the stack, from Docker locally to an AWS-style setup with a database, compute, S3 landing zone and scheduled jobs.
  • Load tested, bottleneck found. A 1M-row schema under k6 load showed Postgres CPU climbing past the API's. I traced it to connection-pool oversubscription (about 160 connections on 8 cores) and resized the pool to 48.
  • Match predictions. A Poisson model predicts match scores from each club's attack and defense strength, with a Dixon-Coles upgrade next.

More projects

Other things I've built

Smaller projects across AI, mobile and web. Each one taught me a different part of shipping software.

Ziggy

2025 · Math fair

An animated lion, powered by OpenAI, that taught kids math, answered their questions and played games with them. It ran from 9 am to 4 pm at a university fair for nearby high schools and was used by an estimated 100+ students.

OpenAI APIConversational AILive event

FitCoach

In progress · Mobile · AI

A fitness app that will scan a workout routine from a photo with the Claude Vision API, turn it into a log you can track, and add an AI coaching chat.

React NativeClaude Vision APISupabase

FocusWave

iOS

A native iOS focus timer built in SwiftUI with a Supabase backend.

SwiftUISupabase

Premier League model

In progress · 2026/27 season

Extending the Fantasy Predictor ideas into a match prediction model for the current Premier League season, tracked against real results as the season goes.

Pythonpandasscikit-learnSQL

Web & backend

Next.js, React, TypeScript, Tailwind, Supabase (Postgres, Auth, Edge Functions), REST, row-level security.

Data

SQL and Postgres query tuning, indexing, bulk loading, load testing, Metabase dashboards, Python, exports to PDF, Excel and CSV.

Mobile

React Native, SwiftUI, and Kotlin with Jetpack Compose. Sketched the mobile flows for Presencia Líder.

Infra & process

Docker, Terraform, Vercel, AWS, Git, k6 load testing. Migrations in version control and before/after checks on every change.

Experience & education

How I got here

A computer science degree, a few years teaching, and now operations work at a global consulting firm while I build and study.

About

A bit about me

I was born in Costa Rica, grew up in Belize, and studied in Jamaica. That path left me comfortable working across cultures and switching between English and Spanish.

Building Presencia Líder showed me what I like most: taking a messy real-world process and turning it into something people use every week. The data side pulls me hardest, especially making sure the numbers are right before anyone acts on them.

Long term, I'm drawn to sports analytics, which is why my data projects keep ending up about football.

  • Based inAlajuela, Costa Rica
  • DegreeB.Sc. Computer Science
  • StudyingSystems Eng., UNADECA
  • LanguagesEnglish, Spanish
  • Looking forData / technical roles

Contact

Let's talk

Open to data, software and technical roles, in Costa Rica or remote. The fastest way to reach me is email.

contact@edwinmiller.dev