Programming

headshot
Python -
Used extensively for work-place data analysis/data manipulation, web applications, and personal projects. Advanced beginner level. 
VBA -
Used extensively to create and maintain custom software used by entire company. Equipment/experiment scheduling, userforms, automated data manipulation and analysis, graphing, auto report generation in Powerpoint, communication with Access database, file manipulation, etc.
SQL -
Frequently used within VBA and Python CRUD applications. I've designed, created, and maintained several shared workplace databases
Apps Script -
Used to maintain collaborative Google Sheets product inventory, including in-sheet data visualization, automated data retrieval/updates, and scripts and forms for custom data filter views.
Matlab -
My first programming experience, used broadly throughout my PhD and work history for data analysis, GUI creation for team collaboration, and basic automation.

Projects

Multi-Purpose Digital Frame and Live Stream Viewer

Framed digital display with controller for viewing livestreams, acting as digital picture frame, and other video functions

Read More
Family Tree

Customizable family tree image and chart generator

Read More
Solar Radiation and Solar Smart Window Dashboard

Plotly-Dash Dashboard for displaying solar radiation data and calculations about powering smart window features with solar windows at various locations in the world.

Read More
Solar Radiation Contour Mapping

Contour mapping of geographic solar radiation data (sourced from NREL) at different locations, angles, and orientations.

Read More
Custom Music Cards

Custom printed cards that play music/audio through speaker via Home Assistant

Read More
Screenshot Warning Message

Send email or slack message based on color of a set point on screen (e.g. warning message for equipment error state). Workaround for tool where we can't connect to status output directly.

Read More