Medical economics and VBC analytics
PMPM trend, capitation and shared-savings modeling, risk stratification, attribution, bundled-payment analysis, HEDIS and quality reporting.
Healthcare analytics · Phoenix, AZ
I turn messy healthcare data into numbers people can act on.
Medical economics analyst at HOPCo, founder of Data Hound Technologies, adjunct in health informatics at GCU.
What I do
Four things, done carefully.
Most engagements are some mix of these. The common thread is claims data, real money, and an audience that needs a straight answer.
Data engineering for analysts
SQL Server and Snowflake ETL, DuckDB and Parquet pipelines, Python automation, Power BI and Tableau delivery.
Automation and small software
n8n workflows, Flask and FastAPI services, Raspberry Pi and Docker deployments, digital signage.
Teaching and translation
Graduate health informatics instruction, and explaining analytics to clinical, operations, and finance audiences.
Selected work
Real projects, described plainly.
Public tools and consulting work I can talk about. Employer analytics stay at the employer.
Healthcare Price Transparency
Public hospital rate lookup · healthcare.traqqit.com
- Problem
- Hospital negotiated-rate files (machine-readable MRF data) are huge and unusable for a patient or a small practice trying to compare prices.
- Built
- A DuckDB and Parquet pipeline that ingests and normalizes negotiated rates, with a FastAPI backend and a web front end for looking up rates by procedure and payer (initial focus: Anthem PPO).
- Outcome
- A working public lookup tool, and the groundwork for an orthopedics-focused variant.
- Python
- DuckDB
- Parquet
- FastAPI
- Hostinger
PSP Browser
Modern web on a 2004 handheld · pspbrowser.traqqit.com (TODO: link when live)
- Problem
- The PlayStation Portable's built-in browser can't render the modern web.
- Built
- A Python/Flask proxy on a Raspberry Pi that fetches, simplifies, and re-serves pages the PSP can render, plus a public site with a one-line
curl | bashinstaller, a systemd unit, and a setup guide. - Outcome
- Anyone with a Pi can stand up a working PSP browser in minutes. Deployed on Hostinger using the same traqqit.com pattern as this site.
- Flask
- Raspberry Pi
- systemd
- Hostinger
House-wide CO₂ monitoring
Homelab · sensors to dashboards
- Problem
- No visibility into indoor air quality across rooms, and a home internet connection behind CGNAT that blocks normal self-hosting.
- Built
- ESP32-C3 and SCD41 sensor nodes on ESPHome and MQTT feeding InfluxDB and Grafana, all in Docker Compose on a Raspberry Pi 4B. Tailscale for private access, Cloudflare Tunnels for public hosting, MikroTik routing.
- Outcome
- Continuous room-level CO₂ dashboards and a reusable hosting pattern for other side projects.
- ESPHome
- MQTT
- InfluxDB
- Grafana
- Docker
- Tailscale
- Cloudflare
Medical bill review automation
Data Hound Technologies · intake pipeline
- Problem
- Reviewing and negotiating medical bills is manual: read the bill, pull the codes, check them against expected rates, draft the dispute.
- Built
- n8n workflows with OCR that extract line items from uploaded bills and stage them for review and negotiation.
- Outcome
- A repeatable intake-to-review pipeline for the bill negotiation service. TODO: one sentence on results, if wanted
- n8n
- OCR
- Python
Digital signage for pickleball clubs
Data Hound Technologies · managed service
- Problem
- Franchise locations need court schedules, league flyers, and hours on screens without staff managing content by hand.
- Built
- A Yodeck-based managed signage service: configured players, content templates, remote updates, annual contract.
- Outcome
- Live at franchise locations under a managed annual agreement.
- Yodeck
- Managed service
References
What people I've worked with say.
TODO: quote
About
Analyst first, builder second, teacher on Tuesdays.
headshot
I'm a healthcare data analyst in Phoenix. By day I do medical economics at HOPCo, a musculoskeletal value-based care company. Before that I worked on ACO performance and population health at OnBelay Health Solutions, Equality Health, and ACO Partner, mostly in SQL, Python, and Power BI, mostly on claims.
On the side I run Data Hound Technologies, teach graduate health informatics at Grand Canyon University, and build small tools that live at traqqit.com. I like problems where the data is messy, the money is real, and someone has to explain the answer to a non-technical room.
- 2026 – presentHOPCo Medical Economics Analyst
- TODO: start year – presentGrand Canyon University Adjunct Instructor, Health Informatics (HIM-650, HCI-690; previously HIM-615)
- TODO: start year – presentData Hound Technologies Founder. Analytics and automation consulting, mostly healthcare.
- TODO: yearsPickleball Kingdom Technology Director. POS, member management, court reservations, KPI reporting, franchise tech support. TODO: confirm still current
- TODO: yearsOnBelay Health Solutions Senior Business Analyst. Actuarial dashboards, capitation modeling, risk stratification with claims and ADT data.
- TODO: yearsEquality Health Population Health Analyst. HEDIS automation, value-based payment modeling, stratified reporting on Arizona Medicare contracts.
- TODO: yearsACO Partner TODO: title. Shared-savings financial modeling.
- TODO: yearArizona State University MS, Biomedical Informatics
Skills
The stack I actually use.
Data
- SQL (T-SQL, PostgreSQL, MySQL)
- Python
- R
- DAX
- DuckDB
- Parquet
Platforms
- SQL Server
- Snowflake
- Databricks
- Epic Clarity / Caboodle
- Power BI
- Tableau
Build
- Flask
- FastAPI
- n8n
- Docker
- GitHub Actions
- Raspberry Pi
- Grafana
- InfluxDB
- ESPHome / MQTT
- Tailscale
- Cloudflare Tunnels
Domain
- ACO / MSSP
- Medicare Advantage
- HEDIS
- Risk adjustment
- Capitation
- Bundled payments
- Price transparency (MRF data)
Writing
Writing
I write a newsletter called Serendipity Sundays.
Contact