Mahdi Souilem

• Design and implementation of customized business intelligence solutions
• Creation of complex data models for in-depth analysis
• Extraction and transformation of data from various sources
• Development of interactive reports and dashboards using Microsoft Power BI
• Maintenance of the BI environment and resolution of technical issues
• Presentation of results and recommendations to clients for decision-making
• Management of data governance: quality assurance, security, and confidentiality

Projects:

• Design and deployment of an efficient dashboard: provided a Power BI tool tailored for department heads to effectively monitor financial performance and budget execution
• Optimization of datasets: successfully reduced refresh time by 50% for existing datasets used in Power BI reports and dashboards. This goal was achieved by improving data models and refining table joins

• Development and maintenance of data pipelines with Azure Data Factory
• Data exploration, transformation, and analysis of large datasets via Azure Databricks
• Documentation of ETL processes and pipelines in Confluence
• Design, development, and maintenance of reports and dashboards in Microsoft Power BI
• Automation of Power BI alerts using Power Automate
• Automation of .csv file delivery from our database to clients via Azure Logic App
• Monitoring and cost optimization by ensuring budget compliance and analyzing cost-reduction scenarios in Azure

Project:

• Analysis and streamlining of Microsoft E5 licenses: achieved cost savings of over $1M through this project. The objective was to support managers by developing essential Power BI reports and visuals to aid in their decision-making

• Create reports and dashboards that meet client needs and support business decisions
• Maintain and monitor existing Power BI reports
• Develop new KPIs to facilitate decision-making for managers
• Clean and correct data before integrating it into the model
• Collaborate with the industrial engineering team to identify business challenges

• Developed comprehensive Power BI reports to display the branch’s weekly performance metrics
• Transformed and cleansed data to ensure accuracy and consistency in reporting
• Performed weekly comparisons of figures against branch objectives to evaluate goal attainment and performance trends
• Presented reports and in-depth analysis findings to team members, fostering informed discussions and collaborative decision-making