Program Analyst
CurrentLeading a team of Statisticians, built Salesforce reports using program inspection data fields with more than 30,000 rows of data then created or manipulated Microsoft Excel functions to produce weekly data analytics reports for managers of a brand-new housing inspection program.Used Excel Visual Basic macros to clean inspection data, produce weekly program budget reports, and to maintain a stakeholder call log. Discovered that a contractor was billing the government at last option year’s pre-modified level, preventing potentially $344,000 in overpayment. Developed and implemented a phased asset recovery plan to ensure devices were available for future training after a 40 percent contract reduction.