Mario de la Pena
Doral,FL
Overview
14
14
years of professional experience
1
1
Certification
Work History
Operations Analyst
Del Valle Brands
Florida, USA
04.2024 - Current
- Documentation: Proficient in preparing shipping documents, customs declarations, and ensuring compliance with international trade regulations.
- Inventory Management: Skilled in maintaining accurate inventory records, tracking shipments, and resolving discrepancies.
- Problem-Solving: Proven track record of identifying issues, implementing solutions, and optimizing operational processes.
Logistics Analyst
Safety Systems Barricades Corp
Florida, USA
08.2023 - 03.2024
- Optimized manpower and vehicle usage, achieving a 25% reduction in salary expenditure while increasing operating personnel by 32% to enhance work capacity.
Associate Researcher
Complutense University of Madrid
Madrid, Spain
01.2011 - 01.2023
- Collected and analyzed Large Data Sets for the development of Econometric Models.
- Conducted research for publication of academic articles.
- Received extensive training in data manipulation, cleaning, and statistical analysis.
- Tools Used: STATA, Excel, Econometrics Model, Statistics, Mathematics.
Collaborative Planning, Forecasting, and Replenishment for Walmart (CPFR)
Hanan Distributions
Cancun, Mexico
01.2020 - 01.2022
- Monitored Hanan Distribuciones sales on Walmart, ensuring inventory availability of Luxury chocolate and optimizing sales forecast and inventory leveling.
- Provided strategic advice to Walmart Mexico's provisioner team, utilizing mathematical modeling best practices for inventory allocation, and leveling.
- Employed constrained optimization methods for import product model fitting, ensuring consistency between discount recommendations and business partner expectations.
- Tools Used: Excel, SQL, Retail Link, Access, BI tools, SAP.
Financial Planning Analyst
Grupo Anderson´s
11.2020 - 12.2020
- Company Overview: (Temp Contract)
- Utilized advanced Excel techniques for budgeting, forecasting, and financial modeling.
- Enhanced operational and financial reporting capabilities.
- Developed forecasts of Financial Statements and constructed Finance Models.
- (Temp Contract)
Business Intelligence Executive
Experiencias Xcaret Parques S.A.P.I. de C.V.
01.2019 - 01.2020
- Analyzed and interpreted Financial Statements, utilizing economic-financial KPIs.
- Managed and interpreted Data Sets to inform decision-making processes.
- Designed budgeting and forecasting tools, visualizing performance metrics for other departments.
- Tools Used: Excel, VBA, Power Pivot, Power Query.
Senior Finance Analyst
OLYMPUS TOURS (Flight Centre Australia)
Cancun, Mexico
01.2018 - 01.2019
- Developed Finance Models and Finance Projects to support strategic decision-making.
- Designed, improved, and analyzed accounting, operational, and financial reports.
- KPI reports for transportation fleet management and managed budgeting and forecasting tools.
- Tools Used: Excel, VBA, Power Pivot, Power Query.
Education
Ph.D. - Economics
Complutense of Madrid
Madrid, Spain01.2021
M.S. - Administration
University of Holguín
Holguin, Cuba01.2011
Industrial Engineer -
University of Holguín
Holguin, Cuba01.2007
Skills
- Corporate Finance
- Accounting
- Cost Accounting
- Financial Accounting
- Data Science
- Microsoft Excel (Advanced)
- Microsoft Power BI
- Python
- SQL
- DAX
Personal Information
Certification
- Applying Data Analytics in Accounting, University of Illinois at Urbana-Champaign, 01/01/23
- Python in Excel 2023 Masterclass for Data Science, Udemy, 01/01/24
- Google Advanced Data Analytics Certificate, Google, 01/01/23
- Excel Formulas & Functions, Excel Pivot Tables, Intro Financial Modeling, Power Query, Power Pivot & DAX, MySQL Data Analysis, Maven Analytics, 01/01/23
Timeline
Operations Analyst
Del Valle Brands
04.2024 - Current
Logistics Analyst
Safety Systems Barricades Corp
08.2023 - 03.2024
Financial Planning Analyst
Grupo Anderson´s
11.2020 - 12.2020
Collaborative Planning, Forecasting, and Replenishment for Walmart (CPFR)
Hanan Distributions
01.2020 - 01.2022
Business Intelligence Executive
Experiencias Xcaret Parques S.A.P.I. de C.V.
01.2019 - 01.2020
Senior Finance Analyst
OLYMPUS TOURS (Flight Centre Australia)
01.2018 - 01.2019
Associate Researcher
Complutense University of Madrid
01.2011 - 01.2023
Ph.D. - Economics
Complutense of Madrid
M.S. - Administration
University of Holguín
Industrial Engineer -
University of Holguín
Similar Profiles
Audrey HaysAudrey Hays
Special Education Teacher at Del Valle ISD- Del Valle HSSpecial Education Teacher at Del Valle ISD- Del Valle HS
Edith SeminaraEdith Seminara
CEO & Board of Directors’ Executive Assistant at Oleoductos del Valle S.A. (Del Valle Oil Pipelines S.A.)CEO & Board of Directors’ Executive Assistant at Oleoductos del Valle S.A. (Del Valle Oil Pipelines S.A.)
Elizabeth Vargas HolguinElizabeth Vargas Holguin
TEFL Teacher at Peace Corps TEFL Volunteer Teaching at Universidad Tecnológica Del Valle Del Mezquital in Ixmiquilpan-Hidalgo, MexicoTEFL Teacher at Peace Corps TEFL Volunteer Teaching at Universidad Tecnológica Del Valle Del Mezquital in Ixmiquilpan-Hidalgo, Mexico
Jose GonzalezJose Gonzalez
Convention Participant at Future Farmers of America, FFAConvention Participant at Future Farmers of America, FFA
Kris ZabianKris Zabian
Licensed Massage Therapist at Spinex CentersLicensed Massage Therapist at Spinex Centers