Cover Image
Jastin Gabriel Ongko

Jastin Gabriel Ongko

"

Driven by a passion to unlock impactful insights from data, I empower businesses to achieve their full potential through smarter decision-making, growth, and real-world product building.

"

About Me

A glimpse into who I am and what drives me

As a Data Analyst with experience as a Data Engineer at Samsung Research Indonesia and a Research Consultant at Baker & York, I specialize in solving critical business challenges through data. I have partnered with diverse clientsβ€”including the Asian Development Bank, Better Australia, Australian Football, and Hilma's Networkβ€”delivering strategic, data-driven analytics, reports, and insights that empower stakeholders to make smarter decisions and solve operational problems.

By combining my passion, proven experience, and commitment to continuous learning, I'm confident in making a valuable contribution to any team. I specialize in both data-driven analytics and building products that solve real problems.

πŸ“ Jakarta, IndonesiaπŸŽ“ BINUS UniversityπŸ’Ό Open to opportunities
1.5
Years Experience
10+
Projects Delivered
5+
Clients Served
3.75
GPA / 4.00

Skills & Tools

Technologies and tools I use to bring ideas to life

πŸ“Š
Power BI
πŸ—ƒοΈ
SQL
πŸ“ˆ
Excel
πŸ“‰
Think-Cell
☁️
AWS (S3, Glue, Athena)
πŸ”¬
Statistical Analysis
🐍
Python
⚑
JavaScript
β˜•
Java
πŸ”·
TypeScript
β–²
Next.js
🏒
SAP S/4HANA
🎨
Figma
✏️
Adobe Illustrator
🎬
Adobe Premiere
πŸ”„
N8N
βš™οΈ
Supabase

Product Building

Full-stack products I've designed, built, and shipped

🎟️

QR Ticketing Systems

Completed

A QR ticketing system designed to help event managers handle ticket distribution and automatic attendee check-ins efficiently, featuring reliable offline-first validation and real-time syncing.

Next.jsQR CodeAutomationSupabase
πŸƒ

Kahf x NewCentralPalu Fun Run

Completed

Event QR and ticketing system for Kahf x NewCentralPalu Fun Run. Features QR BIB for attendance tracking, merchandise exchange, and medal distribution with high-speed scan-to-process latency for fast-paced events.

Next.jsSupabaseMobile Phone Camera
πŸͺ

POS System

Completed

A full-featured Point of Sale system built for F&B businesses, featuring real-time inventory tracking, warehouse management, and multi-branch operations with hub-to-branch supply chain workflow.

FlutterSupabaseDartPostgreSQL
πŸ“…

Absensi dan Penjadwalan Otomatis CSP

Completed

Build an automated web-based scheduling and attendance platform for Sekolah Rajawali Makassar built with React, Laravel, and Supabase. It digitized manual spreadsheet processes to eliminate 100% of scheduling conflicts across teachers and classrooms

ReactLaravelSupabase
πŸ€–

LinkedIn Post Automation

Completed

A web app built with Next.js frontend and n8n backend to schedule and publish LinkedIn posts weekly, streamlining content management and social media automation.

Next.jsSupabaseN8NClaude AI
🦷

AI Dental Scheduler

Completed

An AI-powered dental scheduler assistant that helps clinics and patients manage appointments automatically.

n8nReactjsSupabase

Data Analytics

Data-driven insights, dashboards, and research projects

🌏

ADB Green & Digital Transition Research

Completed

How can developing Central Asian economies transition toward a green and digital future while ensuring social equity and worker protection? To answer this for ADB, I synthesized socio-economic, energy, and labor indicators from the World Bank, ILO, and WID. Using cross-country time-series models, I delivered actionable investment roadmaps focusing on internet access, youth upskilling, informal worker safety, and renewable energy transitions.

Power BIThink-CellExcelPythonEconomic Modeling
πŸ“±

Samsung App Analytics

Completed

Unifying scattered data across 4 core Samsung apps (Salaam, Samsung Gift, S-Lime, and SPay) into a single React dashboard. By processing raw logs in AWS Athena and validating APIs via Postman, I built a real-time platform to help teams track daily/monthly active users, user retention, and A/B testing outcomes.

AWS Data LakeSQLPostmanReactJSAWS Athena
πŸ›΅

Zomato Delivery Operations Analytics

Completed

Analyzed delivery operation datasets to uncover the primary factors contributing to delivery latency. Identified Weather Conditions, Traffic Jam severity, and Peak Hours as key drivers affecting delivery times, and formulated strategic recommendations to optimize efficiency.

SQLPower BIPythonData Analysis
πŸ“ˆ

Cafe Sales Data Cleaning & Visualization

Completed

Cleaned and analyzed a dirty dataset of cafe sales to extract actionable insights. Created an interactive Power BI dashboard to visualize key metrics like total sales, item popularity, and payment methods.

PythonPandasPower BIData Cleaning
πŸ“Š

Economic Data Analysis

Completed

Specialized analysis of economic indicators including CPI Inflation, GDP, Interest Rates, GDP per Capita, and Unemployment Rates for individual countries and trading blocs.

SQLPower BIExcelThink-Cell
πŸ—³οΈ

Better Australia Campaign Analytics

Completed

Monitored and visualized performance data for the Better Australia political advocacy campaign, analyzing key engagement metrics and electorate data.

Power BIExcelData Visualization

My Journey

The path of my professional and academic growth

Work Experience

Data Analyst

Baker and York Business Consulting

Jul 2024 β€” Present

Melbourne, Australia (Remote)

  • β–ΈSpecialized in economic data analysis: CPI Inflation, GDP, Interest Rates, Unemployment Rates
  • β–ΈBetter Australia campaign β€” analyzed key performance and engagement metrics
  • β–ΈCreated visualizations with SQL, Excel, Power BI, and Think-Cell
  • β–ΈStatistical analysis, data cleaning, transformation, and modeling

Intern Data Analytics

Samsung R&D Institute Indonesia

Oct 2023 β€” Mar 2024

Jakarta, Indonesia

  • β–ΈStreamlined data pipelines with AWS S3, Glue, and Athena
  • β–ΈInternational project analyzing Samsung app user behaviors
  • β–ΈBuilt quantitative models and product performance projections

Intern System Operation Support

Samsung R&D Institute Indonesia

Mar 2023 β€” Oct 2023

Jakarta, Indonesia

  • β–ΈSecurity audits and risk management documentation
  • β–ΈCross-functional collaboration with international colleagues
  • β–ΈInfrastructure and network analysis for problem-solving

Project Manager (Volunteer)

National Mandarin Competition 2022

Apr 2022 β€” Oct 2022

Jakarta, Indonesia

  • β–ΈLed cross-functional team for cultural event management
  • β–Έ279 participants, 50+ media partners engaged
  • β–ΈManaged YouTube announcement for champion reveal
Volunteer

Education

Bachelor of Information Systems

Bina Nusantara University

πŸ“ Jakarta, Indonesia

πŸ“… Aug 2020 β€” Mar 2024

🎯 GPA: 3.75 / 4.00

πŸ“š Major: Enterprise Resource Planning (ERP)

Management & OrganizationIntegrated Business ProcessDatabase ManagementTesting & Implementation

Certifications

βœ“AWS Data Lake (Udemy, 2023)
βœ“SAP Certified Application Associate β€” S/4HANA 2020
βœ“Public Speaking Professional (Udemy)
βœ“Business Analysis Basics (Skill Up)
βœ“Semi-finalist DIG IN 2022 (Top 50 / 800)