Key Project: Hierarchy Jobs Run Time

Optimized graph database performance by implementing an improved data model and optimizing queries with Neo4j and Snowflake/SQL, achieving a 20x reduction in key job run times.

Key Project: Data Quality Mousetraps + Monitoring Dashboards

Established a data observability framework using Python, Lambda, and Power BI to create data quality checks throughout the ETL process. These checks identified known data issues, automatically created and assigned tickets based on issue type and the data's source system, and improved forecasting accuracy by 10%. Developed Power BI dashboards to visualize our Supply Chain data, make the errors public, and monitor for significant variance in the data.

Key Project: MTTR End User Support Metrics Green

Reduced total incident ticket count from over 400 to less than 100, and raised our ‘MTTR’ metric (how many tickets are resolved in less than 5 days/3 days/2 hours, based on priority) from 64% in 2021 to 81% in 2022.

Key Project: Tax & AP Systems API Integration

Developed an API integration to catch errors before invoices are exported and add AP/Tax team members to an approval flow rather than dealing with issues in the accounting systems.

Key Project: Coupa SaaS Platform Integration

Developed and integrated Coupa’s SaaS platform for global use, ensuring seamless connections to over 10 enterprise systems, managing over $4B in annual spend. Travelled to India, France, Mexico, and across the US to meet with users and understand their needs before rolling out to all Caterpillar facilities and offices around the world.
Engineered and automated integration processes by creating over 40 robust regression test scripts, eliminating the need for a dedicated testing team and drastically improving project velocity.

Key Project: Vending Machine Software Maintenance

Developed and maintained vending machine software hosted on-premises across Caterpillar facilities, ensuring high availability, zero vulnerabilities, and operational efficiency through effective database management and feature implementation using Java and Oracle DB hosted on Windows servers and Windows POS machines.

While attending IU, I worked as one of several undergrad instructors for the Programming class that taught students intermediate Python skills, data structures, and algorithms. During lab, we helped students who were stumped on exercises – urging them to understand the logic and how to solve problems themselves. Outside of class, we held office hours and graded coding assignments.

In my first job, I cooked grilled chicken/steak/etc. subs for customers. We also cleaned the restaurant and attended to customers in the most pleasant manner possible. This taught me core principles such as work ethic, timeliness, and working with a diverse group of coworkers.