Ferhat CHALA

Experience

• 

  AIR ALGÉRIE

  Oct 2021 - Jul 2022

  BI & Data Intern

  During my internship at Air Algérie, as part of graduation project i led the design and development of a complete end-to-end BI solution focused on Budget and transportation analysis. This project involved the design of robust data warehouse, ETL' and accurate data models and the creation of intuitive dashboards. As a result of this experience, I have enhanced my skills in translating complex business requirements into actionable insights, which has strengthened my expertise in BI and data analytics. Show less

• 

  ITComp-dz

  Dec 2022 - May 2023

  Database Consultant
• 

  IT Solutions Algérie

  May 2023 - now

  BI Consultant
• 

  Insight 360

  May 2023 - now

  Data Analytics Consultant

  As BI Consultant at Insight 360, I have worked on several big projects. I was involved in all phases of the project lifecycle (Design, Environment Configuration, Development, Deployment, Testing, Quality Control, etc.), my main tasks are : • Business requirements gathering.• Design and Development of ETL’s within SSIS, and writing complex SQL Queries for data retreving and pre-processing.• Design and Development of Analysis Services Models SSAS (Data Modeling, creating complex measures with DAX, Managing relationships, Row Level Security within SSAS).• Design and Development of Dashboards & Power BI Reports (High-Quality UI/UX, Managing permessions and Row-level security …)• Setup and configuration of production environment, overseeing more than 10 servers including Data Warehouse (DWH), SSAS, ML, PBI RS, RPA ...). Managing high-availability and scale-out deployment for Power BI Report Servers and Analysis Services Servers, as well as implementing Network Load Balancing to ensure optimal performance and high availability.• Performance Optimization for ETL’s (Incremental Load), SQL Queries, SSAS Models and Power BI Reports• Quality Control for the ETL solution , SSAS Models and Power BI Reports.• Collaborate with AI team to integrate ML Models and build scalable analytics solution (Creation of API’s using FastAPI to integrate Dynamic AI Results to Power BI).• Technical documentation. Show less