SAP BI consultant since 2010.
Technical Environment
SAP BW, SAP BO, SAP SD, Qlikview
Clients:
sanofi pasteur, Schneider, Volvo IT, Vencorex/Perstorp, TAG Heuer, EDF, bioMérieux
Mes compétences :
SAP BW
Training
Qlikview
Entreprises
Capgemini France
Parismaintenant
EDF
- SAP BI Consultant
Paris2015 - maintenantBI Maintenance
Employer: Sopra Steria Group
User Assistance
Incidents and tickets resolution
Evolution and application corrections
Conduct conception and validation workshops
User support during test phases
Technical Environment:
SAP BO
Caisse d'allocations familiales
- Business analyst
Paris2014 - 2014Project: Télé recouvrement
Employer: Sopra Steria Group
Conduct, conception and validation workshops
Redact functional specifications documents
Realise application mock-ups
Realise test strategies and user acceptance tests
Ensure that all functional requirements are covered with the help of test plans
Train junior team members on technical aspects of the project
bioMérieux
- SAP BI Consultant
MARCY-L'ETOILE2014 - 2014TMA BI ComOps
Employer: Sopra Steria Group
Manage maintenance of BI applications in commercial domain at global level
Realised the project "Price conditions" that allows price listing, analysis, and manage various discounts applied to clients based on products, countries, clients etc…
Corrective and evolutive maintenance
Manage incidents
Manage change
Regular activity reporting to american collaborators
Conduct follow-up meeting and writing reports with the client in France & USA
Requirement Analysis
Propose a solution for application evolution solution & control with an action plan
Technical Environment:
SAP BW7.0
Volvo Trucks
- SAP SD Functional Consultant
saint priest2014 - 2014TMA SD SIPRE / ALCOR
Employer: Capgemini
Application Maintenance SIPRE (Manage spare parts of Renault Trucks)
-Evolution & correction of current system
Manage a project for Renault Trucks Défense :
-Retrieve from SAP SD the list of spare parts, stock valorisation and price list to an e-commerce portal
Conduct conception & validation workshops
Redact functional specifications documents
Collaborate with offshore team
Present the final solution to the client
Technical Environment:
SAP SD
TAG Heuer
- SAP BI Consultant
Paris 92013 - 2014CO-BI Project
Employer: Capgemini
Build SAP BW for sales managers at TAG Heuer.
Constructed the BW flows that retrieves data from SD/MM and COPA
The reporting concerns the sale of watches
Analysis of the Sell-In Sell-Out of TAG Heuer
Analysis budget forecasts and monthly sales
Analysis of sales performances both real & estimated
Analysis of monthly stocks
Analysis of TAG Heuer sales compared to those of competitors in swiss market
Conduct workshops for requirements gathering
Develop the flows in several iterations, presentation and validation of each iteration
Develop Bex Reports(autorisations, user exit…)
Unit & integration tests
Support et corrections of anomalies during test phase
Technical Environment:
SAP BI 7, SAP SD, SAP MM, SAP CO-PA.
Schneider Electric
- Consultant SAP BW
Rueil Malmaison2013 - 2013Client: Schneider Electric
Extraction of historical orders and deliveries from BW
Technical Environment:
SAP BW 3.1
Vencorex Perstorp
- SAP BI Consultant
Paris2013 - 2013Client: Vencorex Perstorp
Creation of two new flows for SD/MM and FI/CO data
Technical Environment:
SAP BI 7.3
Volvo Trucks
- SAP BW Consultant
saint priest2011 - 2012Maintenance of BI applications SIPRE BW and ALCORE BW
SIPRE : Logistics (SAP SD/MM)
ALCOR: Finance and Accounting (SAP FI/CO, CO-PA)
-Users Assistance
-Ticket's Treatment:
- Data's errors in the reporting
- Difference between SAP R/3 and BW
- User's accounts locked
- Users Creation/Suppression
- Add and remove authorizations
Enhancement:
-Qualification of the application with the customer
-Achieving of the evolutions and/or corrections
-Test the solution
-Transport the solution to the production environment
-Documentation
-Offshore One Team with Indian team
Project 1 : REMAN (Remanufacturing)
In the standard exchanges, customers purchase items in exchange of parts.
There are two types of invoices:
Standard Billing: Parts are billed at the time of purchase of the item.
Differed Billing : Parts not billed at the time of purchase of the item.
These two types were not taken in account in BW, the reporting was therefore false.
Projet 2 : Hubble
Extraction of invoices from BW to MS-BI plateform with BW ETL tools (Infospoke).
Projet 3 : AMDM
Create new flow to had dynamic analyse of stock depreciation.
Projets 5 : FAST IT
Creation of new profit center and cost center for ALCOR
Yearly closing
-Execution of End Of Year process 2011/2012
-Simulation of new rates for 2012 in BW
-Simulation of stock depreciationsfor 2012 BW
-Corrcetion of the new bugs
BW Upgrade from 3.5 to 7
-Assistance of Polish team
-Writing test plan
-Running tests
Users traning
-Writing training support for SAP BEX for end users and key users.
-Help users to improve their skills in using reporting and dashbording tools
Reverse shadowing
-Writing technical documentation
-Knowledge transfer in English with Polish team
Technical Environment:
SAP BW 3.5, BW 7.2, SAP SD/MM, SAP FI-CO, SAP CO-PA
Schneider Electric
- SAP BI Consultant
Rueil Malmaison2011 - 2011
Maintenance of ASARIS and SSRM Plateforms
ASARIS: BW application for Logistics
-Users Assistance
-Ticket's Treatment:
- Data's errors in the reporting
- Difference between SAP R/3 and BW
- User's accounts locked
- Users Creation/Suppression
- Add and remove authorizations
-Constraint :
- The monitoring is done in India
- Night and weekends intervention if the loadings failed
SSRM : BW application for Supplier Management
Monthly loadings of SPENDS (purchase's volume) and SPM (quality management of suppliers)
Small Enhancement: Evolutive and Corrective Maintenance (between 5 and 10 days)
-Qualification of the application with the customer
-Achieving of the evolutions and/or corrections
-Test the solution
-Transport the solution to the production environment
-Documentation
-Offshore One Team with Indian team
ASARIS
Enhancement 1 : Add free characteristics for monitoring delivery steps
When analysing the consolidation of shipments, it was found that the recipient customer is not always the customer delivered.
Correction of transport flow, adding the characterestics that allows to monitor the delivery.
Enhancement 2 : InfoSource to cancel sales orders
Some orders are excluded from the portfolio of orders in SAP R / 3 but are considered ongoing or delivered in BW side.
This distorts the reporting in BW.
Enhancement 3 : New key figures
Add in all ASARIS queries the data related to the dedicated stock:
Stock dédié (MARC-ZZ_STOCK_DEDIE)
Stock dédié (€) (Stock dédié * Prix standard / Base prix)
Enhancement 4 : Creation of new queries (new requirement)
SSRM
Enhancement 1 : Entity Country and Region
The requirement consists in provinding ti the SSRM BW users an additional analysis means, allowing to have directly access to proups of Entity Countries in the BW reports. This group of Entity Countries, will be an additional analysis object and will be named "Entity Region".
Enhancement 2 : Rebuild completly the Payment Terms Data Flow
Enhancement 3 : Move AUT
SSRM servers were moved from Sophia Antipolis to Saint Denis :
Write the test plan
Execute the tests with HPQC
Enhancement 4 : Default value of year in Payment Terms queries
In the Payment Terms query, we need to implement a new selection variable which displayed the last year loaded in the base.
Enhancement 5 : Reporting Guidelines
Write a document that allows to define and describe thereporting functional and technical rules common to all the SSRM reports, in order to provide the development maintenance standards, and guarantee clear and homogeneous layouts to the end users.
Technical Environment:
SAP BW 3.5, SAP SD/MM, EBP, SRM (BW)
Capgemini France
- Consultant SAP BI/ Qlikview
Paris2011 - 2011-Maintenance of BI Applications (SAP BW 3.x)
-Enhancements / Projects
Clients: Schneider / Volvo IT
Sanofi Pasteur
- Consultant SAP BW / Qlikview
Lyon2010 - 2011Junior consultant on SAP BW and Qlikview for sanofi pasteur.
Maintenance of BI plateformes:
-Monitoring and check of the loadings
-Users assistance
-Loading data in cubes from BPS or flat files
-Process chains
-Transports
-Creation of Autorisation
-Loading InfoObjets and Master Data
-Creation and planning Qlikview tasks
-Deployment of applications in validation and production environment
-Evolutive and corrective maintenance
-Qualification of the solution with the customer
-Help users to improve their skills in using reporting and dashbording tools
-Knowledge transfer with project teams when new applications are deployed
into production environment
-Environement: SAP BW 3.5 and BI7, SAP R/3, Qlikview 9 and 10
Lyon2013 - 2013SAP SD - Self-training SAP SD:
SCM600: Business Processes in Sales Order
Management
SCM605: Sales processing in SAP ERP
SCM610: Delivery Processes
SCM615: Billing
SCM620: Pricing in SD
SCM650: Cross-Functional Customizing in SD
SAP BI Academy (Lyon)
Lyon2012 - 2012SAP BI - SAP BI Academy:
-330: Business Information Warehouse
Modelisation and implementation
-365: Business Information Warehouse
Authorization -SAP BO -Advanced Modelisation -
OpenHub