Rayane Declercq

At Guerlain, I contributed to the design and organization of a new BI application focused on CRM. I helped with the migration of analytics to a GCP architecture, and was involved in gathering requirements, application design, dashboards building and user testing. Additionally, I helped in project planning and suggested data storytelling techniques for a more comprehensive customer view. I also shared best practices for building and using Power BI dashboards.

In addition to my internal responsibilities, I participated in the agency's business development by responding to commercial briefs and client calls. Played a part in recruiting and onboarding 10+ new consultants by implementing a recruitment process using technical tests. As a mentor to young consultants, I provided guidance on data-related issues and helped them develop their skills.

Worked on the review for the company's new web tracking tool on its e-commerce site. Additionally, I mentored a Data Analyst to help her provide relevant e-commerce analyses for the client. Finally, my mission was to establish clear documentation to help new data analysts to maximize their utilization of the tools available.

As a member of the Client Data Team within the Digital & Innovation Services department, I actively participate in the development of customer knowledge in the areas of Digital, E-Business, and Retail. My role involves facilitating the understanding and management of CRM issues across the Fashion, Fragrances & Beauty, and Watch & Fine Jewelry divisions.

As the responsible for completing the commercial asset base for the Mytraffic product, I oversaw a team of 20 offshore workers who produced over 4000 high-quality assets across multiple European countries (including the UK, Spain, Germany, and Italy). By developing an algorithm in Python and Postgis to identify commercial areas based on their intensity in peri-urban zones, I helped Mytraffic gain a competitive edge in the market. To provide even greater value to Mytraffic clients, I spearheaded efforts to source critical data, creating and managing regular data scrapping processes to update the database of brands, socio-demographics, and products. These additions enabled us to provide even more accurate and impactful analyses, positioning Mytraffic as a leading provider of data-driven insights. As part of my commitment to continuous improvement, I also played a key role in various R&D initiatives aimed at enhancing the quality of data provided by Mytraffic analyses. This work helped to solidify our reputation as a trusted and innovative partner for businesses seeking to make data-driven decisions.

During my role as a Growth Data Analyst, I participated in the update of the lead generation pipeline by integrating various services such as ColdCRM and Hunter. This integration helped to increase the total number of qualified leads for the Sales team by 20%. By leveraging my Python development skills, I also created a web scraper to source additional leads from various industry websites. As a result, we were able to expand our reach and generate more opportunities for business growth.

Building a data warehouse solution for data analysis and reporting needs. Development of data integration environments and pipelines through Google Cloud Platform (GCP) managed services

Enhancing the value of data through developments & improvements of new PowerBI dashboards for the L'Oréal marketing teams Business support for the validation of the algorithm results through the analysis of SSAS cubes, error logs & various Data Science processes applications developed in Python Follow-up, relaunch & improvements of data processes within the L'Oréal DataPlatform (BI and Big Data) via the following tools: Informatica, Big Data Manager, and Microsoft SSAS Contributed to the evolution of a fraud detection algorithm developed in Python