Accounting • Finance • Data • Automation

Turning financial data into clear business insight.

Accounting & Finance professional combining financial reporting, budgeting, accounts receivable, SAP S/4HANA, business intelligence, and practical automation with Python and cloud-based tools.

7+ yearsAccounting & Finance
SAP + BIS/4HANA • Power BI • Looker Studio
Python Automationpandas • Colab • GitHub workflows
Portrait of Putra Rat Ajari
Based in Jakarta, Indonesia
SAP S/4HANA
Finance + Data + Automation

About

Finance fundamentals, strengthened by data and automation.

I work across financial reporting, budgeting, project finance, accounts receivable, reconciliation, and collection monitoring. I also build practical reporting tools that turn operational data into structured dashboards and management-ready views.

Beyond spreadsheet reporting, I use Python, Power BI, Google Colab, and GitHub-based workflows to clean large datasets, validate documents and budget data, automate repetitive checks, and make information easier to monitor and act on.

Finance

Financial ReportingBudgetingCash Flow Accounts ReceivableAccounts PayableReconciliation

Systems, BI & Automation

SAP S/4HANAMicrosoft ExcelGoogle Sheets Looker StudioPower BIPython / pandas VS CodeGoogle ColabGitHub Actions

Finance & Business Intelligence

Work that connects finance, reporting, and decision visibility.

View original PDF portfolio ↗
Finance division collaboration website preview

03

Finance Division Collaboration Website

Centralized SOPs, job descriptions, dashboards, and finance references into a single internal hub.

Internal WebsiteGoogle Workspace
Automated data consolidation project preview

04

Automated Data Consolidation

Built a master Google Sheet to consolidate AR tracking data from multiple project files automatically.

IMPORTRANGEQUERYPivot Tables
SAP S/4HANA accounts receivable project preview

05

SAP S/4HANA — Accounts Receivable

Managed AR journal posting, reconciliation, aging monitoring, collection reporting, and month-end support.

SAP S/4HANAARGL Reconciliation
Budgeting and cash flow reporting preview

06

Budgeting & Cash Flow Reporting

Consolidated annual budgets, monitored monthly utilization, and prepared cash flow and variance views.

BudgetingForecastingCash Flow

Data Engineering & Automation

Practical tools built to reduce repetitive work and make large data usable.

Selected technical projects using Python, Colab, Google Sites, and GitHub.

BSPS 2015 to 2024 data processing files and Python scripts

07 / Python + VS Code

BSPS 2015–2024 — 1.4M-Row Data Processing Pipeline

Processed a multi-year dataset of approximately 1.4 million rows that exceeded the practical limits of a single Excel worksheet, then prepared clean outputs for Power BI analysis.

What I built

  • Split the source CSV into annual datasets for 2015–2024.
  • Standardized province and regency/city names with reference mappings.
  • Consolidated duplicate and regional-expansion records.
  • Created both aggregated and detailed Power BI-ready outputs.
  • Preserved identifier fields such as NIK as text during processing.

Stack

PythonpandasVS CodeCSV / ExcelPower BI-ready data

Outcome: a repeatable data-preparation workflow instead of manual handling across very large spreadsheets.

Live project

08 / Google Sites

SIPERI 2.0

A web-based information portal built with Google Sites and organized as a practical single-entry point for work information and supporting resources.

PurposeCentralize access to frequently used information.
BuildStructured web navigation and grouped resource access.
PlatformGoogle Sites.
Google SitesWeb PortalInformation Access
Open SIPERI 2.0 ↗
Source data
GitHub Actions
Scheduled / dispatched run
Updated result ✓

09 / GitHub Actions

Scheduled Workflow Automation

Built GitHub Actions-based automation for repeatable checking workflows, allowing scheduled or dispatched runs without manually starting the same process each time.

GitHub ActionsAutomationScheduled / Dispatched Run

10 / Google Colab Automation

Automated Budget & Document Validation

Built reusable Google Colab notebooks for budget validation and document-checking workflows that can be run from Google Drive without requiring a local development setup.

Budget / Pagu Validation Checks allocation data and helps compare TOR/RAB values against the available budget.
ABT Lintor Document Checklist Scans supporting-document folders, updates checklist results, and protects existing manual entries when source folders are unavailable.
Google ColabPythonGoogle DriveopenpyxlDocument Checking
Google Colab notebook used for budget and document checking
Budget / allocation checking notebook
Google Colab ABT Lintor document checklist notebook
ABT Lintor automatic checklist notebook

Portfolio note: internal paths and identifiers in automation screenshots are intentionally redacted. Source datasets and working files are not distributed through this website.

Experience

A career built across corporate and project finance.

Selected milestones from the full CV.

2023 — 2025

PT Wijaya Karya Bangunan Gedung Tbk

Staff of Finance, Collecting, and Accounting

AR cycle, SAP S/4HANA, annual budgeting, monthly cash flow consolidation, AR dashboards, and aging reports.

2019 — 2023

PT Wijaya Karya Bangunan Gedung Tbk — Project Assignments

Accounting and Finance Staff

Financial statements, vendor invoices, project payments, petty cash, reconciliations, and collection coordination.

2017 — 2019

PT Wijaya Karya (Persero) Tbk

Accounting and Finance Staff

Project accounting, financial reporting, tax payments, budgets, operational finance, and project administration.

2013 — 2016

Perum Pembangunan Perumahan Nasional (PERUMNAS)

Accounting Staff / Marketing Staff

Financial reporting, budgeting, administration, expenditure control, and earlier marketing support.

Education

S1 Accounting

Universitas Islam Sultan Agung

2013 — 2015 • GPA 3.31 / 4.00

Education

D3 Accounting

Universitas Diponegoro

2010 — 2013 • GPA 3.40 / 4.00

Training

Selected Development

TOEFL ITP 580 • Supervisory Skills • Basic Financial Modelling

2024 — 2025

Contact

Let’s talk about finance, reporting, data, and practical automation.

For professional opportunities or collaboration, contact me directly.