Client Description

St. Jude Medical, Inc. develops, manufactures, and distributes medical devices for the worldwide cardiovascular market. The Company serves patients and its health care customers with products and services including heart valves, cardiac rhythm management systems, specialty catheters, and other cardiovascular devices.

The company is a global medical device manufacturer focused on improving the treatment of some of the world’s most expensive epidemic diseases. St. Jude Medical produces seven principal product categories: implantable cardiac defibrillator (ICD) systems (the company’s largest category), pacemaker systems, atrial fibrillation products, vascular products, structural heart products, Thoratec products, and neuromodulation products. The firm sells its products in more than 100 countries; the US is its largest market. In early 2017, St. Jude Medical was acquired by Abbott Laboratories for $25 billion.

St. Jude Medical operates with five major areas of focus: heart failure, atrial fibrillation, neuromodulation, traditional cardiac rhythm management, and cardiovascular.

The company started out making mechanical heart valves, but half of its revenue these days comes from pacemakers and ICDs. ICDs (the company’s largest product category) correct for tachycardia, or overly fast heartbeats. Pacemakers, in contrast to ICDs, are used to treat patients whose hearts beat too slowly. St. Jude developed one of the industry’s first pacemakers with wireless telemetry — which in this case allows the patient to be monitored by his physician from a distance from the time of implantation all the way through to his follow-up.

St. Jude Medical’s atrial fibrillation products include electrophysiology introducers and catheters; cardiac mapping, navigation, and recording systems; and ablation systems. The company also makes vascular products such as pressure management guidewires, tomography imaging products, vascular plugs, heart failure monitoring devices, and other accessories. Structural heart products include heart valve repair or replacement products and structural heart defect devices, while neuromodulation products use spinal cord or brain stimulation to treat chronic pain or movement disorders.

Thoratec products include ventricular assist devices and percutaneous heart pumps. These help the flow of blood throughout the body.

In addition to the US, St. Jude Medical’s markets include the rest of the Americas, Europe, and the Asia/Pacific region (especially Japan).

Based in Illinois, the company has additional headquarters based on various product lines in California, Massachusetts, Texas, and New Jersey. It has US manufacturing facilities and research and development facilities in California, Michigan, Minnesota, Arizona, South Carolina, Texas, New Jersey, Oregon, Massachusetts, and Georgia. The company has foreign plants in Brazil, Puerto Rico, Costa Rica, Israel, Switzerland, and Malaysia.

St. Jude Medical has more than 100 sales and administration offices around the globe. Its products are sold in more than 100 nations.

Abbott purchased St. Jude Medical as part of its mission to focus extra efforts on chronic pain management and cardiovascular care (which now make up about a third of its business).

Challenge

St Jude Medical’s financial system was split up into multiple divisions that independently handled their plan-in, plan-out, and actuals from over 18 unique Legacy source Systems and ad hoc processing.  Due to the this highly disparate data, SJM experienced difficulty organizing this data allowing analysis to take place.

The Clearview project was an effort to synchronize their multiple RevScogs, Opex, and Workforce sources into a central location for reporting and planning from their Hyperion Essbase Cubes.

Solution

The solution for St Jude included extracting RevScogs and Opex data from SAPBW as well as Flat files into their Oracle environment using DataStage as the middleware solution and then applying the appropriate business rules and transformations to integrate the different data sets before loading them into their target Hyperion Planning and Essbase applications.

Benefits

Due to the creation of this interface, many redundancies were discovered which allowed St Jude to retire a multitude of systems and report exclusively from Hyperion providing a single source of truth and a clearer view of their data.

  • Tools: Hyperion | IBM InfoSphere DataStage | Oracle | SAP BW
  • Categories: Analytics, Big Data
  • Tags: Healthcare