Back to Projects
Enterprise / ERPBackend Engineer

Enterprise ERP System – DAT Consultancy (Dubai)

A full-featured ERP backend for DAT Consultancy in Dubai, with GraphQL APIs, Redis caching, Xero automation, and auto-scaling on AWS.

Project Overview

An enterprise ERP backend built for DAT Consultancy (Dubai) covering inventory management, sales orders, customer management, and financial reporting. Built with NestJS and Prisma on PostgreSQL, it exposes a GraphQL API for flexible dashboard queries, caches hot catalog and inventory data in Redis, automates invoicing and reconciliation through Xero, and runs on AWS with auto-scaling for high availability.

Key Highlights

  • Designed and built a full-featured ERP backend covering inventory, sales orders, customer management, and financial reporting using NestJS and Prisma
  • Implemented a GraphQL API layer for flexible, efficient querying of inventory and stock data, reducing over-fetching for complex dashboards
  • Integrated a Redis caching layer for frequently accessed catalog and inventory data, significantly cutting average API response time
  • Connected the Xero accounting API to automate invoicing, payment reconciliation, and financial reporting workflows
  • Deployed on AWS (EC2, RDS, S3) with auto-scaling for high availability and fault tolerance