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

**Authentication**

* JWT

**Security**

* AES-256-GCM encryption
* RBAC
* Audit logging

**Other Technologies**

* Leaflet
* SheetJS/XLSX
* REST APIs

### Expected Result

I want the final system to become a professional enterprise-grade ISP CRM platform with:

* Premium and intuitive UI/UX
* Reliable ISP operational workflows
* Strong customer management
* Efficient ticket management
* Accurate billing and payment workflows
* Secure credential management
* Granular role-based access
* Stable real-time notifications
* Fast and scalable APIs
* Optimized database operations
* Clean and maintainable code
* Production-level security
* Responsive design
* Professional dashboards and reporting

### Important

Please review the existing codebase and architecture before making major changes.

I prefer a developer who can first identify the existing issues, explain the recommended improvements, and then implement them systematically without unnecessarily rewriting working functionality.

The priority is **quality, security, maintainability, performance, and production readiness**.

Repository:
https://github.com/vimalraj1112/Superlink

Please include:

1. Your experience with React, Node.js, Express, TypeScript and PostgreSQL
2. Your experience with Prisma
3. Your experience building CRM/ERP/ISP/business management systems
4. Your experience with RBAC and secure authentication
5. Your experience with real-time Socket.io applications
6. Similar projects you have worked on
7. Estimated timeline
8. Estimated cost