The maker · the story behind Roshni
The night it started
Roshni began the way so many evenings do in Pakistan: in the dark.
I · The fan slows down
The lights went out again
Load shedding is part of life in my area of Islamabad. The fan slows, the Wi-Fi drops, the street goes quiet, and everyone asks the same two questions: was this planned, and when is it coming back?
II · Scattered answers
The answers were all over the place
The power companies do publish schedules, but as a spreadsheet of six alternative plans, as PDFs and as press releases on different pages, while NEPRA's yearly reports say how many hours each company reported. Nothing put them side by side, and nothing kept the history.
III · Treat it like production
So I built a pipeline
I'm a data engineer, so I treated it like any production data problem: collect politely every morning, parse and test every file, model it in a warehouse, match messy names across sources, and publish something anyone can read on a phone, in English and Urdu.
IV · Honest about what it knows
Plans, reports and the gap between them
Roshni shows schedules and reported figures, not measurements. It cannot tell you whether your feeder actually went dark. It can show what was planned, what was reported, and where the two disagree.
This page is the last lamp on the line.
Schedule card · the maker
Ahmad Uzzam Masood
Data engineer, and the person behind Roshni
“I design data systems that stay fast, governed, and cost-efficient at scale.”