Alexandre Rocat

At CMP Group, I designed and architected an AWS Data Lake, leveraging cloud and Big Data technologies to optimize data storage and processing. 🏗 Designed and implemented the Data Lake architecture on AWS S3, Glue, Athena, and Spark, ensuring a scalable and high-performance infrastructure. 🔄 Automated data pipelines with Airflow, reducing manual interventions and improving processing reliability. 🚀 Optimized data transformation workflows using Python and Spark, increasing processing speed and efficiency. ☁ Deployed serverless architectures via AWS Lambda, cutting operational costs and enhancing scalability. 🛠 Monitored and proactively maintained systems using CloudWatch, ensuring high service availability. 💡 Impact: By designing the Data Lake architecture, I structured and industrialized data management, enabling better accessibility and reliability for analytics and decision-making.

I collaborated with several small and medium-sized businesses to collect and process data from various web sources while also providing training in Artificial Intelligence and cloud technologies. 🤝 Partnered with SMEs to understand their data collection and analysis needs. 🕵️‍♂️ Developed web scrapers to extract, structure, and centralize data from different websites. 📊 Transformed and integrated data into CSV files and stored them in a PostgreSQL database for improved accessibility and analysis. ⚙ Automated data workflows to enhance data quality and streamline the collection and analysis process. 🎓 Provided training and mentorship on AI and Cloud Computing for professionals and students, covering topics such as Machine Learning, cloud architecture (AWS/GCP), and model optimization. 💡 Impact: Helped multiple SMEs structure and leverage their data, improving their decision-making and competitiveness, while also upskilling their technical teams.

At CMA-CGM, I worked on a strategic project focused on contact data cleansing and enrichment, improving the quality and consistency of information used by internal tools. 🛠 Refactored and standardized contact data, ensuring compatibility with business tools. 🔄 Merged and aligned historical and new data models to maintain consistency and data integrity. 🏗 Designed a new database schema for better data management and scalability. 📡 Researched and integrated new data sources, developing algorithms to enrich missing information. 🚀 Automated data validation and cleaning processes, ensuring reliability and reducing manual interventions. 💡 Impact: This project enhanced the quality and reliability of customer data, optimizing its usability for sales and analytics teams.

At BPI-France, I played a key role in modernizing data infrastructures by designing and optimizing an AWS Data Lake, while training teams on Big Data technologies. 🏗 Developed and managed a Data Lake on AWS (S3, Glue, Athena) to centralize and structure financial and analytical data. ⚡ Built scalable data processing pipelines using PySpark, ensuring high-performance analytics. 🔄 Integrated and managed real-time data streams with Kafka, ensuring seamless synchronization across multiple sources. 🚀 Decommissioned the Matillion ETL, migrating workflows to a more modern and optimized AWS-based infrastructure. 🎓 Onboarded and trained teams on Spark and AWS services, facilitating adoption of new technologies and improving data team efficiency. 🛠 Orchestrated ETL workflows with Airflow, automating and streamlining data processing. 📈 Worked within Agile SAFe sprints, contributing to continuous delivery and iterative improvements of data pipelines. 💡 Impact: I contributed to modernizing BPI-France’s data infrastructure by replacing outdated tools and training teams on cutting-edge technologies, improving data reliability and processing efficiency.

At Kering, I contributed to the implementation of a Data Vault architecture to build a 360° customer view, consolidating data from various brands to enhance analytics and personalized customer experiences. 🏗 Designed and implemented a Data Vault to structure and centralize customer data from the Data Lake. ⚡ Developed data transformation pipelines using Python (Airflow) and Scala (Spark) for efficient data processing. 📊 Created an analytical database from Parquet files, making data accessible through AWS Athena. ☁ Managed data storage on AWS S3, ensuring optimal accessibility. 🚀 Implemented a CI/CD process with Jenkins, automating deployments in the development environment. 💡 Impact: This project enabled Kering to enhance customer insights by consolidating data from multiple sources, improving marketing strategies and personalized offerings.

At Hult (EF), I worked on consolidating and analyzing data from MarketingCloud and Salesforce, optimizing marketing campaigns and student acquisition strategies. 🔄 Extracted, transformed, and loaded data from MarketingCloud and Salesforce into AWS. ⚡ Developed ETL pipelines using AWS Glue and PySpark (Python) for data processing and normalization. 📊 Created an analytical database from CSV and Parquet files, making data accessible via AWS Athena. ☁ Managed data storage on AWS S3, ensuring optimal scalability and accessibility. 📈 Built dashboards and visualized data using Tableau, providing insights to improve marketing strategies and lead conversion. 🚀 Worked in an Agile environment, ensuring continuous delivery and rapid iterations on data pipelines. 💡 Impact: I contributed to optimizing lead management and marketing campaigns, improving decision-making and increasing student conversion rates.

At Artefact, I contributed to the development of a promotional platform for a major retail group, enabling real-time management of offers and promotions using a microservices architecture. 🔍 Designed and implemented a microservices architecture on Google Cloud Platform (AppEngine), ensuring scalability and reliability. 🛠 Developed new features and an admin interface, improving data management and monitoring of promotions. ⚡ Built backend services using Python (Flask) and frontend components with Node.js (Vue.js) for a seamless application experience. 🏗 Managed data storage in PostgreSQL, optimizing it for promotional data processing. 🚀 Implemented versioning mechanisms to maintain service continuity and stability. 📈 Worked in an Agile environment, delivering iterative improvements to meet client needs efficiently. 💡 Impact: This project automated and optimized the management of promotions, reducing errors and improving the responsiveness of marketing campaigns.