Freelance

Garment Inventory Management

TypeScriptBunElysiaNext.jsDrizzleZustandShadcn/UIForgejoAivenPostgreSQLBiomeScalarDev ContainersWeb PushRenovateLefthookSonarQube

Served as Technical Project Consultant for a medium-scale garment inventory system deployed in client's retailers and warehouses. Led requirements analysis, sprint planning, technical architecture, team coordination, and code quality assurance, including the development of a secure custom kiosk OS for store terminals.

Key Responsibilities:

  • Translated client requirements into technical specifications and managed sprint execution.
  • Designed database schema, enforced strict typing (zero any usage), and maintained code quality via reviews and Git hooks.
  • Established CI/CD pipelines for automated testing and deployment.
  • Developed a immutable kiosk OS with encrypted storage, BIOS-level passwords, and no local data persistence to prevent tampering.

Features:

  • User, retailer, product, and bundle CRUD operations.
  • Retailer-specific transactions with barcode scanning and dynamic price adjustment.
  • Automatic bundle detection and low-stock notifications.
  • Sales trend analysis and database archiving for performance.

Technology Stack:

  • Development Tools
    • Dev Containers: Provides a consistent and isolated development environment.
    • Bun: Supercharged runtime environment.
    • Biome: All-in-one development toolchain such as analyzer, formatter, and linter.
    • Scalar: API documentation that automatically generated by Elysia Swagger plugin.
    • Lefthook: Runs Git hooks for code quality checks and enforces commit message conventions before CI/CD verification.
    • SonarQube: Code quality and security analysis tool to identify code smells, vulnerabilities, and bugs.
    • Renovate: Automates dependency updates for packages, Dev Containers, and Forgejo Actions.
    • Forgejo Actions: CI/CD for code quality and automated deployment process.
  • Backend
    • Elysia: Top-performing TypeScript framework that offers E2E type safety, unified type system, and removes validation boilerplate.
    • Drizzle ORM: ORM tool for simplifying database operations and supercharge query speed.
    • PostgreSQL: Hosted on Aiven, providing a cheaper cost as data grows.
    • Native Web Push: Utilized for real-time notifications.
    • Turnstile: Integrated for bot protection and security.
  • Frontend
    • Next.js: React framework that seamlessly integrated with Elysia with minimal setup.
    • Zustand: Lightweight and powerful state management compared to Redux.
    • Shadcn: A collection of reusable components.
    • Tanstack: Minimize boilerplates such as virtualization, table, and query.
    • Valibot: A shared schemas between backend and frontend for validation and type inference.
  • Kiosk OS
    • Base OS: Custom immutable image built on Universal Blue with full-disk encryption.
    • Lockdown: Enforced kiosk mode with full-screen application access and restricted system functions.
    • Hardware Security: Configured BIOS passwords and disabled boot modifications to prevent unauthorized access.
    • Stateless Design: No persistent user data; system resets to a secure baseline on reboot to mitigate tampering.