Element / Healthcare Insights (J&J) - Facility-to-UCN Mapping Algorithm Enhancement (SourceView)
Facility-to-UCN Mapping Algorithm Enhancement (SourceView)
Problem :
The SourceView platform relied on manual and hard-coded processes to match hospital sales data to J&J’s internal UCN system. This limited scalability caused frequent mismatches, and delayed business feedback loops.
Solution :
The legacy algorithm was upgraded using cosine and Euclidean distance metrics to improve match accuracy. The system was made dynamic by linking directly to the SV product master table, enabling the processing of all platforms automatically. Additional features included:
- Multi-UCN mapping for IDNs
- Weekly automation of outputs
- Migration from SharePoint to Azure Blob and SQL
- Consolidation of source tables and customer hierarchy updates
Outcome :
The enhanced algorithm doubled the processing capabilities, automated business feedback integration, and significantly improved mapping accuracy. It transitioned SourceView from a semi-manual process to a fully scalable, cloud-enabled, and production-grade system.