Portfolio — Version III

Folio 01

The volume

Aaron
Mercado

A builder who turns ideas into working solutions through technology.

Manila · Remoteiii

Chapter · Introduction

Folio 02

I build software that helps businesses grow and succeed.

FULL-STACK DEVELOPER

DEVOPS

MOBILE DEVELOPER

WEB DEVELOPER

INFRASTRUCTURE ENTHUSIAST

No. 01 — The Maker

Folio 03
Aaron Mercado
Aaron Mercado

My Journey

2+ years building software — mostly freelancing, with recent corporate experience delivering full-stack applications.

Manila · Remote / Local01

Chapter · Beliefs

Folio 04

I'm a full stack developer who builds and ships production systems end to end, from database design and APIs to deployment. I specialize in React, Next.js, TypeScript, Node.js, and Python (FastAPI), with experience in cloud infrastructure like DigitalOcean, Vercel, Supabase, and Firebase, plus Discord alerts for commits and deployments. Outside my day job, I mentor student capstone teams and enjoy scoping software solutions for clients' business problems.

Build Log — selected work

  • FRONTEND - REACT & NEXT.JS83%
  • BACKEND - NODE.JS & FASTAPI85%
  • MOBILE - REACT NATIVE/EXPO & KOTLIN81%
  • ARCHITECTURE - DOCKER & CI/CD73%

Loading contributions…

No. 02 — The Experience

Folio 06

Work log

Roles, teams, and what I shipped.

  • Maintain and extend a high-volume Inventory & Ordering System processing millions of material requests and millions of PHP in monthly transactions, shipping features and resolving production bugs across staging and live environments.
  • Led end-to-end development of a new Asset Management system, from the ground up through production: built the application, engineered a cross-database integration that syncs employee and asset data with the HRIS, and owned the DigitalOcean deployment infrastructure (Docker, Nginx reverse proxy, server firewall, Discord commit/deploy alerts).
  • Lead interns and run requirement meetings, feature planning, and technical decision-making, tracking work in Trello and enforcing a Git branching workflow so the team ships without stepping on each other’s code.
  • Partnered with Accounting and executives to reconcile stock discrepancies, then imported and validated [100,000+] stock records into the system’s hub, establishing the verified beginning balance for live inventory.
  • Imported and validated a full year of historical sales data (2025 to 2026) into the Key Accounts Sales module, auditing records and resolving discrepancies to keep downstream reports accurate.
  • Architected the refactor of the Inventory & Ordering System and HRIS from manual, AI-generated SQL workflows to a layered architecture (Repository, Service, Controller, Route) with Redux state management and version-controlled migrations, making deployments repeatable and the codebase easier to extend.
  • Developed a full-stack e-commerce website for Deepsky Nation, a lifestyle brand selling T-shirts, apparel, and branded merchandise to customers online.
  • Built a responsive product catalog with category filtering, product detail pages, image galleries, and size/variant selection so customers can browse and shop across devices.
  • Implemented shopping cart and checkout flows, including order summary, customer information capture, and order confirmation for a smooth end-to-end purchase experience.
  • Designed and developed an admin-facing interface for managing products, inventory, pricing, and order status, giving the client control over store operations without technical support.
  • Integrated the storefront with the brand's social presence and marketing channels, aligning the site experience with Deepsky Nation's identity and Facebook-based customer engagement.
  • Delivered the project on a contract/freelance basis, working remotely with the client from requirements gathering through deployment, iteration, and post-launch support.
  • Responsible for the maintenance and enhancement of a Human Resource Information System (HRIS) application designed for efficient employee management. The application is built using PHP Laravel for backend operations and Next.js for the frontend, providing a seamless and responsive user experience. The system is containerized using Docker, ensuring consistent deployment across development, testing, and production environments. Key responsibilities include managing employee records, attendance, payroll integrations, and role-based access controls, while optimizing performance, ensuring system security, and implementing feature updates.
  • Collaborated with a development team to engineer an inventory management system using FastAPI and Next.js with Shadcn UI, specifically developing backend APIs and frontend integrations for bulk CSV uploads, automated report exports, and a dynamic query builder with functional filtering
  • Developed a secure login module for a Human Resource Information System (HRIS) using Kotlin and Jetpack Compose, with Room Database for local storage and Bcrypt password hashing and salting for secure authentication.
  • Developed and maintained backend APIs using Node.js, Express, and TypeScript in a startup environment Integrated backend services with frontend via React Query to enable real-time, dynamic data flow Collaborated with React developers to ensure seamless UX through efficient API consumption Contributed to schema design, API documentation, and cloud deployment of backend services
  • Gained hands-on experience in a fast-paced internship environment, using Git for collaborative version control. Partnered with fellow interns to implement a standardized branching strategy, ensuring code quality and consistency across multiple concurrent workstreams
  • Freelance developer specializing in student capstone prototypes, delivering end-to-end web and mobile (Android) solutions — frontend, backend, databases, APIs, and IoT hardware integration.
  • Guided 4 solo capstone groups (13 students) and 3 collaborative ( with my mentor) groups (9 students) through full project development and defense — 100% success rate across all 22 students.
  • Projects: AI-powered Rental Management App (FastAPI, Kotlin, Gemini, FAISS, Google Maps), Smart Pig IoT system (ESP32, Firebase, Android, Gemini AI), Smart Fire Monitoring IoT (ESP32, Android, FastAPI), IcomDeaf Sign language web app (FastAPI, Mediapipe, OpenCV), and an E-Learning Game App published on Google Play.
  • Supported development of mobile features and debugging Worked with Kotlin, Android Studio, and UI frameworks
  • Trained in Git and GitHub under senior mentorship, with a focus on professional-grade version control, code integrity, and collaborative workflows
  • Delivered customer service in a fast-paced environment Managed food preparation and order fulfillment Developed teamwork, communication, and time management skillss

No. 03 — The Projects

Folio 07

Selected work

Products, prototypes, and shipped systems.

  • B1G Fuel — RBAC Warehouse, Hub Ops & Order Booking

    B1G Corporation · NDA

    Led the architecture and end-to-end development of a working proposal prototype for B1G Corporation's multi-tenant fuel warehouse and hub operations system — covering companies, hubs/facilities, suppliers, purchase orders and receiving, inventory with stock movements, material requests between warehouses and hubs, and a consumer booking flow so clients can book orders. Built for internal proposal and workflow demonstration only; a third-party company will provide a separate production system. Designed the layered RBAC and dashboard permission model: global Super Admin vs company-scoped roles, page-level dashboard grants, and action permissions (view/add/edit/delete) with all / company / own scopes — so Super Admin configures role templates while company supervisors can provision staff and assign per-person dashboard subsets without rewriting the shared role.

    Next.jsTypeScriptReduxTailwind CSS+5
  • Asset Management System

    B1G Corporation · NDA

    Led end-to-end development of B1G Corporation's Asset Management System from the ground up through production — covering the full asset lifecycle from request and issuance to transfer, return, repair, and disposal. Built multi-step approval workflows (Department Head → Operations Manager → Head of Operations), procurement flows (asset needs → purchase requests → purchase orders → receiving), kit/BOM inventory, QR-based physical counts, Excel bulk import, role-based access, and a cross-database HRIS sync for employee and asset data. Owned DigitalOcean deployment with Docker, Nginx, and Discord commit/deploy alerts.

    Next.jsTypeScriptReduxTailwind CSS+4
  • 03

    Smart Pig - 2nd Overall, Best IT Capstone Project (2026)

    Personal

    A mobile and IoT-based system that enables farmers to track individual pigs using QR codes. Integrated with ESP32, DHT22, and water level sensors, the system monitors temperature and humidity, provides real-time mobile notifications when thresholds are exceeded, and allows farmers to manually activate a water sprinkler through the mobile app. The platform also includes an in-app chatbot for support. Video available — click the card to view the demo.

    KotlinXMLFirebase RTDBPython FastAPI+6
  • MuntiRent: Finder

    Side Project

    Munti Rent: Finder is a mobile app that connects landlords and tenants, making it easy to post, find, and rent properties. It features an AI-powered search, an instant chatbot, video call for virtual viewings, and location sharing in chat for easier meet-ups. Video available — click the card to view the demo.

    KotlinXMLPython (Fast API)Gemini Ai+4
  • Smart Fire Monitoring - Presentend in Research Colloquium (2026)

    Side Project

    Smart AI-Based Fire Monitoring – A mobile app connected to IoT sensors that monitors fire, temperature, smoke, and humidity. It sends instant notifications via FCM when hazards are detected, triggers AI voice alerts, and includes a chatbot for user interaction.

    JavaXMLPythonESP32+6
  • Icom Deaf

    Side Project

    A real-time sign language practice platform where students can learn and practice using AI-powered hand gesture recognition. Teachers can upload learning materials, and students can follow along and practice interactively.

    Python (FastApi)NumpyOpenCVHTML5+3
  • E-Learning App - Presented in Research Conference (2025)

    Side Project

    An educational app designed for children 8 years and older to learn the alphabet. Kids can practice tracing letters, improving their writing skills and letter recognition through interactive exercises. The app gamifies learning with stages, rewarding progress with stars for completed tasks. Available on the Play Store for easy access.

    JavaXmlCanvaPlaystore
  • EcoConnect

    Personal

    EcoConnect is an IoT-integrated mobile application designed for smart farming. It enables users to manage plants, monitor farm environmental conditions, remotely control water pumps, view pump activity logs, and receive AI-powered suggestions through a chatbot. The system also includes an admin panel for user registration and ESP32 device management, making farm operations smarter and more efficient.

    KotlinJetpack ComposeRoom DatabaseMUI3+12
  • 09

    AI Commission Marketer

    Personal

    An automated n8n workflow leveraging OpenAI to dynamically generate conversion-focused promotional posts and auto-publish them directly to my marketing channels.

    n8nTelegramOpenAI
  • E-Commerce Website

    Deepsky · NDA

    A full-stack e-commerce website for Deepsky Nation, a lifestyle brand selling T-shirts, apparel, and branded merchandise to customers online.

    Next.jsReduxShadCN UITailwind CSS+4
  • Voice Revive Ai

    Personal

    I built this app to help stroke patients regain their voice. Many stroke survivors can speak, but not always clearly — this app lets them practice, one word at a time, and rebuild their confidence.

    Next.jsReduxShadCN UITailwind CSS+2
  • Event Management System

    Fetti Creative Solution · NDA

    A web application built for creative event management, where users can organize and oversee their events end to end. The platform supports event planning, bookings, and event speech management, giving organizers a single place to coordinate schedules, content, and participant details.

    Next.jsReact QueryTailwindShadCN UI+3
  • Asset Management System

    FMC Research Solution Inc. · NDA

    A web app that lets admins/managers assign, transfer, and track company assets across employees, locations, and other companies. It includes a centralized inventory with pricing, warranty, and end-of-life tracking, lifecycle status badges (Active, Out of Warranty, Phased Out), asset categorization, employee/facility administration, a full activity history log, and a dashboard with trend charts and analytics for monitoring asset usage and distribution.

    Next.jsReduxShadCN UITailwind CSS+2
  • Inventory & Ordering System

    B1G Corporation · NDA

    Maintained and enhanced B1G Corporation's multi-tenant Inventory & Ordering System, which processes millions of pesos in monthly transactions — from stock allocation to agent orders, remittance, and finance approval. Key features we implemented: Consignment — consignee orders only appear in analytics after payment (not when placed), and each entry is clickable to show when that consignment order was created. AR (Accounts Receivable) — payment status is tracked per product line, not the whole order, so unpaid items stay visible until settled. FSN — products are classified as Fast, Slow, or Non-moving so the sales team can plan stock and promotions from real movement data.

    ViteSupabaseTailwindVercel
  • Human Resource Information System

    B1G Corporation · NDA

    Maintained and enhanced B1G Corporation's existing Human Resource Information System (HRIS), developing a new attendance data export feature (Excel format) used by HR for manual upload into the bank's payroll system, along with ongoing bug fixes to improve system reliability.

    ViteSupabaseTailwindVercel
  • DevHive

    Personal

    Free open-source starter templates and project structures that give developers a solid foundation for building modern applications quickly.

    Next.jsTailwindShadCN UITypeScript+1
  • Templato

    Personal

    A free open-source hub of starter templates and project structures I built to help beginners get a clear foundation before they start coding. Instead of guessing folder layouts, boilerplate, and setup, developers can grab a ready structure and focus on building — no more confusion on where to begin.

    Next.jsTailwindShadCN UITypeScript+3

No. 04 — The Certificates

Folio 08

Credentials

Proof of work, filed in the margins.

  • Best Capstone Awardee

    Research Team Lead

    June 2026

  • Research Colloquium 2026

    Research Team Lead

    June 2026

  • FMC Research Solution Inc.

    Full Stack Developer

    December 2025 to April 2026

  • Fetti

    Full Stack Web Developer

    September 2025 to April 2026

  • Certicode

    Android/Mobile Developer

    September 2025 to January 2026

No. 05 — The Collections

Folio 09

Tech stack

Tools I reach for when building.

  • Expo
  • React Native
  • Java
  • Kotlin
  • XML
  • Room Database
  • Jetpack Compose
  • Next.js
  • Redux
  • SHADCN
  • Typescript
  • Tailwind
  • Material UI
  • Javascript
  • Python (FastAPI)
  • NodeJS (Express)
  • Firebase
  • PHP (Laravel)
  • MySQL
  • PostgreSQL
  • Supabase
  • Room Database
  • Firebase RTDB
  • Firebase Firestore
  • ESP32
  • DHT22 Temp & Humid Sensor
  • MQ2 Smoke Sensor
  • KYS026 Flame Sensor
  • HW-038 Water Level
  • Water pump motor
  • Resistor
  • Soil Moisture
  • Swagger
  • Postman
  • Git
  • GitHub
  • BitBucket
  • Android Studio
  • Visual Studio
  • Arduino IDE
  • DBeaver
  • DBgine
  • Docker
  • Fork
  • Vercel
  • Render
  • Digital Ocean
  • Supabase
  • Firebase

No. 06 — The Services

Folio 10

What I do

Disciplines, filed and ready.

Click a row to expand.

Complete system development from server to client, including database design and deployment.

Cloud infrastructure setup, containerization, CI/CD pipelines, and automated deployment.

Architecture and strategic advice for startups, students, businesses, and hobbyists.

No. 06 — The Contact

Folio 09

Dear Visitor,

Have a project in mind?

Drop me a line and I'll write back shortly.

Correspondence06