Melvin Darial Yogiana

• Transformed LSEG and Bloomberg market data into the firm's internal reporting models, supporting analytics pipelines on Azure across investment diligence, ratings research and ESG datasets.
• Worked daily in Excel and R, the tools the firm's legacy data models run on, transforming datasets and building the charts that feed internal reporting.
• Built and shipped an internal research dashboard in Next.js and TypeScript, giving the research team one view of fund manager coverage, approved and recommended product list status, classification and internal ratings.
• Modelled it on a SharePoint list read live through the Microsoft Graph API so the research team can maintain it without a developer after handover, with dashboard edits propagating back to the company SQL database.
• Implemented session-based authentication, role-restricted admin configuration and access-key gating for embedded delivery, plus a mock data mode enabling development without production tenant credentials.
• Built video automation pipelines generating recurring market-update content with Gemini, ElevenLabs and Remotion, plus n8n workflows streamlining internal data operations for a boutique investment intelligence firm serving 50+ Australian asset managers.

Azure, SQL, LSEG, Bloomberg, Next.js, TypeScript, Microsoft Graph, SharePoint, n8n, Databricks

• Designed and implemented a relational database schema across 8 tables on Forge SQL (MySQL), writing 58 version-controlled schema migrations to support structured data for events, questions, voting and moderation.
• Built an ETL-style data pipeline integrating OpenAI Whisper for speech-to-text and GPT-4o-mini, transforming unstructured voice recordings into clean, structured text data written back to the production database.
• Engineered a chunked-upload data ingestion workflow to reliably move large audio payloads through a serverless backend, working within platform size constraints.
• Wrote automated data validation and integration tests in Jest, Mocha and WebdriverIO to verify data integrity and correctness across the pipeline, from ingestion through transformation to storage.
• Configured CI/CD automation with GitHub Actions to run tests and validate builds on every commit, aligned with Atlassian engineering standards.
• Collaborated in an agile team of 6 to ship a data-driven application for hybrid Atlassian developer townhalls, published on the Atlassian Marketplace and handed over to Atlassian's developer advocate for ongoing use.

Forge SQL, MySQL, TypeScript, OpenAI Whisper, GPT-4o-mini, ETL, Jest, WebdriverIO, GitHub Actions, CI/CD

• Led frontend development for Ignite, the official PPIA UNSW membership platform, building a React 19 and TypeScript application on Vite with Tailwind CSS, React Router and Radix UI.
• Architected a component-based frontend around shared UI primitives and Zod-validated forms, enabling 3 sub-teams to build member profiles, the events feed and the community directory in parallel without integration conflicts.
• Integrated the client with an Express and TypeScript REST API over Supabase PostgreSQL, covering JWT session authentication, email OTP verification, profile management, connection requests and directory search.
• Wrote frontend unit and integration tests with Vitest, React Testing Library and Mock Service Worker, mocking the documented API so interface work could proceed independently of backend delivery.
• Led a 10-person cross-functional team with structured agile governance: daily standups, sprint reviews and documented workflows, mentoring 4 junior developers on code review, Git workflows and development standards.
• Drove stakeholder alignment through bi-weekly demos with the PPIA board, translating feedback into 15+ feature enhancements.

React, TypeScript, Vite, Tailwind CSS, React Router, Zod, Supabase, PostgreSQL, Vitest, Agile, Team leadership

In progress

Finished Jan 2026

• First place, CSESoc Flagship Hackathon 2025
• UNIHACK 2026, Most Fun Idea and Best Design
• Terrible Ideas Hackathon, Most Absurd Idea with Best Execution

Completed