Transforming insurance underwriting using a cloud-based data management architecture

Underwriting requires exchanging sensitive consumer data securely with external vendors and partners
Legacy system and process were slow, expensive, and required frequent human intervention
Data storage architecture was rigid and non-scalable
Data pipes were insecure and unreliable
Offline, batch data integrations failed frequently causing significant delays and customer frustration

Designed a data architecture that seamlessly integrated data flow with existing underwriting workbench
Leveraged SFTP, Azure Firewall and a VPN to ensure secure data transfer across external enterprises
Flask / Gunicorn, CosmosDB and Blob Store to build a light-weight backend that can scale easily
Data Factory to orchestrate workflows for the data pipelines
Azure Data Lake and Synapse Analytics to partition, cleanse, and transform data
PowerBI and Analysis Services to analyze data and share insights
Azure Pipelines and App Service to automate CICD infrastructure and accelerate their digital transformation and innovation

Cloud-based platform eases real-time analysis and offline underwriting workflows
Significant improvement in enterprise-wide security posture
Underwriting workflow saves 20%+ time to complete
Improved analytics result in more relevant loan offers and 8% increase in revenue
Optimized workflow reduces human intervention and generates 11% savings
Easily add new data sources through Data Factory pattern
Automated new partner signup and subscription