Jorge Flores Hernández
CDMX
Summary
Experienced Digital Finance Head and Business Intelligence Lead with over 18 years in corporate IT, specializing in finance systems, BI solutions, and automation. Proven ability to lead cross-functional teams, design ETL processes, and deliver executive-level insights through data visualization. Skilled in Oracle Essbase and Oracle EPM/EPBCS, Tableau, SQL, Power BI, and process optimization.
Overview
21
21
years of professional experience
Work History
Digital Finance (Financial Planning) Head
Peñoles – Finance Division
01.2020 - Current
- Financial Planning & Analysis: Oracle EPBCS Administrator (technical and functional)
- Digital Transformation: Lead initiatives for process automation
- Data-Driven; Collaborate with IT and data teams for financial data integrity and architecture
- Process Optimization: Eliminate manual processes, streamline data collection, validation, and reporting cycles.
Oracle Essbase Administrator / BI Lead
Peñoles – Finance Division
01.2012 - Current
- Maintain 100+ Essbase cubes across 2 servers for budgeting and forecasting.
- Lead migration from Essbase 9.3 to 11.1.2.2; cut backup time from 12 hours to 30 minutes.
- Design and manage MAXL, calc scripts, report scripts, and Essbase WebServices.
- Developed Essbase Excel macros using VBA and DODECA add-in.
Systems Analyst / Web Developer
Peñoles – Corporate IT
01.2005 - 01.2012
- Developed enterprise web applications using Java, PHP, JavaScript, Oracle, and Sybase.
- Designed and deployed WebServices and backend solutions for internal tools.
- Drafted specifications for system enhancements and documented incidents.
Education
Master's - Information Technology Management
ITESM
Mexico City01.2008
Bachelor's - Computer Science (Ciencias de la Informática)
UPIICSA – IPN
Mexico City01.2005
Skills
- Analytical Thinking
- Strategic Thinking
- Continuous Improvement Mindset
- Crisis Management
- Emotional Intelligence
- Decision-Making
TECHNICAL SKILLS
- Analytics: Tableau (Admin, API), Power BI (DAX, Power Query)
- Data Integration: Alteryx, Tableau Prep Builder
- Languages/Scripting: SQL, PowerShell, Java, PHP, JavaScript, HTML, EPM Automate
- Essbase Tools: Calcscript, Maxl, Esscmd, Report Scripting, Financial Reporting Studio
- Automation: Excel VBA, DODECA, WebServices, REST API
Languages
English
Advanced (C1)
Timeline
Digital Finance (Financial Planning) Head
Peñoles – Finance Division
01.2020 - Current
Oracle Essbase Administrator / BI Lead
Peñoles – Finance Division
01.2012 - Current
Systems Analyst / Web Developer
Peñoles – Corporate IT
01.2005 - 01.2012
Master's - Information Technology Management
ITESM
Bachelor's - Computer Science (Ciencias de la Informática)
UPIICSA – IPN
Similar Profiles
MOHAMMAD ANWARUL KARIMMOHAMMAD ANWARUL KARIM
Executive Director- Standard Setting at Financial Reporting Council (FRC), Bangladesh, Finance Division, Ministry of FinanceExecutive Director- Standard Setting at Financial Reporting Council (FRC), Bangladesh, Finance Division, Ministry of Finance
Subhash KumarSubhash Kumar
Junior National Savings Officer at Finance Division, Ministry of FinanceJunior National Savings Officer at Finance Division, Ministry of Finance
Md. Ziaur RahmanMd. Ziaur Rahman
Coordinator-Job Placement, Database & Procurement at Skills for Employment Investment Program (Finance Division, Ministry of Finance, GoB)Coordinator-Job Placement, Database & Procurement at Skills for Employment Investment Program (Finance Division, Ministry of Finance, GoB)
Armando Barragán ReyesArmando Barragán Reyes
Internal Medicine Physician at Hospital Médica SurInternal Medicine Physician at Hospital Médica Sur
Diego MirandaDiego Miranda
Category Manager at Procter & GambleCategory Manager at Procter & Gamble