home/about
The person behind the charts

Hi, I'm Melvin. I make data make sense.

An Indonesian Computer Science student at UNSW, building in Sydney — equal parts analyst and engineer, and fully addicted to the moment a messy spreadsheet finally tells you something true.

Melvin Yogiana
Sydney, AU · 2026
01 — My story

I came to Sydney to study Computer Science at UNSW, and somewhere between a database lecture and my third hackathon I realised I'd fallen for two things at once: finding the story hiding in data, and building the thing that puts that story in front of people.

Most developers pick a lane. I genuinely couldn't. So I lean into both — I'll spend a weekend untangling ABS labour statistics or scraping supermarket prices, then turn around and ship a full-stack app with a team under deadline. The two halves feed each other: the analyst makes my software honest, and the engineer makes my analysis usable.

Along the way I've been lucky enough to win a few rooms — a hackathon first place, two UNIHACK 2026 categories, and one gloriously cursed Golden Rubbish Bin. I also help run tech for PPIA UNSW, the Indonesian student community here, because building things that bring people together is the whole reason I started.

When I'm not coding you'll find me hunting Sydney's coffee scene, planning the next trip, or quietly turning caffeine into commits. ☕

02 — At a glance
UNSW
Computer Science
2026
Graduating
Sydney
Based in AU
Award wins
03 — The path so far

Experience & education

2026

Foresight Analytics — Data Analyst & Automation Engineer Intern

May 2026 – Present · Sydney, AU

Building automation workflows with n8n to streamline internal data operations for a boutique investment intelligence firm serving 50+ Australian asset managers.

Supporting data analytics pipelines using Excel, Azure SQL, and Databricks — working across investment diligence, ratings research, and ESG datasets.

Conducting market and product research to inform analytical frameworks and data strategy within a DataOps-driven environment.

n8nAzure SQLDatabricksExcelResearchDataOps
2025

UNSW × Atlassian — Software Developer

Sep 2025 – Dec 2025 · Sydney, AU

Led development of enterprise Q&A system as top contributor (121 commits), delivering a secure real-time audience interaction platform for Atlassian town halls.

Designed and implemented 3-layer end-to-end testing infrastructure (API, integration, UI) with automated CI pipeline.

Built backend services with SQL schema design, implementing structured data validation and access controls across resolvers and API endpoints.

Developed moderator dashboard with role-based permissions, audit trail tracking, and session facilitation controls.

TypeScriptReactGraphQLSQLCI/CDTesting
2025

PPIA UNSW — Frontend Lead

Aug 2025 – Nov 2025 · Sydney, AU

Led a 10-person cross-functional team with structured Agile governance, daily standups, sprint reviews, and documented workflows.

Drove stakeholder alignment through bi-weekly demos with PPIA board, translating feedback into 15+ feature enhancements.

Mentored 4 junior developers on code review, Git workflows, and development standards.

Architected a component-based frontend enabling parallel development by 3 sub-teams without integration conflicts.

ReactNext.jsAgileTeam LeadershipCode Review
04 — The toolbox

What I build with

Data & Analytics

/ analyse
SQLPythonpandasNumPydbtSnowflakePostgreSQLTableauLookerscikit-learn

Software & Web

/ build
TypeScriptReactNext.jsNode.jsExpressSupabasePostgreSQLTailwindWebSocketGit
Still reading?

Let's build something together.