Author: danjsmith3@gmail.com

  • Stock Tracker App: Real-Time Dealer Inventory Dashboard

    Stock Tracker App: Real-Time Dealer Inventory Dashboard

    Full-Stack Internal Tool • Built for PSC Motorsports

    I designed and deployed a live, real-time stock visibility platform for PSC Motorsports’ wholesale dealer network. Over 800 SKUs needed to be instantly accessible to multiple dealers 24/7 — without granting access to the internal ERP system.

    In under 48 hours, I shipped a production-ready, zero-maintenance web dashboard that replaced twice-weekly emailed spreadsheets.

    Key Technologies • React 18 + TypeScript – Fast, modern frontend • Vite – Lightning-fast builds and hot reload • Bootstrap 5 + React-Toastify – Clean, responsive UI with instant feedback • json-server + custom Node.js endpoints – Full REST API from a single db.json file • basic-ftp + PapaParse – One-click CSV generation and automated FTP upload • Render.com (Static Site + Web Service) – Free, auto-deployed hosting with zero server management

    Features • Real-time searchable and sortable inventory table (800+ parts) • Inline editing of stock quantities with instant persistence • Configurable FTP server management stored securely in localStorage • One-click CSV export and automated upload to up to 4 dealer FTP servers simultaneously • Mobile-responsive design – dealers can check stock from anywhere • Fully deployed and self-updating on every git push • End-to-End Development – Solo built: database design, API routes, frontend logic, UX, deployment pipeline

    What I Learned This project pushed my ability to deliver a complete, client-ready full-stack solution at high speed. I mastered monorepo-style deployment quirks on Render, built a custom FTP automation flow that works reliably in production, and created a buttery-smooth React data table experience with debounce, pagination, and live search — all while keeping the codebase clean and maintainable.

    Summary The Stock Tracker App eliminated hours of manual work each week and gave PSC’s dealers instant, accurate inventory visibility. It’s now the single source of truth for wholesale stock levels — running 24/7 for $0/month in hosting costs.

    A perfect example of building fast, functional, and beautiful tools that solve real business problems on day one.

  • PSC Registration App: FullStack Contest Solution

    PSC Registration App: FullStack Contest Solution

    I built the PSC Registration App for my employer, PSC, to support a promotional contest initiative. This streamlined full-stack web application enabled users to register and log in for a giveaway, where PSC awarded a $4,500 steering kit to one lucky winner.

    To explore the backend functionality, you can access the admin panel at /admin using the credentials:
    Username: admin
    Password: Password!


    Key Technologies

    • React – For a fast, interactive UI
    • Material UI (MUI) – For a polished, accessible design
    • Node.js & Express – Backend API and server logic
    • Prisma – Type-safe database ORM
    • PostgreSQL – Secure relational database
    • TypeScript – Type safety across the stack

    Features

    • Easy Registration & Login – Quick signup and login for contest entry, with streamlined authentication suited to the event’s short timeline
    • Modern UI – Clean, mobile-responsive design using Material UI for an intuitive user experience
    • Admin Demo – View and manage contest entries through the /admin dashboard (see credentials above)
    • End-to-End Development – Personally handled database modeling, backend logic, frontend design, and UX

    What I Learned

    This project sharpened my full-stack development skills using modern JavaScript/TypeScript tooling. I deepened my experience with React and MUI on the frontend, Prisma and PostgreSQL for robust data handling, and Node.js/Express for building secure backend APIs. It also taught me how to deliver a production-ready solution under tight business deadlines.


    Summary

    The PSC Registration App demonstrates my ability to design, build, and deploy a full-stack, user-focused application that meets real-world business goals. Created for PSC’s successful giveaway campaign, it highlights my skills in React, MUI, Node.js, Express, Prisma, and PostgreSQL—while providing an accessible demo for backend functionality through the /admin route.