# Musa Yohanes

> Software developer in Jakarta. Builds data platforms for treasury teams at a SaaS company. Former financial auditor at PwC and accounting lecturer. This portfolio covers his projects, writing, and experience at the intersection of software and finance.

The site is static, fast, and serves clean markdown twins of every page: append `index.md` to any blog or project URL, or read llms-full.txt for all content at once.

## Pages

- [Home](https://muyo.dev/): Overview, featured projects, and work experience
- [About](https://muyo.dev/about/): Career story from PwC audit and accounting lecturing to software development
- [Writing](https://muyo.dev/blog/): Articles on data analysis, automation, and engineering
- [Portfolio](https://muyo.dev/projects/): Selected projects across SaaS, data pipelines, and finance systems

## Blog

- [Why SFTP Still Rules the Finance World](https://muyo.dev/blog/why-sftp-still-rules-the-finance-world/): Why legacy SFTP connections remain the backbone of bulk data exchange in B2B finance, and what building treasury software taught me about respecting boring tools.
- [From Accountant to Software Engineer](https://muyo.dev/blog/from-accountant-to-software-engineer/): How I went from Big Four accounting to a remote software engineering role, and the faith that carried me through two years of rejections.
- [Navigating OAuth2 Authentication in VBA](https://muyo.dev/blog/navigating-oauth2-authentication-in-vba/): A practical walkthrough of implementing OAuth2 authentication in VBA to connect Excel with the Xero API.
- [How to Scrape and Analyze Instagram Engagements Data](https://muyo.dev/blog/how-to-scrape-and-analyze-instagram-engagements-data/): A walkthrough of scraping public Instagram engagement data with the Instagrapi library in Python and analyzing it to compare influencer performance.
- [Customer Data Analysis Using Python — Google's Capstone Project](https://muyo.dev/blog/diving-into-customer-data-analysis-using-python/): An exploratory analysis of a bike-sharing company dataset in Python, using visualizations to uncover rider behavior and recommend marketing strategies.
- [Data Cleaning with SQL — Google's Capstone Project](https://muyo.dev/blog/data-cleaning-with-sql/): A step by step SQL walkthrough for cleaning a bike trip dataset, covering deduplication, standardization, and validation of real world data.

## Projects

- [Treasury Data Platform](https://muyo.dev/projects/treasury-data-platform/): A B2B data platform for treasury teams at Automation Boutique: Python pipelines that collect and clean treasury data, a React dashboard on top, MongoDB and Docker on Azure. I own the technical execution end to end, production deploys included.
- [Xero API × Excel Integration](https://muyo.dev/projects/xero-excel-integration/): VBA macros that plug Xero's accounting API straight into Excel. I wrote the whole OAuth2 flow myself, including the part where Internet Explorer used to live.
- [Global Energy Consumption Dashboard](https://muyo.dev/projects/tableau-energy-viz/): An interactive Tableau dashboard on global energy use: country comparisons, growth rates, and how the energy mix shifts over time.
- [Accounts Receivable Dashboard](https://muyo.dev/projects/excel-ar-dashboard/): An Excel dashboard for tracking what customers owe, built on a real data model with VBA-generated reports. My PwC audit days picked the numbers it watches.
- [Cyclistic Rider Analysis with SQL and Python](https://muyo.dev/projects/cyclistic-data-analysis/): My Google Data Analytics capstone: 3.5 million Chicago bike-share trips cleaned up in PostgreSQL and taken apart in pandas.
- [Cyclistic Rider Dashboard in Tableau](https://muyo.dev/projects/cyclistic-tableau-dashboard/): The Tableau half of my Cyclistic capstone, so the marketing team can dig into rider behavior without touching my SQL.
- [Instagram Engagement Scraper](https://muyo.dev/projects/instagram-scraper/): Python scripts that scrape public Instagram profiles, store everything as JSON, and pick up where they left off after a rate limit knocks them down.