BDO ApplicationPortal
Enterprise Data Warehouse & Multi-Client Portal Production
📊 Project Overview
A comprehensive enterprise data warehouse and portal system for BDO, providing unified access to financial and operational data across multiple clients. Built with .NET Aspire, Blazor Server, and Azure services, this production-grade application manages complex data synchronization, role-based access control, and multi-tenant operations.
- Multi-Client Portal - Unified interface serving multiple BDO clients with isolated data views
- Data Warehouse - Enterprise SQL database with complex ETL and data synchronization
- .NET Aspire Orchestration - Modern cloud-native application architecture
- Role-Based Access Control - Granular permission management per client and user
- Azure Integration - Managed Identity, SQL, Key Vault, and cloud deployment
- API Services - RESTful APIs for data access and integrations
- Reverse Proxy - Advanced routing and request management
- Production Deployment - Multi-stage environment (Dev, ACC, PRD) with CI/CD
🎯 Key Features
-
🏢
Multi-Tenant Architecture - Isolated data and views per client within single application
-
🔐
Role-Based Access Control - Granular permissions with role synchronization from Azure AD
-
📊
Advanced Reporting - Complex data visualization and reporting capabilities
-
🔄
Data Synchronization - Automated ETL and data syncing from multiple sources
-
📧
Email Notifications - Automated reporting and notification system with templates
-
⚙️
Scheduled Jobs - Background jobs for reports, user sync, and notifications
-
☁️
Azure Cloud-Native - Full Azure integration with Managed Identity, SQL, Key Vault
-
🔀
Reverse Proxy - Advanced request routing and API gateway functionality
🏗️ Architecture & Technology
Technology Stack
.NET Ecosystem
.NET Aspire Blazor Server C# 12 Minimal APIs
Azure Services
Azure SQL Managed Identity Key Vault App Service
Architecture Layers
Clean Architecture Domain Layer Business Logic Infrastructure
DevOps & Deployment
Azure Pipelines Multi-Stage Deployment CI/CD Infrastructure as Code
Core Components
- BDO.DataEyesWH.Web - Blazor Server web application for user interface and portal
- BDO.DataEyesWH.ApiService - REST API services for data access and integrations
- BDO.DataEyesWH.AppHost - .NET Aspire orchestration and service coordination
- BDO.DataEyesWH.BusinessLogic - Core business logic and domain rules
- BDO.DataEyesWH.Domain - Domain entities and business model
- BDO.DataEyesWH.Infrastructure - Data access, Azure integration, external services
- BDO.DataEyesWH.ReverseProxy - API gateway and request routing
💼 Business Context
Data Warehouse Solution
BDO ApplicationPortal provides a centralized data warehouse consolidating financial and operational data from multiple sources. The portal serves as the primary interface for BDO clients to access, analyze, and report on their data.
Multi-Client Management
- Isolated Data Views - Each client sees only their own data with complete isolation
- Role Synchronization - Automatic syncing of roles and permissions from Azure AD per client
- Global Portal Features - Shared functionality across all clients with per-client customization
- User Management - Synchronized user accounts and permissions from dedicated Azure AD projects
Operational Features
- Scheduled Reports - On-demand and automated report generation and distribution
- Email Notifications - Automated alerts and report delivery via email
- Background Jobs - Scheduled tasks for data sync, reports, and user management
- Super Admin Control - Administrative interface for system management and configuration
📋 Development Status
Phases & Deployment
- Phase 1 - ✅ Core application and data warehouse foundation
- Phase 2 - 🔄 Production deployment and optimization
- Current Status - Environments: Dev, ACC, PRD with continuous improvement
Technical Highlights
- Multi-stage CI/CD pipeline with automated deployment
- Azure Managed Identity for secure authentication
- Complex multi-tenant data isolation strategy
- Integration with Azure AD for user and role management
- Advanced email and notification system with templates
🎓 What This Project Demonstrates
BDO ApplicationPortal showcases expertise in:
- ✅ Enterprise Application Architecture - Clean architecture with .NET Aspire
- ✅ Multi-Tenant Systems - Complex data isolation and per-tenant customization
- ✅ Azure Cloud Services - SQL, Managed Identity, Key Vault integration
- ✅ Data Warehouse Design - Complex ETL and data synchronization
- ✅ Role-Based Access Control - Granular permissions across multi-client system
- ✅ Production DevOps - Multi-stage deployment with CI/CD pipelines
- ✅ Blazor Server Development - Rich web interface with real-time updates
- ✅ API Design - RESTful APIs with complex business logic