Experience
Advocates for Human Potential
Data Visualization Specialist
November 2022 — Present
- Wrote multiple Python ETL scripts to extract data from multiple spreadsheets and load into a MySQL database hosted on AWS
- Designed and Developed Interactive Data Dashboards for use by state agencies to help allocate approximately $1bn in grant funding
- Wrote Python scripts to automate data transfer into Smartsheet and create new sheets based upon templates
- Created Tableau Dashboards for public facing websites to demonstrate the success of grant funding initiatives
Corning Inc
Intern
July 2020
- Consolidated and cleaned 1 year of web log data from multiple Excel sheets
- Performed exploratory data analysis to understand application usage
- Segmented 250 application users based on page visits using K-Means clustering
- Reported findings about the 5 user segments to management
Production Modeling Corporation
Freelance Web Developer
June — August 2019
- Designed and deployed 25 webpages for new lines of business
- Revitalized old webpages with additional information and new offerings
- Updated navigation and information to reflect changes to company portfolio
Intern
June — August 2017
- Created layouts and mock ups for new website
- Deployed single node Hadoop system for internal testing purposes
- Developed ETL pipeline to ingest customer relationship data into Hive using Pig
- Performed exploratory data analysis using Zeppelin, SQL, and Spark
- Presented findings and data visualizations of customer interactions to management
Empati Reklam
Intern
July — August 2016
- Designed 10 unique holiday and event posters for shopping malls
- Created 2 Powerpoint templates for presentations
- Zafer Bayramı Poster selected for Carrefour shopping malls in Turkey
Education
DePaul University
MS Data Science, December 2020
School of the Art Institute of Chicago
BFA, May 2018
Skills
- Python
- pandas
- sci-kit learn
- numpy
- R
- tidyverse
- SQL
- PL/SQL
- MySQL
- Tableau
- Power BI
- LaTeX
- Illustrator
- InDesign