Laurent - Chef de projet HYPERION
Ref : 150225B002-
74600 SEYNOD
-
Chef de projet, Consultant, Consultant fonctionnel (44 ans)
-
Freelance
FIND Diagnostics (Geneva, CH)
JEDOX CONSULTANT
2014 (1 month)
THE CUSTOMER
MISSION & OBJECTIVES Non-profit Organization
Conception of a JEDOX limited application (cube, dimensions)
Creation of JEDOX reports, calculations (Actuals, Budget, Forecast)
TECHNOLOGIES JEDOX v.5.2
CROSS (Geneva, CH)
JEDOX CONSULTANT
2014 (3 months)
THE CUSTOMER
MISSION & OBJECTIVES Cross-systems is an IT company specialized in performance management, Business intelligence and digital transformation
Conception of a JEDOX application for budget, Forecast & re-forecast
Customize ETL tool to populate actuals data
Creation of JEDOX reports, calculations
TECHNOLOGIES JEDOX v.5.2
DHL (Bâle, CH)
ODI – COGNOS SUPPORT
2014 (8 months)
THE CUSTOMER
MISSION & OBJECTIVES DHL is the global market leader in the logistics industry
Customer support
Development of new interfaces
Creation of new scenario
Modifications of Cognos reports
TECHNOLOGIES Oracle Data Integrator, Cognos Report 8, SQL
PERNOD-RICARD (Geneva, CH)
HYPERION PLANNING CONSULTANT
2013 (4 months)
THE CUSTOMER
MISSION & OBJECTIVES Pernod Ricard is the world's co-leader in Wines & Spirits and the leader of the Premium segment. The group operates in 80 subsidiaries.
Design, implementation of a planning & budgeting application
Build and customize web forms, task lists
Development of controlling, consolidation and complex allocation rules
Workflow Design
Assistance during UAT phase
Go-live
TECHNOLOGIES Oracle Hyperion Planning v.11, SmartView
SAN MARINA (Aubagne, FR)
ESSBASE CONSULTANT
2013 (2 months)
THE CUSTOMER
MISSION & OBJECTIVES San Marina is a leader in the footwear industry with 250 stores in France and abroad.
Implementation of a Essbase cube for sales analysis
ASO cube Implementation for sales analysis
Data flow management with a SQL Server Datawarehouse
TECHNOLOGIES Oracle Essbase v.11, SQL Server 2008
SNCM (Marseille, FR)
ESSBASE CONSULTANT
2013 (2 months)
THE CUSTOMER
MISSION & OBJECTIVES
TASKS French shipping company providing regular connections from France to Corsica, Sardinia, Algeria and Tunisia
Implementation of a planning & budgeting application
Manage Workshops
Specifications & requirement analysis
TECHNOLOGIES Oracle Essbase v.11
CITCO (Nyon, CH)
EPM CONSULTANT
2013 (2 months)
THE CUSTOMER
MISSION & OBJECTIVE The Citco Group of Companies is a worldwide group of independent financial service providers serving the world's elite hedge funds, private equity and real estate firms, institutional banks
Assistance during tools recommendations and selections
Comparison of tool according to CITCO requirements
Manage the development of a proof of concept
TECHNOLOGIES Oracle Hyperion Planning, Jedox, IBM TM1, Tagetik
TRB International (Geneva, CH)
HYPERION PLANNING CONSULTANT
2012 - Present
THE CUSTOMER
MISSION & OBJECTIVE
Design, marketing and development of branded products "Villebrequin”
Support of a planning & controlling application
Assistance during the development of new interfaces between Essbase and the ERP.
Data validation after closing cycles
Participation during creation of a new budget process
TECHNOLOGIES Oracle Hyperion Planning v.9, SmartView, SQL Server 2000 (DTS)
Family Office (Geneva, CH)
HYPERION CONSULTANT
2011 – 2012 (12 months)
THE CUSTOMER
MISSION & OBJECTIVE Family office
Participation during requirements analysis and design
Design a new HFM application for the group consolidation (Allocation & Consolidation Business Rules, Web forms, Member-lists, Reports…)
Design a new FDM application to populate data in HFM & in Qlikview
Training
Applicative maintenance
TECHNOLOGIES Oracle HFM, FDQM v.11, Qlikview
General Electric Energy (Belfort, FR)
HYPERION PLANNING CONSULTANT
2011-2012 (6 months)
THE CUSTOMER
MISSION & OBJECTIVE For more than half a century, GE has been an industry leader in combined cycle technology and today leads the industry in combined cycle installations around the world.
Implementation of a planning & budgeting application
Translation of requirements analysis in technical specifications
Build and customize web forms
Development of controlling, consolidation and allocation rules
Development of a reporting application for Budget and Forecast vs Actual
Create and design Hyperion Reports
Assistance during UAT phase
Support & maintenance
TECHNOLOGIES Oracle Hyperion Planning, Hyperion Financial Reports
CMA-CGM (Marseille, FR)
HFM CONSULTANT
2010-2011 (12 months)
THE CUSTOMER
MISSION & OBJECTIVE A world leader company in container shipping ranking third worldwide. CMA CGM operates a fleet of 350 ships.
Participation during requirements analysis and design
Conception and customization of web forms
Mainly involved during the development of “complex” consolidation and allocation rules
Development of a reporting application for IT CAPEX for Actual, Budget and Forecast
Create and design Hyperion Reports (P&L, Management accounts...)
Worldwide functional support for 350 subsidiaries
TECHNOLOGIES Oracle HFM, Oracle Hyperion Reports, SmartView
Mutuelle France Plus (Marseille, FR)
SAGE 1000 & BO CONSULTANT
2010 (1 month)
THE CUSTOMER
MISSION & OBJECTIVES Mutuelle France Plus is the first “Mutuelle” federation in France
Training and build financial reports
TECHNOLOGIES Business Objects XI Web Intelligence, Sage 1000
CAPL (Avignon, FR)
SAGE 1000 CONSULTANT 2008-2009 (10 months)
THE CUSTOMER
MISSION & OBJECTIVES CAPL is an agricultural cooperative that develops procurement, collection, and free agricultural services.
Implementation of new financial platform
Analysis, design and development of a new accounting system
Implementation of a cost-accounting application
Design and development of an interface to manage data flow
End-users training
Manage and coach consultants & client relationship
Project management
TECHNOLOGIES Sage 1000 ERP (modules financiers) v.5.50
FIC (Nîmes, FR)
SAGE 1000 CONSULTANT
2008-2010
THE CUSTOMER
MISSION & OBJECTIVES FIC SA is a trading company in heating, plumbing, iron, water treatment, plumbing, tiling
Financial application migration
Application and data migration (1,5 million of accounting records)
Design and development of an interface to manage data flow
End-users training
Manage and coach junior consultants & manage client relationship
Project management
TECHNOLOGIES Sage 1000 ERP (modules financiers) v.5.50
Florajet (Aix-en-Provence, FR)
SAGE 1000 CONSULTANT
2008-2010
THE CUSTOMER
MISSION & OBJECTIVES Florajet is a e- transmission floral company
Implementation of new financial platform
Analysis, design and development of a new accounting system
Implementation of a cost-accounting application
Data migration (8 million of accounting records)
Customize templates and forms
Create retrieve and dashboards, financial statements
Design and development of an interface to manage data flow
End-users training
Manage and coach consultants & client relationship
Project management
TECHNOLOGIES Sage 1000 ERP (modules financiers) v.5.50
Clos d’Aguzon (Drôme Provençale, FR)
SAGE 1000 CONSULTANT
2008-2010
THE CUSTOMER
MISSION & OBJECTIVES Based in the heart of the Drôme region of Provence, the Bontoux company has established itself over the years as a major international supplier of aromatic ingredients for the production of fragrances, flavors, cosmetics, pharmaceuticals.
Implementation of new financial platform
Participation during analysis, design of a new accounting system and statutory consolidation application
Implementation of an asset management software
Create retrieve and dashboards, financial statements
End-users training
Design and development of an interface to manage data flow
TECHNOLOGIES Sage 1000 ERP (modules financiers) v.5.50, Invoke, BO XI WebIntelligence
Berto Group (Avignon, FR)
INVOKE CONSULTANT
2008-2000 (3 months)
THE CUSTOMER
MISSION & OBJECTIVES The Berto group is the leader in France of industrial vehicle hire with conductors.
Implementation of a financial consolidation & reporting system
Implementation of a statutory and managerial application
End-users training
Functional support
TECHNOLOGIES Sage 1000 ERP (asset module), Invoke Financial Accounting System
Midi Libre (Montpellier, FR)
GEC CONSULTANT
2008 (2 months)
THE CUSTOMER
MISSION & OBJECTIFS Midi Libre is part of South West Media Group.
Development of an application to populate accounting records from cash management application
TECHNOLOGIES Dimo gestion (GEC)
EXPERIENCE OVERVIEW
Financial systems specialist (statutory consolidation, budgeting & controlling)
Global understanding of business & technical issues
Customer satisfaction approach based
Making the link between the Business and IT department
Solutions provider, customer support
FUNCTIONAL SKILLS
TYPE EXPERTISES
BUSINESS
CONSULTING
SECTORS Statutory consolidation, Management Reporting
Budgeting, controlling and Planning
Group Accounting, Financial Management
Cost accounting, Budgeting & Planning
Asset Management, Tax reporting
Collect & analyze business requirements
Functional & technical design
Build and customize applications
Functional and technical support
Training expertise
Services (financials, trucks rental, regional press)
Industry (Logistics, Alcohol, footwear, textile, Energy)
Transport (passengers and containers)
Family office
Mutuality
Agricultural cooperatives
Trading
Internet (flowers, tires sales)
LANGUAGE French Mother tongue
English Daily professional use
TECHNICAL SKILLS
DOMAINE TECHNONOLOGIES & EXPERTISES
PLANNING Oracle : Hyperion Planning, Essbase (certified consultant)
Jedox
SAP BPC
STATUTORY CONSOLIDATION
Oracle: Hyperion Financial Management (certified consultant)
Invoke Financial Accounting system
REPORTING & DASHBOARDING
ETL Hyperion Financial Reports
Cognos Report 8
QlikView
Tableau Software
Oracle Data Integrator
ERP
LANGUAGES Sage 1000 (certified consultant)
SQL, VB
YEARS DIPLOMAS AND LOCATIONS
2001 Master degree in information systems - Grenoble Ecole de Management (Business School, Grenoble, France)
2000 Maîtrise in Economics - University of Pantheon-Sorbonne, Paris, France
(FOURTH YEAR OF UNDERGRADUATE STUDIES EQUIVALENT TO A BACHELOR DEGREE)