1 / 28

The University of Newcastle Facilities Management

The University of Newcastle Facilities Management. Maximo Key, Swipe card and Lock change request system project 2009 NSW & ACT Maximo User Group meeting 8 th October 2009. The University of Newcastle. Multi-Campus institution: Newcastle (Callaghan) Newcastle (City Precinct)

ulysses-watkins
Télécharger la présentation

The University of Newcastle Facilities Management

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. The University of Newcastle Facilities Management Maximo Key, Swipe card and Lock change request system project 2009 NSW & ACT Maximo User Group meeting 8th October 2009

  2. The University of Newcastle Multi-Campus institution: • Newcastle (Callaghan) • Newcastle (City Precinct) • Central Coast (Ourimbah) • Port Macquarie • Singapore • Sydney presence • Tamworth • Taree • Orange • Armidale • Hospital affiliation (JHH, Mater)

  3. University Statistics: • Over 30,000 students • 2190 FTE staff • $475m revenue • 220 buildings • Asset Replacement Value $1,282M • Australian Top 10 for research • Comprehensive range of teaching programs • Multiple campuses • International students from over 80 countries

  4. Callaghan campus • Bushland campus (…”a million trees”) • Established 1951 • Located in Newcastle suburbs • University’s largest campus • Single-sector campus • 21,000 EFTSL • 140 Buildings • 140 Hectare site • 277,000 GFA • 936 student beds on campus

  5. The University of Newcastle Maximo Overview • Version 6.1 • Live January 2007 • All UoN staff can log requests • Maintenance requests • Cleaning Requests • Relocation Requests • Key, swipecard and lock change requests • Minor Works Requests (future November 2009)

  6. The University of Newcastle • Project: Key, Swipe card and Lock Change Request system in Maximo • Background • Previous system paper based • Previous database custom built, Access 97 based & no longer supported • No electronic record kept of keys issued

  7. The University of Newcastle Requirements in New System: New form to be added to existing Maximo Service Request forms Workflow for approval and key / swipe card issue to be developed New database for key and lock data to be developed Previous Access 97 data to be imported into new database

  8. The University of Newcastle Test Database Demonstration: New Request form Key and Lock database

  9. The University of Newcastle Key, Swipe Card & Lock Change Implementation Overview: New system live July 2009 274 Standard Key Requests processed 108 Swipe Card Requests processed 10 Lock Change Requests processed 23 Master Key Requests processed 3912 keys in database 3911 locks in database

  10. 10 Matrikon™ Locks and Keys. The System Developer’s Perspective.

  11. Analyze Visualize & Collaborate Field Instrumentation Aggregate & Contextualize Collect Data ERP / Business Systems 11 Our Vision Enable & sustain Operational Excellence by better managing your data, assets and operations Partnersin Vision • Matrikon Products & Solutions • Improve asset reliability • Optimize process performance • Better manage production TechnicalInnovation • Over 60% of Global 500 • Over 10,000 installs • Only provider of complete solution • Global operations How We Do itRole-based web visualization of integrated operational and maintenance data, in context, across the enterprise Industry Expertise

  12. Who is Matrikon? 12 Other150+ Complete Solution Provider Consultants275+ R&D100+ • 550 employees • 300+ consultants with extensive domain expertise • Complete services, from planning to execution Global Presence • 18 offices • 17 Partners • Leading clients world-wide

  13. Audit & assessment IBM-Maximo technology deployment & upgrades System design Condition-based maintenance IBM-Maximo Consulting Team 13 Consultants with 100+ combined years of IBM-Maximo experience Services Stats Sinclair Energy, Meridian Energy, Alberta Health Services, International Power SelectClients Total Resource Management, Cohesive Solutions Comp. 30 consultants worldwide Resources

  14. System Design Process 14 The design process was broken up into two components… • Requirements Discovery • System Development

  15. Requirements Discovery 15 • Understanding the current system operation. • This was achieved through...

  16. Requirements Discovery 16 • Interviews with key system users • Current system functionality review • Identification of system workflows • Identification of data sources (2 different systems for existing campuses) • Identification of “Wish List” items for system enhancements

  17. Requirements Discovery 17 • Documentation of the current system • Documentation of the requirements for the new system • Preparation of detailed design documentation • System costing

  18. System Development 18 • Database Object Development The system was developed using the following custom objects…

  19. System Development 19 • Custom hierarchical tables • Custom database views • Custom actions • Custom domains • Custom relationships

  20. Application Development 20 • The system required a number of custom applications to be developed • 11 custom application definitions (XML) were created for this project

  21. Application Development 21 • Custom Key Request Application • Keys Application • Key Inventory • Key Transactions • Swipe Card Transactions • Locks Application • Lock Inventory • Lock Transactions

  22. Programming Development 22 • In order to provide the required functionality, 28 custom classes were developed utilising in excess of 1000 lines of custom java code.

  23. Workflow Development 23 • Existing workflows were customised to incorporate the new workflow requirements.

  24. Testing and Migration 24 • System testing • System migration between environments • Data migration • Development of training documentation • System rollout

  25. Data Migration Process 25 • The locks and keys data was originally held by the UoN in various sources (paper based) • This data was defined and sorted

  26. Data Migration Process 26 • Developed scripts to create Key Safe objects • Using the data obtained, cleansing and concatenation rules were developed for each object

  27. Data Migration Process 27 • The cleaned data was used to generate data insert scripts • 22163 Standard Insert Statements • 10436 Recursive Insert Statements • 32599 Total Inserts in final scripts for data migration

  28. DISCUSSION A presentation to the NSW & ACT Maximo user group. 8th October 2009

More Related