Entries by John Shantz

DWC HL7 Receiver

HL7 messages are the primary method that medical systems use to communicate in real time. This product allows the capture and storage of HL7 messages into a generic schema that can then be used for any purpose. Once the HL7 message is parsed and stored in a database, legacy applications and ETL can be run […]

DWC Patient Communications Tracker

This product allows you to automatically receive patient communications into SQL Server or other relational database. Our clients use this product to capture patient-related emails that are sent to and from clinical staff. It allows you to simply “CC” the clinical database as part of your normal communications with the client. When this is done, […]

Financial Data Warehouse

Data Warehouse Consultants worked with the Armstrong Group on several projects to improve their business intelligence infrastructure. The primary effort was related to creation of a data warehouse and dimensional model in SQL Server to support profitability analysis of the home security installation group. This group used multiple legacy source systems for sales and execution, […]

Specialty Pharmacy Design

Data Warehouse Consultants worked with a specialty pharmacy provider to review their data warehousing strategy, design and architecture for processing prescription related data. Key activities on this project included providing direction for best practices of a reporting architecture and assisting with the selection of an ETL methodology and tools. Our consultants worked with our client’s technical […]

DWC Oracle Quick Report

QuickReport is a custom reporting solution that enables batch reporting and feed creation from an Oracle database by simply writing an SQL query and saving it to a table. After reviewing various third-party solutions a custom, cost-effective solution was developed to generate hundreds of reports and data feeds on a daily and weekly basis. It […]

VMS to Database Conversion

Our team has performed a number of VMS to Oracle database conversions. Our consultants are experienced in working with large datasets on the file system and in the database. We have done many projects that involve the conversion of vast amounts of flat file data into a relational database.  Data Warehouse Consultants has developed many […]

Hyperion Essbase Conversion

DWC has developed custom programs and processes that convert Hyperion Essbase data to SQL Server Analysis Services. After exploring and attempting to use Third-Party solutions, our consultants created a custom, cost-effective solution to meet the client requirements of converting six Essbase cubes to SQL Server Analysis Services. As a part of this project, over a […]

Report Conversion

Data Warehouse Consultants led an effort to convert business-critical reports from a legacy VMS platform into a modern, high-performing and low maintenance Oracle 10g system. These reports were worth approximately $5m/year in revenues and distributed monthly, quarterly and annually to a large manufacturer. The reports provide in-depth marketing analytics and sales data that is critical […]

Hyperion Essbase Conversions

We have developed custom programs and processes that convert Hyperion Essbase data into a SQL Server database or Analysis Services OLAP cube. Since acquiring Hyperion, Oracle has greatly increased the price to maintain this software.  If you are looking to move your legacy data away from Hyperion we can create a custom, cost-effective solution to meet your requirements […]