Web Application • Maintenance / Support • ASP.NET / SQL Server
About the Client
PHIcure, Inc. is a leading healthcare communications company connecting healthcare organizations to their payers, providers, and patients. Our secure cloud based solutions allow organizations to manage their revenue cycle from any web browser in any location. We connect our partners to thousands of payers throughout the USA and to their patients to successfully manage every aspect of communication in the revenue cycle.
Delmar, New York
ASP.NET, SQL Server
Project in a Nutshell:
Enhance current application, optimize database performance and fix critical bugs.
PHIcure approached us to help them cleanup their existing web application, which was written in ASP.NET and SQL Server. This was a typical maintenance and support engagement, which makes up 50% of our business. PHIcure had a list of features they wanted to implement that their internal development resources didn’t have the bandwidth to complete.
We also optimized the performance of their database (impacting hundreds of stored procedures), and fixed critical bugs that were impacting their user base. PHIcure was bought out by Inmediata, and we have continued to work for them as well.
Goals and Objectives
Most of the maintenance projects we take on have similar goals to those of PHIcure. Their custom application was in need of bug fixes, starting to slow down and it was missing features they had been wanting to implement for many months.
Because the application fell under HIPAA laws regarding patient privacy, we had to optimize database performance without the benefit of running and analyzing the actual data. We worked closely with PHIcure’s internal development team to help us bridge this gap.
By restructuring the database objects to utilize stored procedures instead of inline SQL statements, we were able to run most queries in memory (instead of from the disk drives), which resulted in dramatic performance improvements. We also addressed many bugs and feature requests, further improving the overall user experience.