Loading... WIB
✈️
✈️

Data professional specializing in advanced SQL querying (CTEs, window functions, complex joins), Data Visualization using Metabase, and automated reconciliation pipelines using Google BigQuery. Focused on transactional, settlement, and statement data environments for B2B and fintech operations.

For Q&A, start a chat with

For escalations, please find my LinkedIn instead.

Tools I Use

GCP GCP
Big Query Big Query
Metabase Metabase
Python Python
Javascript Javascript
Matchmade

Matchmade

Data Modeler

Apr 2024 - Present
  • Built an end-to-end automated reconciliation pipeline in Google BigQuery using advanced SQL (CTEs, window functions, complex joins), reducing manual reconciliation effort by ~60% for B2B clients.
  • Reconciled transaction, settlement, and bank statement data across POS systems, payment switchers (Artajasa, Alto), payment gateways (Xendit), and corporate banks (BCA, BRI, BNI).
  • Developed a reconciliation pipeline for retail clients (Pizza Hut), matching transaction-to-statement data to shorten reconciliation cycles from days to hours.
  • Implemented SQL-based data validation logic for fintech clients (Bank Neo Commerce) to detect inconsistencies between core banking systems and payment switcher records.
  • Optimized complex BigQuery queries to support high-volume daily transaction processing with consistent data accuracy.
Braincore

Braincore

Machine Learning Engineer (Intern)

Aug 2024 – Nov 2024
  • Developed a computer vision liveness detection model, optimized and deployed using TensorFlow Lite (TFLite) for on-device mobile inference.
  • Built a structured data preprocessing pipeline to clean and standardize large-scale image datasets, improving model training stability.
IPB University

IPB University

Bachelor / Computer Science

aug 2021 - Jul 2024
  • GPA: 3.19 / 4.00
  • Relevant Coursework: Database Systems, Data Mining, Statistics and Data Analysis, Algorithm Analysis, Artificial Intelligence, Digital Image Processing.
Corn Detection using CNN Twitter Sentiment Analysis using Naive Bayes

Recent Projects

View all projects
Ram-AI Website Generator

Ram-AI Website Generator

python flask +1

An AI web app that turns text prompts into complete websites. Using Gemini LLM, I developed a tool t...

Viorama - Virtual Asistan

Viorama - Virtual Asistan

python flask +1

Developed Viorama - an intelligent library assistant system now actively serving UIN Sunan Kalijaga ...

Rama's portofolio Facelift

Rama's portofolio Facelift

python flask +1

This is my new portfolio featuring all the enhanced functionalities. What I'm most proud of is the c...

Plant Detection CNN

Plant Detection CNN

Python TensorFlow

A machine learning model that identifies four plant types (corn, cotton, rice, wheat) with 90% accur...

Latest Writing

View all posts
Read Article

Hello World!

Actually, this syntax is just to check if the compiler or environment works. But somehow tonight...

Rams Support Click to chat

Hi there! 👋

Ask me anything about Rama.

POWERED BY GEMINI AI