Co-Op: Preclinical Manufacturing Process And Development - Technology Transfer And Logistics
• Supported the project management team in the Tech Transfer and Logistics Department by enhancing tools, resources, business processes,and optimizing workflows to drive efficiency, establish best practices, and facilitate seamless communication across multiple departments.• Automated Excel-based forecasting tools that analyzed data to generate detailed data summaries and advanced visualizations in a dynamicPower BI dashboard, enabling users to identify required assay groups and molecule formats within a customizable time frame.• Developed streamlined template for future iterations, ensuring the easy integration of new molecule formats and assay groups.• Implemented a Continuous Improvement Tracker by integrating data from a SharePoint list and utilizing Power Automate to generate newcalculated metrics, automating project prioritization. Streamlined data summarization in Power BI, significantly reducing FTE hours.