Flutter App Developer in Punjab
DoodHisaab Case Study

Project Challenge & Context in Punjab

Dairy farming and milk collection form the economic core of rural Punjab. However, local milk collection operators and milkmen (known locally as *doodhis*) traditionally record twice-daily collections in physical paper notebooks. This manual ledger method is highly prone to mathematical errors, payment disputes, and lost data due to damaged notebooks. Because cellular connectivity is highly unstable in the outer fields of Muktsar Sahib and Bathinda, any standard cloud-hosted SaaS tool is completely unusable during active collection hours.

These connectivity constraints mean that milk collection centers need a solution that runs locally on simple mobile hardware while matching the operational realities of local cooperatives.

The Engineering Solution

To resolve this connectivity gap, I architected **DoodHisaab** as an offline-first mobile database application. Built with Flutter, the app utilizes a local relational SQLite database embedded directly inside the device sandbox. This guarantees that data is written immediately, even without internet access.

SQLite Database Schema and Data Integrity

The underlying database is built using a normalized schema that links clients (farmers) to daily collections. The main collections table tracks volume, milk FAT percentage, SNF (Solids-Not-Fat) parameters, rate-per-liter, and the calculated total cost. To prevent concurrency conflicts when writing morning and evening records, the database triggers use automated transaction blocks.

Operational Outcomes & Direct Impact

Since deployment at select collection centers in Muktsar, DoodHisaab has delivered measurable efficiency improvements:

• Saved 1.5 hours daily: Collection operators no longer spend hours at night recalculating entries in physical books.
• Zero payment disputes: Automatic calculations based on transparent fat pricing slabs eliminated customer complaints.
• 100% Data Preservation: Even when phones are dropped or changed, localized SQLite exports ensure database state remains safe.

UI/UX Design Tailored for Rural Mobile Operators

Software interfaces designed for urban office users fail immediately when deployed in hot, dusty rural milk collection centers. To make DoodHisaab usable under field conditions, I designed the user interface around high-contrast themes and simplified input mechanisms.

Instead of typing parameters on standard, small alphanumeric mobile keyboards, operators use customized, large numeric pads with single-tap selections. Every input (like entering fat content or quantity) triggers localized audio signals in Punjabi, confirming success and preventing keystroke errors. Visual graphs show monthly milk collections and payments per farmer, helping dairy owners communicate billing parameters clearly.