Valerie - Chef de projet SAP BW

BI Project manager

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.

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

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, …)
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 – BI-HR

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’s 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… 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

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

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

Mission :
- Follow-up of accidents and incidents of the group: Safety Reporting for the Production in 2004 – 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

Mission :
- Follow up of delivery notes: automatic saving of customers’ files from the database in Access with Visual Basic coding.
- Reporting on Contract of technical documentation
- Analyze of customers data in SAP R/3