Muhamad Dimas Pratama

Treasury officer at the Ministry of Finance, Indonesia. Tech enthusiast.

I build tools and dashboards that take the manual work out of treasury reports.

Download CV

automation systems in active use

151

ledger rules checked automatically

>80%

less manual work for spending units

01 / About

About me

Works at: Directorate General of Treasury, Ministry of Finance
Based in: Purworejo, Central Java
Studying: Information Systems, Universitas Siber Asia
Shares: Build logs and tutorials as Code With Dims

02 / Journey

How I got here

I have liked maths and logic since school. I studied finance, not computer science, so most of my coding I learned on my own.

SMA Negeri 1 Purworejo, science track. Maths and logic were my favourite subjects.
One year of Informatics at Sebelas Maret University (Admitted by SBMPTN). My first year of basic programming in C, Java, and Python.
Turning point
The detour. I moved to PKN STAN to study state treasury for another opportunity: accounting, how the state budget (APBN) is managed, and how it is carried out. Most of that work lived in Excel.
Started at KPPN Masohi, fixing PCs and printers, and helping with Barang Milik Negara procurement, records and auctions. This was where I learned how things actually get run.
Back at STAN for the D3 in Asset Management (GPA 3.76). Coding came back on my own terms: programming logic, Python, PHP, and Laravel.
Started at KPPN Kolaka and met real problems worth solving. Built monitoring tools for the office, and learned React, Angular, MongoDB, and machine learning along the way.
Moved to the Bank Section and automated the quarterly TKD report with Excel VBA. Studying Information Systems at Universitas Siber Asia. Learning a lot about AI Agents

Selected Work

Things I have built

Free Excel learning platform in Indonesian, with its own formula engine

Current focus

Learning platform for data, programming, and AI

Diagnostic assistant for the IKPA output achievement score

Screenshot of Football Player Archetype Clustering

Grouping players in Europe's top 5 leagues by playing style

House price prediction for 7 Indonesian cities

More projects

Q&A over the TKD disbursement guidelines, with sources
On request
Hand-gesture energy effect on a live webcam feed
On request
Budget deviation dashboard with WhatsApp alerts
Quarterly TKD report, from raw data to Word in one run
On request
Desktop app that checks government ledgers against 151 rules
On request
Guest book and staff leave requests for KPPN Kolaka
Fills in UP and TUP disbursement documents automatically
On request
Turns a Word template into a fill-in form
Numbered-menu auto replies for client questions
On request
Online submissions for spending units under KPPN Kolaka
16 years of Antam gold prices: forecast and risk
Fiscal risk score for 196 countries
Predicts which spending units will miss the year-end target
On request

Several client projects are private and not listed here. Happy to walk through them on a call.

Work with me

Freelance work

I build tools for small teams and businesses. These are the kinds of work I take on.

Open to freelance projects & collaboration

Start a project

01
Report and document automation
Reports, letters, and forms that fill themselves. I build Excel VBA workbooks, Google Apps Script tools, and small desktop apps that take raw data, calculate it, and produce the finished document.
- Excel VBA
- Google Apps Script
- Python
- Word templates
02
Web apps
Custom web applications for a specific job: a tool your team uses every day, or a product you want to launch. Built from the database to the screen, and deployed on a server I can maintain for you.
- React
- Laravel
- Node.js
- MySQL
- Docker
03
WhatsApp replies and status notifications
Automatic answers to common questions, and a message to the customer or applicant each time the status of their request changes.
- Fonnte API
- Google Apps Script
- Webhooks
04
Data analysis and dashboards
Turning a spreadsheet or a database into answers: cleaning the data, finding the pattern, and showing it in a dashboard people can open without asking you.
- Python
- Pandas
- Machine learning
- Chart.js

How it works

Tell me the problem
Message me on LinkedIn with what you do today: the files or apps you use, how often, and what is slow or error-prone.
Agree on the scope
I reply with questions, what I would build, and a rough timeline and price, before any work starts.
Build and review
You see a working version early and tell me what to change while it is still cheap to change.
Hand over
You get the finished tool, a short guide on how to use it, and the source files where we agreed on that.

03 / Experience

Experience

Treasury offices, 2019 - today

Sep 2026 - Present
Current
Bank Staff
KPPN Kolaka
Moved from customer service to the bank section. Handles regional transfer fund (TKD) disbursement, treasury bank accounts, and UMi financing data, and advises spending units on payment requests. Still building Excel VBA automation for the section's quarterly reports.
Nov 2024 - Sep 2026
Customer Service Officer
KPPN Kolaka
Answered spending units' questions and helped them with SAKTI and MyIntress problems. Built DeviasiGuard and SI-CAPUT, which turn MyIntress Excel exports into dashboards for budget deviation and output achievement.
Sep 2024 - Oct 2024
On-the-Job Training (Re-Entry Program)
Sekretariat Direktorat Jenderal Perbendaharaan
Short re-entry training at the DG Treasury Secretariat after the study assignment, before returning to a regional office.
Aug 2022 - Sep 2024
Tugas Belajar (Ministry-Funded Scholarship)
Sekretariat Direktorat Jenderal Perbendaharaan
Fully funded study assignment (tugas belajar) from the Ministry of Finance to complete the D3 Asset Management conversion program at PKN STAN, administratively based at the DG Treasury Secretariat.
Sep 2020 - Aug 2022
General Affairs & Household Staff
KPPN Masohi
Ran procurement and payments, office logistics and protocol, public information requests (KIP), and the office's social media.
Dec 2019 - Aug 2020
Bank Staff
KPPN Serang
Processed returned treasury payments (retur): checked SP2D and beneficiary data, traced the mismatch, and worked with spending units to fix it before the funds were paid out again.

Skills & tools

What I use to build the projects above, grouped by the part of an app it covers.

Backend

10 tools

The part users never see: logins, business rules, and the connections between apps, databases, and WhatsApp.

PHP (Laravel)
Python (Flask)
Node.js (Express)
RESTful APIs
Database routing middleware
Docker
Git
Laragon
WhatsApp API (Fonnte)
LLM APIs (Gemini)

Frontend

8 tools

What people click and read: web pages, forms, and dashboards that work on phones and laptops.

React.js
Next.js
Angular
TypeScript
Tailwind CSS
Framer Motion
Three.js (3D on the web)
Interactive dashboards

Data & Automation

9 tools

Turning spreadsheets into automatic checks, ready-to-use documents, and charts.

Python (Pandas, NumPy)
Desktop apps (Tkinter)
Data Audit & Rule Validation
Word automation (python-docx)
Excel VBA Automation
Tableau
Google Apps Script
Google Looker Studio
RAG (AI answers from documents)

Databases & Infrastructure

7 tools

Where the data is stored and where the apps run online, on servers I set up and maintain myself.

MySQL
SQL Server
PostgreSQL
MongoDB
Ubuntu VPS
Nginx
phpMyAdmin

04 / Education

Education

Part-time bachelor's degree taken alongside full-time work, covering business intelligence, data mining, artificial intelligence, and enterprise systems.

Certificates

12 completed courses

Contact

Freelance work, a collaboration, or a question about something I built. Email is the fastest way to reach me.

dimasmg2017@gmail.com