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

EQ REV

QUICK COMMERCE GROWTH 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 massive location data streams across Google BigQuery and GCS, reducing manual effort by 60% and improving report generation efficiency by 40%.

Launch Live ApplicationGitHub Repository
TimelineJan 2025 – Dec 2025
RoleSoftware Developer (Product & Platform)
React.js///Chart.js///Recharts///Tailwind CSS///Hero UI///Zustand///Node.js///Express.js///REST APIs///Cloudflare Workers///Google BigQuery///MongoDB Atlas///PostgreSQL///Google Cloud Storage (GCS)///Google Cloud Platform (GCP)///Cloudflare Edge///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///Google Cloud Storage (GCS)///Google Cloud Platform (GCP)///Cloudflare Edge///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///Google Cloud Storage (GCS)///Google Cloud Platform (GCP)///Cloudflare Edge///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

Stores Analyzed
1,000+

Hyper-local store pin codes tracked in real-time

Data Scale
2B+ Records

Ingestion and extraction across GCS & BigQuery

Efficiency Gain
+40%

Report generation velocity acceleration

Manual Effort Reduction
-60%

Automated backend data 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

Architected the complete production full-stack web application across 3 core modules using React.js and Node.js/Express REST APIs, integrating Google BigQuery for real-time aggregation queries and Cloudflare for edge security.

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 Backend Data Pipelines

Automated ETL extraction and transformation scheduling reducing manual processing overhead by 60%.

04

Edge Security & Role-Based Authentication

Cloudflare edge security acceleration paired with secure OTP login and multi-tier access control.

Technical Stack Architecture

// Frontend Stack
React.jsChart.jsRechartsTailwind CSSHero UIZustand
// Backend Architecture
Node.jsExpress.jsREST APIsCloudflare Workers
// Database & Warehouse
Google BigQueryMongoDB AtlasPostgreSQLGoogle Cloud Storage (GCS)
// Cloud & Security
Google Cloud Platform (GCP)Cloudflare EdgeJWT / 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 AtlasPostgreSQLGoogle Cloud Storage (GCS)
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 ProjectSAHA YATRINext Project REQTIMELINE (NPM)