Replacing 5 Disconnected Spreadsheets With One Unified Operational Platform
A commercial refrigeration and technical services company was managing customer accounts, job quotes, technician visits, van stock, and billing preparation across paper notes, local memory, and 5 separate spreadsheets. This custom platform replaced that manual friction with a single connected system where a quotation, the technician visit it triggers, the parts consumed, and the invoice generated share one operational record.
Context
Prior to this project, Fractal Tech struggled with administrative drag. Service coordinators manually copied customer requests from emails into paper job sheets, technicians called the office for equipment history, consumed spare parts went unbilled, and invoice preparation waited up to a week for intervention reports to be typed up.
In a focused 4-week delivery sprint, Anass designed and implemented a unified web and mobile operational platform. The system connects 18+ operational modules into a single pipeline: from initial quote creation to technician dispatch, mobile visit evidence capture (photos, signatures, consumed stock), automated PDF certificate generation, and invoice-ready validation.
Existing Process & Operational Problem
Before State (Fragmented Manual Handoffs)
- Quotes stored in individual Word documents.
- Interventions scheduled via WhatsApp & paper notes.
- No real-time visibility into technician van stock or spare parts.
- Technicians had no access to equipment visit history on site.
- Office coordinators manually reconciled job notes before billing.
- Invoice preparation delayed by 3 to 7 days post-intervention.
After State (Connected Operational Engine)
- Centralized customer & quote repository.
- Structured dispatch calendar with skill & region tagging.
- Technician mobile view with site access notes & history.
- Parts consumed on site automatically deduct from van inventory.
- Auto-generated PDF compliance certificates attached to job records.
- One-click validation turns completed visits into invoice-ready records.
Constraints
Custom software succeeds only when engineered within the real operating limits of the business:
Strict 4-Week Release Window
The company had an upcoming season peak and needed the system deployed without interrupting active maintenance contracts.
Non-Technical Field Staff
Field technicians required a clean, high-contrast mobile interface with zero unnecessary form fields or complex menus.
Role-Based Security
Technicians could access only their assigned jobs and parts, while managers retained quote approvals and financial reporting access.
Traceable Stock & Documents
Every spare part consumed on site had to link directly to a specific customer job ID and invoice line item.
Delivered Scope
Delivered Module Inventory
The system integrates 18+ core modules grouped into 5 functional operational domains:
1. Customer & Commercial Management
- Customer profile & site location database
- Service contract & SLA tracking
- Quote generation engine with itemized pricing
- Deposit & payment status indicators
2. Dispatch & Field Operations
- Planning calendar & job assignment
- Technician mobile visit completion view
- Equipment repair history & past visit notes
- Customer signature & photo capture
3. Stock & Inventory Control
- Central warehouse & van stock tracking
- Job-level parts consumption logging
- Low-stock re-order thresholds & alerts
- Part-to-invoice price mapping
4. Documents & Compliance
- Automated PDF certificate generation engine
- Inspection reports & safety compliance forms
- Digital customer sign-off attachments
Verification & Outcomes
All claims are governed by our evidence classification rules:
Architecture, Technologies & Security
Laravel REST API & Queues
Chosen for rapid domain modeling, robust ORM, role-based access control, and asynchronous queue processing for PDF generation.
React Single-Page Application
Provides a responsive, low-latency desktop interface for office dispatchers and a streamlined touch-friendly mobile view for technicians.
PostgreSQL Data Schema
Enforces strict relational integrity between customer IDs, quote line items, intervention logs, parts consumed, and invoice states.
Docker & Linux VPS Pipeline
Containerized application deployment with SSL certificates, automated daily offsite database backups, and Nginx reverse proxy.
Limitations & Confidentiality
What was intentionally excluded in Phase 1:
- Automated GPS route optimization (managed via manual dispatcher regional grouping).
- Direct customer self-service booking portal (planned for Phase 2).
- Automated accounting API sync (Phase 1 exports standardized CSV for accounting import).
* Framing limitations transparently ensures clients understand exact project boundaries before contracting.
Facing similar field operations bottlenecks?
Discuss your operational workflow, disconnected tools, or manual handoffs with Anass.