D&P Systems javelin banner with Design • Build • Optimize tagline

Lucena City, Quezon · Business Systems Developer

Turn scattered bookings, orders, and follow-ups into systems your team can track.

I help small businesses replace chat-based tracking, spreadsheets, notebooks, and manual follow-ups with web systems for booking, queue, seller, order, admin, and dashboard workflows — backed by Supabase and tested on real devices.

Booking SystemsOrder TrackingAdmin DashboardsSeller ToolsCustomer RecordsStaff AccessMobile-Friendly ScreensTechnical Case Studies
Manual work made trackableBookings, orders, queues, reviews, dashboards
Working portfolio proofMarketplace + QueuePoint SaaS MVP
Protected records and mobile useSafer access, working data rules, and real-device QA

Who I Help

From scattered work to visible operations.

Best fit: small businesses already handling bookings, orders, customer updates, staff assignments, stock, or follow-ups — but still relying on chats, spreadsheets, notebooks, or memory to know what is happening.

Cleaner daily tracking

Turn bookings, orders, queues, and follow-ups into records your team can see and update.

Safer user access

Give owners, staff, sellers, and customers the right views so they only work with records meant for them.

Better owner visibility

Show pending work, completed activity, stock concerns, customer flow, and bottlenecks in one place.

Common Client Problems

The problems I look for first.

Broken access, messy records, checkout mistakes, missing dashboards, mobile friction, and processes that depend too much on manual checking.

Broken login or onboarding

Fix auth-state problems, missing profile records, failed onboarding, and pages that break after login.

Messy database tables

Review table structure, relationships, foreign keys, naming, and whether the database matches the real process.

Unsafe access rules

Plan record access so buyers, sellers, staff, and admins only see or change the right information.

Inventory and checkout bugs

Improve stock checks, cart validation, order creation, seller grouping, and checkout failure handling.

Forms that do not save

Debug insert/update errors, validation gaps, wrong selectors, missing fields, and silent JavaScript failures.

Deployment and config issues

Check environment variables, Supabase links, local/cloud differences, CLI issues, and production cleanup.

Services Offered

Focused ways I can help.

Start with one painful process, then build the backend, screens, access rules, and deployment path needed to make it usable.

Database & App Backend Setup

Tables, relationships, login flow, file storage, and app connections for real business records.

User Access & Record Protection

Buyer, seller, staff, owner, and admin access planned around who should control each record.

Deployment & Setup Checks

Check project settings, app links, environment variables, local/cloud differences, and Vercel deployment notes.

Interactive Screens & Dashboards

Forms, dashboards, filters, status updates, cart actions, and app screens using HTML/CSS/vanilla JS.

Marketplace & Seller Tools

Seller onboarding, products, orders, stock checks, tracking, and moderated reviews/ratings.

Debugging & Stabilization

Console debugging, error handling, rollback thinking, mobile checks, and production-readiness cleanup.

Freelance Starting Points

Start with one workflow, not a risky big-bang project.

A good first engagement is a review, fix sprint, or small MVP around one process: booking, order tracking, seller tools, access rules, or a messy prototype that needs to become reliable.

Workflow Review & Supabase Health Check

A focused review for an existing app, database, or prototype. I look at the business process, data structure, login flow, deployment setup, console errors, and mobile behavior, then return a practical fix plan.

  • Good first step before a larger build.
  • Useful for messy prototypes or stuck Supabase projects.

Booking, Queue, or Internal Dashboard MVP

A small-business operations system based on your actual daily process: appointments, queues, services, staff, status updates, simple owner dashboards, and customer-facing tracking.

  • Best for clinics, service shops, repair desks, and appointment-heavy workflows.
  • Can start as a guided pilot before expanding features.

Marketplace, Seller Tool, or Admin Panel Build

Seller dashboards, product management, order tracking, review workflows, stock checks, buyer lookup, and admin tools backed by clear data rules and practical JavaScript screens.

  • Best for lightweight commerce and operations workflows.
  • Focuses on working data rules, not decorative screens alone.

Good Fit

Send the process. I will help turn it into a system.

I am strongest when the work involves records, permissions, status changes, owner/staff views, mobile usability, and processes currently handled through chats, spreadsheets, notebooks, or memory.

What to send

Screenshots, table notes, current URLs, error messages, sample forms, or a plain-language description of how the business works.

What I return

A practical build or fix plan, then working Supabase-backed screens with safer data access, clearer workflows, and mobile behavior checks.

Best first conversation

“Here is how we currently handle bookings/orders/customers. Can you help make this workflow cleaner and trackable?”

Proof Through Working Systems

Proof that the process can become a working system.

Marketplace proves commerce operations: seller products, orders, stock, tracking, and reviews. QueuePoint proves appointment operations: branches, services, staff, queues, settings, and public/customer workflows.

Marketplace seller inventory dashboard preview

Project 1 · Marketplace

Multi-Seller Marketplace Portfolio Build

Portfolio demoFinal polish stage

Small sellers need product, stock, order, tracking, and review workflows that do not depend on manual checking after every sale.

System builtGuest checkout, seller dashboard, product CRUD, seller-specific orders, tracking, and moderated ratings/reviews.
ProofSafer checkout, seller-owned records, stock rechecking, approved reviews, and Android QA; technical details are in the case study.
Workflow proven Product → Cart → Checkout → Seller order → Stock deduction → Buyer tracking → Moderated review/rating.

Try this demo path

Browse products, add to cart, checkout as guest, track the order, leave a review/rating, then inspect the seller-side workflow.

  • Checkout creates seller-specific orders instead of one confused mixed-seller transaction.
  • Seller dashboard handles product, order, stock, and review/comment workflow.
  • Real-device Android QA covered landscape, keyboard, and Back behavior.
Supabase BackendDatabase LogicAccess RulesVanilla JSMobile QA

Why it matters

  • Reduces manual order and stock checking for small seller operations.
  • Separates buyer flow, seller records, and public tracking into clear responsibilities.
  • Shows moderated customer feedback instead of uncontrolled public comments.
QueuePoint dashboard preview with branch selector

Project 2 · QueuePoint

QueuePoint Appointment & Queue SaaS MVP

Working MVPGuided-pilot ready

Appointment-heavy businesses need a simple way to manage public booking, branch/location choices, staff/service setup, queue movement, and customer tracking.

System builtPublic booking, branch-aware dashboard modules, appointments, queue status, services, staff, and settings.
ProofBranch-separated records, protected owner/staff screens, edit locks, draft guards, and mobile navigation safety; technical details are in the case study.
Workflow proven Public booking → Appointment code → Customer tracking → Staff update → Queue movement → Owner dashboard.

Try this demo path

Choose a branch/location, book an appointment, save the code, track it, then test dashboard status and queue movement.

  • Public booking supports branch/location selection and appointment-code tracking.
  • Dashboard modules reload by selected branch: services, staff, settings, appointments, queue, and business data.
  • Mobile QA covered sticky nav, Android Back trapping, edit locks, draft guards, landscape keyboard behavior, and real-phone use.
Supabase LoginAccess RulesBranch IsolationVanilla JSVercel

Why it matters

  • Gives front-desk staff a clearer view of today’s appointments and queue movement.
  • Separates public customer booking from protected owner/staff dashboard work.
  • Shows SaaS-style branch isolation without exposing one business location’s records to another.

Where This Applies

The same approach works across different business operations.

The examples can apply to booking, seller, internal admin, hotel, inventory, and service workflows: organize the records, define who can access them, show the status, and make the daily work easier to track.

Booking and queue operations

Appointments, queue status, services, staff, public tracking, and owner/front-desk dashboards.

Commerce and seller operations

Products, stock, orders, checkout, buyer tracking, customer reviews, and seller dashboards.

Internal business tools

Admin panels, customer records, approvals, reports, status changes, and protected team access.

Why I Think This Way

Systems-analysis habits behind modern implementation.

My earlier work in systems analysis, programming, application support, and business software still shapes how I build today: start with the process, identify the records, protect access, handle exceptions, then build the screens around real use.

Business workflow first

I start by understanding how the business actually operates: who enters data, who owns records, what changes status, and where mistakes can cost time or money.

Record ownership and user access

My builds focus on who owns each record, who should see it, who can change it, and how to keep customer and business data separated safely.

Usability beyond desktop screens

I test real mobile behavior: sticky navigation, Android Back, keyboard layouts, landscape screens, form safety, and user-error recovery.

Technical Proof

Technical proof behind the business promise.

This is where the technical proof lives. The homepage explains the business value; these tools show how the systems are protected, connected, deployed, and tested.

Backend / Database

Supabase, PostgreSQL, SQL, RLS policies, RPC functions, Auth, Storage-ready architecture, table relationships, and data ownership rules.

Frontend / Integration

HTML, CSS, vanilla JavaScript, ES modules, DOM workflows, form validation, CRUD screens, responsive layouts, and dashboard UI logic.

Workflow / Deployment

GitHub, Vercel, environment variables, Chrome DevTools, Android remote debugging, QA testing, production cleanup, and technical documentation.

Partner-Supported Services

Optional collaborator support, kept in the right lane.

My core role is building practical business systems. When a project also needs branding, visual content, or app prototype support, D & P Systems can coordinate trusted collaborators while keeping one clear technical point of contact.

Core service: software systems. Optional support: collaborator-assisted design, video, branding, or prototype assets when the project needs them.

Cross-Platform Prototype Support

Mobile or desktop app prototype support can be coordinated through trusted collaborators when a project needs to test an app idea alongside a Supabase-backed workflow.

Video & Visual Content Support

Video and presentation-ready visual assets can be coordinated through trusted strategic collaborators when the software project also needs client-facing materials.

Graphic & Brand Design Support

Logo concepts, basic brand visuals, social media graphics, and presentation-ready design assets can be supported through trusted collaborators when needed.

Real-Device QA & DevTools

Mobile QA that protects real customer and staff use.

The projects were tested on real Android devices so key actions still work when screens are small, the keyboard is open, navigation gets tricky, or users press Back at the wrong time.

Real-phone testing Checked live pages on Android, not only desktop resizing
Back-button safety Reduced confusing exits and navigation loops
Keyboard and landscape Checked forms when space is tight
Android Chrome landscape test showing the order tracking page and order result
Track page landscape validation Confirmed that the order tracking page remained scrollable and usable on a real phone in landscape mode.
Android Chrome landscape test showing the cart and buyer information form
Cart and checkout landscape QA Tested buyer information, cart behavior, empty-cart navigation, checkout redirects, and Android Back behavior.
Android Chrome landscape test showing review form with the on-screen keyboard open
Keyboard and review-form usability Verified that the completed-order review form remained usable even with the mobile keyboard consuming most of the landscape screen.

Navigation hardening

Checkout, tracking, empty-cart return, and dashboard views were adjusted to avoid confusing Android Back loops.

Keyboard-heavy screens

Cart, tracking, and review screens were checked in landscape with the keyboard open, then adjusted for natural scrolling.

Contact-link judgment

Unreliable contact channels were hidden instead of being shown as broken buyer options.

Database Proof

Database structure behind the visible screens.

The marketplace has real relationships behind the screens: sellers, buyers, products, orders, inventory, reviews, ratings, and contact data.

Supabase schema diagram for marketplace app
Supabase table diagram used as a simple database relationship proof image.

Record relationships

Products belong to sellers, orders connect buyers and sellers, and reviews/ratings attach to real marketplace activity.

Stock and checkout protection

Stock, product status, order totals, and checkout validation are handled as business rules, not just screen labels.

Access planning

The schema supports RLS, seller ownership checks, and safer role-based data access.

Workflow Review

Need a practical business system built around your actual workflow?

Send your current process, screenshots, database notes, or errors. I can help turn manual work into a clearer system for bookings, orders, dashboards, tracking, and daily operations.

Request a workflow review

Contact

Send the process you want to make trackable.

Describe the business process, dashboard, booking flow, marketplace, or internal tool you need. Screenshots, table notes, database structure, and console errors are welcome.

This form opens your email app. If it does not open, send your workflow brief directly to j3ba508@gmail.com. A Supabase-backed inquiry form is a planned portfolio upgrade.