RGS Nordic — Waste Management B2B Customer Portal API

Context & Goals

B2B backend API powering a customer self-service portal for RGS Nordic — one of Scandinavia's largest waste management companies — giving corporate clients access to weighing reports, recycling metrics, orders, and invoices from their waste collection data.

Constraints & Challenges

RGS Nordic's corporate clients had no self-service visibility into their waste collection data. All weighing records, recycling sustainability metrics, collection orders, and invoices lived inside a legacy Microsoft SQL Server ERP system with no customer-facing access layer — requiring manual reporting by account teams and leaving clients with no real-time insight into their environmental performance.

Solution & Approach

Built a NestJS REST API that acts as a secure read-and-download layer on top of RGS Nordic's existing MS SQL Server ERP data, without modifying the source system. Used TypeORM with a dual-database strategy: MS SQL Server for all business data (weighing, recycling, orders, invoices) and PostgreSQL for B2B user identity and access. Secured access with JWT authentication and request-scoped customer context so each corporate user sees only their own data.

Delivered a production B2B API with four core reporting domains: weighing reports (weight per collection with per-page totals in tonnes), sustainability/recycling reports (recycling %, reuse %, energy utilisation, landfill %, and EAK waste codes), collection orders (with QR code and PDF driving licence generation via Puppeteer), and invoices (with credit memo handling and bulk PDF download from AWS S3). All report types support paginated JSON responses, Excel export via ExcelJS, and ZIP batch download — enabling clients to export full audit-ready datasets independently.

Technology Stack

Results & Impact

• →Full self-service access to corporate waste data across 4 reporting domains: weighing, recycling, orders, and invoices
• →Sustainability dashboard exposing recycling %, reuse %, energy utilisation, landfill %, and material recovery per European Waste Catalogue (EAK) code
• →PDF generation via Puppeteer covering weight certificates and order driving licences, stored and served from AWS S3
• →Excel and ZIP batch export across all report types enabling clients to produce audit-ready compliance reports independently
• →Dual-database architecture bridging a live MS SQL Server ERP system and PostgreSQL without modifying legacy source data