You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Steven GueganSG

Steven Guegan

Demand Manager I Consultant S&OP - APS - Excel

€650/day
1 project
Clermont-Ferrand, FR
8-15 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Steven

Specialist in sales forecasting and data analysis issues, I support you in these two areas:

Demand Management:
👉 Demand and sales forecasting management
👉 Implementation of tools (APS - Advanced Planning System)
👉 Optimization of forecasts and their reliability
👉 Implementation or optimization of the S&OP process
👉 Creation of steering and performance measurement indicators
👉 Improvement of supply chain planning

Data Analysis / Dashboard Optimization:
👉 Creation of dashboards
👉 Improvement of the reporting process (automation)
👉 Implementation of a data analysis strategy
👉 Data visualization
👉 Statistical analysis
👉 Optimization of your Excel files

Do not hesitate to contact me to find the solution best suited to your needs, let's meet!

______________________________________________________________

Degrees

- Master II in management (Graduate school of management)
- Bachelor's degree in Decision-Making Statistics applied to Marketing
- DUT (University Diploma of Technology) in Statistics and Decision-Making Information
  • French

    Native or bilingual

  • English

    Fluent

Can work on-site
Clermont-Ferrand (up to 50km), Lyon (up to 50km)

Experience

  • bioMérieux
    Business Process Referent Demand & Planning
    PHARMACEUTICALS INDUSTRY
    June 2020 - June 2021 (1 year and 1 month)
    Lyon, France
    BioMérieux – Pharmaceutical industry specialized in in-vitro diagnostics (Systems, reagents, software, services)
     Support project management in impact analysis, design of deployed solutions, and validation testing organization.
     Monitoring of improvements and main operational issues on various tools (APS - OMP / SAP APO / DDMRP).
     Master Data management and optimization.
     Support and train the business in understanding processes and using tools.
    APS SAP Project Management Supply Chain S&OP
  • Limagrain
    European Demand Manager
    AGRICULTURE
    September 2018 - February 2020 (1 year and 6 months)
    Clermont-Ferrand, France
    Limagrain Europe - Business Unit of Limagrain, specialized in field seeds (Corn, Sunflower & Rapeseed)
     Implementation of the APS project: Advanced Planning System - a tool to aid demand and production planning.
     Ensure the smooth running of the S&OP (Sales & Operations Planning) cycle and its animation.
     Challenge countries on demand levels - Demand Review.
     Interface and alert role between different departments: sales, marketing, finance, and supply chain.
     Construction and optimization of demand management tools.
     Lead the update of sales forecasts for Business Areas.
    Forecasts APS Microsoft Excel Supply Chain
  • Mondelez
    Promotional Sales Forecasting Manager
    AGRICULTURE
    February 2016 - February 2018 (2 years and 1 month)
    Paris, France
    Mondelēz International - Production and sale of consumer goods (Biscuits, Chocolate & Gum)
     Direct management of a team of 4 people.
     Steering and consolidation of promotional forecasts for the Biscuit category.
     Analysis of volume variations by brand and by retailer.
     Guarantee of the IBP cycle and participation in various meetings.
     Responsible for communicating figures and analyzing discrepancies to other departments.
     Support for forecasters on sales forecasts and guarantor of the recommended methodology.
    Team Management Forecasts APS Process Leadership

Reviews

5.0

Out of 1 rating

S

Steven

OriDream Editions

Reviewed on 9/1/2023

Recommendations

Be the first to recommend Steven

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • DUT STID
    University of South Brittany
    2008
  • Bachelor's degree in Decision-Making Statistics applied to Marketing
    University of South Brittany
    2009

Certifications

  • Oliver Wight Class A for Business Excellence
    Oliver Wight
    2012
    Supply Chain S&OP Forecasts Process Business Management

Skill set (35)

Categories