A scalable, multi-tenant SaaS inventory management system designed for mid-sized retail operations to track stock levels, orders, and shipments in real-time.
Project Context
- Business Domain: Retail & Logistics / E-Commerce Enabler
- Project Context: Multi-tenant SaaS inventory management system designed for mid-sized retail operations.
My Role
My role was as a Full-Stack Developer. I contributed to designing and implementing the multitenant database model using Entity Framework Core, integrating Stripe billing for automated subscription management, developing the Angular frontend, and optimizing search indexing using Azure Cognitive Search.
The Challenge
The client required a solution that could support tenant-aware data isolation, automated subscription billing, and real-time inventory level alerts across multiple warehouse locations. The platform needed to handle large-scale inventory data with highly responsive search capabilities.
Architecture
- Frontend: Angular frontend featuring lazy loading and responsive dashboards.
- Backend: ASP.NET Core API.
- Database: Multi-tenant data model with tenant-aware data isolation using Entity Framework Core.
- Billing: Stripe billing integration.
- Search: Azure Cognitive Search.
Technology Stack
Frontend
- Angular
- TypeScript
Backend
- ASP.NET Core
- Entity Framework Core
- Stripe API
Data
- Azure Cognitive Search
- SQL Server (Planned/Target database framework)
Infrastructure
- Azure
Key Engineering Challenges
Challenge 1: Multi-Tenant Data Isolation
- Challenge: Ensuring strict data isolation for dozens of enterprise tenants across multiple warehouse locations.
- Solution: Architected a multi-tenant data model using Entity Framework Core query filters to keep tenant data logically isolated.
- Engineering Impact: Successfully isolated database operations for each tenant, ensuring security and preventing cross-tenant data leaks.
Challenge 2: Search Performance Over Large-Scale Inventory Data
- Challenge: Maintaining highly responsive search capabilities for inventory queries across large-scale inventory data.
- Solution: Integrated Azure Cognitive Search to offload query processing and indexing from the primary database.
- Engineering Impact: Enabled efficient real-time search capabilities across the entire product catalog.
Challenge 3: Billing Automation
- Challenge: Automating complex billing subscriptions for onboarded tenants.
- Solution: Integrated Stripe billing for automated subscription management.
- Engineering Impact: Enabled hands-free subscription execution and billing tracking.
Technical Decisions & Trade-offs
- Azure Cognitive Search for Indexing: Selected Azure Cognitive Search to manage product indexing. While this added a cloud-service dependency and required synchronization logic, it bypassed relational database limitations when querying large-scale inventory data.
Performance & Scalability
- Successfully managed large-scale inventory data.
- Achieved highly responsive search capabilities.
Security
- Multi-tenant logical data isolation.
- Secure payment processing via Stripe integration.
Outcome
The platform successfully onboarded dozens of enterprise tenants, managing large-scale inventory data with highly responsive search capabilities and reliable billing automation.
Lessons Learned
- Offloading search indexing to dedicated search engines (Azure Cognitive Search) prevents primary relational database bottlenecks under high-volume queries.
- Implementing structured multi-tenancy at the ORM layer (Entity Framework Core) simplifies developer workflows and prevents accidental cross-tenant data access.
Similar case studies
Scaling Collaborative E-Learning Platforms with ASP.NET Core SignalR
Learn how a real-time e-learning platform was scaled to support high concurrent connection loads using ASP.NET Core SignalR and Angular NgRx.
High-Performance API Gateway for Logistics | ASP.NET Core YARP
Discover how an API Gateway was architected to handle thousands of updates, offline syncing, and real-time alerts for enterprise logistics.
About Rajdip Khavad
Rajdip Khavad is an Angular and ASP.NET Core/.NET developer specializing in enterprise applications, APIs, application modernization and performance-focused engineering. On this project, his focus was multi-tenant data isolation, billing integration and search optimization.