Multi-Tenant Inventory SaaS

Overview

A full-featured inventory management platform designed for multi-tenant operation. Each tenant gets an isolated PostgreSQL database, ensuring data separation and independent scaling. The system handles real business operations including stock management, invoicing, and financial tracking.

Responsibilities

• Designed and implemented database-per-tenant architecture with PostgreSQL, including automated tenant provisioning and schema migrations.
• Built the full-stack application with Next.js frontend and Node.js backend.
• Developed automated PDF report generation using Puppeteer for invoices and financial statements.
• Implemented Shariah-compliant investment tracking modules (Mudarabah, Musharakah) with FIFO cost management.
• Deployed and maintained the system across multiple Linux servers using Docker and Nginx.

Technical Highlights

• Database-per-tenant architecture ensuring complete data isolation between clients.
• Automated report generation pipeline producing professional invoices and financial documents.
• Shariah-compliant investment structures integrated directly into the inventory workflow.
• Production system handling real business transactions and financial operations.

Challenges

• Designing a tenant provisioning system that could spin up isolated databases with consistent schemas on demand.
• Balancing multi-tenant resource allocation across shared server infrastructure.
• Implementing complex financial calculations for multiple investment models while maintaining data integrity.

Outcomes

• Delivered a production SaaS platform serving multiple business clients with zero cross-tenant data leaks.
• Established a repeatable deployment pattern for multi-tenant applications on self-managed infrastructure.