50,000 Patient Records from Paper to Salesforce in 8 Weeks

The Challenge

A community health programme serving 400,000 beneficiaries across 300 villages in Maharashtra was operating on paper-based field registers. Four hundred field health workers carried physical records. They drove to district offices every week to enter data into block-level computers — a round trip that consumed a full working day. They had no access to patient history during home visits: the record they needed was on a shelf in a building sometimes 30 kilometres away.

Quarterly reports to funders required three weeks of manual data compilation across 15 district coordinators. By the time those reports reached funders, the data was six to ten weeks old. Programme decisions were being made on information that no longer reflected the field reality.

The technical constraint was connectivity. Many of the 300 villages had intermittent or no mobile internet. Any mobile solution had to work offline.

Results at a Glance

AlmaMate's Approach

AlmaMate conducted a two-day requirements workshop with the Programme Director, 6 district coordinators, and 4 field health workers — the people who would actually use the system. The configuration priorities that came out of that workshop were different from what a desk review would have identified: field staff were less concerned about reporting dashboards than about being able to pull up a specific patient's history from last month's visit without internet.

We implemented Salesforce NPSP with the Program Management Module, building custom objects for RMNCH+A, TB, and nutrition programme verticals — aligned to the National Health Mission's district-level reporting formats so the same data entry serves both field operations and government reporting. Salesforce Mobile was configured for offline-capable operation on Android tablets, syncing automatically when connectivity is available and flagging conflicts for coordinator review when offline edits create data inconsistencies.

The data migration covered 50,000+ patient records across 300 villages, validated against the original paper registers during a three-week parallel-run period. Field staff trained in batches of 20 over four weeks, with district coordinators trained first to provide peer support. Go-live was village-by-village across four weeks, starting with the three highest-volume districts.

What Changed After Go-Live

The first measurable change was reporting speed. Quarterly funder reports went from three weeks of manual compilation to same-day generation from Tableau CRM. The data is live — the report reflects the current state of the programme, not the state it was in six weeks ago when coordinators started compiling it.

The second change was operational visibility. The Programme Director now has a live dashboard showing every village, every beneficiary cohort, and every programme metric. Before implementation, getting an accurate count of beneficiaries reached in a specific district this month required calling the district coordinator and waiting for a WhatsApp message. Now the number is on the screen.

The third change was harder to quantify but consistently reported by field staff: the ability to access a patient's complete history during a home visit — previous assessments, referrals, medication records — changed the quality of the interaction. Field health workers no longer had to ask patients to repeat information they had already given three times to three different staff members.