Christopher Kenneth Herre

Projects

• Conducted business requirements analysis and led the design of a scalable full‑stack food delivery solution—serving customers, drivers, and restaurant admins—built with React, Node.js/Express, and MySQL.
• Defined and implemented secure access workflows, designing Google OAuth integration and Express middleware for session management and role‑based authorization.
• Translated delivery network goals into a location‑aware service by integrating Google Maps/Places API and haversine distance calculations to optimize restaurant recommendations and dynamic delivery fees.
• Designed a flexible, revenue‑driving menu customization feature—complete with ingredient modifiers and real‑time price updates—to meet evolving restaurant business needs.
• Developed an intuitive restaurant control panel enabling vendors to manage their one‑to‑one restaurant relationship—updating public‑facing information, configuring menu items with ingredients, and customizing available customer ordering options through reactive components for rapid database operations.
• Architected a normalized MySQL schema with FK relationships for one‑to‑many (users→orders) and junction tables to model true many‑to‑many associations (menu items↔ingredients, orders↔menu items), ensuring data integrity, reducing redundancy, and enabling streamlined reporting.