DATA ANALYTICS ENTHUSIAST

Kelvin Irawan

I'm an ambitious, highly self-motivated data analytics enthusiast for the tech industry with a good experience in inventory management & sales skills. I am currently improving myself by learning other programming skills and working on several projects. I recently finished a 3-month Full-Stack Data Analytics program from Revou with an acceptance rate of ≤ 10 %.

Relevant Experience

Working Experience

Education

Skills

• Understanding Business Problem, Spreadsheet, SQL, Python, Data Visualization, Data communication

• Data Analytics:
  • Exploratory Data Analytics (EDA), Data Cleaning, Cluster Analysis, Cohort Analysis
  Data Tools:
  • Excel/Spreadsheet, SQL(Google BigQuery), Python (Lib: Pandas, Numpy, Sklearn, Matplotlib)
  Data Visualization:
  • Tableau (Public/Desktop), Google Data Studio(GDS)

• Analytical Skills:
  • Communication Skill, Planning & Organizing, Problem Solving

Interests

My main goal is to become a data analysis expert, but I also like to learn new things, especially other programming languages; In my free time, I also work on projects to increase my skills.

I like joining online groups for discussions about data analytics topics. In addition, I am also interested in future technological developments, so I spend a large amount of my free time exploring the latest technology advancements in the data analytics world.

Projects

Group Final Project (Junyi Academy Analysis - Kaggle)

Junyi Academy is an expanding Chinese-based online education platform that provides world-class learning free to all users, inaugurated in October 2012. From Junyi Academy Datasets, the number of active users per month significantly decreases and occurs downtrend lines. We identify the problems using cohort analysis to show which months have a significant number of active users increased and decreased; after the cohort analysis, we use cluster analysis to divide users into two spesific clusters and, we give recommendations and campaigns for each cluster.

Result: Finding and solving business problems from Junyi Academy regarding the high Churn Rate percentage and providing some strategic recommendations for Junyi Academy management.

Roles: As a Project Lead and part of the Data Analytics team, leading group discussions from defining and solving problem statements in Junyi Academy to making some strategic recommendations for Junyi Academy.

Project Code

Singapore AirBnb Case Study(Data Visualization with Tableau)

From the Airbnb Singapore Listings Dataset, I'm doing Exploratory Data Analysis (EDA) and creating interactive dashboard visualization in a map based on location listings to get exciting insights.

Result: Creating an interactive dashboard based on location map listings (neighborhood location and type of room) to get exciting insights for Airbnb Singapore management.

Roles: As a Data Analyst, defining and solving business problems, then turning them into useful information that assists management in critical decision-making.

Project Visualization

Olist-Gustavo Case Study(Customer Segmentation with Python& Data Visualization with Tableau)

From the Olist-Gustavo Dataset, I identify the business problem is a small percentage of users return to their website, and I decide to reduce the marketing budget using target marketing by using customer segmentation to increase their marketing conversion rate. The first step is doing cluster analysis to gain exciting insight and make recommendations for each cluster. In the last step, I'm doing Exploratory Data Analysis (EDA) to creating graph and combining them into an interactive dashboard (order overview) visualization, including making flexible period filters and other filters.

Result: Creating customer segmentation to increase their marketing conversion rate using cluster analysis and make recommendations for each cluster. In the last step, Exploratory Data Analysis (EDA) graph and combining them into an interactive dashboard (order overview) visualization.

Roles: As a Data Analyst, defining and solving business problems, then turning them into useful information that assists management in critical decision-making.

Project1 Project2 Code Visualization

HackerNews Case Study(Cohort Analysis with SQL)

From the HackerNews Dataset, I'm doing Exploratory Data Analysis (EDA) to gain exciting insight and create monthly retention cohorts tables and percentage of return users tables.

Result: Creating monthly retention cohorts and percentage of return users tables to help Hacker News management improve website user experience and increase user engagement to reduce the churn rate.

Roles: As a Data Analyst, defining and solving business problems, then turning them into useful information that assists management in critical decision-making.

Project

Bike Share San Francisco Case Study(Exploratory Data Analysis with SQL)

From the San Francisco Ford GoBike Dataset, I'm using SQL to manipulate the data and doing Exploratory Data Analysis (EDA) to gain exciting insight.

Result: Creating EDA to gain insight from a user profile, user trips, and user growth to help improve Bike Share San Francisco management.

Roles: As a Data Analyst, defining and solving business problems, then turning them into useful information that assists management in critical decision-making.

Project

Olist Case Study(Linear Regression) & A/B Testing

From the Olist Dataset, I'm creating Simple Linear Regression to gain exciting insight and doing A/B Testing to compare two variables.

Result: Cleaning data in Google Spreadsheet and using simple linear regression to gain exciting insight and creating A/B testing experimental to compare two variables and get the result for a significant variable that gives a better convenient rate to help management decision-making in the website.

Roles: As a Data Analyst, defining and solving business problems, then turning them into useful information that assists management in critical decision-making.

Project Code1 Code2

Understanding Business Problems Define Digital Business Growth Problem from Gojek, Ride-Hailing Application Startup (6-Pager) & Go-Food Event Tracking

I'm creating 6 pagers to help understand business problems and define digital business growth problems and the solution from Gojek, a ride-hailing application startup. After that, I created Gofood event tracking to identify the event and metrics used.

Result: Defining problems using a tree diagram and creating metrics that are used. The next steps are creating strategy priorities to increase the Annualized Gross Transaction Volume (GTV) and active users and transactions on Gojek and giving recommendations (6-Pagers), creating go-food event tracking to gain insight from the order of application use, metrics that will be tracked, property values, etc. (Event Tracking)

Roles: As a Data Analyst, defining and solving business problems, then turning them into useful information that assists management in critical decision-making.

6-Pager Event Tracking

Agro Waste Indo Web Export

I'm developing an export website for Agro Waste Indo, Corn Cob Suppliers.

Result: Creating and managing the website from zero.

Roles: As a Front-End Web Developer, designing, maintaining, and updating website pages, checking troubleshooting website problems, and monitoring website traffic activity.

Website

Contact

"I'm ready to be Data-Analyst. Please contact me at my email and Whatsapp and check my LinkedIn and Github below this. Let's get in touch!"