BI Project manager
TOTAL Refining & Chemicals
3/2013 - 9/2014
Mission : Run a consolidation project of 2 BI environments (Refining and Petrochemicals) named COBI-One in the context of reorganization of the TOTAL group entities.
Environment :
- 2 platforms sources SAP BI :
o BW 7.1 (no Unicode) + BPS application with reporting via BO XI 3.1
o BW 7.1 (no Unicode) with reporting via BEx Analyzer/BEx Web via portal CRM et Intranet.
- 1 target platform :
o SAP BW 7.1 (Unicode) with BPS application
o Reporting tools : BO XI and BEx Analyzer/Web
- Achieve and follow budget, planning, workload & reporting based it (actual vs budget)
- Coordination of the task assigned to all the different team on the different entities (COBI-1
Hologrammes-Industrie
1/2013 - 6/2013
Mission : Performing an audit on the SAP BO 4 (BI landscape with BO XI webi) for all the modeled flows and developed reports.
- Inventory,
- Production costs
- Sales & CO-PA
And coordination of a specific procedure to reorganized the datawarehouse and the BO reports.
BI Manager
TOTAL Petrochemicals
1/2011 - 6/2013
Mission : Manager BI replacement for the definition of BI roadmap, definition of the strategic choices, project management and BI Support (Europe and Asia) with the team (5 to 8 persons) + Coordination with the BI support team in US (2 persons), the basis team and the abap development team and the SAP team.
- BI Support: SAP BI 7, Reporting BEx Web & Analyzer, Reporting BO XI 3.1
o Incidents / Evolutions / Monitoring
o Recurrent Meeting for coordination & Follow-up with Business / Support Team / IT Basis
- Follow-up of the several projects : Purchasing (COSPER) et Credit (TFGS) Consolidation and Supply Chain Optimization (BI part with APO & ECC links).
- Study of the BI Roadmap and System Convergence in the context of the reorganization :
o Workshop Coordination with SAP Max Attention
o Study of the several SAP BO 4 reporting tools
o Analyze et proposal for the convergence of the BI systems
o BI roadmap proposal
- BI Stabilization Project
o Scope definition (loadings optimization, Early watch, &hellip)
o Organization, definition and coordination of the planning, workload, budget, tasks
o Communication in IS&T department and to the business.
- Dashboard Project
o POC XCelsius / WAD
o Project charter, requirements definition
o Model and coordinate the development
o Change management
- Project Migration BO 6.5 to BEx Analyzer 7.1 / BEx Web (~5000 reports/1000users)
o Arrived at the end of the project to close it :
Lot of communication, change management, specific coaching and coordination to solve all the last issues
Consultant / Responsible of the Support and Recurrent Activities for SAP HR &ndash BI-HR
UCB Group
11/2008 - 12/2010
Mission : responsible of the SAP HR system for support and recurrent activities (SAP HCM, ESS/MSS portal, authorizations) with an on-site team (5 persons) and offshore team (India) and BI-HR project manager.
- Personnel Cost Planning Project (HR/BI/FI)
o Requirements definition for HR and Finance department / Project Charter/ Blueprint
o Workflow proposal
o Conception / Model / Develop / Tests / Validation
o Change management
- BI-HR Dashboard Project => sent by mail to the COMEX members and the HR committee.
o Dashboard PA-OM : Dashboard and drill-down reports to follow RH processes (hiring, turnover, sales per FTEs, vacant positions, etc)
o Dashboard Compensation & Benefits : Dashboard and drill-down on reports to follow RH processes (salary, bonus, etc.. per level)
o Tools : Bex Web Application Designer et Business Objects XI Web Intelligence et XCelsius.
- SAP HR recurrent projects :
o Talent management : Workshops with the business to define and validate the new templates for evaluations. Customization of the new templates (PMS, PDP, EDR), and update of the workflow via les BAPI&rsquos and Classes.
o Salary review : Update of the customization following the rules defined by the management, and worldwide test phase for the automatic generation of the bonus letters.
- BI Support
o Stabilization of the solution :
on ECC side (exit, specific and standard extractors, BAPI, data update),
on BI side (review the model of the Infoproviders, loadings, routines, update rules),
Reporting side (BEx via BI portal) : update of the queries
- RH Support
o Fix bugs, evolutions and customizations (ABAP programs, sap reports, BAPI, SPRO for C&B, OM, PA, MBO domains)
o Manage and challenge the off-shore Indian team
o Follow the GxP quality processes
- Stabilization of the RH authorizations
o Analyze and redefine the requirements with the business for the different processes
o Creation of the authorization
o Integration between the general and structural authorizations (RHBAUS&hellip programs, T77... tables et BAPI)
o Integration with portal authorizations (ESS, MSS)
- Ad-Hoc Query Project
o Requirement definition / Blueprint
o HR Infosets creation on PA and OM with specific fields
o User group creation and users management
BI Senior Consultant / Project manager
Vinci Route
1/2007 - 11/2008
Mission : Integrated in the BI team in order to do support on several BI Domains and take in charge reporting projects.
- BO XI Migration project (BEx and Crystal reports to Business Objects) :
o POC on the first version of the Business Objects XI 3 (Rich Client and Web Intelligence trough BEx query designer)
o Definition of the universes via predefined BEx queries
o Creation of the queries and BO XI WEBI reports
o Creation and management of the authorizations via CMC
- Migration Project : BW 3.5 to BI 7
o Technical study with the basis team and tests (AS Abap vs AS Java, BI Java, Embedded portal...)
o Definition of the step by step procedure for the upgrade
o Presentation of the best scenario (Risk/planning/workload) : split of the system, memory size,etc
o Management of the team, tasks, planning and communication
o Authorization migration
- Reporting projects :
o Turnover Reporting : (controllers & holding)
Requirements and Workshop
Technical and functional analysis
Adapt a BW flow on FI and SD to have all turnovers with exceptions on accounting: modify extractors on R/3 side, exit program, and InfoProviders, loading on Process Chain.
Create new reports on BEx Query Designer.
Change management: user manual / training
o Human Resources Reporting (for Human Resources & Holding)
Requirements and workshops
Technical and Functional analysis.
Design and Build SAP R/3 infosets and queries for operational reporting.
Model of 4 flows for ODS and Infosets: Personal Administration / Payroll / Time and Training Event Management.
Definition of specific extractors in R/3 based on InfoTypes and Clusters
Optimization of loading
Build authorizations on Unit Organization with Hierarchy
Model 5 reports with Business Objects XI 3.0 and with Web Application Designer 7.0
o Purchase Reporting (for purchasing, controlling & holding)
Requirements and workshops
Technical and functional analysis
Model the flow: Extractor Lo-Cockpit MM with user exit, Standard Cube purchase with specifics InfoObjects, Transfers rules and Updates Rules with routine ABAP.
Creation 5 BEx reports on WAD 3.5 and 7.0 with Query designer
Install Delta Loading
Change management : technical and functional trainings
- Maintenance on BW 3.5 et BI 7:
o Anomalies on all flows: FI-CO-SD areas.
o Stabilization of the closing period loadings with scheduling
BI Consultant / Project manager junior
TOTAL Petrochemicals
2/2005 - 2/2007
Mission : Integrated in the Global Reporting team for the achievement of several BI taks, the follow-up of the project and the support of applications.
- Industrial Maintenance Reporting (for all chief of industrial maintenance)
o Technical & Functional analysis: Analyze of data warehouse flow, checking of data in SAP R/3 (PS, PM, CO), BW,
o Customize BW 3.5 cube and specific R/3 extractors on PM and CO area
o Creation of BO universes in the Designer, and creation of reports on Bex and Business Objects 6.5
o Change management : Build Training support, organize and plan functional and technical sessions
o Setup R/3 infoset an queries to feed BW system.
- Investment management reporting (for all chief of projects and holding)
o Technical & Functional analysis: Analyze of data warehouse flow, checking of data in SAP R/3 (PS, CO), BW,
o Customize BW 3.5 cube and specific R/3 extractors on PS and CO area
o Creation of BO universes in the Designer, and creation of reports on Bex and Business Objects 6.5
o Change management : Build Training support, organize and plan functional and technical sessions
- Manage and create authorization management in the BO Supervisor.
- In charge of project manager tasks: report meeting, to collect requirements, to follow planning
BI Consultant / Business Analyst
TOTAL Exploration & Production
6/2004 - 12/2005
Mission :
- Follow-up of accidents and incidents of the group: Safety Reporting for the Production in 2004 &ndash Statistic, graphs, analyze
- Implementation of decision-making tools: monthly indicators
- Learning of the software Business Objects and implementation of monthly indicators reporting
- Analyze of the application OCIAR (use to keyboarding accidents data)
- BW cube customizing, external (non sap) system connection and extractions
Business Analyst Consultant
EADS Group
1/1994 - 5/2004
Mission :
- Follow up of delivery notes: automatic saving of customers&rsquo files from the database in Access with Visual Basic coding.
- Reporting on Contract of technical documentation
- Analyze of customers data in SAP R/3