Field 3: ERP Development (Enterprise Resource Planning)
- Discipline: Custom Ground-Up Enterprise & Institutional ERP Platforms
- Real Engineering Projects in Workspace:
- Oushadhi E-Commerce ERP
- School ERP (VPS SMS)
- Oushadhi Attendance & Shift Management
- Usha Service Operations ERP
1. Flagship Workspace Case Studies
A. Oushadhi E-Commerce ERP
- Client: Government of Kerala enterprise manufacturing Ayurvedic pharmaceuticals.
- Backend: Django 6 + Django REST Framework + Celery + Redis + Supabase PostgreSQL.
- Frontend: React 19 + TypeScript + Vite + Tailwind CSS v4 + TanStack Query.
- Key ERP Modules:
- Catalog & Variants: Multi-pack sizes, dosage forms, soft-delete, and keyword search.
- Inventory Tracking: Transaction logs for every stock movement, low-stock threshold alerts, and Excel batch uploads (
openpyxl/pandas). - Concurrency-Safe Orders: Atomic checkout reservations with
select_for_update, auto-cancellation stock returns, and automated PDF tax invoices. - Payment Reconciliation: Cryptographic Razorpay webhook signatures, idempotent callbacks, and refund administration.
- Logistics: Courier assignment and shipping label tracking.
B. School ERP (Vivekananda Public School SMS)
- Scale: Modular Monolith with 29 domain modules, 68 controllers, and 83 services.
- Stack: ASP.NET Core (.NET 8/9), Entity Framework Core (35+ migrations), MySQL, Angular Standalone Components with Signals.
- Key ERP Modules:
- Admissions & Student Lifecycle: Bio-data, roll number assignment, document verification, sibling mapping.
- Academics & Lesson Plans: Multi-section division, class-subject allocation, Excel-based lesson plan import.
- Attendance Engine: Daily and period-wise student/staff attendance with automated parent SMS alerts.
- Examinations & Grading: CCE grading scales, mark entry, and automated progress report card generation.
- Multi-Tier Fee Engine: Tuition, bus, hostel fees, discount concessions, installment plans, and PDF receipts.
- Payroll & HR: Faculty profiles, leave rosters, and automated monthly salary slips.
- Transport & Hostels: Bus routes, pickup stops, vehicle logs, room/bed allocations.
2. ERP Engineering Competencies
- Multi-Departmental Integration: Eliminating operational silos between HR, inventory, finance, and operations.
- Database Interceptors & Auditing: Automatic logging of
CreatedAt,UpdatedAt,CreatedBy, andUpdatedByacross all tables. - Academic/Financial Year Locks: Transactional locks preventing alteration of historical financial periods.
- Zero SaaS Fees: Fully owned, customizable source code with zero recurring vendor licensing costs.
