Portfolio/Projects/EQ REV
PROJ_02PRODUCTION_ONLINESaaS Platform / E-Commerce Intelligence

EQ REV

QUICK COMMERCE ANALYTICS PLATFORM FOR D2C BRANDS

EQ REV is an enterprise SaaS analytics platform engineered specifically for D2C brands scaling on instant quick-commerce platforms like Zepto, Blinkit, and Swiggy Instamart. The system ingests and processes granular location data, enabling store managers and founders to analyze sales performance down to individual pin codes and warehouse fulfillment centers across India.

Launch Live Application
TimelineJan 2025 – Dec 2025
RoleSoftware Engineer (Fullstack & Data)
React.js///Chart.js///Recharts///Tailwind CSS///Hero UI///Zustand///Node.js///Express.js///REST APIs///Cloudflare Workers///Google BigQuery///MongoDB Atlas///PostgreSQL///Prisma ORM///Google Cloud Platform (GCP)///Vercel Enterprise///JWT / OTP Auth///React.js///Chart.js///Recharts///Tailwind CSS///Hero UI///Zustand///Node.js///Express.js///REST APIs///Cloudflare Workers///Google BigQuery///MongoDB Atlas///PostgreSQL///Prisma ORM///Google Cloud Platform (GCP)///Vercel Enterprise///JWT / OTP Auth///React.js///Chart.js///Recharts///Tailwind CSS///Hero UI///Zustand///Node.js///Express.js///REST APIs///Cloudflare Workers///Google BigQuery///MongoDB Atlas///PostgreSQL///Prisma ORM///Google Cloud Platform (GCP)///Vercel Enterprise///JWT / OTP Auth///
// SCREENSHOT SHOWCASE
IMAGE 01 / 05
EQ REV main screenshot view 1
eq-rev_view_1.pngCLICK TO EXPAND
PROJECT GALLERY (5 VIEWS)Click any thumbnail to switch view

Key Performance Metrics & Impact

Retail Stores Analyzed
1,000+

Hyper-local store pin codes tracked in real-time

Platforms Integrated
3 Major Q-Comm

Zepto, Blinkit & Swiggy Instamart

Key Enterprise Clients
Mee Mee, Ramraj

Adopted by top D2C consumer product brands

Query Throughput
10M+ rows/sec

BigQuery powered data aggregation pipelines

Problem Statement

Brands selling on Quick Commerce platforms face complete dark spots regarding hyper-local demand, pin-code inventory stockouts, and regional channel analytics.

Engineering Solution

Built a multi-tenant analytics engine with interactive Chart.js/Recharts data visualizations, automated BigQuery data processing pipelines, OTP authentication, and responsive Hero UI dashboards.

Core Capabilities & System Features

01

Hyper-Local Pin Code Insights

Interactive heatmaps and data grids mapping store performance and demand patterns to exact regional postal codes.

02

Multi-Platform Aggregation

Unified analytics dashboard comparing revenue velocity, SKU performance, and stockouts across Zepto, Blinkit, and Instamart.

03

Automated Stockout Alerting

Smart inventory monitoring that flags low-stock warehouses before replenishment failure affects revenue.

04

Role-Based Brand Portal

Multi-tenant portal featuring custom dashboard views for brand executives, category managers, and regional leads.

Technical Stack Architecture

// Frontend Stack
React.jsChart.jsRechartsTailwind CSSHero UIZustand
// Backend Architecture
Node.jsExpress.jsREST APIsCloudflare Workers
// Database & Data Warehouse
Google BigQueryMongoDB AtlasPostgreSQLPrisma ORM
// Infrastructure & Security
Google Cloud Platform (GCP)Vercel EnterpriseJWT / OTP Auth

System Architecture Topology

TIER 1 // CLIENT INTERFACE & APPLICATION LAYER
PORTAL_ONLINE
Client Technologies:
React.jsChart.jsRechartsTailwind CSSHero UIZustand
Active Execution Modules:
  • G-Code Viewer & Code Diff Engine
  • Atomic Client State Hydration & Live Socket
HTTPS / REST / CRYPTO_HASH
TIER 2 // BACKEND ENGINE & SECURITY VAULT
VERIFIER_ACTIVE
Core Backend Stack:
Node.jsExpress.jsREST APIsCloudflare Workers
Security & Processing Pipeline:
  • AES-256 G-Code File Cipher & Audit Log Engine
  • Role-Based Access Controller (RBAC)
ENC_STREAM / GRIDFS_BINARY
TIER 3 // PERSISTENT STORAGE & CLOUD TIER
STORAGE_SYNCED
Storage Architecture:
Google BigQueryMongoDB AtlasPostgreSQLPrisma ORM
Data Persistence & Cloud:
  • MongoDB Atlas Machine Schemas & Operator Profiles
  • GCP Cloud Storage Encrypted Backup Vault
TELEMETRY_CONSOLE // eq-rev.sh
LIVE STREAM
>$ eqrev-cli query --brand meemee --region south-zone
>[DATA_INGEST] Ingesting pin-code data streams for 1,250 dark stores...
>$ eqrev-cli analytics --platform blinkit --skus all
>[AGGREGATION] BigQuery executed query across 8.4M records in 180ms.
>$ eqrev-cli stockout-check --threshold 10%
>[WARN] 4 pin codes in Bengaluru showing stockout risk within 2 hours.
>[SUCCESS] Brand analytics portal initialized & active.
>
Previous ProjectPROGRESS IQNext Project BITLINKS