All projects
Felt cover for Rota

Rota

  • AIESEC

A team app AIESEC local committees use to find partner organisations for internships and exchanges. It finds schools, companies and hotels in a district with their contact details, logs every contact and the next follow-up, and keeps the team's memory when the term changes.

private code

My role: Solo: built the whole system from scratch and still run it.

Problem

AIESEC local committees hunt for partner organisations for internships and exchanges every term. The team changes every term and hand-overs rarely happen, so who called whom and what was said leaves with the person who leaves.

Approach

Rota finds schools, companies and hotels in a district with their contact details. The team saves them to shared lists and logs the outcome of every contact and the next follow-up. The Today screen puts up to three institutions to call that day at the top, each with the reason why.

Result

In November 2026 it held 180,868 institution records across 80 districts in 5 provinces, 60.3% of them with a phone number. The data is merged only from open sources whose licences allow permanent storage, and it refreshes itself every month. AI call rehearsal, season goals and team analytics live in the same app.

Highlights

  • 180,868 institution records
  • 80 districts in 5 provinces
  • 38 institution types
  • 60.3% phone coverage
  • Monthly automatic data refresh

Stack

  • Next.js 16
  • TypeScript
  • Tailwind 4
  • Leaflet
  • FastAPI
  • PostgreSQL (Neon)
  • Vercel
  • NextAuth
  • LiveKit
  • Wiro
  • OpenStreetMap
  • Overture Maps
Rota search results
Search: institutions in a district with contact details and team status.
Rota Today screen
Today: partnership tasks, my assignments and the institutions to call today.
Rota team board
Board: season goal, points, streak and this week's tasks.
Rota analysis screen
Analysis: the conversion funnel and a breakdown by institution type.