AVAILABLE FOR WORK

Hi, I'm Irfan
Data Enthusiast

Results-driven Data Analyst with a Bachelor’s in Computer Systems and an Associate degree in Computer Engineering, blending a robust technical foundation with advanced analytical expertise. Proficient in architecting automated end-to-end ETL pipelines using Apache Airflow and Docker, and experienced in processing large-scale datasets (14GB+) to uncover actionable business metrics. Proven track record in applying the CRISP-DM methodology to deliver strategic insights in Banking (Customer Churn), HR Analytics (Attrition), and Urban Mobility. Expert in Python, SQL, and data visualization tools such as Power BI and Looker Studio, with a specialized focus on driving data-informed decisions within the FMCG, Fintech, and Logistics sectors.

View Projects Contact Me

Jakarta, Indonesia

Education

Gunadarma University

2025

Bachelor's degree, Computer System

Gunadarma University

2023

Diploma of Education, Computer Engineering

Experience

Japanese Translator

Tropics Entertainment | January 2025 - Now

Performing accurate and context-aware translations for films, videos, and other multimedia content.
Performed precise in/out marking and synchronization (marker application) of audio/visual content to guarantee optimal playback experience and data accuracy.
Conducted rigorous Quality Checking (QC) and editorial review, acting as an analyst to maintain linguistic and descriptive data precision.
Applied domain expertise and critical judgment to categorize content (genre, style) and ensure correct application of industry terminology (analogous to metadata application).
Applying cultural sensitivity and contextual understanding to preserve the original tone and intent of the source material.

Localization Specialist

Yuramedia Link | May 2022 - Now

Translated film content from various genres, integrating slang and cultural nuances to resonate with target audiences.
Produced accurate subtitles with precise synchronization of dialogue and visual cues.
Adapted to various subtitle formats, ensuring the final product met industry standards.

Transcriber

Vision+ | November 2024 - May 2025

Creating precise subtitle timing to align with dialogue and scenes.
Ensuring translations are culturally and contextually appropriate for easy understanding by the audience.
Worked collaboratively within a team environment to consistently meet pre-determined data and quality targets.

Featured Projects

Selected highlights of my work, delivered dynamically from the database.

Read Study Live Demo

HR Analytics

Jaya Jaya Maju is a multinational corporation established in 2000, with a workforce of over 1,000 employees spread across the country. Despite its significant scale, the company still faces challenges in managing its workforce. This has resulted in a high attrition rate—the ratio of staff departures relative to the total headcount—exceeding 10%.

The HR Department requires assistance in identifying the various factors driving this high turnover rate and seeks a business dashboard to monitor these factors on a continuous basis.

Read Study Live Demo

Bank Customer Churn

This end-to-end data analytics project focuses on diagnosing and understanding customer churn within the banking sector. With a churn rate of 20% across 10,000 customers, the bank faced a critical challenge: retaining financially stable, long-term clients who were actively moving their capital to competitors.

The analysis was conducted using the CRISP-DM (Cross-Industry Standard Process for Data Mining) methodology — moving beyond surface-level visualization into deep business understanding and strategic evaluation.

Read Study Live Demo

OTT Platform Analytics

This project explores a massive-scale user interaction dataset (approx. 14GB) from a major Video-on-Demand (OTT) platform. The primary objective is to translate raw viewing logs into actionable business strategies across four key pillars: Marketing ROI, Technical User Experience (UX), Product Feature Effectiveness, and Content Monetization.

By processing millions of rows using highly memory-efficient techniques, this analysis provides clear, data-driven recommendations to optimize ad spend, reduce churn rate, and maximize platform loyalty.

Read Study Live Demo

Olist E-Commerce: Sales & Logistics Optimization Dashboard

A comprehensive end-to-end data analysis project using Microsoft Power BI to diagnose business performance for Olist, a Brazilian e-commerce platform. This project analyzes over 100,000 transaction records to uncover the root causes of stagnant customer satisfaction scores. Key findings reveal critical bottlenecks in the logistics chain—specifically within carrier transit times—and highlight geographical disparities hindering market expansion. The dashboard provides actionable insights to optimize supply chain operations and improve customer experience.

Read Study Live Demo

Navigating the Pulse of Jakarta

50% of Transjakarta's Revenue Comes from Just 5 Operational Hours! 🚌
We often view transportation data merely as statistics. However, for my Microsoft Excel Bootcamp Final Project with DQLab, I decided to dive deeper into a full month of Transjakarta transaction data to uncover the story behind the numbers.

Read Study Live Demo

Automated ETL Pipeline For Urban Logistics

Jakarta Daily Pulse is an end-to-end Data Engineering and Business Analytics project. It demonstrates the complete lifecycle of data: from establishing an automated ETL (Extract, Transform, Load) pipeline using Apache Airflow, to deriving actionable business insights regarding the impact of weather and air pollution on daily delivery logistics in Jakarta.

This project bridges the gap between Data Engineering (building robust, idempotent pipelines) and Data Analytics (answering real-world business questions).

Read Study Live Demo

Global Tech Layoff Analysis

The Data Proves It: Trillion-Dollar Funding Doesn't Guarantee Job Security 📉

We often assume that joining a tech company fresh off a massive fundraising round is the safest career move. However, after diving into the Global Tech Layoff data (2020-2024)—covering 558,000+ impacted talents—the data tells a different story.

Hi, I'm Irfan
Data Enthusiast