New Mexico Budget Tracking System
Updating budget tracking and generating budget adjustment requests to reflect the current working environment.
To enable the New Mexico Public Education Department (PED) to manage and coordinate the budgeting process for the hundreds of school districts and charter schools across the state, RESPEC staff first conducted a workflow analysis for budget submissions and approvals and then a workflow analysis for budget changes. Having identified new processes that closely aligned to those of PED, RESPEC staff then developed a custom-built, web-based, C#.NET SQL Server budget tracking data system called the Operating Budget Management System (OBMS). This web-based database and data warehouse system consist of a series of modules that automate the submission and email notification approval process for school budgets and budget adjustment requests. The entire public education budget for the state of New Mexico is actively managed through the OBMS, totaling more than $7 billion. PED and RESPEC staff collaborated on reengineering the business process to optimize and automate the workflow process for budget generation, approvals, and tracking by creating a single data repository and set of utilities with role-based security features, servicing 600-700 active users throughout the year. RESPEC staff reengineered business processes for grant allocation and reimbursement requests (including dependent charter reimbursement processes) and integrated OBMS with existing district accounting systems via secure, encrypted web-based file uploads. RESPEC then configured the servers with a storage area network for full redundancy and designed the database solution. RESPEC staff developed user and system documentation and related training items, and we still provide the help desk for customer support.
The OBMS, which PED has been using since 2006, helps automate and manage many aspects of school budgets, including initial planning and approval, adjustments and actuals reconciliation, and historical auditing. The OBMS runs on a large SQL Server database with more than 300 tables, 700 procedures, 35 views and operational data dating back to 2006.