Facilities - Strategic Application Roadmap

Tririga Upgrades

Benefit:

1. Overhaul of the user experience. Consumer web site type of look and feel.
2. Work scheduling
3. One platform for project and work order management
   
   Project Scope:
4. Upgrade FACserv application and platform to 10.
5. Upgrade Projects 8i application and platform to 10.
6. Merge Projects 8i and FACserv
7. Licensing extension until Projects 8i is upgraded and merged

Challenges

1. Realtime copy of Tririga database (data warehouse) is end of life.
2. Entire project take approx. a year to complete. What this means for current and pending work and bug fixes.
3. Reassessment of all customizations, with the goal of getting as close to OOB as possible.

2 FTE for 1 year

data warehouse short term solution

Remove all dependencies to existing data warehouse

tbd

data warehouse long term solution

Provide a unified and clean view of Facilities data

Benefits:

1. Ability to remove some of the customizations from Tririga.
2. Provide analytical and transactional reporting across the organization for internal and campus use.
3. Consolidate Fleet billing
   

Requirement for removing existing customizations out of Tririga.

1. Creation of new unified data store for Facilities data.
2. Remote access protocol
3. Applications for accessing the data, which can be accessible from FACserv.

tbd. Needs to be done in parallel with Tririga upgrades.

Performance Improvement Groups

Recommend shift of focus to leading the upgrade process from the business perspective

Analytical Reporting

Incorporate into data warehouse solution

Paperless Timesheet Processing

Define scope of project:

1. Paperless process
2. Implementation of work schedules, which will automate overtime calculations and simplify the timesheet.
   
   Business Value:
3. Eliminates cost of DDM to scan and enter timesheets, retain scanned copies, and Facilities rework due to errors.
4. Eliminates cost of paper and ink
5. Eliminates cost of physically moving and tracking timesheets from off North Campus locations
6. Reduce time spent for payroll calculation
7. More timely billing - time will get into the system faster
8. Users will be able to view timesheets.

1. DDM does not have adequate controls for their part of the process.
2. Additional payroll controls needed

Depends on project scope

Inventory Management

Scope and direction needs to be determined. Will each shop become an inventory location. Will supervisors become inventory managers?

1.  Get Grainger inventory and ids into FACserv
2. If each shop is to be an inventory location, pilot with Sign shop.

tbd

Asset Tracking and Management

Recommend putting on hold and concentrating on the following:

1. FDX expansion to include all space
2. Incremental delivery of assets. Populate FACserv with just the basic asset information. No customizations to FACserv and provides general asset tracking. Does not include inspections and fine grained asset tracking.

FDX expansion. 1 FTE for 6 weeks

iPool replacement

Vendor could fold at any time

1. Build vs. buy.
2. Can fleet management be done in FACserv. It would have to be done around the upgrade schedule because FACserv will be frozen.
3. Purchase the source code. This will provide a temporary solution until the upgrade is completed and/or a long term solution is found.

tbd