Human Services / Nonprofit

Automating Human Services Case Management with Azure

How we replaced fragmented manual workflows with a serverless, RBAC-secured platform built on Azure

Technology stack

React, Azure Functions, Azure SQL Server, Azure Cosmos DB, Microsoft Data API Builder, Azure Static Web Apps, Azure AD B2C, Azure Communication Service, Azure Application Insights

Front-End: React for building an intuitive and responsive user interface.
Backend & Data: Azure Functions for serverless automation and data transformations; Azure SQL Server for structured storage and efficient querying; Azure Cosmos DB for scalable NoSQL storage of external system data with trigger-based adaptation into the internal schema; Microsoft Data API Builder to streamline API creation and integration.
Infrastructure & Hosting: Azure Static Web Apps to host the front end with scalability and cost-efficiency.
Security & Access: Azure AD B2C to enable secure authentication and role-based access control.
Communication: Azure Communication Service for sending automated email notifications and reminders.
Monitoring & Insights: Azure Application Insights for real-time monitoring, tracking performance issues, analyzing user flows, and proactively identifying bottlenecks.