Selected Projects

Automated Tech Blog Pipeline

Fully autonomous blog pipeline: an n8n workflow pulls trending dev topics, an AI agent drafts an original post, and it's committed straight to a live Astro site — no manual approval step.

  • Scheduled end-to-end flow: topic sourcing → AI drafting → Markdown generation → auto-commit → auto-deploy
  • Runs on a self-hosted n8n instance with OAuth-based GitHub integration
n8nAstroAI Agent (LLM)GitHubRender

AI-Powered News Blog Automation

Daily automated tech news blog with a resilient 3-provider AI fallback chain — RSS stories are sourced, drafted into original articles, and published automatically via GitHub Actions.

  • Provider-fallback design keeps the pipeline running even if one AI API fails
  • Explicit anti-plagiarism instruction set — drafts are original, not copied summaries
GitHub ActionsPythonAstroGemini/OpenRouter/Groq

Billing & Payment Reminder Automation

Automation built for a dealership CRM's finance operations — matches outstanding receivables against invoice files and sends structured payment follow-up reminders automatically.

  • Cross-references live Receivables and Customer Details sheets against Drive-stored invoices
  • Handles Drive API rate limits with batching/throttling for reliable runs
n8nGoogle Apps ScriptGoogle SheetsGmail

BA Timesheet Leaderboard

Internal leaderboard app for tracking Business Analyst timesheet performance, evolved from a static prototype into a full App Router application backed by a cached Apps Script API.

  • Same-origin API route keeps the browser decoupled from backend credentials
  • Token-authenticated Apps Script backend with server-side caching
Next.js 14TypeScriptGoogle Apps Script

MRR Hierarchy Reporting System

Company-wide MRR reporting workbook rolling up costs across a multi-level org hierarchy, with automated data-quality flagging and a companion Python forecasting script.

  • Built a monolithic hierarchical-rollup formula with individual salary lookups
  • Added automated warning flags for data mismatches across thousands of rows
Google Sheets (ARRAYFORMULA/LET/LAMBDA)Excel VBAPython

Spam & Fake User Detection

Supervised learning pipeline to detect spam/fake profiles based on behavioral signals; evaluated with F1, PR, ROC-AUC.

  • Feature engineering (gender inference, click behavior, activity frequency)
  • Model evaluation and visualization
PythonScikit-LearnPandasMatplotlib

Adaptive Learning Platform (AI)

AI-powered platform that adapts content difficulty using schema-validated prompts and progressive rendering.

  • Prompt engineering & response validation
  • Modular backend with clear separation of concerns
Next.jsNode.jsPython (LLM Prompting)Gemini API

Hostel Management System

Full-stack app for room allocation, payments, and maintenance tracking.

Next.jsPostgresAuth

E-commerce Website

Clean product catalog, cart, and checkout flow (mock payments).

Next.jsStripe (mock)Tailwind

Text-based JavaScript RPG

Retro-inspired terminal RPG with branching dialogs and inventory.

JavaScriptHTMLCSS