Laurent - Consultant fonctionnel HYPERION

Sep 2012 – Present John Menzies plc (Edinburgh)
Hyperion Systems Manager
 Coded, tested and documented monthly HFM development changes, including rules using VB Script.
 Maintenance of FDM mapping tables.
 Provided user training and guidance to 120 users across 30 countries.
 HFM and FDM User security maintenance.
 Building and maintaining Smart view models
 Report building using Financial Reporting Studio.
 Project lead for the upgrade to Hyperion EPM 11.1.2.3
 Development of the carbon reporting and weekly cash flow applications in HFM
 Design of an application for 3 Year Plan and Budgeting in Hyperion Planning

Dec 2011 – Sep 2012 RBS – FiRST programme (Edinburgh)
HFM Consultant
 Took responsibility for HFM rules change management as part of the build team.
 Ensured integrity of business rules though unit testing and troubleshooting.
 Participated in the significant improvement of consolidation run time (-60%).
 Developed portions of the regulatory reporting and validations (rules, metadata, web forms).

Jan 2011 – Sep 2011 Fraikin Group (Paris)
HFM Consultant
● Led preparatory workshops and wrote HFM general functional specifications.
● Defined testing scenarios to ensure and consistency of HFM functionalities, calculations and objects.
● Provided training and documentation to local and english end users (UK Fraikin – Coventry).
● Took ownership of critical reconciliation and data migration exercise (from Excel to HFM and from accounting systems to HFM using FDQM).
● Served as the primary communications link between the customer (Fraikin) and the project executor (IBM).
● Took responsibility for HFM reports design.
● Troubleshoot / provide technical assistance to end users (from HQ and countries).
● Assisted Consolidation department on data reconciliation and trouble shooting of interface discrepancies.

Oct 2010 – Jan 2011 CPI Group (Paris)
Business analyst
● Implemented / standardized CPI group’s KPIs under Cartesis - Magnitude.
● Took responsibility for Germany, Netherlands and Eastern european’s divisions financial reporting.

Mar 2004 – Sep 2010 Trader Media East (Paris -Istanbul)
Management accountant / HFM Administrator
● Project manager for HFM 3.5 upgrade to HFM11.
● Analyzed top management and countries financial controllers needs.
● Issued specifications sheet to the external Oracle consultants (Keysoft).
● Served as the primary communications link between HFM consultants, the internal IT, financial departments of Headquarters and countries; oversaw and monitored their activities to ensure timely delivery of HFM system.
● Communicated project guidelines and timelines to internal IT and financial departments of Headquarters and countries.
● Developed Consolidation and Controlling applications.
● Checked / tested data integrity, application functionalities, consolidation rules and calculations.
● Migrated and created financial / KPI reports under HFM11 using Reporting Studio or Smart view.
● Troubleshot / provided technical assistance to end users (from HQ and countries).
● Provided training and documentation to end users.
● HFM administrator assisted by a junior controller.
● Ensured maintenance and administration of group reporting system
● Developed new reports and accounts in line with cost cutting objectives.
● Budget and reporting senior analyst assisted by a junior controller.
● Managed the group budgeting and forecasting process.
● Participated in preparation of LRP.
● Participated in financial communication (due diligence, annual reports, press releases, and presentations).
● Supervised the preparation of Monthly Management Pack and countries analysis.
● Prepared and managed group monthly management accounts and financial reports.
● Reported group actual and planned financials & statistics to parent group (DMG) using SAPBW.
● Managed HQ office monthly accruals.
● Defined HQ office budget & forecast processes / prepared and loaded data.