Yann - Consultant / Business Analyst Digital Marketing

Ref : 201021M001
Email vérifié
Photo de Yann, Consultant / Business Analyst Digital Marketing
Compétences
SALESFORCE
ADOBE CAMPAIGN
SQL
TABLEAU SOFTWARE
TERADATA
SQL SERVER
Microsoft Power BI
QLIKVIEW
Expériences professionnelles

  • Marketing Cloud Data analyst:

    TODAY LUMINUS
    Jan 2020 - aujourd'hui

    SEPT 2020 –
    - Marketing Business Requirements analysis
    - Design data integration of diverse data sources
    o Created Integration interface documents
    o Initiated a Data dictionary
    o Started implementing the data integration using FTP and SQL
    - Data Model design in Marketing Cloud
    o Designed a user-friendly Data Model for easy segmentation by Marketeers
    o Designed Master Data extensions for Product Holdings at Contact level and a Master data extension for Contract/Billing level information. It covers at least 80% of the BR
    o Combined Data filters and Data relationships for enhanced filtering capabilities through Filtering the User Interface

  • Due to Covid-19, working on personal projects:

    WITHIN YLEOM
    Jan 2020 - Jan 2020

    - Blockchain and crypto-currency: self-trained on Blockchain and started a cryptocurrency investment portfolio;
    - E-commerce: designed and developed 2 online stores using the Shopify platform and Facebook Ad Manager;
    - Learning path:
    o Certifications: Salesforce Marketing Cloud Consultant (certified June 2020), Salesforce Marketing Cloud Admin (certified in July 2020), Tableau desktop specialist (certified July 2020;
    o Trainings: Salesforce Einstein Analytics, Microsoft PowerBI

  • Marketing automation expert for Vlerick Business School:

    4C, BRUSSELS (FREELANCE)
    Jan 2019 - Jan 2020

    - Design and development of the data integration process between Sales Cloud and Marketing Cloud using automations/SQL activities
    o To synchronize opt-in/opt-out status for Leads and Contacts and DoNotTrack flag
    o To synchronize profile attributes in a multi-org configuration
    - Data Model design in Marketing Cloud
    - Journey and email templates design

  • Salesforce Marketing Cloud Product Owner:

    EASYFAIRS, BRUSSELS (FREELANCE)
    Jan 2019 - Jan 2020

    - Create User stories based on the Marketing Business requirements
    - Redesign of the current journeys and new campaigns development based on the User stories
    - Development of complex segmentations using Automation studio
    - Data analysis/Campaign reporting
    - Administration tasks: SAP and Private domain, RMM, FTP accounts, Send classifications, etc.
    - I have designed and implemented a process that uses an automation schedule (only one) to send an email at a fixed time based on the recipient’s location time zone.
    - Google Analytics integration with Marketing Cloud: conversion analysis and reporting
    Data Management:
    - Design of a common Marketing Data model for the Group and redefinition of the Contact key for cross-channel and cross-BU utilization
    - Development of data integration processes between Marketing Cloud and other systems (DMP, Data lake)
    - Creation and maintenance of a Data dictionary
    - Development of Data quality processes

  • Salesforce Marketing Cloud development:

    CGI MONTPELLIER (FREELANCE)
    Jan 2018 - Jan 2018

    - Automation Studio: design and development of data manipulation and segmentation processes with SQL
    - Email design using Content Builder
    - Tracking and reporting using Google Analytics

  • Unica (IBM Campaign) consultant

    STIME (INTERMARCHE)
    Jan 2018 - Jan 2018

    - Design and implementation of a campaign monitoring solution using IBM Campaign notification capabilities.
    - Implementation of a solution using the IBM Platform utility in order to copy flowcharts and campaigns between environments.

  • CAMPAIGN DATA ANALYST

    DASSAULT SYSTEMS
    Jan 2018 - Jan 2018

    Data Management and data quality
    - Critical Marketing data sets analysis: Design and development of new technical workflows in Adobe Campaign for data quality analysis and complex segmentation with SQL
    - Tracking data analysis using Tableau
    - Design and Development of a Contact quality score in Adobe Campaign.
    - Improvement of the underlying Data Model for storing Contact History over 6 months Rolling period

  • CONSULTANT (FRANCE) Consultant and Product Owner for La POSTE B2B

    CGI SR SOLUTION
    Jan 2017 - Jan 2018

    - New tables and views design and development for the new business scope using Data Vault modelling principles.
    - Design and development of new Adobe Campaign schemas and mapping
    - New campaigns workflows development

Études et formations

  • MBA – . Major: Business start-up.

    Sorbonne’s Graduate Business School
    2009

  • Certified in Structured Programming, IBM MVS system, DB2 SQL at H2I Education services –

    Montpellier, France
    1996

  • Certified in Structured Programming, IBM MVS system, DB2 SQL at H2I Education services

    – Montpellier, France
    1995
Autres compétences
Languages
• French: mother tongue
• English: bilingual
• Dutch: beginner

D'autres freelances
Consultant fonctionnel SALESFORCE

Ces profils pourraient vous intéresser !
CV Consultant fonctionnel
Dennis

Consultant fonctionnel

  • PARIS
JIRA EXCEL Microsoft Power BI Microsoft PowerApps WTX MYSQL SALESFORCE AGILE ITIL HTML5
Disponible
CV Business Analyst SALESFORCE
Christophe

Business Analyst SALESFORCE

  • CHARENTON-LE-PONT
SALESFORCE JIRA MAITRISE D OUVRAGE AGILE SQL
Disponible
CV Chef de projet SALESFORCE
Nadia

Chef de projet SALESFORCE

  • COURBEVOIE
SALESFORCE HUBSPOT MICROSOFT CRM
Disponible
CV Consultant fonctionnel SALESFORCE
Charlotte

Consultant fonctionnel SALESFORCE

  • LYON
MICROSOFT TEAMS SHAREPOINT SALESFORCE POWERPOINT AGILE
Disponible
CV Consultant fonctionnel Polyvalent SALESFORCE .Certifié Agile
Nicolas

Consultant fonctionnel Polyvalent SALESFORCE .Certifié Agile

  • PARIS
BUSINESS SUPPORT SYSTEM SALESFORCE AGILE
Disponible
CV Product Owner / MAITRISE D OUVRAGE / Gestion d'Applications
Stéphane

Product Owner / MAITRISE D OUVRAGE / Gestion d'Applications

  • PARIS
MAITRISE D OUVRAGE JIRA EXCEL AGILE SQL SCRUM MOA (MAITRISE D OUVRAGE) ISTQB ORACLE SALESFORCE
Disponible
CV PMO AGILE
Héritier

PMO AGILE

  • CHELLES
JIRA AGILE EXCEL MAITRISE D OUVRAGE GED LEAD MANAGEMENT PKI SQL ITIL SALESFORCE
Disponible
CV Consultant fonctionnel Pardot
Walid

Consultant fonctionnel Pardot

  • PARIS
Pardot Salesforce Marketing Cloud SALESFORCE HubSpot CRM
CV Ingénieur support applicatif
Mehdi

Ingénieur support applicatif

  • SAINT-MAUR-DES-FOSSÉS
SQL JIRA ORACLE SQL SERVER AGILE MS OFFICE 365 WINDOWS MAITRISE D OUVRAGE SAP SALESFORCE
CV Consultant fonctionnel SALESFORCE
Djamali

Consultant fonctionnel SALESFORCE

  • FRANCONVILLE
SALESFORCE Pardot HUBSPOT