Jesus Flores
Infrastructure Finance & Data Automation Specialist
Mexico, Puebla
Summary
Infrastructure finance and data automation specialist skilled in project controls and CAPEX reporting to enhance financial and physical progress tracking. Proficient in Power BI modeling, advanced Excel automation, and SharePoint document control to improve data accuracy and stakeholder communication. Focused on leveraging technology and analytics to optimize infrastructure project delivery and risk management.
Overview
19
19
years of professional experience
Work History
Data & Project Controls Analyst
Aleatica – Atizapán–Atlacomulco Highway Project
08.2023 - Current
- CAPEX: MXN $20,000M highway concession
- Automated financial and physical progress reports, reducing processing time from 3 days to under 1 minute (400+ hours saved/month).
- Built a multi-source Power BI executive dashboard used by 100+ stakeholders, including Contracts, Project Management, Finance, and Investors.
- Consolidated 40,000+ monthly data rows from 20+ sources (Supervision, Contractors, Contractual, SICT Recognition).
- Identified inconsistencies, duplicated quantities, and concept misallocation, improving data accuracy and preventing reporting errors.
- Managed documentation and monthly reporting for physical progress, financial progress, and SICT recognition.
- Automated Excel tools for program comparison, contractor estimates, and WBS-based monitoring (VBA + Power Query).
- Organized and standardized 200,000+ construction photos in Procore, mapping them to the official WBS.
Statistical & Performance Monitoring Consultant
Frenier – Concession Oversight for Water & Sewer System in Puebla
07.2023 - Current
- Consolidated field-collected data and produced monthly regulator reports covering 31 KPIs.
- Compared operator-reported data vs. field verification, detecting 3 KPIs with negative trends requiring regulatory action.
- Generated visual analyses, trend charts, and performance deviations for concession oversight.
Financial Controls
Consultant for IDBC-Hermes Infrastructure
06.2023 - 12.2025
- Mexicali Pumping System
- CAPEX: MXN $191M (Stage 1) + $178M (Stage 2)
- Client: CONAGUA – Colorado River–Tijuana Aqueduct
- Managed financial tracking for modernization of 16 high-capacity pump–motor units (3,500–8,000 HP) and electrical transformers operating since 1986.
- Reported variances, progress curves, cash flow, and deliverables to corporate leaders and concession authorities.
- Ensured financial compliance and supported procurement and contractor deliverables.
Project Controls & Reporting
Hermes Infrastructure – La Peninsular Constructor
01.2021 - 02.2023
- CILA Pumping Plant, Tijuana
- CAPEX: MXN $88M
- Managed physical–financial reporting, procurement tracking, and executive presentations for modernization of the CILA International Pumping Plant.
- Tracked equipment from international suppliers (Germany & others) including gates, pumping systems, and electromechanical components.
- Controlled cost deviations, extraordinary price files, schedules, and project close-out documentation.
- Achieved direct contribution to MXN $7M profit by optimizing documentation accuracy and cost control.
Project Controls Coordinator
Concesiones Integrales (Hermes Group)
04.2019 - 01.2021
- Coordinated documentation and progress tracking for 200+ water, sewer and drainage infrastructure projects (2014–2019).
- Created a full SharePoint digital archive (1–2 GB per project + photos) used by Directors, Superintendents, and Operations.
- Automated 90% of documentation processes and standardized deliverables across 12 resident engineers and 20–30 contractors.
- Delivered monthly financial/physical reports and variance analyses, improving visibility for top management.
- Led the successful demolition of a seismically damaged elevated tank and assisted the Superintendent and Manager in corporate reporting.
Seismic Damage Research Fellow
CONACYT – National Research Scholarship
02.2018 - 04.2019
- Built nonlinear structural models (SAP2000, ETABS, OpenSees, DRAIN2D) to analyze post-earthquake school building damage for INIFED.
- Research published at the 2019 National Congress of the Mexican Seismic Engineering Society.
Event Photographer (Support)
AS Fotografía
01.2016 - 01.2018
Professional Internship – Construction Supervision
RSC Arquitectos
07.2016 - 06.2017
- Assisted construction supervision of two residential towers (18 & 21 stories).
Business Process Support
Dulino & Sabrositos
08.2006 - 12.2016
- Designed digital payroll tools reducing manual calculation errors.
- Migrated manual sales-tracking systems to a POS platform; built databases and product catalog (photos + pricing).
- Developed website for product ordering before modern delivery apps existed.
Education
Master of Corporate Finance - Finance
Universidad De Las Américas - UDLAP
Puebla, Mexico City, Mexico 05.2001 -
Bachelor´s Degree - Civil Engineering
UPAEP
Puebla, Mexico City, Mexico06-2019
Skills
Project Controls & CAPEX Reporting
Financial & Physical Progress Dashboards
Advanced Excel (Macros, VBA)
Data Automation (Power Query, VBA, ETL)
Power BI Modeling & Visualization
Project (WBS, Scheduling)
SharePoint Architecture & Document Control
Procore (Financial & Photo Models)
Data Quality, Error Detection & Standardization
Risk Analysis & Variance Tracking
Stakeholder Engagement (Contractors)
Infrastructure Projects (Water, Roads, Electric)
Mountain hiking and wellness
- Mountain hiking and trekking
- Wellness
- Running and endurance training
Timeline
Data & Project Controls Analyst
Aleatica – Atizapán–Atlacomulco Highway Project
08.2023 - Current
Statistical & Performance Monitoring Consultant
Frenier – Concession Oversight for Water & Sewer System in Puebla
07.2023 - Current
Financial Controls
Consultant for IDBC-Hermes Infrastructure
06.2023 - 12.2025
Project Controls & Reporting
Hermes Infrastructure – La Peninsular Constructor
01.2021 - 02.2023
Project Controls Coordinator
Concesiones Integrales (Hermes Group)
04.2019 - 01.2021
Seismic Damage Research Fellow
CONACYT – National Research Scholarship
02.2018 - 04.2019
Professional Internship – Construction Supervision
RSC Arquitectos
07.2016 - 06.2017
Event Photographer (Support)
AS Fotografía
01.2016 - 01.2018
Business Process Support
Dulino & Sabrositos
08.2006 - 12.2016
Master of Corporate Finance - Finance
Universidad De Las Américas - UDLAP
05.2001 -
Bachelor´s Degree - Civil Engineering
UPAEP