Yassine Khouali

The objective of this project is to evaluate the existing solution and develop use cases for migrating to Lufthansa's One Data Platform, while ensuring the continuity of current solutions and daily operations. The key tasks include:

o Managing the current on-premise Data Vault solution.

o Providing daily operational support for various business areas, including Flight, Ground, Engineering and Maintenance, Finance, HR and Crew.

o Migrating the ETL solution to a new server.

o Designing a data model for Crew data, encompassing rostering and actual assignments.

o Creating a migration plan to transition to the cloud, aligning with other Lufthansa airlines.

Technologies:

SSIS, T-SQL, TIBCO Spotfire, SQL Server Master Data services

Managing the semantic layer of the solution. Functioning as the bridge between the reporting side and the back-end. Consulting the developers and business users on the best practices for data modeling and Power BI report creation.

Technologies:

Power BI, Azure Analysis Services, Azure SQL, Azure Synapse, Databricks, Azure Data Factory, Azure DevOps

Providing the status (Activity, projects, certifications, rates, etc..) of the back-office employees of Devoteam via an Azure SQL Database solution. The aim of this project is to compare the difference in cost and feasibility between an ELTL process approach with the combination of Azure Data bricks and Azure Synapse and an approach with Azure Data Factory.

o Analyze current solution

o Create Azure SQL Database

o Create landing zone in the Azure SQL Database

o Create Azure Data Factory Pipelines

o Create dimension tables in Azure SQL Database

o Create Fact tables in Azure SQL Database

Technologies:

Azure Data Factory, Azure Data Lake Storage Gen2, Azure SQL Database, T-SQL

Designing and developing a corporate data warehouse and semantic layer about the logistics network planning of Toyota vehicle production parts in Europe

o Analyze Database and business requirement to draft solution architecture

o Complete feasibility study

o Secure data readiness for Digitalization

o Data Analysis

o Data warehousing

o Create landing tables

o Create dimension tables

o Create Fact tables

o Develop ETL pipelines with Integration Services

o Develop the semantic layer in Analysis Services Tabular

Technologies:

SSAS, Azure Analysis Services, SSIS, T-SQL, Power BI

Enabling the business to monitor the progress of railway projects and improve on their processes using Power BI reports.

o Maintaining and developing Power BI reports

o Optimize data model

o Monitor data quality

o Create an ETL task that stores current and historical data with Integration Services

o Data Analysis

Technologies:

SSIS, T-SQL, Power BI, DevOps, Microsoft projects

Providing insight into CBS (Liferay) data. Setting up and retrieving data from the existing CBS platform (Liferay). Creating a Power BI data model, according to the rules of the art, and an eye for the desired complexity (e.g. Time Intelligence). Create a number of standard Power BI reports.

A short training in Power BI for some of the employees, so that afterwards they can get started to create new visualizations themselves.

o Setting up the Data Model (Facts, Dimensions, Time Intelligence)

o Developing Power BI reports

o Handover / Training content creators

o Aftercare

Technologies:

Azure SQL Database, T-SQL, Power BI

Reporting on data from Wit-Gele Kruis Vlaams-Brabant’s learning platforms. There are a total of 800 learning platforms. The goal is to consolidate the data from these 800 SharePoint sites and then visualize it in Power BI.

o Pre-sales

o Analyzing context

o Measuring technical feasibility

o Outline project approach

o Write a proposal

Technologies:

Power BI, SharePoint

Developing a forecasting tool to allow the After Sales department to set and adjust targets based on future sales forecasts and financial planning. Creation of a Collaborative platform. Replacing Excel files used in the After Sales department with Power BI reports.

Getting metrics data from different sources, and loading the data into the data warehouse. This data represents the KPI’s for various activities(marketing, insurance, parts sales, returned car battery’s, etc.…). Optimizing the current SSAS solution by migrating to a new server.

o Getting the requirements from the business

o Define new ways to automate manual uploads and write-back data

o Helping with the design of the data model

o Design and implement ETL processes with SSIS and SQL

o Supporting the business in case of data issues and Power BI issues

o Migrating SSAS solution to a new server

o Developing Power Apps

o Developing a Power BI report to visualize the status of SSIS jobs

o Developing a Collaborative platform in SharePoint Online

o Implementing Microsoft Flow(Power Automate) with SQL Server, Power Apps and SharePoint to automate manual workflows.

o Ensuring that data is loaded daily without errors from the source systems into the staging tables

o Data Cleaning

o Data Analysis

Technologies:

SSAS, SSIS, T-SQL, Power Apps, Power BI, Flow(Power Automate), SharePoint

Gathering data from multiple sources and visualize it through different tools

Technologies:

Azure IOT Hub, Azure Stream Analytics, Azure Blob Storage, Azure Data Lake, Azure Data Bricks, Power BI