Fiscal Year-End Procurement & Reporting System
Optimized city-wide year-end processes, reducing rollover time by 50% while eliminating recurring budget errors through automated workflows and cross-departmental collaboration.
The Challenge:
City departments operated in silos during fiscal year-end, with no proactive communication about budget issues or purchase order status. This created a chaotic 5-hour year-end rollover process filled with last-minute discoveries, manual corrections, and delayed transitions to the new fiscal year.
The Solution:
Redesigned the procurement close-out workflow by implementing error detection, streamlined reporting processes, and collaborative resolution. Built Visual Basic scripts to automate department-specific report generation, reducing manual processing from 1.5 days to 3 hours. Established proactive communication system with scheduled alerts and cross-departmental coordination meetings.
The Impact
- 50% reduction in year-end rollover time (5 hours → 2.5 hours)
- Zero budget errors for 2+ consecutive years
- 80% faster report generation (1.5 days → 3 hours)
- Transformed crisis-driven process into proactive, collaborative workflow
- Achieved city-wide adoption with ongoing executive recognition
Error Reporting and Communications
Built a cross-departmental communication system tied to budget alerts and error flags.
The Challenge:
Departments were missing budget and purchase order errors throughout the y ear, creating massive end of fiscal year crises with rushed connections and delayed processes.
The Solution:
Proactive email workflows with error detection reports, department-specific to transform crisis management into proactive prevention.
The Impact
Eliminated year end budget errors (for 2 consecutive years), reduced processing time by 50% and transformed crisis management into proactive prevention.
Peoplesoft Reporting & Data Auditing
Transformed manual KPI tracking into real-time visual dashboards, enabling instant performance assessment and proactive bottleneck identification across city operations.
The Challenge:
Purchase order and requisition processing times had no systematic tracking or visual indicators. Managers spent valuable time manually calculating performance metrics, making it impossible to identify bottlenecks quickly or maintain consistent service level agreements across departments
The Solution:
Architected automated KPI dashboard with color-coded performance indicators (green for 1-day, yellow for 4-day, orange for 7-day, red for overdue). Implemented sophisticated business-day calculations that account for weekends and city holidays, ensuring accurate SLA tracking. Created instant visual assessment tools that replaced manual number-crunching with at-a-glance status monitoring.
The Impact
- Instant visibility into processing bottlenecks and performance trends
- Eliminated manual calculations: managers get real-time KPI status in seconds
- Proactive error detection through automated flagging of overdue items
- Improved service delivery through early identification of process delays
- Enhanced accountability with clear, objective performance metrics