AK
All case studies
CRMlakal

Full-Stack Architect & Developer

Building an Agricultural ERP That Works in the Field

Farmers, land records, crop cycles, soil data, and AI recognition. Built from scratch for an agri-business moving off spreadsheets.

6 months

The Problem

Challenge

The client ran their entire agri-business on Excel sheets and phone calls. They had thousands of farmers to track, each with multiple land parcels, crop cycles, and soil reports. Field agents spent more time searching for information than helping farmers. During peak season, the backlog meant lost sales. They needed a purpose-built platform.

The Approach

How I thought about it

I spent the first two weeks watching how field agents worked. What do they actually need to see when a farmer walks in? What slows them down? Then I designed the data model: farmers connected to land parcels, crops, soil tests, and purchases. Every screen was built from the user workflow out, starting with what the agent needs to accomplish.

The Build

What was built

  • Built server-side pagination from day one. The database was going to be large, and users expect fast page loads.
  • RBAC based on JWT claims. Field agents see their farmers. Managers see their region. Admins see everything. Simple, effective.
  • Integrated AWS Rekognition for KYRA. Point a phone camera at a farmer, the system pulls up their land, crops, soil data, and purchase history in under 2 seconds.
  • CSV exports with column selection. Management wanted reports their way. Built it once, they use it daily.
  • Crop dashboards, soil modules, irrigation tracking. Each module connects to the others. No silos.
  • Used AWS Lambda to generate personalized Kisan discount cards as images. Delivered automatically to the farmer's WhatsApp. No one has to press send.

The Outcome

Results

1L+

Records Managed

<200ms

Query Speed

4

User Roles

99%+

AI Recognition

Tech Stack

Technologies used

ReactNext.jsTypeScriptSupabasePostgreSQLAWS RekognitionTailwind CSSAWS Lambda

System Tour

Every module, with the actual interface.

KYRA — AI Farmer Recognition
01

KYRA — AI Farmer Recognition

AI + Computer Vision + CRM Integration

Instantly identify farmers using facial recognition and link them with their complete agricultural profile.

Capabilities

  • Real-time face detection using AWS Rekognition
  • Instant farmer identification with confidence score
  • Auto-fetch customer profile, land, crop, and transaction data
  • Multi-match handling with probability scoring
  • One-click profile navigation for field teams

Data & Connections

Customer ProfilePersonal and contact details
Land RecordsOwned land, acreage, irrigation
Crop CyclesActive, harvested, and planned crops
Soil ReportsSoil health and recommendations
Purchase HistoryFertilizer and product buying patterns

Eliminates manual search. Reduces identification errors. Enables instant fertilizer recommendation during farmer interaction.

WhatsApp Communication Automation
02

WhatsApp Communication Automation

Automation + Customer Engagement

Automate farmer communication based on crop lifecycle, reminders, and business triggers.

Capabilities

  • Template-based messaging system
  • Scheduled message delivery after events
  • Recurring reminders for fertilizer and irrigation
  • Remark-rule based targeting
  • Message logs and delivery tracking

Data & Connections

DeliveryWhatsApp API
ProcessingAWS Lambda
StorageSupabase

Continuous farmer communication without manual effort. Improves repeat purchases. Handles thousands of automated messages at scale.

Sales Analytics Dashboard
03

Sales Analytics Dashboard

Business Intelligence

Real-time insights into sales performance, revenue trends, and operational efficiency.

Capabilities

  • Total sales and invoice volume tracking
  • Tax analysis and discount tracking
  • Monthly growth and sales distribution
  • Year-over-year growth comparison
  • Branch and village-level insights

Data & Connections

MetricsRevenue, Invoices, Tax, Discounts
DimensionsBranch, Village, Product, Time

Complete financial overview. Identifies high-performing products and regions. Supports inventory and demand forecasting.

Leaderboard & Performance System
04

Leaderboard & Performance System

Gamification + Performance Tracking

Track and rank field agents based on customer acquisition performance.

Capabilities

  • Monthly, weekly, and daily rankings
  • Branch-level filtering
  • Performance comparison across agents
  • Growth vs last period tracking
  • Top performer highlighting

Data & Connections

Ranked ByRegistrations, Sales, Activity

Encourages competition among field staff. Drives higher customer onboarding. Clear visibility of individual performance.

Customer 360° Profile
05

Customer 360° Profile

Core CRM

Unified 360° view of each farmer across all business and agricultural data.

Capabilities

  • Personal information and contact details
  • Land ownership and acreage data
  • Crop lifecycle timeline
  • Soil health reports and history
  • Purchase insights and discount card status

Data & Connections

SegmentationOccasional, Regular, High-value
RankingValue-based across all customers
Linked ModulesKYRA, WhatsApp, Sales, Inventory

Tailored recommendations for each farmer. Better targeting for upsell and cross-sell. Single source of truth for all customer data.

Crop Lifecycle Management
06

Crop Lifecycle Management

Agricultural Intelligence

Track crop lifecycle from seeding to harvest with actionable insights.

Capabilities

  • Crop type tracking (sugarcane, soybean, wheat)
  • Seeding and harvest timelines
  • Acreage tracking per crop
  • Expected harvest predictions
  • Days remaining indicators per crop stage

Data & Connections

CropsSugarcane, Soybean, Wheat, Cotton
StagesSeeding → Growing → Harvest
MetricsAcreage, Yield, Timeline

Predict fertilizer demand by crop stage. Enable timely advisory and interventions. Improve yield outcomes through data-driven planning.

Land Records Management
07

Land Records Management

Core Agricultural Data

Manage and track farmer land ownership and survey-level details at scale.

Capabilities

  • Survey number tracking
  • Village and location mapping
  • Acreage management per land parcel
  • Irrigation type classification
  • Advanced filtering and search across 20,000+ entries

Data & Connections

Total Records20,000+ land entries
AttributesSurvey #, Village, Acreage, Irrigation

Accurate farmer profiling through precise land data. Better resource allocation. Land-based segmentation for targeted advisory.

Live User Activity Monitoring
08

Live User Activity Monitoring

Admin Control & Monitoring

Track system usage and user activity in real-time across the organization.

Capabilities

  • Online and offline user tracking
  • Last login timestamps
  • User role visibility (admin, manager, field agent)
  • Activity path tracking
  • Audit trail for security and compliance

Data & Connections

TrackedLogin state, Activity path, Role
PurposeSecurity, Productivity, Support

Monitor unauthorized access. Track team productivity across branches. Quick troubleshooting for support requests.

Admin Command Dashboard
09

Admin Command Dashboard

System Control + Operational Intelligence

Centralized control panel for managing customers, monitoring system health, and accessing key operational workflows.

Capabilities

  • Unified customer search by ID or mobile number
  • Operational alerts for missing or inconsistent data
  • Quick-access shortcut cards for high-frequency operations
  • Centralized navigation to all core modules
  • Role-based access with real-time system alerts

Data & Connections

Quick ActionsNew Customer, All Customers, Soil Reports, Land Records
ModulesKYRA, Sales, Soil, Crop, Land, Customer DB

Single control point for all CRMlakal operations. Reduces time spent navigating workflows. Immediate visibility into data issues. Entry point of the entire CRMlakal ecosystem.

Ankit built something we didn't think was possible. KYRA changed how our field teams work. No more scrolling through registers. Just click a photo and everything is there.

Client, Operations Director, CRMlakal

Contact me