Custom Software Application for Location Management
Solution Description:An organization with a wide geographic footprint grows quickly through mergers and acquisitions. The current process to manage data access and flow such as new location IDs, function and people is to use Excel spreadsheets and store information on SharePoint. This process causes version control uncertainty and confusion internally resulting in misidentification of locations, rework and inefficiencies in information gathering.
Watch TAP Innovation Solutions in action!
Assign internal ownership of managing new site integrations and quickly identify new locations for global visibility. Real-time reports and analytics for company awareness, performance and site status.
Number of Locations: 15
Number of Employees: 300
Industries: Healthcare, Senior Care, Home Care, Mergers & Acquisitions (M&A)
TAP Digital Tools solved the spreadsheet and SharePoint data confusion by replacing spreadsheets and capturing entity information to create a multi-level hierarchy that is stored in a centralized database through TAP Admin. This centralized storage location can be managed with security and access controls. The newly acquired locations are assigned a unique location number, implementing process standardization to easily identify and refer to locations. This eliminates confusion from the manual way of naming based on address or physician name which proved inconsistent. Multiple suites or specialties at a single building can be assigned individual location numbers, making site geography easy to map and visualize. This is also critical for IT, vendor or other services that need accurate entity and location information at their fingertips.
Categories: Custom App
C#, ASP MVC.net, SQL Server, APIs, SSIS, Azure Cloud Services, Multi-Tenant, Entity Framework, Microsoft Power BI, Microsoft SQL Server, SSIS, SQL Server Integration Services