TOOLBOX
NOTE: This page is under development. Some listed information may be incomplete, just like any good toolbox.
Programming & Markup Languages
Python
Automated telecom and broadband industry flowshare products using Python in a cloud environment
Integrated Python with AzureData Factory (ADF) to reduce manual processing and hand-off delays in production environment
Developed and maintained hourly automated data processing through SAP HANA datasources and Microsoft SQL Server databases
Built predictive modeling of LendingClub loan default likelihood
Led factory-wide Introduction to Python course at John Deere Harvester Works
Translated and improved over a dozen existing R and SQL notebooks into Python code for modernization in AWS Databricks
R
Developed monitoring scripts for machine data from ODBC connection in a fabrication environment
Authored global machine health alerts for crop harvesting equipment
"Computing in Industrial Engineering" course at Purdue University in 2017
SAS
Maintained legacy production code for telecom flowshare product data processing
Created extensive data QA processes for large telecom flowshare datasets
Developed Optmodel procedure scripting for scheduling, network, and transactional optimization problems
"Applied Optimization" course at University of Iowa in 2021
VBA
Automated report generation and formatting connecting SAP and Excel
SQL
SQL Server Management Studio used for table creation and maintenance of common data sources and ETL pipeline endpoints within Materials organization at John Deere Harvester Works
Completed initial data management for big data within tools such as PowerBI and Databricks
Built local database backend for monitoring part condition at North American Parts Distribution Center for John Deere
Embedded SQL within internal quality monitoring software for manufacturing environment
"Computing in Industrial Engineering" at Purdue University in 2017
C
"Programming in C" at Purdue University in 2016
PHP
"Computing in Industrial Engineering" at Purdue University in 2017
HTML
"Intro to HMTL" at Codecademy in 2013
"Computing in Industrial Engineering" at Purdue University in 2017
"Social Analytics" at University of Iowa in 2020
Visualizations, Exploration, & Reporting
PowerBI
Maintains all 80+ materials related reports for supply management, production control, inventory audits, etc. at John Deere Harvester Works
Continuous refactoring and improvements for efficient data processing and changing business needs
Utilizes Data Flows to reduce redundant computations on limited processing resources
Specializes in What-If parameter usage and developed tools for smart decision making
PowerApps
Streamlined data entry for shop floor material availability into Microsoft SharePoint online list
Prototyping and fast democratized development of applications
Tableau
Produced monthly deliverable for client in the telecom industry while working for Hawkeye
Maintained and updated reports for Materials team at John Deere Harvester Works
"Data Management and Visualization" at University of Iowa in 2020
R-Markdown
Automated daily reporting for sheet metal utilization and available at John Deere Harvester Works
RShiny
Developed forecasting and automation tools for CSV files in sheet metal parts management at JD Harvester Works Hackathon in 2019
Jupyter Notebooks
Led Introduction to Machine Learning course for new users at JD Harvester Works
"Data Science" and "Programming in Python" courses at University of Iowa in 2020
Databricks Notebooks
Developed standardized workflow and processing tools for mobile telecom and broadband industry flowshare data processing
Developed standardized research notebooks for global machine health teams monitor equipment in the field for error codes and fault conditions
Scheduled jobs for alerts to dealer network of equipment field failures
Organized and developed data wrangling notebooks for capstone project involving large data joins and feature engineering at University of Iowa in 2021
Alteryx Workflows
Utilized fast development to meet business supply chain needs following the Covid 19 pandemic
Focuses on data processing to better enable visualization and off-load limited capacities of PowerBI gateways
Particular interest in text analytics and geo-spatial machine learning
Web Development
Google Sites
This portfolio website
Substack
JavaScript Ionic Framework
Orcharrd Dating App
Audio and Photographic Editing
Adobe Lightroom
Streamlined workflow while editing hundreds of images from study abroad trip in Italy
Professional edited graduation and engagement photos for clients within two weeks of our shooting sessions
Darktable
RAW processing of personal photos
Snapseed
Fast edits and lighting corrections on mobile devices directly from camera
Audacity
Personal podcast editing completed for sponsor ad reads and sound effects
Anchor
Published over a dozen podcast episodes
Integrated into personal website developed using Google Sites
CakeWalk by Bandlab
Personal electric bass recording