Selected projects

What I've built

01 Operational Intelligence
PEMEX E&P 2018 – 2023

ADPAY Diario

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.

~300 Wells monitored
36 Analysis modules
5am Daily cutoff
Power BIDAXO&G AnalyticsPEMEX
02 Reservoir Engineering
PEMEX E&P 2018 – 2023

ADPAY Mensual

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.

45+ Years of history
17 Specialized modules
78 Reservoirs
Power BIDAXReservoir Eng.Chan Plot
03 O&G Mobile App
PEMEX E&P 2021

Prontuario APAPCH

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.

78 Reservoirs documented
3 User levels
100% Mobile, no install
Microsoft Power AppsM365SharePointO&G Data
04 Automation & Data
Personal project 2024 – Present

Quiniela Tena

Automated system with a Telegram bot and runtime code generation

A football pool for 60+ coworkers that started in Excel and has been running for 10 years. Today a Telegram bot builds each round, detects deposits by reading the bank's email, publishes results, and announces the winner — with no administrator. The admin panel generates and uploads its own Apps Script code for every round.

63 Group members
5 Automated events
0 Admins needed
FirebaseFirestoreGoogle Apps ScriptTelegram Bot APIGmail parsing
05 Digital Portfolio
tefra.mx 2026

tefra.mx

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.

6 Documented projects
2 Languages
100% Open source
AstroFirebaseTypeScriptChart.jsEmailJSZoho Mail