Skip to content
Shivam Gupta
Automation Portfolio

Production-Focused Projects

Automation, retrieval-grounded agents and internal platforms — each one running against live operational data rather than a demo dataset.

Projects

Next.js 14NestJSLive
Platform EngineeringLiveFeatured

SkillCircle Job Portal

A three-sided marketplace connecting students, employers and placement coordinators. Students build profiles and apply, employers post roles and search candidates, coordinators verify users and record placements.

Three-sided marketplace live in production for students, employers and coordinators
Next.js 14NestJS 10SupabaseBullMQResendTypeScript
Visit the live system
Idempotent by construction — every workflow is safe to re-runDesired-state reconciliation rather than fragile event handlingAmbiguous upstream responses write nothing and retry, instead of writing a guessSecret scanning that is proven to fail before it is trusted to pass
Open Source

n8n Automation Patterns

Six production automation patterns published as importable workflows with architecture write-ups — and a mutation-tested scanner that gates every commit.

Production patterns, not toy examples
n8nQdrantGeminiLangChainGoogle Sheets APINode.js
View system details
Answer strictly from retrieved passages, never from model memoryRoute refunds, complaints and payment questions to a human regardless of what retrieval returnedStay correct when the source document is edited, without redeploying anythingGive the escalated human a draft rather than a blank page
Retrieval & AgentsFeatured

RAG Support Agent

Retrieval-grounded ticket resolution over the brochure corpus, with structured output and an explicit escalation path to a human for refunds, complaints and account issues.

Grounded answers with an explicit escalation path instead of guesses
QdrantGeminin8nLangChain
View system details
Surface the agent who made zero calls, not just the ones who made someAdjust targets for walk-in work the phone system cannot seeStay silent for everyone who met target, so the mail keeps meaning somethingSurvive one bad address in the roster without losing the rest of the run
Operational Alerting

Daily Sales-Performance Alerting

Joins counsellor rosters, walk-in logs and live MCube telephony data, computes role-specific call targets and escalates below-target agents to their managers automatically.

Nightly exception report that replaced a manual spreadsheet review
n8nMCube APIGoogle SheetsGmail
View system details
SLA timersApproval gatePostgres
Internal ToolingFeatured

Admission Process Dashboard

Replaced a single Google Form with a role-based admissions platform — student self-verification, an admin approval gate and SLA timers on the 24h / 48h / 3-day rules.

Role-based admissions with SLA timers across 30+ migrations
Next.jsSupabasePostgreSQLTypeScript
View system details
Meritto CRMJWTLive data
Data Dashboards

Sales Manager Portal

Multi-branch sales dashboard with counsellor-level drill-down, pulling from Google Sheets and the Meritto CRM behind a JWT-authenticated API.

Multi-branch sales visibility with counsellor-level drill-down
ReactExpressGoogle Sheets APIMeritto CRMJWT
View system details
Automations

Running in production

The workflows behind the platforms — scheduled, webhook-driven and real-time.

WorkflowTriggerSystemsStatus
LMS Student OnboardingDailyEdmingle · Google Sheetslive
LMS Archive / UnarchiveDailyEdmingle · Google Sheetslive
MCube Defaulter AlertDaily 20:00 ISTMCube API · Google Sheets · Gmaillive
Masterclass CertificatesReal-timeGoogle Slides · Drive · Gmaillive
Fee Reminder EmailsDailyGoogle Sheets · Gmaillive
Canva Seat GatekeeperForm submitGoogle Sheets · Gmaillive
LinkedIn Extension ReceiverWebhookChrome extension · Google Sheetslive
PandaHost Shutdown ReminderEvery 3 daysGoogle Sheets · Gmaillive
AI Ad-Creative PipelineOn demandOpenAI · Google Sheetslive
Canva Provisioning MailForm submitGoogle Sheets · Gmaillive