SuperLink ISP CRM – Enterprise Customer, Billing & Ticket Management System

I am looking for an experienced Full Stack Developer to review, improve, optimize, and enhance an enterprise-grade ISP Customer Relationship Management (CRM) and ticketing platform. SuperLink ISP CRM is designed to manage ISP operations from a centralized platform, including customers, sites, network connections, tickets, billing, payments, credentials, quotations, and operational workflows. The existing application is already developed using a modern PERN + TypeScript architecture, and I am looking for professional-level improvements, bug fixing, feature enhancement, UI/UX refinement, security improvements, and production optimization. ### Project Objectives The main objective is to make the platform more polished, reliable, scalable, secure, and production-ready for real-world ISP operations. ### Core Areas #### 1. UI/UX Refinement * Create a modern enterprise SaaS-style interface * Improve dashboard design and information hierarchy * Improve navigation and sidebar structure * Improve forms, tables, filters, and data presentation * Improve customer and site management screens * Improve ticket management interface * Improve billing and payment screens * Improve responsive behavior * Improve loading, empty, success, and error states * Add professional animations and micro-interactions where appropriate * Improve accessibility and usability #### 2. Customer Management Improve the complete customer lifecycle, including: * Customer creation and management * Customer profile and details * Sites and connections associated with customers * Customer ticket history * Payment history * Customer activity visibility * Search, filtering, and sorting #### 3. ISP Site & Network Management Improve the site management workflow, including: * ISP site directory * Connection types * Site status * Network lifecycle tracking * Feasibility workflow * Survey and approval workflow * Provisioning * Active connections * Renewal tracking * Suspension and disconnection workflows The expected lifecycle is: FEASIBILITY_PENDING → SURVEY_IN_PROGRESS → FEASIBILITY_APPROVED/REJECTED → PROVISIONING → DELIVERED_ACTIVE → RENEWAL_DUE → SUSPENDED → DISCONNECTED #### 4. Ticketing & Support System Improve the ticketing system for operational and customer support teams.

Requirements

include: * Ticket creation * Ticket assignment * Priority management * SLA tracking * Ticket status management * Internal and customer messages * Ticket history * Real-time ticket updates * Reopening resolved tickets * Better notification and alert handling The platform should support tickets originating from multiple sources such as manual creation and messaging integrations. #### 5. Billing & Payments Improve the billing and payment management functionality, including: * OTC billing * MRC billing * Static IP charges * Renewals * Payment tracking * Invoice management * Payment history * Billing status * Better financial dashboards and reporting #### 6. Role-Based Access Control Review and improve the existing RBAC system. The application currently supports different operational roles such as: * SUPER_ADMIN * ISP_OWNER * SALES * NOC * FINANCE * SUPPORT * CLIENT Each role should have appropriate permissions and access restrictions. #### 7. Security Security is an important part of this project. I need: * Authentication review * Authorization/RBAC review * JWT security improvements * API protection * Input validation * Secure credential handling * Sensitive-data protection * Secure error handling * Audit logging * Security best-practice review The application includes an encrypted credentials vault using AES-256-GCM, which should be reviewed carefully during development. #### 8. Real-Time Functionality Review and optimize the real-time communication architecture using Socket.io. Focus areas: * Real-time ticket updates * Live alerts * Connection stability * Reconnection handling * Event management * Performance * Multiple concurrent users * Avoiding duplicate or missed events #### 9. Excel Import & Export Improve the Excel-based data workflows: * Import templates * Data validation * Preview before import * Error reporting * Export functionality * Large dataset handling * User-friendly validation messages #### 10. Dashboard & Analytics Improve the administrative dashboard with: * Operational statistics * Customer statistics * Active/renewal connections * Ticket metrics * SLA information * Payment information * Charts and visual analytics * Useful filters and date ranges The dashboard should provide actionable information rather than simply displaying numbers. #### 11. Maps & Location Features The platform uses Leaflet for map functionality. I would like the map experience and related site/location workflows to be reviewed and improved for usability, performance, and responsiveness. #### 12. Backend & API Optimization Review the Node.js/Express backend for: * API architecture * Database queries * Prisma usage * Validation * Error handling * Middleware * Authentication * Authorization * Performance * Code organization * Scalability The API should remain clean, consistent, maintainable, and production-ready. #### 13. Frontend Optimization Review the React frontend for: * Component architecture * State management * TanStack Query usage * API integration * Unnecessary re-renders * Loading states * Error states * Form handling * Responsive layouts * Performance * Reusable components #### 14. Production Readiness Before final delivery, I want a complete production-readiness review covering: * Performance * Security * Scalability * Database optimization * API reliability * Frontend performance * Real-time functionality * Error handling * Logging * Authentication * RBAC * Responsive design * Cross-browser compatibility * Deployment configuration ### Current Technology Stack **Frontend** * React 18 * Vite * TypeScript * Tailwind CSS v4 * TanStack Query **Backend** * Node.js * Express.js * TypeScript * Prisma **Database** * PostgreSQL **Real-Time** * Socket.io **Au