Projects & Certifications

A curated showcase of real-world systems, game-changing tools, and community-centered platforms. Every project and certificate reflects a passion for purpose-driven technology, strategic problem solving, and lasting social impact.

10+
Software Projects
1,000+
End-Users Empowered
12+
Certifications in Tech & Cloud
10+
Workshops & Events Led

Featured Project

Launched on March 1, 2024 — St. Paul University Manila Information Systems

SPU Manila Information Systems
Featured: March 1, 2024 Source: St. Paul University Manila FB Page

Library Attendance Monitoring System &
Multimedia Keys Monitoring System

Overview:
• Developed two internal systems for the ICT and Library departments using Java Spring Boot, PHP, and SQL, supporting over 1,000 users. Integrated QR-based attendance and asset tracking features, which were acknowledged during PAASCU accreditation.
• Provided post-deployment support including user training, bug resolution, performance optimization, and internal server management to ensure secure, uninterrupted system operations.

1,000+
Active Users
QR-Code Based
Web Automation Systems

Technology Stack

PHP SQL Java (Spring Boot) HTML CSS
View on Facebook
Image Credits: St. Paul University Manila Facebook Page

All Projects

A comprehensive showcase of technical expertise and innovation — featuring both solo and collaborative work.

SPU Manila Information Systems
Featured

SPU Manila Information Systems

Overview:
Developed an internal QR-based system for monitoring library attendance and ICT equipment inventory — streamlining operations and supporting over 1,000 users across the university.

PHP Java SQL
1,000+ Users
Thesis
Oddinary Times

Oddinary Times: A 2D PC Game

Overview:
An interactive educational platform that teaches emergency preparedness and response through gamification — built using Unity and C# to deliver an engaging learning experience.

Unity C# Game Design
95%+ Survey Satisfaction
INGAT - Hackathon Project
Hackathon

INGAT

Overview:
INGAT is a mobile-based solution that reimagines crime awareness and community safety. It delivers real-time crime mapping and safety alerts through a user-friendly smartphone interface.

Flutter Notion Innovation
2 Days Development Time
Payo Project - Appointment Scheduling System
Collaboration

Payo

Overview:
Developed a university-wide appointment scheduling system for the Guidance and Counseling Office of St. Paul University Manila. The system was tailored to meet institutional requirements and streamline student appointment management.

Flutter Agile Jira
Project — Mobile App & Emerging Tech
SPU Manila Snake Game
Open House

SPU - Manila Snake Game

Overview:
This game was showcased during the university’s Open House event to introduce prospective students to programming through an engaging, SPU-themed twist on the classic Snake game.
Game Developer: John Paolo Rosales

Python Game Development Open House
50+ Students Engaged
Student Portal
Project Activity

FB Sign-Up Test Automation

Overview:
Developed an automated testing suite using Python and Selenium to validate Facebook’s Sign-Up functionality — with special focus on mobile number and password field validations.Ensures robust form behavior through simulated real-world scenarios.

Python Selenium Web Automation
3.7 / 4.0 Final Grade
Image Credits: St. Paul University Manila Facebook Page
All images featured are either sourced from the official pages or personally captured by John Rosales.

Verified Certifications

A curated collection of certifications from 2024 to 2025 earned through IBM, Microsoft, Cisco, and Udemy. These credentials span artificial intelligence, data science, cloud platforms, networking, software design, and programming—demonstrating a strong foundation in full-stack development and systems thinking.

Artificial Intelligence Fundamentals

Artificial Intelligence Fundamentals

IBM (2025)
Completed foundational training in Artificial Intelligence, covering key concepts in machine learning, neural networks, and real-world AI applications using Python.

View Credential
Python for Data Science

Python for Data Science

IBM (2025)
Explored essential Python techniques for analyzing and visualizing data using Pandas, NumPy, and Matplotlib. Built a solid base for data-driven decision-making.

View Credential
Agile Explorer

Agile Explorer

IBM (2025)
Learned Agile development principles, Scrum methodology, and iterative delivery practices. Reinforced my ability to collaborate and deliver continuously.

View Credential
User Experience Design Fundamentals

User Experience Design Fundamentals

IBM (2025)
Gained practical skills in UX design, user-centered development, and usability testing to craft accessible, user-friendly digital experiences.

View Credential
Big Data Foundations

Big Data Foundations - Level 1

IBM (2024)
Introduced to the Big Data ecosystem, including Hadoop and Spark. Focused on managing and extracting value from large-scale datasets.

View Credential
Networking Basics

Networking Basics

Cisco (2024)
Covered fundamentals of networking, including IP addressing, protocols, routing, and switching. Strengthened understanding of digital communication.

View Credential
AZ-900 Azure Fundamentals

AZ-900: Microsoft Azure Fundamentals

Microsoft (2024)
Built cloud fluency in core Azure services, security, pricing, and deployment models. Prepared to build cloud-native and hybrid applications.

View Credential
Data Structures and Algorithms in Java

Intro to Data Structures & Algorithms in Java

Udemy (2024)
Mastered key data structures and algorithmic patterns using Java. Improved problem-solving and coding interview readiness.

View Credential
Object-Oriented Programming in Java

Object-Oriented Programming in Java

Udemy (2024)
Learned the foundations of OOP: encapsulation, inheritance, abstraction, and polymorphism. Applied these in structured Java development.

View Credential
UML and Object-Oriented Design

UML and Object-Oriented Design

Udemy (2024)
Learned to create UML diagrams like use case, class, and sequence diagrams. Modeled system architecture using OOP principles.

View Credential
SQL with MySQL

SQL - Introduction to SQL with MySQL

Udemy (2024)
Gained proficiency in SQL for querying and managing databases. Applied joins, filtering, aggregation, and schema management in MySQL.

View Credential
Intro to PHP for Web Development

Intro to PHP for Web Development

Udemy (2024)
Learned basic PHP scripting, form handling, and integration with MySQL. Developed dynamic websites with server-side functionality.

View Credential

Ready to Collaborate?

Let's discuss how we can work together to create innovative solutions that make a real impact.