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