All projectsCASE STUDY / 07

ENTERPRISE SAAS · DATA & PERMISSIONS / PROJECT EXPERIENCE

BI Data Management Platform.

Connect organizations, data, and definitions.

Built a NestJS + TypeScript enterprise backend for organization permissions, multiple data sources, data entry, and visual modeling.PRODUCT DEVELOPMENT

EMPLOYER
Bluewinged · Suzhou
ROLE
App Software Engineer
EMPLOYMENT PERIOD
2023.07 — 2025.05
TOOLS & STACK
NestJS / TypeScript / MySQL / PostgreSQL / SQL Server
BUSINESS NEEDS

Manage enterprise structure and business data.

The backend supports organizational hierarchies, dynamic roles, and fine-grained permissions alongside multiple data sources, data entry, visual modeling, and shared data definitions across departments.

CORE DELIVERY

Deliver organization permissions and data capabilities.

Implemented multilevel organizations, Row-level Security, and dynamic role configuration. Built data-warehouse linking and data-entry modules with multiple-source access and tenant isolation.

02 /

Features & delivery.

01

Organization & permissions

Multilevel organization structures, Row-level Security, and dynamic role configuration.

02

Data access & entry

Warehouse linking, data entry, MySQL/PostgreSQL/SQL Server access, and multitenant isolation.

03

Visual data modeling

Model version management, synchronized switching between environments, and consistent cross-department data definitions.

03 / TECHNICAL IMPLEMENTATION

An enterprise backend with NestJS + TypeScript.

Implemented the enterprise backend with NestJS and TypeScript, covering organization permissions, multitenant data access, warehouse linking, and visual modeling.

Row-level SecurityDynamic rolesTenant isolationModel versions
FEATURE SCOPE / 07
ORGANIZATIONHierarchies · Dynamic roles · Row-level Security
DATA ACCESSMySQL · PostgreSQL · SQL Server · Tenant isolation
DATA MANAGEMENTWarehouse linking · Entry · Modeling · Versions / Environments
BI DATA MANAGEMENT PLATFORM · FEATURE MAP

04 / DELIVERED SCOPE

Enterprise capabilities from organization permissions to data modeling.

Delivered organization and dynamic-role management, row-level access, multiple data sources, warehouse linking, data entry, and model-version and environment management.

NEXT CASE STUDY / 08

Feifan Art App