PhD. Mario de la Pena

Data Analyst

Miramar, Florida 786-***-**** adxgev@r.postjobfree.com SKILLS

- Data Visualization using Microsoft Excel, Microsoft Power BI and Tableau

- Python (NumPy, Pandas, Matplotlib, Seaborn), DAX and VBA

- Managing large Data Sets in relational database using SQL Querying & Database Management

- Data Mining for development of Econometric Models using Stata. EXPERIENCE

Hanan Distribuciones, Cancun, Mexico Jun 2021-Dec 2022 Data Analyst (CPFR) Collaborative Planning, Forecasting, and Replenishment for Walmart I worked as a member of the systems team where I monitored data generated at Walmart, Chedraui, HEB Business, Soriana, and others as well as internally generated data, building data intelligence tools. Working as a CPFR monitoring Hanan Distribuciones sales on Walmart, inventory availability of Luxury chocolate as well as sales forecast and inventory leveling.

- Working as a CPFR monitoring Hanan Distribuciones sales on Walmart, inventory availability of Luxury chocolate as well as sales forecast and inventory leveling.

- Advised to Walmart Mexico provisioner team where allocate and leveling inventory based in mathematic modeling best practices.

- Used constrained optimization methods for import product model fitting to ensure that discount recommendations from the pricing tool were consistent with the business partner’s expectations.

- Used optimization models for the importation of products to increase profitability. Used: Excel, SQL, Retail Link, Access, BI tools, SAP OLYMPUS TOURS (Flight Centre Australia), Cancun, Mexico Sep 2018 – Sep 2019 Senior Finance Analyst

I worked as a member of the controller team in charge of forecasting, internal auditing, feasibility studies as well as the implementation of new tools to drive efficiency and reduce costs within the transportation fleet. Our team routinely performed data analysis at the request of the CEO or CFO.

- Designed, improvement and analysis of accounting, operational and financial information reports.

- Designed reports (KPI) for transportation fleet management.

- Design of tools for budgeting, forecasting, visualizing the performance of other areas. Used: Excel, VBA, Stata, Power Query

Complutense University of Madrid, Madrid, Spain Mar 2011 – May 2023 Associate Researcher

I worked as a research associate with the GRIPICO research group of the Applied Economics department of this university, helping to create and clean large databases, as well as receiving training in Econometrics and software for data science Stata. Two of my thesis chapters were published in top quartile scientific journals worldwide.

• Construction and management of databases, test and development of Econometric Models.

• Conduct research for publication of articles.

• Training in data manipulation, data cleaning, scientific analysis, statistical and econometrics. Used: STATA, Excel, Econometrics Model.

EDUCATION

Complutense of Madrid- Applied Economics Department, Madrid, Spain (2021) Ph.D. Economics

University of Holguín- Complutense of Madrid- Applied Economics Department, Cuba & Spain (2011) M.S. Administration

University of Holguín, Holguin, Cuba (2007)

Industrial Engineer

PUBLICATIONS

• De la Peña, Mario Raúl; Núñez-Serrano, J.A.; Turrión, J. y Velázquez, F.J. (2016): “Are Innovations relevant for consumers in the hospitality industry? A hedonic approach for Cuban hotels”, Tourism Management 55 (2016) 184-196

• De la Peña, Mario Raúl; Núñez-Serrano, Juan.A. Turrión Jaime, and Velázquez, Francisco J. (2017): “A new Tool for the Analysis of the International Competitiveness of Tourist Destinations Based on Performance”, Journal of Travel Research. DOI: 10.1177/0047287517746012.