Hi, there!

I'm Kamal Muftie Yafi

Data Analyst & Scientist skilled in Python, SQL, Tableau, and machine learning, transforming data into actionable insights. Recent Statistics graduate from Universitas Indonesia with track record of improving operations and decision-making through data-driven strategies. Passionate about turning data into efficient solutions that drive measurable impact.

Publications

Muftie, F., Yafi, K. M., & Addina, Q. M. (2024). Perbandingan performa deteksi cyberbullying dengan transformer, deep learning, dan machine learning. Jurnal Pendidikan Informatika Dan Sains, 13(1), 75-87. https://doi.org/10.31571/saintek.v13i1.4002

Rifaie, F., Arida, E., Maireda, N. L., & Yafi, K. M. (2023). Human-Water Monitor Conflicts in Indonesia: Spatial Patterns and Mitigation Alternatives. Journal of Tropical Ethnobiology, 6(1), 1-15. https://doi.org/10.46359/jte.v6i1.160

Experiences

Work Experiences

Dec 2024 - Mar 2025

Technical Services Intern - PT Freeport Indonesia

  • Forecasted annual workloads and optimized manpower across 8 work centers using Python, reducing excessive workload by 25%.
  • Improved inventory planning by analyzing material usage in SAP, adjusting min-max levels, and optimizing procurement timing.
  • Developed dashboards and scheduling tools in Excel for compliance monitoring, budget forecasting, and daily job tracking.
Feb 2024 - Jun 2024

Data Exploration Intern - PT Nutrifood Indonesia

  • Performed clustering to group customers route based on geolocation in Python.
  • Implemented delivery scheduling optimization system using R.
  • Developed applications to search cluster routes, preprocess datasets, and validate optimization results in Python.
Feb 2023 - Jun 2024

IT Club Instructor - SMA Sejahtera 1 Depok

  • Mentored and guided 10+ high school students in the IT Club extracurricular, focused on Python language.
  • Developed Python curriculum for whole year of study, integrating the latest industry trends and best practices.
Sep 2022 - Jan 2024

Statistical Laboratory Assistant - Department of Mathematics Universitas Indonesia

  • Facilitate interactive synchronous lab sessions for Introduction to Data Science, Data Exploration and Visualization, Linear Modelling, Introduction to Multivariate Analysis, and Nonparametric Statistics courses.
  • Taught a total of 240+ students of Mathematics, Statistics, and Actuarial Science study programs in applying theoretical concepts by coding and programming via software such as Python, R, and Microsoft Excel.
  • Created assignments and a comprehensive quiz to assess student progress.

Organizational Experiences

Mar 2022 - Feb 2023

Staff of Evaluation Management, Research, and Analysis Bureau - Himpunan Mahasiswa Departemen (HMD) Matematika FMIPA UI

  • Created a report and designed a dashboard for management survey report of 13 bureaus and departments in HMD Matematika FMIPA UI 2022.
  • Created analysis reports on 7 work programs of the Simetri (Syiar Matematika Ar-Ruh Al-Islamiyah) Department.
  • Managed 60+ publication data for Notion Database of HMD Matematika FMIPA UI 2022.
Mar 2022 - Jan 2023

Staff of Research and Development Bureau - Badan Eksekutif Mahasiswa FMIPA UI (Faculty Student Executive Board)

  • Collected data of outstanding students from 6 departments of FMIPA UI and nominated the best department by leaderboards.
  • Created 2 infographics about surveys on @bemfmipaui Instagram, LINE, and Facebook account with over 200 likes in total.

Skills

skill Python
skill R
skill Git
skill GitHub
skill SQL
skill Tableau
skill Looker Studio
skill Microsoft Office
skill Visual Basic
skill HTML5
skill CSS3
skill JavaScript
skill GNU Octave
skill Mathematica
skill SAP ERP

Projects

Rupiah Exchange Rate ARDL Model

Application of Autoregressive Distributed Lag (ARDL) in modeling the effect of money supply on rupiah exchange rate.

Hoax Classification

Created a cross-validated SVM model with an accuracy of 85.7% using TF-IDF vectorizer method to detect hoax narrative using hoax dataset from MAFINDO dataset.

Data Mining on Property Data

Performed data preprocessing and EDA on property data in Indonesia to derive insights on house prices across cities and identified key characteristics of the most sought-after properties.

Breast Cancer Differential Gene Expression Analysis

Conducted Gene Filtering, LIMMA Analysis, and Gene Ontology to investigate genes that are expressed differently between normal cell and cancer cell.

Emotion Analysis Twitter Bahasa

Multiclass classification task to perform emotion analysis of tweet using NLP. Obtained LR-TFIDF model with 65.22% accuracy (precision 72,6%, recall 66,8%, dan F1-score 68,8%).

Clustering and Discriminant Analysis on Stunting Cases in Indonesia

Cluster analysis grouped Indonesian provinces into two based on infant stunting rates by age, revealing that the average age at first pregnancy is the most significant contributing factor.

Stock Forecasting PT. Telkom Indonesia (Persero) Tbk [TLKM]

Created ARIMA(p,d,q) model to forecast the stock price of PT. Telkom Indonesia (Persero) Tbk [TLKM] On October, 2004 - June 16, 2023.

Electric Vehicle Predictions

Created SARIMA(p,d,q)(P,D,Q)m model to forecast the number of Electric Vehicles (EVs) in counties of Washington.

Electric Vehicle Dashboard

Created a dashboard visualizing electric vehicle trends and forecasts across Washington State counties, alongside existing charging infrastructure.

Online Food Delivery Database System

Designed an online food delivery database system using SQLite, including simulated user, seller, and driver interactions.

GPA Calculator

Cumulative GPA Calculator for Mathematics, Statistics, and Actuarial Science study programs in Universitas Indonesia.

Management Survey Dashboard

Developed an interactive dashboard using Looker Studio to present the 2022 HMDM FMIPA UI management survey report.

Certifications

Data Exploration and Visualization using Python

Credential: #DQLAB

Data Science Academy

Show credential

Fundamental Course Software Engineering

Show credential

Probability and Statistics (A20)

Credential: 0789/KP/PAI/I/2025

SQL (Intermediate)

Credential: F6B8EA9251B2

Zero to Hero in Microsoft Excel

Credential: UC-968c14bc-d9e7-4b97-85fb-53d04869acfd