Provide support, analysis, design, architecture and development services for a medical financial system that creates paper claims and statements as well as online access for patients to their statement information. The primary focus is the manipulation of PHI data sent from hospitals and ETL processes that load it into SQL Server.
One solution that we helped to architect loads incremental data daily from a hospital to recreate their full dataset instead of the hospital sending full loads daily. Two key benefits are the reduced processing on the hospital systems and the ability to extract and blend data in various formats for different timeframes and blend the data with other sources.
Another solution that we architected is a file management system that harvests files from various sources (FTP, SAMBA, SFTP, FTPS and UNC paths), stores them in a repository, has a file identity system, file routers and event logging. This is a unified system that replaces several single task applications for managing the thousands of files this group receives and manages daily. It is designed to scale out with multiple light weight Harvesters and Routers placed across the network and using WCF to communicate between the services.