Every weekday I turn LSEG and Bloomberg market data into models a firm reports on, with the pipelines running on Azure. SQL, Python, dbt. I care about the boring parts: clean joins, sane definitions, and a number you can actually defend in a meeting.
[ data analyst · analytics engineer, sydney au ]
Melvin Darial Yogiana
Data Analyst · Analytics Engineer · builds his own pipelines
Raw data in, then decisions out. Ideas in, then shipped products out.
[ the index ]
about
I’m a Computer Science graduate from UNSW who got hooked on the moment a chart makes a room go “oh”, so I wrangle data into honest insight, and build the software that puts it in front of people.
TypeScript, React, Next.js, Node and Postgres. This is the half that lets me build the pipeline and then build the thing people read it in, instead of handing over an extract and hoping. Five hackathons taught me to ship.
A Data Analyst / Analytics Engineer seat in Sydney, from the raw extract to the slide that changes a decision. The engineering is how I got here. The data is where I am going.
8+Projects shipped
4×Hackathon awards
50k+Rows analysed
’26Grad year
work
[ the spread ]
Two desks,
one brain.
One desk asks the questions, the other ships the answers. The shelf reads sideways.
[ /data ]4 case studies
Data
Projects
Dashboards, pricing wars, trending-video forensics and a revenue pipeline, each written as a data story, not a README.
enter the data desk ↗[ /software ]4 builds
Software
Projects
Networking platforms, an award-winning hackathon app, an AI Q&A helper and a student-housing review site. Stacks & source included.
see what i've built ↗[ field notes ]
I also write
about it.
Build logs, data stories and the occasional hackathon post-mortem.
read the blog ↗recognition
- [ 2025 ]🏆 winner
First Place
CSESoc Flagship Hackathon · gamified peer-to-peer coding platform
- [ 2026 ]✶ double
Most Fun Idea & Best Design
UNIHACK 2026 · Peersuade, two category wins
- [ 2025 ]★ honour
UNSW International Student Award
Recognition for academic & community contribution
- [ 2025 ]🗑 legend
Golden Rubbish Bin Award, Most Absurd Idea with Best Execution
Terrible Ideas Hackathon · Stall Wars · the prize nobody plans for
telemetry
No Google Analytics, no third-party script. I built the pipeline that powers these numbers, from a cookieless tracker, a Postgres events table, and the SQL that rolls it up. What you're reading right now is already in it.
pageview → beacon → /api/track → postgres → sql → dashboard
-Page views · 30d
-Unique visitors · 30d
-Countries · 30d
-Reading right now
contact
Open to Data Analyst, Analytics Engineer & graduate roles in Sydney, and always up for a good problem. Pick a channel.