Please Wait for a moment...
Sitaram Metlon
Manufacturing & Coating
21 days
1
A complete digital transformation of a coating business, replacing manual spreadsheet and Word-based workflows with an AI-powered desktop ERP system.
Sitaram Metlon is a leading aluminum sheet coating business serving industrial clients. They coat aluminum sheets used across various industries. With growing order volumes and complex workflow requirements, they needed a modern system to replace their manual, error-prone processes.
Sitaram Metlon's operations were drowning in manual work. Every order, invoice, and delivery record was managed through disconnected Excel spreadsheets and Word documents. Data entry was entirely manual, invoice generation required copying information between documents, and there was no central system to track orders or deliveries. This led to frequent errors, lost data, and hours wasted on repetitive administrative tasks.
All order management handled through disconnected Excel spreadsheets
Manual Word-based invoice generation prone to errors and formatting issues
Zero automation - every data entry done manually by staff
No centralized system to track orders from intake to delivery
Frequent data loss due to file corruption or human error
Hours wasted daily on repetitive copy-paste administrative work
We built Metlon, a powerful desktop ERP application using Electron.js and Node.js. The game-changer was integrating Google Vertex AI—a smart AI model that reads documents and images, automatically extracting order data and building records without any manual entry. The system handles the complete workflow from order intake to invoice generation to delivery tracking, eliminating the need for spreadsheets and Word documents entirely.
Built native desktop application using Electron.js for Windows performance
Integrated Google Vertex AI for intelligent document and image data extraction
Automated order-to-delivery workflow eliminating manual spreadsheet work
Real-time order tracking and inventory management dashboard
One-click automated invoice generation with professional formatting
Centralized database replacing scattered Excel files and Word documents
Conducted deep-dive analysis of existing spreadsheet workflows and pain points.
Designed database schema optimized for coating business operations.
Built Electron.js desktop application with intuitive, fast interface.
Integrated Google Vertex AI for automatic data extraction from documents and images.
Developed automated invoice generation system replacing manual Word templates.
Created real-time order tracking dashboard for complete visibility.
Implemented centralized database system with automated backups.
Trained staff on the new system and migrated existing data.
The transformation was revolutionary. What used to take hours of manual work now happens in seconds with AI automation. The AI model reads incoming documents and automatically builds records, eliminating manual data entry completely. Invoice generation went from 15 minutes per invoice to one click. Sitaram Metlon now operates with a modern, efficient system that scales with their growing business.
Start a Project Like This