Drew Tschetter bio photo

Drew Tschetter

Data Scientist interested in the healthcare and climate change/environmental sustainability sectors. Master's of Data Science from The George Washington University

Email LinkedIn Instagram Github Steam

Education

Oxford Climate Society

School of Climate Change Certificate (expected completion March 2024)

January 2024 - March 2024

The George Washington University

Masters in Data Science

August 2016 - December 2017

State University of New York: College at Brockport

Bachelors in Mathematics, with minors in Biology and Chemistry

August 2007 - December 2011

Employment

Lead Consultant

Two Circles Inc. (New York, NY)

April 2021 - August 2023

  • Updated and maintained Python script that created copies and updates to individual school Tableau dashboards from the master template
  • Created Tableau dashboard to track programmatic ad performance of blended 1st and 3rd party data
  • Managed ETL process of 3rd party ticketing data of member teams, implementation of automated SQL data quality checks, and the upkeep of the pipeline to Power BI reporting dashboards for a sports league
  • Learned Alchemer to design, implement, and analyze a lewague-wide fan survey
  • Managed a 3rd party ticketing data warehouse solution for a sports team
  • Managed the implementation of propensity modeling and machine learning lead scoring pilot to increase premium sales for a venue ownership group
  • Managed business development project for a mutli-team organization from proposal to delivery, including multiple market surveys, existing fan survey, corresponding analyses, and created an unsupervised clustering model (k-means and k-modes) to identify audience segments from the market surveys
  • Developed Python script to create random, non-repeating pairings for internal coffee dates for North America staff

Senior Consultant

Guidehouse LLP (Washington, DC)

November 2019 - April 2021

  • Customized and expedited data management in R to deploy visualizations in Power BI
  • Utilized SQL, R, and HTML to scrape client documents and aggregate data to populate a process improvement Power BI dashboard
  • Deployed a Javascript/jQuery web scraping solution for client to improve project tracking capacity
  • Transitioned a data redaction process from PowerQuery and SQL to an automated Python solution
  • Learned UIPath to create a web scraping bot to collect abstracts and research papers from a medical conference website
  • Learned Qualtrics to create surveys with custom Javascript functions, and develop Power BI visualizations to analyze the results

Consultant

Ernst & Young LLP (McLean, VA)

July 2018 - November 2019

  • Administer ETL of client data with SQL Server
  • Create data preprocessing automations and analyses, including logistic regression prediction, in R and Python
  • Learned and utilized web development stack to enact changes to client’s collaboration website
  • Collaborated with backend web-dev engineers to incorporate NLP into search function of client solutions

Data Analyst Intern

World Wildlife Fund (Washington, DC)

May 2017 - May 2018

  • Organize and clean data in R, Python, and MS Excel
  • Calculate and implement food waste metrics for corporate partners
  • Develop food waste analysis dashboards in Tableau and manage with Tableau Server

Certifications

Esri

GIS for Climate Action

2023

PADI

Open Water Scuba Diver

2024