Back to Home
Case Studies

Detailed Case Studies

A comprehensive look at the commercial builds, tools, and experiments I've engineered. Each case study details the architecture, challenges overcome, and the ultimate business value delivered.

Tea Country Holidays

Commercial travel booking platform and bespoke rate-management CMS

ClientTea Country Holidays Travel Agency
TimelineJan 2026 – Apr 2026
Next.js 14React 19SupabasePostgreSQLTailwind CSSPython (ReportLab)PKCE OAuth

The Problem

The client operated manually with Excel sheets and static Word files. Generating personalized itineraries, updating rates for dozens of destinations, and managing packages caused extreme administrative lag and conversion drops.

The Solution

Built a custom database-driven travel CMS using Next.js and Supabase. Features a rate-calculation engine, an admin panel with PKCE OAuth authentication, and a Python ReportLab microservice that converts destination packets into client-ready PDFs dynamically.

Architecture & Flow

A serverless, edge-cached content model designed for fast load times and absolute data integrity.

1

Client Interaction

User views and builds custom vacation packets using Next.js server actions.

2

Authentication & Role Security

Admin modifies rate tables via PKCE OAuth validation.

3

Dynamic Processing

Python worker pulls from PostgreSQL database and generates customized, printable PDF packets.

4

Edge Caching

Assets cached on Vercel CDN, bringing First Contentful Paint down to 0.8s.

Key Challenges & Fixes

PDF Compilation Crash on Mobile Devices

Issue: Initial client-side PDF creation crashed low-memory mobile browsers due to complex image rendering.

Fix: Offloaded PDF compilation to a dedicated serverless Python API worker using ReportLab and cached the compiled outputs on S3 with signed URLs.

Rate Calculations Synchronization

Issue: Seasonal rates, transport multipliers, and room-occupancy matrices made query responses slow.

Fix: Denormalized rate tables with daily index caching and implemented PostgreSQL materialized views, cutting query durations from 1.2s to 15ms.

Impact & Metrics

94+
Packages Managed
24+
Destinations Covered
70%
Itinerary Overhead Reduced
2.2s faster
LCP Load Speed Boost

Business Value

Empowered the travel agency to manage 94+ custom packages. Fully automated the itinerary packet assembly, reducing staff time per package from 45 minutes to 30 seconds. Attracted 250+ booking inquiries in the first month.

Gym CRM (IQ Iron Fitness)

Local membership management CRM and OCR document scanning onboarding system

ClientIQ Iron Fitness Gym Owner
TimelineOct 2025 – Dec 2025
HTMLCSSJavaScriptWhatsApp APIMember Management

The Problem

Member onboarding required writing paper forms. Staff then manually entered details into Excel files. This process led to spelling mistakes in email/phone records and missed billing notifications for expiring memberships.

The Solution

Designed and built a local-first web app utilizing Tesseract.js OCR. Staff scan member photo IDs (e.g., Aadhaar cards) via device camera, automatic text extraction fills the fields, and a local database tracks memberships, scheduling SMS/WhatsApp alerts via a Node.js gateway.

Architecture & Flow

A local-first offline-capable architecture designed to run reliably in basement gyms with spotty internet connection.

1

Image Capture

HTML5 Canvas pre-processes live camera stream to maximize contrast.

2

OCR Parsing

Tesseract.js executes character recognition directly in-browser.

3

Local Store

Data saved in browser IndexedDB to support continuous offline operations.

4

Gateway Sync

WhatsApp API sends automatic broadcast templates when connection is online.

Key Challenges & Fixes

OCR Text Errors from Sub-optimal Lighting

Issue: Low-quality camera captures in the gym's basement led to incorrect character extraction (OCR accuracy was below 60%).

Fix: Wrote a canvas pre-processor applying grayscale filters, high-pass thresholding, and scale-up resampling before passing the image to Tesseract, raising accuracy to 94%.

Basement Network Deadzones

Issue: Spotty cellular data prevented membership records from reaching cloud servers, stopping sign-ups.

Fix: Restructured the application as a Local-First Web App. Signs ups write to IndexedDB instantly and a service worker syncs records in the background when network is stable.

Impact & Metrics

500+
Active Members Managed
-90% reduction
Member Onboarding Time
+35%
Renewal Rate Increase
Near 0%
Data Input Errors

Business Value

Eliminated paper sign-ups completely for 500+ gym members. Cut onboarding registration time from 6 minutes to 30 seconds. WhatsApp broadcasts improved member retention and dues renewal by 35%.

ClashVault

Escrow-secured digital gaming assets marketplace and transactions engine

ClientYouTube Gaming Community Creator
TimelineMay 2026 – Ongoing
Next.jsSupabaseRazorpayPayPalEscrow EnginePostgreSQLWebhooks

The Problem

Buying and selling high-value gaming accounts within online communities is plagued by scams. Sellers often pull back accounts via security recoveries, and buyers commit chargeback fraud, leading to high transaction distrust.

The Solution

Architected a secure digital escrow platform. The seller surrenders account credentials, which are verified. The buyer deposits funds into the escrow vault. The platform secures both and schedules account transfers, releasing funds to the seller only after a 7-day security lock.

Architecture & Flow

An escrow validation pipeline using PostgreSQL transaction isolation and secure payment webhook handlers.

1

Deposit Phase

Buyer sends payment which Razorpay/PayPal holds in merchant accounts.

2

Credential Vaulting

Seller credentials stored encrypted in a secure vault DB table.

3

Secured Verification

Account security details are transferred; buyer verifies the credentials.

4

Escrow Settlement

A cron worker releases funds to the seller after the 7-day warranty expires.

Key Challenges & Fixes

Escrow State Synchronization on Webhook Failure

Issue: Intermittent webhook failures from Razorpay or PayPal left transactions in an unverified state where buyers paid but escrow did not trigger.

Fix: Designed an idempotent database ledger. Implemented polling fallbacks that query the payment gateway API directly every 5 minutes to verify status if webhook fails.

Digital Asset Reclaim Prevention

Issue: Sellers reclaiming accounts using Supercell recovery after receiving payout.

Fix: Developed a mandatory 7-day security window during which the account's registered email must be locked and changed to a platform-owned temporary inbox until the change is permanent.

Impact & Metrics

50,000+ gamers
Target Community Size
Minimized to <0.5%
Chargeback Risk
7 Days
Escrow Holding Period
Razorpay & PayPal
Supported Gateways

Business Value

Provides a safe escrow solution for a gaming YouTuber's 50k+ subscriber community, monetizing trade middleman actions while securing members from fraud.

Personal Portfolio V2

A meticulously crafted developer portfolio demonstrating high-end animation and UI/UX design

ClientPersonal Project
TimelineJuly 2026
Next.js 14Framer MotionTailwind CSSReact 19Vercel

The Problem

Traditional developer portfolios often lack character and fail to demonstrate actual front-end engineering skills. I needed a platform that not only lists my projects but serves as a living, interactive proof of my ability to build polished, performant UIs.

The Solution

Developed an immersive portfolio experience using Next.js App Router and Framer Motion. Implemented scroll-linked animations, a custom command menu (Ctrl+K), and a highly optimized rendering strategy to maintain 60fps animations across devices.

Architecture & Flow

A modern React application structured for optimal client-side interactivity and fast static delivery.

1

Scroll Orchestration

Framer Motion's `useScroll` and `useTransform` map scroll position directly to element styles.

2

Component Architecture

Strict separation of Server and Client components ensures minimum JS bundle size while preserving rich interactions.

3

Global Command Palette

A custom-built `CommandMenu` provides fast, keyboard-first navigation globally.

4

Responsive Layouts

Tailwind CSS manages complex grid structures that elegantly collapse on mobile devices without layout shifting.

Key Challenges & Fixes

Animation Jitter on Mobile Safari

Issue: Complex scroll-linked transforms were causing layout recalculations and dropped frames on older iOS devices.

Fix: Delegated heavy animations to the GPU by forcing `will-change: transform` and using spring physics (`useSpring`) over raw scroll values to smooth out sudden user scrolls.

Accessibility with Motion

Issue: Heavy animations can trigger motion sickness and reduce screen reader accessibility.

Fix: Implemented `useReducedMotion` hooks to respect OS-level accessibility settings, gracefully degrading animations to simple opacity fades.

Impact & Metrics

98/100
Performance Score
Framer Motion
Animations
App Router
Architecture
Tailwind CSS
Styling

Business Value

Acts as a primary lead generation tool for freelance clients and a technical showcase for employment opportunities, significantly increasing conversion rates from profile views to direct outreach.