SourceMedical provides turnkey solutions for ambulatory surgery centers, including billing, scheduling and registration, credentialing and inventory. As the largest provider of ambulatory surgery software and therapy software, Source Medical has been in business for more than 30 years, supporting more than 5,200 clients.
SourceMedical brought in J2 to help build a business intelligence solution to consolidate data from three of its applications—AdvantX, SurgiSource, and Vision—into a single data store capable of supporting pre-built reports, ad-hoc queries, and advanced analytics. Using Ensemble and DeepSee, we designed and built a solution that included a robust Caché data warehouse, ETL processes for loading and updating the data model from external Caché and SQLServer databases, and a process for data purging and archiving. Subsequent project phases introduced role-based security and authentication, transaction auditing capabilities, and the development of DeepSee data cubes, dashboards, and reports.