Yassine OUARDAOUI

Data Optimization for Improved Performance: ETL Strategies, Effective Consolidation and BI Process Automation Designed and implemented a data warehouse using the Medallion Architecture to centralize and consolidate data from various sources (CRMs and ERP). Built automated ETL pipelines using Python for cleaning, standardizing, and transforming data before integration. Created interactive dashboards with Power BI for real-time analysis of lead conversion, sales performance, and campaign effectiveness. Implemented Row-Level Security (RLS) in SQL Server to ensure secure access and data confidentiality. Cleaned and standardized data in the Silver layer to ensure consistent and reliable reporting.

As the Head of Communication and External Relations, I led initiatives to enhance the visibility and engagement of our group. My key responsibilities included: Event Planning: Organized and executed various events, including workshops, hackathons, and networking sessions, fostering a collaborative environment for students to learn and innovate. Competition Organization: Coordinated competitions that encouraged participants to showcase their skills, driving participation and enthusiasm within the community. Logistics Management: Managed all logistical aspects of events, ensuring smooth operations from planning to execution, including venue selection, resource allocation, and coordination with vendors. Communication Strategy: Developed and implemented communication strategies to promote events and initiatives, effectively engaging with both internal and external members.

Payment Delay Prediction System Developed a predictive system for payment delays using Machine Learning algorithms, enabling more accurate forecasting and improved cash flow management. Data Cleaning and Processing: Executed thorough data cleaning techniques, including handling missing values and outliers, ensuring the dataset was reliable and ready for analysis. Exploratory Data Analysis (EDA): Conducted detailed exploratory analysis to identify key trends and correlations in the data, utilizing statistical tools to support data-driven decisions. Data Visualization: Created comprehensive visualizations to effectively communicate findings, helping stakeholders understand complex data insights.

Customer Data Handling and Sales Analysis Data Filtering and Processing: Filtered and processed customer data to ensure accuracy and relevance, facilitating better insights into customer behavior and preferences. Sales Reporting and Performance Analysis: Prepared detailed sales reports and conducted performance analysis, identifying trends and areas for improvement to support strategic decision-making. Customer Query Analysis and Management: Analyzed and managed customer queries, ensuring timely responses and enhancing customer satisfaction through effective communication.

Data Collection and Automation Regular Data Collection: Gathered data consistently from CSV files, ensuring a steady flow of information for analysis and reporting. Data Verification and Cleaning: Conducted thorough verification and cleaning of data to maintain accuracy and reliability, addressing inconsistencies and errors. Process Automation with SSIS: Automated the data collection and cleaning processes using SQL Server Integration Services (SSIS), significantly improving efficiency and reducing manual effort.