highlights
Systematizing Financial Management with the United States Marine Corps
In my role as Fiscal Chief for the Battalion, I transformed a cumbersome, error-prone financial reconciliation process into an efficient, highly accurate system using innovative technology. By self-teaching database management and overcoming significant technical challenges, I developed a solution that saved time, increased financial accuracy, and was eventually adopted across the Marine Corps, earning me the Navy Achievement Medal Bronze Star.
Error Prone Manual Reconciliation
The weekly process of manually reconciling accounts involved two people spending four and a half days reviewing each line item against local records, resulting in frequent inaccuracies and delayed financial reporting.
Inability to Fully Use Funding
This labor-intensive process led to financial discrepancies of tens of thousands of dollars by the fiscal year's end, preventing the battalion from utilizing its funds effectively.
ordered
invoiced
unmet
demand
Extracted data from reports via screen scrapping software.
Built three (3) databases to hold details on what was ordered, what had been invoiced and what'sunfunded needs.
- Self-taught the necessary database management and software skills to develop the end-to-end solution.
- Implemented over 700 macros across the databases to handle all logic given the lack of programming capabilities the tools.
- Ran both the manual and automated processes in parallel for six months to ensure complete accuracy.
99.99
%
Utilization of battalions’ annual funding
2,808
Hours saved annually by reducing the reconciliation process to 30 minutes per week.
$
30k
Obtained 75% of division-wide funding for drug operations due to having real-time visibility.
Adopted across the US Marine Corps
