How Fresenius Created Robust Financial Forecasting Automations with Workato
Customer Company Size
Large Corporate
Region
- America
- Europe
Country
- Germany
- United States
Product
- Workato
- Quick Base
- Prolog
- Salesforce
- SharePoint
Tech Stack
- Intelligent Automation
- Integration Platforms
- iPaaS
Implementation Scale
- Enterprise-wide Deployment
Impact Metrics
- Productivity Improvements
- Cost Savings
- Customer Satisfaction
Technology Category
- Application Infrastructure & Middleware - API Integration & Management
- Platform as a Service (PaaS) - Connectivity Platforms
- Analytics & Modeling - Predictive Analytics
Applicable Industries
- Healthcare & Hospitals
Applicable Functions
- Facility Management
- Business Operation
Use Cases
- Predictive Maintenance
- Process Control & Optimization
- Remote Asset Management
Services
- System Integration
- Software Design & Engineering Services
About The Customer
Fresenius Medical Care is a global Fortune 500 company based in Germany and North America, specializing in providing services and products for renal dialysis and other medical needs. With over 325,000 renal patients globally and more than 100,000 employees worldwide, Fresenius is a leading provider for patients with kidney issues. The company operates more than 3,800 dialysis clinics and is committed to delivering high-quality care. In North America, Fresenius builds, owns, and runs medical treatment centers, as well as manufactures and distributes medical supplies. The company's North American division includes a department called RECS (Real Estates and Construction Services), which handles construction projects for new dialysis centers and other facilities. Fresenius's executive vision is to be the most trusted provider for patients with renal and chronic care needs by building a comprehensive and integrated network.
The Challenge
Fresenius faced significant challenges in managing and opening new dialysis centers and other physical locations. The RECS department, responsible for construction projects, operated separately from the rest of the company, using a disparate set of unconnected systems. This led to inefficiencies in the review and approval process, with no comprehensive view of project progress and forecasting models. The company needed to improve data management and streamline workflows to complete construction projects faster and provide better patient care. Additionally, approvals for each stage of a project were completed in an ad hoc manner across multiple systems and divisions, leading to unnecessary project delays. The ability to review data was inefficient, and dynamic reports were non-existent.
The Solution
To address the challenges, Fresenius partnered with MCF Technology Solutions to develop a fully integrated project review, approval, and management system using Quick Base. Intelligent automation was built into the workflows, involving other applications and systems. The solution included an automatic and full financial forecasting model, where preliminary information for new medical centers is submitted through a web portal. This portal includes geographical information, management information, cost estimates, and necessary file attachments. Intelligent automation allows data from construction projects to be sent to Salesforce, enabling smarter management decisions and KPI tracking. A bidirectional integration between Quick Base and Prolog was created to eliminate manual data entry and reduce human error. The integration allows for automatic project creation in Prolog once the budget and project approval process is completed. The project schedule is automatically loaded, and projects are prepopulated with an interactive Gantt chart. Workflows for bi-monthly project updates and task lists are synced in the cloud, providing a single record of truth for all divisions. The integration also sends budget data back into Quick Base, allowing for a complete picture of budget estimates versus actual spend.
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.
