Case study
ShiftFlow
Modernizing legacy workforce scheduling and payroll processes for manufacturing operations.
- Status
- In development / payroll period validated
- My role
- Solution design, technical leadership, and delivery (scope described below)
- Focus areas
- Workforce scheduling
- Payroll validation
- Legacy modernization
At a glance
A comparison for one specified pay period achieved a 100% cell-level match against an HR reference. This is not evidence of general payroll accuracy.
The challenge
Workforce scheduling and related processes depend on an aging Microsoft Access-based system with years of accumulated business rules and undocumented exceptions.
My role & decisions
I independently initiated the replacement and work with operational stakeholders and power users to discover requirements, interpret legacy logic, and translate workflows into a maintainable application.
The solution
Built with Next.js, TypeScript, Prisma, PostgreSQL (Neon), and Vercel. The evolving scope includes rotating crew schedules, a multi-week schedule view, vacancy management, overtime and red-hour calculations, PTO and shift adjustments, on-call workflows, and visibility into active shifts.
Verified progress & results
One specified pay period was checked against the HR reference and matched at the cell level. This is a validation milestone, not evidence of general payroll accuracy or full production rollout.
What's next
Continue module development, operational validation, user testing, and deployment readiness.
What this work demonstrates
This project illustrates my approach to identifying operational needs, making pragmatic architectural and delivery decisions, and connecting software capabilities to business workflows.