Data Scientist

• Feb 2021 - Present

DB Developer and Data Analyst

• Apr 2018 - Feb 2021

Design interactive reports and dashboards using Spotfire for various internal groups including our project portfolio and resource management team, finance team, fermentation group, and the analytical group. Exclusively develop and deliver data views, functions and stored procedures from both our in-house Oracle operational DB and SQL Server data warehouse for a wide range of applications including our automation lab, various functional groups ad-hoc analyses, financial reporting as well… Show more Design interactive reports and dashboards using Spotfire for various internal groups including our project portfolio and resource management team, finance team, fermentation group, and the analytical group. Exclusively develop and deliver data views, functions and stored procedures from both our in-house Oracle operational DB and SQL Server data warehouse for a wide range of applications including our automation lab, various functional groups ad-hoc analyses, financial reporting as well as our enterprise-wide laboratory information management system (LIMS). Develop and manage the integration of various IT systems including our dev and production data warehouse, the scheduling software for the automation platform, and the Spotfire server which supports the development and distribution of various visualization reports. Create and oversee our ETL workflow by designing SSIS packages for our data warehouse, and monitoring data ingestion from our LIMS, external databases and raw files. Show less Design interactive reports and dashboards using Spotfire for various internal groups including our project portfolio and resource management team, finance team, fermentation group, and the analytical group. Exclusively develop and deliver data views, functions and stored procedures from both our in-house Oracle operational DB and SQL Server data warehouse for a wide range of applications including our automation lab, various functional groups ad-hoc analyses, financial reporting as well… Show more Design interactive reports and dashboards using Spotfire for various internal groups including our project portfolio and resource management team, finance team, fermentation group, and the analytical group. Exclusively develop and deliver data views, functions and stored procedures from both our in-house Oracle operational DB and SQL Server data warehouse for a wide range of applications including our automation lab, various functional groups ad-hoc analyses, financial reporting as well as our enterprise-wide laboratory information management system (LIMS). Develop and manage the integration of various IT systems including our dev and production data warehouse, the scheduling software for the automation platform, and the Spotfire server which supports the development and distribution of various visualization reports. Create and oversee our ETL workflow by designing SSIS packages for our data warehouse, and monitoring data ingestion from our LIMS, external databases and raw files. Show less

Senior Associate

• Apr 2017 - Dec 2017

Designed, implemented and supervised a data processing flow to manage large amounts of transactional data using SQL. Managed various datasets that required a considerable amount of cleaning, transforming and merging with overlay files. Coordinated with both internal team members and external expert firms to create an extensive notice list and transaction database for claims administration for a foreign exchange litigation case.

Associate

• Jun 2016 - Apr 2017

Resolved new data requests and inquires daily, trained temporary and newly hired associates, as well as produced various reports and ad-hoc analysis for a Senior Partner. Collected data and created a forecast that would predict the number of injured from a faulty automotive part.

Academic Intern

• Jun 2014 - Aug 2014

Discovered trends and unknown associations between chemical byproducts in over 10,000 experiments. Used principal component analysis, discriminant analysis, and various multivariate analytical tools to develop and implement a standardized workflow. Presented and explained results to the computational group and the senior leadership as well as gave a statistical ‘crash course’ presentation during a company-wide meeting. Discovered trends and unknown associations between chemical byproducts in over 10,000 experiments. Used principal component analysis, discriminant analysis, and various multivariate analytical tools to develop and implement a standardized workflow. Presented and explained results to the computational group and the senior leadership as well as gave a statistical ‘crash course’ presentation during a company-wide meeting.