Problem Statement:

A Mid-tier Agricultural Corporation connects farmers with voluntary carbon markets, empowering them to generate additional income while contributing to sustainability. However, the application faced critical challenges impacting efficiency and scalability:

• KYC Module: Photos stored on the server consumed excessive space.
• Farmer Verification: No robust multi-factor authentication.
• Attestation: Lack of self-attestation functionality.
• Surveys: Limited questions reduced data accuracy.
• Crop Data Management: No option to update previous crop records.
• Agreement Handling: Dependence on costly stamp papers.
• Land Records: No direct image capture/upload option.
• Automation: No scheduled activity reports.
• Performance & Architecture: Inefficient monolithic structure with suboptimal performance.
• Security: Lack of end-to-end encryption.
• Database Migration: Transition required from MySQL to PostgreSQL for scalability.

Technology Stack Used:

• Frontend: React JS
• Backend: Dot Net Core
• Mobile: Flutter (Android)
• Database: MySQL (previous) → PostgreSQL (current)

Feature Comparison: Before Enhancement vs. After Enhancement

Feature	Before Enhancement	After Enhancement
KYC Photo Storage	Stored on server, consuming more than 1 TB	Moved to AWS reducing storage burden storage burden by 40%
Farmer Verification	No structured authentication	Multi-channel (missed call, OTP, IVR), reducing verification time per farmer from 5 to 2 minutes, reducing failure cases from 1,200 to 780 per month
Attestation	No self-attestation option	Self-attestation enabled, reducing processing time from 15 to 5 minutes
Short Survey	4-5 questions	Expanded to 14-15 questions, increasing data accuracy by 60%
Crop Data Update	Could not be modified	Farmers can update past crop data, reducing incorrect entries from 1500 to 700 per month
Agreement Handling	Required costly stamp paper	Stamp paper requirement removed, saving ₹500,000+ annually
Land Records	No image capture/upload option	Users can capture/upload land records, reducing paperwork by 5000+ pages per month
Automation	No automated reports	Daily CRON jobs generate email reports, saving 5+ hours/day
App Performance	Slow and inefficient	Optimized to 1.2s response time
Architecture	Monolithic structure	Migrated to microservices, reducing system downtime from 12 to 6 hours per month
Security	No encryption	End-to-end encryption implemented, ensuring 100% secure data
Database	MySQL	Migrated to PostgreSQL, improving query execution from 800ms to 400ms and supporting 2x users

Measures Taken:

To address these challenges, the following enhancements were implemented:

• KYC Optimization: Migrated photo storage from server to AWS, reducing server load by 40%.
• Farmer Verification: Integrated multi-channel verification via:
  • Missed Call System: Verification via missed calls (to/from farmer) reduced manual verification time by 50%.
  • OTP Authentication: Implemented Msg91 as a third-party OTP provider, reducing authentication failure rates by 35%.
  • IVR Integration: Automated voice-based verification improved farmer onboarding efficiency by 45%.
• Attestation: Enabled self-attestation, reducing document processing time by 60%.
• Survey Expansion: Increased short survey questions from 4-5 to 14-15, improving data collection accuracy by 60%.
• Crop Data Management: Provided update functionality for previous crop records, reducing data inconsistencies by 55%.
• Agreement Handling: Eliminated stamp paper dependency, reducing operational costs by ₹500,000+ annually.
• Land Records: Enabled direct image capture and PDF uploads via the app, cutting manual paperwork by 70%.
• Automation: Scheduled daily CRON jobs for reporting farmer additions, field surveys, and activities, saving 5+ hours of manual reporting daily.
• Performance Optimization: Refactored the codebase, decreasing response time by 30%.
• Architectural Overhaul: Transitioned from a monolithic to a microservices-based architecture, reducing system downtime by 50%.
• Security Enhancement: Implemented end-to-end encryption, ensuring 100% secure data transmission.
• Database Migration: Successfully migrated from MySQL to PostgreSQL, improving query execution time by 50% and handling 2x more concurrent users.

Conclusion:

By implementing cloud storage, security encryption, and a microservices-based infrastructure, the Sustainable Farming Enterprise’s system is now future-proof, scalable, and optimized for growth. The enhancements reduce downtime, cut operational costs, and improve farmer accessibility, paving the way for continued innovation.