Back to Home
Portfolio Projects
A collection of technical projects demonstrating end-to-end capabilities in GCP, healthcare analytics, and data engineering.
BigQuerySQLPython+2
Medicare Stars Measure Analytics Platform
A comprehensive analytics platform simulating Stars measure calculation with BigQuery, SQL, and Python. Features synthetic data generation for members, claims, and providers, with Looker Studio dashboards for performance tracking.
GCPDataflowPub/Sub+3
HIPAA-Safe Stars Data Pipeline
Secure ingestion and transformation pipeline using GCS, Pub/Sub, and Dataflow (Apache Beam). Implements IAM least privilege, PHI/PII tokenization, and comprehensive data quality checks.
AutomationAnomaly DetectionPython+2
Stars Performance Early Warning System
Automated risk detection system using BigQuery scheduled queries and Python anomaly detection to identify measure risks early. Includes risk scoring models and automated alerting mechanisms.
Data StorytellingExecutive ReportingTableau+1
Executive Stars Storytelling Dashboard
A 'board deck' style dashboard designed for executive consumption. Features high-level KPIs, drill-down capabilities, and a narrative-first approach to explaining performance drivers and recommendations.
ComplianceAuditDocumentation+2
Stars Audit and Compliance Documentation
A complete documentation pack demonstrating audit discipline. Includes measure calculation logic, versioned SQL scripts, audit trail tables, and controls mapping for CMS compliance.
Data MartData EngineeringSelf-Service+2
Self-Service Stars Analytics Data Mart
Design and implementation of a Gold layer data mart for analyst self-service. Includes member, provider, and plan marts with row-level security and semantic layer documentation.