Ravi Kumar
All projects

Case study · Jan 2026 — present

Her Aviation Era

The complete preparation platform for aspiring cabin crew — designed, architected, and shipped by one engineer, reaching 800+ active users.

Her Aviation Era landing page — the all-in-one cabin crew prep platform

The inbox was the market research

My wife is an active Emirates cabin crew member, and I manage her social media — 350k+ combined followers across Instagram, TikTok, and YouTube. Her inbox was flooded daily with the same questions: how do I prepare, what are the minimum requirements, am I eligible?

That inbox was a measurable, recurring problem statement. Instead of answering one DM at a time, I turned it into a product — and the demand it predicted showed up immediately: 800+ active users and counting.

What I built

Live Hiring Feed

A fully automated daily pipeline scrapes 50+ international airlines for crew openings. Vague listings are rejected in an admin panel; one click publishes the curated feed to every user's dashboard.

Aspirant Toolkit

Six interactive tools: airline eligibility matcher (50+ airlines), BMI and body-standards checker, tattoo and grooming checker, salary estimator, aptitude/SJT practice, and a self-intro script builder.

Interview Bank

151 real interview questions with model answers and STAR breakdowns, gated by a freemium model across 15+ product surfaces.

Cabin Crew Academy

18 study modules, each with 7 lessons, a quiz, and a flashcard deck — plus a mock interview studio, premium CV templates, 1:1 coaching bookings, and direct crew Q&A.

Growth engineering

Product analytics identify engaged free users; a templated win-back email goes to that exact segment in one click from the admin panel (PostHog + Resend).

Admin console

Revenue reporting split by currency, customer insight badges, booking availability management, and a curated hiring-feed review queue.

Group Discussion prep

A dedicated GD prep track with its own pricing tier, built to cover a recruitment stage most competitors ignore.

Airline profile pages & open days

SEO-indexed profile pages per airline plus an open-days calendar with free/gated alerts, routed and scroll-fixed for mobile.

Startup-grade engineering discipline, team of one

I directed the full software development lifecycle — scoping, architecture, implementation, testing, deployment, and DevOps — in close AI-augmented collaboration with Claude, treating an AI agent as a genuine engineering partner rather than an autocomplete.

  • Staged releases: feature branch → staging environment → production, with two verification checkpoints
  • Gated CI/CD on every PR via GitHub Actions, plus a manually-confirmed production migration job
  • Governed database migrations with an expand/contract schema strategy for zero-downtime changes
  • Postgres Row-Level Security audited and enforced; GDPR-aligned account deletion
  • Encrypted daily 3-2-1 backup and disaster-recovery pipeline
  • SemVer-tagged releases with a public what's-new feed
  • Test coverage raised from 61% to a 90% CI-enforced floor, risk-weighted toward money, access, and API surfaces

Monetization

A freemium model with tiered feature gating across 15+ product surfaces, backed by three payment gateways — Stripe, PayPal, and Razorpay — supporting both USD and INR billing with a yearly founding membership.

Stack

  • Next.js 16
  • React 19
  • TypeScript
  • Supabase (Postgres, RLS, Auth)
  • Tailwind CSS
  • Vercel
  • GitHub Actions
  • Stripe
  • PayPal
  • Razorpay
  • PostHog
  • Claude Code