Muhammad Randa Yandika
Data Analyst - Business Intelligence Analyst
A passionate data analyst. I have developed a solid foundation in statistical analysis, programming, and machine learning through my coursework and projects.
Hi, my name is
About Me
Hi Everyone! My Name is Muhammad Randa Yandika. I graduated from Informatics, University of Bengkulu. I have a strong interest Data Science and Data Analyst. With my backgorund, I have a solid understanding of computer systems, programming languages, and database management. Now, I am specifically focusing on enhancing my data science skills like Python, SQL, etc. by participating in various bootcamps and learning from data experts. I am confident that my skills and experience make me a great fit for any organization looking to leverage the power of data to drive their success.
Skills and Technologies:- Python
- Microsoft Excel
- SQL
- Google Looker Studio
- Power BI
- Tableau
Experience
Nov 2023 - Nov 2024
Data Analyst Intern
FINKU
- Collaborated with the analytics team, responding to and fulfilling 35+ team or user requests for product analysis using SQL.
- Created, managed, and redesigned over 80 graphics and visualizations, as well as 50+ pages within Google Looker Studio, to enhance the Company Metrics Tracker.
- Regularly showcased comprehensive company metrics visualizations and graphics at both Monthly Lending Meetings and Pre-Iteration Planning Meetings.
Jun 2023 - Jul 2023
Project-Based Intern: Data Science
Virtual Internship Experience
Kalbe Nutritionals
- Acquired and applied a comprehensive skill set, including proficiency in SQL querying, Python Programming, Machine Learning Automation and Data, Supervised & Unsupervised Learning.
- Successfully completed a project involving SQL data querying to address specific questions, proficiently designing an interactive sales dashboard using Tableau, forecasting daily product quantity sold with ARIMA, and implementing customer segmentation through K-Means clustering.
Jun 2023 - Jul 2023
Project-Based Intern: Business Intelligence Analyst
Virtual Internship Experience
Bank Muamalat
- Demonstrated proficiency in Microsoft Excel and applied end-to-end data processing skills using SQL to optimize data analysis processes, create clean datasets, and provide valuable insights for informed business decision-making.
- Leveraged data visualization and analysis expertise to generate comprehensive reports and visual representations, enabling Bank Muamalat to gain valuable insights and make informed business decisions.
- Successfully designed and developed interactive sales dashboards from raw data. Demonstrated the capability to present complex sales information in a user-friendly manner. Provided valuable suggestions to maintain and improve sales based on the insights derived from the sales dashboard.
Apr 2023 - May 2023
Project-Based Intern: Data Science
Virtual Internship Experience
Home Credit Indonesia
- Learned and Implemented learning skills and tools used at Home Credit Indonesia, such as Big Data Fundamental Knowledge, SQL Programming, Python Programming, Machine Learning, and Data Warehouse.
- Completed weekly tasks encompassing Microsoft Excel, Spreadsheet, SQL, as well as demonstrated proficiency in fundamental concepts of Big Data, Data Warehouse, data preprocessing, and Python-based modeling.
- Completed end-to-end Machine Learning modeling tasks for the Home Credit Score Card Model project based on the brief provided by Home Credit Indonesia.
Mar 2023 - Apr 2023
Project-Based Intern: Data Science
Virtual Internship Experience
ID/X Partners
- Implemented various skills and tools commonly used in ID/X Partners, such as Big Data Fundamentals, Statistics & Data Analytics SQL Querying, Python Programming, & Machine Learning
- Built a model that could predict credit risk using a dataset provided by the company, consisting of accepted and rejected loan data.
- Created Credit Risk Analysis and Prediction Project using Python
Feb 2022 - Dec 2022
Planning Support Staff
Balai Wilayah Sungai Sumatera VII
- Collected data and information need for planning and program activities
- Assisted in conducting field surveys and monitoring according to directions
- Collaborated with the planning and program teams to complete the tasks in the fiscal year 2022
Aug 2020 - Dec 2020
Database Lab Assistant
University of Bengkulu
- Provided guidance and assistant practitioners in carrying out practicum in the laboratory
- 40 Informatics students in mastering the concepts, fundamentals, and techniques of databases effectively.
- Implemented practicum in accordance with the directions and modules provided by the practicum supervisor
Feb 2020 - Jul 2020
Project-Based Internship
PT. Persada Bakti Mandiri Bengkulu
- Created and build a web based management information system for PT. Persada Bakti Mandiri to manage and monitor financial data in a project being worked on.
- Implemented enhancements that improve functionality from manual to digital
Education
Jan 2023 - Jul 2023
Data Science Bootcamp
Dibimbing.id
- Acquired comprehensive knowledge and practical skills in data science, including data analysis, machine learning, SQL querying, and statistical concepts, during an intensive 6 Month Data Science Bootcamp. Developed proficiency in using Python for data manipulation, visualization, and statistical analysis..
- Developed a machine learning model to predict productivity performance in the garment industry, extracting valuable insights from data. Applied advanced data analysis methods to uncover patterns and correlations, empowering industry decision-makers with actionable insights.
Feb 2023 - Apr 2023
Business Intelligence Analyst Course, Professional Academy Program
Binar Academy
- Learned data, functions, roles, responsibilities, and career path of BI Analyst.
- Executed needs analysis as BI Analyst and Executed data analysis process (data cleansing, profiling, transformation, query).
- Solved issues in business context with data using SQL and Google Looker Studio.
- Designed dashboard prototype based on BRD and users' feedback.
Sep 2022 - Nov 2022
Data Science Course, Fresh Graduate Academy Program
Binar Academy
- Learned basic database dan SQL queries using BigQuery.
- Created and build Covid-19 Dashboard using Google Data Studio and Tableau.
- Created Telecommunication Customer Churn Prediction Project using Python.
Aug 2017 - Oct 2021
Bachelor Degree In Computer / Sarjana Komputer
University of Bengkulu
GPA:
3.70 / 4.00
- Provided support as a database lab assistant for 2 semesters.
- Organized an off-campus event, the IT EXPO, which was attended by 400 people.
- Organized up to 15 events for the Informatics Student Association and actively participated for 3 years.
Projects
Building and Scaling ETL With Airflow
The project is to extract existing data in MySQL, after that do an aggregation from that data,
and the last task is to send that report to email. I make 3 different DAGs for each task,
the entire process is fully automated with a scheduling system I implemented from start to finish.
.
Sales Analysis, Forecasting, & Segmentation
This project uses the purchase, sales, and SOH datasets from India.
Analyze various insights that exist in the data and make business recommendations based on those insights.
And this project also carries out sales forecasting using ARIMA and customer segmentation using k-means clustering.
NYC TLC Analysis & Prediction
The main objective of this project was to conduct a deep-dive analysis of a dataset,
aiming to extract insights that would be invaluable in supporting business decisions within the organization.
Developing a machine learning time series analysis model. This model is designed to predict the number of passengers using taxi services every hour.
New York City Taxi Dashboard
This dashboard displays various insights and trends obtained from data from the NYC TLC project.
This dashboard aims to analyze taxi services in the last year. By looking at the daily trend,
hourly trend, how much is generated, and what type of payment is often used, we can make business decisions based on this insight to advance the business.
Customer Segementation Clustering & Quantity Regression
This project is for Project-Based Intern in Kalbe Nutritionals. This project creates
clustering based on customer segmentation using K-Means, and performs time series
forecasting analysis using ARIMA.
The model is made based on the brief and data provided.
Kalbe Nutritionals Sales Dashboard
This dashboard is one of the final tasks given in the Rakamin Academy & Kalbe
Nutritionals Virtual Internship Experience program. With the provided data and
brief, the goal was to identify valuable insights and determine the next business
steps to enhance sales based on the created dashboard.
Productivity Prediction of Garment Employees
Dibimbing.id Data Science Bootcamp Final Project. Create a machine learning model
that can accurately predict the productivity of the employees. This predictive model
will enable businesses to anticipate and estimate the productivity levels of their
garment employees, allowing them to make informed decisions to optimize resource
allocation, improve efficiency, and enhance overall performance.
Garment Productivity Dashboard
This dashboard is a combination of various data visualizations from the Productivity
Prediction of Garment Employees project. The dashboard provides many interesting
insights that can be utilized in business decisions and allows for the observation
of factual occurrences.
Bank Muamalat Sales Dashboard
This dashboard is one of the final tasks given in the Rakamin Academy & Bank
Muamalat Virtual Internship Experience program. With the provided data and brief,
the goal was to identify valuable insights and determine the next business steps to
enhance sales based on the created dashboard.
Customer Churn Prediction
Get insight and Predict from Customer Churn Dataset using various machine learning
technique and find best model
Indonesia Covid-19 Case Dashboard
Time series dashboard in Google Looker Studio to track COVID-19 in Indonesia
Hotel Reservation Prediction
Show visualization of hotel dataset from kaggle and use some model to predict
booking status from Customer. This solution will provide valuable insights for
hotels and help them to optimize their marketing and pricing strategies.
Steel Industry Energy Consumption
A machine learning model for predicting energy consumption in the steel industry.
Applying various machine learning techniques to classify and analyze energy usage
patterns, providing valuable insights for steel companies to optimize their energy
usage and reduce costs.
Superstore Dashboard & Business Requirements Document
Business Intelligence Analyst Course Last Project. The course has equipped me with
essential skills in Data Analysis Process, Visualization, Solve issues in business
context with data using SQL and Design dashboard prototype based on BRD and users
feedback using top industry tools like Looker Studio.
Early Diabetes Risk Prediction using Decision Tree & Random Forest
Early stage diabetes risk prediction is a machine learning project that aims to
predict an individual's likelihood of developing diabetes at an early stage, before
the onset of symptoms.
Canada's Fuel Consumption Dashboard
Canada's Fuel Consumption Dashboard with Tableau is a cutting-edge tool for drivers
and fleet managers who want to maximize their fuel efficiency and reduce costs. This
interactive dashboard provides real-time insights into fuel consumption and costs,
using data analysis and advanced visualizations powered by Tableau.
Fuel Consumption Prediction using Regression Techniques
Canada's Fuel Consumption Prediction using Machine Learning is a state-of-the-art
tool for drivers and fleet managers who want to optimize their fuel usage and reduce
costs. This advanced system uses machine learning algorithms to predict fuel
consumption based on fuel types, car model, car factory, emissions, engine size,
transmission and cylinders.
Credit Risk Analysis & Prediction
Rakamin Academy & ID/X Partners Virtual Internship Experience Final Task. model can
predict credit risk using a dataset provided by the company, consisting of accepted
and rejected loan data.
Home Credit Score Card Model
Rakamin Academy & Home Credit Indonesia Virtual Internship Experience Final Task.
The model ensures that customers who are capable of repayment are not rejected when
applying for a loan, and loans are provided with a principal, maturity, and
repayment calendar that will motivate customers to succeed.
Licenses & Certifications
DQLAB Data Scientist
This certification include hands-on training and projects to help individuals
gain practical experience in building machine learning models using Python. Upon
completion, individuals will have the ability to apply machine learning
algorithms to real-world problems and make data-driven decisions.
Database Design & Programming with SQL
The Database Design & Programming with SQL certification focuses on teaching
individuals how to design, create and manage databases using SQL (Structured
Query Language). This certification covers various topics such as database
design principles, SQL syntax and commands, data manipulation, database security
and optimization techniques.