2012 – Present
Architected a multi-tenant lead management platform with isolated PostgreSQL databases, durable ingestion and automated delivery. Each tenant instance processes millions of transactions per day on very lightweight infrastructure where cost effectiveness, reliability and scalability were at a premium.
What I Built
- Ported the entire legacy PHP website to Next.js using OpenAI Codex.
- Built a Telegram support bot that lets customers ask questions about their own instance in group chats without needing technical support staff to answer.
- Migrated from a costly, fully virtual environment to dedicated physical hardware, saving hundreds of thousands of dollars in overhead and recurring monthly expenses.
- Built tenant-aware connection pooling and Python workers for CSV and API ingestion, field mapping, deduplication, assignment and delivery.
- Implemented batched delivery with retries, throttling and overflow routing to enforce campaign limits and recover failed jobs.
- Designed parameterized search and enrichment queries using DISTINCT ON and keyset pagination.
- Built tenant-scoped reporting APIs, dashboards and streaming CSV exports with FTP/FTPS delivery, role-based access and audit logs.
Jul 2026 – Present
Built an ESPN-style site for cue sports, where fans can explore historical professional pool results and player statistics, compare performances, and catch up on news and YouTube videos.
What I Built
- Built collectors for APIs, websites, PDFs and images using Playwright and OCR. Normalized records and matched player identities with fuzzy and phonetic matching.
- Queued collection jobs in RabbitMQ, made reprocessing safe with idempotent upserts, and synchronized live scores over GraphQL WebSockets with automatic reconnects.
- Modeled relational and JSONB data and used dependency-ordered materialized view refreshes, CTEs, window functions and lateral joins to serve rankings and head-to-head analytics.
- Built a world-class, first-of-its-kind rating system for professional pool that uses variable weighting to track each player's rating over time, both overall and by discipline.
- Built a parallel OpenCV and FFmpeg pipeline that detects ball motion and rack boundaries to turn full matches into condensed clips.
Mar 2026 – Present
Reverse-engineered legacy devices such as automatic chicken coop doors and boat lifts so owners could control them over Wi-Fi from a mobile app. Captured and decoded Bluetooth and radio signals and designed custom circuit boards to support the different devices. Customers already use the AirRemote gateway, and the website offers a preorder interest list.
What I Built
- Reverse-engineered the Bluetooth traffic between an Android phone and a chicken coop door. Captured the traffic and used AI to identify the exact commands a compact ESP32 could send to control the door remotely.
- Built a radio receiver to capture commands from legacy boat lift remotes such as GEM. An ESP32 with a radio transmitter replays those commands so customers can raise and lower their lifts from the app.
- Built Flutter apps for iOS and Android with Bluetooth Wi-Fi setup, secure session storage, live device status and a shared REST API for gateway commands.
- Wrote MicroPython firmware with BLE/GATT adapters, Wi-Fi failover, signed over-the-air updates and local recovery routines.
Built React tournament dashboards with interactive charts for win rates and match lengths, plus sortable comparisons of tournament performance and player ratings.
What I Built
- Helped shape the product roadmap, made design and usability decisions, and built features for both site visitors and the people who manage the platform.
- Built ETL to normalize DigitalPool events, brackets and results for insidesp.in, then used Firebase Functions to bring insidesp.in rankings and player profiles back into DigitalPool.
Created Tradesmark, a mobile asset registration product, built its website, and deployed the app to several field technicians who are now beta testing it.
What I Built
- Built a Flutter app for iOS and Android that scans QR codes, registers assets and helps users find providers.
- Used Riverpod for state management, Auth0 with secure token storage, and Next.js mobile APIs.
Built the full business website for Shooters Billiards, with information about the pool hall and a dedicated section for league play.
What I Built
- Built player performance and head-to-head matchup history views using FargoRate data.
- Automated handicap lookups and score submission with Playwright and serverless Chromium on Vercel, then read back the submitted scores to verify them.
Built a broadcast overlay for live pool break speeds.
What I Built
- Decoded BreakDemon telemetry over WebSockets with Protocol Buffers and served the latest reading through a JSON API.
Designed a standing support for the rear deck of Sea-Doo personal watercraft.
What I Built
- Used the LinQ cargo rack and designed around cooler clearance and rod-holder placement.
SB
Snookered Billiards & Bar
Owner
Aug 2018 – Nov 2022 · Frisco, TX
Mar 2013 – Aug 2016 · Alpharetta, GA
Designed a reporting and analytics platform spanning Kafka, Elasticsearch, Kibana, PostgreSQL, BIRT, Python and a custom web front end.
What I Built
- Built incremental ETL adapters, a parallel message processing framework, dimensional models and database architecture for reporting across products and storage platforms.
Sep 2011 – Mar 2012 · Atlanta, GA
Designed ETL processes and OLAP cubes and built an automated tax management solution.
Digital Realty Trust
Data Architect
Apr 2011 – Aug 2011
Built and supported the corporate data warehouse and BI environment, automated business processes, built proofs of concept and established a corporate data definition portal.
Jan 2007 – Apr 2011 · Nashville, TN
Designed the company’s first OLAP cube for subscriber analytics and an automation framework used to run and maintain hundreds of ETL processes.
What I Built
- Designed the corporate BI hardware architecture, built a .NET database deployment app, and developed an ETL engine for the Greenplum warehouse.
Jan 2001 – Jan 2007 · Pompano Beach, FL
Jan 1999 – Jan 2001 · Pompano Beach, FL
CRAIG
