Friendly Neighbourhood Prod-man who makes solutions for everyday challenges.

Hi! I'm Pranav.

I spend my weekends building nifty tools and solutions for problems we run in our everyday lives.

1 live 2 in build 3 in scoping
Pranav Gawde

Things I've built

Each began as a problem I ran into, and each is built end to end.

  1. Applitracker CV link tracking Live

    A tracked link embedded in my CV, working as both a scannable QR code in print and a hyperlink in the PDF. It records when the CV's links are opened, from where, and through which application.

    • A single tracked destination, with QR scans and PDF clicks recorded separately
    • Real-time Telegram notification on each open
    • Time, location, device and source logged to a Google Sheet
    • Tracking is per application, so each CV sent out is measured separately
  2. R.E.M. Sleep wellness In design

    A sleep wellness app that assesses a night by REM achieved rather than hours in bed. It reads staged sleep from a wearable and reports the composition of the night back to the user, along with what to adjust.

    • Reads staged sleep through Health Connect rather than inferring REM from heart rate
    • Hypnogram and REM-per-cycle view of each night
    • Wake guidance tuned to cycle boundaries instead of a fixed hour
    • Full nine-screen journey designed; Android first
  3. Sourceter Project asset organiser Building

    Began as a batch renamer for a photographer handling shoots from multiple sites in a single folder. Changing user requirements reshaped it through several versions — desktop, then iPhone, now a device-agnostic web app that organises any file type, aimed at photographers and visual artists first.

    • A naming convention you define once, applied across a whole batch
    • One user-labelled tag field — you call it Client, Series or Scene
    • Original filenames preserved in a CSV log
    • EXIF-derived filename parts, with RAW and sidecar pairing after that
  4. Relay Project tracking & handover Concept

    Project tracking commonly sits in individually maintained Excel sheets and Outlook threads: effortful to keep current, inconsistent between owners, and difficult to hand over when someone leaves or goes on leave. Relay packages what a person owns, what is in flight, and who to ask, across both tech and GTM projects.

    • Tracker and handover as a single artefact, maintained as work happens
    • Built to blend with mail, Excel and decks rather than replace them
    • A new joiner onboards from the same record used for status reporting

What's next

Scoped, not yet started.

Crunch

Every credit card EMI a user is carrying, in one place, with the aggregated monthly outflow across all cards.

Note graph

Notes as nodes, each connected to several inputs, colour-coded by area and by weight. For research notes, and for project legs on a critical path.

From the devlog

Notes on the decisions behind each build. All posts →

In progress: build notes on Sourceter's successive rewrites, and on R.E.M. moving from estimated REM to wearable-read sleep staging.

Happy to discuss any of this in more detail.