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 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

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: