Christian JayBaquilid

THE PROBLEM

The same grocery item costs different amounts from store to store, and the government's suggested retail prices don't tell you where to buy.

WHAT I BUILT

A community price map. Shoppers log prices they see, the map compares stores within 2 km and against the suggested price, and a monthly shopping list is re-priced at the cheapest nearby store.

HIGHLIGHTS

• Geospatial queries in PostGIS: stores within a 2 km radius, and duplicate stores caught within 50 m.
• Row-level security in Postgres: guests can only read, registered users can contribute, and the UI mirrors the same rule.
• Money stored as whole centavos end to end, and medians use percentile_disc so every price shown is one somebody actually saw.
• 16 versioned schema migrations with test scripts; nothing is ever deleted, flags and corrections are recorded instead.
• Every screen has a loading, empty and error state, designed first as 39 Figma frames.

THE PROBLEM

A test score like 9 out of 20 says little about what a student actually knows, or what they should study next.

WHAT I BUILT

A skill-assessment web app that scores each student with a composite algorithm, places them at a skill level, and gives AI feedback that names the concepts they missed. Teachers get analytics to spot students falling behind.

HIGHLIGHTS

• Composite score that weighs question difficulty, answer speed and consistency, not just right answers.
• “The algorithm decides, the AI explains”: levels come from a fixed formula, the AI only writes the feedback.
• AI calls go through a serverless function, so the API key never reaches the browser.
• Piloted with 21 students: two who both scored 9/20 landed at Beginner and Intermediate, the detail a percentage hides.
• Installable on phones as a web app; teacher dashboard with cross-filters and an at-risk view.

THE PROBLEM

SM Life is the HR app SM employees use, and version 4.0 is a major upgrade of the platform.

WHAT I DID

I joined the concept discussions for the upgrade and contributed ideas on the user experience, engagement features, and how employee programs and internal surveys should be structured.

HIGHLIGHTS

• Ideas for engagement modules and employee program features.
• Input on workflow structure and the usability of internal surveys.