Selected projects
Real-time production analytics platform
36-module Power BI system centralizing monitoring of ~300 wells across PEMEX Marine Subdirección, with daily 5am data cutoff.
Reservoir intelligence with 45+ years of history
17 modules with production history from 1980. Reservoir engineering analyses — drive mechanisms, Chan plot, pressure-production — directly in Power BI.
Reservoir technical datasheets on any device
Power Apps application with complete technical datasheets for all 78 Asset reservoirs: petrophysical parameters, fluid properties and cumulative production — accessible in seconds from any device.
AI sales agent on WhatsApp
WhatsApp Business chatbot with integrated LLM for Querinox (stainless steel manufacturer). Collects technical requirements from clients, generates a structured brief, and notifies the owner via WhatsApp, email, and Google Sheets.
Sports management web app in active production
A football pool between coworkers and friends that started in Excel, moved to Google Forms, and has been running for 10 years. This year it hosts its third World Cup. Shows the evolution from a simple idea to a full web app with payments, external APIs and real users.
Bilingual professional portfolio with real production data
This site. Astro + Firebase Hosting + Zoho Mail, bilingual ES/EN, with interactive case studies, real BDI PEMEX data charts, and functional contact form.