Yaakoub FAJRAOUI

Designed and industrialized Power BI dashboards for retail performance (pricing, sales, store operations). • Built and optimized data pipelines in Azure Databricks using SQL and Python notebooks (ingestion, transformation, data quality). • Improved query performance and harmonized SQL development practices across BI workflows. • Conducted validation and performance testing to ensure indicator reliability across source systems. • Collaborated with business teams (Pricing, Finance, Operations) to translate requirements into scalable data models. • Prepared and validated mockups with UX and BI teams to align technical feasibility with business expectations. • Contributed to Agile ceremonies, challenged requirements, and supported continuous improvement of the BI ecosystem. • Reported progress, risks, and technical decisions to the BI manager. Keywords: Power BI, Databricks, SQL, Python, Retail BI, Data Modeling, Agile

• Led BI initiatives across international regions (AMER, India, North Asia, Europe). • Migrated reporting solutions to a unified Google Cloud Platform with Power BI in DirectQuery mode. • Standardized modeling and development best practices to optimize BI performance. • Executed performance testing campaigns and presented results to top management. • Coordinated with regional project teams and Microsoft BI Center of Excellence to resolve performance issues. • Worked with Finance to build Power BI–GCP solutions for product price monitoring, margin calculations, and pricing strategy. • Collaborated with UX design and business teams on mockups and technical validation. • Managed a team of 3 Power BI developers and aligned workloads with business priorities. • Prepared technical environments: Power BI Service, service accounts, AD groups, Premium capacity, performance tests. • Participated in business workshops to explain BI concepts and challenge requirements in an Agile (Scrum) context. • Reported progress, blockers, and deliverables to the Sunrise Program Director. Keywords: Power BI, GCP, DirectQuery, UX, Data Architecture, Agile Scrum

Led workshops with business teams to capture reporting needs. • Wrote functional & technical specifications for BI solutions. • Built Power BI datasets, data models, and performance-optimized reports. • Supported Power BI users and conducted training sessions. • Executed performance tests via DAX Studio. • Assisted business teams in manipulating reporting tools and validating indicators. Keywords: Power BI, Power Query, SQL, Oracle, Databricks, Power Automate

• Designed and delivered Power BI reporting solutions (On-premise & Azure). • Defined BI architectures and delivered project planning for Power BI initiatives. • Coordinated between business and development teams. • Modeled and enriched data warehouses for Finance reporting. • Provided Level 0–3 Power BI support, troubleshooting complex issues. • Managed Power BI Report Server platform and SSAS servers (incidents, deployment, access). • Developed SSAS Tabular models and Python/R analytics embedded in Power BI. • Conducted performance tests and optimization via DAX Studio. • Designed and delivered Power BI training materials and facilitated hands-on sessions. Keywords: Power BI, SSAS, DAX, Power Platform, Python, R, T-SQL, Trino, Azure

Data Analyst / Forecast Analyst • Built forecasting models for national electricity demand. • Developed BI dashboards (Power BI, R Shiny) and preprocessing tools. • Authored functional specifications for renewable energy forecasting systems. • Trained dispatchers on time-series analysis and forecasting methods. Keywords: Power BI, R, Python, Time Series, Energy Forecasting