Protocept — R&D Project Management Platform
Project Management System that serves to track project timeline and progress of research initiatives. Built as a lightweight, accessible web platform with an integrated performance tracker to balance researcher workloads and recognize personnel specializations.
Waiting For Thumbnail
Challenge & Architecture Target
No Integrated System to Track Project Progression
The legacy workflow relied on manual report sign-offs from unit heads to verify research progress. This platform provides real-time transparent reporting, minimizing cross-team latency so researchers can focus on innovation rather than bureaucracy.
Automated Report & Task Scoring System
Delivers an executive dashboard illustrating R&D velocity, research bottlenecks, and milestone progression. An algorithmic scoring engine helps managers balance PIC workloads based on task weight.
Engineered Modules
Formulation & Trial Lifecycle
Tracks batch formulation iterations for every research trial. Includes a Formula Marker allowing teams to flag scale-up ready recipes for handover to mass production lines.
Headless Google Sheets Integration
Bi-directional synchronization with existing laboratory spreadsheets using Google Sheets API, preserving existing operational habits without disruptive data migrations.
Material Catalog & Production Costing
Centralizes ingredient inventories and calculates projected industrial production costs directly from trial recipe usage and dynamic batch yields.
HTTP Gateway & RBAC Session Guard
Enforces Role-Based Access Control (RBAC) across division scopes. Secured API endpoints with request signing ensure restricted R&D intellectual property is shielded from unauthorized access.
Architectural Highlights
ORM Architecture & DB Migrations
Leverages Prisma ORM to bridge safe type connections to PostgreSQL, preventing raw query vulnerabilities and providing deterministic schema evolution tracking.
Automated CI/CD & Multi-Stage Deployment
GitHub Actions automation executing rigorous type checking, linting, and unit validation, accompanied by staged preview environments for user verification.
Rate Limiting & Auth Guard
Guards endpoints against unauthorized data modification and implements sliding-window rate limiting to safeguard the server cluster against burst traffic.