Redouane LAMKADEM

𝐈𝐧𝐝𝐞𝐩𝐞𝐧𝐝𝐞𝐧𝐭 𝐂𝐨𝐧𝐬𝐮𝐥𝐭𝐚𝐧𝐭 : Providing expert consultancy services as a freelance Data Specialist, helping organizations to optimize their data strategies, improve data quality, and implement advanced analytics solutions. 𝐌𝐞𝐧𝐭𝐨𝐫𝐬𝐡𝐢𝐩 & 𝐂𝐨𝐚𝐜𝐡𝐢𝐧𝐠 : Mentoring and coaching junior professionals, offering guidance and training in data science, analytics, and industry best practices, helping them to accelerate their careers. 𝐓𝐚𝐥𝐞𝐧𝐭 𝐀𝐜𝐪𝐮𝐢𝐬𝐢𝐭𝐢𝐨𝐧 𝐒𝐮𝐩𝐩𝐨𝐫𝐭 : Acting as a business broker for clients, connecting them with top IT talents

Developed data pipelines for the migration of SAP BW to Google Cloud Platform (GCP) using Dataform. Created MicroStrategy cubes and dashboards to support the decommissioning of SAP BusinessObjects (BO). Designed and implemented data models in BigQuery to optimize query performance and data storage. Automated ETL processes using SQL and Python to streamline data workflows and reduce manual intervention. Supported and maintained legacy BI applications (SAP BO/BW), ensuring seamless operations. Led code reviews (BigQuery/SQL) for the Data team, promoting best practices and high-quality standards.

𝐅𝐚𝐬𝐡𝐢𝐨𝐧𝐂𝐮𝐛𝐞 (𝐉𝐮𝐥𝐞𝐬,𝐏𝐢𝐦𝐤𝐢𝐞,𝐎𝐫𝐬𝐚𝐲..) : 𝟎𝟐/𝟐𝟎𝟐𝟏 -> 𝟎𝟏/𝟐𝟎𝟐𝟒 - Drafting technical specifications for Data projects - Data referent for the FashionCube group's Finance department - Handling requests for BI (BO/Qlikview) upgrades - Participating in the migration of the datawarehouse (Oracle) to the cloud (GCP) - Implementation of a data dictionary as part of data governance 𝑇𝑒𝑐ℎ𝑛𝑖𝑐𝑎𝑙 𝑒𝑛𝑣𝑖𝑟𝑜𝑛𝑚𝑒𝑛𝑡 : 𝑆𝑄𝐿 / 𝑆𝑡𝑎𝑚𝑏𝑖𝑎/ 𝐵𝑖𝑔𝑄𝑢𝑒𝑟𝑦 / 𝑆𝐴𝑃 𝐵𝑂 / 𝐿𝑜𝑜𝑘𝑒𝑟 𝐒𝐚𝐧𝐨𝐟𝐢 : 𝟏𝟎/𝟐𝟎𝟏𝟗 -> 𝟎𝟐/𝟐𝟎𝟐𝟏 - Participating in IS development via change requests. - Leading partner teams in the investigation of problems - Making proposals to improve the IS - Ensuring on-call service continuity for applications - Maintain Sanofi's warehouse management tool (WMS) in operational condition 𝑇𝑒𝑐ℎ𝑛𝑖𝑐𝑎𝑙 𝑒𝑛𝑣𝑖𝑟𝑜𝑛𝑚𝑒𝑛𝑡 : 𝑆𝑄𝐿 / 𝑆ℎ𝑒𝑙𝑙 𝑈𝑁𝐼𝑋 / 𝑂𝑟𝑎𝑐𝑙𝑒 / 𝑆𝑒𝑟𝑣𝑖𝑐𝑒𝑁𝑜𝑤 𝐂𝐚𝐫𝐫𝐞𝐟𝐨𝐮𝐫 𝐅𝐫𝐚𝐧𝐜𝐞 : 𝟎𝟑/𝟐𝟎𝟏𝟗 -> 𝟎𝟓/𝟐𝟎𝟐𝟎 - Writing technical specifications for medium-sized projects. - Develop and check the solutions to be implemented (unit and integration tests) - Ensuring continuity and quality of service (N3 support) - Delivering and supporting the customer during acceptance testing 𝑇𝑒𝑐ℎ𝑛𝑖𝑐𝑎𝑙 𝑒𝑛𝑣𝑖𝑟𝑜𝑛𝑚𝑒𝑛𝑡 : 𝑂𝑅𝐴𝐶𝐿𝐸,𝐸𝑆𝑆𝐵𝐴𝑆𝐸,𝑃𝐿/𝑆𝑄𝐿 𝐋𝐚 𝐏𝐨𝐬𝐭𝐞 : 𝟎𝟓/𝟐𝟎𝟏𝟕 ->𝟎𝟏/𝟐𝟎𝟐𝟎 - Participating in the maintenance and development of La Poste group's various BI applications - Gathering and analysing customer requirements - Participating in steering meetings with the client - Developing PL/SQL procedures and Essbase cubes for integrating data into the information system - Development of OBIEE reports for the daily reporting of business teams 𝑇𝑒𝑐ℎ𝑛𝑖𝑐𝑎𝑙 𝑒𝑛𝑣𝑖𝑟𝑜𝑛𝑚𝑒𝑛𝑡 : 𝑂𝑅𝐴𝐶𝐿𝐸,𝑂𝐵𝐼𝐸𝐸,𝑃𝐿/𝑆𝑄𝐿,𝐸𝑆𝑆𝐵𝐴𝑆𝐸,𝑆𝐻𝐸𝐿𝐿 𝑈𝑁𝐼𝑋

- Gathering and analysis of business requirements (Marketing/Finance) - Studies and analysis of datawarehouse data (Teradata/Oracle) - Information system maintenance and support - Verification of data consistency and quality (Teradata) - Production of dashboards (Microstrategy) - Implementation of data mapping

- Adapting reports to meet changing customer requirements - Maintenance and improvement of existing reports/universes (SAP BO) - Integration and analysis of customer data - Creation and management of ETL flows (ODI) - Checking ETL processing has been carried out correctly