Freelancer profile translated to English.
Back to original languageAbout Oualid
You have data. It doesn't yet tell you what you need to do. That's my job.
Data & Business Analyst with 15 years of experience at the intersection of data, marketing, and commercial performance. I intervene where data exists but has not yet been translated into concrete decisions.
I work on commercial steering, marketing and CRM analysis, customer segmentation, sales reporting, and Power BI dashboards... for SMEs, scale-ups, and large groups.
References: Nespresso France, eYeka (433K users, 187 countries), AXA.
What I build
● **Commercial and Sales Performance Analysis**: sell-out steering, channel and circuit analysis, sales KPI monitoring, promotion and pricing impact studies, competitive analysis.
● **CRM and Segmentation Analysis**: RFM segmentation, behavioral scoring, churn and attrition analysis, identification of retention levers, database qualification and cleaning.
● **Digital Marketing and Acquisition Analysis**: SEA, social ads, and emailing campaign performance, A/B testing, conversion funnel optimization, multi-channel reporting.
● **Dashboards and Reporting**: data modeling, automated Power BI dashboard design, multi-source integration, decision-oriented presentation for non-technical users.
● **Automation and Applied AI**: implementation of automated workflows (Power Query, Python) and use of generative AI tools to accelerate processing, generate code, and produce analyses faster.
● **Ad hoc Analyses**: exploratory studies, cross-referencing heterogeneous sources, data storytelling, actionable recommendations presented to management.
Stack
Power BI · SQL · Python (Pandas, NumPy, Scikit-learn) · Advanced Excel (Power Query) · Google Analytics · Salesforce · Google Data Studio · AB Tasty · Kameleoon
Languages
Native French · Bilingual English · Native Arabic
French
Native or bilingual
English
Native or bilingual
Arabic
Native or bilingual
Can work on-site
Paris (up to 20km), Châtillon (up to 10km)
Experience
- Auto-entrepreneurIndependent Data Analyst ConsultantCONSULTING AND AUDITSJanuary 2023 - Today (3 years and 7 months)Paris, France● **Commercial and Marketing Analysis**: consolidation of multi-source data (CRM, sales, digital, field), cleaning and structuring, identification of priority performance levers, actionable recommendations for non-technical decision-makers.● **Sales Steering and Reporting**: design of automated Power BI dashboards for commercial and marketing monitoring — sales steering, lead and conversion tracking, campaign performance, field activity, decision-making KPIs.● **CRM and Segmentation Analysis**: RFM segmentation, behavioral scoring, churn and attrition analysis, customer database qualification and cleaning, implementation of effective customer tracking logic.● **Modeling, Automation, and Applied AI**: audit of existing databases, data model design, workflow automation (Power Query, Python), and use of generative AI tools to accelerate processing and produce analyses faster.● **Ad hoc Analyses and Data Storytelling**: rapid response to urgent business questions, impact studies, decision-oriented presentation for management.🛠️ Power BI · SQL · Python (Pandas, NumPy) · Excel Power Query · CRM · Google Data Studio
- Nespresso FranceData & Business AnalystAGRICULTUREOctober 2023 - April 2025 (1 year and 6 months)Paris, France
Business & Data Analyst – Nespresso France
📍 Commercial Development Department | Trade Marketing & Machine Sales📅 2023 – 2025**Mission**:Build and automate a comprehensive analytical system to support commercial performance, from sell-out sales monitoring to measuring the impact of field actions, to inform decisions of the commercial and trade marketing management.**My contributions**:● **Commercial and Sell-Out Sales Steering**: weekly and monthly sales analysis by circuit, banner, and commercial sector, translated into actionable recommendations for trade teams.● **Power BI Modeling and Dashboards**: design of data models and automated reports that have become the reference tools for decision-making by the commercial department.● **Trade Impact Studies (4Ps)**: analysis of the effects of promotions, pricing, visibility, and field activities on volumes, conversion, and ROI.● **Competitive and Market Analysis**: monitoring market dynamics, competitor commercial strategies, GfK data, identification of priority levers.● **Data Consolidation and Validation**: collection, cleaning, and structuring of multi-source data (CRM, store sales, 4P field reports, GfK market data) to ensure analysis quality.● **Data Flow Automation**: implementation of automated workflows (Power Query, Salesforce) to ensure continuous data availability without manual intervention.● **Strategic Ad hoc Analyses**: response to urgent business arbitration requests, regular presentation of insights to commercial and marketing management.● **Data Referent and Support**: single point of contact for teams on all data-related topics, daily tool maintenance, operational support.🛠️ Power BI · Excel Power Query · SQL · Salesforce · PowerPoint · Sell-Out KPIs · Retail Dashboards · 4P Logic - eYekaData & Digital Marketing ManagerCONSULTING AND AUDITSJanuary 2014 - December 2022 (8 years and 11 months)Paris, France
Data & Digital Marketing Manager – eYeka
📍 Paris – International creative crowdsourcing platform📅 2014 – 2022**Mission**:Steer the performance and growth of a global digital co-creation platform by leveraging data to optimize acquisition, engagement, and retention.**My contributions**:● **Digital Analytical Steering**: monitoring key KPIs (acquisition, engagement, retention, churn, product) via dashboards, data extraction, and regular exploratory analyses.● **CRM and Segmentation Analysis**: advanced segmentation, behavioral scoring, automatic profile qualification, database cleaning, and anti-bot measures.● **Churn Modeling and Loyalty**: attrition analysis, predictive churn modeling, implementation of targeted engagement levers (onboarding, gamification, scoring, loyalty programs differentiated by segment).● **Analysis and Reporting**: creation of B2B and B2C reports for management and clients, ad hoc analyses for project and sales teams.● **Testing and Optimization**: design and monitoring of A/B tests on user journeys, landing pages, and campaigns to optimize the conversion funnel and acquisition rates.● **Digital Acquisition Campaigns**: creation and optimization of SEA, social ads, emailing, and display campaigns, budget management, and continuous improvement based on performance data.● **Product and UX Management**: writing functional specifications, user testing, UX/UI monitoring in collaboration with tech and design teams.● **Data Storytelling**: presentation of performance and strategic recommendations to management and clients, with simplification of insights for non-technical teams.🛠️ Google Analytics · Google Data Studio · Excel · Python · Salesforce · Google Ads · Facebook Ads · Kameleoon · AB Tasty · Digital Analytics · CRM · A/B Testing
Reviews
Recommendations
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 DegreeUniversity of Reims Champagne-Ardennes2010Marketing Stratégique
- Master's DegreeISTEC2011Marketing Digital & Opérationnel
Certifications
- Data Analyst with PythonDataCamp2023
- Python complete courseUdemy2023