Project Portfolio
Projects executed for international organizations, governments and civil society organizations in Central America and Latin America. Each case solves a real challenge with proven technology.
🇬🇹 Guatemala · UNDP · Government
SIPREVI — Integrated Violence Prevention Information System
Challenge
Guatemala lacked a unified system to consolidate, analyze and visualize violence data, hampering public security policy decision-making.
Solution
Comprehensive data management and analysis platform for violence with regional consolidation modules, geovisualization and executive report generation, developed for UNDP Guatemala.
Technology
Django · PostgreSQL/PostGIS · Leaflet.js · Power BI · REST API · Docker
Outcome
System operational in multiple municipalities in Guatemala, integrating data from 15+ institutional sources and supporting UNDP’s violence prevention public policy.
🇭🇳 Honduras · Public Ministry
Regional Conflict Geoviewer
Challenge
The Public Ministry of Honduras needed to visualize and analyze patterns of social conflict geospatially to improve institutional response.
Solution
Interactive geoviewer with information layers on crimes, social conflicts and risk zones. Enables temporal and spatial analysis with advanced filters and report export.
Technology
OpenLayers · OpenStreetMap · PostGIS · Pentaho · Python · GeoServer
Outcome
Operational geospatial analysis tool that enabled identification of conflict patterns and optimization of MP resource distribution in priority territories.
🌐 Regional · Human Rights · Civil Society
SAT Defenders — Early Warnings for Human Rights Defenders
Challenge
Human rights defenders in Central America operated without secure technology tools to communicate risk situations and coordinate collective responses.
Solution
End-to-end encrypted Telegram bot for activating early warnings, secure geolocation sharing, network notification and immutable blockchain incident logging.
Technology
Python · Telegram Bot API · E2E Encryption · Blockchain · PostgreSQL · Geolocation
Outcome
Active system protecting dozens of defenders across multiple countries, with coordinated response network and cryptographically guaranteed incident records.
🇩🇴 Dominican Republic · PGR
BI Dashboard — Attorney General’s Office
Challenge
The Attorney General’s Office of the Dominican Republic required consolidating data from multiple units into executive dashboards for institutional decision-making.
Solution
Power BI dashboard suite with direct integration to institutional databases, real-time KPI indicators, comparative analysis and automatic unit-level reporting.
Technology
Power BI · SQL Server · ETL Pentaho · DAX · Power Query
Outcome
Executive report generation time reduced from days to minutes, with real-time access to institutional management indicators for management and executive level.
🌐 UNDP · FONAT · Regional
ONASEVI — Geolocation System
Challenge
ONASEVI needed to geolocate attended cases and available resources to optimize territorial coverage of violence survivor support services.
Solution
Case and resource geolocation system developed for UNDP and FONAT, with field data capture modules, cartographic visualization and coverage analysis.
Technology
Django · PostGIS · Leaflet · Android App · REST API · PostgreSQL
Outcome
Significant improvement in resource planning and territorial coverage, with geolocated data accessible to field teams and program headquarters.
🔏 Transparency · Public Safety
Transparency Portal & Crime Analyzer — National Police
Challenge
Citizens and decision-makers lacked transparent analytical access to crime data registered by the National Civil Police, limiting accountability.
Solution
Public transparency portal with crime analysis engine by category, period, territory and trend. Includes interactive visualizations, data export and public API.
Technology
Django · Chart.js · PostgreSQL · REST API · Leaflet · D3.js
Outcome
Open data portal with public access to historical crime statistics, improving institutional transparency and enabling citizen analysis of public safety.