BI Ejecutivo — Savia Salud EPS
50+ executives at a 1M+ member health insurer wasted 40h/week manually assembling Excel reports from 4 incompatible regulated sources (RIPS, BDUA, tutelas, clinical records).
Designed a cloud data warehouse integrating all 4 sources with automated ETL pipelines in Python/Airflow. Built geospatial predictive models for demand forecasting. Delivered Power BI dashboards with custom HTML/CSS visuals and live refresh — zero manual intervention.
Eliminated 100% of manual Excel reports. Critical reporting cycle dropped from 3 days to 4 hours. Geospatial models hit 85% accuracy, reshaping resource allocation for high-risk zones.
Stack