Cost Data Warehouse for manufacturing production insights to break out true elements of cost throughout multiple levels of subassembly production. Multiple versions exist.

Modernized communication with homeowners in the community by posting key information and documents. Prior to launch of website, homeowners in the community would need to wait for an email response to answer basic questions and receive various documents.

A profile of my experiences in the LAS @ Work blog from the University of Illinois at Urbana-Champaign through my time as Principal Architect at Corterra Solutions. Read more about me!

Saved 100's of manual hours generating a printable application form from a Google Forms response by implementing the GSuite tool called Autocrat. Autocrat allows for workflow automation in the GSuite. Particularly in this instance, used Autocrat to generate a printable document from a Forms response collected in Google Sheets.

Design and implement a system to automatically track all changes to production code (SQL, C# library, JavaScript, etc.) to support IT change audit. Read more about how this is accomplished.

Designed, lead, and engineered a custom ERP application built on top of CRM/XRM/CE/Power Platform for a global electronics distributor and manufacturer with operations in 26 different counties.

Article I wrote for SQL Server Central (750,000+ subscribers) regarding a technique in SQL Server using GoTo for looping.

Developed an interview guide process. This process improved hiring efficiency in our interview process for technical candidates. Included a three-phased approach using Microsoft Teams to initially screen, technically screen, then finally interview on-site. Both candidates and internal team members appreciated the transparent process. This enabled the team to more effectively gauge talent in a consistent manner.

Design eCommerce Interface utilizing SSIS and JSON based REST web API calls.

Website I architected to help a local non-profit dog rescue manage their own changes. This saved costly updates by a professional website design firm while still meeting their needs to find volunteers fosters, and adoption candidates. Setup the overall layout and trained the Board on updating design elements to meet the look they desired.

Time collection system design and development using Dynamics CRM, SQL Server Integration Services, SharePoint, and Reporting Services. Includes Time Sheet for manual entry labor and Time Clock for clock in/out

Lead the design of a plugin in the popular XRM Toolbox community tool supporting Microsoft Power Platform (and legacy "xRM"/CRM). Used in the deployment lifecylce to validate that solution contains all necessary dependencies. Eliminated failed solution deployments due to missing dependencies. Over 30k downloads.