Marie-Camille Vergez

Climbing Gym Mobile App Development of a Progressive Web App (PWA) dedicated to indoor bouldering gyms, designed to help climbers track their progression and route setters manage climbing routes. 🔹 Main features - User authentication and profile management - Interactive climbing topo with sectors and routes - Route interactions (Performances, Like, Project, Comments, Videos) - User scoring and progression system - Climbing statistics and performance tracking - Route setter and admin management interfaces - Competition module with live rankings, automated scoring, and post-event statistics ⚙️ Tech stack - React (TypeScript) - Supabase (Auth, PostgreSQL, Storage) - PWA architecture for mobile installation - Vercel deployment ✅ Impact Designed and developed a complete end-to-end application in a short delivery timeline, combining product design, full-stack development, and real-time competition management for climbing communities.

Global Retail & E-commerce – Paris (Hybrid) At Decathlon, I lead the redesign and industrialization of the global Customer Analytics data model as part of the “All Metrics” initiative, aiming to harmonize KPIs across Customer dashboards. 🔹 Customer Data Model & KPI Harmonization I designed and delivered a scalable data model powering strategic Tableau dashboards, with a focus on KPI consistency, scalability, and performance optimization for very large datasets. The architecture includes: - Sales transaction models - Customer/member dimensions - SCD2 fact tables (activity, omnichannel, marketing consent, etc.) - Aggregated KPI layers with multiple time granularities and rolling metrics - Lifecycle and segmentation migration tracking I also standardized reusable BI layers and dashboard tables to simplify future dashboard development and ensure reporting consistency. 🔹 Analytics Engineering & Data Quality In a complex distributed environment, I implemented validation frameworks, business-rule checks, and source-level remediation mechanisms to address upstream data quality issues while maintaining reliable reporting. The models were optimized for global-scale customer data volumes and strict infrastructure constraints around query spilling and computation performance. 🔹 Cross-functional Leadership I coordinated the migration from legacy models, supported analysts during the transition, and introduced shared governance practices using Jira and Confluence. I became a key contact for Customer Analytics topics, supporting teams on KPI definitions, model adoption, and reporting alignment. ✅ Impact Delivered a centralized and scalable analytics foundation enabling harmonized KPIs, simplified dashboard development, and more reliable customer insights across Decathlon’s global ecosystem.

EdTech – Paris (Remote with occasional on-site workshops) At Ornikar, I supported the Sales, CRM, and Marketing teams during a maternity leave replacement, working on the company’s Education division (driving courses, code, and driving license). 🔹 Data restructuring & reporting I rebuilt the Sales, CRM, and Marketing data pipelines using DBT and SQL, ensuring consistency across multiple sources including Salesforce, Braze, and front-end tracking. This enabled the teams to have reliable, harmonized data for monthly reporting and operational decision-making. 🔹 BI dashboards & visualization I delivered Looker reports for all teams and proposed Tableau dashboards to enhance visualization and decision-making. I conducted demos to showcase Tableau’s added value, helping the company increase adoption and elevate their data visualization capabilities. 🔹 Cross-functional collaboration Partnering closely with business owners, I ensured that all reports were aligned with operational needs, accurate, and actionable. I also coached teams on best practices in SQL and BI reporting & internal documentation. ✅ Impact Delivered a consistent and reliable data foundation for Sales, CRM, and Marketing, enabling executives and teams to make informed decisions and improving the adoption of BI tools across the company.

- Intervenante professionnelle auprès des étudiants de Master 2 CEEM (UPPA) sur un module de 15h visant à acquérir les bases en Python et Tableau. Le développement de ces compétences s'effectue au travers de use cases business et plus récemment avec une introduction sous la forme d'escape game data créé sur mesure pour les étudiants. - Intervention Ad'hoc auprès du corps enseignant, pour le développement des compétences Tableau.

Implementation of automated tools in order to manage inventory and product arrivals easily as part of a website redesign. Volunteer work for a small local company - Automated solutions to clean existing products (description, name, pictures, brand, categorie, stocks) - Automated solution to create more easily new products arrivals - Wordpress website clean & redesign

FinTech Unicorn – Paris (Remote with regular on-site workshops) At Qonto, I supported both the Growth BI and Finance BI teams, leading projects essential for the company’s scale-up journey. 🔹 Growth BI – Marketing & Acquisition Data Due to the GA → GA4 migration, Qonto risked losing full visibility on acquisition performance. I rebuilt the tracking framework internally using Segment and DBT, recreating sessions, customer identities, and extracting website channel data to maintain complete coverage for marketing analysis. Working with the Data Engineering and Business teams, I integrated ads platforms APIs (Facebook, TikTok, LinkedIn, etc.) with budget data to calculate CAC, ROI, and channel efficiency. As a result, Growth and Product teams had a reliable and comprehensive dataset with Tableau dashboards, and I became the referent for acquisition tracking data, supporting product managers and marketers on governance, quality, and actionable recommendations. 🔹 Finance BI – Strategic KPI definition I led the definition and rollout of a new company-wide KPI to improve how customer activity is measured for investors and internal reporting. This required alignment with Finance, Growth, and Product stakeholders, iterative testing of KPI definitions, and implementation in DBT. I coordinated BI developers to roll it out across all Tableau dashboards, establishing it as a trusted reference metric for strategic business reporting. 🔹 Additional contributions I also created and maintained other Marketing, Finance, Sales & CRM Tableau dashboards, trained stakeholders on data literacy, and promoted best practices in SQL, DBT, and Git. ✅ Impact Strengthened Qonto’s ability to measure marketing efficiency and financial performance, providing executives with reliable, actionable insights in one of Europe’s leading FinTech unicorns.

Monitoring de la performance : acquisitions & revenus Tableau Software - SQL - Python - R Google Analytics - Emarsys Stripe - Braintree

Analyse de données, Modélisations, Etudes de marché, Géo marketing & Data visualisation Relation client, gestion de projet Formations aux fondamentaux de l'analyse statistique pour nos clients dans le marketing

Pôle Services : Transport, Télécoms, Énergie, Banques, Assurances Lancement d'études, analyse des résultats, relation client Expertise : Analyse conjointe (Trade off), Data Visualisation, Brand Image, lancement de produits, pré-test & post-tests publicitaires

Service Marketing, Marché des jeunes : Développement de projets sur le marché jeunes : attrition, opérations de rentrée, analyse de la concurrence, connaissance clients et customer journey