Diana Gaspar Email & Phone Number

• Overseeing processes for trade deductions, validation, compliance and contract management • Support and review negotiations of customer contracts; create contract library• Govern and lead deductions accuracy, off-invoice, reporting, aging deductions, compliance claims• Develop post audit process and trade deductions ways of working• Expand reporting such as aging deductions, OTIF disputes, deductions vs. trade forecast

• Led a Price Pack Architecture project assessing pricing for North American portfolio: competitive landscape, absolute price points, price per weight, slopes – resulting in new innovation pack sizes• Worked on item level P&Ls to assess profitability for brand, marketing and sales teams

North York

• Led the implementation of an internally built sales business intelligence tool o Liaised with 20+ internal cross-functional stakeholders (finance, IT, sales, commercial teams, marketing, supply chain, R&D) and external vendorso Data wrangling over 30 data sources (point of sale, distributor, ERP SAP, master data), data harmonization of master data, ETL in Alteryx with complex business ruleso Reporting in Tableau which delivered visibility for the first time into live reporting of POS data, distributor data, plan/forecast/actualso Enabled sales and commercial teams to be proactive in key account management, closing the gap to plan monthly instead of quarterly• Govern, lead and train team members around business tools, business processes, business plans, financial planning & reporting, customer markets, customer segments, financial modelling• Support the annual sales planning process, including creating and refining of standardized planning templates; partnering with account managers to support measurement and financial analysis• Enable company to course-correct in time by developing the sales forecast process, including tracking and monitoring of budget, actuals, forecast (latest estimate), month to go, year to go• Prepare analysis on profitability, sales patterns, seasonality, external factors – for innovation new launches, current items, brand, customer, and market development initiatives• Mentor and coached 2 direct reports: onboarding, training, professional development, 1:1s

Vaughan, Ontario, Canada

• Supported 6 sales areas of the business: Canada, US, international, e-commerce, private label, pet and collaboration with other departments: Trade Marketing, Marketing, Category, R&D • Lead a Business Intelligence data project (Tableau & Alteryx)• Lead, coached and mentored the sales finance team• Supported the annual sales budgeting process through the creation of a sales budget model Excel template that includes a Customer P&L in collaboration with internal SME’s• Created and developed tools such as pricing and margin analysis model and payback model for listing fees• Assessed and estimated the profitability of different pricing scenarios:o Current skus (new listings to current customers)o Current skus to new customerso New skus to current customerso Promotions profitability and impact on contribution margino Payback analyses (payback period for listing fees) • Provided strategic insights related to current and future customer opportunities • Oversaw the implementation of sales reporting automation through SAP Analytics Cloud tool with external vendor partner.o Resulted in visibility to the business to view invoice data live (Gross Revenue, COGS, Case Quantities – By Brand, by Channel, by Sold To Party, by Ship To etc). o Automated manual Customer P&Ls in SAP Analytics Cloud, resulting in being able to view Customer P&Ls and the profitability for direct customers in real time.o Trained the sales, marketing and finance teams on the SAP SAC reports: how to navigate Stories, Pages, Filters, Exporting, Designer, etc. and created instruction manual. • Familiarity with POS retailer portals: Walmart RetailLink, Sobeys IRI, Save-On-Foods IRI, LDIA (Loblaw, Shoppers), FCL One Screen (Federated Co-operatives Limited), Calgary Co-op, Whole Foods Portal, Target VendorIQ• Familiarity with navigating SAP S4Hana• Good understanding of different areas within a CPG company: innovation, manufacturing, supply chain, finance, IT, trade, marketing, inside sales.

• Oversaw implementation of SAP Analytics Cloud BI tool to automate Gross Revenue sales reports and Customer P&Ls, accessible live, previously manually created in Excel.• Prepared monthly/quarterly/annual P&L’s for key accounts; provided recommendations and action plans to improve profit margins• Created templates for sales revenue budget for US and Canada sales teams• Partnered with Account Managers (KAM) to plan, monitor and enhance performance measurement of the Key Account Planning process (KAP)• Liaised with the sales and marketing teams to identify opportunities to optimize the marketing and trade budgets for each key account• Created and developed tools such as pricing modeling, break-even point estimations and marketing ROI measurement for new and existing customers• Supported FP&A in tracking the international markets performance by comparing actual sales and marketing spend versus the business case• Assisted Corporate Strategic Planning in identifying market trends to forecast E-comm sales and to model multi-variable scenarios• Developed, tracked, reported business metrics and KPI’s for the company’s key customers• Provided analysis and interpretation of business results and metrics to aid corporate decision making• Assess and estimate the profitability of new product launches and market development initiatives• Financially assess performance of customer promotions and retailer programs and suggests sales and promotional activities to further penetrate distribution channels and existing markets

Toronto, Canada Area

• Performed comparative analysis of pricing proposals, quotations, target pricing• Assessed and improved sourcing activities by analyzing spend, researching commodity prices, building costing models, adopting procurement best practices and preparing redundancies for critical SKUs• Worked cross-functionally (Eg. with product development) to source new items for menu innovation (Eg. vet new supply chain and logistics for new vendors, coordinate product samples, analyze into-unit landed cost, forecasting)• Conducted timely negotiation of contract renewals in food and non-food product categories• Maintained information for contract list and records management related to contracts

Toronto, Canada Area

• Inventory Management: Reviewed out of stock situations or shortage of supply issues and recommended to take mitigating actions by working closely with the vendors, partners and distributors to avoid re-occurrences• New Store Openings: Managed and executed new store opening process to set with domestic and international partners• Supply Chain point person for US market partners – managed truck issues, communicated supply shorts, order issues and day to day communication• Provided recommendations for the development and implementation of supply chain network changes and processes, which can enhance efficiencies and service for franchise partners

Mississauga

• Managed monthly report automation in collaboration with IT and end users• Assisted in developing a landed cost and margin pricing module for food products (consumer goods) in Microsoft Dynamics NAV ERP: gathered user requirements, created templates, outlined logic and data sources, worked with IT to build, test, implement• Costed new skus (product cost, pallet tie-high, freight, etc) and work closely with Purchasing Team• Conducted adhoc analysis for sales, marketing, pricing and business intelligence• Managed and analyzed price changes for over 4500 skus in Microsoft Dynamics Nav ERP and Whole Foods VIP system within strict catalogue deadlines; negotiated price change notice timelines and price protection with vendors• Updated content in InDesign and Photoshop flyers and send email campaigns via Constant Contact• Coordinated print publication of the catalogue, prepare print ready files and liaise with printer• Trained interns and co-workers in various data analysis tasks and Excel competencies

Mississauga

• Prepared weekly, monthly, quarterly and year-end reports for forecasts, budgets, actuals• Improved inefficiencies by re-engineering reports in Excel, developed methods of measuring Key Performance Indicators (KPI)• Analyzed actuals and KPIs (such as on-time delivery, truck issues, freight per skid costs, lead times), provided insights and overview to management• Prepared key metrics for outbound logistics for the Go Green Committee (sustainability committee)

Executive Management Certificate

2024 June - received Certification 2024 April - Strategic Decision Making https://execed.degroote.mcmaster.ca/courses/strategic-decision-ma.

Tableau Desktop 1 Fundamentals, Data

Bachelor Of Commerce - Bcom, Business/Commerce, General, Honours

Activities and Societies: HSF Board of Directors, Humber Leadership Institute, Toastmasters, Orientation Team, Guelph-Humber DECA U, Peer.

Cind 123 Data Analytics: Basic Methods, Statistics, R

Intro to R Studio This course is an introduction to R, analyzing and exploring data with R, and using R with a database. It focuses.

Introduction To Analytics And Big Data Course, Big Data

Activities and Societies: big data business intelligence analytics unstructured and structured data

Vegetarian Culinary Arts Program, Culinary Arts/Chef Training

https://coned.georgebrown.ca/courses-and-programs/vegetarian-culinary-arts-program