Dorian Keddar

Creation of the Data Group division,

Implementation of Power BI,

Development of a Data Warehouse,

Development of reports for management

- SI Mapping:

Map the IT system in its entirety (Corporate and WorldWide). Implemented automation routines to collect and keep the mapping up to date.

-H+20 Data Science:

Supervised a Data Science project aimed at improving a vaccine production process (research project supported as part of my studies). Implemented python scripts for structuring, preparing, and analyzing data. It allows reading large files (+2GB per file), transforming (pivot, Label Encoder) the structure of datasets, consolidating missing data, creating new features, and finally analyzing the correlation between the yield variable and production variables (Pearson correlation). Defined a prediction model based on a classification algorithm (XGboost) to predict product quality upstream of production. Created a Web Application with RShiny to visualize all production curves.

-JESSE RUN activities management:

Supervised a BI project aimed at assisting in the management of run activities by implementing and monitoring KPIs in Microstrategy. Agile project manager, scrum master, I supervised the implementation of Talends jobs and VEGA tasks for automating the extraction, processing, and transfer of data from source (email) to destination (ODS AND DWH). SQL and Microstrategy developer, scripts for creating, structuring, and populating ODS and DWH tables. Development of basic Microstrategy reports for KPI visualization.

Website development and traffic analysis

Implementation of an email address collection solution

Administration and management of web servers

Writing automated email sending scripts

Implementation of a tool for analyzing email campaign feedback