Hello there!

I'm Daniel,
Data Analyst based in Mexico City.

Driving business strategy through clear, data-backed decisions. I specialize in MySQL, Python, Power BI, and A/B testing to uncover trends, optimize performance, and fuel continuous growth.

Who I Am

About Me

I am a passionate Data Analyst with a knack for identifying patterns and delivering data-driven solutions. With experience in Power BI, SQL, Python, and statistical analysis, I help businesses optimize their performance through clear and actionable dashboards.

My expertise includes clustering analysis for retail stores, designing efficiency dashboards, and conducting rigorous A/B testing. I believe that data tells a story, and my job is to make that story clear and compelling.

  • Name: Daniel
  • Role: Data Analyst
  • Email: d.perez@edanielprz.info
  • Location: Mexico City, Mexico
Download CV

Experience

Data Analyst

EFZ Energy & 3Styk | Feb 2025 - Present
  • Designed database architecture to automate commission calculations for 50+ retail sellers using SQL.
  • Conducted omnichannel sales analysis to identify profitable categories and days by geography for 40 stores using SQL and Excel.
  • Built a payment voucher capture pipeline for automated travel expense control for 60 field operators using Python ETL.
  • Performed dining expense audits resulting in a 27% reduction in operational costs via Exploratory Data Analysis in Python.
  • Coordinated migration of internal processes to a SharePoint-based Intranet for improved security and accessibility.
PythonSQLETL PipelinesEDAExcelSharePoint

Administrative Analyst

Truper | May 2021 - Jan 2025
  • Led logistical implementation of nationwide marketing campaigns, meeting monthly goals for 2+ consecutive years using Excel logistics data analysis.
  • Created productivity dashboards for bonus evaluation, increasing visibility and fairness in performance measurement using Power BI.
ExcelData AnalysisPower BILogistics

Warehouse Administrator

Truper | Sept 2018 - May 2021
  • Implemented operational metrics in marketing and electrical construction warehouses to identify improvements and optimize delivery times by 15% through KPI development.
KPI DevelopmentLogisticsProcess Optimization

Electrical Coordinator

Truper | Mar 2017 - Sept 2018
  • Coordinated technical crews across 13 field electrical projects, ensuring compliance with safety regulations and delivery timelines using project management methodologies.
Project ManagementTeam CoordinationSafety Compliance

Education

B.S. Electrical and Electronic Engineering (Partial Credits)

Universidad Nacional Autónoma de México (UNAM) | 2012 - 2016

Industrial Instrumentation Technician

CECyTEM | 2008 - 2011

Certifications

Data Analyst Certificate

TripleTen | Jun 2025 - Feb 2026

Exploratory Data Analysis (EDA), Statistical Data Analysis (Hypothesis testing, A/B Testing with SciPy), Business Metrics, and Machine Learning (Classification/Churn prediction with Scikit-learn).

Bootcamp Premium SQL

Código Facilito | Issued Feb 2026

Advanced Joins, Subqueries, CTEs, Window Functions, ETL, Query optimization, Database design.

Extract, Transform and Load Data in Power BI

Microsoft | Mar 2025

Harnessing the Power of Data with Power BI

Microsoft | Feb 2025

Data Preparation for Analysis with Microsoft Excel

Microsoft | Feb 2025

My Skills

Excel (Power Query / DAX) 95%
SQL (PostgreSQL / MSSQL / MySQL) 90%
Power BI & DAX 85%
Python (Pandas / NumPy / Scikit-learn) 80%
A/B Testing & Statistics 80%
ETL Pipelines 80%
Linux (Pop!_OS / Ubuntu) 75%
Tableau 70%
ML: Regressions, Trees & Clustering 65%

Portfolio

Sales Dashboard Power BI
View Details

Sales Dashboard Power BI

Power BI, DAX, Data Visualization

Get In Touch

Have a question or want to work together?

LinkedIn

Connect with me

Location

Mexico City, Mexico

Latest Updates

View All Posts →