Freelancer profile translated to English.
Back to original languageAbout Achraf
Many companies still drive their decisions on intuition: scattered data, manual Excel reporting, and a lack of architecture to transform their data into reliable information. Without a structured data pipeline, from collection to dashboard, data remains an untapped volume rather than a true decision-making lever.
I am a Data Analyst & BI Consultant, with a dual background in Finance, Management Control, and Information Systems. I help companies transform their data, from collection and flow structuring with SQL, Python, and Azure, to data modeling, process automation, and the creation of Power BI dashboards tailored to the needs of business teams and management.
My added value lies in a dual understanding: technical and business. I don't just produce reports; I understand the indicators used to steer a company: margins, cash flow, inventory turnover, sales performance, or budget variances. This approach allows for the construction of data solutions aligned with operational and financial challenges.
Through my experiences at AbbVie, Marjane Holding, and Les Cafés Caron, I have contributed to structuring data, automating reporting, and developing Power BI steering tools to improve the reliability of analyses and facilitate decision-making.
I also integrate automation and artificial intelligence solutions with Python and Power Automate to reduce repetitive tasks, improve process reliability, and accelerate access to information.
Do you want to make your data more reliable, automate your reporting, and implement steering tools that are actually used by your teams? Let's chat via video call to identify your challenges and define an approach adapted to your context.
French
Native or bilingual
English
Fluent
German
Basic
Can work on-site
Paris (up to 50km), Lyon (up to 50km), Toulouse (up to 50km), Rennes (up to 50km), Nantes (up to 50km)
Experience
- Zylio
On Malt
Data Analyst - Purchase Data Analysis & Steering Dashboard (Excel & PowerPoint)DIGITAL AND ITJanuary 2026 - February 2026 (1 month)Paris, FranceExpert and urgent intervention for a consulting firm aiming to identify savings opportunities on multi-site invoices.Objectives & Scope:Analyze a sample of purchase prices to detect invoicing anomalies.Transform raw data into actionable insights for presentation to the Management Committee.Technical & Data Management Achievements:Data Cleaning: Cleaning and structuring complex CSV exports in Excel.Data Reconciliation: Mapping heterogeneous labels and product codes to enable reliable comparison.Variance Analysis: Calculating inter-site price differences and identifying pricing deviations for the same product references.Modeling: Creating a potential savings simulation tool.Deliverables & Synthesis:Steering Dashboard: Design of a dynamic and automated Excel dashboard.Presentation Support: Creation of "Executive" slides in PowerPoint for a strategic and synthetic presentation.Results & Impact:✅ Immediate highlighting of significant price differences between various consumption sites.✅ Decision support tool finalized and delivered in less than 48 hours (ASAP mission).Technical Environment: Expert Excel (Power Query, Pivot Tables, Light DAX), PowerPoint, Purchase Data Analysis. - AbbVieData Analyst – Power BI, Snowflake & Reporting AutomationPHARMACEUTICALS INDUSTRYMarch 2025 - October 2025 (7 months)Rungis, FranceI supported AbbVie (an international biopharmaceutical leader) in transforming its decision-making environment to strengthen the Data-Driven culture, ensure the reliability of KPIs, and automate the steering of Marketing and Financial performance.
- Challenges & Data Strategy
Centralization of heterogeneous data sources and definition of strategic KPIs: Marketing ROI, P&L, budget tracking, sales performance.Structuring data to provide a reliable and actionable vision for business teams and management.- Data Engineering & Architecture
Design of a Star Schema data model to optimize BI analyses and performance.Utilization of Snowflake Data Warehouse with Raw / Staging / Analytics layer organization.Development of ETL/ELT pipelines with SQL and Python to clean, transform, and automate data flows.Implementation of automated refresh processes ensuring a Single Source of Truth.- Business Intelligence
Creation of Power BI dashboards with advanced DAX measures for performance monitoring and decision-making analyses.Design of a user experience adapted to business needs and implementation of Row Level Security (RLS) rules.- AI & Data
Implementation of Snowflake Cortex AI and a conversational AI Agent allowing business users to query data in natural language without SQL skills.Facilitating access to Finance and Marketing insights through a Natural Language Analytics approach.Results
- Data reliability and reduction of manual processing.
- Acceleration of reporting production.
- Improved autonomy of business teams in analysis and decision-making.
- Anne Caron le café de spécialitéData Analyst & Engineer | BI, ETL & Cloud ArchitectureRETAIL (LARGE RETAILERS)October 2022 - October 2024 (2 years)Saclay, FranceFull oversight of the Data strategy for a fast-growing SME (Retail/E-commerce). Critical challenges: Supply Chain, Finance, and Omnichannel.Mission:Orchestration of digital transformation: moving from manual Excel reporting to an automated, real-time, and scalable Business Intelligence platform.Engineering & Architecture Expertise (Back-end):
- ETL Pipeline Construction:Development of automated flows to unify massive and heterogeneous sources (SQL Server, PostgreSQL, PrestaShop & Shopify APIs, ERP).
- Data Modeling:Complex data architecture in Star Schema within Power BI to optimize calculation times and reliability.
- Automation:Python scripting for multi-source data cleaning and integration.
- Governance & IS:Participation in the IS Master Plan and implementation of Data Quality and security protocols.
Business Intelligence & Insights (Front-end):- Power BI Expert:Design of strategic dashboards for the Executive Committee and operational management.
- Business KPIs:Fine-tuned steering of Margins, Treasury (Cash Flow) analysis, Inventory Turnover, and Sales Performance.
- Advanced DAX:Development of complex measures for comparative analyses (Year-over-Year, LFL).
Business Results & Impact:- Productivity:Elimination of 80% of manual processing time (transition from several days of processing to instant updates).
- 360° Visibility:Full reconciliation of E-commerce and Physical Store data flows.
- ROI:Direct support for strategic decision-making, optimizing working capital requirements (BFR).
Technical Stack:Power BI, DAX, SQL Server, Python, ETL, Azure, Shopify API.
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 in Information Systems ManagementIAE de Brest2024🎓 Expertise Data Engineering & BI : Cycle de vie de la donnée : Maîtrise avancée de SQL, Python (Pandas/Numpy) et automatisation via VBA. Architecture Décisionnelle : Conception de systèmes BI, modélisation d'entrepôts de données (Data Warehouse) et automatisation des flux ETL/ELT. Intelligence Artificielle : Application du Machine Learning et de l'IA aux problématiques SI d'entreprise. ⚙️ Pilotage de Projets & Architecture : Gestion de Projets SI : Méthodes Agile (Scrum), Lean Management et pilotage de la transformation digitale. Urbanisation des SI : Mise en œuvre d'ERP (MS Dynamics 365) et alignement des infrastructures Cloud (Azure). Audit & Gouvernance : Audit organisationnel, conduite du changement et sécurité des systèmes d'information. 📈 Stratégie & Performance : Gouvernance des données : Mise en place de référentiels de données (Master Data Management) et conformité. Pilotage de la Performance : Définition de KPIs stratégiques et tableaux de bord de gestion (Balanced Scorecard). Valeur ajoutée : Vision transversale permettant de lier l'infrastructure technique aux objectifs business de la direction.
- Master in Finance and Management ControlUniverisapolis - Agadir2020📊 Pilotage de la Performance & Stratégie Financière : Maîtrise des cycles financiers : Expertise en suivi budgétaire, analyse des écarts et construction du P&L. Comptabilité Analytique : Calcul de coûts de revient complexes, analyse de la rentabilité et audit financier. Gestion de la Trésorerie : Optimisation du BFR et pilotage des flux de Cash-flow. 💻 Modélisation & Ingénierie Financière : Modélisation Avancée : Conception de modèles financiers complexes sous Excel et mise en place de scénarios prévisionnels (Forecasting). Automatisation du Reporting : Digitalisation des processus financiers via VBA et Power Query pour supprimer les tâches à faible valeur ajoutée. Architecture de KPIs : Définition d'indicateurs de performance fiables, audités et alignés sur les objectifs de la direction. 💡 Valeur ajoutée "Finance-to-Data" : Expertise hybride permettant de traduire les besoins critiques des Directions Financières (DAF) en architectures techniques Data-driven précises. Je garantis la fiabilité de la donnée financière tout au long de sa transformation.
Certifications
- Google Data Analytics Professional CertificateGoogle2026