Freelancer profile translated to English.
Back to original languageAbout Pauline
I help you analyze and leverage your data to better understand your challenges, make informed decisions, and implement tools tailored to your needs.
Since 2015, I have worked on various projects in luxury, real estate, logistics, and music. I am involved in the entire data lifecycle: from data retrieval to making it available in the form of dashboards and decision support tools.
I work quickly, document my work, and ensure that my deliverables are understandable and useful for both business and technical teams.
Some examples of projects completed:
- Analysis of stockouts in stores and their causes for a major French luxury house, with the implementation of a dashboard used by 100+ people.
- Development and deployment of a decision support tool with a sampling rate recommendation model to help the quality control team of a major French luxury house perform targeted checks.
- Development and deployment of a real estate valuation model using heterogeneous and open-source data for Crédit Foncier Immobilier.
- Development of an Artificial Intelligence familiarization training for non-technical teams.
Tools mastered: Python, SQL, Tableau, Power BI, DBT, Snowflake, AWS, GCP, Dataiku.
French
Native or bilingual
English
Fluent
Can work on-site
Paris (up to 10km)
Experience
- EkinoData AnalystLUXURY GOODSOctober 2022 - September 2024 (1 year and 11 months)Pantin, FranceAnalysis of stockouts for a selection of products worldwide and identification of root causes of stockouts, for the retail team of a major French luxury houseTechnologies : Python, SQL, Snowflake, and Power BIProject Scoping
- Client needs gathering
- Client data audit
Stockout Analysis- Data transformation and cleaning with DBT
- Complex analysis of business processes related to stockouts (Python and SQL)
- Quantitative estimation of stockout costs and identification of their causes (Python and SQL)
Creation of a PowerBI stockout analysis demonstrator- Facilitation of analysis dashboard design workshops with the UX team
- Writing technical specifications for the analysis dashboard
- EkinoData Analyst / Data ScientistLUXURY GOODSAugust 2020 - July 2022 (1 year and 11 months)Levallois-Perret, FranceCreation and maintenance of a targeted sampling rate recommendation tool for the quality control team of a major French luxury houseTechnologies : Python, SQL, Snowflake, AWS, and TableauProject Scoping
- Collaboration with a Consultant for client needs gathering
- Client data audit
Development of data extraction and transformation processes- Collaboration with a Data Engineer for data model creation
- Collaboration with a Data Engineer for database creation in Snowflake
- Collaboration with a Data Engineer for the creation of SQL data transformation scripts
Development of the recommendation algorithm- Writing technical specifications for the algorithm
- Development in Python of a Bayesian inference algorithm to estimate sampling rates
Tool Development- Facilitation of tool design workshops with the UX team
- Development of a Tableau tool comprising 5 reporting tabs, 4 configuration tabs, and 1 recommendation tab
- Tool acceptance testing
- Collaboration with a Consultant for user training on tool usage
Application Maintenance- Addition of a reporting tab to the dashboard
- Addition of business rules to enrich rate recommendations
- Improvement of the data transformation process
Tool in production and used since 2021 - EkinoData ScientistREAL ESTATEDecember 2017 - December 2019 (2 years)Paris, FranceDevelopment of a real estate valuation algorithm for Crédit Foncier Immobilier to perform property-by-property or portfolio valuations based on 3 inputs: property type, size, and locationTechnologies : Python (XGBoost), DBT, GCP, and TableauProject Scoping
- Client data audit
- State-of-the-art review of real estate valuation models
Model Development- Testing of several algorithms (XGBoost, Random Forest)
- Feature Engineering
- Collaboration with a Data Engineer for model deployment on GCP
- Collaboration with a Data Engineer for automating model retraining
- Development of an analysis and monitoring dashboard for model results to detect data drift
- Mentoring an intern for model improvement
Modification of the data source and ETL- Replacement of client data with open-source data (DVF)
- Analysis of new data and comparison with client data
- Development of a Python script for data retrieval and raw data storage in GCS
- Data transformation and cleaning with DBT to replace Airflow
- Use of BigQuery as DataWarehouse
Recommendations
Be the first to recommend Pauline
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Master's in Mathematical Engineering, Statistics Option,University of Nantes2014Master Ingénierie Mathématiques Option Statistique,
- Bachelor's in Mathematics,University of NantesLicence de Mathématiques,