Dylan Demo Email and Phone Number

- Utilized SQL to organize WA state’s car data into related tables to improve query performance and data integrity.- Cleaned and transformed data using string functions, aggregate functions, and filters.- Loaded and visualized data in Tableau to display an overview of electric vehicle statistics in WA state.

- Programmed accurate and flexible excel macros in VBA to automate copying and formatting data into the company’s database.- Maintained consistent updates on newly formatted data to ensure immediate uploading into the company’s database.

- Collaborated with team members on developing models in R Studio for approximately 200 customers of Duke Energy around NC to predict kWh usage in order to target inefficient HVAC systems.- Cleaned and transformed large customer datasets (~8600 entries per customer; ~1,700,000 entries total) using R base/tidyverse packages.- Tested performance of models for each customer using an industry standard 80%-20% train-testing split.- Generated data and model-performance visualizations using ggplot2.-Presented an overview of final model results to a senior data scientist.

- Performed statistical analysis in R Studio on Trinet procurement data to confirm system error in new company technology (Oracle ERP) in preparation for upcoming audit (SOX compliance).- Presented statistical results to upper management to non-technical audiences in various departments.- Programmed excel macros in VBA to automate the data copying of procurement reports from Oracle database to a master spreadsheet.