Yassine Yousfi

Ipsen Pharma is a pharmaceutical company developing medicines to improve patients' lives. As one of the leaders in oncology, neuroscience, and rare diseases, it operates in over 100 countries with a revenue of approximately €3 billion. IPSEN offers flagship products such as Smecta, Forlax, and Tanakan. Context: Within the Data & Analytics department, I joined the team maintaining a SaaS BI platform dedicated to clinical study management, providing strategic insights to over 400 ClinOps and MedAffs members worldwide (EMEA, NA, LATAM, APAC). I collaborated with a multidisciplinary team (PM, PO, Data Engineers, Cloud Engineers, IT QA, ClinOps, Business Stakeholders) to design high-performance solutions. Achievements: Development and maintenance of 20+ interactive dashboards in Tableau, integrated with SharePoint for data entry and API ingestion. BI performance optimization: 80% reduction in load times (20s → 4s) through advanced audits and Tableau/AWS improvements. UI/UX enhancement via Figma and Miro, integrating innovative features to optimize user experience. Responsibilities: Agile project management: Participating in Scrum ceremonies (Sprint Planning, Review, Retro, Story Mapping, PI Planning) via Jira. Data & Cloud BI: Utilizing a robust tech stack with AWS (S3, Lambda, Athena), Tableau, and Power BI. Project RUN: Managing deployment phases across 4 environments (DEV, QA, Staging, Prod). CI/CD and API: API integration via Swagger, implementation of automated pipelines with Kubeflow, CircleCI, and GitHub. Documentation of architectures and user guides on Confluence and EasyDoc. Tableau Server administration: Managing sites, projects, user permissions, and Row-Level Security (RLS). Compliance: Ensuring adherence to GxP regulations and Operational Qualification (OQ) within clinical trials.

Decathlon is a global leader in sports retail, present in over 70 countries, with more than 100,000 employees and an annual revenue exceeding €15 billion. Decathlon Digital division is dedicated to digital transformation and data exploitation to optimize customer experience and business performance. Context: I joined the Pricing and Insights team to contribute to pricing strategy optimization and competitive analysis. The team was composed of 3 Data Analysts, 3 BI Engineers, 2 Data Scientists, 4 Analytics Engineers, as well as Product Managers, Product Owners, and UI/UX Designers spread across France (Lille and Paris), the UK, Spain, the Netherlands, and Romania. Responsibilities: - Designed and developed interactive dashboards on Tableau Cloud, enabling the visualization and analysis of e-commerce competitor data (Amazon, Intersport) from providers Netrivals, Skuddle, Minderest to monitor dynamic pricing. - Optimized data pipelines and ETL processes with Tableau Prep, Databricks, and dbt, ensuring seamless integration with BI tools. -Designed and implemented a full BI architecture (Dev, QA, Prod), ensuring a continuous development cycle. - Data validation in collaboration with business analysts (AMOA), improving dashboard performance by 32% and enhancing user experience using Decathlon's UI/UX templates. - User training on BI best practices to encourage reusability and scalability of BI solutions. - Tableau Cloud administration, including access management, dashboard performance optimization, and data governance. Technical Stack: BI & Data Visualization: Tableau Desktop, Tableau Prep, Tableau Cloud, Glooker Cloud Computing: AWS, Databricks, DBT, SQL, One Big Table (OBT) CI/CD: Airflow, GitHub Actions

Stellantis is a global automotive group resulting from the merger of PSA and FCA, operating in over 130 countries with a portfolio of 14 iconic brands, including Peugeot, Citroën, Fiat, Jeep, Opel, and Dodge. The company employs approximately 270,000 people and generated a revenue of €179.6 billion in 2023. Mission Context: As part of a migration project for Stellantis, I contributed to the transition from the Legacy CRM to Salesforce by developing analytical solutions to optimize post-migration gap analysis. This mission was carried out in close collaboration with the Data Factory team to ensure the reliability and consistency of the migrated data. Key Achievements: Audited and analyzed existing solutions, including Salesforce Tableau CRM dashboards and data flows (Dataflow). Collaborated with the Data Factory to ensure the quality and usability of the migrated data. Designed and implemented a BI architecture tailored to business requirements. Developed and deployed reports and dashboards dedicated to gap analysis on Tableau Cloud. Technologies Used: ETL: Salesforce Recipe Dataflow, Tableau Prep Cloud: AWS Redshift, PostgreSQL Reporting: Tableau Cloud, CRM Analytics Methodology: Agile (Scrum), Jira

Orange is a telecommunications company that connects people and businesses through innovative and reliable services. Founded in 1988, it has more than 266 million customers worldwide, employs around 130,000 people, and generated €43.5 billion in revenue in 2022. Context: Within the Services and Information Systems Department (DSSI), I contributed to implementing a solution for managing economic performance by adopting a Business Intelligence approach. Team: Collaboration with multidisciplinary teams, including information systems experts, developers, and project managers. Main Responsibilities: - Project Planning and Management (Agile/Scrum): Organizing and tracking sprints to ensure timelines and objectives were met. - Framing Analysis and Requirement Specification: Identifying business needs and defining functional specifications. - DataWarehouse Design: Implementing data architecture with a Bottom-up approach (Bus of DataMarts) using Kimball methodology. - ETL Development and DataWarehouse Loading: Creating ETL processes with Talend for data integration and storage in the DataWarehouse. - Report and Dashboard Creation: Developing interactive reports and dashboards with PowerBI for visualizing economic performance. Tech Stack: ETL: Talend Database: Microsoft SQL Server Reporting: PowerBI Methodology: Agile (Scrum) Languauge : French , English

Boursorama is a French online bank and a subsidiary of the Société Générale group. Founded in 1995, it is now one of the leaders in the sector, with over 5 million clients. It offers a wide range of banking services, including current accounts, savings, loans, and stock market investments. Mission Context: Within the BI & Data department, and more specifically within the team responsible for data visualization and reporting, I contributed to the implementation and optimization of analytical solutions for various banking business units. Responsibilities: Corrective and evolutionary maintenance of existing dashboards, ensuring their performance and reliability. Optimization and debugging of SQL queries to improve the speed and efficiency of analyses. Leading workshops with business teams to gather, analyze, and formalize reporting and data visualization requirements. Developing dashboards covering multiple business areas, including credit, life insurance, customer service, KYC, and data quality. Collaborating with Data Lake and Data Hub teams to integrate, structure, and efficiently leverage data for Tableau reports. Technologies: ETL: Tableau Prep, SQL Database: Microsoft SQL Server Reporting: Tableau Desktop, Tableau Server Methodology: Agile (Scrum), Jira

Société Générale is one of the leading French banks and a leader in banking and insurance. Founded in 1864, the company serves over 25 million clients worldwide and employs approximately 117,000 people. Context: Within the ITIM (Information Technology and Innovation for Business) division of Société Générale's French Retail Banking, I contributed to the TOMFIR (Target Operating Model for Finance & Risk) project, by BCE (Europpean Central Bank ) aiming to harmonize and optimize financial and risk management processes within the group. Team: Composed of diverse profiles, including managers, project leaders, business analysts, developers, and data and BI experts. We worked closely with teams based in Luxembourg and Romania. Main Responsibilities: - Framing : Understanding and framing user requirements. - Specification documentation: Developing detailed functional and technical specifications. - Data Modeling: Designing star and dimensional data models following Bill Inmon's Top-down approach (Star Schema), promoting a robust and scalable data architecture. - Project Monitoring: Managing the entire evolution process, from design to production deployment, including testing (UAT;QA) and validation to ensure quality and compliance of deliverables. - Dashboard Creation: Developing interactive dashboards with Power BI and Tableau. - Validation with the Financial Department: Collaborating with business units within the financial department (MOA) to validate deliverables and ensure they meet business requirements. Technical Stack: ETL: IBM DataStage Data Warehouse: SQL Server, Teradata Cloud: Microsoft Azure Reporting: Power BI, Tableau Project Management and Documentation: Agile, Jira, Confluence, ServiceNow Languages: French , English

The Ministry of Agriculture and Maritime Fisheries of Morocco is a public institution dedicated to the agricultural sector, aiming to promote sustainable development of agricultural and fisheries industries. It oversees programs impacting over 4 million farmers and contributes nearly 14% to the national GDP. Context: Within this ministry, I participated in the analysis, design, and implementation of an expense management application. This application enables the management and tracking of public contracts and purchase orders, contributing to more efficient and transparent financial management. Team: I collaborated with functional analysts, developers, and public procurement experts. Main Responsibilities: Needs Analysis: Understanding user requirements to define solutions tailored to the ministry's expense management processes. Application Design: Developing the application's architecture, integrating functional and technical specifications to ensure a robust and scalable solution. Development: Programming the application in VB.NET and C#, ensuring an intuitive user interface and seamless integration with existing systems. Reporting: Creating detailed reports and interactive dashboards using SAP Crystal Reports and SSMS, facilitating data visualization and decision-making. Database Management: Designing and managing the database using Microsoft SQL Server, ensuring data integrity, security, and performance. Testing and Validation: Conducting functional and performance tests to ensure the application's quality and compliance with the ministry's requirements. Tech Stack: Programming Languages: Visual Studio, VB.NET, C# Reporting: SAP Crystal Reports, SSMS DBMS: Microsoft SQL Server Methodology: Agile Languages: French, Arabic