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