Full-featured WPF desktop ERP managing 2M+ records with production scheduling, real-time inventory tracking, and sub-second query performance.
The Challenge
The client's existing off-the-shelf ERP couldn't handle their domain-specific manufacturing workflows — production scheduling across 3 shifts, real-time raw material consumption tracking and supplier performance analytics were all manual spreadsheet processes.
The ERP vendor quoted 18 months and $400K for customisation. The client needed it done in 8 months at a fraction of that cost.
Our Approach
We embedded a business analyst with the factory floor team for the first three weeks, documenting every workflow, exception and edge case before writing specifications. This meant zero requirement changes during development.
We delivered a fully functional core ERP in month 4 and spent months 5-8 on advanced modules, reporting and user training.
The Solution
A full-featured WPF desktop ERP covering: production order management, raw material tracking, shift scheduling, supplier management, quality control logging, Crystal Reports suite with 40+ report templates, and Windows Service background jobs for real-time KPI calculation.
SQL Server query optimisation with indexed views achieved sub-second response times across 2M+ records.
The Results
500+ daily active users from day one of go-live. Sub-second query performance across all modules. Manual spreadsheet processes eliminated entirely. Management now has real-time production KPIs available at any time.
DebMedia built our custom ERP from scratch. It now manages our entire manufacturing operation — 2M+ records, flawless performance. Debasis understands both business and technology deeply.
Key Learnings
Embed Before You Build
Three weeks on the factory floor learning the actual workflow saved months of requirement changes during development. No amount of meetings can replace direct observation.
Query Optimisation is a Feature
Designing indexed views and query plans as a first-class deliverable — not a performance fix — is what made sub-second queries achievable at 2M+ record scale.
Training is Part of Delivery
Allocating a full month of the project budget to user training and documentation is the difference between a system that gets used and one that gets abandoned.