This work focuses on operational visibility and labor cost optimization built on top of an existing payroll system. Implementation details are private due to sensitive workforce and financial data.
Context
Multi-location parking operations with diverse shift patterns and external schedules
Payroll and timekeeping managed through Paychex, serving as the system of record
Leadership required clearer visibility into labor costs, overtime exposure, and compliance trends
Constraints
All analysis needed to align with Paychex as the authoritative payroll source
Reporting had to be informational and advisory, not disruptive to existing HR workflows
Insights needed to scale across locations, entities, and time ranges
Solution
Built automation to compare external schedules against Paychex timecards to surface alignment gaps
Generated daily, monthly, and yearly reports highlighting overtime, meal premiums, and labor cost trends
Calculated opportunity-level savings where schedule adjustments could reduce premium labor costs
Delivered concise daily summaries to an executive Slack channel for operational awareness
Key Decisions
Treated Paychex as the single source of truth while layering analytics externally
Focused reporting on trends and optimization opportunities rather than individual-level enforcement
Designed outputs for leadership consumption: short, actionable, and non-intrusive
Impact
Improved leadership visibility into labor utilization and premium cost drivers
Enabled proactive schedule adjustments that reduced overtime and meal premium exposure
Established a repeatable analytics framework for labor cost monitoring without changing core HR systems