BI and EPM consultant - Hyperion Expert

At Nezya - Oct 2017 (Current Job)
? Nokia – EPM Essbase expert • RedBox 2.0 project: Ensuring Alcatel Lucent reporting tool fusion with Nokia global reporting: P&L and Balance Sheet data mappings and
integration : Source data check, data load, mappings, currency conversion, elimination and data checks before the transfer to target system
• Support during the Alcatel current production reportig
? Technical environment: Hyperion Essbase, MS SSIS, Windows batch
At PerfectSight - Aug 2016 to July 2017
? Apicil – Project manager • Management of study the design and the delivery of the performance management system allowing Apicil to build the budget and the reporting
of all insurance activities: Lead the study and the design phase, build planning, manage the delivery team members.
? Technical environment: Jedox ? Wavestone – Project manager • Management of the delivery of the system allowing Wavestone to merge different subsidiaries’ ERPs into one Group ERP: Build planning,
manage team members, and monitor all aspects of the project until the start of the ongoing mode.
? Technical environment: People Soft, Talend, Active 6, Odoo • Management of the delivery of the news version of the BI and EPM plattform that has been updated to suit to the new target operating model created as a consequence of the merge of Kurt Salmon and Solucom companies: Estimate charges, Plan tasks and resources, design and implement changes and manage all the project delivery phases
? Technical environment: Jedox
At Nell’Armonia - Nov 2015 to July 2016
? Schenider-Electric – EPM Hyperion Project leader • Management of the year switch for 2 Hyperion Planning applications (AOC Analysis Of Change and RMI Raw Material Impacts) and for 4
Essbase applications (Global Functions, Cash, Global Distribution and Global Finance) : update of the chart of accounts, Entities organization, Business rules, Securities and optimization of the consolidation scripts
? Technical environment: Hyperion Planning and Essbase, Shuttle, Windows batchs
At Accenture - May 2011 to Oct 2015
? LVMH – EPM Hyperion consultant • Lead of the EPM Hyperion study in order to define the new BI transformation program for the PCIS department of LVMH. As-is analysis, target definition, definition of the roadmap and costing of the transformation work
? Technical environment: Hyperion Essbase and Planning ? Carrefour Bank – Senior Consultant • CRM2 project: design of a datawarehouse and a datamart for marketing and risk departments: design workshops’ animation, writing of the
detail design documents and coordination of the works between the business and the Italian team which were the responsible for the build step of the project
? Technical environment : Oracle DB ? DANONE – BI/EPM Front office Manager • Lead of the BSBI team who ensures the support for the business on the Group BI information system. Management of 4 contributors in the front and a team of 20 contributors in the back office (off-shoring in Manila). Coordination of the service, management of the production SIR / Opportunities / Projects and the financial month close. Lead of the Reporting/Budgeting/Forecasting changes implemented under Hyperion
? Technical environment: Oracle, Informatica, Hyperion Essbase/Planning, Microstrategy ? FAURECIA – Senior Consultant • Metis-HR project: reporting and budgeting system for the HR department. Monitoring of achievements and Hyperion Planning expertise : Lead of a team of 2 resources in building Model design, Webforms, Business rules, Reports, and training documentation.
? Technical environment : Hyperion Planning 11.1.2.1
  At Business & Decision - Feb 2007 to Apr 2011
? TOTAL Group – Senior Consultant/Project Manager
Management of several applications in ongoing mode and leading several Hyperion projects: scoping, planning, design, build, test support
and change management. Direct contact with the IT and the business during regular workshops and lead of a team of 2 contributors
to ensure deliveries’ completion: • Total RM (Refining & Marketing)
o Horus project – Financial and operational reporting system of Total RM: Audit, Third Party Maintenance (corrections and changes), Application upgrade and migration, Support for users, Administration, Project leading.
? Technical environment: Hyperion Essbase 6.5 then 9.3, Hyperion Shared Services, VB interface, VBA. o Sarastro project – Application dedicated to the development of long-term plan for Total RM: Assistance in the plan drawing process, user
training, Third Party Maintenance (corrections and changes), Application upgrade and migration, Administration, Project leading.
? Technical environment: Hyperion Essbase 6.5 then 9.3, Hyperion Shared Services, VB interface, VBA.
o Phoenix project – Application dedicated to the development of budget and long-term plan for Refining direction of Total RM: Assistance
in the budget and plan drawing process, Third Party Maintenance (corrections and changes), Application upgrade and migration, Administration,
Project leading.
? Technical environment: Hyperion Essbase 9.3, Hyperion Shared Services, VBA interface. o Eclair project – Application dedicated to financial and operational reporting for the fuel direction of Total RM: Design, development and
delivery of the application which includes actual, forecast and budget processes, Change management, Third Party Maintenance (corrections
and changes), administration, Project leading.
? Technical environment: Hyperion Planning/Essbase and Financial reporting 9.3, Hyperion Smartview for office, Hyperion Shared Services. • Total Holding
o PLT and Herget projects – Applications dedicated to the development of reporting, budget and long-term plan for Total Holding: Application
upgrade and migration.
? Technical environment: Hyperion Essbase 6.5 then 9.2, VB interface, VBA.
• Total GEN (Gas & New Powers)
o Figaro project – Application dedicated to financial and operational reporting for Total GEN: Establishment of the budget reporting phase
and the budget drawing process, Development of the input forms, study and development of several changes, Audit and recasting of the
security policy.
? Technical environment : Hyperion Essbase 6.5, VB interface, VBA. ? GROUPAMA Group – Senior Consultant • Business Plan project for the subsidiary Gan Assurance – Modeling, design and implementation of the business plan for the general, health
and life insurances
o Needs collection and analysis, Workshops animation, Writing functional and technical specifications and build of the project.
o Support for validation phase, Writing user and administration guide, Supervisors Training.
? Technical environment: Hyperion Planning/Essbase and Financial reporting 9.3, Hyperion Smartview for office, Hyperion Shared Services,
Oracle Data Integrator (ODI), Batch. ? AIRWELL Group – Senior Consultant/Project manager • Evolution of the budgeting system – Design and implementation of several changes in the budgeting system
o Needs collection and analysis, Writing requirements specifications and Development of the changes in the incoming data interface.
o Changing components of the application that manages the sales and costs.Updating the interface that transfers data to the application
managing the P&L and the balance sheet.
? Technical environment: Hyperion planning/Essbase and Financial reporting 9.3, Hyperion Shared Services, Batch. ? PSA Group – Consultant • Samara Project – Design and implementation of the restitution and analysis data components for car’s margin calculation systems
o Development of the restitution reports.
? Technical environment: Hyperion Essbase 9.3, Hyperion Shared Services, Smartview for office, MDX, VBA ? BNP Paribas Group – Senior Consultant • Kaplan project: Cost management software package for BNP group subsidiaries.
o Specifications analysis, configurability study, application and technical architecture.
o Writing requirements list, requirements file, use cases and business rules.
? Technical environment (planned) : Hyperion EPM 11, Oracle, Java interface. ? CDG Maroc – Senior Consultant • PLN Project: Lead of the workshops during the design stage for building 3 Hyperion Planning applications (REPORTING, BUDGET and PLAN)
? Technical environment (planned) : Hyperion EPM 11, Oracle, Java interface.