Master Providers Repository
A centralised portal for managing and reconciling Healthcare Provider records aggregated from 50+ data sources, serving as the single source of truth for provider credentialing and service data.
Features
- Ingestion and deduplication of provider records from 50+ upstream sources
- Provider record management with 30+ attributes coming from reference tables and source data
- SSO-secured access with role-based permissions and users management
- Provider search and filtering across specialties, locations, and service types
- Golden Record reconciliation workflows with conflict resolution
- ServiceNow integration for change requests
- Downtime notifications and data emails for stakeholders
- Atrributes-based access control for different teams and sources
- PDF export of provider records with custom templates and formatting
- Conditional and triple-dependency attribute change approval workflows
Tech Stack
AngularNode.jsTypeScriptPythonTailwindSSOPDFKitSentryMSSQLAzure DevOpsPM2Nginx
Key Insights
- Reference Tables for provider attributes like specialties and service types simplified data normalization across disparate sources
- A custom change detection and reconciliation system helped route attribute change requests efficiently
- For attributes unrelated to ServiceNow, implementing a custom tasks system with approval workflows allowed for proper authorization and auditability