Laurent - Business Analyst SAP
Ref : 170811O001-
69500 BRON
-
Consultant, Directeur de projet, Business Analyst, Data Analyst (59 ans)
-
Freelance
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
EDUCATION
Ecole Centrale de Lyon (1987), General Engineering
Dual training – Centrale / E.M. Lyon Business School
SKILLS
SAP SAP CRM, SAP SD, SAP PI, SAP PO SAP MDM, MasterData, Netweaver
CRM / Marketing Tools SAP CRM, Avisor, Coheris Nomad Pivotal CRM, Adobe Campaign
BI SAP BW, MSBI (SSRS, SSAS), Decision Dashboard, Jasper Report, Webreport PowerPivot, DAX, MDX
ETL Business object (BODS, BODI), SSIS Oracle ODI, Informatica, Talend
Business Analyst Business Requirements, Teams Accompaniment
Solutions Benchmarking, Selection Process, Gap Analysis, Compliance
Request For Proposal, Testing Strategy, UAT, Standard Operating Procedures
MDM/DQM
Data Migration/MDG Orchestra Network EBX5
Process definition of MDG (MasterData Governance)
Model Driven Approaches, As-Is Modeling, Target Datamodel (To Be)
DB Modeling, Data Profiling, Data Quality Management, Data Cleansing,
SAP: LSMW – ELM – ECC – Idocs
Cutover Management, Stored Procedures, Triggers, PL/SQL, T-SQL
Business Areas Sales/Marketing/Digital, Sell-out (CRM B to B to C), Sell-in (CRM B to B)
PMO/Data project manager
Project Management and Coordination, POC Management
Business Owners / Technical Teams Interface
Migration / Roll-out, Kick-off, Workshops
Roadmap, Reporting, Planning, Budget, Group-wide Process Animation
Coaching
Methodologies/Models UML2, BPMN, Agile Methods (Scrum, XP), Merise, V-Model, CMMI 3, Off-shore
BPM – Workflow
Business Process Modeling - Reverse Engineering
Bonita, BPMN, XSD, Groovy, XPDL, WSDL
DBMS SQL Server, PostgreSQL, MySQL, Oracle, DB2
Softwares BPMS: Bonita Studio, Visio Ticketing: JIRA, Mantis, ServiceNow
Languages English: Professional skills German: Basic Knowledge