• Generated novel marketing insights by investigating campaigns that drove engagement beyond their intended purpose• Explored data extensively, aggregating at various user attribute levels and designing metrics to gauge user interest and engagement. Extracted data using SQL in Google BigQuery, visualized and analyzed with Python• Crafted a data story through a slide deck of insights and presented to the marketing analytics team

• Re-engineered a client's existing data pipeline in Python by disconnecting it from source data in a Hive database and replacing it with source data in Google Cloud BigQuery, subsequently reducing the pipeline run time from 5 hours to 15 minutes, enabling the move from a weekly refresh to a daily refresh, and aiding the organization’s larger migration toward Google Cloud Platform.• Facilitated a client's business acquisition by using SQL and Teradata to merge the two companies’ customer databases into one comprehensive dataset.• Investigated ad hoc business data questions via SQL queries, including examining how data was mapped between tables, finding data table origins, making sense of data discrepancies, and reporting my observations and recommendations
• Maintained Tableau dashboards for data visualization.• Frequently worked with terabyte-magnitude data tables via BigQuery SQL• Created and maintained detailed documentation in Confluence• Collaborated with an offshore team in Bangalore, India

• Tutored students on class material at weekly office hours• Graded students’ homework assignments on data representation, designing relational databases, and SQL

• Explored and cleaned a Design for America teamwork survey dataset (with Excel and R) for a NASA-funded research project on building optimal astronaut teams for Mars exploration• Designed and implemented a multilevel model to examine the effects of gender on the working relationships of 4-5-person Design for America teams

• Assisted the owner of the used vinyl business in tasks such as choosing and ordering custom merchandise and researching advice for new small business owners• Established a social media presence on Instagram, Twitter, and Facebook to inspire local enthusiasm for the new business