Data Engineer & BI Developer

Alfen
Hasiholan

// data engineer · bi developer · ml practitioner · Jakarta, ID
3+ years building end-to-end data pipelines and BI systems — from raw ingestion and ETL to semantic modeling and dashboard delivery. SSIS · SSAS · Power BI · Python.
3+
YRS EXP
7
DASHBOARDS
1.4M
ROWS PROC.
89%
ML ACCURACY
✉ Hire me ⌥ GitHub in LinkedIn
💼
Available for freelance & remote work
BI Dashboards · ETL Pipelines · ML Apps · Data Consulting
Get in touch
// find me on
GH
GitHub
github.com/alfenh17
↗
in
LinkedIn
alfen-hasiholan
↗
✉
Email
alfenhasiholan@gmail.com
↗
K
Kaggle
kaggle.com/alfenh17
↗
Up
Upwork
Hire on Upwork
↗
PF
Portfolio
alfenh17.github.io
↗
// featured projects
PROJECT 01 · DATA ENGINEERING + BI
↗
Jakarta Transjakarta Demand Analytics
End-to-end pipeline processing 1.4M+ trip records across Jan 2023–Mar 2026. Multi-source ETL from GTFS TUMI, Open-Meteo weather API, and holiday calendar → SQL Server → SSAS Tabular → 6-page Power BI dashboard. Key finding: Lebaran caused a -71.4% ridership drop with only 2-day recovery — a unique seasonal insight exclusive to this dataset.
Python Power BI SSAS Tabular SQL Server Pandas Plotly GTFS Open-Meteo API DAX
PROJECT 02 · MACHINE LEARNING + DEPLOYMENT
↗
Jakarta House Price Predictor
XGBoost & LightGBM regression model for Jabodetabek property price prediction. Features include MRT proximity scoring via Geopy, SHAP explainability charts, and MLflow experiment tracking. Deployed as an interactive Streamlit web app — users input house parameters and receive instant price estimates with feature importance breakdown.
XGBoost LightGBM Streamlit SHAP MLflow Scikit-learn Geopy Pandas
// tech stack
DATA ENG
SSIS SSAS Tabular SQL Server ETL Design Star Schema
BI & VIZ
Power BI DAX Tableau Plotly Matplotlib Seaborn
PYTHON
Pandas NumPy Scikit-learn XGBoost LightGBM SHAP MLflow
DATABASE
PostgreSQL MySQL MongoDB
DEPLOY
Streamlit MLflow Git GitHub Pages Google Colab
// freelance services
📊
BI Dashboard Development
Power BI or Tableau dashboards from scratch — KPI tracking, sales analytics, operational reporting. ETL pipelines included.
Power BI · Tableau · SSIS
🔧
ETL Pipeline Engineering
End-to-end data pipelines from source extraction to clean, analytics-ready datasets with full documentation.
SSIS · SQL Server · Python
🤖
ML Model & Web App
Regression or classification models deployed as interactive Streamlit apps — ready for business use without writing code.
Python · XGBoost · Streamlit
🗃️
Database Design
Schema design, query optimization, and data modeling — ideal for startups building a solid data foundation.
PostgreSQL · MySQL · SQL Server
📋
Data Audit & Cleaning
Audit datasets for quality issues, clean and standardize, then deliver actionable reports — perfect pre-analysis prep.
Python · Pandas · SQL
🧩
Reporting Automation
Automate repetitive Excel or manual reports using Python scripts — save hours every week for your team.
Python · Power Automate · Excel
// experience & education
PT Astra Honda Motor
Business Intelligence Engineer
Dec 2022 – Present · Jakarta
Led delivery of 7 production dashboards (SSIS · SSAS · Power BI)
Engineered ETL for Procurement & Purchasing Control
Automated cross-department reporting workflows
Standardized ETL & documentation to enterprise standards
Brawijaya University
Bachelor's Degree in Computer Science
GPA 3.54 / 4.00 · 2018–2022 · Malang, East Java
BI Digital Talent Scholarship
Rakamin Academy × Kominfo · Mar–Apr 2022