Missions Data Dictionary : Découvrez les offres de mission déposées

Résumé d'expériences de Yann,
freelance DATA DICTIONARY habitant ?

Marketing Cloud Data analyst:
TODAY LUMINUS
9/2020 -
SEPT 2020 &ndash
- 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
4/2020 - 8/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)
12/2019 - 4/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)
2/2019 - 2/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&rsquos 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)
9/2018 - 12/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)
6/2018 - 8/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
3/2018 - 6/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
10/2017 - 2/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