Professional portfolio

Arturo
Tena Franco

Petroleum Engineer · Data Science & AI
Applied to the Energy Industry

10 years at PEMEX specializing in well productivity and reservoir engineering, combining technical O&G knowledge with Python, Power BI, and artificial intelligence to drive operational decisions in the energy industry.

  • UNAM · Ing. Petrolera
  • Reservoir Engineering
  • Well Productivity
  • Python · Power BI
  • Firebase · Web Apps
  • Kóritsu Consulting

About me

Reservoir engineer
with a data mindset

I spent 10 years at PEMEX solving real production problems — first with nodal analysis and pressure testing, then building the digital tools that accelerated those decisions. That combination of O&G technical domain and development capability is what I bring as a consultant.

I currently work at Kóritsu Consulting helping energy sector companies digitalize operations and extract value from their production data using Power BI, Python, and Firebase.

Experience

2023 – Present Independent Consultant Kóritsu Consulting
2018 – 2023 Project Eng. · Reservoir · Data Science PEMEX E&P — Abkatún Pol Chuc
2014 – 2017 Well Productivity Engineer PEMEX E&P — Litoral de Tabasco

Leadership

Treasurer

CIPM — Sección Dos Bocas  ·  2022–2024

  • Organized 4 annual assemblies for members across offshore platforms and onshore offices
  • Implemented digital voting via Microsoft Forms — real-time results visible simultaneously onshore and on offshore platforms

Leader — Talento PEP

PEMEX E&P  ·  2014–2017

  • Led professional integration group of 60+ engineers across 2 production assets (Abkatún Pol Chuc & Litoral de Tabasco)

Technical experience at PEMEX

Well Productivity

Activo Litoral de Tabasco · 2014–2017

Nodal analysis, inflow/outflow performance evaluation, pressure transient testing (PTA/PBU), and operational parameter optimization to maximize well production across the asset.

Reservoir Engineering

Activo Abkatún Pol Chuc · 2018–2023

Reserves estimation, decline curve analysis, production forecasting, drive mechanism analysis, and pressure monitoring for the 78 reservoirs of the asset.

Project Engineer

Offshore platforms · Gulf of Mexico

Technical liaison between the Production Asset and offshore marine platforms. Responsible for executing well intervention programs: stimulations, minor repairs, and workover operations.

CIPM Treasurer

Sección Dos Bocas · 2022–2024

Budget management, membership fees, credentials, and 4 annual events. Implemented digital voting with Microsoft Forms + Teams — all members voted in real time from any location, replacing the manual in-person counting process.

Infographic: 10 years of petroleum engineering at PEMEX — Arturo Tena Franco

Education

2024 Data Science & AI Diploma Facultad de Ingeniería, UNAM
2023 Statistics in R Diploma Instituto de Geología, UNAM
2018 Power BI Data Analyst Microsoft Certification
2013 B.Eng. Petroleum Engineering Facultad de Ingeniería, UNAM

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 Conversational AI
Querinox · Kóritsu Consulting 2026

Querinox Bot

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.

4 Product flows
3 Notification channels
0 Manual intervention
BotpressLLMWhatsApp Business APIGoogle SheetsMeta
05 Firebase Full-Stack Development
Personal project 2024 – Present

Quiniela Tena

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.

v2.5 Active in production
6+ API integrations
100% Serverless
FirebaseRealtime DBMercado PagoGoogle APIsWhatsApp
06 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

Areas of expertise

Three worlds, one profile

O&G Technical

  • Well Productivity Expert
  • Reservoir Engineering Expert
  • Nodal Analysis / PTA Expert
  • Forecasting & Reserves Advanced
  • Wellflo · Prosper · Pansystem Advanced

Data Science & AI

  • Power BI & DAX Expert
  • Python (analytics) Advanced
  • R (statistics) Intermediate
  • Applied Machine Learning Advanced
  • Data Visualization Expert

Web & App Development

  • Firebase (Realtime DB, Hosting) Expert
  • HTML / CSS / JavaScript Advanced
  • Astro (this portfolio) Advanced
  • API Integrations Advanced
  • Visual Basic / Advanced Excel Advanced
What sets me apart: