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.
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.
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.
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.
Project Paper for Health Management Information System