InterSELT Plan
ReactExpressPostgreSQL
Project management ERP system
Corporate ERP for InterSELT — a manufacturing enterprise (~100 employees) where I have worked since 2016. Replaced Google Sheets that slowed down with large data volumes. Requirements and engineering workflows came from firsthand knowledge of the shop floor. The interface is designed with Fitts's law in mind — comfortable for daily use.
Role: Team lead / Systems analyst / Full-stack developer.
Note: Running reliably since 2022 — continuous support and readiness to implement new ideas.
Cases
01
Authentication
JWT authentication. Six roles (admin, manager, project manager, supervisor, supervisor+engineer, engineer) with granular permissions per operation.
02
Project & task management
Full project lifecycle: creation, decomposition into department tasks, key date tracking, filtering, search, pagination. Auto-close when all departments are done. Support for R&D and recurring projects.
03
Work logging & workload
Hour logging with two-stage approval (supervisor > manager). Department workload: plan vs actual, interval breakdown, overload warnings. Russian production calendar.
04
Engineering workflow
Task decomposition into engineering subtasks with configurable stages and quality gates. Checklists by department and stage. A task is done only when all stages are approved and checklists are complete.
05
Progress & analytics
Department progress tracking: production, service, and overall. Overtime calculation when deadlines are exceeded. Separate workflow for the service department with an event timeline.
06
Real time
WebSocket broadcast of changes to all clients. Telegram bot (Python + aiogram) for work summaries with delivery and read tracking.
07
Peak-hour stability
Employees reported the UI "freezing" when many worked at once — especially before standups and at end of day. Could not reproduce under normal conditions. Built a separate load-test environment that mimicked peak usage: the system behaved like in production. Found and fixed the cause of hangs — now it stays responsive with dozens of concurrent users.
08
Administration
Employee, role, and department management. Reference data with uniqueness checks and duplicate detection. Automatic database backups.
09
Deployment
Deployed on Windows Server under IIS.
All projects