-
IPSEN Pharma - Data Stream Leader Enterprise Interface & MDM
- Expert
2019 - maintenant
Data Stream Leader for a portfolio of cross system Data flows exchanges (60%)
* Front Office (Build + Run)
* participation of functional supervision (Sales/Marketing, R&D, Data Governance)
* workshops with stake-holders for business requirements (SalesForce CRM, Marketing Automation, Clinical Studies, Manufactured Products in SAP ...)
* Review of various data life cycle artifacts (Data Dictionary, Data Flow Diagram, Data Quality Plans incidents, problems and changes management)
* For New interfaces (Build): leading the whole life cycle
* designing the right way to implement + drafting of functional specifications
* data quality assessment and improvement recommendation
* Lead of technical implementation (backlog preparation, sprint planning)
* test management (integration + UAT)
* GxP Validation (Life Science regulatory constraint)
* cutover management and hypercare
Environment
AWS - iPaaS - Informatica Cloud - informatica IDQ - iPaaS for Salesforce connector
Veeva CRM (Salesforce) - Adobe Campaign (Neolane) - SAP Ecc (Finished Products)
XBIOM (Biometry) - Veeva ATOLS RIM (Regulatory Information)
Webservices - API - JSON - XML - Service Now - Jira - $U - BODI/BODS - postman
to support the company masterdata approach and roadmap (40%)
* Participation in the drafting of the 3 years MDM roadmap
* Life Science data models: IDMP (Medicinal Product), HCP/HCO (Customer), BRIDG
* Infrastructure improvement plan for GxP Compliance
* Transverse collaboration to promote the appropriate vision to meet the needs
* Workshops with stakeholders (business, IT, partners, DataGov ...)
* identifying ``Master Data'', designing and building data models
* identifying scope of data to manage (Datamodel comparison, Data Collection ...)
* MDM + Interfaces functional specifications (URS, FSD, Backlog)
* DWH assessment (gap analysis), Functional Data quality assessment (Sales)
* Implementing the Roadmap (Clinical Study Referential, Product Master Data)
* Committees preparation and participation (Steerco, Operational, Vendor)
* RFP preparation and tender's evaluation
* Lead developments (Third Party) and technical operations
* Insure quality of delivery (UAT + GxP Validation)
Environment
Informatica MDM - Informatica IDQ - iPaaS - Informatica Cloud
AWS Server DB Oracle - SQL Server - Active Directory
Life Science: TraceLink (Serialization) - RIM/VREG (Regulatory) - GxP- GTGov (Regulatory)
-
SANOFI
- Marketing and Sales
Paris
2018 - 2019
SANOFI ITS - Data Architect Team - -------
As part of a major BI Core Model project for all countries and all Business Units
Assistance to a current BI implementation on Data Architecture's perspective
* management of 2 products hierarchies
* data inconsistencies detection
* mappings description review
Data-modeling of the Business Object `Contract' in an agnostic Core-Model BI Approach
* Business requirement challenging
* DB-Modeling on each BI's level (
Environment
AWS - S3 - Informatica Cloud - PostGre SQL - QuickSense
MDM: Semarchy - Tibco EBX5 (Orchestra) SAP HANA - BW - COPA
SAP Power Designer
-
EDENRED
- Transversal Project Management
Malakoff
2017 - 2018
PMO BI for EDENRED (World leader Ticket Restaurant)
-------
In a context of CRM + MDM Roll out, management of a major BI release
* Kick off, Steering, Business & Technical committees
* Roadmap, Requirements, backlog and Sprint Management
* UAT and Cutover Management, Training material content (participation)
Business Assessment and impacts
* Stakeholder Interviews for a Top 10 of major reports by department
* Workshops with stakeholders on major datamodel and MDM issues
* Business Glossary design and redaction
BI Governance
* Inventory of the situation, workshops for alignment on priorities
* Roadmap for BI Governance synchronized with IT initiatives
Environment
BI: SAP BO, Power BI, MDM : Semarchy CRM : SalesForce, Pivotal Sciforma Biztalk
-
SANOFI GROUP
- Data Architect MDM
2017 - 2017
MDM Assessment for SANOFI PASTEUR (Vaccines) - -------
Assessment of the EDR Transformation Program (Enterprise Data Referential)
Transversal analysis (Build, Master Data Governance, SOP, ...)
Diagnostic and suggestions on MDM and DWH according to business objectives required
* Functional architecture (Material Registration, Business Data Model ...)
* Interfaces Roadmap based on the Roll out of the Corporate Core Initiatives
Environment
IDMP, MDM, Business Data Model, EDR, SOP, SAP
Pharmaceutical / Medical / Manufactured Products, GxP
-
Kronenbourg SAS
- Senior Business Analyst & Data Analyst
2016 - 2017
Nomad: Sales Force Team Automation (Retail - Supermarket)
* Business Analyst on the new SFA
* RFP + Consultation with vendors (participation)
* UAT: Testing Strategy+ End-to-End process tests
* MDM/Data Analyst
* MDM: Sales MasterData (Customers, Materials, Trade, Org Model, Assortments)
* Scope of data to manage (Datamodel comparison + Data Mapping + workshops
* Transverse workshops focused on the functional quality of the Sales Data
* Governance/Process for each DataSet
* Technical Topic Management: Interface Contracts, Hosting, Maintenance
* Functional Data migration - Cutover - Data Quality (DQM) 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
Environment
MDM: Idocs, SAP PI, SAP PO, MiddlewareECC, SQL
ERP: SAP CRM, SAP BW, SAP SD, HR, PP, ServiceNow
Hybrid BI +DBMS: SSIS, SSRS, SSAS, SQL Server, PowerPivot, DAX, MDX
-
Carlsberg Group
- Business Analyst
Copenhague
2015 - 2016
Business Analyst - MasterData -------
SAP Standardisation Program Western Europe Roll-Out (near-shore + off-shore)
* Business Analyst
* Gap Analysis between SAP package and business specific expectation
* Workshops with PMO + Country Key Users for alignment of the SAP package
* Workshops to design Workarounds and Way Of Working
* UAT: Testing strategy
* hypercare: Territory Management + Standard Operating Procedures (SOP)
* MDM/Data Analyst
* Data preparation
* Migration of functional data required for the implementation
* Dataset for tests - Dataset and configuration for Go Live (scope * Mass Upload + Cutover
Environment
SAP CRM, REX, SAP ECC, SAP BW, SAP ERP (SD, HR) , ServiceNow
MDM: LSMW, Navicat, Dataloader
-
AJUSTEO
- Business Analyst / PMO
2013 - 2015
Main Activities
* Business Analyst / PMO
* Business Requirement and drawing of business process flow (BPMN)
* Transverse management
* MDM/Data
* Model Driven approaches
* Alerting Data inconsistencies, Tools for MasterData auto-cleansing
* Workshops for Governance and DataQuality Improvement (DQM)
* Design of synchronized interface contracts depending on IT and security rules
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
Main Keywords (out of NDA)
Datamining, MasterData Management, Nomenclature, Governance
B to B to C: sell-out, up-selling, loyalty,
B to B: sales channel management, Reseller Business KPI (sell-out)
For a World Wide Petcare Laboratory (N.D.A.) - Marketing Automation
Digital Health Booklet interconnected with Petcare Management Software (PMS): innovative DataWhareHouse with MasterData Customers + Pets + Treatment Adherence
* DWH modelisation (Universal definitions + MasterData)
* DataSet (PMS's Datamodel Transformation, Treatment Adherence Templates, ...)
* 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
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
* Data Rules Resilience: Inconsistencies Detection, Data Quality, SQL Packages
For a healthcare Economic Interest Group: POC for data collection after Phase 4 clinical trials (NDA)
* Business Cases drawing (BPMN Notation)
* POC management + DataModeling
-
AVISOR
- Business Data Analyst & Senior Partner
2005 - 2012
Avisor: Trusted third-party Platform for Workflows Execution in PaaS Mode
* Business Process executed for the payer out of his IT with his own MasterData
* Data Quality Improvement
* Marketing Automation
* Graphical studio (BPMN) for MasterData Governance (MDG) + Business Process
* BI - Business KPI tracking and Report
* Business Analyst / PMO
* Opportunity and feasibility study of the concept `Workflows out of IT'
* Workshops for Users Requirement and Business Process Modelization (BPMN)
* Committees (Steering, Technical), Roadmap and Coaching
* MDM/Data Analyst
* Assessment of the Quality of MasterData required for Business Process
* MasterData changes ( * Business KPI to track and report
* DataModel Analysis of each Third Party's software source for the MDM
