Freelancer profile translated to English.
Back to original languageAbout Karim
I am a senior Data & Business Intelligence consultant, specializing in the design, optimization, and governance of Power BI and SQL Server solutions. With over 12 years of experience in data, I have supported major groups (industry, health, retail, finance) in building robust data models, strategic dashboards, and high-value-added automation processes.
Core expertise:
• Power BI (DAX/M modeling, RLS, performance, governance, CI/CD via pbi-tools and GitHub)
• SQL Server, SSIS, Tabular Editor, Azure Data Factory, Fabric
• Multidimensional & SSAS cubes modeling
• Data architecture, ETL automation (PowerShell, Excel VBA, API)
• CRM integration (Salesforce, Factorial, X3, Sylob)
• Deployment and maintenance of financial, sales & supply chain reports
My approach combines strategic vision and technical excellence to transform data into operational decisions and performance levers. I am involved in both dashboard design and the implementation of complete BI environments (Dev/Test/Prod, automation, monitoring).
Keywords: Power BI, SQL, SSIS, Tabular Editor, Azure, CI/CD, Data Modeling, ETL, Reporting, KPI, Dashboard, DAX, Fabric, Business Intelligence, Data Architecture, Data Strategy.
French
Native or bilingual
English
Native or bilingual
Can work on-site
Paris (up to 50km)
Experience
- LUMIBIRD GROUPHead of Data & BIOctober 2023 - Today (2 years and 8 months)• Developed and executed a BI roadmap aligned with business objectives.• Manage Business intelligence report and systems for 10 different countries.• Led a team in designing Power BI dashboards to provide actionable insights across Finance, Sales, and Operations.• Managed gross margin analysis, KPI tracking, and financial reporting, optimizing data efficiency.• Collaborated with cross-functional teams to improve data consistency and system integration.• Delivered enhanced data visualization tools to support strategic decision-making.
- Krème
On Malt
Implementation of Power BI dashboards for sales performanceE-COMMERCENovember 2023 - November 2023🔹 Data & IntegrationsSellsy API Connection (OAuth2) – Automated extraction of invoices + invoice linesOpenPharma and external databases importMulti-source consolidation (Excel, API, internal repositories)Creation of an optimized data model (star schema), relationships, DAX tables, complete Date dimension (business days, quarters, semesters)🔹 Data Engineering / Power QueryAdvanced cleaning (establishment matching, commercial mapping, sector correspondence)Reconstruction of product/invoice line granularitySales type detection: opening, restock, new products (based on SKU catalog rules)API performance and pagination optimization🔹 Business KPIs DevelopedTotal revenue, Monoprix revenue, new product revenue, restock revenue, store revenueCustomer/salesperson/sector targets per quarterRevenue/Target ratio, real-time projectionsNumeric Distribution (DN), Shelf Space (PDL)Rankings: top delegations, top products, top customersElapsed business days vs. total quarter (% time elapsed)Complex DAX measures (X functions, table expressions, variables)🔹 Scorecard & DashboardsQuarterly sales scorecardGlobal view + Monoprix, new products, categories viewsAnalysis by sector, salesperson, regionAdvanced visuals: target donuts, heatmaps, dynamic bars, automatic ranking, customer segmentationProfessional design & optimized navigation🔹 DeliverablesComplete PBIXModel documentation + business rulesVersion filterable by salesperson/sectorRefresh automation & production deployment - ALIRA HEALTH SASPOWER BI SMEPHARMACEUTICALS INDUSTRYNovember 2021 - November 2023 (2 years)Paris, FranceDeveloped and maintained data models using Power Query and DAX to ensure accurate and efficient data analysis.Created visually appealing and insightful reports and dashboards using Power BI Desktop and Service to support business decisions. Collaborated with stakeholders and business users to gather requirements and ensure the solutions met their needs.Managed project timelines, budgets, and resources using Agile methodologies and project management tools.Provided technical guidance and mentorship to junior team members to improve their skills and knowledge.Conducted training sessions and workshops for business users to improve their data literacy and adoption of BI solutions and successfully implemented BI solutions that significantly improved operational efficiency and business performance.Streamlined data analysis processes, resulting in faster and more accurate decision-making and played a key role in driving the adoption of BI solutions across the organization, resulting in increased data-driven decision-making.Defined the Power BI strategy of the company, which involved identifying key performance indicators, data sources, and business goals to drive successful implementation.Created a new MODEL POWER BI using multiple sources, which involved integrating data from various sources to create a comprehensive and accurate view of business performance. This enabled effective data analysis and decision-making.
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 in Business IntelligenceUniversité de lorraine2013
- Master in Information Systems Audit & Management ControlSKEMA Business school2015
Certifications
- Power BIMicrosoft2019
- Implementing datawarehouseMicosoft2018