Back to All Projects
Case Study • [03.01]
01Full-Stack Enterprise SystemProduction Client System

EtechCRM

Client Management & Field Visit Tracking Platform

Client • Excel Technologies & Services
Client ManagementField Visit TrackingTanStack Query & ZodVercel Serverless
SYSTEM ARCHITECTURE & VERIFIED WORKFLOWPRODUCTION CLIENT APPLICATION
Excel Technologies • Field Operations & Client CRM
PRODUCTION DEPLOYMENT
Active Field Visits
18 / 20
90% Target Met
Enterprise Accounts
142
Multi-Tenant Scoped
GPS Verification
100%
Zero Coordinate Drift
Sync Engine
TanStack
Optimistic Cache
REAL-TIME FIELD VISIT AUDIT STREAMKOLKATA METROPOLITAN REGION
Technocraft Engineering LtdAnnual Maintenance
22.5726° N, 88.3639° E•Exec: A. Banerjee
VERIFIED & SYNCED14:32 IST
Eastern Power Systems CorpTransformer Audit
22.5851° N, 88.4124° E•Exec: S. Mukherjee
IN TRANSIT15:10 IST
Metro Rail Logistics HubField Equipment Check
22.5697° N, 88.3562° E•Exec: R. Sen
SCHEDULED16:30 IST
01 • Operational Challenge

The Problem & Requirements

Excel Technologies & Services required a centralized system to coordinate field visits, log client interactions, and manage account documentation without latency or sync errors across distributed field teams.

02 • Architectural Solution

System Design & Delivery

Engineered a responsive web portal utilizing React 19, TypeScript, and Vite with route-level code splitting. Implemented Zod schema validation for data integrity and TanStack Query for background state synchronization with MongoDB Atlas M0.

03 • System Architecture & Implementation Details

Technical Pipeline & Data Flow

Vite SPA with route code-splitting and ErrorBoundary isolation; Express 5 API deployed on Vercel Serverless Functions; MongoDB Atlas M0 with Mongoose schemas; Cloudinary signed image uploads for field documentation.

Verified Production Features:
Field visit scheduling, tracking, and visit report submission.
Comprehensive client profile management with historical engagement records.
Client-side form validation using React Hook Form paired with Zod.
Asynchronous server state caching, pagination, and optimistic updates via TanStack Query.
Responsive analytics dashboards visualized with Recharts.
04 • Verified Technologies & Tooling
React 19TypeScriptViteExpress 5MongoDB AtlasCloudinaryTanStack QueryZodRechartsTailwind CSS v4
LET'S CONNECT • PROJECT INQUIRY

Interested in deploying this architecture or collaborating?

Available for software engineering roles, full-stack systems design, and applied AI application development.

Connect via Direct Channels