Open to data engineering & GenAI opportunities

Sparsh Verma

Data Engineer & Cloud Automation Specialist

I design resilient data pipelines and cloud-native workflows on GCP — turning manual, error-prone reporting into systems that run themselves. Over 2+ years shipping production pipelines, BI platforms, and — most recently — applied GenAI automation.

ops-console — sparsh@portfolio:~
$ whoami
> Software Engineer, HCLTech
$ uptime --professional-experience
> 2 years shipping data systems
$ pipelines --status
[OK] BigQuery + Power BI reporting
[OK] GCP Cloud Run CI/CD
[OK] Terraform disaster recovery
[OK] LLM-based PII redaction · 99% acc.
3
Cloud Certs
6
Shipped Projects
10k+
Users Reached
Stage 01 // Source

Where the data starts

I'm a data engineer based in Delhi NCR, India, currently building automation and AI-driven data pipelines at HCLTech. My work sits at the intersection of cloud infrastructure, ETL design, and — more recently — applying LLMs to real production problems like PII redaction.

Before this, I cut my teeth at Blackcoffer Consulting, shipping BI dashboards and scraping pipelines for clients across sectors. I like systems that remove a human from a repetitive loop — and I like it even more when I can prove it with a number.

Outside the stack, I led my college's Editorial Club and served as Student Council Coordinator — same instinct for turning chaos into a clean pipeline, just with people instead of data.

Location
Delhi NCR, India
Education
B.Tech, Computer Science — Galgotias College of Engineering & Technology (2019–2023)
Focus
Cloud-native pipelines + applied GenAI
Status
Open to new opportunities
Stage 02 // Transform

Core Expertise

Google Generative AI Leader
Associate Cloud Developer (GCP)
AWS Cloud Developer (Silver Badge)

Cloud & IaC

Google Cloud Platform Terraform (IaC) AWS (S3, EC2) DigitalOcean Linux / Git

ETL & Processing

Python SQL / BigQuery FastAPI / Flask Supabase ELK Stack REST API Integration

BI & Data Ops

Power BI Google Looker Studio GCP CI/CD (Cloud Run) PowerApps / Power Automate Cron & Automation Scripts

AI & GenAI Tooling

LangChain OpenAI API Ollama Prompt Engineering LLM Pipelines
Stage 03 // Process

Professional Experience

Software Engineer

Jan '24 — Present

HCLTech, Noida, India

  • Led a 7-person team delivering a deterministic AI/LLM pipeline that replaced a fully manual content-review step.
  • Built automated Python → BigQuery → Power BI reporting pipelines, cutting manual reporting effort by 35%.
  • Shipped a PowerApps / Power Automate / FastAPI survey tool to 10,000+ coworkers via SMTP, cutting manual effort by 60%.
  • Designed CI/CD workflows for GCP Cloud Run functions, cutting deployment time by 60%.
  • Implemented Terraform-based disaster recovery for GCP, enabling one-click infrastructure rebuild and 100% business continuity.

Data Science Intern

Aug '23 — Jan '24

Blackcoffer Consulting Firm, Delhi, India

  • Built FastAPI pipelines connecting Google Looker Studio to BigQuery, improving reporting speed by 30%.
  • Designed and published interactive Power BI / DAX dashboards for client stakeholders.
  • Automated Python ETL scripts for data ingestion from external APIs (RapidAPI, Looker API).
  • Built automated web-scraping workflows (BeautifulSoup) feeding BigQuery and the ELK Stack for analysis.
Stage 04 // Output

Key Engineering Projects

Six production builds — one shipped solo end-to-end, the rest spanning applied GenAI, BI platforms, and cloud-native ETL — each one designed to take a slow, manual process and make it run on its own.

SSBForge — SSB Interview Prep Platform

Live — personal project

A free, full-stack platform helping India's defence aspirants prepare for the SSB interview — six timed practice modules, Supabase-backed auth, and a ₹51/month premium tier, built and shipped solo.

ssbforge.in
Indian Armed Forces Selection Prep
Forge Your Officer's Mindset
TAT
30s / image
WAT
15s / word
PPDT
4 min write
Lecturette
3+3 min
GPE
10 min plan
SRT
30s / situation
Technologies
HTML / CSS / JS Supabase (Auth + Storage) Razorpay GitHub Actions CI/CD
Key Highlights
  • • Six timed practice modules (TAT, WAT, PPDT, SRT, Lecturette, GPE) that mirror real SSB conditions down to the second.
  • • Built a Supabase Auth system with session caching and token refresh, gating premium content behind signed URLs.
  • • Automated content-index regeneration via GitHub Actions, so the repo can stay public without leaking premium assets.

Deterministic AI/LLM PII Redaction Pipeline

Private — built at HCLTech

A hybrid rule-based + LLM pipeline that scrubs PII, profanity, and sensitive content from text at scale — replacing a manual review step for a 7-person team.

Technologies
Python LangChain OpenAI API / Ollama FastAPI Regex Rule Engine
Key Highlights
  • • Combined deterministic rule-matching with LLM judgment to reach 99% scrub accuracy.
  • • Removed a fully manual review step, freeing a 7-person team for higher-value work.
  • • Built to be deterministic by design — identical input always yields identical redactions, which matters for compliance.
SOURCE Raw Text Input Unstructured docs DETERMINISTIC Rule Engine Regex · PII patterns AI VERIFICATION LLM Verifier LangChain + OpenAI / Ollama OUTPUT Scrubbed Output 99% redaction accuracy Audit Log Compliance trail

← swipe to see the full pipeline →

Interactive BI Dashboard — Crimes in India

Live demo

A live business-intelligence report, fed by an automated GCP + Python pipeline, surfacing actionable insight into NCRB crime data (2020–2022).

lookerstudio.google.com/reporting/d1531916…
Screenshot of a Looker Studio dashboard analyzing crime data across Indian states, 2020-2022
Technologies
Google Looker Studio GCP BigQuery Python Data Pipeline Looker API
Key Highlights
  • • Connects directly to GCP BigQuery through an automated data pipeline.
  • • Built to shorten the path from raw data to a stakeholder decision.
  • • Demonstrates end-to-end ELT/BI delivery, from source to visualization.

Client Data Automation Solutions

Private — built at HCLTech

Automated enterprise reporting pipelines, deployed end-to-end on GCP.

Technologies
GCP (Cloud Run, BigQuery) Terraform (IaC) Python Power BI FastAPI
Key Highlights
  • • Streamlined the data flow from SharePoint → BigQuery → Power BI, cutting manual reporting by 35%.
  • • Designed CI/CD for Cloud Run functions, cutting deployment time by 60%.
  • • Automated the data-freeze process, taking it from 4 hours down to 30 minutes.
SOURCE SharePoint API Source system COMPUTE Cloud Run Python ETL service CI / CD Cloud Build Artifact Registry / CI/CD INFRA Terraform IaC · disaster recovery WAREHOUSE BigQuery Staging → final tables BI LAYER Power BI / Looker BI consumption layer

← swipe to see the full pipeline →

Automated UK Government Data ETL

Private — built at Blackcoffer

An ETL tool that ingests and refines large public datasets for a client-facing web application.

Technologies
Python (Pandas) PostgreSQL Data Mining Scripts
Key Highlights
  • • Mines large datasets from multiple UK government sources.
  • • Refines and structures data for loading into PostgreSQL behind a client-facing app.
  • • Keeps stakeholder reporting close to real time.
SOURCE UK Gov Data APIs / files TRANSFORM Python ETL Script Mine · clean · validate SCHEDULE Cron Scheduler Orchestration STORAGE PostgreSQL Schema + final tables CONSUMPTION Client Web App Reads live data

← swipe to see the full pipeline →

Content Sentiment Analysis Pipeline

Private — built at Blackcoffer

An automated script that scores sentiment across 200+ scraped websites.

Technologies
Python BeautifulSoup Selenium NLP
Key Highlights
  • • Scrapes content from 200+ sources on an automated schedule.
  • • Applies NLP scoring to calculate sentiment per source.
  • • Feeds a continuous pipeline for trend analysis and content strategy.
SOURCE Excel File List of target URLs PROCESS Python Pipeline 1. Scrape BeautifulSoup / Selenium 2. Clean Text Strip markup, normalize 3. Score Sentiment NLP polarity scoring OUTPUT Output Saved & displayed score

← swipe to see the full pipeline →

Stage 05 // Sink

Let's ship something

I'm currently a Software Engineer at HCLTech, and always open to conversations about Data Engineering, Cloud Architecture, or applied GenAI roles. Feel free to reach out.