You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Ammari YacineAY

Ammari Yacine

Data Analyst

€600/day
Athis-Mons, FR
8-15 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Ammari

Expert Power BI & BI Architecture — 10 years of experience with major accounts
I design and maintain reliable decision-making solutions for companies that need actionable data, not just pretty dashboards.
My core business: advanced semantic modeling (DAX, Power Query, star schema), BI architecture (DWH, Data Marts, cloud integration with Synapse and Snowflake), and application management (MCO/RUN).
I cover the entire chain — from data source to business reporting.
Recent references: France Télévisions (since Feb. 2024), Saint-Gobain, TKH Group.
I work in both project mode (scoping, specs, delivery) and TMA/RUN (maintenance in operational condition, support, SLA).
And when it's useful, I train teams to make them autonomous.
Environments mastered: Power BI (Service, Report Server, DAX Studio, Tabular Editor, RLS), SAP BusinessObjects, Talend, SSIS, SQL Server, Oracle, Snowflake, Synapse Analytics.
Based in Île-de-France. Available for full remote or hybrid.
  • French

    Native or bilingual

  • English

    Fluent

  • Arabic

    Native or bilingual

Can work on-site
Athis-Mons (up to 50km)

Experience

  • FRANCE TÉLÉVISIONS
    Power BI Decision Support Consultant
    PRESS AND MEDIA
    February 2024 - Today (2 years and 6 months)
    Paris, France
    Business Needs Analysis and BI Development
    ▸Needs Analysis: In-depth analysis of business requirements to optimize BI solutions, in collaboration with relevant departments
    ▸Data Sources: Identification and evaluation of relevant sources (including Oracle OTBI), ensuring data quality and relevance
    ▸Backlog & Prioritization: Structuring requests (evolutions/corrections), prioritizing with business referents, preparing delivery batches
    Power BI Design and Implementation
    ▸Decision Modeling: Development of custom data models (facts/dimensions, granularity, relationships); design of semantic models for business consumption
    ▸Advanced DAX: Development of measures (KPIs, comparisons, cumulative, variations), filter context management, BLANK/0 robustness, total reliability
    ▸Power Query / M: Transformations, field normalization, data type management, quality controls
    ▸Dataviz: Creation of interactive dashboards, detailed reports, and visualizations; reliability and accuracy testing
    Power BI Service Administration — MCO
    ▸Service & Deployment: Workspace administration, publication/deployment, gateway and refresh configuration, maintenance in operational condition, SLA monitoring
    ▸Security & RLS: Implementation of roles, security perimeters, and Row-Level Security testing
    ▸RUN / Support: Handling incidents and change requests, root cause analysis, coordination with project managers and users
    Training, Support, and Technology Watch
    ▸Training: Training end-users on Power BI to maximize their autonomy and productivity
    ▸Documentation: Writing detailed documentation including best practices and maintenance procedures
    ▸Technology Watch: Maintaining knowledge of BI innovations and best practices; evaluating new features
    Microsoft Power BI Data Analysis Microsoft Excel DAX Language M Language
  • Saint-Gobain
    Power BI Decision Support Consultant
    RAW MATERIALS INDUSTRY
    August 2023 - February 2024 (6 months)
    Paris, France
    Business Needs Analysis and Collaboration
    ▸Needs Analysis: In-depth analysis of BI needs in collaboration with business departments, precise identification of data sources
    ▸Data Quality: Analysis of existing data to ensure its quality and suitability for business expectations
    BI Modeling and Data Engineering Expertise
    ▸BI Architecture: Definition of target models (facts/dims, granularity, keys) for sustainable and maintainable models
    ▸Data Engineering Guidance: Review and challenge of models, 'data layer vs Power BI' arbitration to limit technical debt
    ▸Cloud: Integration of Synapse Analytics and Snowflake sources into Power BI models
    Power BI Design and Development
    ▸Power BI: Design datasets, dashboards/reports (navigation, drill), standardization of visuals for group alignment
    ▸DAX & VertiPaq: Development and optimization of measures, multi-granularity reliability, diagnosis and reduction of load times
    ▸Industrialization: Testing, functional validation, technical documentation, training and support; writing specifications for evolutions
    Microsoft Power BI Power BI DAX SQL M Language
  • ADALTRA (ex : CAE-Groupe)
    Deputy CIO / BI & Data Consultant
    RAW MATERIALS INDUSTRY
    April 2020 - August 2023 (3 years and 4 months)
    Massy, France
    Deputy CIO — IT Strategy and Governance
    ▸IT Strategy: Development of the Industry Division's IT policy, identification of investments, compliance of specifications
    ▸IT Budget: Establishment and monitoring of the budget, cost control, management of service providers and subcontractors
    ▸Performance & Continuous Improvement: Monthly IT KPI monitoring, continuous infrastructure improvement, planning of evolutions
    ▸HR Management: Leadership of the IT team, skills development, administrative personnel management
    ▸Risk & Security: IT risk management, backup of critical data, availability and performance of tools
    Key Projects
    ▸ERP Sage X3 V6.5: Implementation for purchasing, inventory, and sales across all subsidiaries
    ▸E-commerce: Creation of an online sales department under direct management, significant revenue increase
    ▸WMS: Implementation of a warehouse management solution to optimize logistics operations
    ▸CRM Fresh CRM: Needs assessment, integration, and deployment support
    Decision Support Consultant — Data-BI Domain
    ▸DWH / Data Marts Modeling: Design of the data warehouse (Merise), Power BI dashboards, DAX/M measures, performance optimization
    ▸ETL Talend: Automation and maintenance of flows, proactive monitoring in production
    ▸Power BI Report Server: Installation, DEV/TEST/PROD configuration, security, deployments, migrations, server performance optimization
    ▸Versioning: Implementation of Git + MediaWiki to track changes and secure maintenance
    Microsoft Power BI Power BI DAX SQL Data Analysis

Recommendations

Be the first to recommend Ammari

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • Specialized Master in Business Intelligence
    EISTI
    2016

Skill set (9)

Categories