🤖 ML Project
Enterprise Inventory & Discussion Management System
Full-stack ASP.NET Core 8 MVC inventory management with Identity authentication, EF Core, SQLite for local dev, and PostgreSQL for Azure App Service production.
Project Overview
BrightLife Health Services
Healthcare / Enterprise / Inventory Management
Ongoing (2025 – Present)
Full-Stack Developer
This Enterprise Inventory & Discussion Management System is a production-grade ASP.NET Core 8 MVC application designed for comprehensive inventory tracking and team collaboration. It features Identity-based authentication with Google OAuth, Entity Framework Core with SQLite for local development and PostgreSQL for production, Bootstrap 5.3.3 responsive UI, and is deployed on Azure App Service with infrastructure defined in Bicep. The solution follows a structured SDLC with GitHub-based CI/CD, comprehensive testing, and operational monitoring via Application Insights.
Development Process
This SDLC defines how we build, test, release, and operate the Enterprise Inventory & Discussion Management System, ensuring delivery stays consistent and production-ready.
Plan
Define user story with acceptance criteria, data needs, and non-functional requirements (performance, security, accessibility). Capture in GitHub issue.
Design
Update architecture notes including data model changes, API surface, UI flow, and infra/Bicep changes. Plan caching strategy and review for risky changes.
Build
Follow .NET conventions, keep DI-friendly services, avoid static state. Align provider choice (SQLite vs Postgres) with environment. Keep migrations atomic.
Test
Run dotnet test from solution root. For data changes, run EF migrations and smoke CRUD paths locally. For auth flows, manual Google OAuth login.
Review
Security (authZ/authN), data correctness, nullable handling, logging/exception paths, migration safety, performance (N+1, large includes), and test coverage.
Release
Prefer automated deploy via azd or GitHub Actions. Pre-flight: build in Release, run EF migrations against staging, confirm secrets/connection strings.
Operate
Monitor App Insights dashboards, set alerts on failure rate and latency. Log rollout notes and known issues. Rotate secrets on schedule.
The Challenge
BrightLife Health Services needed a robust, enterprise-grade inventory management system to replace manual tracking processes:
No centralized inventory tracking - Items managed via spreadsheets with no audit trail
No authentication system - Shared credentials with no role-based access control
No cloud deployment - Local-only solutions with no remote access capability
No automated testing - Manual QA processes slowing down releases
No infrastructure-as-code - Manual Azure resource provisioning prone to errors
No discussion/collaboration features - Inventory decisions made offline without tracking
They needed a modern full-stack solution with secure authentication, cloud deployment, automated CI/CD, and comprehensive testing to ensure reliability and scalability.
My Solution
I designed and implemented a complete full-stack solution with enterprise-grade architecture:
ASP.NET Core 8 MVC
Modern .NET 8 application with Razor views, Identity authentication, and EF Core 8 for data access. Supports both SQLite (local dev) and PostgreSQL (production) via provider abstraction.
Azure Cloud Deployment
Production deployment on Azure App Service with Azure Database for PostgreSQL. Infrastructure defined in Bicep for repeatable, version-controlled provisioning.
Google OAuth Integration
Secure authentication via ASP.NET Core Identity with Google OAuth support. User secrets for local development, Key Vault for production credentials.
SDLC & DevOps
Structured workflow with feature branching, PR reviews, automated testing (unit + integration), and CI/CD via GitHub Actions. Application Insights for runtime monitoring.
Key Features
Identity + OAuth
ASP.NET Core Identity with Google OAuth integration for secure, flexible authentication.
Inventory CRUD
Full create, read, update, delete operations for inventory items with search and filtering.
Discussion System
Built-in discussion features for team collaboration on inventory decisions.
Azure Deployment
Production hosting on Azure App Service with PostgreSQL and Key Vault secrets.
EF Core Migrations
Atomic database migrations supporting SQLite (dev) and PostgreSQL (prod) providers.
Application Insights
Runtime telemetry, error tracking, and performance monitoring via Azure Monitor.
Tech Stack
Backend
Frontend
Database
Infrastructure
Auth
DevOps
Screenshots
Main dashboard with inventory overview
Inventory items list with search and filters
Detailed inventory item view
Add new inventory item form
Edit inventory item with validation
Discussion thread for inventory decisions
User and role management interface
Inventory reports and analytics
Application settings and configuration
Responsive mobile layout
Results & Impact
100%
Cloud-Native
Azure Deployment
.NET 8
Latest LTS
Framework
2 DBs
SQLite + Postgres
Provider Support
IaC
Bicep
Infrastructure
Key Achievements
Deployed to Azure App Service with PostgreSQL backend
Implemented Google OAuth with ASP.NET Core Identity
Created Bicep infrastructure-as-code for repeatable deployments
Established comprehensive SDLC with CI/CD via GitHub Actions
Integrated Application Insights for runtime monitoring
Built responsive UI with Bootstrap 5.3.3
Interested in Something Similar?
I help businesses build robust backend systems, membership platforms, and automation tools.
.png)
.png)
.png)