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