lyle agreda project case studies
home →full-stack project case studies
All 13 projects by Lyle Agreda, a software developer, web developer, and app developer in Malaybalay City, Bukidnon — from public-service platforms and healthcare systems to business websites, hospitality experiences, and real estate operations.
Ideas into working experiences.
From community systems to business websites. Explore the work, from the first project to the latest.
01 Public servicesOne Dalwangan HubA digital front desk for the barangay.
01 / Public services
One Dalwangan Hub
An installable barangay service platform bringing document requests, incident reporting, announcements, and request tracking into one place.
Purpose
Make essential local services easier to access, especially for residents using mobile devices or limited connectivity.
Architecture layers
- Presentation — Next.js and React progressive web app interface.
- Application — service requests, incident reports, announcements, and tracking flows.
- Data — PostgreSQL and Supabase persistence for resident and staff workflows.
- Infrastructure — offline-ready delivery, Leaflet mapping, and Web Push notifications.
Inside the project
- Reference-based request tracking and document verification.
- GPS-assisted incident submissions and offline-ready access.
Tech stack
Security & operations
02 HealthcareSmart Health IntegrationConnected records. Better coordinated care.
02 / Healthcare
Smart Health Integration
AI-DSUHIS is a unified health information system for Malaybalay City, Bukidnon, supporting structured health records and data-informed service coordination.
Purpose
Help healthcare and LGU teams organize information and coordinate services through accessible, role-based workflows.
Architecture layers
- Presentation — Flutter mobile interface for health workers and coordinators.
- Application — GetX modules for records, analytics, and service workflows.
- Data — Cloud Firestore records with SQLite offline synchronization.
- Infrastructure — Firebase services and Cloud Functions for a connected system.
Inside the project
- System analysis, database design, interface development, and documentation.
- Health information modules with analytics and offline synchronization.
AI features & intelligent workflows
- Google ML Kit is part of the mobile system stack for supported health-information workflows.
- Data-informed analytics help teams coordinate services across connected and offline contexts.
Tech stack
Security & operations
03 Food & hospitalityAthena’s Best Catering ServicesFrom finding a menu to planning a celebration.
03 / Food & hospitality
Athena’s Best Catering Services
A digital storefront for a home-based catering business, organizing food packages, pricing, and an ordering journey around real customer needs.
Purpose
Make catering options easier to compare and help customers plan an order with clear package information.
Architecture layers
- Presentation — React and TypeScript storefront interface.
- Application — package browsing, pricing, and guided ordering flows.
- Data — Zod-validated order payloads with Google Sheets order storage.
- Infrastructure — Vite delivery with Cloudflare Workers and Turnstile protection.
Inside the project
- Curated food packages and transparent pricing.
- Guided browsing and ordering suited to the business’s booking process.
Tech stack
Security & operations
04 Real estateProSmart Estate Web PlatformA clearer path from property discovery to inquiry.
04 / Real estate
ProSmart Estate Web Platform
A business-facing real estate website presenting properties, company information, and inquiry pathways in a responsive interface.
Purpose
Strengthen the company’s digital presence and help prospective clients find properties and start a conversation.
Architecture layers
- Presentation — React, Vite, and Tailwind responsive property interface.
- Application — location-based discovery and structured inquiry pathways.
- Data — organized property and company content for business operations.
- Infrastructure — Vercel delivery with transactional email integrations.
Inside the project
- Property presentation and location-based discovery.
- Inquiry capture and organized business content.
Tech stack
Security & operations
05 Tourism operationsTourism Accommodation & Booking ManagementOrganized stays, reservations, and availability.
05 / Tourism operations
Tourism Accommodation & Booking Management
An accommodation management platform combining property listings, reservations, and role-based dashboards for clients, owners, and administrators.
Purpose
Bring accommodation operations into a shared workflow so staff can manage listings, availability, and bookings more consistently.
Architecture layers
- Presentation — Blade and Alpine.js interfaces for public and role-based views.
- Application — listing, reservation, owner, and administrator workflows.
- Data — booking and availability records managed through Laravel and PHP.
- Infrastructure — Redis, Stripe, DomPDF, and QR-code integrations.
Inside the project
- Listing and reservation management with owner and admin views.
- Booking tracking and customer communication.
Tech stack
Security & operations
06 Tourism & governmentTourism Destination Management & BookingOne place to discover destinations and manage visits.
06 / Tourism & government
Tourism Destination Management & Booking
A tourism platform for destination promotion, visitor booking, and municipal reporting, connecting the public browsing experience with management tools.
Purpose
Help visitors plan trips while giving tourism staff an organized view of bookings and visitor activity.
Architecture layers
- Presentation — Blade visitor experience with Chart.js reporting views.
- Application — destination discovery, bookings, and municipal reporting.
- Data — MySQL persistence for visitor and destination records.
- Infrastructure — Sanctum authentication, Google API, PDF, and QR integrations.
Inside the project
- Destination discovery, booking forms, and reference tracking.
- Visitor analytics and downloadable management reports.
Tech stack
Security & operations
07 Legal servicesLaw Offices of Jay BernsteinA professional presence built around client inquiries.
07 / Legal services
Law Offices of Jay Bernstein
A law firm website presenting immigration, litigation, family law, and trial practice services through dedicated practice-area pages.
Purpose
Help prospective clients understand the firm’s services and make a consultation inquiry with confidence.
Architecture layers
- Presentation — responsive HTML, CSS, and JavaScript service pages.
- Application — practice-area navigation and consultation inquiry flow.
- Data — validated inquiry payloads for the firm’s contact workflow.
- Infrastructure — Vercel delivery with Resend and Turnstile protections.
Inside the project
- Focused practice-area pages and clear service navigation.
- Responsive contact experience with spam-protected submissions.
Tech stack
Security & operations
08 Student welfare · web + mobileBukSU KaubanWeb platform with Android and iOS apps.
08 / Student welfare · web + mobile
BukSU Kauban
A student welfare and engagement platform for BukSU available as a web platform with companion Android and iOS apps, pairing a public information portal with private student profiles and appointment scheduling.
Purpose
Give students a clear, accessible way to connect with campus support and manage their appointments across web and mobile.
Architecture layers
- Presentation — React web platform with Capacitor Android and iOS apps.
- Application — student profiles, welfare information, and appointment management.
- Data — PostgreSQL-backed records shared through the Express API.
- Infrastructure — protected admin API, secure native storage, Resend, and Google Calendar.
Inside the project
- Verified email sign-in and private appointment management.
- A web platform plus Android and iOS apps sharing the same student support experience.
Tech stack
Security & operations
09 Public serviceKonsehala Cecille PagalingA public record made easier to explore.
09 / Public service
Konsehala Cecille Pagaling
A public service portfolio organizing legislative records, community programs, partnerships, and engagements for Councilor Kathleen Cecille Pagaling.
Purpose
Make the councilor’s work easier for residents to understand through an organized, accessible public accomplishment record.
Architecture layers
- Presentation — HTML, CSS, and JavaScript public record interface.
- Application — browsable legislative, community, partnership, and engagement content.
- Data — structured accomplishment records prepared for public access.
- Infrastructure — HTTPS delivery with CSP, Permissions Policy, and security headers.
Inside the project
- Browsable ordinances, resolutions, and community initiatives.
- Engagement gallery, partnerships, and transparency information.
Tech stack
Security & operations
10 Business consultancyCloud Consultancy ServicesTurning complex services into clear next steps.
10 / Business consultancy
Cloud Consultancy Services
A consultancy website presenting business registration, regulatory support, documentation, and operational services in a structured service catalog.
Purpose
Help business owners identify relevant support and move from exploring services to requesting a consultation.
Architecture layers
- Presentation — Next.js and React service catalog interface.
- Application — service exploration, business insight, and consultation pathways.
- Data — structured service content organized around client needs.
- Infrastructure — Vercel delivery with CSP, HSTS, and Permissions Policy.
Inside the project
- Dedicated service information and a clear consultation pathway.
- Company approach, client segments, and business insights.
Tech stack
Security & operations
11 Beauty & wellnessChrisz Aesthetics & Beauté SpotExplore treatments. Build a personalized visit.
11 / Beauty & wellness
Chrisz Aesthetics & Beauté Spot
An aesthetics clinic website with a searchable treatment catalog, transparent pricing, client results, and a guided appointment request experience.
Purpose
Help clients compare treatments and assemble an appointment request while making the clinic’s services easier to navigate on mobile.
Architecture layers
- Presentation — SvelteKit treatment catalog with responsive browsing.
- Application — search, category filters, and step-by-step appointment requests.
- Data — persistent selections and same-origin inquiry payloads.
- Infrastructure — Vercel, Resend, rate limiting, and an admin studio desk.
Inside the project
- Treatment search and category browsing with persistent selections.
- Step-by-step appointment requests and same-origin inquiry routes.
Tech stack
Security & operations
12 Travel & hospitalityTulganan sa DahilayanA welcoming first look at a mountain stay.
12 / Travel & hospitality
Tulganan sa Dahilayan
A homestay website showcasing rooms, rates, amenities, and property photos, with a date-and-guest selection flow for planning a stay in Dahilayan.
Purpose
Help families and groups understand the accommodation, compare room options, and prepare a booking inquiry.
Architecture layers
- Presentation — Next.js and React stay-planning interface.
- Application — room comparison, date selection, guest selection, and inquiry flow.
- Data — availability-validated booking payloads.
- Infrastructure — Vercel delivery with a focused booking workflow.
Inside the project
- Room details, rates, property gallery, and local travel information.
- Responsive stay planning with date and guest selection.
Tech stack
Security & operations
13 Real estate & operationsMindanao Properties by Prestigious Real Estate Management ServicesProperty discovery and operations for Malaybalay and Bukidnon.
13 / Real estate & operations
Mindanao Properties by Prestigious Real Estate Management Services
A production real estate platform combining public property discovery with inquiry and viewing flows, media management, and an authenticated operations workspace for Prestigious Real Estate Management Services.
Purpose
Make property discovery more transparent while giving the real estate team a safer, structured workflow for listings and client operations.
Architecture layers
- Presentation — React and Vite public catalog plus operations workspace.
- Application — property, inquiry, viewing, notification, report, and role-aware workflows.
- Data — Supabase and PostgreSQL with private media storage.
- Infrastructure — Cloudflare Workers, RLS, Turnstile, rate limiting, and audit logs.
Inside the project
- URL-backed property catalog with pricing, availability, detail pages, and responsive inquiry and viewing flows.
- Internal operations workspace for properties, media, inquiries, viewings, reports, notifications, and role-aware workflows.