Albar Pambagio Arioseto's Resume

Albar Pambagio Arioseto

Data analyst building end-to-end analytics pipelines across FMCG, retail, and healthcare. Open to relocate.

Bandung, Indonesia

  • GitHub
  • LinkedIn
  • Medium
PDF Version ↗
albarpambagio@gmail.com/
AP

About

Data analyst with hands-on experience building end-to-end analytics pipelines — from ETL and star schema design to interactive dashboards and time-series forecasting. Projects span FMCG procurement intelligence, pharmacy retail operations, and e-commerce marketing analytics. Strong foundation in Python, SQL, and business-oriented storytelling; background in UX design sharpens how I communicate findings to non-technical stakeholders.

Work Experience

PT Kautsar Inovasi Teknologi Digital

2020 - 2021

UX Designer

Designed user interfaces for school and learning management system products, translating user requirements into component specifications. Collaborated with developers to establish a shared design system, reducing implementation inconsistency across product lines.

Education

Universitas Terbuka

2022 - 2026
Bachelor of Management

Pacmann

2023 - 2025
Analytics & Data Science Program

Bangkit Academy (Google, Tokopedia, Gojek, Traveloka)

Feb 2024 - Jun 2024
Independent Study — Cloud Computing Cohort

Skills

  • Python
  • SQL
  • PostgreSQL
  • DuckDB
  • dbt
  • pandas
  • ETL Pipeline Design
  • Star Schema Modeling
  • Exploratory Data Analysis
  • Time-Series Analysis
  • Forecasting (AutoARIMA, AutoETS)
  • Funnel Analysis
  • LTV Analysis
  • Power BI
  • Next.js
  • TypeScript
  • Recharts
  • Cloudflare Pages
  • GitHub Actions
  • Marimo

Projects

In Progress

Indonesia Food Price Intelligence
github.comalbarpambagio/indonesia-food-price-intelligence

17-year WFP food price pipeline (325,240 raw rows → 2,116 analytical rows) across 224 markets in 34 Indonesian provinces. dbt transformation layer with 33 automated tests. AutoARIMA/AutoETS forecasting with 12-month holdout validation. 4-page procurement dashboard for FMCG Category Managers.

  • Python
  • DuckDB
  • dbt
  • AutoARIMA
  • AutoETS
  • Next.js
  • Cloudflare Pages

Pharmacy Retail Sales Analytics
github.comalbarpambagio/pharmacy-retail-sales-analytics

End-to-end ETL pipeline for 511,559 pharmacy transaction lines. Parsed irregular prescription number formats, designed star schema, classified 2,233 SKUs, and identified 2 negative-margin products. Deployed interactive 3-page dashboard with margin threshold slider and CSV export.

  • Dashboard ↗
  • Python
  • PostgreSQL
  • Next.js
  • Recharts
  • shadcn/ui
  • GitHub Actions
  • Cloudflare Pages

Olist Marketing Funnel: Channel Performance & LTV Analysis
github.comalbarpambagio/olist-marketing-report

Analyzed 8,000 MQLs and 100,000 orders. Built combined star schema joining marketing funnel and e-commerce datasets. Identified root cause of Social channel's low conversion (5.56%): 17.3% Wolf-profile deal mix — nearly double other channels. Delivered 4-page Power BI dashboard for VP Marketing budget allocation.

  • Deck ↗
  • Python
  • PostgreSQL
  • Power BI

Press Ctrl+J to open the command menu