Pt Pal — Clinician Portal & Outcomes Dashboards

Web (PHP 8.3 + MariaDB)

About

Clinician and organization portal behind the Pt Pal therapy app. Therapists, managers and org admins track patient adherence and outcomes, and the portal serves the mobile API, HL7 feeds, and scheduled survey and report jobs.

My Role

Rebuilt the Power BI outcomes report as native role-aware dashboards over MariaDB with an incremental rollup job, rolled out Sentry across the portal and mobile API behind a PHI scrubbing gate, added the Android Health Connect sync endpoint, redesigned login with security and accessibility fixes, and wrote deploy and rollback runbooks.

Core Capabilities

• Therapist, manager and org-admin dashboards cloned from the Power BI report with filter and data parity
• Incremental rollup job that pre-aggregates outcomes data for fast dashboard reads
• Sentry errors, tracing spans and structured logs behind a PHI gate with a self-test, so no patient data leaves the server
• Surfaced 26 previously swallowed exceptions and fixed cron jobs that aborted mid-run
• Health Connect server-sync endpoint for the Android app
• Login redesign fixing injection sinks, SSO and accessibility issues

Architecture

• PHP 8.3 portal and mobile REST API on MariaDB
• Rollup tables refreshed by scheduled jobs; dashboards read pre-aggregated data
• Power BI semantic model with a SQL Server build engine as the reference implementation
• Sentry PHP SDK with before_send and before_breadcrumb scrubbers and per-environment toggles

Tech Stack