PROJECT_07 / Internal tooling & planning
A phased proposal for replacing spreadsheet-based capacity planning.
STACKNext.js · Flask · PostgreSQL · Docker · RBAC
The original Excel tracker helped managers understand employee allocation and whether the team could take on additional projects. The proposal moved that workflow toward a shared web application.
My contribution
I defined a phased migration from Excel, planned the application and access model, and worked on the initial foundation and management dashboard in phase one.
As more stakeholders used the spreadsheet, version drift, collaboration limits, and weak change visibility made it harder to keep a reliable view of capacity. The goal was clearer planning and governance, not simply replacing Excel with a newer technology.
The proposal separated an initial foundation from broader user workflows and project-specific planning.
Login, database design, uploads, and a management dashboard for utilization and hours allocation.
Employee pages, project creation, user management, role-based access, and profile editing.
A project-specific planning dashboard complementing manager and employee views.
Technical decisions
Tie each phase to a concrete planning workflow rather than attempting the whole operational surface at once.
User roles and ownership were requirements for a shared internal tool, rather than additions after the dashboard.
The effort ended after phase one when management changed and the organization no longer needed the tool. The remaining employee, access-management, and project-planning phases stayed on the roadmap.