Lead BI & Systems Analyst

Results-driven Data & BI Specialist with 3+ years of experience architecting end-to-end data pipelines, manufacturing intelligence, and automated reporting systems. Proven track record in building pioneer enterprise BI architectures and scaling solutions internationally (including U.S. Operations).

Power BI & DAX Microsoft Fabric Dataflow Gen2 Lakehouse Architecture Power Automate SQL / PostgreSQL Python GCP & BigQuery dbt & Airflow
3+ Yrs
Professional BI Experience
70%
Report Prep Time Saved
CTO
Endorsed Pioneer BI Architecture

[SLIDE 1: TRAINING SESSION]

Mentoring engineering teams on BI adoption
Cross-Departmental Engineering Training & Enablement

[SLIDE 2: AWARD RECOGNITION]

Best Employee of the Quarter Award (2024)
Best Employee of the Quarter (PT HLI Green Power)

[SLIDE 3: U.S. OPERATIONS DEPLOYMENT]

Implementation at HL-GA Battery LLC (Georgia, US)
International BI Replication (U.S. Operations)

Education Background

B.Tech in Informatics — STMIK Rosma (GPA: 3.67 / 4.00)
Karawang Cerdas Scholarship Awardee (2020–2022)

Certifications & Training

• Data Engineer Intensive — IYKRA (GCP, Airflow, dbt)
• Data Science — Binar Academy | SQL — HackerRank

Key Recognition

Best Employee of the Quarter (2024) — PT HLI Green Power for pioneering the company's first enterprise BI platform.

Current Role & Scope

ROS Business Intelligence Analyst at PT HLI Green Power. Managing multi-department E2E ETL pipelines & Fabric Lakehouses.

End-to-End System Methodology (Agile SDLC)

Click or navigate through each phase of my systematic framework for engineering enterprise BI & Data solutions.

Sprint 0: Discovery
Sprint 1: Backlog
Sprint 2: Architecture
Sprint 3: Dev & Modeling
Sprint 4: Automation
Sprint 5: UAT & Impact
SPRINT 0 // INITIATION GEMBA & DISCOVERY

Problem Definition & Field Observation

Observing physical factory workflows (Gemba) to identify paper-based bottlenecks, manual double-inputs, and operational pain points before designing any technical architecture.

Key Inputs

User Interviews, Physical Paper Worksheets, Legacy Excel Files

Core Tech & Tools

MS Forms, Process Mapping, Stakeholder Alignment

Deliverables

Business Problem Statement, Stakeholder Map, Scope Baseline

Selected Case Studies

Detailed breakdown of enterprise systems designed, built, and deployed.

Case Study 1: Consumable Control Stock BI System

Lead BI & Systems Analyst Production Mgmt, Warehouse Admins, Planning & Procurement
CTO Endorsed
1. Project Overview & Business Problem
  • As-Is Process: No digital system existed; operators physically walked to consumable rooms to track inventory using paper worksheets, handed over to admins to manually re-enter into separate Excel files per department.
  • Operational Pain Points: Data records mismatched across departments; management suffered from complete reorder blind spots; high weekly overtime costs spent purely on manual physical counts.
  • Objective: Build a centralized, automated inventory control system providing live stock balance, dynamic reorder alerting, and total inventory monetary valuation.
2. Requirements Engineering & Business Metrics
  • Key Stakeholders: Production Managers, Supervisors, Consumable Admins, Team Planning, and Team Procurement.
  • System Requirements: Standardized digital entry point for operator checkouts, automated run-out projection, and targeted reorder email alerts.
  • Defined Metrics: Dynamic Stock Balance ($\sum\text{Incoming} - \sum\text{Outcoming}$), Room Inventory Value, and Reorder Cost Projection.
3. System Design, Data Architecture & Modeling
  • Data Architecture: MS Forms (Operator Log) $\rightarrow$ Power Automate $\rightarrow$ Star Schema Dataset $\rightarrow$ Power BI Dashboard.
  • Data Model (Star Schema): Built a clean 3-table data model consisting of fact_transaction, dim_master_item, and dim_date for time-intelligence capabilities.
  • Advanced DAX Logic: Engineered dynamic status classification measures:
    🔴 Critical to Order (Current Stock $\le$ Safety Stock Threshold)
    🟡 Need to Order (Current Stock $\le$ Reorder Point)
    🟢 Safe / Good (Current Stock $>$ Reorder Point)
4. Automation & Quantifiable Business Impact
  • Automated Alerting: Programmed Power Automate to filter DAX status flags (`Critical to Order` / `Need to Order`) and automatically route notification emails with estimated order costs to Procurement & Planning.
  • Quantifiable Impact: Reduced report preparation time by 70%; completely eliminated operator overtime costs for manual counting; achieved Zero Unannounced Stockouts.
  • Recognition: Endorsed by the CTO as the company's pioneer BI architecture and earned the Best Employee of the Quarter Award (2024).

[YOUR POWER BI DASHBOARD SCREENSHOT HERE]

Replace this placeholder block with your sanitized dashboard image