Work
Handed over
Aapki Sewa Mein
Aapki Sewa Mein (EDMS)
Electoral and constituency data management system.
- Role
- Engineer (via The Local Sandbox)
- Timeline
- Dec 2025 – Feb 2026
- Client
- Aapki Sewa Mein
Context
An admin platform that models India's administrative and electoral hierarchy (country → state → district → block → panchayat → village → ward → booth), alongside Lok Sabha and Vidhan Sabha constituencies, as the backbone for constituency services.
What I built
- 01Hierarchical geo data on PostgreSQL + PostGIS with Drizzle migrations
- 02TOTP multi-factor authentication with QR enrolment and cookie-based JWT sessions
- 03Modern admin UI with Next.js, shadcn/ui, Zustand and react-hook-form

