My Projects
The projects displayed below were made during my undergraduate studies, from courses, and through self-learning. There are projects that I work on alone and in groups.
I divided the projects based on the professions I'm interested in, as follows:
Data Analyst Projects
Tools used: Tableau, Google Collab, Microsoft SQL Management Studio, Ms. Excel, Ms. Access
01
Online Shop Business Transaction Performance Dashboard
Project Overview
The online shop business transaction dashboard is the final project of the Data Visualization course. In this final project, we were tasked to create an analytical dashboard with data sources from the internet. The data used is B2C e-commerce sales transactions based in the UK within one year (2019). This London-based shop has been selling gifts and homewares for adults and children through its website since 2007. The dataset contains 500K rows and 8 columns.
My Contribution in Team
This project is carried out by a team of 6 people. Here are my contributions to this project:
-
Searched for the data to be used
-
Created graphs that will be used on the dashboard
-
Contributed to making the final presentation
-
Shared the dashboard creation process with the class
Project Results
We have succeeded in creating a performance dashboard that can be used by the online shop management in making decisions. There are insights obtained when analyzing using the dashboard which can be seen in the final ppt.
​
02
Restaurant in USA Analytical Dashboard
Project Overview
This is the final project from the data visualization course. I was tasked to build an analytical dashboard with several datasets (Restaurant, review, population density, median household income, and covid cases). The datasets are derived from the United States in 2019 and 2020. Before building the dashboard, the available datasets must be cleaned and joined first because they come from different sources.
Project Goals
Develop an analytical dashboard to showcase the business insights discovered in a way that is easily understood by restaurant decision-makers and simple for them to implement to stimulate performance improvement.
Project Results
I managed to create an analytical dashboard that can be used by restaurant decision-makers for prescriptive analytics. The analytical dashboard reveals easy-to-understand and effective business insights to stimulate performance improvement.
​
03
PT Sejahtera Bersama Sales Dashboard
Project Overview
This is the final project of the virtual internship experience of Bank Muamalat Business Intelligence Analyst. The datasets used are derived from data on sales transactions of PT Sejahtera Bersama. I was asked to create a sales dashboard from these datasets to maintain sales or increase sales of PT Sejahtera Bersama. The four datasets provided must be combined using Ms. Access to create a detailed transaction table and then visualize it using Ms. Excel.
Project Goals
Build a sales dashboard to reveal business insights and utilize it to maintain or increase PT. Sejahterah Bersama sales.
Project Results
Successfully developed a sales dashboard using PT. Sejahterah Bersama's datasets, and used the sales dashboard to gain insights. Also, made a strategy to increase and maintain PT. Sejahterah Bersama's sales.
04
House Rental Analytical Dashboard
Project Overview
The House Rental Analytical Dashboard serves as the culminating project for the Data Visualization course. For this final assignment, my objective was to craft an analytical dashboard utilizing data gleaned from online sources, focusing specifically on house rental data.
Project Goals
Build a analytical dashboard to reveal business insights
Project Results
Successfully developed an analytical dashboard using house rental datasets, and used the dashboard to gain insights.
05
Prediction of Customer Intention to Purchase Travel Insurance Using the ID3 Decision Tree Classification Algorithm
Project Overview
Utilize the ID3 Decision Tree algorithm for analyzing and modeling to forecast customer intent for purchasing travel insurance.
Technology Stack: Python with Pandas, NumPy, Matplotlib, and Seaborn libraries.
Project Goals
analyzing and modeling to forecast customer intent for purchasing travel insurance.
Project Results
Successfully developed accurate and insightful ID3 decision tree model to forecast customer intent for purchasing travel insurance
06
New Product Market Strategy: Data Analysis
Project Overview
The Product Team is currently launching two new products/services, one of which is a service used to support the sale of an existing product, the Multipurpose Loan product. As a result, they require the Data Team to perform some urgent analysis to assist them in increasing their cross-selling opportunities for their newest product/service at an early stage (A/B testing). Unfortunately, there is no BI available at the Business Intelligence Center at the moment. As a result, a data scientist from the CRM Analytics team, as well as myself as a data scientist intern, will be entrusted with resolving the issue.
Project Goals
Conducted several analyzes to help the product team and marketing team to increase cross-selling opportunities for their latest products/services for the initial stage (A/B testing).
Project Results
Successfully carried out data processing and transformation of marketing campaign data using the Python programming language. Generated insights that can be used to increase cross-selling opportunities for new products/services for the initial stage (A/B testing).
07
WatchAn: Data Definition Language and Data Manipulation Language in SQL
Project Overview
This is the final project of the introduction to database systems course. I was tasked with creating a database, performing DDL and DML operations with SQL, and simulating transaction processing for WatchAn. WatchAN is the best place for selling watches managed by me and my teammates. I am responsible for managing all of the activities that belong to WatchAN. Users who are registered to the site can purchase watch online through the site. However, WatchAN is still using a manual management system to maintain the purchase and sales transactions. I need to help WatchAN to create a database system that can store data and maintain the purchase and sales transactions.
My Contribution in Team
This project is carried out by a team of 4 people. Here are my contributions to this project:
-
Designed Entity Relationship Diagram to maintain sales and purchase transactions
-
Created a database system using DDL syntax
-
Created query using DML syntax to fill the tables in the database systems and to simulate the transaction process
-
Created query to support database management process in WatchAn
Project Results
Successfully created a database system that can store data and maintain purchase and sales transactions. The database system, which has been effectively implemented in WatchAn, allows for the efficient operation of the transaction process.
System Analyst Projects
Tools used: Visual Paradigm 16.3, Figma, Ms. Word, Ms. PowerPoint
08
E-Parking
Project Overview
E-Parking is a mobile application that allows users to find and reserve parking spaces. The E-Parking project is the final group project of the Advanced in Information Systems Analysis and Design course. As system analysts, my teammates and I were tasked with designing the system for a company named E-Parking. The Unified Modeling Language is used to create the system design. We have to develop activity diagrams, multilayer sequence diagrams, package diagrams, and system input and outputs, etc. to determine the overall flow of the application.
My Contribution in Team
This project is carried out by a team of 4 people. Here are my contributions to this project:
-
Together with other team members, created UML diagrams, system architecture, and application UI.
-
Made a report and final ppt to be presented together with other team members
Project Results
We succeeded in designing a system for E-Parking by creating activity diagrams, use case diagrams, use case descriptions, sequence diagrams, first cut sequence diagrams, multilayer sequence diagrams, state machine diagrams, first cut class diagrams, domain model class diagrams, updated class diagrams, ERD, package diagrams, and app UI.
09
CuFi
Project Overview
CuFi application is a mobile application developed by PT. Home Innovation. This application will help users to be able to order custom furniture. The CuFi project is the Advanced in Information Systems Analysis and Design course's final group project. My teammates and I were tasked as system analysts with developing the system for CuFi. The system is developed using the Unified Modeling Language (UML). To define the overall flow of the application, we have to create activity diagrams, multilayer sequence diagrams, package diagrams, and system input and outputs, etc.
My Contribution in Team
This project is carried out by a team of 4 people. Here are my contributions to this project:
-
Analyzed the case study
-
Together with other team members, created UML diagrams, system architecture, and system inputs and outputs.
Project Results
We succeeded in designing a system for CuFi by creating activity diagrams, use case fully descriptions, system sequence diagram, system architecture, design system input and output, design database, first cut class diagram, crc cards, first cut sequence diagram, three layer sequence diagram, communication diagram, updated class diagram, and package diagram.
UI/UX Designer Project
Tools used: Figma, Ms. PowerPoint
10
GreatNusa
Project Overview
GreatNusa is an online learning platform that provides lifelong learners with access to learning at anytime and anywhere. GreatNusa is a project of the Bit Proto-A-Thon competition. I and 2 other team members were asked to design the user interface and user experience from the learner and learning partner side of GreatNusa on the mobile platform. To design a UI that fits the user needs, we apply a design thinking framework consisting of empathizing, defining, ideate, prototyping, and testing. We first analyzed the case study, conducted user research and observed the current platform, identified requirements and problems, provided solutions, designed prototypes, and performed testing.
My Contribution in Team
This project is carried out by a team of 3 people. Here are my contributions to this project:
-
Interviewed one of the three interviewees during the user research process
-
Along with other team members, designed the prototype of GreatNusa's mobile app from the learner and learning partner side
-
Made the final PPT and prototype demo video
Project Results
From this project, we succeeded in designing a UI/UX prototype for the application and shared the insights we got from the design thinking framework through the final ppt. My team made it into the top 10 out of 74 teams from Indonesia, Malaysia, Singapore, Nigeria, Japan, and India by designing the GreatNusa's mobile application.
Product Manager Project
Tools used: Miro, LucidChart, Ms. PowerPoint
11
MONY
Project Overview
MONY is an artificial intelligence-based program that enables users to keep track of all their financial issues, including budgeting, planning, spending, and more. With the help of Artificial Intelligence technology, users can easily track their expenses and income. MONY is a project from the entrepreneurial ideation course. In this course, we were tasked with creating a new product. The process for developing the product goes from the stage of ideation/brainstorming to the creation of a prototype. We also have to perform market research utilizing questionnaire surveys to determine our target market.
My Contribution in Team
This project is carried out by a team of 5 people. Here are my contributions to this project:
-
Initiated the idea of the application
-
Together with other team members, developed application mind map, value proposition canvas, video storytelling video, value chain industry (Process end-to-end business), application UI/UX prototype, as well as performed market research.
Project Results
Successfully developed the MONY application up to the prototype stage. What was successfully created from this project included an idea mind map, user persona, value proposition canvas, video story telling, market research results, problem identification, industry value chain (end-to-end business process), and application UI/UX design.
Other Projects
Tools used: Ms. Word
12
The Influence of Digital Financial Literacy on Interest in Investing in the Capital Market of Millennial Generation Students (Research Paper)
.png)
Project Overview
The Research Methods in Information Systems course led to the creation of this paper. Due to the younger generation's strong interest in investment and easy access to information about investing in the modern digital age, I and 3 other friends conducted research on this topic. For this research, we used a quantitative approach with a non-experimental research design. A questionnaire survey is used to obtain data. The goal of this study is to determine whether there is a correlation between student interest in capital market investment and their digital financial literacy.
My Contribution in Team
This project is carried out by a team of 4 people. Here are my contributions to this project:
-
Initiated the research topic
-
Distributed the questionnaire to 50 respondents
-
Made the research paper with the help of other team members
Project Results
As a result, extensive action is required to increase student interest in the capital market, which is precisely what this study wants to do. According to our findings, students who have access to digital financial and investment information have increased their financial literacy and developed a greater interest in investing in the capital market. Individuals are also encouraged by social media trends to try their hand at investing in the stock market. Additionally, students prefer to invest in stocks and mutual funds over other investing options.
