Capstone Projects

Asset Management System for Database Management System

Adapt and retrofit inventory management systems to relational database systems using a web interface system that runs on a Windows Server (deployed via AWS). Programming Languages used – SQL, Python, JavaScript, PHP, CSS, and HTML. Unfortunately, the system was taken down due to incurring costs. But, you can still see all the documentation below.

Relevant Skills:

SQL , RDBMS, Python Scripting, Front End Development, Back End Development, System Architecture, Amazon Web Services, Data Cleansing, Microsoft SQL Server, Oracle Server, MySQL Server, and Postgres Server

Information Systems

MIS Capstone Project

CAPSTONE PRESENTATION

REFERENCE FILES

1 / Capstone Project Paper

Softcopy of my Capstone Project for MIS. Click on the link to be redirected to Zenodo to view the entire project.

2 / Github Repository

Contains all the codes needed to run the entire system.

3 / Capstone Presentation Deck

Powerpoint presentation for Capstone Project.

Data Analysis on Education for Covid: Were online classes Successful?

An in-depth analysis on Covid's impact in Philippine Education. Using statistical models, quantitative and qualitative analysis and data visualization, this study explores 1) deterioration of mental health and its adverse effect in online education and 2) the social and economical factors that hindred online education.

Relevant Skills:

Excel, Data Analysis, Research, Data Cleansing, Data Visualization, Dashboard Creation, Data Studio, Reporting

SPARTA RESEARCH PAPER

Project SPARTA Capstone Project

CAPSTONE PAPER

REFERENCE FILES

1 / Capstone Project Paper

Softcopy of my Capstone Project for project SPARTA, Data Analyst Pathway.

2 / Education Dashboard (Excel)

Contains all the codes needed to run the entire system.

3 / Education Dashboard (Data Studio)

Revised version of Mock Covid Education Dashboard and hosted in Data Studio.

Other Projects

MMDA Traffic Dashboard

REFERENCE FILES

1 / Data Cleansing SQL

Contains SQL queries for Data Cleansing, and initial data analysis. All queries are available in github. Link to Raw Data.

2 / MMDA Dashboard

MMDA Traffic Dashboard hosted in Tableau Public. Alternatively, you can view the dashboard below. (Not Available for Mobile)

Relevant Skills: SQL, Data Visualization, Data Cleansing, Tableau

PH 2022 Election Telegram Bot

REFERENCE FILES

1 / Python & SQL Scripts

Python code hosted in AWS EC2 that accesses MySQL Database. Afterwards, it interfaces with a Telegram Bot. Python code also calls Twilio and Mailgun API to text and email the person, respectively. My contributions are python scripts in link and AWS EC2 (Linux OS) set up. Unfortunately, AWS Server was shut down to avoid incurring costs.

2 / PH Bot Video Presentation

Video Presentation of PH 2022 Election Bot

Relevant Skills: Python Scripting, MySQL, AWS EC2, Chat Bot

Health Information Management System

REFERENCE FILES

1 / Python & SQL Scripts

AWS Lambda programmed using python uses multiple API points. It connects with MS SQL Server and triggers stored procedures. Front-end for this project is a mobile app that accesses API end points. Server was shut down due to incurring costs.

2 / Project Paper

Project Paper for Health Management Information System

Relevant Skills: Python Scripting, MS SQL Server, AWS Lambda, Software Design