Skip to content
company project· ongoingProject 08 / 11

Jewelry Fulfillment & Procurement ERP

PostgreSQL-backed fulfillment ERP — my contribution focused on the procurement operations dashboard and Finance Manager purchase invoice UI within the broader platform.

  • React
  • Vite
  • Redux
  • Recharts
  • Tailwind CSS
  • Express
  • PostgreSQL
  • Sequelize

01

Problem

Jewelry fulfillment teams needed visibility into purchase order status, job card pipelines, and vendor invoice payment tracking — with clear dashboards instead of scattered operational data.

02

Solution

Built procurement dashboard UI with PO status charts, vendor breakdowns, job card pipeline metrics, and KPI cards; and Finance Manager purchase invoice screens with filtering, payment status tracking, and invoice actions.

03

Architecture

React + Vite + Redux frontend consuming the platform's REST APIs. Procurement dashboard uses Recharts for PO trends, vendor bars, and job card pipeline gauges. Finance module provides purchase invoice table with payment status (Paid/Partial/Unpaid), vendor filters, and upload/print actions. Backend: Express + PostgreSQL (Sequelize) within the fulfillment platform.

04

Business impact

Gave operations and finance teams at-a-glance visibility into procurement health and vendor invoice payment status across high-volume jewelry fulfillment workflows.

Decisions

Technical decisions

  1. 01Recharts for PO trend lines, vendor bar charts, and job card pipeline visualization
  2. 02Separate Finance Manager module UI with dedicated invoice filtering and status taxonomy
  3. 03Dashboard KPI cards for quick operational health checks before chart drill-down

Features

Feature breakdown

  • Procurement Dashboard
  • PO Status Overview
  • Job Card Pipeline
  • Vendor Breakdown
  • Finance Purchase Invoices
  • Payment Status Tracking
  • Invoice Filters

Responsibilities

  • Built procurement operations dashboard — PO status overview, vendor breakdown, monthly PO trends, and job card pipeline metrics
  • Implemented KPI cards for active POs, sales orders, open job cards, and finished-goods inventory
  • Developed Finance Manager purchase invoice UI with reference/vendor filters and payment status views
  • Built purchase invoice data table with Paid, Partial, and Unpaid status indicators and invoice actions

Challenges

  • Presenting dense PO and job card metrics without overwhelming the dashboard layout
  • Designing finance invoice tables that handle thousands of records with clear payment status at a glance

Performance considerations

  • Paginated invoice tables for 10,000+ purchase invoice records
  • Chart data aggregation at API layer for dashboard load performance

Lessons learned

  • Procurement dashboards benefit from pairing summary KPIs with drill-down charts (vendor, trend, pipeline)
  • Payment status color-coding (Paid/Partial/Unpaid) is essential for finance invoice review at scale

Related engineering library

Explore more← All projectsEngineering library →