Heart Center Database

Data Warehouse Consultants worked with the Heart Center at the Children’s Hospital of Pittsburgh to convert a Microsoft Access database tracking hundreds of thousands of patients into an enterprise-class web application based on ASP.NET and Microsoft SQL Server. This application has evolved to include patient tracking for various areas within the department including Adult Cardiology, Heart Failure and Heart Surgery among other areas. The live HL7 feed from the core EMR provider keeps the department’s database up-to-date, which saves time for heart center staff and allows them to focus on more effective delivery of care.

Contact us today for a free demo!

Neurodevelopment in Rare Diseases

The Children’s Hospital of Pittsburgh maintains a world-class program for the study of Neurodevelopment in Rare Disorders led by Dr. Maria Escolar. Data Warehouse Consultants has developed an extensive Virtual Medical Home application for this organization that allows them to track and communicate more effectively with their patients around the world. This application has developed over time to include many different functions including communicating with patients, tracking patient development and general improvement of patient care.

Contact us today for a free demo of the virtual medical home application!

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, and this data needed to be extracted and merged to provide meaningful profitability analysis by job and product. Our team successfully completed this effort to provide unique insights to Armstrong Group stakeholders regarding this business.

For a free demo, contact us today!


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 personnel to fine-tune an already successful business intelligence platform into one that was world-class.

Contact us today for a free demo!

Pharmacy Mobile Application

intermecData Warehouse Consultants developed a system to track the delivery of custom medications within the hospital. Current EMR systems only track the submission of a medication order until the point where the order is sent to the patient from the internal pharmacy. This can lead to situations where a medication is delivered to caregivers or remote stations and then lost.

Our solution provides a mobile application for the Medical Delivery Personnel. These specialists deliver the IV medications to the hospital floor or nurse. Then they scan the location or badge of the person to whom the medication is delivered at the time of delivery. This completes the life cycle of the medication order from the pharmacy’s perspective. It also provides an audit trail and a point to begin looking for a medication that gets “lost in the shuffle”.

This mobile system also allows management to track the efficiency of medication delivery for the pharmacy which leads to superior service. The department maintains an internal queue of each order and the time expected to delivery. This helps the pharmacy to run efficient operations, and significantly reduces the time and costs required when a medication must be redistributed. This technology has revolutionized the business processes of the internal pharmacy at Children’s Hospital of Pittsburgh.

Contact us today for a free demo of the pharmacy mobile application!