Summary
Overview
Work History
Education
Skills
Certification
Timeline

Francisco Abraham Álvarez López

Business Intelligence And Analytics
Toluca

Summary

Business Intelligence and Analytics professional with 7+ years of experience, possessing a strategic profile and 1 year of experience as a Team Lead (Marketing Business Partner). Specialist in translating complex functional requirements into analytical solutions (MVPs/POCs) and in data standardization to establish a corporate Single Source of Truth.

Overview

6
6
years of professional experience
3
3
Certifications
3
3
Languages

Work History

Analytics Reporting Executive

Coca-Cola FEMSA
05.2025 - Current
  • Leadership & Management: Direct leadership and management of a team of 2 data specialists, acting as a strategic Business Partner for the Marketing area.
  • Single Source of Truth (SSOT): Led the initiative for the standardization and harmonization of corporate data sources, ensuring data quality and accuracy for decision-making.
  • Analytical Solutions Development: Developed advanced analytical solutions on Data Lake architecture (Azure/Databricks), designed for the processing and analysis of large volumes of structured and unstructured data.

Distribution Intelligence Coordinator

Coca-Cola FEMSA
11.2023 - 05.2025
  • Modeling & Optimization: Analytical lead in the application of advanced models (linear regressions) using Python and SQL for the strategic optimization of the logistics chain.
  • Financial Impact: Successfully implemented a linear regression model that defined a new business policy, generating verified operational savings of up to 50% in logistics expenses.
  • Project Scaling (MVP/POCs): Led the 'Order Fulfillment' dashboard automation project, establishing it as a benchmark and Minimum Viable Product (MVP) for implementation in operations across other countries.

Business Data Analyst

Coca-Cola FEMSA
09.2022 - 11.2023
  • Data Integration & QA: Orchestrated the engineering team to create the comprehensive Supply Chain control dashboard for LATAM. The tool was established as the Single Source of Truth, guaranteeing data quality and documentation for 7 Regional Directors and corporate leadership.
  • Actionable Insights Generation: Responsible for creating control dashboards (Power BI/Tableau) to present clear insights and monitor KPIs.

Database Administrator

Krismar Computación
06.2021 - 09.2022

Continuous Improvement: Automated the generation of PDF catalogs, eliminating a manual task of 40 hours per semester (demonstrating efficiency and automation capabilities).

Volunteering | Interpreter and Secretary

Alpha Observatory
01.2021 - 01.2022

Interpreter (English to Spanish / Spanish to English) for an organization dedicated to studying youth mental health in different countries.

Trainee Software Developer

General Motors México
07.2019 - 02.2021

Analysis & Visualization: Used Power BI to design engineering efficiency dashboards, facilitating design reuse and resulting in a saving of 180 engineering hours per year (demonstrating the impact of BI from the ground up).

Education

Computer Engineering

Universidad Autónoma Del Estado De México, Toluca, Mexico
05.2001 -

Skills

Customer relations

Certification

Azure Fundamentals

Timeline

Analytics Reporting Executive - Coca-Cola FEMSA
05.2025 - Current
Distribution Intelligence Coordinator - Coca-Cola FEMSA
11.2023 - 05.2025

Agile SCUM Master

12-2022

Data Science Udemy

12-2022
Business Data Analyst - Coca-Cola FEMSA
09.2022 - 11.2023

Azure Fundamentals

06-2022
Database Administrator - Krismar Computación
06.2021 - 09.2022
Volunteering | Interpreter and Secretary - Alpha Observatory
01.2021 - 01.2022
Trainee Software Developer - General Motors México
07.2019 - 02.2021
Universidad Autónoma Del Estado De México - , Computer Engineering
05.2001 -
Francisco Abraham Álvarez LópezBusiness Intelligence And Analytics