Laurent - Business Analyst SAP

Expérience professionnelle

4/2017 to 7/2017 IT Migration consultant in buyout context for Calgon Carbon (USA)
Migration of applications and associated data for subsidiaries hosted by Arkema
Assess & Design phase
Assess of each plants to migrate from Arkema IT to Calgon Carbon IT
Application mapping and criticality analysis
Migration plan and check list management for each site
Global Risk log management
Daily report to project’s teams (USA + Belguim)
Implementation and support
Migration activity coordination with local IT contact
Issues management
Technical Environment
SAP, DPS7, Autocad, Bentley, PI

3/2016 to 3/2017 Senior Business Analyst – Data Analyst for Kronenbourg SAS
Nomad: Sales Force Team Automation (Off Trade Supermarket)
To Be SFA Business Analyst
RFP + Consultation with vendors (participation)
MDM: MasterData Sales (Customers, Materials, Promotions, Organisational Model, Assortments)
Determination list of data to manage (Datamodel comparison + workshops)
Governance/Process for each DataSet
Technical Topic Management (Interface Contracts, Hosting, Maintenance procedures)
UAT: Testing Strategy + End-to-End process tests
Functional Data migration – Cutover – Data Quality Management (Tools + Process)

Reporting / BI
Cube (Business Requirement) + Advanced reports (business design + build)
Workaround and Alternative solutions for 2016
Package for a light Sales Force Management until new SFA Goes live

Technical Environment
MDM: Idocs, SAP PI, SAP PO, Middleware ECC, SQL
ERP: SAP CRM, SAP BW, SAP SD, HR, PP, ServiceNow
Hybrid BI + DBMS: SSIS, SSRS, SSAS, SQL Server, PowerPivot, DAX, MDX

8/2015 to 2/2016 Business Analyst - MasterData for Carlsberg Group
Carlsberg Business Standardisation Program Western Europe Roll-Out Wave 4
Workshops with PMO + Country Key Users for alignment of the SAP package to business specific expectation
MasterData
Data preparation + migration of functional data required for the implementation
Mass Upload + Cutover
UAT: Testing strategy
ELS: Territory Management + Standard Operating Procedures redaction
Technical Environment
SAP CRM, REX, SAP ECC, SAP BW, SAP ERP (SD, HR) , ServiceNow
Hybrid BI: SSIS, SSRS, SSAS, Sharepoint
MDM: LSMW, Navicat, Dataload

7/2013 to 7/2015 AJUSTEO (SAS) Business Analyst / MDM
Main Activities
Business Requirement and drawing business process flow for Business Owner
Model Driven approaches
Business Data Management, Functional Data inconsistencies detection, DQM
Design interface contracts and data synchronization depending on Workflows to fill, IT technologies, datamodels and security rules
Main Environments and Methodologies
Bonita, Talend, Jasper Report
Data Modeling: Navicat
Idocs, sftp, REST
DataModel, DataSet, DataStage, Repository, Git, Snapshots
Debian, Stored Procedures, Dynamic SQL, Triggers

For a World Wide Petcare Laboratory (N.D.A.) - CRM B 2 B 2 C
Business Analyst EMEA: Conception of an innovative DataWhareHouse with medical and owner datas coming from Petcare Management Software (PMS)
DWH modelisation (Universal definitions)
DataSet (PMS’s Datamodel Transformation, Treatment Adherence Templates, etc.)
ETL’s packages conception depending on PMS’ technologies
MDG (Standard Operation Procedures, Master, Child Branch, Version, Snapshot)
PMO, workshops with Business Owner, IT Corporate and Vendors

Keywords (out of NDA)
Datamining
B to B to C: sell-out, up-selling, loyalty,
B to B: sales channel management, Reseller Business KPI (sell-out)

For an Event Agency: CRM Data Quality Management (DQM)
PMO: Roadmap, Budget, Supplier management
Business Analyst: Business Requirements, RFP, Dashboards design
MasterData:
Duplicates management, Data Cleansing, Mass-Upload
SQL package for data migration
Data Rules Resilience: Inconsistencies Detection, Data Quality monitoring

For a healthcare Economic Interest Group: POC for data collection after Phase 4 clinical trials (NDA)
Business Cases drawing (BPMN Notation)
POC management + DataModeling
In addition:
Data Quality: inventory, cleansing, duplicates merging, inconsistencies detection
Datamodel transformation, etc

2005 to 2012 AVISOR (Workflows Execution in PaaS Mode) Business Data Analyst – Senior Partner
Avisor: Trusted third-party Platform for Workflows Execution in PaaS Mode
Business Process executed for the payer out of his IT with MasterData automatically synchronised
Distributed architectures: Integration in Business Process of Data coming from Business Partners (Resellers, Suppliers, Prescribers, etc.)
Graphical studio (BPMN) for MasterData Process + Business Process
BI - Business KPI tracking and Report

Business Analyst / PMO
Opportunity and feasibility study for Workflows out of IT with Internal MasterData + Partner’s Data (Resellers, Suppliers, …)
Business Requirement for Key Business Process and/or Valorisation of Available Data
Reformulation with graphical Business Process Modelisation (BPMN)
Workshop (Business Owners, IT, Information System Security, vendor )
Steering committee
Roadmap definition and Coaching

MDM/Data Analyst
Inventory of MasterData required for Business Process
Business KPI to track and report
MasterData changes (Audit Trail)
Graphical design for Process, Dataflow and Data Lifecycle (Data Quality, Data sharing, Data Multi-Owner, etc.)
DataModel Analysis of each Reseller’s software in order to execute directly on local DBMS with a Vendor’s innovative ETL the Business Queries ordered by the Payer
Secure Data exchange management

Main Technical Environments
Business Process and Dataflow modelisation: Bonita, BPMN, Visio, UML, XPDL
Data Modeling: Navicat
Data exchanges : Talend, SSIS
Supervision + Monitoring data + Process: Bonita, Nagios, Stored Procedures
BI/Analytic/Reporting: Talend, MS PowerPivot, Webreport
Workflows: XPDL, WSDL, BPEL, Bonita Talend, Groovy
Techno: Dotnet, JVM, Java, WAR, XML RPC, drivers JDBC/ODBC, C, SQL Server

Example of Business Process hosted
For large manufacturing Brand: CRM B to B to C
For Network Brand: Creation of virtual Customer Information System via data sharing between Network leader and Resellers

Merial (Animal Health – 300 resellers animal hospital) CRM B to B to C
Sell-Out for OTC drug
SMS/Email reminders for OTC medical examination appointments, medical treatment, medication compliance
Electronic health journal automatically filled with data coming from Petcare Medical Softwares

For Atlantic (boiler manufacturing) – 10 000 Resellers Business Lead Management and Upselling
Cross- canal intermediation between customer and most efficient certified installer from lead detection to closing.
Workflow warranties extensions depending on installer and material and contract

For Gentlemen du Déménagement (movers) (2005-2008)
CRM B to B to C: SMS Reminder right before the purchase decision (+ 28 % Sales)

For SanteVet (Insurance – 50 prescribers animal hospital)
CRM B to B to C: "Third-party payment Animal" (POC)

Other clients: Generik (material for hairdressing), Vins de Loire (Wine), Bayer
Cross-canal exchanges during customer experience
Data Quality Management, one shot ETL, Data Valorisation

1991 to 2004
For several large and small IT service companies (ATOS, APX, AUSY, etc.)
Consultant career from Junior Consultant to BU Manager
Transverse Team and HR Management (software engineers)
PMO
Key Account Manager - Business Development
Profit Center Head