Ahmed AlsaidyProduct & Systems Engineer
← All projects
B2B Supply Chain, Supplier & Order Management
Client System

ASPECTRIQ Supply Chain

A B2B supply-chain and fulfillment platform featuring live order delivery KPIs, supplier performance scoring, a 2,450+ SKU product catalog and role-based access control

Role
Full-stack engineering & UI design
Timeline
2025 – 2026
Platforms
Web · Server
2,450+
catalog products & SKUs
128 مورد
suppliers & SLA tracking
صلاحيات
role-based access control
تقارير حية
delivery & stock KPIs
ASPECTRIQ supply-chain dashboard showing order fulfillment KPIs and supplier SLA ratings
ASPECTRIQ supply-chain dashboard showing order fulfillment KPIs and supplier SLA ratings Click to expand ⤢

Overview

Business problem & context

B2B supply-chain operators coordinating hundreds of suppliers and thousands of purchase orders need real-time visibility into delayed shipments, supplier SLA compliance and strict role-based access control

System Architecture

System layers & components

An enterprise Arabic RTL supply-chain and supplier management platform built with React, TypeScript and Tailwind CSS featuring live fulfillment analytics, SKU catalog management and RBAC identity administration

L1

Executive & Operations Console · React + TypeScript

Supply chain KPIs, delivery status breakdown & supplier SLA cards

  • Order Fulfillment Analytics
  • Supplier SLA Rating Matrix
  • Delayed Order Alerts
  • Native RTL Arabic Design System
L2

Catalog & Order Fulfillment Engine

2,450+ SKU catalog & Affiliate · Fulfill · Deliver lifecycle

  • SKU Stock Status & Thresholds
  • Multi-Category Filtering & Search
  • Supplier Assignment & Tracking
  • Export & Audit Reports
L3

Identity & RBAC Security Layer

Enterprise user lifecycle, role matrix & access policies

  • Role-Based Access Control (RBAC)
  • Department & Branch Scoping
  • Session & Activity Auditing
Tech Stack — Technologies used:
  • TypeScript
  • React
  • Tailwind CSS
  • PostgreSQL
  • Row Level Security

Data Model

Database schema & core tables

Data model connecting suppliers, SKU catalogs, fulfillment orders, SLA performance metrics and RBAC user permissions

Table Role in the system
suppliers / supplier_sla_metrics Supplier profiles, on-time delivery rate and quality scorecards
catalog_products / stock_levels Product SKUs, categories, unit pricing and stock availability
supply_orders / order_status_logs Fulfillment orders and status transitions (delivered, in-progress, delayed)
users / roles / role_permissions Enterprise users, functional roles and granular permission grants

Implementation

Key technical decisions

01

Automated supplier SLA scoring driven by actual delivery timestamps

Supplier reliability scores and on-time percentages are computed directly from order fulfillment timestamps rather than manual ratings

02

Dedicated enterprise identity and RBAC administration console

Isolated user and role administration into a dedicated security console governing read/write access across suppliers, pricing and financial reports

Security

Security & access control

  • Role-based access control separating system admins, procurement managers and fulfillment operators
  • Full auditability across order status transitions and catalog price updates

Code Highlight

Supplier SLA compliance calculation

aspectriq/domain/sla.ts · TS
export function computeSupplierSla(orders: ReadonlyArray<SupplyOrder>): SlaSummary {
  const completed = orders.filter((o) => o.status === 'delivered' || o.status === 'delayed');
  if (completed.length === 0) return { onTimeRate: 100, delayedCount: 0 };
  const punctualCount = completed.filter((o) => o.deliveredAt <= o.promisedAt).length;
  return {
    onTimeRate: Math.round((punctualCount / completed.length) * 100),
    delayedCount: completed.length - punctualCount,
  };
}

Summary

Outcome & status

Cohesive Arabic B2B supply-chain system uniting executive analytics, SKU catalog management, supplier SLA tracking and RBAC security

Next project TEMM Nexus → Open source & self-hosting

Technical Evaluation · GCC / Remote / Egypt

Building an operational system, rescuing an AI cloud stack, or hiring a Product Engineer on retainer?

Complete the 30-second scope qualifier so our first conversation goes directly into system architecture, milestones, and budget fit.