Sanofi Customer Care Data Optimization Project

Sanofi Customer Care Data Optimization Project

I rearchitected and developed a Medallion architecture at Sanofi using Snowflake to process SAP data for the Customer Care team. My role included:

System Design and Architecture: I designed and developed a Medallion architecture using Snowflake to optimize data processing.

ETL Pipeline Creation: I built an ETL pipeline to transform and store data in an AWS Athena data lake, enabling efficient data handling.

BI Model Development: I created a BI model that integrated with Power BI, enhancing reporting capabilities.

Transformation Migration: I migrated data transformations to Snowflake using DBT, improving performance and maintainability.

Process Orchestration: I implemented Airflow DAGs to manage DBT processes, ensuring seamless workflow automation.

This project resulted in optimized data handling and improved reporting efficiency for the Customer Care team.