Hey, I'm John!
I am a current Junior studying Computer Science at UC Irvine set to graduate with a Bachelor's by June 2028. I'm interested in full stack development, machine learning, and building practical projects. However, I love to learn new things and like to consider myself a fast learner!
In my free time, I like to surf, go on hikes and play the guitar.
- Designed a normalized 7+ table PostgreSQL schema with JSONB columns, consolidating 17+ CSV formats into one queryable table serving 200+ engineers
- Engineered a Python ETL pipeline using SQLAlchemy and pandas to ingest 1000+ JSON/CSV/.log test results, reaching 400+ test runs in the first month and cutting manual validation by 80%
- Configured nginx as a TCP reverse proxy in front of PostgreSQL, routing all connections through a single entry point and eliminating direct DB access
- Integrated database push into the Ansible/Fabric/pytest pipeline as a custom CLI option, enabling one-command ingestion post-test and cutting query execution times by 50%
- Built a full-stack site improving patient-facing care coordination in React, TypeScript, and Fastify, consolidating caregiver, clinician, and family updates into one role-based platform
- Built CI/CD pipelines with GitHub Actions and Docker, deploying to AWS (Cognito, Amplify, EC2) at 100% uptime
- Supported 200+ students by troubleshooting C/C++ code, clarifying core concepts, and answering real-time questions
- Created supplemental reference materials and walkthroughs for complex data structure implementations
- Built ML pipelines in PyTorch for amino acid sequence detection, training Spiking Neural Network architectures on biological datasets
- Developed data visualization and analysis tooling with NumPy and Matplotlib to evaluate model performance across perception and attention tasks
Selected work
07 PROJECTS · CLICK TO OPENCurrently working on my own video game. Learning how multiplayer systems work, including server authoritative combat, client and server synchronization, hit validation, and how players interact with each other in real time. Also learning how to 3D model using Blender.
A surf trip planning app that shows surf forecasts and flight prices side by side. I go on surf trips often, and it was always a hassle to check a dozen different tabs to find where the waves would be good and when flights were cheap, so I built this to put it all in one place.
An AI app that converts a guitar recording into guitar tab. It chooses fingerings that a real player would use instead of just the technically correct notes. I wanted to build this because there were many songs I wanted to play that did not have tabs online.
My personal website for writing album reviews. The review cards flip over to show the writeup, and subscribers get an email whenever I post a new review.
An AI agent that plays Minecraft on its own. I liked playing Minecraft as a kid and was fascinated by AI that could play games, so I built this project around both. I fine-tuned OpenAI's VPT model with reward shaping and behavioral cloning to get an iron ingot, and it reached a 95.6% success rate.
Three websites I built for my high school iGEM synthetic biology team, one for each competition season from 2021 to 2023. Each site presented the team's research and was reviewed by judges from around the world. We earned a Gold, Silver, and Bronze medal across the three years.
A website for a local restaurant in Temecula that did not have one yet. I offered to design and build it for free in React so the restaurant could be found online.