Mohammed - Chef de projet VBA

Experiences

Sectors:Ressources,Customer & Sevices,Finance Services and Insurance
➢Companies:Schneider-Electric,Total,Danone,PSA(Peugeo & Citroën),
Faurecia,Carrefour Bank,Groupama(Gan insurance),BNP Paribas,Airwell,LVMH,CDG Maroc,
OCP Maroc,Wavestone,APICIL,Lesaffre,Nokia
AtNezya -Oct2017(CurrentJob)
➢Nokia–EPMEssbase 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 SS IS , Windows batch At Pe build the budget and the reporting of all insurance
activities: Lead the study and the design phase, build planning, man age the delivery team
members.
◘ Technical environment:Jedox
➢Wavestone–Projectmanager
•Management of the delivery of the system allowing Wavestone to merge different subsidiaries’
ERPs into environment:People Soft,Talend, Active 6,Odoo
◘•Management of the delivery of the news version of the Kurt Salmon and Solucom companies:
Estimate charges, Plan tasks and resources, design and implement changes and manage all the
project d 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 con sultant • Lead of the EPM Hyperion study in order to define the new BI transformation
program for the PCIS department ofLVMH.
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
oNeeds collection and analysis, Workshops animation,Writing functional and technical specifications and build of the project.
oSupport for validation phase,Writing user and administration guide,SupervisorsTraining.
◘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
oNeeds collection and analysis,Writing requirements specifications and Development of the changes in the incoming data interface.
oChanging 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 Financialreporting 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
oDevelopment of the restitution reports.
◘Technical environment:Hyperion Essbase 9.3,Hyperion Shared Services,Smartview for office,MDX,VBA
BUSINESS INTELLIGENCE-ENTERPRISE PERFORMANCE MANAGEMENT
➢Feasibility study and BNP Paribas Group–Senior Consultant
•Kaplan project:Cost management software package for BNP group subsidiaries.
oSpecifications analysis, configurability study,application and technical architecture.
oWriting requirements list,requirements file,use cases and businessrules.
◘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 3Hyperion Planning pplications(REPORTING,BUDGET and PLAN)
◘Technicalenvironment (planned):Hyperion EPM 11,Oracle,Java interface.
➢ CDG Maroc– Senior Consultant
•PLN Project:Lead of the workshops during the design
stage for building 3Hyperion Planning applications (REPORTING, BUDGET and PLAN)
◘Technical environment (planned):Hyperion EPM 11, interfa