INDUSTRY:
TECHNOLOGY:
DATABASE:
USER COMMUNITY:

United States Navy, Enterprise Asset Management
IBM Maximo 7.1
Oracle 10g
Naval Facilities Engineering Command (NAVFAC) Expeditionary Programs Office (NEPO)

Business Need	The Naval Facilities Engineering Command (NAVFAC) needed to migrate its expeditionary logistic management information from three custom legacy mainframe systems to a single system using IBM's Maximo 7.1 Asset Management software.
Solution	NAVFAC used a variety of unique, stand-alone, and antiquated applications developed over 25 years ago to manage its expeditionary logistic responsibilities. These legacy systems managed the Navy's 22,000 unique expeditionary items valued at $4.8 billion. Migrated data included 8 years of requisition history, 95 tables with 2000 columns and several million rows of information. Rentfrow analyzed the current business rules, functionality, and processes and designed an implementation of Maximo containing 65 modules, 1100 tables and 20,000 columns of data. During requirements gathering, 1250 additional rules were identified resulting in RENTFROW configuring or customizing 25 modules and 50 tables containing 1130 columns of data. Over 600 reports were analyzed and reduced to 60.
Benefits	RENTFROW is delivering a single system built on new technology and common business methodology that reduces the cost and increases reporting flexibility. The size and age of the application code and outdated technology made it difficult for the legacy systems to keep up with evolving business requirements, and therefore difficult and expensive to maintain and operate. Unlike the legacy systems, EXMIS provides a much more flexible reporting system with the analytical and exception reporting tools needed for enterprise visibility and decision making. The maintenance of 600 reports was reduced to 60 reports. Flexible reporting capabilities were increased through the use of ad-hoc open-source business intelligence and reporting tools.