Alfen Hasiholan

Data Engineer / BI Developer with 3+ years of hands-on experience building and maintaining end-to-end data pipelines and analytical systems, from data ingestion and transformation to semantic modeling and dashboard consumption. Experienced in working with SSIS, SSAS, SQL Server, PowerBI, and Python to deliver reliable, well-structured datasets that support KPI monitoring and operational reporting.

At Astra Honda

Motor, successfully led the delivery of 20+ production dashboards backed by robust ETL processes, reducing manual reporting effort by streamlining ETL pipelines and improving data accessibility across departments. Comfortable translating business requirements into scalable data solutions, with a strong focus on data reliability, performance, and long-term maintainability through close collaboration with cross-functional teams. Proven ability to deliver end-to-end BI solutions that translate raw data into actionable business insights.

Business Intelligence Engineer at PT Astra Honda Motor (2022-12 – Present)

• Spearheaded change request delivery for supplier performance analytics ETL pipelines using SSIS, SSAS, and Power BI, directly improving KPIs including service rate and lead time.
• Established and enforced standardization of ETL pipelines, dashboards, and documentation across 20+ production projects, improving maintainability and team onboarding efficiency.
• Led end-to-end delivery of an internal news monitoring system comprising 7 dashboards, coordinating vendor activities and ensuring on-time delivery aligned with stakeholder requirements.
• Engineered end-to-end data pipelines and Power BI dashboards for Procurement and Purchasing Control, enabling real-time oversight of AHM's expenditures and parts claim management.
• Automated recurring data integration workflows, reducing manual reporting effort and accelerating decision-making cycles across cross-functional departments.

Tableau Developer at PT. BANK NEGARA INDONESIA, TBK. (2022-09 – 2022-10)

• Designed and executed data processing workflows using Python and SQL to support financial analytics and trading performance reporting.
• Managed full-cycle delivery of analytics projects from requirement gathering to dashboard deployment, ensuring deliverables met timeline and scope.
• Produced executive-level presentations and progress reports communicating analytics findings to stakeholders using Tableau.
• Built dynamic Tableau dashboards to surface trading pattern insights, enabling faster market responsiveness and supporting strategic financial decision-making.

Data Analyst at Logee Trans (2021-07 – 2021-09)

• Extracted and cleaned large-scale datasets from MongoDB, improving report accuracy and enabling data-driven operational decisions for the logistics division.
• Designed and automated business operations reports using Python (Pandas, NumPy, Matplotlib, Seaborn, Plotly), translating raw logistics data into visual insights that informed strategic company initiatives.
• Analyzed shipment data trends to identify routing inefficiencies, contributing to improvements in delivery reliability and route accuracy.
• Built and deployed a CatBoost regression model using Streamlit to build a lightweight web-based application, enabling users to input parameters and receive real-time trip fee predictions, attaining an accuracy of 89% (R²).

Bachelor's Degree in Computer Science – Brawijaya University (2018-08 – 2022-07)