The challenge
Prema ran its dairy business on paper and a desktop ERP. The goal was online access for users and faster, more reliable reports for management.
What I built
- Web migration: moved the desktop Sales module to ASP.NET MVC 5 on IIS, used by 50+ users, then Inventory, Purchase and Financial Accounting.
- Mobile invoicing with thermal printing and real-time upload, which ended the daily manual entry of paper invoices.
- FBR digital invoicing integrated in real time.
- Report performance: cut Crystal Report load time from 10 minutes to 1.5 minutes.
- Spare Parts ERP: purchase, sales and inventory management for a spare-parts business.
Technical highlights
- Ransomware recovery (Sep 2021): after an attack wiped 6 months of sales data, I rebuilt it from saved PDF reports using OCR, converted them to Excel and re-imported the data.
- Worked as Lead .NET Developer in a 4-member team.
Results
50+users on the web Sales module
10 → 1.5minutes, report load time
6 monthsof sales data recovered