TMMA Customer Portal

Overview

A full-featured operational portal built to replace manual spreadsheet workflows with structured digital tracking, secure multi-role access, and booking automation. Clients track order progress in real time with structured status updates and a clear audit trail managed by administrators.

Summary

Custom customer portal serving 5000+ users — enabling real-time order tracking, role-based dashboards, and automated workflows that replaced manual spreadsheet operations.

Responsibilities

• Designed and developed a custom customer portal enabling clients to track order progress in real time with structured status updates and a clear audit trail managed by administrators
• Built role-based access control with secure email-based JWT authentication and refresh token rotation stored in HTTP-only cookies, ensuring scoped permissions and tailored dashboards per role
• Designed a normalized SQL schema to manage users, orders, consultation bookings, and status history, ensuring data integrity and accurate order tracking across the platform
• Integrated the Amelia Booking system for consultation scheduling, rescheduling, and cancellations directly from the dashboard
• Automated order visibility workflows with real-time status progression, replacing manual spreadsheet tracking and improving operational transparency and administrative efficiency

Key Achievements

• ✓Served 5000+ active users across customer and admin roles
• ✓Eliminated manual spreadsheet dependency through automated order tracking and real-time status workflows
• ✓Secured multi-role access with JWT refresh token rotation and HTTP-only cookie storage
• ✓Integrated Amelia Booking for end-to-end consultation scheduling directly from the dashboard

Challenges

• Ensuring secure role separation and scoped permissions across multiple dashboard views
• Maintaining data integrity across complex relational order and booking workflows

Outcomes & Impact