Dilbag

Met with stakeholders to define platform requirements. Documented user stories, data relationships, and business rules for the core functionality.

Designed the relational schema in Prisma with normalised tables, proper foreign keys, cascading deletes, and indexes for performance-critical queries.

Refined the schema based on edge cases — added soft deletes, audit timestamps, and polymorphic relations for flexible content types.

Built Next.js API routes with proper validation, error responses, and pagination. Implemented middleware for authentication and request logging.

Coded the core business logic modules including state machines for workflow management, permission checks, and data transformation pipelines.

Created comprehensive seed scripts for development. Wrote integration tests for critical database operations and API endpoints.

Profiled slow queries and added database indexes. Implemented connection pooling and query batching with Prisma's findMany optimisations.

Refactored codebase for standard compliance. Removed hardcoded secrets, added environment variable validation, and implemented input sanitisation.

Wrote comprehensive README, API documentation, and architecture decision records. Created migration guides for future schema changes.