Bilal Kharbach

Castel Afrique – Consultant Data Analyst (Core Data Platform) : Participated in the modeling and validation of the Gold layer within the LKH Castel Core Dev workspace. Built and maintained DAX measures and semantic models to support analytics and reporting needs. Created Power BI reports and dashboards using data visualization best practices for performance and usability. Collaborated with data engineers to validate data pipelines, business rules, and model logic. Performed data quality checks and ensured alignment between Silver and Gold layers. Supported the implementation of a dimension/fact star schema aligned with business requirements. Provided actionable insights to internal teams, improving decision-making and operational efficiency. OCP Nutricrops – Consultant Data Analyst (Market Intelligence Data Platform) : Designed and implemented a centralized data platform to replace large Excel-based workflows and manual data exchanges (emails/API). Built standardized and structured datasets to streamline reporting for the Market Intelligence team. Developed a scalable data model enabling future expansion of business needs and data sources. Created automated and user-friendly dashboards to provide real-time insights for internal stakeholders. Collaborated closely with cross-functional teams (BI, Data Engineering, Market Intelligence) to define business requirements and translate them into actionable datasets. Improved data reliability and consistency by defining validation rules and standard KPIs. Contributed to the implementation of Self BI best practices and workspace governance within Power BI.

Project: Interactive Financial Analysis Dashboard – CDG Capital Gestion Requirements & Design: Defined business needs and drafted functional specifications. Development: Developed financial KPIs in Python, benchmarked against market indices. Dashboard & Integration: Created dynamic Power BI dashboards, integrated into a web application via Azure and Power BI API. Result: Delivered a turnkey solution to optimize financial performance analysis and support strategic decision-making. Skills: Python · Power BI · Azure · API Integration · Financial Analysis

Project: Claims Management – Société Générale Maroc Functional Analysis: Drafted specifications, and developed testing and migration strategies. ETL Development: Modeled data in a star schema and built ETL workflows using Talend. Visualization: Designed analytical cubes and interactive dashboards tailored to user needs. Support & Training: Created a user guide and trained teams to ensure successful adoption. Result: Delivered a comprehensive BI solution that improved claims tracking and optimized decision-making with intuitive, high-performance tools. Skills: Talend · ETL · Data Modeling · Star Schema · Dashboard Design · User Training

Project: CVTHEQUE Platform Integration Analysis: Identified functional and technical requirements. Design: Drafted the technical specifications and implemented the database using MongoDB. Development: Built the platform with Angular and Node.js, integrating key features such as PDF CV uploads. Deployment & Maintenance: Set up the system architecture, deployed the solution, and managed ongoing fixes and improvements. Result: Delivered an optimized CV management platform with user-focused features and a high-performance architecture. Skills: Java · TypeScript · Angular · Spring Boot · MongoDB