Samuel Lefranc

Responsible of all data subjects releated to Oqee, the app that enables Free subscribers to watch tv contents : dashboarding and analytics, recommender system, ad targeting, ... Missions : - Improvement of the system of data collection (addition of new devices, monitoring of anomalies, ...) - Setup of an ELT and a Data Warehouse architecture to clean and process tv watching data (using Minio, prefect and Clickhouse) - Design of a recommender system on live and replay/vod contents - Creation of dashboards and analytics tools to monitor the app usage - Handling of Google Analytics tagging and analysis

Research & Development of Machine Learning / Deep Learning Algorithms - Marketing Mix Analysis (to predict the volume of incoming users) - Lead Scoring (to improve the funnel of conversion) - NLP on client feedbacks, audio recordings, .. - Creation of chatbots (for internal and external use) with LLMs - Extraction of informations in documents and images using OCR and Deep Learning Assistance on Data Engineering processes Data Visualization & Dashboarding Work on Data Enrichment with Open Data

Development of algorithms and methodologies on : - econometrics : estimation of short and long term incremental impact of TV/radio spot broadcasts on website traffic - tv attribution : identify individually these TV visitors among all visitors coming on a website and follow their behaviour along the purchase funnel Development of APIs using Python frameworks (Flask, FastAPI, Dash) Deployment of algorithms running live in production using Docker Data analysis on media and drive to web data

Management of « Marketing Mix Modeling » analyses (sales optimization through modelling of marketing levers impact) for a top player actor of the automotive industry on several European countries (France, Germany, UK, Spain, Italy, Belgium, Netherlands) + A South American country (Argentina) Data reporting and analysis on CRM activation campaigns for another actor of the automotive industry on a European scope (France, Germany, UK, Spain, Italy)

1 / Media Data Analyst in the TV/Web Department (June 2014-August 2017) - TV ratings and Web audience analysis - Production of marketing studies based on media consumption and audience behaviour - Management of a client portfolio including France Televisions (the French public national television broadcaster) and France Télvisions Publicité (its advertising agency) 2 / Data Analyst in the Movies Department (December 2013 / June 2014) - Analysis of movies strengths and weaknesses based upon audience reaction and appreciation - Writing of reports for movies distributors

Media analyst in the Studies Department. Work on TV audience scores and audience satisfaction indicators

Work in the Studies, Statistics and Forecasting Department

Work on the development on a monitoring process for a GNSS GBAS in order to ensure integrity