VHA Cuts Costs and Improves Member Services Using Denodo Data Virtualization
Customer Company Size
Large Corporate
Region
- America
Country
- United States
Product
- Denodo Platform
Tech Stack
- Salesforce
- Hadoop
- Pig
- MapReduce
- Impala
Implementation Scale
- Enterprise-wide Deployment
Impact Metrics
- Cost Savings
- Productivity Improvements
Technology Category
- Platform as a Service (PaaS) - Data Management Platforms
- Analytics & Modeling - Data-as-a-Service
Applicable Industries
- Healthcare & Hospitals
Applicable Functions
- Sales & Marketing
- Business Operation
Services
- Data Science Services
- System Integration
About The Customer
VHA is the largest member-owned healthcare company in the US delivering industry-leading supply chain management services and clinical improvement services to its members. VHA provides services to nearly 30% of the nation’s hospitals and more than 118,000 non-acute healthcare customers. Data is at the heart of VHA's operations. VHA grapples with more than 1 billion detailed line item spend data, 110 million detailed patient records, 9 million products with 100 million cross-references and 110,000 non-acute care customers submitting detailed line item spend data each month. VHA's own product master is the result of their careful research and gathering of data on parity and cost-effective products. With the help of the product master they can negotiate better pricing for their member non-profit hospitals, such as Mayo Clinic, and also help them differentiate between the suppliers.
The Challenge
VHA's Sales Operations team needed various types of reporting such as opportunity reports, leads, as well as member-related reports. They also needed to perform analysis using BI tools on opportunity-to-outcome, member-to-product and lead time. VHA's analysts provide reports on saving opportunities and initiatives to their member organizations on a regular basis. They also needed to know where to invest their time and resources - recruit new members or expand more products within the existing customer base. VHA's sales team uses salesforce.com to generate these reports containing vital business information. Thirty-five analyst users needed immediate access to salesforce.com for reporting purposes. VHA wanted to minimize Salesforce license costs, as some of the user licenses were used strictly to view the data. A new and cost-effective solution was needed to support the business information needs, with the flexibility to make the data accessible and available to any analytics or business intelligence tool used by the relevant business units.
The Solution
VHA had an instance of Salesforce that several analysts used, increasing the licensing cost for every user. VHA decided to use the Denodo Platform for data virtualization to replicate the external Salesforce environment into an internal reporting environment. VHA's internal users did not need Salesforce access anymore since the Denodo Platform became the single access layer for all business information needs. The Denodo Platform's ease-of-use and fine-grained security to the field level of each report made its adoption successful. Denodo's Salesforce connectors enabled VHA to provide a one-way scheduled feed of data from Salesforce. They provided sales operations with the ability to authorize read-only access to specific users for specific data-sets. VHA created 16 different data sets with different authorizations to customize and control the type of data access to users. Using the Denodo Platform's abstraction layer, VHA could also expose virtual views of ICE data to be used by any reporting and/or business intelligence tool in the enterprise.
Operational Impact
Quantitative Benefit
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
Related Case Studies.
Case Study
Hospital Inventory Management
The hospital supply chain team is responsible for ensuring that the right medical supplies are readily available to clinicians when and where needed, and to do so in the most efficient manner possible. However, many of the systems and processes in use at the cancer center for supply chain management were not best suited to support these goals. Barcoding technology, a commonly used method for inventory management of medical supplies, is labor intensive, time consuming, does not provide real-time visibility into inventory levels and can be prone to error. Consequently, the lack of accurate and real-time visibility into inventory levels across multiple supply rooms in multiple hospital facilities creates additional inefficiency in the system causing over-ordering, hoarding, and wasted supplies. Other sources of waste and cost were also identified as candidates for improvement. Existing systems and processes did not provide adequate security for high-cost inventory within the hospital, which was another driver of cost. A lack of visibility into expiration dates for supplies resulted in supplies being wasted due to past expiry dates. Storage of supplies was also a key consideration given the location of the cancer center’s facilities in a dense urban setting, where space is always at a premium. In order to address the challenges outlined above, the hospital sought a solution that would provide real-time inventory information with high levels of accuracy, reduce the level of manual effort required and enable data driven decision making to ensure that the right supplies were readily available to clinicians in the right location at the right time.
Case Study
Gas Pipeline Monitoring System for Hospitals
This system integrator focuses on providing centralized gas pipeline monitoring systems for hospitals. The service they provide makes it possible for hospitals to reduce both maintenance and labor costs. Since hospitals may not have an existing network suitable for this type of system, GPRS communication provides an easy and ready-to-use solution for remote, distributed monitoring systems System Requirements - GPRS communication - Seamless connection with SCADA software - Simple, front-end control capability - Expandable I/O channels - Combine AI, DI, and DO channels
Case Study
Driving Digital Transformations for Vitro Diagnostic Medical Devices
Diagnostic devices play a vital role in helping to improve healthcare delivery. In fact, an estimated 60 percent of the world’s medical decisions are made with support from in vitrodiagnostics (IVD) solutions, such as those provided by Roche Diagnostics, an industry leader. As the demand for medical diagnostic services grows rapidly in hospitals and clinics across China, so does the market for IVD solutions. In addition, the typically high cost of these diagnostic devices means that comprehensive post-sales services are needed. Wanteed to improve three portions of thr IVD:1. Remotely monitor and manage IVD devices as fixed assets.2. Optimizing device availability with predictive maintenance.3. Recommending the best IVD solution for a customer’s needs.
Case Study
HaemoCloud Global Blood Management System
1) Deliver a connected digital product system to protect and increase the differentiated value of Haemonetics blood and plasma solutions. 2) Improve patient outcomes by increasing the efficiency of blood supply flows. 3) Navigate and satisfy a complex web of global regulatory compliance requirements. 4) Reduce costly and labor-intensive maintenance procedures.
Case Study
Cloud-based healthcare solution for Royal Philips
Royal Philips wanted to launch its cloud-based healthcare solution HealthSuite Digital Platform in China to deliver services to help cope with challenges related to urbanization and population growth. Philips wanted to achieve this goal by combining mobile, cloud computing and big data technologies. To bring this platform and product to market, Philips required cloud computing and local technical service capabilities in China, in addition to a flexible IT infrastructure that could handle user requests.
