Nicolas - Business Analyst ESSBASE
Ref : 090921O001-
10023 NEW YORK (Etats-Unis)
-
Chef de projet, Consultant, Business Analyst (41 ans)
-
Freelance
Richemont North America (New York) May 2008 – present
Junior Project Manager in charge of the Business Intelligence system based on SAP solution
Reporting enhancement
Defined business requirements and change requests for new Business Intelligence modules and followed up their implementation with IT team
Enhanced and designed dashboards and reports to support Finance, Retail and Wholesale operations according to users’ needs and responsibilities: brands sales overviews, wholesale sales reports, boutique dashboards, etc.
Analyzed, tested and rolled-out new functionality provided by IT team
Reporting solution maintenance and support
Animated global deployment and rollout of world wide template for distribution entities
Maintained and animated the global reporting solution ensuring coherence, cohesion and usability of reporting
Supported 200 business users being key-contact of local management. Managed requests for information, issues or enhancements
Trained users on a weekly basis during informal Q&A sessions
Enhanced documentation including the development of 15 flash-animated e-learning modules with Adobe Captivate
CRM Reporting Project
Elaborated action plan to develop and provide useful and usable CRM functionality for performance measurement and operational tasks support
Improved Data Quality by cleaning irrelevant or erroneous data and set up indicators to monitor database maintenance
Developed CRM dashboards and Clients Cultivation reports to improve insight about customers, get new contacts opportunities and monitor marketing campaigns efficiency
Budgeting Solution Project
Analyzed local sales budgeting process and methods. Defined business requirements for budgeting tool
Implemented new functionality to load budget data into SAP, redefined process accordingly and performed budget loading for the Richemont North America brands
Business & Decision (Paris) Feb 2005 – May 2008
3+ years of progressive consulting experience in Business Intelligence from junior consultant to junior project manager
Integrated information/decision-making systems, reporting, budgeting and forecasting systems based on Hyperion solutions. Participated to all phases of the projects:
Definition and monitoring of project methodology, phases and resources
Project comities and workshops animation
Business requirement, technical and functional specifications definition
Implementation including technical integration, database design, scripting, forms and reports creation, and global settings
Key-users and developers training, documentation and change management
Users acceptance testing, go-live and rollout management.
Assigned within several different French front-rank companies. Main projects:
Groupe Médéric (8 months as a project manager, managing 2 consultants): Implemented a reporting and budgeting solution concerning HR and general expenses
Heineken (2 months): Updated and enhanced reporting Essbase applications. Defined amelioration plans
CNP Assurances (12 months): Implemented an international reporting system leading the subsidiaries of the group and a budgeting and forecasting solution concerning the general expenses
Aéroports de Paris (6 months): Implemented an « operational business plan » making system
Sanofi-Aventis (5 months): Implemented a budgeting and forecasting solution following the merger of Sanofi and Aventis
France Telecom (2 months): Updated a corporate performance management system
Cadbury (1 month): Performed a technical audit of a sales performance management system
SFR Cegetel (4 months): Implemented a budgeting application
PSA Peugeot Citroën (Rennes, France) Sep 2003 – Feb 2004
Professional internship (6 months)
Made secure a supply chain management information system by deployment of alternative process
Collected and analyzed need in the field ; defined and optimized process
Induced and trained users ; tested and validated process
QUALIFICATIONS SUMMARY
Project Management and Functional skills
- Full life cycle project management experience. Ability to lead all phases of a project. 5 years of experience in projects environment including 3+ years in consulting
- Ability to define clear business requirements or functional specifications and manage following implementation and rollout
- Good knowledge of Budgeting process and methods. 3 years of experience in budgeting tools implementation
- Experience with conception and definition of dashboards
- Experience with business users and developers training and coaching, ability to create 360 degrees training program
IT skills
- Proficient in Business Intelligence Solutions including SAP BW and Hyperion System 9 BI Suite
- Ability to develop expertises on new software applications.
EDUCATION
2007 - Executive Master of Business Administration – Paris Sorbonne Graduate Business School
2005 - Master of Science in Management Information Systems - University of Technology of Troyes (France)
6 months of Erasmus exchange program at the University of Technology of Delft (Netherlands)
COMPUTER SKILLS
- Proficient in Hyperion System 9 BI Suite including Essbase, Planning, Financial Reporting, Interactive Reporting. 3 years of experience in Hyperion Planning and Essbase implementation.
- Proficient in SAP Business Intelligence solution (BW) including Query Designer, Web Application Designer (creation of advanced HTML dashboard) and Analyzer. Good understanding of data-warehouse and multi-providers concepts and mechanism
- Good overview of SAP ERP including FI/CO, SD, CRM
- Advanced skills in Microsoft Office including Word, Excel (and macros), PowerPoint, Access, Visio, and Project
- Basis knowledge of languages and methods VBA, SQL, UML, Java, - Experience with Multimedia creation tools including Adobe Photoshop, Adobe Captivate, Macromedia Flah, etc.