Sanofi Customer Care Data Optimization Project
Darshan Singh
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.
Like this project
Posted Jul 25, 2024
I rearchitected and developed a data system to optimize SAP data processing for the Customer Care team.I built an ETL pipeline,BI Model(medallion) in Snowflake.
