Faiz's Project Portfolio

Hi there! This documentation is like a quick snapshot of my project in the data field, showing off my skills and know-how in this area.

Table of Contens :

• Data Engineering
• Python: Data Analysis and Machine Learning
• SQL
• Dashboard
• Complated Course and Certification

📂 Data Engineering

Project Link	Associated	Tools	Project Description
⚠️ Fraud Detection for Online Transaction Pipeline	IYKRA	Python, GCP(Google Cloud Storage, BigQuery), Spark, Kafka, Looker Studio	Developed and implemented an end-to-end ETL pipeline for processing online payment transaction data. The pipeline integrated batch and streaming processing, transformed raw data using Spark, built a data warehouse applying a fact and dimensional model, provided notifications when fraudulent activity was detected, and created a reporting dashboard with Looker Data Studio.

📂 Python: Data Analysis and Machine Learning

Project Link	Associated	Area	Library	Project Description
💰 Predict Loan Default Customers	VIX - Home Credit Indonesia: Data Scientist	Data Wraggling, EDA, Supervised Learning - Classification	pandas, matplotlib, seaborn, scikit-learn, scipy	Predicted customer defaults or customer would experience payment difficulties. Conducted data cleansing on raw data and analyzed over 100 features using statistical methods for feature selection. The best model achieved an accuracy of 87% and an AUC of 73% using Logistic Regression. Created a simulation by deploying a web application for loan approval prediction using Streamlit.
☎️ Telco Customer Churn	FGA x Binar Academy: Data Science [Team]	Data Wraggling, EDA, Supervised Learning - Classification	pandas, matplotlib, seaborn, scikit-learn, shap	Developed a machine learning model to predict customer churn in a telecom company. The Random Forest model yielded the highest accuracy score, reaching 89%, with the most influential feature being the total day charge. A higher charge indicates a higher potential for customer churn.
📲 Predict Clicked Ads Customer Classification	Mini Project by Rakamin Academy	Data Wraggling, EDA, Supervised Learning - Classification	pandas, matplotlib, seaborn, scikit-learn, shap, etc	Developed a machine learning model and experimented with various algorithms, ultimately determining that the Random Forest model achieved the best fit with accuracy of 96% in identifying potential users likely to click on advertisements. Analyzed key influential features with SHAP to enhance targeting for improved conversion rates and cost efficiency.
🙂 Predict Customer Personality to Boost Marketing Campaign	Mini Project by Rakamin Academy	Data Wraggling, EDA, Unsupervised Learning - Clustering	pandas, matplotlib, seaborn, scikit-learn, yellowbrick	Analyzed customer characteristics of a e-grocery store by creating a clustering model using K-means. Before to clustering, decomposition was performed, and the best cluster was determined using inertia score or distortion score. This resulted in 4 clusters based on customer behavior, considering factors such as the number of transactions, spending levels, response to campaigns, and website visit frequency.
🏬 Investigate Hotel Business using Data Visualization	Mini Project by Rakamin Academy	Data Wraggling, EDA, Data Visualization	pandas, matplotlib, seaborn	Analyzed the performance of City Hotels and Resort Hotels, identifying the frequently visited hotel type and exploring the relationships between booking cancellations, length of stay, and lead time through Python visualization. Identified potential causes for these patterns and provided business recommendations based on the analysis.
🚲 Data Quality Assessment and Customer Segmentation	VIX - KPMG Australia: Data Analytic Consulting	Data Wraggling, EDA, RFM analysis	pandas, matplotlib, seaborn	Developed and optimized a bike company market strategy by analyzing their data. Conducted a data quality assessment and identified strategies to mitigate any data quality issues. Performed customer segmentation using a simple RFM (Recency, Frequency, Monetary) analysis to recommend potential new customers for targeted marketing. Visualized insights about the targeted customer demographics on a dashboard.
🛒 Online Shoppers Purchasing Intention	Final Project -Rakamin Academy [Team]	Data Wraggling, EDA, Supervised Learning - Classification	pandas, matplotlib, seaborn, scikit-learn, shap	Built a model to predict which website visitors are likely to make a purchase or not. After testing several algorithms, Random Forest Hyperparameter Tuning demonstrated the best performance, achieving a ROC-AUC score of 90%. Through simulation, it was projected that this model could potentially increase the conversion rate by 58%.
✈️ Airline Customer Segmentation Based on LRFMC Model Using K-Means	Assignment - Rakamin Academy [Team]	Data Wraggling, EDA, Unsupervised Learning - Clustering	pandas, matplotlib, seaborn, scikit-learn, yellowbrick	Developed a clustering model employing LRFMC scores and the K-Means algorithm, resulting in the identification of 5 customer clusters: New Users, 20% are Loyal Customers, 19% are Potential Loyalists/The Champion, 18% are Need Attention, and 16% are Hibernating.

📂 SQL

Project Link	Associated	Area	Tools	Project Description
💳 Credit Card Customer Churn Analysis	VIX - BTPN Syariah: Data Engineer	Data analysis	PosgreeSQL, DBeaver, Tableau for Visualization	Created tables, loaded data in the database, and designed a star schema. Subsequently, conducted data exploration to identify customer profiles and characteristics related to churn. This analysis allowed for an examination of customer behavior based on demographic information, their relationship with the bank, and transaction history.
🛍 Maven Fuzzy Factory	Advanced SQL: MySQL Data Analysis and Business Intelligence	Data analysis	MySQL, MySQL Workbench	It is a course-based project aimed at analyzing the performance of an e-commerce business, answering various business questions using SQL, covering topics such as traffic, website measurement, product analysis, and user-level analysis. [Documentation is currently in progress.]
📦 Analyzing eCommerce Business Performance	Mini Project by Rakamin Academy	Data analysis	PosgreeSQL, pgAdmin, Excel for Visualization	Evaluated the business performance of e-commerce in Brazil by analyzing the growth in annual customer activity, annual product category quality, and annual payment type usage. The analysis utilized datasets containing information about customers, sellers, products, and orders.

📂 Dashboard

Project Link	Associated	Tools	Project Description
👩🏻‍💻 Human Resource Attrition Analysis (EDA, data analysis)	Challenge Task - IYKRA	Tableau	Joined tables within the dataset to conduct an analysis focused on identifying the demographic traits of employees who are more likely to leave the company, as well as an exploration of the factors that influence employee attrition.
🚕 Green Taxy Trip Monthly Report	Challenge Task - IYKRA	Looker Studio	Created a monthly performance report for taxi services. The report provided information about revenue generated from taxi trips and analyzed the busiest zones, days, and hours for passenger activity.
💊 Sales Report Dashboard	VIX - PT. Kimia Farma, Tbk: Big Data Analyst	Looker Studio	Created a data mart, analyzed the provided data, and generated sales reports for the company. Additionally, developed a dashboard that primarily focuses on sales data from a six-month period, including key performance indicatorssuch as total revenue per month, total sales per branch location, total sales by product, and more.
💉Indonesia Covid-19 Dashboard	Challenge by Binar Academy [Team]	Looker Studio, BingQuery	Presented information about the update of COVID cases in Indonesia, such as new active cases, new confirmed cases, new deaths, and recoveries.
👩🏻‍💻Targeted Customer Demographic Dashboard	VIX - KPMG Australia: Data Analytic Consulting	Tableau	This dashboard provides insights into the demographics of new customers to be targeted in marketing efforts after conducting prior customer segmentation analysis.

📂 Complated Course and Certification

• Advanced SQL: MySQL Data Analysis and Business Intelligent | Udemy: Maven Analytics
• Advanced NLP with spaCy | DataCamp
• Natural Language Processing with spaCy | DataCamp
• Introduction to Natural Language Processing in Python | DataCamp
• Data Science | Binar x Kominfo RI: Digital Talent Scolarship
• Business Intelligence | Rakamin Academy
• Data Science: Machine Learning Specialization | Rakamin Academy
• Big Data Using Python | CISCO x Kominfo RI: Digital Talent Scolarship
• Data Science Math Skill | Coursera: Duke University
• Python Lanjutan | Skilvul