Multi-Tenant Framework
Proprietary ERP & enterprise SaaS architecture
Reusable enterprise SaaS framework born from proprietary ERP work at Ocean Enterprises—now powering the North Star Global product suite (GenPBR, NSG Chatbots, agency platform) and NDA client projects including sales software, CRMs, and service business platforms. Architected multi-tenant Postgres with OIDC-ready RBAC, auth, and integrated payment processing; led a team of four remote engineers on the original ERP build.
Build once, deploy many. Each tenant needs isolated data, customizable permissions, and payment flows—without maintaining separate codebases. The framework had to be opinionated enough to ship fast, flexible enough for diverse business models.
Tenants
- Acme Corp
- Summit Legal
- GenPBR Org
- Northshore K-12
Acme Corp
OIDC · RBACScoped permissions
- billing:read
- users:manage
- api:write
- reports:export
Architected proprietary ERP as key engineer and product manager at Ocean Enterprises
Hired and led a team of four remote engineers through initial ERP delivery
Designed tenant isolation at the database row level with Postgres schemas
Built RBAC system with hierarchical roles and resource-level permissions
Integrated Stripe and Lemon Squeezy with webhook-driven subscription lifecycle
Established patterns for Drizzle migrations across multiple production deployments
- Drizzle ORM with type-safe queries and migration tooling
- Neon Postgres with connection pooling for serverless deployments
- JWT + session hybrid auth with refresh token rotation
- Webhook idempotency and retry patterns for payment reliability
- Connection pooling optimized for Vercel serverless cold starts
- Query patterns indexed for multi-tenant read-heavy workloads
- Edge middleware for auth checks without round-trips to origin
Framework powers multiple production SaaS products—from the original Oceantech ERP through the North Star Global suite and GenPBR. Reduced time-to-market for new verticals from months to weeks while maintaining security and compliance standards.
Explore other case studies — product engineering, live game services, and platform architecture.





