Diana Rios
*****.****@*******.** 1-903-***-****
EDUCATION
Marketing Analytics
Wharton School – University of Pennsylvania Sep 2022 – Nov 2022
Diploma of Stock Market & International Finance
Universidad Autónoma del Caribe, Colombia Jan 2012 – Jun 2012
Bachelor of B.A. International Business & Finance
Honorable Mention for "Excellent Academic Performance" Universidad Autónoma del Caribe, Colombia Jul 2007 – Jun 2012
SKILLS
Computer programming Diploma:
Proficient in Microsoft Office: Excel,
PowerPoint, Publisher, Access, Word,
SQL, and Visual Basic.Net
Planning and organization
Good understanding of financial data
Excellent interpersonal skills
Client Relationship Management
Organizational Leadership
Goal Driven
High energy and Proactive
Spanish, English, and Portuguese
WORK EXPERIENCE
Tax Professional EEUU, H&R Block Sep 2024 – Present
• Prepare and submit federal, state, and local tax returns for individuals and businesses according to IRS regulations.
• Providing strategic tax planning to help clients minimize their tax liabilities.
Regional Finance Controller Latin America, Hilti Sep 2021 – Sep 2023
• Lead Regional HUB Opex, collaborating with functional heads of areas such as Marketing, Customer Service, Finance, Human Resources, and Sales — including P&L oversight for the Energy & Industry (E&I) segment, with a specific focus on Onshore/Offshore Oil & Gas clients across Latin America.
• Analyze financial impact on P&L regarding exchange rates, increase in COGS, margin deviation, and other relevant information across Latin America with a large volume of data.
Finance Controller Andean Region, and America Central, Hilti Sep 2019 – Sep 2021
• Lead MOPE (Market Organization Peru) and MOCO (Market Organization Colombia) NMS Project SAP ByD E&I and ResCom (New Management Statement for Energy & Industry and Residencia and Commercial segments) P&L, collaborating with different functions such as Global Process Expert team, Global IT team, Regional Finance, Marketing and Sales team.
• Establish clear, consistent reporting processes and reporting landscape for Partners and Peru, and be the champion for the tools. Ensure timely and accurate monthly deployment.
• Shape & execute full performance management cycle including orchestration of all relevant stakeholders (Leadership team, Logistics Manager and Controller, Marketing, HR, Regional Finance Process Experts, and Project Managers – ORO).
• Communicate and present effectively to cross-functional team members the accuracy through RFs and full P&L steering.
• Identify opportunities in MOPE and Partners with financial impact across the organization and propose options focused on business trends, with a large volume of data.
Sr. Finance Analyst FP&A Latin America, Estee Lauder Nov 2018 – Feb 2019
• Lead LATAM forecast submissions to Corporate.
• Develop a robot that standardizes forecast updates, representing a significant reduction in time from 2 weeks to 3 hours.
• Build all the processes of LATAM Regions, creating SOP (Standard Operating Processes) and calendarization of its reports.
Sr. Finance Analyst Capital Planning USA, Estee Lauder Jul 2018 – Oct 2018
• Lead the Capital annual Depreciation budget for USA stores. By monthly forecast updates and submissions to Corporate.
• Management for Disposition of Fixed Asset (DFA) based on Company guidance.
• Global outline of administrative tasks that ensure data accuracy in BPC (Business Planning Consolidation System) and allow for the review of estimate submissions.
Financial Analyst Latin America, Ralph Lauren Oct 2016 – Jun 2018
• Co-Lead end-to-end process for the Financial annual budget, by-monthly P/L forecast update, and submissions to Corporate.
• Prepare full P/L reconciliation on a monthly basis, highlighting key drivers for actual results vs. forecast.
• Report and monitor key business metrics by Brand, Category, Country, and Customer, among others.
• Analyze Capital Management projects for new openings, remodeling, closing stores, and possible cannibalizations.
• Potential of IMU (Initial Mark-Up) Sensors in Performance Analysis of our customers around the region.
Demand Planning & Inventory Reporting and Analyst Latin America, adidas Group Jul 2015 – Jul 2016
• Developed the (FBP) Full Business Potential Tracking Tool that helps the various marketing departments perform forecast and market condition analysis, (the file contains relevant information such as net sales, order book, buying volume, and free stock per season, country, business segment and brand (adidas & Reebok)).
• Was the liaison for other areas such as (FP&A) Finance Planning & Analysis, Sales, Supply Chain/Operations, Marketing, and Demand Planning, on LAM (Latin America) level, supporting the IBP (Integrated Business Planning) alignment process.
• Managed regional inventory information, (IDL) Inventory days lasting, reviewing forecast accuracy, reducing 30% of the slow movers inventory in LAM.
• Aligned with FP&A, the FBP (Product Plan) forecast to create an integrated financial view of Demand Planning and Finance, reducing the mismatched information between these areas.
• Planned IBP monthly submission process by maintaining the market reporting tool, ensuring a fluent data information flow.
E-Commerce and Franchise Reporting Specialist Latin America, adidas Group Jan 2015 – Jul 2015
• Defined and implemented the Profit and Loss structure for e-Commerce and Franchise channels in LAM that did not exist.
• Created and implemented the reporting package for e-Commerce and Franchise Operational Business for LAM, that are still strategically used today for the abovementioned channels.
• Established the month-end closing for the Retail, Franchise, and e-Commerce channels with an accuracy of 80%.
FP&A Specialist Latin America, adidas Group Mar 2014 – Dec 2014
• Ensured Risk & Opportunity report of LAM through Business Intelligence tools.
• Consolidated monthly analysis and review of the top 10 Key Accounts of the LAM region in order to support the Wholesale channel, with 80% of the information used to make investment decisions.
Sales Finance Analyst USA, Dell LLC Jul 2013 – Jan 2014
• Cleaned 60% in open POs, which affected the P&L of the United States at the end of the quarter.
• Developed a Revenue analysis implemented in all Commercial organizations about how Revenues can affect commissions, helping to make a forecast with 40% less error.
EXTRA CURRICULAR ACTIVITIES
• Participated in the International program AIESEC for young leaders in Panama. SKILLS
Analytical: Over 8 years of experience in Finance. Languages: Fluent in Spanish and English. Conversational in Portuguese. Software: Diploma in Computer Programming and more than two years of experience in SQL, Visual Basic.Net, Forex, @Risk, Microsoft Office: Excel, PowerPoint, Word, Publisher, SAP S/4Hana, and SAP ByD