Cyril Toussaint
email :
[email protected]
Business Analysis / Controlling / BI Consultant
EXECUTIVE SUMMARY Amazon.com
Business Analyst Responsible for daily, weekly, monthly, quarterly reportings Establishing Variable costs per units reportings & variance analysis Optimization of Excel file & workflow management for finance reportings Finance leader on operational management tools Responsible for HR costs optimization & reportings to the group
Danone Water
Business Analyst consultant (Solution BI) Functional Administrator for all Essbase applications Finance Transformation Calculation Improvements Business Domains : Finance (P&L, budget & forecast) Production (cost estimates, cost analysis) Accounting (Purchase order, invoices analysis) Logistics (Purchasing, Carrier & transportation mgmt) Business Solutions : Hyperion Oracle Essbase V.7 / V.11 (Reporting) SAP FI-CO (Analysis) Excel w. VBA (Reporting / Analysis / Management)
Millicom
EPM consultant (Methys) Functional Administrator on Essbase Security Management Business Domains: Finance (Budget & Forecasting) Business Solutions : Essbase V9 Excel w. VBA
June 2010 June 2011
Kronenbourg Breweries
Business Analysis & Sales Support 1-year internship Business Domains : Marketing (Price, Promotions, Placements) Sales Management Business Solutions : IBM Cognos & Report Net Excel w. VBA
June 2008 June 2009
1
Oct. 2013 May 2014
July 2011 Oct. 2013
Business Analysis / Controlling / BI consultant Cyril TOUSSAINT
WORK EXPERIENCE Amazon.com
Business Analyst for one major operational site in France & South Europe Department
Oct. 2013 Until now
Main projects - ALPS (Amazon Labor Planning Solution) o Analyze volumes by Fulfilment centers and split by activities provided by Sales & Operational Plans team o Plan headcounts and Units per hour applied to these volumes, along with experience curve & onboarding effects o Forecast attrition & attendance for the workforce o Simulate productivity and daily backlogs of volumes per services in the operational workflow on a 3 weeks period and 3 month period o Documenting the workflow and processes on web tools and Excel files Reporting - Establishing daily reporting on the Fulfillment center activities - Responsible for Variable costs per units analysis and reporting - Responsible for establishing the quarterly bonuses for 500+ employees on site in accordance with the labor council guidance - Participating on the month end activities with the accounting team, responsible for accruals information for the fulfillment center Forecast & budgeting activities
-
-
Establishing operational plans in regards to the HQ guidelines o Responsible for the variable and fixed costs ( janitorial, utilities, security expenses, property tax & building rent, equipment rentals, maintenance supplies, telecom charges, depreciations) o Responsible for employee expenses forecast ( wages, bonuses, social charges, vacation, headcounts) Participating in forecast review activities
Danone Water
Business Analyst consultant IS consultant on behalf of a BI company (Solution BI)
June 2011 Oct. 2013
Main Projects - Development and evolution of cash management application o Proposing an automatic process for the closing period to be developed on IBM Tivoli (job scheduling) o Audit of the databases for optimizing the outline and calculation scripts on Essbase - Migrating versions of Essbase from V7.3.1 to V11.1.2.1, adapting batch processes o Establishing guidance for a common naming and batch processes for all applications o Challenging the IT teams and reporting team on the technical restrictions - Redesigning securities for all Essbase applications of a Business Unit, using Shared Services o Developing new Business Rules & guidance for Access management o Reviewing the accesses & filters for all Essbase applications - Developing a new Budgeting application for the Dairy Business Unit in Canada
2
Business Analysis / Controlling / BI consultant Cyril TOUSSAINT
Budget / Forecast improvements - Focus on the optimization of the closing processes, guidance & schedules for Essbase applications - Monitoring evolutions and problems of each business analysis - Using SAP FICO on a daily basis for tests & analysis of financial data Danone Water France – Finance - Managing weekly meetings with all Business Controllers for the follow up of the projects - Providing documentation to be maintained on the indicators and KPI for the analysis of results - Solving data transfers issues between the current application and the historical applications - Assisting the reporting team on daily tasks & backup of key users - Defining, developing & deploying new indicators, managing and updating the Data Load Rules Danone Water France – Production Management - Developing new batch that the controlling team can launch by itself for automatic calculations - Developing new costs data loading and calculations for fixed costs and variable costs - Team leader on solving material quantity variance calculation and data loading Danone Water France – Logistical Management - Maintaining the matching cost center hierarchies between SAP & Essbase - Optimizing calculation scripts for a better business purpose - Using the location aliases for mapping data between two applications instead of a Report Script / DLR process
Millicom
EPM consultant Forecast & Budget applications maintainance on behalf of a small sized BI company (Methys)
June 2010 June 2011
Projects - Project Manager for the evolution of the forecasting application for the company’s new activities o Project involving consolidation data from HFM, and reporting in Essbase o Responsible of 2 interns on the project o Weekly meeting with the BI manager for the schedule and the remaining tasks o Separating the tasks and accompanying the interns on their tasks - Ad Hoc analysis on issues regarding data transfers from the consolidation software (HFM) to the reporting solutions (Essbase). Main Responsibilities - Responsible for the Essbase applications for the group ( Millicom International + 16 subsidiairies worldwide) - Managing the securities, accesses, Essbase servers and Essbase applications - Responsible for the Excel file with VBA, Excel formulas and Essbase API used by the reporting team Budget / Forecast improvements - Maintain budget / forecast applications for 16 worldwide subsidiaries & headquarter in Luxembourg - Developing an ETL application on Excel for extractions from HFM to Essbase ( at the beginning of the budget / forecast process for the actual data) and from Essbase to HFM (at the end of the forecast process) - Responsible of developing calculation rules for KPIs - Establishing a functional / technical documentation for the P&L and Balance Sheet applications
3
Business Analysis / Controlling / BI consultant Cyril TOUSSAINT
Brasseries Kronenbourg Business Analysis & Sales Support
1-year internship
June 2008 June 2009
Main responsibilities - Responsible of the reporting on Sales force bonuses, reports on sales figures - Providing weekly analysis on the sales performance to the top management - Developing weekly marketing reports and in store prices reports, shared by the Sales Force of the company - Verification of calculation logics for Sales KPIs
APPLICATIONS -
Business Softwares o Expert on Hyperion Essbase (all versions) Management and Advanced user on EAS Writing / optimizing calculation scripts Managing the Essbase API for Excel Security management (Shared Services) o Advanced user on Informatica powercenter (ETL), Arcplan (reporting) et Cognos (BI) o Standard user for Planning (BI / Reporting/ Workflow), Microstrategy (BI), Magnitude (BI/Reporting)
-
VBA, Excel, Powerpoint o Able to give training on Excel & VBA o Automatizations of reporting and charts from Excel to Powerpoint o ETL applications with Excel for data transfers between HFM and Essbase for Millicom o Sales Management for all Sales Force & Managers, using reports from Report Net and Powerplay and VBA programs on Excel o Calculations of Unitary Costs using reports from SAP and VBA programs on Excel o Data management of Internal Marketing Order using reports from SAP, VBA programs and Excel
-
Basic use of SQL queries o Ad hoc analysis using DB Visualizer and SQL Server 2010 o Building SQL queries for improvement of analysis processes
-
Baisc use of PHP, HTML, java programs o Developing basic menus for the users to launch calculations on Essbase o Managing a website about Essbase, Excel formulas and VBA programs, using HTML codes
4
Business Analysis / Controlling / BI consultant Cyril TOUSSAINT
Languages -
French (mother tongue) English (fluent) German (basics) Vietnamese (beginner)
EDUCATION 2009 - 2010 -
Texas A&M University, Master of Corporate Finance & Management (College Station, TX, USA)
Investment analysis Survey of management International business policy
2008 - 2010 -
Marketing Business Finance International business
EM Strasbourg (IECS) Master Management control and audit (Strasbourg, France) IFRS & SOX Advanced Accounting Consolidation & merger/takeover Management Controlling
2004 - 2007 -
-
-
Finance Audit Corporate Finance Advanced Financial Analysis Business English & German
East-Paris Marne la Vallée University, Licence Economics - Business (Marne la Vallée, France)
General & adv. accounting Marketing General Economics
-
Mathematics & Statistical finance Management control
EXTRA CURRICULAR ACTIVITIES -
Managing a personal website about Excel & Essbase Classic literature readings (Hemingway, Steinbeck, Kerouac …) Sport (running, swimming)
5
