Looking for a job

Farhan Wiriasubranta

@farhanwiriasubranta

Message

I automate operational workflows and build dashboards that improve business visibility and speed.

Indonesia

Message

What I'm looking for

I'm looking for an operational analytics, process improvement, or business intelligence role where I can automate manual workflows, build actionable dashboards, and support data-driven business decisions.

At Erajaya Swasembada, I automated B2B sales-order and stock-tracking workflows using Excel VBA and SAP ERP. My sales-order automation reduced processing time from five minutes to one minute per order across 20+ dealers.

I've built KPI dashboards and operational tools for Erajaya, RedDoorz, and PMPLand. At RedDoorz, I developed benchmarking and anomaly-detection tools that supported property performance reviews, fraud detection, and operational risk decisions across four regional divisions.

I combine SQL, Python, Excel, SAP ERP, Google Sheets, Apps Script, and BI dashboards to replace manual work with reliable reporting and repeatable processes.

Experience

Work history, roles, and key accomplishments

Process Improvement Analyst

PT. Erajaya Swasembada Tbk.

Aug 2025 - Feb 2026 (6 months)

Automated end-to-end B2B order workflows by integrating Excel VBA with SAP ERP, covering the full operational cycle from stock transfer to sales order fulfillment. Ensured stock and price synchronization across 20+ dealers and designed a KPI monitoring system for a 12-member data support division.

Excel VBA SAP ERP Process Automation KPI Reporting Data Validation Workflow Automation

E-Commerce & Property Performance Analyst

RedDoorz

Jan 2025 - Jul 2025 (6 months)

Conducted operational assessments for newly onboarded properties, evaluating revenue and occupancy performance against regional comparators. Developed internal tools for performance benchmarking and anomaly detection using Google Sheets and Apps Script, and identified properties with abnormal close out patterns for fraud detection.

Google Sheets Google Apps Script Data Analysis Performance Benchmarking Anomaly Detection Operational Risk

Data & Operations Support

PMPLand

Feb 2024 - Jan 2025 (11 months)

Managed end-to-end customer data pipeline for 100+ mortgage applicants every two weeks, ensuring data completeness and submission readiness. Built and maintained a Google Sheets dashboard with per-sales filtering for real-time visibility into document status.

Data Management Google Sheets Dashboard Development Process Improvement

Education

Degrees, certifications, and relevant coursework

RevoU

VBA Macro in Business, Business Automation

Completed a course on VBA Macro in Business, focusing on Microsoft Excel and VBA macro development.

MySkill

Data Analyst: Full-Stack Intensive Bootcamp, Data Analytics

Completed a full-stack intensive data analyst bootcamp covering SQL, Python, data visualization, statistics, and continuous improvement.

Universitas Pakuan

Bachelor of Management, Finance

2021 - 2025

Grade: 3.38 / 4.00

Activities and societies: Project Manager, Business Simulation Club; Research Assistant, IEOM Society International

Bachelor of Management with a focus on Finance, completed in May 2025. Thesis on consumer feasibility analysis for subsidized mortgage at PMPLand Bogor, with research presented at ICOMTED 2024 and published in IJEBD 2025.