Madani Kenab

› Development of Pipelines, Python Notebooks, and Spark Jobs in Python on Azure Synapse Analytics and

Azure PySpark for ELT data processing: Datalake (Azure Blob Storage), Staging STG, ODS, and DWH.

› Implementation and update of Power BI datasets.

› Development of Stored Procedures in Transact SQL for Azure dedicated SQL pool and Serverless SQL pool.

› Development of fixes and enhancements for Web applications in Python (Flask).

› Development of Azure Functions in Python and C# (.Net) as APIs and Swagger for API documentation.

› Development of release deployment pipelines for custom containers in Azure Container Registry using Azure DevOps.

Waste Management Optimization Application (Positioning, Drop-off Point Assignment, and Collection Routes): OPTI'PAC and Business Intelligence Information System (SID): OPUS, which generates reports and publishes indicators related to collection costs, waste quantity by flow, number of appointments, and number of visits to Recycling Centers.

- Facilitating requirements gathering and clarification workshops, Writing General Functional Specifications, Writing Detailed Technical Specifications.

- Designing the application architecture documentation (Back and Front modules, Databases), Defining the Technical Foundation (Bash scripts).

- Developing the OPTI'PAC Web Application (BackEnd: Python and Flask, FrontEnd: HTML, JavaScript, Leaflet, Bootstrap, and CSS, DB: PostgreSQL), Implementing enhancements and improvements for the OPTI'PAC Web Application.

- Installing and configuring the developer workstation " Implementing an MVC architecture, Developing a REST API.

- Implementing Talend Jobs for data extraction, transformation, and loading, as well as calculating various indicators.

- Importing and integrating data from various repositories (Bash scripts and PL-PGSQL scripts).

- Preparing and participating in acceptance, pre-production, and production deployment.

- Writing documentation (user manual, deployment guide).

- Testing and acceptance with business departments, User support and training.

ATLAS Application for managing sports activities.

- Installing the technical foundation and deploying the application, Analyzing and diagnosing to define a list of enhancements and fixes (DB: Oracle Database, scripts in Bash and PL/SQL, BackEnd: PHP, and FrontEnd: JavaScript, HTML, CSS).

- Estimating workloads, Prioritizing into two batches, Defining a schedule with milestone dates.

- Implementing enhancements and fixes, Testing and acceptance, Presenting to the client and delivering the solution.