Anand Agrawal's Portfolio

🚀 DataLabs – Large-Scale Lead Management & Real-Time Data Platform

Tech Stack: React.js, Node.js, MySQL, ClickHouse

A high-performance platform designed to send and receive live lead data across multiple sources and destinations. Built for large-scale, high-speed operations with complex routing rules.

Highlights:

Real-time data processing using Node.js.
ClickHouse used for fast analytics and managing huge datasets.
Multi-source → multi-destination lead flow handling.
Scalable architecture for high-volume pipelines.
Enabled accurate, instant data delivery for multiple clients.

📊 QnAI – Business Intelligence & Reporting Application

Tech Stack: Node.js, MongoDB, MySQL, ClickHouse, Flexmonster BI**

A BI platform delivering daily performance insights for lead generation and email marketing teams.

Highlights:

Integrated multiple email sending & tracking platforms.
Designed complex ETL workflows to pull data from diverse systems.
Used Flexmonster to create dynamic BI dashboards (pivot, charts, tables).
Managed three databases for different workloads:
- MongoDB → dynamic datasets
- MySQL → structured operational data
- ClickHouse → fast analytical queries
Automated daily reporting for decision-makers.

📣 CampaignLabs – Multi-Channel Email & SMS Campaign Tool

Tech Stack: Node.js, React.js, MySQL

A robust system for managing and sending email/SMS campaigns for internal teams and external clients.

Highlights:

Integrated multiple ESPs via API and SMTP.
Connected with DataLabs to ingest lead data.
Built campaign workflows, scheduling, and real-time monitoring.
Delivered to multiple clients as a managed service tool.
Improved speed, deliverability, and overall campaign management efficiency.

🔄 Suppresio – Automated Suppression Management System (2017)

Tech Stack: PHP, CodeIgniter, MySQL, JavaScript

An automation platform that eliminated hours of manual suppression list processing for email marketing teams.

Highlights:

Automatically downloaded suppression files from network servers.
Processed and extracted data for multiple services.
Scheduled suppression updates at optimized intervals.
Reduced manual work from 4–5 hours daily to zero.
Ensured compliance, accuracy, and faster campaign execution.

⚙️ Trickle – Automated Lead Routing & Data Distribution Tool (2016)

Tech Stack: PHP, CodeIgniter, MySQL

A foundational automation tool that streamlined lead distribution in early campaign operations.

Highlights:

Integrated APIs of multiple destinations.
Applied rules/criteria to determine routing logic.
Automated data delivery from various lead sources.
Reduced errors and manual workload significantly.
Helped scale the business during early years of growth.