# Alfred U. Paguio Junior Software Developer based in the Philippines (UTC+8). ## About Full-stack developer focusing on application logic, refactoring, and maintaining well-structured applications. Works mainly with Laravel and React, improving existing systems through thoughtful design and clean architecture. ## Current tech stack Laravel, React, TypeScript, Python. Project-specific technologies are listed below. ## Contact and sources - Portfolio: https://alfredpaguio.pages.dev/ - Email: alfredpaguio36@gmail.com - LinkedIn: https://www.linkedin.com/in/alfredpaguio - GitHub: https://github.com/AlfredPaguio/ - Resume (PDF): https://alfredpaguio.pages.dev/resumes/AlfredPaguio_Resume.pdf ## Projects ### B&D IT Consultancy Business Website Source: https://alfredpaguio.pages.dev/projects/b-and-d-it-consultancy-business-website/ Elevated online presence and improved UX for B&D IT Consultancy site. Status: unknown Project date: 2023-07-19 Technologies: PHP, Laravel:v10, JavaScript, Bootstrap:v5, Laravel Livewire:v2, jQuery:3.6.4 - GitHub Repository: https://github.com/AlfredPaguio/BND-Info-Site **Role**: Web Developer Intern ### Project Overview: Elevated B\&D IT Consultancy's online presence by implementing strategic improvements to their information site, ensuring alignment with the company’s communication objectives. This project focused on enhancing the website’s user experience (UX) to effectively convey the company’s services, values, and culture. ### Key Contributions: * **User Experience Optimization**: Improved the overall site navigation and design to make the company's services and values more accessible, fostering better engagement with potential clients and partners. * **Strategic Communication Enhancements**: Refined the site's layout and content structure to clearly articulate B\&D IT Consultancy’s offerings, culture, and strategic objectives, helping to broaden the company’s reach and appeal. ### Impact: These improvements allowed the company to better communicate its brand identity and services, strengthening connections with a wider audience and enhancing engagement with prospective clients and partners. ### E-Commerce System Source: https://alfredpaguio.pages.dev/projects/e-commerce-system/ Developed a robust and scalable online platform for selling products. Status: unknown Project date: 2023-05-06 Technologies: PHP, Laravel:v10, JavaScript, MySQL, Bootstrap:5, Laravel Livewire:v2, jQuery:3.6.4 - GitHub Repository: https://github.com/AlfredPaguio/Livewire-Ecommerce - Company Website: https://bditconsultancy.com/ The E-commerce Development project at B\&D IT Consultancy aimed to create a robust and scalable online platform for clients to showcase and sell their products or services. I'm not sure about the current status of the project's usage within the company. For accurate details on its usage and performance, I recommend contacting the relevant department for this project. ### Ecommerce Web Scraper Source: https://alfredpaguio.pages.dev/projects/ecommerce-web-scraper/ A cross-platform review aggregator for smarter shopping. Status: archived Project date: 2023-01-05 Technologies: Python:v3.x, JavaScript, Selenium, Beautiful Soup:4, Flask:2.2.2, SQLite - GitHub Repository: https://github.com/AlfredPaguio/Cross-E-commerce-Platform-Product-Evaluation-Web-Application-Capstone ### Purpose: This project was designed to assist consumers in making informed purchasing decisions by allowing them to conveniently compare products from Shopee and Lazada on a single web page. The application provides a unified platform to view product details and customer reviews, helping users streamline their shopping experience. ### Key Features: * **User Account Management**: Users can create and manage their own accounts, allowing for personalized experiences like saving favorite products and viewing search history. * **Input Flexibility**: Users can input either product links or keywords from Shopee/Lazada to retrieve product information. * **Product Information Display**: The app displays key details such as product name, rating, price, description, images, and customer reviews from both platforms. * **Sentiment Analysis**: Customer reviews are analyzed to determine sentiment, which is presented in a visual summary, providing users with insights into overall product reception. * **Activity Tracking**: The system tracks and displays users' most-searched categories, offering a more personalized experience. * **History & Favorites**: Users can view their recent searches and save their preferred products for future reference. ### Project Highlights: * **Web Scraping**: Implemented web scraping using **headless Selenium** and **Beautiful Soup** to gather product details and reviews from Shopee and Lazada. * **Sentiment Analysis**: Integrated sentiment analysis to offer a detailed overview of customer opinions. * **Deployment**: Deployed on **Heroku**, providing a live, cloud-hosted platform for real-time product comparison. ### Benefits: * **For Shoppers**: A convenient, all-in-one platform to compare products and make better-informed purchasing decisions. * **For Sellers**: Indirect promotion of products through enhanced visibility to shoppers. * **For Developers/Researchers**: Offers insights and practical implementation for those interested in e-commerce, web scraping, and Python-based web development. ### Human Resource Information System Source: https://alfredpaguio.pages.dev/projects/human-resource-information-system/ Streamlined HR processes, including data management and payroll. Status: unknown Project date: 2023-04-26 Technologies: Python:v3.x, Flask:2.2.5, jQuery:3.5.1, JavaScript, MySQL, Bootstrap:4, Font Awesome Free:6 - GitHub Repository: https://github.com/AlfredPaguio/Human-Resources-Information-System - Company Website: https://bditconsultancy.com/ The HRIS aimed to streamline various HR processes within the company, including employee data management, payroll, and attendance tracking. The project focused on creating a user-friendly system to improve HR operations. I don't have information regarding the current status or implementation of this project within the company. ### Project Management App Source: https://alfredpaguio.pages.dev/projects/project-management-app/ A project management web app with task tracking, user assignment, and project overviews. Status: archived Project date: 2024-06-12 Technologies: PHP, Laravel:12, React:18, TypeScript, Tailwind CSS:v3, Inertia.js:2, shadcn/ui - GitHub Repository: https://github.com/AlfredPaguio/Project-Management-App ## Tech Stack * **Back-end**: [Laravel 11 (PHP)](https://laravel.com) * **Middle-end 🤔?**: [Inertia.js v2](https://inertiajs.com/) * **Front-end**: [React 18](https://18.react.dev/), [TypeScript](https://www.typescriptlang.org/) * **UI**: [TailwindCSS](https://tailwindcss.com/), [shadcn/ui](https://ui.shadcn.com/) * **shadcn/ui** included those: * [Recharts](https://recharts.org/) for data visualization * [@tanstack/react-table](https://tanstack.com/table/latest/docs/introduction) for table management * [React Hook Form](https://react-hook-form.com/) for form handling * [Zod](https://zod.dev/) for schema validation * **Icons**: [Lucide](https://lucide.dev/guide/packages/lucide-react) * **Database**: [SQLite](https://www.sqlite.org/) for the database * **Authentication**: [Laravel Breeze](https://github.com/laravel/breeze) for authentication, [spatie/laravel-permission](https://spatie.be/docs/laravel-permission/v6/introduction) for role/permission-based access control. * **Development Tools**: * [barryvdh/laravel-debugbar](https://github.com/barryvdh/laravel-debugbar) (for debugging during development) * **Image Provider**: [Picsum](https://picsum.photos/) ## Features: * **Project Management**: Create, read, update, and delete projects with sorting, filtering, and pagination options for efficient project management. * **Task Management**: Manage tasks with full CRUD functionality, including sorting, filtering, and pagination for easy task tracking. * **Task Creation Inside Projects**: Add new tasks directly within specific projects for better task organization. * **User Assignment to Tasks**: Assign team members to tasks, enhancing collaboration and responsibility tracking. * **Personal Task View**: Users can view tasks specifically assigned to them, improving individual task management. * **User Management**: Create and manage users, edit profile information, assign roles, and control permissions. * **Role and Permission Based Access Control**: Different roles and permissions with different access levels to manage tasks and projects. * **Search and Filter**: Search and filter projects, tasks, roles, and permissions based on various criteria. * **Dashboard Overview**: A centralized dashboard showing key project and task metrics, providing an at-a-glance view of progress and status. ## Purpose: This project management app is designed to streamline task and project workflows, offering robust tools for creating, managing, and tracking projects and tasks. The app supports team collaboration through user assignment and provides an intuitive dashboard for real-time insights. ### Simple React Calculator Web Application Source: https://alfredpaguio.pages.dev/projects/react-calculator/ A calculator app built with React, designed to perform basic math operations without relying on the built-in `eval()` function in JavaScript. Status: archived Project date: 2024-01-14 Technologies: TypeScript, React:18, Tailwind CSS:v3 - GitHub Repository: https://github.com/AlfredPaguio/react-ts-calculator - Live Demo: https://alfredpaguio.github.io/react-ts-calculator/ ### Project Overview: The project intentionally avoids using the built-in eval() function in JavaScript, providing a challenge and a more controlled approach to expression evaluation. Users can perform basic arithmetic calculations using this intuitive and responsive calculator. ### Key Features: * **Custom Expression Evaluation**: Instead of relying on JavaScript’s built-in `eval()` function, this project takes a more controlled and secure approach to arithmetic expression evaluation, offering a unique development challenge. * **Responsive Design**: The user interface, styled with **Tailwind CSS**, adapts seamlessly to different screen sizes, ensuring accessibility on both desktop and mobile devices. * **Fast Build Process**: Utilized **Vite** for fast builds and optimized performance, ensuring a smooth development experience and quick load times for users. ### Simple Astro Content Editor Source: https://alfredpaguio.pages.dev/projects/simple-astro-content-editor/ A browser-based tool I built to turn Astro content collection frontmatter into interactive, schema-aware forms and live preview. Status: maintenance Project date: 2025-03-15 Technologies: React:19, TypeScript, Tailwind CSS:v4, shadcn/ui - Live Demo: https://simple-astro-editor.pages.dev/ - Source Code: https://github.com/AlfredPaguio/simple-astro-editor ## Overview Astro Content Editor is a browser-based tool I built to make editing Astro content collections easier. Instead of manually typing YAML frontmatter, the editor reads your `content.config.ts` directly in the browser, parses the Zod schemas, and generates a typed form for every field. ### Demo descriptions The two short demos have no spoken audio. You can read the descriptions below without playing them. - **Demo 1:** The editor displays a calculator project's Markdown alongside its frontmatter form. The form includes the title, summary, date, status, and technology stack, so structured metadata can be edited separately from the body text. - **Demo 2:** The editor displays this project's Markdown and its rendered preview. The preview presents the same headings and paragraphs as a readable page alongside the source. ## Problem It Solves In my own Astro projects, I often forgot fields or made mistakes in frontmatter. Editing YAML manually in a code editor-without validation, autocomplete, or immediate feedback-was tedious and error-prone, especially for larger or nested schemas. This project started as a personal tool to address this workflow. It reads your `content.config.ts` directly in the browser, parses the Zod schemas, and generates a typed form for every field. Dates become date pickers, enums become dropdowns, arrays become dynamic lists, and nested objects render as sub-forms. While it was built primarily for my own use, I deployed it so others working with [Astro content collections](https://docs.astro.build/en/guides/content-collections/) could benefit from a simpler, schema-aware editing experience-without needing a build step, server, or extra plugins. ## Key Features - **Schema-aware form generation** - loads `content.config.ts` and generates a form from Zod schemas using Zod v4's `toJSONSchema` - **File System Access API** - reads and writes files directly to disk with no upload/download roundtrip - **Split-pane editor** - resizable, draggable Markdown editor and live preview side by side - **Dual sidebar layout** - file tree and collections on the left, frontmatter form on the right, both independently togglable - **Keyboard shortcuts** - `Cmd/Ctrl+B` for the file and collection sidebar, `Alt+B` for the frontmatter sidebar ## What I Learned Building this project pushed me into parts of the web platform I hadn't used deeply before. The File System Access API is surprisingly capable - writable streams, directory traversal, and permission persistence all work well in Chromium browsers. The most challenging part was sandboxed evaluation of Astro content collection configs directly in the browser. Since these configs are usually written in TypeScript and depend on Astro-specific modules, I used esbuild's WebAssembly build to transpile them into CommonJS at runtime, allowing me to intercept imports via a custom `require` implementation. I mocked key Astro modules like astro:content and injected Zod to emulate Astro's runtime behavior, then executed the result inside a controlled sandbox using new Function. This allowed me to safely extract schema definitions, resolve dynamic schema functions, and [convert Zod schemas into JSON Schema](https://zod.dev/json-schema?id=ztojsonschema) for use in a dynamic form renderer. The shadcn sidebar layout also took significant trial-and-error. I adapted a community solution from [inj-src](https://github.com/shadcn-ui/ui/issues/5651#issuecomment-3715137601) to achieve this behavior. I learned how to work with `SidebarProvider` context scoping to support two independently controllable sidebars that overlay content without layout shift. ## Technical Highlights The frontmatter form is fully recursive - it handles nested objects and arrays of objects by rendering sub-forms, with each field component responsible only for its own type. The schema evaluator categorizes every key in a file as **known** (defined in the schema), **inferred** (present in the file but not the schema), or **unknown** (neither), so no data is ever silently dropped when saving. ## Shout-out / Inspiration This project was inspired by [Astro Editor](https://astroeditor.danny.is) by Danny Smith, a minimalist markdown editor for Astro content collections. Danny's editor focuses on an advanced writing experience with features like MDX component insertion, focus mode, and live image handling. While this project doesn't include all of those features, it shares the same core philosophy: making content editing simpler and schema-aware. My version is browser-based, and primarily intended for editing frontmatter safely and interactively without a build step, server, or extra plugins. Big thanks to Danny for the inspiration, his work helped shape the idea and motivated me to create a tool for my own workflow. ### URL Shortener Source: https://alfredpaguio.pages.dev/projects/url-shortener/ A simple URL shortener project to practice and understand the workings of RESTful APIs. Status: archived Project date: 2024-03-08 Technologies: React:18, TypeScript, JavaScript, Vite, Express.js, Bun, Tailwind CSS:v3 - GitHub Repository: https://github.com/AlfredPaguio/URL-Shortener This project is a simple and straightforward URL shortener service that allows you to create short links quickly and easily. With this project, you can shorten long URLs into concise, shareable links that are perfect for social media, email, and other online platforms. ## Features * **Simple Interface**: provides an intuitive user interface for creating short links in just a few clicks. * **Randomized Short URLs**: generates unique, randomized 13-character short URLs using nanoid for each long URL you provide, ensuring their uniqueness and security. * **Click Count Tracking**: Keep track of the number of clicks on your short links. ## Scope This export contains the public portfolio profile and project descriptions. The linked PDF resume is a separate source; its contents are not included here. Missing information should be treated as unknown.