Ravi Kant Logo
Ravi Kant
Back to Projects

Alphabell Agrofood Platform & News Scraper

Code Repo

Scalable E-Commerce & Automated Data Ingestion Engine built with Django REST Framework, PostgreSQL, and Python Scrapers.

DjangoDjango RESTPythonPostgreSQLFirebase AuthJWTWeb Scraping
System Blueprint & Flow

Django REST Framework -> PostgreSQL (Indexed & Normalized) -> Python Data Pipeline -> Firebase Auth.

Alphabell Agrofood Platform Case Study

Project Overview

Alphabell Agrofood is an integrated e-commerce and agrofood news platform built for Inkronix Pvt. Ltd. It handles product catalog management, order workflows, user role management, and real-time automated news ingestion.

Key Engineering Accomplishments

1. Database Optimization & Latency Reduction

  • Resolved N+1 query bottlenecks across product catalog endpoints by implementing optimized database relationships and indexed lookups.
  • Reduced API response latency by 30% for mobile bandwidth-constrained users.

2. Automated Python Scraping Pipeline

  • Designed an automated news scraping engine in Python that processes 500+ articles daily into normalized PostgreSQL schemas.
  • Completely eliminated manual data entry for content updates.

3. Enterprise Security & Contract Standardization

  • Architected a 3-tier authentication system using Django JWT and Firebase Authentication with strict role-based access control (RBAC).
  • Standardized Django REST API contracts for Flutter client consumption, cutting cross-team integration bugs by 50%.