Open to work

Data Analytics & Business Enthusiast

Azzrial Arfiansyah

linkedin.com/in/azzrial-arfiansyah-a97407285

+6287872788220

Jakarta, Indonesia

Summary

My name is Azzrial Arfiansyah (commonly called Arfi), an active undergraduate Information Systems student at UPN Veteran Jakarta with a strong interest in data, analytics, visualization, and business. I have hands-on experience in data cleaning, exploratory analysis, customer segmentation, and visualization using various tools such as Google Workspace (Sheets, Docs, etc.), Microsoft Excel, Python, Power BI, Looker Studio, Google BigQuery, SQL, Similarweb, Figma, Miro, Google Colab, and GitHub.

Previously, I served as a Teaching Assistant for a Database course, successfully guiding 33 students in learning MySQL and related topics, improving participation and engagement by up to 85%. I also enhanced my skills through my role in the Data Science division at KSM Android, where I completed over 20 training modules on data analysis, databases, visualization, machine learning, and analytics; built multiple projects; and mentored 60 high school students in programming with a 90% positive learning feedback rate.

I am now seeking an internship opportunity in data, business, and marketing where I can leverage my analytical and creative skills to deliver impactful, data-driven solutions.

Project & Organization Experience

ksm ANDROID UPNVJ

2024 - Present

KSM Andorid UPNVJ

At KSM Android UPN Veteran Jakarta, I studied data science from the fundamentals to the beginner level, covering topics such as exploratory data analysis (EDA), machine learning, deep learning, and data visualization. I worked on several machine learning projects using Python, both independently and collaboratively. In addition to the academic aspect, I was also actively involved in organizing and participating in the community’s social initiatives.

Built end-to-end ML pipelines for time series forecasting, clustering, and classification using real-world datasets.

Predicted Microsoft (MSFT) stock prices with LSTM and deployed results via Streamlit.

Applied DBSCAN to cluster countries by life expectancy and identify health-related patterns.

Classified air quality levels using Logistic Regression, Random Forest, and XGBoost based on environmental and pollution features.

Utilized Python, pandas, scikit-learn, TensorFlow, XGBoost, and visualization tools for analysis, modeling, and evaluation.

Personal project

2025

Analyst & Visualization

This personal project was driven by my curiosity and desire to explore deeper into the fields of data visualization, machine learning, and deep learning. It also served as an opportunity to expand my understanding of new tools and frameworks.

Cleaned and prepared data using Google Colab/Jupyter (handled duplicates, nulls, and formatting)

Calculated budget realization percentages and categorized regional performance

Engineered RFM (Recency, Frequency, Monetary) features for customer segmentation

Performed univariate, bivariate, and multivariate exploratory data analysis (EDA)

Designed interactive dashboard layouts using Figma

Imported data into Power BI and calculated RFM scores using DAX

Built customer segments and visual dashboards in Power BI

Extracted insights to support marketing strategies and regional policy recommendations

Queried and cleaned 3 years of sales data in BigQuery (removed duplicates, handled nulls, standardized formats)

Detected significant revenue anomaly in May 2018, suggesting B2B or campaign impact

Identified top-performing categories (Mountain & Road Bikes) contributing 60%+ of total revenue

Teaching Assistant upnvj

2025

Database System Practicum

I was accepted as a teaching assistant for the Database course in February. In this role, I was responsible for supporting the lecturer through teaching, reporting, and preparing materials. Beyond strengthening my relationship with the lecturer, this experience also expanded my knowledge and allowed me to learn from other students and the academic environment.

Assisted the lecturer during practical sessions by guiding students through exercises and resolving technical issues

Prepared teaching materials, including modules containing exercises and assignments

Created and compiled student attendance reports

Facilitated discussions to strengthen students understanding of database concepts

Collaborated with fellow assistants to divide responsibilities in developing teaching materials

Contributed to improving the structure and delivery of practical materials based on student feedback

Skills & Tech Stack

Data Analysis & Visualization

Team collaboration

Customer Journey Analysis

Data Cleaning & Processing

Customer Segmentation (RFM)

Insight Analysis & Reporting

Data Workflow & Modeling

Database Management

Jupyter

Pandas

Power BI Dekstop

Python

MySQL

PostgresSQL

Excel

Matplotlib

Numpy

Scikit-Learn

Figma

Github

Streamlit

Google Sheets

Git

Notion

Canva

Similarweb

Miro

Looker Studio

Languages

Indonesia

English

Certificates

Links

azzriala@gmail.com

+6287872788220

unsplash.com/@reddfrancisco
unsplash.com/@reddfrancisco

Create a free website with Framer, the website builder loved by startups, designers and agencies.