Case Studies
A closer look at how manual processes became practical, report-ready, web-based business systems.
CETP Audit & Dispatch ERP
The Problem
Wastewater collections, chemical dosage audits, and tanker logs were recorded manually on paper logs. Slow reporting led to auditing delays, chemical usage errors, and regulatory compliance lag.
The Solution
Developed a centralized web portal to track collections, daily chemical dosage logs, and inventory status. Automated chemical audits and created one-click regulatory PDF/Excel report exports.
Technical Stack
- Backend: PHP with secure MySQL Database architecture
- Frontend: Vanilla JavaScript & CSS Grid interface
- Analytics: Chart.js visualization for trend monitoring
Risks & Failures Avoided
- Eliminated environmental compliance limit violations
- Prevented tanker dispatch logs duplication and data loss
- Avoided incorrect chemical dosing through automatic alarms
Key Technical Implementations
- Tanker dispatch logging with automatic ID validation
- Automated chemical audit limits & dosage alarms
- One-click regulatory format PDF/Excel reports
- Role-based dashboards for operators and plant managers
Operational Impact
Achieved 100% paperless daily logging, sped up environmental auditing reporting by 8x, and reduced chemical usage errors by 12% through live alerts.
SME & Retail POS Billing System
The Problem
Local retail businesses struggled with bloated, expensive desktop software that required specific POS hardware and made GST calculation difficult.
The Solution
Developed a lightweight, web-based POS software compatible with tablets and PCs. Built integrated inventory trackers, automatic GST split billing, and thermal print formatting.
Technical Stack
- Backend: Lightweight SQLite Database & Local storage sync
- Frontend: React interface with responsive CSS grid styling
- Printing: HTML5 Canvas for thermal invoice rendering
Risks & Failures Avoided
- Avoided incorrect manual tax splits and tax audit issues
- Prevented billing system downtime due to complex setup
- Avoided printer compatibility lockouts on budget hardware
Key Technical Implementations
- Local browser thermal printing support (no print drivers required)
- Real-time stock alerts and barcode scanning logic
- Multi-tax splitting and monthly GST ledger report export
- Responsive design working smoothly on mobile/tablet
Operational Impact
Queue times reduced by 40%, zero initial hardware setup costs for retailers, and simplified monthly tax filings through automated GST split reports.
KCC Loan & Field Collection Portal
The Problem
Field staff collected daily loan repayments from borrowers using paper ledgers, causing cash reconciliation errors and delays in bank deposits.
The Solution
Created a mobile-friendly collection portal that lets staff input collections on-site. Added automatic SMS receipts for customers and a live executive cash tracking dashboard.
Technical Stack
- Backend: Node.js, Express, and PostgreSQL DB
- Mobile: Responsive HTML5 and Mobile Web PWA
- SMS System: Integrated Bulk SMS Gateway APIs
Risks & Failures Avoided
- Stopped cash-in-transit disputes and ledger errors
- Prevented customer receipt mismatches via instant SMS
- Avoided collection delays in rural low-network zones
Key Technical Implementations
- Mobile web interface optimized for 3G/4G connectivity
- Instant SMS borrower receipt dispatch on collection
- Live cash reconciliation and banking dashboard
- GPS-tagged collection entry log for field auditing
Operational Impact
Reconciliation time reduced from hours to zero (instant cash balance verification), collection efficiency increased by 25%, and payment entry disputes dropped to zero.
Face & GPS Attendance System
The Problem
Labor attendance tracking on scattered construction sites relied on manual signature cards. This led to high proxy entries and took days of payroll verification.
The Solution
Created a hybrid mobile app using facial recognition for verification and GPS geo-fencing for location check-in. Built instant dashboards for contractor billing.
Technical Stack
- Backend: Serverless APIs, Firebase Realtime Database
- Frontend: HTML5 Camera APIs with face landmark detection
- Services: Google Maps API for dynamic geofencing setup
Risks & Failures Avoided
- Eliminated buddy-punching and timesheet fraud
- Prevented billing disputes with site subcontractors
- Avoided data loss on locations without internet access
Key Technical Implementations
- On-device facial pattern matching with anti-spoofing checks
- GPS geo-fencing validation with multi-site setup
- Offline sync support to store records until internet is available
- One-click payroll integration exporting clean shift logs
Operational Impact
Zeroed proxy attendance errors, cut payroll calculation time from 4 days to 2 hours, and provided live operational labor data to construction site supervisors.