Mandawar Data Entry & Transcription Service -- 2

PROJECT TITLE: Citizen Complaint & Political CRM Website Development (Mandawar)

PROJECT DESCRIPTION:
We need a full-stack web developer to build a citizen engagement and complaint management system for the town of Mandawar. The system will be integrated into our existing website (meramandawar.in).

The platform will include two main sections:

1. Citizen Portal
2. Admin Dashboard

CITIZEN PORTAL REQUIREMENTS:

- Mobile number login with OTP verification
- Simple citizen profile form (Name, Ward, Address, WhatsApp Number)
- Complaint submission form
- Complaint status tracking
- Optional image upload
- SMS notification when complaint is resolved

Complaint categories:

- Sanitation
- Water
- Drainage
- Street Light
- Tax
- Other

ADMIN DASHBOARD REQUIREMENTS:

- Citizen database management
- Ward-wise filtering (14 wards)
- Booth field support
- Complaint management system
- Status update (New / In Progress / Resolved)
- Data search and filtering
- Export data to CSV/Excel
- Role-based login

DATABASE SCALE:
System should support 20,000+ citizen records.

TECHNICAL REQUIREMENTS:

- Responsive web application
- REST API backend
- PostgreSQL database
- Cloud deployment (AWS or DigitalOcean)
- SSL security
- Daily database backup

PREFERRED TECH STACK:
Frontend: React
Backend: Node.js or Django
Database: PostgreSQL

OPTIONAL (GOOD TO HAVE):

- Auto complaint categorization
- Reminder system for pending complaints
- Ward analytics dashboard

DELIVERABLES:

- Fully working website
- Admin dashboard
- Source code
- Deployment on server
- Basic documentation

PROJECT TIMELINE:
3–4 weeks

SUPPORT:
Developer should provide at least 2 months of post-deployment support.

Please share:

- Previous dashboard/CRM projects
- Tech stack you recommend
- Estimated cost
- Timeline