Mohamed Yahyaoui

- Implemented Power BI as the company’s reporting solution by developing 8 projects (real-time and D-1), tested and validated by business stakeholders and Business Analysts, and published on Power BI Service. - Contributed to the structuring of the BI architecture (Staging, ODS, DWH) through the development and optimization of SSIS jobs, ensuring reliable data flows, improved governance, and high-performing data warehouses. - Built semantic models tailored to each department (Supply Chain, HR, Logistics, etc.), enabling Business Analysts to perform autonomous analyses. - Trained Business Analysts and prepared user guides for each dashboard. - Collaborated closely with end-users to gather business requirements, design customized reports, and ensure both functional and strategic alignment. - Managed and continuously improved Power BI reports, including the migration of IBM Cognos data models to optimized Power BI semantic models.

Client : Amsons Industries - Camel Cement

- Integrate and develop Power BI within the IT department. - Create interactive dashboards for key departments (Financial Control, Supply Chain, Production, Marketing, Sales, HR) and train teams in its advanced usage. - Develop efficient ETL jobs with SSIS. - Create detailed reports with SSRS and optimize ETL processes to enhance operational performance. - Actively participate in audit projects aimed at optimizing existing ETL processes to ensure maximum efficiency of critical data flows. - Manage ERP Sage X3, manage user requests, and optimize functionalities to support daily operations effectively. - Design and implement interactive dashboards with QlikSense. - Collaborate with business teams to define and track essential KPIs. Technologies: SQL Server, Sage X3, SSIS, SSRS, Power BI, QlikSense

- Implementation of a Power BI dashboard serving as a comprehensive catalog of available players (Loan or Sale) for the transfer market, efficiently gathering data from Transfermarkt.com. This solution provides interested clubs with valuable and relevant information about players represented by MIRSPORT agency, thus facilitating their strategic decision-making. - Establishment of an advanced Power BI dashboard to offer Scouts and FIFA Agents at the agency an in-depth evaluation of players' performances. Data is extracted from Instat, a renowned platform for insightful analyses of matches, players, and opposing strategies. Key indicators such as the Instat Index, match evaluations, goals, assists, etc., are presented visually, thereby easing strategic decision-making during player recruitment and management processes. - Support and training for coaches and other members of the agency on data analysis techniques and tools. Technologies : Power BI . Python

- Real-time decision making support within the BCPM (Business Control and Project Management) team. - Collection, processing, analysis, and synthesis of data related to the production department's activity. - Design and improvement of internal and external reports. - Creation, adaptation, and maintenance of dashboards using the data visualization tool Tableau Software. - Segmentation of Genesys / Salesforce records and flow analysis. - Daily updating of production KPIs and publication of workbooks on the Tableau Server. - Verification of sales (Freemium / Premium) and analysis of agent performance. - NLP Sentiment Analysis project on Parachut Assurance customer reviews from the Trustpilot website using Python notebooks: Web Scraping and data collection with BeautifulSoup and data analysis with the Natural Language Toolkit NLTK. Technologies : Python . Tableau . Salesforce . Genesys . SQL