Freelancer profile translated to English.

Back to original language

Description

My 10 years in data allow me to support you on many topics:

Technical:

-Creation and optimization of SQL, Hive, or SAS queries

-Data cleaning / Data Wrangling / Data prep

-Data exploration / Reporting in dataviz tools like Tableau, Qlik, Power BI

-Scoring / Segmentation / Clustering using SAS, R, or Python

-Journey in Salesforce Marketing Cloud

Business:

-Customer profiles

-Attrition/Retention

-Marketing issues

-Customer value

-Design/Implementation of automated marketing campaigns

-Business analysis support, specification, acceptance testing

If you are looking for a dynamic consultant who loves teamwork and seeks quick solutions, do not hesitate to contact me.

Languages

French
Native or bilingual
English
Conversational

Workplace preferences

Can work on-site

Paris (up to 20km), Nantes (up to 15km), Le Mans (up to 15km), Rennes (up to 15km), Brest (up to 15km)

Simon Hamon Consulting
Data Analyst Freelance
DIGITAL AND IT
January 2022 - Today (4 years and 5 months)
Paris, France
SQL SAS Tableau software Qlik Sense Salesforce Marketing Cloud Direct marketing Reporting Data visualisation Data analysis Microsoft Excel Data mining Business analysis Customer Journey
GARANCE MUTUELLE
Consultant Data Analyst
BANKING AND INSURANCE
January 2022 - May 2022 (4 months)
Paris, France
Support for the marketing team:
-Attrition
-Loyalty
-Customer segmentation
-Salesforce Marketing Cloud exploitation
-Marketing campaign performance
-GDPR consents
Salesforce Marketing Cloud Qlik Sense SQL Reporting Data visualisation Data analysis Data mining Relationship marketing marketing automation Microsoft Excel
Financo
Lead Data Analyst
BANKING AND INSURANCE
July 2018 - December 2021 (3 years and 6 months)
Guipavas, France
Segmentation/scoring/clustering:
-Modeling of customer value for revolving credit
-Production flow forecasting
-Customer portfolio forecasting and monitoring via duration models
-Customer segmentation

Customer profile & spatial analysis:
-Customer profile: SQL data preparation, presentation in Tableau
-Point of sale profile: profile of top-performing points of sale with integration of open-data, catchment area analysis
-Presentation to key account managers

Direct marketing campaigns:
-SQL Oracle/SAS extraction
-Targeting plan design, A/B testing
-Reporting and performance analysis, Tableau software
-Salesforce Marketing Cloud implementation, data extension and journey creation
-Presentation/recommendations to marketing teams

Tool migration and modernization
-Hadoop data lake creation
-Hive SQL queries
-SAS server 9.4 migration.
-Tableau Software implementation
-SalesForce Marketing Cloud implementation
Data analyst Data analysis SQL Data visualisation Tableau software SAS Oracle Reporting Salesforce Marketing Cloud Hive GDPR Business analysis