Data Analyst
Software and Game Developer
I'm a tech professional with a background that's a bit different from most in the field.
Before tech, I was a consistent academic scholar who took up
a career in Marine Transportation,
where I got licensed as a Merchant Marine Officer
and worked onboard oil-chemical tankers
as a Seafarer for almost 3 years.
When the COVID-19 pandemic put that career on hold,
I adapted and picked up new skills,
working in the Financial Services industry and Sales for almost 2 years before
moving into tech.
Since then, I've completed several capstone projects, studied Mathematics,
finished the Google Data Analytics Professional Certificate,
and completed a Data Science and Business Analytics Internship at The Sparks Foundation.
I've also been building a strong foundation in software development,
with a particular focus on game development. I'm currently developing
Survivor's Mask, a solo 2D action RPG in Unity, as I continue exploring
where my skills in data, software, and game development can take me.
Outside of work, I stay active through weightlifting and running,
since I believe there's a strong positive correlation between physical and mental health.
Survivor's Mask is a top-down 2D action RPG built in Unity 6 with C#,
developed solo as one of my portfolio projects.
- Finite State Machines managing player animation, movement, and combat states
- Persistent game architecture using a custom GameManager script to maintain state for Player, Canvas, and Cameras across 10+ scenes
- Enemy AI built with 2D colliders, including grid-based attack patterns for chess-themed enemies using custom TileWarning scripts to telegraph attacks
- Dialogue and NPC systems built with ScriptableObjects
- Shop, inventory, and item effect systems
3D Modeling
A flappy bird style game mixed with the popular Filipino tale: Ibong Adarna.
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.
A collection of the Data visualizations and Dashboards I've made
for my Capstone Projects using the Business Intelligence tool: Tableau.
In this scenario:
Developed a supervised machine learning model in Python
to predict students' exam scores based on their study hours.
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.
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!
Really fulfilling project.
EDA on Python about COVID-19 Cases in the City of Manila, Philippines from 2020-2023.
For subscription-based businesses, reducing customer churn is a top priority.
Simple Excel project on Data Cleaning and Dashboard Creation.
Data Analyst at Thriday
Data Science and Business Analytics Intern at The Sparks Foundation.
Financial Advisor at Sun Life of Canada Philippines Inc.
Seafarer at Stella Marris Shipmanagement/Empire Navigation Inc.
Academic Excellence Awardee and
Consistent Academic scholar at Asian Institute of Maritime Studies.
You can also click on the images as well,
it will automatically open the Certificate in a new tab.
I've completed the Google Data Analytics Professional Certificate!
Courses taken:
Learned more about:
Learned a lot about Python and SQL from this Bootcamp.
Projects:
Blender props and Level Design in Unity 3D
Level Design in Unity using props I created on Blender
↑ 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
Ibong Adarna - Flappy bird game
This game was created using Unity Engine and C# programming language.
Instacart dataset Analysis
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!
Tableau Dashboards
I published the following on Tableau Public:
- Instacart dataset analysis
- Exploratory Data Analysis - Retail
Exploratory Data Analysis - Retail
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.
Prediction using Supervised Machine Learning
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.
Danny's Diner
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
Pizza Runner
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
Balanced Tree Clothing Co.
Was able to practice a lot of SQL Queries including several business questions and the 25th, 50th and 75th percentiles.
Exploratory Data Analysis: COVID-19
Analyzing Customer Churn in Excel
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.
Bike Sales Dashboard (Excel)
- Data Cleaning
- Nested IF Statements
- Pivot tables
- Dashboard creation
Experience:
Data Analyst
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
Sept 2023 - Sept 2023 (1 Month)
Financial Advisor
June 2021 - January 2023 (1 year and 8 months)
Seafarer / Merchant Marine
March 2018 - December 2020 (2 years and 10 months)
Academic Student Scholarship Recipient
2015 - 2017 (2 years)
Certificates
Google Data Analytics Professional Certificate
Throughout this journey, I've acquired some invaluable skills.
I've become proficient in collecting and cleaning data using tools like
SQL, Tableau, R, Google Sheets, and Excel.
Analyzing data has become second nature to me.
I've also learned how to create compelling data visualizations using Tableau, which is essential for conveying insights effectively,
I also worked on a Capstone Project entitled “Cyclistic Bike-Share”.
This accomplishment brings me one step closer to my goal of becoming a Data Analyst,
and it perfectly aligns with my interests and career aspirations.
I'm excited to see where this newfound knowledge will take me in my professional journey!
DataCamp
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.
Statistics for Data Science and Business Analysis
- Descriptive Statistics
- Inferential Statistics
- Hypothesis Testing
- Regression Analysis
Data Vanguard (Python and SQL Bootcamp)
Also made projects about SQL and Python:
- Instacart Dataset Analysis (SQL)
- COVID-19 Cases in the City of Manila
Contact
Data icons created by Freepik - Flaticon
Analysis icons created by Freepik - Flaticon
Graphic icons created by Freepik - Flaticon