Data Integration Pipeline

Completed

June 2020 - April 2021

10 months

Data Integration Pipeline

Project Overview

Led comprehensive data integration efforts for 15 pharmaceutical brands and 50+ dosages, processing over 100GB of structured and unstructured data from 20 vendors. Implemented robust cleansing and transformation pipelines to ensure data accuracy and consistency across all brand reporting. The solution enabled brand managers to access reliable, unified data for decision-making.

Project Timeline

Start Date: June 2020
End Date: April 2021
Duration: 10 months

Technologies Used

PythonSQLAlteryxQlikSnowflakeData CleansingData IntegrationETL

Project Details

Company: Novartis Healthcare Pvt Ltd