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
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
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
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
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
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
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
Hostel Management System
Full-stack app for room allocation, payments, and maintenance tracking.
E-commerce Website
Clean product catalog, cart, and checkout flow (mock payments).
Text-based JavaScript RPG
Retro-inspired terminal RPG with branching dialogs and inventory.