I'm Akmal Fauzan,
a Data Analyst
from Indonesia

Senior Data Analyst with 3+ years of experience building end-to-end automated reporting systems across logistics, mining, and palm oil industries.

Akmal Fauzan - Data Analyst illustration
View Details

About Me

I specialize in bridging the gap between complex operational data and financial strategy. With deep experience as a Senior Data Analyst and Operational Controller, I've built a track record of safeguarding company margins through automated anomaly detection and historical-based budgeting.

From architecting ETL pipelines with Apache Airflow and Pentaho to delivering executive-level dashboards across logistics, mining, and palm oil industries — my focus is always on driving efficiency and ensuring a single source of truth for decision-making.

Universitas Islam Indonesia

Bachelor of Statistics

Sep 2018 – Feb 2023

GPA
3.68 / 4.00
Key Coursework
Statistical MethodsMachine LearningTime SeriesProgramming for Data ScienceData Visualization
Beasiswa Berprestasi & Beasiswa Penggerak Kepemimpinan (2021)
Awarded for outstanding achievements in organizational leadership and academic performance.

Experience

Pancaran Inland Group

Report Management Specialist – Business Control
Oct 2025 – Present
PythonSQLApache AirflowPentaho PDIPentaho PSWPostgreSQLExcel XMLAGoogle Sheets
  • Built company-wide reporting automation across multiple business units — reduced latency ~95% (monthly → near real-time daily)
  • Designed Direct Margin reporting architecture by customer & business unit using PostgreSQL, Pentaho PDI/PSW, OLAP Cube, Excel XMLA
  • Automated GPS & fuel data collection from 5 vendors (Transtrack, Cartrack, UD Trucks, Renault Trucks, Hino) via Python & Airflow
Most PDCA Awards 2025 (GPS Automation System)

Pancaran Inland Group

Operational Controller
Aug 2025 – Oct 2025
PythonSQLExcelLooker Studio
  • Reduced manual validation workload ~80% via automated anomaly detection system (Python) flagging excessive operational expenses
  • Built end-to-end automated unbilled monitoring system replacing manual Excel, integrated with Looker Studio
Most PDCA Awards 2025 (Unbilled Monitoring Automation)

Komunitas Excel Indonesia (KEI)

Data Analyst Mentor
Feb 2026 – Present
PythonExcel (Power Query, Power Pivot)
  • Delivered bootcamps, webinars, and hands-on training covering Excel, Python, and business data analytics
  • Developed practical learning materials on reporting automation, data processing, and real-world problem-solving

Thinkmatch

Data Analyst
Jun 2023 – Jul 2025
Kalimantan (On-site)
PythonSQLPower BIQlik SensePostgreSQLApache Airflow
  • Built 20+ automated operational dashboards across 4 mining sites (Bengalon, Asam-Asam, West Kintap, Kintap Coal) under Darma Henwa
  • Owned full development of PLM reporting: Oil/Grease/Coolant, Maintenance Scheduling, Fuel Monitoring, PA, MTBF, MTTR, HO reports
  • 3-month on-site business requirement assignment in Kalimantan

BPS Republic of Indonesia

Intern Data Administrator – SHPed
Jan 2021 – Feb 2021
TableauExcelEViews
  • Processed national agricultural datasets; created Tableau infographics for Farmer Exchange Rate (NTP) publications
  • Conducted price volatility analysis between traditional and modern markets using ARCH/GARCH models

Skills

Data & Programming

Python (Pandas, NumPy, Matplotlib)SQL (PostgreSQL, MySQL, Oracle)ETL DevelopmentData Cleaning & TransformationData Validation & Auditing

BI & Visualization

Power BIQlik SenseTableauLooker StudioMicrosoft Excel (Advanced)Metabase

Data Engineering & Automation

Apache AirflowPentaho PDIPentaho PSWOLAP Cube DevelopmentWorkflow AutomationData Pipeline OrchestrationAPI IntegrationDockerGit

Business & Operational Analysis

Cost AnalysisOperational MonitoringFinancial Performance ReportingProcess OptimizationAnomaly DetectionReporting Automation

Statistical & Analytical Tools

SPSSRStudio

Projects

Automated GPS Asset Reporting

Pancaran Inland Group

PythonApache AirflowPostgreSQLGoogle SheetsAPI Integration

End-to-end GPS data automation integrating 5 vendor platforms — transforming monthly manual reporting into near real-time daily monitoring.

Impact
Reduced reporting latency by ~95%

Unbilled Monitoring Automation

Pancaran Inland Group

PythonSQLLooker StudioExcel

Automated unbilled monitoring system replacing manual Excel-based reporting, improving billing visibility and operational speed.

Impact
Reduced manual workload by ~80%

Direct Margin Reporting Architecture

Pancaran Inland Group

PostgreSQLPentaho PDIPentaho PSWOLAP CubeExcel XMLA

Scalable Direct Margin reporting architecture by customer and business unit enabling centralized profitability analysis.

Impact
Enabled near real-time profitability monitoring across business units

Plant Maintenance Operational Dashboard

Thinkmatch

Qlik SenseSQLPostgreSQLApache AirflowPython

20+ automated PLM dashboards across 4 mining sites covering Oil/Grease/Coolant, Fuel Monitoring, PA, MTBF, MTTR, and HO reporting.

Impact
Eliminated manual Excel compilation for entire PLM teams

System Anomaly Detection

Internal Project

PythonExcel Power PivotStatistical Modeling

Automated Budget vs. Actual validation tool detecting excessive operational expenses per transaction and customer in real-time.

Impact
Prevented budget overruns before escalation

Adidas Sales Dashboard

Personal Project

PythonSQLPower BIExcel

Sales dashboard visualizing product performance, regional trends, and monthly revenue to support inventory and strategy decisions.

Impact
Comprehensive sales analytics for decision-making

Achievements

Most PDCA Awards 2025

Pancaran Inland Group

Awarded as employee with the highest number of PDCA initiatives in 2025. Initiatives: Unbilled Monitoring Automation & GPS Automation System.

Issued by: SPI (Strategic, Planning, and Improvement) Department

Beasiswa Berprestasi & Beasiswa Penggerak Kepemimpinan (2021)

FMIPA UII

Awarded academic and leadership scholarships for outstanding achievements in organizational leadership and academic performance.

Issued by: FMIPA UII

Certifications

Harnessing the Power of Data with Power BI
Microsoft2025
Extract, Transform and Load Data in Power BI
Microsoft2025
Foundations: Data, Data, Everywhere
Google2025
AI Agents and Agentic AI with Python & Generative AI
Vanderbilt University2025
Data Visualization with Looker Data Studio
MySkill2025

Get in Touch

Open for new opportunities, collaborations, and mentoring. Let's build something meaningful from data.