Hamza Ayari

• Design and implement scalable data models (e.g., star, snowflake, constellation schemas) to support reporting and analysis. • Build and maintain interactive dashboards and reports using Power Bl Desktop and Service. • Connect, clean, and transform data from various sources using Power Query to ensure data quality and consistency. • Create DAX measures to support key performance indicators (KP|s) and business logic. • Ensure data quality, consistency, and accuracy across all deliverables. • Apply Row-Level Security (RLS) to meet governance and access control requirements. • Collaborate with business teams to gather requirements and translate them into actionable data solutions. • Perform testing and validation of Bl solutions to ensure reliability and accuracy. • Document data sources, logic, and usage of developed dashboards and reports. • Automate workflows and reporting processes.

• Analyzed client business needs and designed customized ERP (Cegid) solutions to meet specific operational requirements. • Configured and deployed ERP systems, including data migration and end-user training. • Managed system integrations using SOAP & REST APIs and performed advanced SQL queries to support data exchanges. • Collected, cleaned, and prepared datasets for analysis and reporting purposes. • Developed interactive dashboards and reports using Power BI, Power Query, Python, and R to provide insights for business users. • Supported end users in understanding and using BI tools and reports effectively. • Collaborated with clients and internal teams to define data analysis needs and translate them into actionable visualizations.

• Design & Development: Built a complete decision support system to evaluate teaching performance. • Data Management: Extracted, cleaned, and transformed raw data for analysis. • Data Warehouse Implementation: Designed and developed a robust Data Warehouse to store structured data. • Power BI Dashboards: Created interactive dashboards using Power BI to visualize evaluation results. • Data Analysis & Reporting: Performed data analysis and generated detailed reports to support academic decision-making.

▪Collecte des informations sur les entreprises cotées en bourse par secteur selon un processus de scraping de données. ▪Modélisation et analyse des collectes de l’entreprise cotée en bourse.

Création d'un dashboard pour la comité générale des assurances CGA -Technologies utilisés : Power BI , SQLServer , PostgreSQL , Talend , Python , R. -Taches effectuées : fixation des objectifs métiers , ETL , Data Mining , Machine learning, Analyses descriptives et prédictives. -Méthodologie de travail : CRISP-DM. -Nombre de l'équipe de travail : 6

Développement , configuration et la mise en place d'un système d'information sous l'ERP Odoo pour la gestion des commerciaux : • Développement et Configuration : • Conception d'un système pour la gestion des commerciaux. Configuration adaptée aux besoins spécifiques. • Mise en Place d'Odoo : Implémentation complète pour une gestion intégrée. Personnalisation des modules pour optimiser les processus. • Gestion des Performances : Intégration de fonctionnalités de suivi des performances. Amélioration de la collaboration en équipe. • Formation et Support : Formation des utilisateurs pour une transition en douceur. Support continu pour maximiser l'utilisation.