Available for opportunities  ·  Bandung, ID

Azhar Amirul Abid.

>  Data Process Analyst

Turning complex petrochemical and operational data into executive-grade intelligence — from raw multi-sheet Excel through to polished Power BI semantic models, Deneb Vega-Lite visuals, and machine learning research.

Download CV Contact me
Scroll
01 — About

Data practitioner engineering decision-grade intelligence, not dashboards that no one reads.

A recent Informatics graduate from Telkom University, building the BI stack that runs Indonesia's petrochemical intelligence.

I'm a Data Process & Business Intelligence Analyst currently engineering the BI foundation at PT Merak Chemicals Indonesia — a petrochemical company where raw data arrives as multi-sheet Excel chaos and has to leave as a polished Power BI semantic model that executives actually trust.

My craft sits at the intersection of Power Query M, DAX, and Deneb (Vega-Lite). I obsess over reproducibility: zero raw-data modification, reusable transformation patterns, unified measure libraries, and a shared visual theme across the department. The goal is never "a pretty chart" — it's a semantic layer that still makes sense six months later when someone else opens the file.

Before BI, my undergraduate thesis explored Depression Detection on X via Hybrid CNN-BiLSTM and Particle Swarm Optimization — so I'm equally comfortable in TensorFlow notebooks and DAX measures. I care about the full arc: clean pipeline, honest model, sharp visual, decision made.

Power BI DAX & Power Query M Deneb · Vega-Lite Python · SQL NLP & Deep Learning Petrochemical Analytics
02 — Experience

Five roles, one throughline: disciplined data, shipped as usable intelligence.

2025 Dec — Present

Data Process & BI Specialist Intern

PT. Merak Chemicals Indonesia · Maganghub, Ministry of Manpower RI
  • Architected a PTA & PX Global Capacity Intelligence Dashboard monitoring 600+ PTA and 300+ PX producers worldwide — star-schema semantic model, operation-rate DAX measures, and combo visuals that surface underperforming plants at a glance.
  • Delivered the EXIM Trade Analytics Platform covering Indonesia's cross-border flows for PET Bottle, PTA, Paraxylene, and Acetic Acid across 2023–2025 — Deneb KPI cards, trendlines, and a dynamic Value/Quantity toggle driving commercial and procurement decisions.
  • Shipped the Daily Market Watchlist Dashboard (PX, PTA, Naphtha, Benzene, Crude Oil, Ethylene) with LASTDATE-based aggregation, spread/margin KPIs, and watchlist-style Deneb sparklines.
  • Established the department's ETL & BI Development Framework — zero raw-data modification, reusable Power Query M patterns, a unified DAX measure library, and a shared Deneb Vega-Lite theme.
Power BI DAX Power Query M Deneb · Vega-Lite Star Schema Petrochemical
2025 Mar

Mobile Apps Developer (Virtual Intern)

Bank Mandiri × Rakamin Academic
  • Built MandiriNews, a native Kotlin Android app consuming RESTful APIs to deliver real-time, dynamic content.
  • Engineered a responsive UI with category-based filtering and search — smooth across device classes and screen sizes.
  • Wrote unit tests for reliability and collaborated via GitLab in an Agile flow.
Kotlin Android REST APIs GitLab Agile
2024 Nov — Jan 25

NLP Researcher — CoE CSWDA

PT. Motio Labs · Telkom University Center of Excellence
  • Processed 50,000+ news articles, engineering preprocessing and feature pipelines for a hybrid LSTM fake-news classifier reaching 85%+ accuracy.
  • Packaged the model into a user-friendly GUI application, letting non-technical users verify credibility of arbitrary news content.
Python LSTM NLP TensorFlow Feature Engineering
2024 Jul — Aug

IT Intern

PT. Jembo Cable Company, Tbk · Tangerang, Indonesia
  • Built an interactive Looker Studio production dashboard that lifted reporting efficiency by 40% across operations.
  • Analyzed 100,000+ rows of production data to surface trends and support process optimization.
  • Replaced paper-based data collection with a Google Forms pipeline — 60% less paperwork and 30% higher data accuracy.
Looker Studio Google Forms Process Optimization Manufacturing
2024 Jun

Big Data Analytics Intern (Project-based)

Kimia Farma × Rakamin Academic
  • Cleaned and harmonized 1M+ healthcare records, cutting inconsistencies by 95% and sharpening data-driven decisions.
  • Built and optimized ETL workflows and predictive models in Python + SQL, boosting processing efficiency by 40%.
  • Designed Looker Studio dashboards that lifted stakeholder comprehension by 30%.
Python SQL ETL Predictive Modeling Healthcare
03 — Selected work

Dashboards and models that drive commercial, operational, and research decisions.

PTA · PX · Global Capacity
Producers
912
Op Rate
87.4%
Capacity KT
58.2K
Project 01 · Featured

PTA & PX Global Capacity Intelligence

An end-to-end Power BI solution monitoring global petrochemical plant performance. ETL pipeline extracts monthly capacity, days offline, and production output from multi-sheet Excel workbooks — transformed via column unpivoting and operation-rate logic, loaded into a star-schema semantic model with DAX measures powering combo charts, top-producer rankings, and multi-level slicers.

600+PTA Plants
300+PX Plants
GlobalCoverage
Power BI Power Query M DAX Star Schema Deneb
EXIM · Trade Analytics
Project 02

EXIM Trade Analytics Platform

Cross-border flow analytics for Indonesia's key petrochemical products. Null-preserving ETL, country mapping, and a dynamic Value/Quantity metric toggle powering Deneb Vega-Lite KPI cards with embedded trendlines.

Power BI Deneb Vega-Lite Trade Data
Daily Market · Watchlist
PX $987
PTA $742
Naphtha $631
Benzene $845
Project 03

Daily Market Watchlist

Daily petrochemical price monitoring across the full value chain. LASTDATE-based aggregation, calculated spread/margin KPIs, and watchlist-style Deneb visuals with sparklines for real-time movement tracking.

Power BI LASTDATE DAX Sparklines Commodity
LSTM · Classifier
Project 04

LSTM Fake-News Classifier

50,000+ news articles, hybrid LSTM architecture, GUI delivery. Achieved 85%+ accuracy.

LSTM NLP Python
Markets
IDX +1.2%
Headline
Breaking News
Project 05

MandiriNews — Kotlin

Native Android news app consuming RESTful APIs with category filtering and search.

Kotlin Android REST
Thesis · PSO + CNN-BiLSTM
Project 06 · Research

Depression Detection on X

Undergraduate thesis: Word2Vec feature expansion + hybrid CNN-BiLSTM + Particle Swarm Optimization.

CNN-BiLSTM Word2Vec PSO
04 — Capabilities

The stack I've built, tested in production, across three complete BI projects this year alone.

BI & Data Engineering
Primary Stack
Power BI · DAXAdvanced
Power Query MAdvanced
Deneb · Vega-LiteAdvanced
SQL · Database MgmtProficient
Looker StudioProficient
Excel · Office ScriptsProficient
ML & Programming
Languages · Models
Python · Data ScienceAdvanced
NLP · Text ModelingProficient
Deep Learning (LSTM · CNN-BiLSTM)Proficient
Kotlin · AndroidFamiliar
Statistical AnalysisProficient
Git · GitLabProficient
Craft & Mindset
Ways of Working
Thinking & Analysis
Analytical Thinking
Critical Thinking
Problem Solving
Attention to Detail
Team & Delivery
Communication
Teamwork
Time Management
Languages
Bahasa Indonesia — Native
English — Professional
05 — Education & Certifications

Four years of Informatics at Telkom University, plus continuous professional credentialing.

T
Undergraduate Degree

Telkom University

B.Sc. Informatics — Bandung, Indonesia
Sept 2021 — Nov 2025Duration
3.57 / 4.00GPA
Undergraduate Thesis
Depression Detection on X with Word2Vec Feature Expansion via Hybrid CNN-BiLSTM Method and Particle Swarm Optimization.
Machine Learning with Big Data
UC San Diego · Coursera
Mar 2025
Foundations: Data, Data, Everywhere
Google · Coursera
Mar 2025
Penetration Testing
Coding Studio
Apr 2025
Fundamental Algorithm
Coding Studio
Apr 2025
Fundamental Command Linux
Coding Studio
Apr 2025
Basic Artificial Intelligence
Mounev Academy
Apr 2024
SQL for Career
Mounev Academy
Mar 2024
06 — Contact

Let's build something measurable together.

I'm open to full-time roles, BI engagements, and collaborative research — especially at the intersection of data engineering, petrochemical analytics, and applied machine learning.

Emailazharabid21@gmail.com
Phone+62 812 9787 9405
LinkedInazhar-amirul-abid
LocationBandung, Indonesia

Send a message

> Drop a line · I reply within 24h