Freelance

Garment Inventory Management

TypeScriptBunElysiaNext.jsPrismaZustandShadcn/UIFirebaseAmazon RDSPostgreSQLBiomeScalarDev ContainersGitHub ActionsRenovateLefthookSonarQube

Worked as a technical project consultant for a medium-scale garment inventory project used in both client stores and warehouses. Oversaw requirements analysis, sprint planning, technical architecture, team coordination, and code quality assurance.

Key Responsibilities:

  • Analyzed client requirements and translated them into technical specifications.
  • Created and assigned tasks, managed sprints, and led a team of developers.
  • Designed database schema and oversaw code implementation.
  • Enforced strict typing across the codebase, ensuring zero use of the any type.
  • Reviewed and tested code to ensure functionality, performance, and compliance with Git hook quality checks.
  • Set up CI/CD pipelines for automated code quality and deployment.

Features:

  • User, retailer, product, and bundle CRUD.
  • Product and transaction based on retailer ID assigned to user.
  • In-store transaction with barcode scanner and price adjustment for bargaining.
  • Automatic bundle detection during transaction and suggests applicable product bundles.
  • Low stock notification when any product stock reaches low level.
  • Sales trend analysis.
  • Archiving system to keep the database size small.

Technology Stack:

  • Development Tools
    • Dev Containers: Provides a consistent and isolated development environment.
    • Bun.js: Supercharged runtime environment.
    • Biome.js: 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 GitHub Actions.
    • GitHub Actions: CI/CD for code quality and automated deployment process.
  • Backend
    • Elysia: Top-performing TypeScript framework that offers E2E type safety and a unified type system.
    • Prisma Accelerate: ORM tool for simplifying database operations and supercharge query speed.
    • PostgreSQL: Hosted on AWS RDS, providing scalable database.
    • Firebase Cloud Messaging: Utilized for real-time notifications.
    • ReCAPTCHA v3: Integrated for each API that uses POST, PUT, PATCH, and DELETE methods.
  • 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.