Hooah Valentine's Day! In celebration of my love for federal IT work, here's a quirky story about my first Low-Code/No-Code solution presented by then, PFC Enrique "Gizmo" Gomez to his first federal "client"... the US Army 1st Cavalry Division at Ft. Hood (now Cavasos), circa 1997.
As a member of the finance team quartered within the 1st Cav Division HQ building, we supported all of the fine men and women dedicated to providing our nation's security. On a daily basis, we processed promotions, allotments, changes in pay, pay advances, hazardous duty pay, "death gratuities" (sadly), and an assortment of other services related to payroll.
Processing was one step better than punchcards (but not much better), where snippets of code were entered and then uploaded as a batch each night, with error reports indicating which transactions had errors and had to be corrected. QA was completely manual and prone to high errors which impacted soldier pay.
Using a simple MS Access database and simple front end (as it was all we had), a small team of front counter staff, including myself, designed and refined a process to automate the front-end and customer facing workflows where the transaction codes were written up front and validated by the acting NCO (non commission officer in charge of customer service) before it even got to the coders. This reduced error rates from 30-35% to under 1% overnight, and even lower as the process was refined.
My reward for a job well done you ask? Being tasked out as system security officer to oversee Y2K compliance for the brigade. And so began my journey in IT and solutions design. This is where it all started.
Cheers!