Big Data Migration and Analytics at Spark Therapeutics
Challenge:
Spark Therapeutics struggled with fragmented data systems and inefficient workflows, leading to delays in product development, shipping, and quality control processes. They also needed a centralized tracking solution to improve operational visibility.
Optimization:
Enhanced Databricks and Snowflake platforms, improving processing efficiency by 20% and reducing data processing times by 35%.
Centralized Tracking:
Developed a Main Centralized Tracker System to monitor key activities such as product development, shipping, testing, and quality control. This provided a single source of truth for all stakeholders.
Dashboard Development:
Created interactive dashboards using Power BI and Python to deliver actionable insights in real time.
Collaboration:
Provided training to quality control teams and upper management to ensure adoption of the new tools and processes.
Results:
Improved process visibility by 40% through centralized tracking.
Reduced project completion times by 25% with streamlined workflows.
Increased decision-making speed by 30%, enabling faster time-to-market for critical products.
