Rahul SarkarFull Stack AI Engineer + Pharmacist

QUIK ERP

Full-Stack Developer2025Live
ReactTypeScriptNode.jsExpressPrismaPostgreSQLDocker
QUIK ERP cover image

Overview

QUIK ERP addresses GST compliance, drug inventory tracking, batch/expiry management, purchase workflows, reporting, barcode scanning, and supplier coordination for Indian veterinary pharmacy operations — connecting purchase, invoice, stock, and financial records through one transaction history with role-aware access.

Problem

Small pharmacies and veterinary retail teams need strict inventory and billing control without the complexity or cost of enterprise ERP systems — and, specifically, correct GST classification and filing-ready records from day one.

Approach

Built a focused ERP with a React + Tailwind + Vite frontend (barcode scanning via ZXing, printable invoices, a reports engine) and a Node.js/Express/TypeScript backend split into seven service modules: Auth, Inventory, Sales, Purchase, Reports, Accounting, and Dashboard.

Architecture

Prisma ORM schema with UUID primary keys and soft-delete support, PostgreSQL serializable transactions for stock-movement integrity, JWT-based auth with role-based access control (SUPER_ADMIN, ADMIN, PHARMACIST, SALES_STAFF, ACCOUNTANT, WAREHOUSE_STAFF), and the full stack containerized with Docker Compose.

Technology decisions

  • Snapshot seller GSTIN and state code on every invoice rather than joining to a live settings table, so historical invoices stay accurate if business registration details change
  • Compute and store supply_type/transaction_type deterministically at invoice creation, so GSTR-1 aggregation is a simple grouped query instead of a conditional nest at report time

Results

Seeded medicine records
1,000+

Outcomes

  • Deployed for pharmacy operations and used for daily billing, inventory reconciliation, and monthly reporting
  • Seeded database with 1000+ medicines

Related projects

Live2025

SARK ERP

A commercial, offline-first desktop ERP for independent Indian pharmacies — a single Go binary with an embedded React frontend and a local SQLite database.

GoReactSQLite
In progress2026

EduWav

One institutional system for students, staff, attendance, fees, examinations, and timetables — where every module shares the same academic-year boundary.

ReactTypeScriptNode.jsExpress