Mahfoud Gzem

Setting up workshops to help define needs. Design and development of automated pipelines in Dataiku: building workflows integrating cleaning, joining, transformation, aggregation, and business enrichment steps. These pipelines are automated and documented. Automatic validation tests have been implemented to ensure their execution. Understanding business processes on Power BI (reporting tool): delivery of data models, modeling of simple dashboards for monitoring maintenance center data. Data source analysis: I performed exploratory analyses on the main available data sources (reservations, customers, repositories, campaigns, etc.) to identify useful fields, formats to standardize, business rules to apply, and discrepancies to correct. This helped inform modeling choices. Performing business acceptance testing during the DATA platform migration: I supported the migration of old processes and datasets to the new cloud platform. This included verifying outputs, updating scripts, and conducting business acceptance testing. Monitoring the proper management of repositories: I led workshops with the Data department responsible for repositories (Technical Center, Operational Unit, pricing, etc.) to frame the needs of the business teams. Making data available automatically via Power BI Dataflow: data can be shared between teams via Power BI. I created datasets using Power Query. Supporting business teams: discussions to understand data, and also through a Dataiku project that monitors data health daily (via quality checks) allowing data scientists to work more smoothly. Tools: Dataiku, Power BI, Power Automate, Databricks

Data BI Governance, whose role is to implement the BI platform (Teradata, Dataiku, Tableau). **Member of the Dataiku Support Team**. Data processing (pipelines) with Dataiku for Business Teams (Operations, Finance Risk). Migrations of SAS programs to Dataiku. Migration of a project developed in ACCESS (VBA program, with table and Excel file creation) to Dataiku (SQL, Python, and Dataiku acceptance testing). Migration of a project under Alteryx to Dataiku. Writing automated scenarios with Dataiku (Python and Dataiku steps). Performing Dataiku version upgrade tests before production deployment. Creating Dashboards under Tableau. Presenting the Dataiku platform to Business teams. Support in evaluating projects from a GDPR (Personal Data Protection) perspective for the Data Office.

Objective: Contribute to the strategic decision-making of the Marketing team by providing reliable and visual analyses of commercial activity and customer behavior. Role: Data Analyst. Department: Marketing. Design and automation of interactive dashboards on Tableau to monitor the company's overall performance, analyze customer portfolios, and identify high-potential segments. Development and structuring of databases on Oracle, with creation and optimization of SQL queries to feed customer segmentation studies. Extraction, cleaning, and preparation of data to ensure their quality and reliability before analysis. Production of marketing analyses to better understand customer profiles and guide commercial actions and targeted campaigns.