Celeste McFarlane

About Celeste McFarlane

An engineer with demonstrated interest and experience in the transformation of data for use in social contexts.

Experience

1. Data Scientist

   Analysis Group

   Jan 2024 — Present · NY, US

   Design and conduct quantitative analyses and visualizations with large non-homogeneous datasets using R, Python, SAS and SQL to perform healthcare economics research and support expert testimony in litigation- Build interactive dashboards in RShiny to summarize and visualize patient outcomes for multiple pharmaceutical clients with products at different stages in the drug development pipeline- Engineer features for and build machine learning models for predictive analytics projects with limited, heterogeneous data- Contribute to the development of a $25 million software development project in RShiny to build drug pricing models on behalf of a pharmaceutical company to support regulatory submissions-> Lead feature planning for multiple application features, involving designing and presenting feature proposals to the client, as well as soliciting and incorporating client feedback into feature development-> Implemented application features by learning and applying industry specific knowledge to provide tailored solutions to client requests-> Fix bugs in the application under tight timelines, addressing the comments of multiple stakeholders-> Automate the maintenance of a relational SQL database connected to the application to integrate existing pharmaceutical information with newly developed application features-> Apply principles of reactive programming to refactor outdated application code to improve application speed and enhance user experience-> Collaborate with teammates by coordinating workstreams on larger features, overseeing the work of junior teammates, and performing quality assurance on feature code.

Education

• Columbia University in the City of New York

  Bachelor of Science - BS, Chemical Engineering

  2017 — 2021