BI for 200 Healthcare Centers

BI for 200 Healthcare Centers for an amerinca company.

About

Customer

The Customer is an American company that offers software to help 200 healthcare centers and retirement homes to process data related to patients and medication as well as build various types of reports.

Challenge

The Customer commissioned ScienceSoft to rewrite the software – a Java application used by the healthcare centers for management and reporting of data on medication inventory, clinical services, patient data, marketing activities and others. Within the project, the Customer also wanted the tool to allow its users to enable quality population health analytics with prompt reports.

Solution

To ensure scalability and short query response time, ScienceSoft built an analytical Microsoft SQL Server data warehouse which would use a Transact-SQL script to load data from the relational database. The latter was consolidated from 200 databases during the application development process and totaled 12GB. Currently, ScienceSoft BI developers build reports with the JReport tool. Among the reports there are:

Medication Classification Report
Missed Medications
Hospital Readmissions
Employee Performance Report
Community Marketing Activity Summary

Results

The Customer’s clients are now able to improve their management processes thanks to prompt analytics reports. Together with ScienceSoft, the Customer is also planning to build OLAP-cubes to store aggregated data for advanced healthcare data analytics and information processing. Technologies and Tools

MS SQL Server, Transact-SQL, JReport

Not providedSize in euros
Not providedPrice
Not providedDuration in month
Not providedTeam size

Tech Information

Skills

ms sql

Services

Software Development

Industries

Not Provided

Markets

Not Provided

ScienceSoft Portfolios

IBM QRadar SIEM

CambridgeSoft

Automation of Cancer Drug & TPN Order

SIEM Solution

BI for 200 Healthcare Centers

World’s Largest PLM Platform

Viber App

ScienceSoft

Company Description

Founded in 1989, ScienceSoft is a US-headquartered provider of custom software development and IT consulting services with 700 employees located internationally.

For over 32 years we’ve been bringing custom and platform-based solutions to midsized and large companies in Healthcare, Telecom, Retail, Financial Services and other industries. The likes of Walmart, Nestle, eBay, T-Mobile, Baxter and IBM rely on our solutions in their daily operations.

With the background rooted in science, we build on our legacy knowledge and grow it dynamically in the areas of Collaboration, CRM, Data Analysis, VoIP and Information Security. As part of this journey, we partnered with Microsoft, IBM, Oracle, Salesforce, Episerver and more tech leaders so that our clients can benefit from these high-level networks too. Currently, we are recognized with 8 Gold Microsoft Competencies in Application Development, and Collaboration and Content.

The core of our client operations is at our US headquarters in McKinney, TX, and EU office in Vantaa, Finland. At the same time, the major development centers in Eastern Europe. From here, our teams nurture and apply their competencies worldwide: while Northern America remains our principle market, our customers come from over 30 countries.

Experience 32 years in IT

Size 700 employees (600 IT professionals)

Customers 60 countries, 30 industries

Turnover 75% of the revenue comes from 1+ year-long customers

INDUSTRIES

ScienceSoft has been delivering software solutions for middle-market and enterprise customers across multiple target industries. Our hallmark projects include:

Banking and Finance: СRM for a bank with 7 mln clients Award-winning mobile banking solutions Intranet portal for a bank with over $400 bn assets Information security projects for financial institutions on three continents

Healthcare: Business intelligence solution for 200 US healthcare centers Medication order processing system for a US healthcare company with more than $15 bn revenue and 60,000 employees

Retail: Modules for one of eBay’s e-Commerce platforms with over 2.5 mln members Private label product analysis and reporting used by Walmart Trade promotion management solution used by Heinz Brand health monitoring system used by Nestle

Telecom: Viber, one of the world’s most popular instant messaging and VoIP apps with 600+ mln users Information security projects for telecoms in Europe and Asia

Public Sector: Nationwide civil registry for an EU country Mobile document management solution for a parliament We have also built up experience in Education, Manufacturing, Oil and Gas, Media and Entertainment, Transportation and Logistics.

PROJECT MANAGEMENT

With an established project management culture, ScienceSoft has achieved 100% project delivery owing to:

ability to work with both detailed and vague project scope realistic estimation and, thus, staying within budget during implementation effective resource allocation to lessen risks being able to apply various software development methodologies ensuring smooth communication with the Customer and 3rd parties all-round Quality Assurance to guarantee that the application runs as intended

KEY TECHNOLOGY EXPERTISE

Back-end and desktop: Microsoft .NET, Java, C++, PHP, Qt, Node.js Front end: HTML5, CSS3, JavaScript Mobile: iOS, Android, Windows Phone, Xamarin, Apache Cordova, Qt Web development: Drupal, WordPress, Joomla, Pimcore, Magento, Sitecore, EPiServer

BI for 200 Healthcare Centers