Hackensack Meridian Health Speeds Up PeopleSoft by Archiving Decades of Data Before Its Next Acquisition
Hackensack Meridian Health (HMH) is New Jersey’s largest and most comprehensive health network, running its financials and supply chain operations on PeopleSoft FSCM. Two decades of transactions live in that system, and the network keeps growing.
Industry
Healthcare
Service
Consulting
Solution
PeopleSoft Data Archiving
Organizations naturally store more data over time, especially as they grow. Add acquisitions into the mix, and storage needs increase exponentially. For a health network expanding as fast as HMH, data growth isn’t a someday problem.
The Challenge
HMH had accumulated more than 20 years of data in its FSCM 9.2 system and noticed the system was slowing down. With three more hospitals joining the network through acquisition, concern grew that the additional data would further bog down the system.
The Solution
Mythics completed an in-depth analysis of HMH’s database, projecting data growth and pinpointing the top 100 largest tables. Working from pie charts and pivot grids, HMH’s product module experts reviewed performance issues and identified which data to archive. Mythics guided the team through reconciling transactions, a required step before archiving, delivered custom templates that saved HMH from building its own, and documented step-by-step procedures so archiving could continue year after year.
Services provided:
- Data Archive Analysis Toolset. Delivered a toolset that analyzed HMH’s entire PeopleSoft database and tracked its data growth trajectory.
- Custom Data Archive Templates. Provided custom archive templates not delivered by PeopleSoft and improved existing templates that were performing poorly.
- Transaction Status Guidance. Advised the HMH team on reconciling and closing PeopleSoft transactions for faster archiving.
- Data Archive Procedures. Delivered instructions and procedures for ongoing archiving.
The Results
- Faster system, fewer concerns. HMH alleviated its performance concerns and increased system speed by archiving several years of historical data from its main product modules.
- A repeatable annual process. The initial archival left HMH with the tools and documentation to repeat the process every year.
- Ready for the next acquisition. Data growth from future acquisitions is no longer a looming system risk.
