Top Skills and Tools:
Projects:
Student Life Manager website
An all in one website/companion for college students
Task manager, budget tracker, and schedule planner in one dashboard, with an anonymous forum where
students can ask questions and share their experiences.
This project was
built for college students who are tired of juggling multiple apps to keep their student life together.
Tech used: React, Next.js, Supabase.
Team project, 6 members.
VIEW PROJECT
Blender props and Level Design in Unity 3D
3D Modeling in Blender
Level Design in Unity
↑ Click the Image above to view the 3D model of this Chibi low poly knight
↓ Click the button below to view the level design and the rest of the props
WATCH VIDEO
Ibong Adarna - Flappy bird game
A flappy bird style game mixed with the popular Filipino tale: Ibong Adarna.
This game was created using Unity Engine and C# programming language.
PLAY GAME
Instacart dataset Analysis
Analyzed the dataset of a popular online grocery delivery service in the US using Microsoft SQL Server
and visualized the data using a Tableau Dashboard.
It was a great experience handling this
extremely large dataset using SQL.
- 5 tables
- 19 columns
- 34,000,000 + rows
This Capstone Project also has a 10 minute live video presentation posted on YouTube!
VIEW CODE
Tableau Dashboards
A collection of the Data visualizations and Dashboards I've made
for my Capstone Projects using the Business Intelligence tool: Tableau.
I published the following on Tableau Public:
- Instacart dataset analysis
- Exploratory Data Analysis - Retail
VIEW DASHBOARD
Exploratory Data Analysis - Retail
In this scenario:
I am a business manager and my job is to find the weak areas we can work on
to make more profit.
Exploratory Data Analysis on Python about a Superstore that sells
Phones, Copiers, Office Supplies, and Furnitures.(SampleSuperstore.csv)
I also made a three page interactive Dashboard on Tableau.
(including the postal codes)
Completed as part of my Data Science Internship at The Sparks Foundation.
This project has a 13 minute video presentation posted on YouTube.
WATCH VIDEO
Prediction using Supervised Machine Learning
Developed a supervised machine learning model in Python
to predict students' exam scores based on their study hours.
I used Python's Scikit-Learn for this Supervised Machine Learning project
This is a Simple Linear Regression as it only involves 2 variables.
Completed as part of my Data Science Internship at The Sparks Foundation.
This project has an 8 minute video presentation posted on YouTube.
WATCH VIDEO
Danny's Diner
Danny wants to use the data to answer a few simple questions about his customers,
especially about their visiting patterns,
how much money they’ve spent and also which menu items are their favourite.
Having this deeper connection with his customers will help him
deliver a better and more personalised experience for his loyal customers.
Was able to practice the following SQL skills:
- Window Functions
- Aggregate Functions
- CTE/Common Table Expressions
- CASE Statements
VIEW CODE
Pizza Runner
Danny was scrolling through his Instagram feed when something really caught his eye - “80s Retro Styling and Pizza Is The Future!”
Danny was sold on the idea, but he knew that pizza alone was not going to help him get seed funding
to expand his new Pizza Empire - so he had one more genius idea to combine with it - he was going to Uberize it -
and so Pizza Runner was launched!
Danny started by recruiting “runners” to deliver fresh pizza from Pizza Runner Headquarters (otherwise known as Danny’s house)
and also maxed out his credit card to pay freelance developers to build a mobile app to accept orders from customers.
Was able to practice Data Cleaning and SQL Queries
VIEW CODE
Balanced Tree Clothing Co.
Really fulfilling project.
Was able to practice a lot of SQL Queries including several business questions and the 25th, 50th and 75th percentiles.
VIEW CODE
Exploratory Data Analysis: COVID-19
EDA on Python about COVID-19 Cases in the City of Manila, Philippines from 2020-2023.
VIEW CODE
Analyzing Customer Churn in Excel
For subscription-based businesses, reducing customer churn is a top priority.
In this Excel case study, I investigated a dataset from an example telecom company Databel
and analyzed their churn rates.
Analyzing churn doesn’t just mean knowing the churn rate:
it’s also about figuring out why customers are churning at the rate
they are and how to reduce churn.
I answered these questions by creating calculated columns and fields, building PivotTables,
and creating an eye-catching dashboard.
VIEW DOCUMENT
Bike Sales Dashboard (Excel)
Simple Excel project on Data Cleaning and Dashboard Creation.
- Data Cleaning
- Nested IF Statements
- Pivot tables
- Dashboard creation
VIEW CODE
Experience:
Data Analyst
Data Analyst at Thriday
Over the past three months, I gained hands-on experience with modular programming in Python,
created over 20 SQL scripts for pipeline execution, and updated a data dictionary sync app using Python and Azure Functions.
Additionally, I utilized Excel, Power Automate, and Power BI for data migration, monitoring, and dashboard editing,
while gaining exposure in SQL (SQL Server and Azure SQL), NoSQL (CosmosDB), and SDLC environments (Development, QA, and Production)
in an Australian tech startup.
March 2024 - June 2024 (3 Months)
Data Science and Business Analytics Intern
Data Science and Business Analytics Intern at The Sparks Foundation.
Sept 2023 - Sept 2023 (1 Month)
Financial Advisor
Financial Advisor at Sun Life of Canada Philippines Inc.
June 2021 - January 2023 (1 year and 8 months)
Seafarer / Merchant Marine
Seafarer at Stella Marris Shipmanagement/Empire Navigation Inc.
March 2018 - December 2020 (2 years and 10 months)
Academic Student Scholarship Recipient
Academic Excellence Awardee and
Consistent Academic scholar at Asian Institute of Maritime Studies.
2015 - 2017 (2 years)
Certificates
You can also click on the images as well,
it will automatically open the Certificate in a new tab.
Google Data Analytics Professional Certificate
I completed the Google Data Analytics Professional Certificate, building hands-on skills
in SQL, Tableau, R, Google Sheets, and Excel.
For my Capstone Project, "Cyclistic Bike-Share", I cleaned, analyzed, and visualized
real ride data to uncover patterns between casual riders and annual members.
VIEW CERTIFICATE
DataCamp
Courses taken:
1. Introduction to SQL
2. Intermediate SQL
3. Joining Data in SQL
4. Data Manipulation in SQL
5. Analyzing Business Data in SQL
6. Reporting in SQL
7. Exploratory Data Analysis in Python
8. Data Preparation in Excel
9. Data Analysis in Excel
10. Cleaning data in SQL Server Databases
11. Analyzing Customer Churn in Excel
12. Understanding Data Engineering
Continuously sharpening the saw.
Improving my skills in SQL, Excel, Python, and Statistics.
VIEW CERTIFICATES
Statistics for Data Science and Business Analysis
Learned more about:
- Descriptive Statistics
- Inferential Statistics
- Hypothesis Testing
- Regression Analysis
VIEW CERTIFICATE
Data Vanguard (Python and SQL Bootcamp)
Learned a lot about Python and SQL from this Bootcamp.
Also made projects about SQL and Python:
- Instacart Dataset Analysis (SQL)
- COVID-19 Cases in the City of Manila
VIEW CERTIFICATES