Michaël Estiot

- Sales rep commissions calculation for EMEA & APAC, Accruals.
- SOX preparation work for commission part.

Tools:
Cognos - Excel, VBA for Excel

Sector: Internet

TESCO Ireland , Trade & Marketing Analyst ;
Location : Dun Laoghaire, Dublin – IRELAND
Consolidated Sales figure 2006: €3,5b
xxxx employees
Mission context :
- Commercial Finance Dpt : Weekly Trade Review: Weekly Sales ReportAd hoc Analysis, Daily Sales Report automation.
- Marketing Management Accounts : Monthly Accruals, Clubcard points & Christmas Saver.
- Space Insight Dpt: Sales and Space data Report and every Ad-hoc requests within the Dpt / Buyers request.
- Tools: Excel, SQL (Teradata)

Sector: Hypermarkets

ASTRIUM Space Transportation (EADS), Production Cost control ;
Location : Les Mureaux - FRANCE
Consolidated Sales figure 2005: €300m (France, Ariane 5 Production program )
330 employees
Mission context : 30 Launchers to be delivered to Arianespace, from 2006 to 2011.
- Monthly Progress Review preparation, Stage and Launcher; Technical progress vs Estimated Cost at completion analysis; Database setup on Excel and Access for cost per Stages / Cost per Launcher analysis.
- Cost per Launcher ; Subco’s cost + Own part cost consolidation, Estimated cost at completion vs Actuals analysis.
- Travel Costs Analysis ; analysis per activity module, frequency and cost per mission, daily cost per mission per destination (Paris, France, Europe, Kourou) ; HR and Accounting data breakdown.
- Tools: Excel, SAP, BW

Sector: Spatial industry

Coriolis TELECOM, Mobile Handsets Business Controller;
Location: Paris (Nanterre 92) - FRANCE
Consolidated Sales figure 2004: €450m
800 employees
3 main business areas:
- CORIOLIS Telecom: Telecommunication Service Provider (B to B, B to C), mainly Mobile phone rentals, Handsets Wholesaler, Broadband internet and fixed phone as side businesses to be developed
- CORIOLIS Service; Call Center, all located in France exclusively
- TELEPHONE Store: Retailers network (mobile phones handsets, accessories…)
Mission : for CORIOLIS Telecom, as the Mobile Handsets sales figure moved from 40 ME in 2003 to 90 ME in 2004:
- on a Monthly basis : Closing, stock valuation, prepayments & accruals- Finance support to Sales & Marketing Dpt. (Business planning, Pricing for Mailing campaigns…)

Sector: Telecom Operators

France TELECOM, Procurement Dpt, Business Analyst, « TOP Sourcing Program» (Total Operational Performance)
Location: Montrouge 42 Av de la Marne (Région Parisienne 92) - FRANCE
Consolidated Sales figure 2004: €47,157m
206,524 employees (52 % located in France for FTSA)
As a Business Analyst:
Mission : in the context of the TOP Sourcing Program of a new European Procurement Department, for each commodities (Office IT equipment & Administrative Prints) :
- Supplier's profiles Analysis Market analysis, suppliers profiles.
- Datacollection : specifications, volumes and prices, trough a questionnaire on Excel for each group entities, or trough an e-RFI for suppliers, consolidation on Excel
- RFP sent : design of the suppliers quotation sheet, suppliers quotations analysis trough a database on Excel, savings estimates on Excel
- Negotiation files : on Powerpoint, meeting minutes in French/English
Achievements :
* 41% savings on Office IT Equipments (35 % if you take in account price decrease % that usually occur on IT market each year)
* 16 % savings on Pre-print bills
* 11 % savings on envelopes, less items used
Commodity Teams were organised with a Core Team (1 Team Leader, 1 or 2 AT Kearney consultants, specifiers, 1 or two Business Analyst depending on the volume of work to do) + extended team members for legal questions, and person representatives of the different entities to make sure the products we negotiated fits their company needs, most of the time they were buyers.
English as a working language
References available upon request

Sector: Telecom Operators

SARP ONYX (Veolia ENVIRONNEMENT), Management Accountant
Location : Courbevoie - FRANCE
Business area : Liquid Waste Collection and Management / Pipeline Maintenance
Consolidated Sales figure 2001 : €365m)
5000 employees
as a Financial Analyst :
Mission :
- Reporting : on a monthly basis, financial reporting .
Budgeting and forecasting for the Holding company and two subsidiaries (SARP Reseaux; Pipeline Maintenance and SEVIA: Facility Management). Business Planning for a new contract in Britanny for SARP Reseaux. Closing quarterly forecasts.
- Business analysis with Cartesis SKOVER, a new software application in use at the beginning of 2002.
- Project Management : Budget Planning software development over 8 eight months
As the company set up a new budgeting process going further more in details, it became necessary to help subsidiaries to manage with the huge volume of data they had to face at this moment, mixing accounting and forecasting data for each statutory accounting period.
Project scope: French scope turnover : €250m
Rollout; Training program over three weeks for people in charge of French subsidiaries financial reports.
References available upon request

Sector: Industrial Waste Disposal - Safety