All Entries · 12 records
Guardians Make Their Own Fate
click anywhere to dismiss
Portfolio
aka agoodtheory
I'm a Senior Business Analyst with a strong SQL background and a passion for data, programming, and building solutions in the cloud. I'm working toward a career transition into data engineering through hands-on project work and formal AWS training. Outside of work I enjoy building things — from serverless data apps to tinkering with hardware, to whatever idea lodges itself in my head and won't let me rest until I figure it out — and you'll usually find me hiking or fully locked into gaming.
Projects
A full-stack data engineering project that models how a message would travel across the continental US via dog-owning households, county by county. Built on U.S. Census data, a weighted NetworkX graph, Dijkstra pathfinding, and a serverless AWS backend — with an animated Leaflet.js frontend that visualizes the route in real time.
A private, AI-powered research archive for cataloging and cross-referencing reported paranormal phenomena — Bigfoot sightings, UFO/UAP reports, Missing 411 cases, and more — normalized from public datasets into a unified schema. Entries are embedded into a Pinecone vector index and queried through a Claude-powered reasoning layer that surfaces cross-case patterns: geographic clustering, seasonal timing, behavioral overlap across otherwise unrelated reports. There's no link to it anywhere on this site. Access is triggered by a passphrase typed directly into the AI chat widget in the lower right corner, which silently unlocks a hidden login screen. The architecture is open. The door is locked.
A standalone desktop ingestion pipeline that feeds The Compendium. Takes CSV, XLSX, or PDF input, fuzzy-matches columns against a configurable field schema, shows a live JSON preview and cost estimate before committing, checks for duplicates against a DynamoDB GSI, and delivers in one pass to DynamoDB, S3, and Pinecone. Packaged as a portable Windows executable.
Skills & Tools
Data
Cloud & Infra
Frontend
Tools
About
The handle agoodtheory has been mine for years — a gaming tag that made its way onto GitHub and eventually into a domain name. It fits: I tend to show up with a theory, test it against reality, and see what survives.
My background is in business analysis, where I've spent years translating data into decisions. I'm now building toward data engineering — combining the analytical foundation I already have with the technical skills to work further upstream in the data pipeline.
When a problem gets interesting enough, I can't let it go. Twilight Bark started as a half-formed idea on a walk and turned into a full-stack data project with a live AWS deployment. That's usually how it goes.
Currently
Senior Business Analyst
Targeting
Data Engineer · Analytics Engineer
Training
AWS (Adrian Cantrill) · Python · Cloud Infrastructure
Outside work
Hiking · Gaming · Building things