Smaël NAIDA

1) DATA PROJECT MANAGER | Fragrance & Beauty Division Supply chain data governance (DRP) & transformation (Dec 2022 - Feb 2024) • Responsible for DRP (Distribution Requirement Planning) of the Fragrance & Beauty division, with generated monthly and weekly global purchasing forecast data based on stock levels, in-transit goods, orders, lead times, and sales forecasts, SAP MRP (production sites) • Team management : Supervised and coordinated a team of 3 consultants • Data integration : Centralized and processed supply chain data in Oracle databases • Change management : Facilitated meetings with international key users, including 10 key markets (Japan, Taiwan, Hong Kong, USA, Korea, China, UK, Australia, France, Russia), and supported process transformation initiatives • System transformation : Contributed to the migration from the legacy Blue Yonder (Manugistics) DRP tool to the new Kinaxis (Maestro) DRP solution, transforming Chanel's end-to-end supply chain 2) SUPPLY CHAIN TRANSITION MANAGER | Fragrance & Beauty Reporting modernization & change management (Mar 2024 - Present) • BI strategy & governance : Designed the migration of Hyperion reports to Microsoft Power BI for the Fragrance & Beauty division • Business workshops : Organized workshops with global key users • Planning (Roadmap) : Developed macro and micro plans (using MS Project) for each report, including a dedicated business owner and a 6-phase breakdown (specifications, data collection, development, data visualization, UAT, and production deployment) • Specification drafting : Coordinated with business teams to write functional and technical specifications • Training and support : Created training materials (before/after comparisons) and provided post-go-live support for Power BI users • Executive Steering : Facilitated bi-monthly steering committee meetings with F&B leadership (Supply Chain, IT, Finance, Sales Forecasting) to present progress, address risks, and drive strategic decisions

Implementation of a reporting system under the Microstrategy platform allowing the Pricing/Finance functions and businesses of the Saint-Gobain group to have operational and analytical data and information related to purchase and sale prices : • Single point of contact with the Pricing and Finance department for the management of the business relationship, the study of needs and the proposal of functional and technical solutions • Collection and analysis of functional/technical requirements • Drafting of detailed project technical specifications • Definition and monitoring of schedules and load plans • Management of the development team (4 service providers) in technical environment (SAP, Microstrategy, SQL, Oracle Data Integrator) • Planning and organisation of unit tests • Editing of COPIL/COPROJ reports • Development of Microstrategy reports (Dossier and Developer) • Guarantor of the day-to-day service to end users and the availability of data by delegation to the operating teams (in India) and to the support of the DSI

AREA OF INTERVENTION : Implementation of 4 dashboards with a home page for the 4 perimeters at ALLIANZ : 4RP (4 wheels), 2RP (2 wheels), A4R (special vehicles), ULT (terminated drivers) • Database modeling • Audit and study of user needs + Writing of functional and technical specifications • Creation of the semantic layer + Creation of public objects (Measures, Filters, Prompts, Grids) • Development of Dashboards via MicroStrategy • Creation of data cubes • PostgreSQL ETL job development • Realization of unit and functional tests and validate design deliverables TECHNICAL ENVIRONMENT : • Database : PostGreSQL v12 • ETL Tool : SQL data load scripts • Reporting tool : Microstrategy v2020 • Agile tools : Confluence, Jira

AREA OF INTERVENTION : Single point of contact with end users worldwide to analyze and challenge reporting and data needs • Management of the Microstrategy BI team (6 developers: 1 expert, 3 senior consultants, 2 junior consultants) so that they always have a sufficient quantity of previously prepared tasks to work on (DOD, DOR) • Work in close collaboration with the 4 main departments of Euler Hermès (Risk, Commercial, Organization, and Finance) as well as all the global entities of Euler Hermès (USA, Spain, Italy, Holland, Germany, China, ..) to create and maintain a backlog based on "business value" • Preparation and animation of business Workshops • Management of the backlog and iterations (sprint). Supervision of daily meetings (Daily), bi monthly (sprint planning and retro-planning), as well as backlog refinement (preparation of the next sprint) under Trello and Jira • Definition, planning and prioritization of “user stories” concerning the deliverables of the squad : documents, dashboards (Dossier) and Microstrategy reports • Assessment of “business value”, then creation of “epics” and major themes to ensure that work focuses on dashboards with maximum “business value” and which are aligned with the Datahub program strategy • Planning of dashboard evolutions and definition of business expectations in terms of new Microstrategy functionalities (HyperCards, Mobile, Ipad) • Participation within the team in impact studies, in the analysis of sosu Microstrategy technical solutions and in the constitution of documentary repositories (PPT and WORD)

AREA OF INTERVENTION : Implementation of several Purchasing and Sales analysis projects for merchandise warehouses and stores • Management of 4 developers • Microstrategy Architect: schema objects (creation of attributes, facts and hierarchies) • Configuration Source Project : implementation of projects "from scratch" (connectivity information, creation of the metadata database, creation of ODBC connectors to the Teradata database) • MicroStrategy Administration : Managing security via LDAP (creating LDAP groups and automatically importing users into MicroStrategy). Create scripts with Commander Manager and workflow to load intelligent cubes with System Manager. License management (user and CPU licenses) and projects (duplication of projects, copies of objects between projects with object manager). Scheduling jobs and administrative tasks. Administration of MicroStrategy Web and mobile. VLDB properties for optimizing the execution of intelligences cubes and reports. Entreprise Manager pour • Microstrategy Mobile: development of dashboards for Android (Samsung J3, j5, XCover) and IOS (Iphone 6.7) to display Casino KPIs (Sales / Number of sold items, number of customers, ..) per store , by store group, with 3 levels of time: daily, weekly and monthly with a comparison with the previous year. • Optimization of Microstrategy governance processes : resource management to ensure optimal performance and use of system resources • Data modeling (conceptual data model, logical data model, and physical data model) • Reporting : creating simple reports, multi-panels documents, templates, interactive dashboards with Visual insight v10 • Migration : Microstrategy v9.3 to v10.3 then v10.3 to 10.11 • Project management in Agile method

Performing an audit of the existing Microstrategy v10.3 solution : • Audit of all Microstrategy projects (objects and reports) • Diagnosis of existing for identification of strong and weak points • Analysis of Microsrategy technical architecture • Standardization of Microstrategy processes (naming of attributes, tables, views, attribute forms, categories of attribute forms, facts, measures, transformations, ..) • Recommended Microstrategy best practices (optimization of reports based on Free Form SQL, creation of cubes with dynamic sourcing mode, creation of new user hierarchies and layers in the Architect layer,…) • Implementation of indicators to measure the quality of the Microstrategy solution (response time, business satisfaction)

Project 1 : Microstrategy v9.3/9.4 • Management and development reports in Microstrategy v9 • Group management and security (License Manager) • Migrating Microsoft SQL Server Reporting Services reports to MicroStrategy v.9.3 • Microstrategy migration v9.3 to v9.4 Project 2 : Genio v4, v7 et v8 • Management and development of ETL flows under v4 Genio: Belgium and Holland • Management and development of ETL flows under Genio v7: France, Portugal, Italy, Spain • Migration projects Genio v7 to v8 Genio Project 3 : Business Objects v5.1 et v6.5 • Management and development reports in Business Objects v5.1: Belgium and Holland • Management and development reports in Business Objects v6.5: France, Portugal, Italy, Spain • Group management and safety in Business Objects v5.1 and v6.5 (Supervisor) Technical environment : • Database: SQL Server 2008, Oracle 9i • ETL : Tools: Genio v4, v7 and v8 • Reporting tools: Business Objects v5.1 and v6.5, v9.4 Microstrategy, • Teams : Sales, Human Resources, Marketing, Finance, IT, Purchasing, General Management, Logistic Functional environment : Teams : Sales, Human resources, Marketing, Finance, IT, Purchasing, General Management, Logistic Geographical context : Europe : ENGLAND,BELGIUM, FRANCE, PORTUGAL, ITALY, SPAIN,,NETHERLANDS, HUNGARIA, POLAND, SLOVAKIA, CZECH, DENMARK, FINLAND, NORWAY, SWEDEN,SWISS, GERMANY

Main Mission: Transforming MOVEX applications to HYPERION • Setting up meetings with users of keys each team (purchasing, sales, finance, manufacturing, data management, logistic, quality, Heim) • Analysis of functional specifications and change management • Establish schedules • Writing technical specifications • Development of reports and dashboards in Hyperion Interactive Reporting Studio and Dashboard • Test planning and test plans • Deploying reports for users keys • Management and monitoring of change requests on Hyperion Technical environment: • SQL Server 2008, Movex V12, Hyperion Interactive Reporting Studio v11, Hyperion Dashboard Studio     results: • 41 applications migrated to Hyperion, 12 applications for Zodiac Heim (Germany)

PROJECT 1 : Implementation of Hyperion Performance Suite developments and monitored daily Informatica and Microstrategy v8 treatments. • Integration and deployment of of Hyperion Performance Suite ( BRIO ) reports, and optimization of Informatica treatments and Microstrategy reports • Development of new reports Hyperion Performance Suite • Informatica treatments load data into data warehouses 6 and 8 Datamarts • Monitoring activities of Microstrategy reports • Informatica : Monitoring and daily diet of 6 and 8 Datamarts Datawarehouse • Microstrategy : 500 shared reports and more than 4000 personal reports Technical environment : • Informatica v8, v7 Microstrategy , Hyperion Performance Suite v8.3 , Oracle 9i , PL / SQL , Toad v9.0, CMMI 2 PROJECT 2 : Developments treatments with Microsoft SQL Server 2008 Analysis Services and Reporting Services 2008 Project IT- Refresh PRIMO : transformation Hyperion Performance Suite Reports ( Brio ) into Microsoft SQL Server Reporting Services 2008 reports • More than 11 000 users AXA France • Over 3 million PDF on PRIMO Portal • Developments of 5 SQL Server Analysis Server cubes ( FCG , PRIMO , MCM , HO, EVR ) • Integration and deployment of 80 Reporting Services reports TOM PROJECT : to serve the Axa Blegium who wishes to measure the quality of service and productivity of document processing • Supports changes on Reporting Services • 5 SSAS cubes ( DMS , WOLF, WIPS , WEM , IRIS_TOM ) for 25 reports TOM VIADUC PROJECT: General agents for AXA • Creation of new Reporting Services reports • 1 SSAS cube for 30 reports VIADUC Microsoft SQL Server Analysis Server 2008 , Microsoft SQL Server Reporting Services 2008 , Microsoft SQL Server 2008 database , Citrix

PROJECT 1: Project STARC Fast in the team Deploying Decisional Systems (DSYD) Areas: • Creating UNIX trees • Creating instances and schemas in Oracle • Analysis of functional specifications and participation in macro-planning • Development and supply InfoCentre • Development and supply of Datawarehouse • Getting the recipe Datawarehouse treatments • Development and testing unit Datamart • Setting the OTIS interface • Production of the CIC, Datawarehouse, Datamart and setting OTIS Otis results: • Complete BI chain and ready for use by countries Algeria and Greece Technical environment: • Datastage PX 7.5, Oracle 9i, PL / SQL, XML, Unix PROJECT 2 : Establishment of a versioning (adding and modifying fields for Portugal , Germany , Hungary, Thailand and France ) Areas: • Creation of validation requests • Draw fields in Datastage PX • Technical Documentation results: • New fields available for France and countries worldwide Technical environment : • Datastage PX 7.5, Oracle 9i , PL / SQL , UNIX PROJECT 3 : Assistance & Support to production within the team and Maintenances Assitances to Production (MAP) Areas: • Support countries , following requests for changes OTIS • Feeding August 2008 production data for Germany • Mini- project maintenance ( counter products , delete Oracle ) results: • From August 2008 to end of September 2008 , 193 Apollos solved for France 74 and the International Technical environment : • Oracle 9i , PL / SQL , Unix, XML