At Comfandi, I build analytics for a network of 13 schools and the Occupational Foresight team. I created a Python parser and Streamlit app that extracts Saber 11 results from official ICFES PDFs, replacing manual data entry at each school.
I also developed a geospatial pipeline to identify families affected by the August 2026 earthquake, with the results feeding Power BI and Azure Maps. The analysis included evaluating the distance involved in temporarily relocating a school campus.
For the school network, I design Power BI dashboards for management KPIs and students’ post-secondary pathways. I’ve also built a teacher staffing planner and Power Apps solutions that replace shared Excel files.
Earlier at Comfandi, I managed the ERP for schools, institutes, and the library network, and developed a machine learning model to classify cost-object categories. At DNA Music, I centralized financial data for Power BI reporting; at Universitat Oberta de Catalunya, I designed and tracked service-level KPIs using Oracle data.
