Pierre-Benoît COLLET

En résumé

Entreprises

• Merck-Millipore

  Lyon maintenant

• Merck Millipore - Global Planning & Reporting Analyst

  2012 - maintenant

• Merck Millipore - Global Sales Financial Analyst, Process Solutions

  2011 - 2012 In coordination with the WW Sales controller & sales teams, creates, develops & maintains critical concepts & measures to drive sales force efficiency.
  Provides the WW Sales Controller with accurate, relevant business analysis to support monthly business reviews and ad hoc requests.

• Merck Millipore - Senior Financial Analyst - Bioscience Central Reporting Group

  2009 - 2010 Develop & implement the new organization:
  - Develop and implement the Central Reporting Group within the Bioscience business unit.
  - Centralized financial & business reports: define priority of reports to be integrated, implement the process for new requests.
  - Provide added value metrics.
  
  Provide ad hoc analysis to Business & Finance senior management (Head of Finance Bioscience, Corporate Strategy Team):
  - Integration: SEC & EU filling, Millipore Sales analysis performed following Merck requests.
  
  Participate to key projects:
  - Bioscience trade organization support:
  Optimize Service bag process in order to reduce inventory values (Green Belt project):
  Reduce service bags by FTE from $11.4k to $9.6k (-19%).
  Service bag process improvement: reduce physical inventory gaps and bad business habits.
  Communication of the new process and objectives to the service team.
  
  - Backlog (Green Belt project):
  Accelerate sales by reducing the backlog level.
  Coordinate & Improve process with order entry team, Demand group, Logistic, Field Service / Support define responsibilities by order type.
  Ensure support from senior management respective organization.
  Achievement (Acceleration of 400K$ prior to quarter end).
  
  - Automation of the North America incentives (+220 Sales & Service FTE, paid quarterly):
  Accrual (D+1) and net payment calculation (D+8).
  Automation of final performance report to each trade employees.
  Incentive dashboard.
  
  - Corporate or CMG Initiatives:
  Support Hyperion (FRP) Implementation:
  Key users & Trainer for the Bioscience finance team.
  Development of a set of basic reports for the team.
  
  - French R&D Tax Credit:
  Develop and simplify the calculation tool for Tax credit / Define & harmonize methodology for Bioprocess & Bioscience R&D organizations.

• Merck Millipore - [Financial Analyst – Bioscience]

  2006 - 2009 Controlling activities:
  - Support the Head of Demand & Planning Group for Bioscience (Hervé Cassis):
  - Perform forecasting & closing activities for the group (16 people - $1.6M).
  - Control the WW Bioscience Demo & Service Bag Inventories ($10M: EU, NA, JAPAN, CHINA…) and analyze the variances.
  
  Develop Key Financial metrics:
  - Implement and standardize key-indicator metrics: across the company: on time customer shipment (OTCS) / backorder / inventory (DIO).
  
  - Develop GPS & Innovation metrics:
  Global ops: Plant performance, Inventory level.
  Innovation: New products reports, ECV / NPV Waterfall, R&D Time tracking.
  Sales performance: Revenue Bridge, Sales channel.
  
  - Sales & Business metrics:
  WW Sales & Orders reports, Expenses reports, Key products, Top 20 customers, fixed assets…
  Develop various ad hoc analysis for the Lab Water marketing group.
  
  Projects:
  
  - Support Working Capital initiative: Inventory level analysis, Non moving items analysis.
  
  - Drive the annual mass pricing update for all Bioscience products (EU, NA and Japan):
  Harmonization of pricing within the Euro zone.
  Develop a set of analysis / business trends for the Marketing group.
  
  Direct support of the WW Bioscience Controller:
  - Develop various ad hoc analytical tools and dashboards (Reconciliation between financial tools).
  - Support the acquisition of Serologicals by updating the existing reporting and creating new reports.

• Merck Millipore - [EU Junior Financial Analyst – Lab Water]

  2003 - 2006 Lab Water business unit European controller assistant:
  - Develop and maintain monthly and quarterly sales reports.
  - Prepare and control the R&D Lab Water T&E and supplies budget.
  - Maintain the fixed-asset database.
  - Optimize and automate existing reports.

• Bouygues Telecom - Internship - 7 months

  Meudon 2002 - 2002 - 7 months internship in the Project Management / Internal Control department.

Formations

• Ecole Supérieure De Commerce Et De Management Tours-Poitiers

  Tours 1999 - 2002 IMC International Management Control

• Ecole Supérieure De Commerce Et De Management

  Tours 1999 - 2002

• Lycée La Bruyere Prépa HEC

  Versailles 1997 - 1999 Mathématique

Réseau

• Alexandre CLOAREC

• Annabelle GLÉMAS

• Axelle DE FOUCAULT

• Bruno ROSSI

• Charlène KAMDEM

• Eric BEGUEC

• Eugénie GASSMANN

• Jérôme LAISNE

• Mickaël DUBOIS