Success Stories

Our client’s success in meeting their goals is our most important objective.

Giving Users the Power of Automated Provisioning

Giving Users the Power of Automated Provisioning

This for-profit division of a major national Medical Association provides market, clinical, medical, and community information and research services to the healthcare and insurance industries, as well as consumers.  There are numerous health-related websites maintained for use by its members and the public.  Additionally, the client was developing a new online application to replace a paper volume of thousands of data points for its members and eventually for purchase to those outside the association, with a short implementation timeframe.  With a membership of several thousand, including the possibility of numerous users within each member, current provisioning applications and processes became unworkable, and were not robust enough to be used for a large number of users – not to mention that manual provisioning would have involved significant staff additions.  It was determined that the best solution would be a single user provisioning and access control system that could be initially deployed for the new application, and then deployed for the rest of the Association’s applications.
On the technical side, because of the number of new users that would require provisioning, the already over-taxed IT Department simply did not have the capacity to support the functionality needed.  The association’s staff and IT department had their own technical frustrations with their own provisioning system.  Since previous to this endeavor the client was only responsible for provisioning internal users, they had nothing in place to provision thousands of users in a reasonable, cost-effective manner and required an automated system that could address internal as well as self-service provisioning at member organizations. An automated provisioning system would give the client flexibility in its access control, along with giving its members the ability to control provisioning for the members’ own users. 

How We Solved It

Trillium performed a rigorous technical review and requirements analysis prior to leading a fast-track selection process to identify the best provisioning solution for the client’s needs.  The review confirmed that an open-source solution would best serve the client’s needs both from technical and financial standpoints.  Then, the selection process was conducted to identify the best implementation partner for the identified open-source solution.  The partner chosen will have an ongoing client relationship both for provisioning build and as a maintenance partner, working on a fast-track implementation schedule.

Results

  • Client has an open-source application for user provisioning and access control, along with its implementation partner
  • Implementation of a standard provisioning system allowed client to begin to replace older custom provisioning systems and manual processes.
  • Client met the deployment schedule for its new online application with its new provisioning system in place

Download this Success Story »

Successfully Predicting Failures

Successfully Predicting Failures

Large airlines tie up millions of dollars each year holding inventory of excess parts in order to support the unplanned replacing of parts.  They spend millions of dollars each year moving those parts from one maintenance location to another in order to ensure that they have the parts on hand when they have to perform maintenance on their planes.

The stocking levels for the spare parts were often determined based on actual usage requirements and limited forecasts.  Not having the needed part on hand in the right maintenance location caused out of stock conditions which grounds aircraft that cost the airlines money, negative impacts consumer experiences, and negatively impacts the reliability numbers that the airlines are measured against.  In order to limit this, airlines hold excess inventory which costs them millions of dollars a year.  Without analytical tools, there was no ability to see trends in part usage aside from raw historical use. The airline was also not able to determine if maintenance should be done earlier than scheduled when the part and the plan were in the same location.

How We Solved It

Trillium was brought in to manage the requirements gathering, data mining, design and implementation of new Supply Chain Software and predictive analytics solutions and then coordinate the activities of 6 best of breed consulting companies to implement these new tools.  Trillium also designed and developed tools to simplify the integration of these new tools into the airlines legacy environment.  In addition, Trillium designed and developed key reporting components to support the clients decision making process.

Results

  • Management of over 450,000 bin locations is no longer a manually intensive and reactive activity.
  • Procurement of parts is now done objectively using forecasts with measurable error rates allowing departments to make decisions based on rel
  • Annual carrying cost for parts was reduced by over $100 million
  • Shipping costs were reduced by over $50 million a year transferring parts between maintenance facilities.
  • Tight integration with the existing legacy system reduces the risk of unnecessary overstocking and stock-outs.

Download this Success Story »

Maximizing Not-for-Profit Productivity by Minimizing Customization

Maximizing Not-for-Profit Productivity by Minimizing Customization

This major not-for-profit organization specializes in product distribution to its member agencies throughout the Unites States.  The member agencies, in turn, distribute products to needy population in their areas.  While the organization doesn’t warehouse any product, it has very specific activities concerning its supply chain and distribution areas, and its current Enterprise Resource Planning (ERP) System was struggling to keep up with growth.  Required financial reporting had become more difficult and increasingly manual.  In order to create needed reports, the client’s financial staff had to create different desktop applications and databases that were very complex in comparison with their resulting rudimentary reports.  The ERP also had to interface with a number of back office systems, which was made more difficult every time an interface with each required modifications.   
The existing ERP was numerous levels out-of-date and no longer supported by its vendor.  Due to multiple customizations applied to it, required modifications to the system had become difficult, time-consuming, expensive, and nearly impossible to maintain. Both the organization’s business staff and the IT organization were frustrated with amount of maintenance necessary.  Both the business staff and IT agreed that the time had come to investigate ERP systems that would satisfy the client’s unique requirements through; middleware instead of customizations; demonstrated use in the not-for-profit sector for supply chain, fund accounting, and reporting; and, a Software-as-a-Service (SaaS) model to streamline hosting and ensure that system updates would occur on a predetermined schedule to minimize customizations and hosting expenses.

How We Solved It

Trillium used its Proprietary Vendor/ Software selection process to identify the best ERP solutions and implementation vendors to meet the client’s needs.  We reviewed the client’s existing systems to identify their go-forward business and technical requirements.  We created use cases with the client so potential vendors could understand their unique requirements, and could be used for testing during the implementation of the chosen system.  After the selection process and client demonstrations, Trillium assisted the client in selecting a SaaS-based ERP system that best met its business and technical requirements with a minimum of customizations.

Results

  • Client had standard ERP functionality including needed not-for-profit processing and reporting
  • Client had simpler customizations and interfaces to back office systems through middleware
  • Client had complete buy-in from all key stakeholders on the software selected and the vendor to perform the implementation

Download this Success Story »

Predicting Patient Readmittance

Predicting Patient Readmittance

Most healthcare organizations are drowning in data but are challenged to gain reliable, actionable insights from this information.  It is in the form of physician notes, registration forms, discharge summaries, documents and more.  This data is doubling every five years.  Different from machine-ready data, this content lacks structure and is arduous for healthcare enterprises to include in business analysis and therefore is routinely left out. As a result, millions of patient notes and records often sit unavailable in separate clinical data silos. This content contains valuable information, but there’s historically been no easy way to analyze it.  While there’s no silver bullet for preventing all re-admissions, hospitals and health providers can take action to significantly decrease the occurrence.

More than 80% of the client’s data was unstructured. It was in the form of physician notes, registration forms, discharge summaries, echocardiograms, and other medical documents.  The client knew they had to leverage their wealth of unstructured information to discover new, population-specific clinical and operational insights and significantly reduce the occurrence of high cost CHF re-admissions by proactively identifying patients likely for re-admission and introducing early interventions to reduce cost, mortality rates, and improve patient quality of life.

How We Solved It

Trillium managed the data mining, modeling and implementation team that introduced a healthcare industry software offering that combined content analytics and natural language processing technology that helped both the health care providers and payers improve patient care and reduce costs.
Leading the entire project and predictive analytics solution team while working directly with a world leader in natural language processing, Trillium was able to provide a Content and Predictive Analytics solution that allowed the client to extract relevant clinical information from vast amounts of patient data to better analyze the past, understand the present, and predict future outcomes.

Combining natural language technology with predictive analytics allowed the client to identify the root causes of hospital re-admissions, and the ways it could decrease preventable multiple hospital visits.

Results

  • By predicting readmission candidates and introducing mitigating strategies, the client reduced costly and preventable readmissions by 7%
  • Eliminated the need for traditional analysis a resource intensive task and transformed raw information into healthcare insight quickly.
  • Revealed trends, patterns, deviations, and the probability of outcomes. Enabled client to derive insight in minutes versus weeks or months.

Download this Success Story »