Projects

Data Engineering & Analytics

• CMS 5-Star Quality Scorecard — reconstructing CMS hospital star ratings from public data (API → MinIO → Postgres → dbt → scoring)
  • The Math Behind 5-Star Ratings
  • Dimensional Modeling for Healthcare Quality Data
• Obsidian RAG Pipeline — hybrid semantic + keyword search over this vault, wired into Claude Code via MCP
• Kobo Highlight Pipeline — e-reader highlights → database → this website, zero manual steps
• Running Data ETL Pipeline — merging two wearable data sources into MariaDB for analytics
• Knoebels Wait-Time Models — two seasons of queue-time logging, per-ride models in marimo, and the crowd forecasts live on this homepage
• Bandwidth Forecasting — a week-long MLOps project against my own router data

Reverse Engineering & Hardware

• Lippert OneControl over CAN — tapping the RV’s CAN bus directly for instant, connectionless control (the “RV-C” that turned out to be Lippert’s own IDS-CAN)
• Lippert OneControl over BLE — the earlier Bluetooth approach: decompiling the app to reverse the panel’s BLE protocol
• Golf Cart BMS — reading a LiFePO₄ pack over BLE Modbus, after two weeks spent on a decoy device
• Gazebo Fans — Bluetooth fans driven by encrypted advertisements, adopted by cloning their remotes
• Gazebo String Lights — decoding a Tuya controller’s per-pixel pattern format for arbitrary scenes

Archive

• RVLink Firmware RE — rooting and reverse engineering the Magnadyne RVLink (see the blog for the full series)

Reference

• Mikrotik Scripting
• How This Website Works — the Astro build, the five-minute publish loop, and the live widgets