Fernando Guerra, CSCP

Demand & Supply Planner at Castrol - Wakefield Canada Inc
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Toronto, Ontario, Canada, CA
Languages
  • Inglés -
  • Francés -
  • Español -

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

5.0

/5.0
/ Based on 2 ratings
  • (2)
  • (0)
  • (0)
  • (0)
  • (0)

Filter reviews by:

Luis Gerardo Garcia

I met Fernando at Toshiba were he used to be Business Planning manager for PC division, He is an accomplished executive, committed to quality an goal oriented, he performed great analysis and smart forecast keeping us updated with sales performance trend and market data helping us to take smarter decisions.

Carlos Alberto Barragan Escondrillas

I had the opportunity to work with Fernando for PSI (Business Analysis) department, and he alway showed his self as a professional and leader on their business giving to the company a lot of visibility according to sales and inventory to take actions in time for forecast, promotions, marketing, etc. Being part of one of the most successful teams than the company ever before had .

You need to have a working account to view this content.
You need to have a working account to view this content.

Credentials

  • Certified Supply Chain Professional (CSCP)
    APICS
    May, 2021
    - Nov, 2024
  • Demand Planning, Forecasting and S&OP Certification
    Institute of Business Forecasting & Planning
    Feb, 2017
    - Nov, 2024
  • TEFAQ Niveau 3 (B1-CECR)
    CCI Paris IdF
    Jul, 2012
    - Nov, 2024
  • Certification English FCE - Grade B2 of Council of Europe Level
    University of Cambridge
    May, 2012
    - Nov, 2024

Experience

    • Canada
    • Automotive
    • 100 - 200 Employee
    • Demand & Supply Planner
      • Jan 2019 - Jan 2020

    • Canada
    • Food and Beverage Manufacturing
    • 700 & Above Employee
    • Senior Demand Planner
      • Sep 2016 - Jan 2019

      Responsible for production planning and forecasting in Ontario for packaged fresh bread and bakery products. • Develop demand forecasts at multiple levels of aggregation based on historical data, promotional activities, and seasonality, generate production plan on a weekly, monthly and yearly basis. • New product baseline forecasting preparing, execution and monitoring. • Lead monthly S&OP consensus meetings with Sales and Finance to track monthly volume forecasts and drive alignment… Show more Responsible for production planning and forecasting in Ontario for packaged fresh bread and bakery products. • Develop demand forecasts at multiple levels of aggregation based on historical data, promotional activities, and seasonality, generate production plan on a weekly, monthly and yearly basis. • New product baseline forecasting preparing, execution and monitoring. • Lead monthly S&OP consensus meetings with Sales and Finance to track monthly volume forecasts and drive alignment to budget and growth objectives. • Data analysis and maintenance of ERP forecasting tools, monitor trends and troubleshoot forecast errors. • Ensure orders fulfillment, avoiding back orders, shorts and service disruptions focusing on supply chain efficiencies and cost reduction. • Planning of high seasonal items, in-out product strategy, prepare daily sales forecast on high demand periods. Show less Responsible for production planning and forecasting in Ontario for packaged fresh bread and bakery products. • Develop demand forecasts at multiple levels of aggregation based on historical data, promotional activities, and seasonality, generate production plan on a weekly, monthly and yearly basis. • New product baseline forecasting preparing, execution and monitoring. • Lead monthly S&OP consensus meetings with Sales and Finance to track monthly volume forecasts and drive alignment… Show more Responsible for production planning and forecasting in Ontario for packaged fresh bread and bakery products. • Develop demand forecasts at multiple levels of aggregation based on historical data, promotional activities, and seasonality, generate production plan on a weekly, monthly and yearly basis. • New product baseline forecasting preparing, execution and monitoring. • Lead monthly S&OP consensus meetings with Sales and Finance to track monthly volume forecasts and drive alignment to budget and growth objectives. • Data analysis and maintenance of ERP forecasting tools, monitor trends and troubleshoot forecast errors. • Ensure orders fulfillment, avoiding back orders, shorts and service disruptions focusing on supply chain efficiencies and cost reduction. • Planning of high seasonal items, in-out product strategy, prepare daily sales forecast on high demand periods. Show less

    • United Kingdom
    • Manufacturing
    • 700 & Above Employee
    • CPFR Specialist - Customer Demand (Personal Care)
      • Apr 2015 - Sep 2016

      Responsible for forecasting, CPFR Analysis and Purchase Sales Inventory (PSI) Analysis for Wal-Mart Canada on Unilever Foods & Personal care portfolio. • Promotional Forecasting - Store level forecasting on open cases and presentation display vehicles. - Lead forecast consensus process with customer and sales, elaboration of demand plans, safety stock analysis and product allocation. • Reporting - KPI Monitoring and Analysis (Sales, aging, forecast accuracy, inventory… Show more Responsible for forecasting, CPFR Analysis and Purchase Sales Inventory (PSI) Analysis for Wal-Mart Canada on Unilever Foods & Personal care portfolio. • Promotional Forecasting - Store level forecasting on open cases and presentation display vehicles. - Lead forecast consensus process with customer and sales, elaboration of demand plans, safety stock analysis and product allocation. • Reporting - KPI Monitoring and Analysis (Sales, aging, forecast accuracy, inventory management, and weeks of supply) provide recommendations & troubleshoot service interruptions. • Inventory/Replenishment - Shipment tracking and leading PO shipments ensuring Customer Case Fill on Time and support On Shelf Availability at store level . - Weekly and daily Supply Chain Management reporting in support of leadership and internal stakeholders. - Lead supply chain initiatives to reduce lead times, logistic costs and network optimization.

    • CPFR / Customer Demand Planning (Foods)
      • Mar 2014 - Mar 2015

      • Data mining of customer databases (Retail Link) for tracking and implementation of CPFR activities on the order management fulfillment, customer DC inventory management and store replenishment. • Collaboration/Planning - Works closely with the internal teams (LOT, DOT, Planning, Warehousing) to optimize case fill and W&T efficiencies of customer orders - Working with Promo Planners/Demand Planners /CLA/CDP/KAM - Participates in meeting with Planning daily - Promo PO summary for… Show more • Data mining of customer databases (Retail Link) for tracking and implementation of CPFR activities on the order management fulfillment, customer DC inventory management and store replenishment. • Collaboration/Planning - Works closely with the internal teams (LOT, DOT, Planning, Warehousing) to optimize case fill and W&T efficiencies of customer orders - Working with Promo Planners/Demand Planners /CLA/CDP/KAM - Participates in meeting with Planning daily - Promo PO summary for KAMs highlighting variances from Script • Order Management - Responsible for the validation & execution of incoming customer orders. - Primary contact point for the customer buying teams, with daily interactions to manage the day-to-day business (ensuring orders are credit released on time). - Optimize Dispatch Rate where possible - Processing Cut report - Processing manual DSD orders • On-Time Improvement - Investigate and recode FAAs - Participate in Canada Weekly Carrier Reviews • Analyze customer scorecard metrics for gaps vs. Unilever KPI’s of similar metrics. Recommend action steps to mitigate ongoing issues or substandard results. • Continuous measurement and improvement of KPI related to service on-shelf availability, forecast accuracy, logistical efficiency. • Participate as a core member on the Customer Care Team.

    • Canada
    • Manufacturing
    • 1 - 100 Employee
    • Procurement & Replenishment Analyst
      • Sep 2013 - Jan 2014

      • Coordinated procurement and replenishment of products, analyzing sales trends and variations to minimize shortages of products and maintained an appropriate level of inventory based on weeks of supply. • Supported S&OP process and generated reports to manage sales and inventories of retail customers in Canada and USA. • Defined purchase strategies based on market requirements and product costs. • Managed customer orders and product allocation process based on strategy and product… Show more • Coordinated procurement and replenishment of products, analyzing sales trends and variations to minimize shortages of products and maintained an appropriate level of inventory based on weeks of supply. • Supported S&OP process and generated reports to manage sales and inventories of retail customers in Canada and USA. • Defined purchase strategies based on market requirements and product costs. • Managed customer orders and product allocation process based on strategy and product availability. • Supervised and implemented purchasing process of national and international suppliers through the set up and management of replenishment tools. Show less • Coordinated procurement and replenishment of products, analyzing sales trends and variations to minimize shortages of products and maintained an appropriate level of inventory based on weeks of supply. • Supported S&OP process and generated reports to manage sales and inventories of retail customers in Canada and USA. • Defined purchase strategies based on market requirements and product costs. • Managed customer orders and product allocation process based on strategy and product… Show more • Coordinated procurement and replenishment of products, analyzing sales trends and variations to minimize shortages of products and maintained an appropriate level of inventory based on weeks of supply. • Supported S&OP process and generated reports to manage sales and inventories of retail customers in Canada and USA. • Defined purchase strategies based on market requirements and product costs. • Managed customer orders and product allocation process based on strategy and product availability. • Supervised and implemented purchasing process of national and international suppliers through the set up and management of replenishment tools. Show less

    • South Korea
    • Computers and Electronics Manufacturing
    • 700 & Above Employee
    • Demand Planning Coordinator
      • May 2011 - Jan 2013

      • Develop demand forecasts for TVs, digital cameras and audio systems categories, develop baseline forecasting during product launches and product life management forecasting, maintain healthy inventory levels and avoid end of life aging. • Analyzes sell-in and sell-out forecasting trends and aligns future demand to meet the trends and current market conditions. • Review forecasting, sales capability, Inventory KPI’s for alignment and meeting business requirement. • Analyze market… Show more • Develop demand forecasts for TVs, digital cameras and audio systems categories, develop baseline forecasting during product launches and product life management forecasting, maintain healthy inventory levels and avoid end of life aging. • Analyzes sell-in and sell-out forecasting trends and aligns future demand to meet the trends and current market conditions. • Review forecasting, sales capability, Inventory KPI’s for alignment and meeting business requirement. • Analyze market share and in-store share and identify competitive issues. Show less • Develop demand forecasts for TVs, digital cameras and audio systems categories, develop baseline forecasting during product launches and product life management forecasting, maintain healthy inventory levels and avoid end of life aging. • Analyzes sell-in and sell-out forecasting trends and aligns future demand to meet the trends and current market conditions. • Review forecasting, sales capability, Inventory KPI’s for alignment and meeting business requirement. • Analyze market… Show more • Develop demand forecasts for TVs, digital cameras and audio systems categories, develop baseline forecasting during product launches and product life management forecasting, maintain healthy inventory levels and avoid end of life aging. • Analyzes sell-in and sell-out forecasting trends and aligns future demand to meet the trends and current market conditions. • Review forecasting, sales capability, Inventory KPI’s for alignment and meeting business requirement. • Analyze market share and in-store share and identify competitive issues. Show less

    • Japan
    • Appliances, Electrical, and Electronics Manufacturing
    • 700 & Above Employee
    • Demand Planning Manager
      • May 2005 - Mar 2011

      • Supervised the demand planning of sales and inventories for laptops and computer products division improving the correct forecasting of SKU’s achieved and maintained forecast accuracy over 80%. • Price analysis and cost structure management, defined strategies for profitability improving on computers and accessories. Business trend analysis and tracking vs. production plans and budget. • Elaboration of production forecast based on customer allocation and market trends, achieving product… Show more • Supervised the demand planning of sales and inventories for laptops and computer products division improving the correct forecasting of SKU’s achieved and maintained forecast accuracy over 80%. • Price analysis and cost structure management, defined strategies for profitability improving on computers and accessories. Business trend analysis and tracking vs. production plans and budget. • Elaboration of production forecast based on customer allocation and market trends, achieving product life cycle below 15 weeks. • Implemented databases for compiling and analyzing internal and customer information (product, sales, inventories), resulting the elaboration of automated reports for weekly reviews to top management. Show less • Supervised the demand planning of sales and inventories for laptops and computer products division improving the correct forecasting of SKU’s achieved and maintained forecast accuracy over 80%. • Price analysis and cost structure management, defined strategies for profitability improving on computers and accessories. Business trend analysis and tracking vs. production plans and budget. • Elaboration of production forecast based on customer allocation and market trends, achieving product… Show more • Supervised the demand planning of sales and inventories for laptops and computer products division improving the correct forecasting of SKU’s achieved and maintained forecast accuracy over 80%. • Price analysis and cost structure management, defined strategies for profitability improving on computers and accessories. Business trend analysis and tracking vs. production plans and budget. • Elaboration of production forecast based on customer allocation and market trends, achieving product life cycle below 15 weeks. • Implemented databases for compiling and analyzing internal and customer information (product, sales, inventories), resulting the elaboration of automated reports for weekly reviews to top management. Show less

    • United Kingdom
    • Financial Services
    • 700 & Above Employee
    • Financial Information Analyst
      • Jul 2003 - May 2005

      • Developed and implemented a cost management system for corporate offices and branches to determine its profitability. • Compiled and designed an employee information database of bank employees , implemented in corporate Intranet to improve interaction between departments. • Elaborated profitability forecasts and budgets of corporate offices and branches and deployed to the properties department the classification of branches based in expenses versus profit. • Inspected and analyzed… Show more • Developed and implemented a cost management system for corporate offices and branches to determine its profitability. • Compiled and designed an employee information database of bank employees , implemented in corporate Intranet to improve interaction between departments. • Elaborated profitability forecasts and budgets of corporate offices and branches and deployed to the properties department the classification of branches based in expenses versus profit. • Inspected and analyzed monthly budget results, reported deviations from month to month and year to year and forecasted deviations for fiscal year for all properties. • Collaborated with finance and accounting departments to improve the accuracy of reports of revenues, costs and expense reports, reducing by 50% the time for presenting results to headquarters . Show less • Developed and implemented a cost management system for corporate offices and branches to determine its profitability. • Compiled and designed an employee information database of bank employees , implemented in corporate Intranet to improve interaction between departments. • Elaborated profitability forecasts and budgets of corporate offices and branches and deployed to the properties department the classification of branches based in expenses versus profit. • Inspected and analyzed… Show more • Developed and implemented a cost management system for corporate offices and branches to determine its profitability. • Compiled and designed an employee information database of bank employees , implemented in corporate Intranet to improve interaction between departments. • Elaborated profitability forecasts and budgets of corporate offices and branches and deployed to the properties department the classification of branches based in expenses versus profit. • Inspected and analyzed monthly budget results, reported deviations from month to month and year to year and forecasted deviations for fiscal year for all properties. • Collaborated with finance and accounting departments to improve the accuracy of reports of revenues, costs and expense reports, reducing by 50% the time for presenting results to headquarters . Show less

    • United States
    • IT Services and IT Consulting
    • 700 & Above Employee
    • Marketing and Training Analyst
      • Jan 2002 - Jul 2003

      • Coordinated logistics of technical trainings and marketing campaigns related to different software solutions focusing on Novell's partners, identify potential distributors and maintain a continuous training, certification & solution update for category improvement. • Developed and reporting of results related to license renewal to top management. • Coordinated follow-up of result of trainings and marketing promotions focused to end-users. • Implemented setup logistics of classrooms… Show more • Coordinated logistics of technical trainings and marketing campaigns related to different software solutions focusing on Novell's partners, identify potential distributors and maintain a continuous training, certification & solution update for category improvement. • Developed and reporting of results related to license renewal to top management. • Coordinated follow-up of result of trainings and marketing promotions focused to end-users. • Implemented setup logistics of classrooms for technical trainings, administrative functions (inscriptions, invitation of partners/users, assistance follow-up, coordinate trainers and preparation of manuals and learning materials. Show less • Coordinated logistics of technical trainings and marketing campaigns related to different software solutions focusing on Novell's partners, identify potential distributors and maintain a continuous training, certification & solution update for category improvement. • Developed and reporting of results related to license renewal to top management. • Coordinated follow-up of result of trainings and marketing promotions focused to end-users. • Implemented setup logistics of classrooms… Show more • Coordinated logistics of technical trainings and marketing campaigns related to different software solutions focusing on Novell's partners, identify potential distributors and maintain a continuous training, certification & solution update for category improvement. • Developed and reporting of results related to license renewal to top management. • Coordinated follow-up of result of trainings and marketing promotions focused to end-users. • Implemented setup logistics of classrooms for technical trainings, administrative functions (inscriptions, invitation of partners/users, assistance follow-up, coordinate trainers and preparation of manuals and learning materials. Show less

Education

  • Universidad del Valle de México
    Bachelor's degree, Computer Information Systems (BSc)
    1998 - 2005

Community

You need to have a working account to view this content. Click here to join now