Freelancer profile translated to English.
Back to original languageAbout Otmane
◉ A little about me ⤵︎
👨💻 I am a consultant in **Power BI**, **SQL**, and **data automation**.
🎓 Le Wagon Certified.
⚙️ +80DAXmeasures audited on a single project, manual exports eliminated across all my assignments.
🧑💼 4 years of experience in data visualization and activity monitoring.
The data is never lacking in a company; it's their readability that is missing.
A slowdashboardcosts more than an audit.
Each delivery is accompanied by a skills transfer, not a dependency.
◉ My references ⤵︎
Animal Health Network, Bookstore, Concierge Service
◉ Here are the missions I undertake**⤵︎**
Power BI | Dashboard Creation | Data Visualization
- Audit of existing Power BI models: DAX measures, anomalies, refresh performance.
- Buildingdashboardsfrom scratch for activity monitoring, adapted to each user profile (management, HR, operations).
- Centralizing data from multiple business platforms into a single source of truth.
- Implementing profile-based restricted access and custom criticality indicators.
- Automating refreshes to eliminate manual exports.
- Documentation and skills transfer with each delivery to ensure internal adoption.
- Fast delivery with an action plan and prioritized implementation roadmap.
SQL | ETL | Automated Reporting
- Connecting and structuring multiple data sources (business platforms, exports, SQL databases).
- Defining the data reliability strategy: detecting and correcting anomalies.
- Building ETL pipelines to automate data collection and updates.
- Implementing data validation processes before dashboards go into production.
- Tracking and reporting progress on each data centralization project.
Available 7 days a week via Malt messaging.
Response within an hour.
French
Native or bilingual
English
Fluent
Remote only
Primarily works remotely
Experience
- TANGKOKO
On Malt
Implementation of Power BI DashboardsE-COMMERCEJune 2026 - July 2026 (1 month)Design and delivery of a complete business intelligence Power BI report for a concierge service company, on assignment through an intermediary data agency.
**Scope**:4 analysis axes consolidated in the same report — e-commerce KPIs (Magento), email marketing performance (Mailjet), booking activity (SimplyBook), and product analysis / RFM customer segmentation.**Work performed**:- Star semantic modeling on Azure MySQL warehouse: fact tables, calendar and 3-level categorical hierarchy dimensions, handling granularity breaks (daily vs. monthly) using DAX.
- Development of 65 DAX measures (conversion KPIs, open and click-through rates, fill rates, RANKX rankings, RFM scoring).
- Data ingestion via API: Python pipeline on Mailjet (REST) and SimplyBook (JSON-RPC + REST) APIs, with handling of edge cases (slots spanning midnight, exclusion of test accounts) and upserting into the database.
- Security: implementation of multi-role Row-Level Security to partition data by entity.
- Design: full application of the client's graphic charter (palette, typography, custom Power BI theme).
- Industrialization: report versioning in PBIP/TMDL format under Git, delivery of a business KPI dictionary and technical documentation with a complete DAX appendix.
- FovéaData Architect / Power BIFebruary 2026 - March 2026 (1 month)Supporting a fast-growing multi-site group (network of 30 establishments) in auditing, validating, and strategically restructuring its financial and operational reporting system.Key missions and achievements:- Technical Audit & Reverse Engineering: Complete diagnosis of a complex existing Power BI model (dozens of tables, Power Query flows, heavy data model). Precise identification of technical debt, bottlenecks (DAX code optimization), and modeling flaws (fragile join keys) limiting scalability.- Global Data Flow Mapping: Analysis and documentation of the data ecosystem, integrating multiple heterogeneous sources (specialized business software, accounting ERP, HRIS, complex manual exports).- Data & Finance Governance: Close collaboration with the Financial Department and Management Control to harmonize analytical repositories, unify KPI definitions, and ensure strict reconciliation between operational data and accounting.- Strategy & Architecture: Development of an exhaustive audit report including a risk register and a strategic recommendation (Go/No-Go). Design of a roadmap to migrate from manual management to an automated, robust, and centralized data architecture (star modeling, API integration).Technical Environment: Power BI, Power Query (M), DAX (performance optimization), Data Modeling (star schema), BI diagnostic tools, REST API integration, ERP/HRIS systems.
- One educationPower BI ConsultantOctober 2025 - November 2025 (1 month)Supporting a training and education organization in modernizing its activity monitoring through the design and deployment of a suite of automated dashboards.Key missions and achievements:- Audit & Scoping: Analysis of the needs of different stakeholders (Management, Managers, Operational Teams) to define key financial and operational performance indicators (KPIs).- Data Modeling & Processing (ETL): Extraction, cleaning, and structuring of complex data from the internal management software (ERP) using Power Query and DAX.- Creation of a suite of 5 custom Dashboards (Power BI):- Management Dashboard: Consolidated view of revenue, cash receipts, and remaining to be collected.- Operational Monitoring: Optimization of the invoicing process and file transmission to funding bodies.- Treasury Management: Daily monitoring of outstanding amounts, bad debts, and optimization of reminders.- Quality & Governance: Implementation of a tool for anomaly detection to ensure the reliability of source data.- Technical Workaround Strategy: Faced with the client's software's native export limitations, designed an alternative workflow to ensure regular and secure data refreshes.- Change Management: Writing comprehensive technical documentation (guides and summary notes) and leading skills transfer sessions to ensure team autonomy.Technical Environment: Power BI, Power Query, DAX, Data Modeling (star schema), Management ERP, Excel / CSV.
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
- Data Analytics BootcampLe Wagon2025Data Analytics Bootcamp
- Master in International Economic and Financial StrategiesUniversité Nice Sophia Antipolis2013Master
Certifications
- Python SpecializationUniversity of Michigan - Coursera2025