90 likes | 305 Vues
Southern Ontario Maximo Users Group ( SOMUG ) Automation & Integration. Presented by… Mike Hausser, P.Eng Director of Asset Management and Support Services City of Cambridge. Implementation Objectives Business Intelligence. Embed business processes into technology Automate routine actions
E N D
Southern Ontario Maximo Users Group( SOMUG )Automation & Integration Presented by… Mike Hausser, P.Eng Director of Asset Management and Support Services City of Cambridge
Implementation ObjectivesBusiness Intelligence • Embed business processes into technology • Automate routine actions • Minimize Human Input • Leverage information you have • Present relevant information to user to support human decisions • Make relevant information to others to support external communications with minimal effort • Collect information to support iterative expansion of above objectives …
Summary of Examples • Quality control of information • Alerting senior staff of significant events and issues • Alerting asset management staff of changes in components • Dynamic routes to deploy crews and track issues that manage risks
Quality Control Example… • Need to ensure observations are input • Using escalations, identify specific workorders that are missing observations after labour entries have been entered. • Email supervisor of workorder
Alerting Senior Staff of Events… • Water main breaks, sewage backups, response to weather event… • Using escalations, filter by specific job plans, email senior staff within 10 minutes of workorder creation. • Budget / Expense alerts… • Extra fields added to ChartofAccounts table to record annual budget and background process updates expenditures daily. • Escalations identify when expenses are nearing and exceeding budgets.
Alert Asset Mgmt Staff on component changes.. • Valve replacements, service installations, manhole installs, etc… • Using escalations, when workorder status changes to Complete and specific worktypes, email AM staff.
Dynamic Routes… • Road inspections use ESRI ArcPad • Capture defects and issues • In GIS database, defects are processed into various lists based on various thresholds • Each list becomes a maximo route • MEA process refreshes maximo route asset/location list representing defects • Escalation will ‘activate’ PMs to generate a workorder if the maximo route has a list and ‘de-activate’ PMs when no asset/locations on route.
Metrics Reporting Program Planning Claims Mitigation Defects & Issues Road Needs Assessment (Condition) GIS (Defect Registry) 980 Lane*km Analytics (in GIS) Status Monitoring Updates Crew 1 - Day X Crew 1 - Day Y Work Orders in Maximo Organized by Type and Geography Crew 3 - Day Z Crew 2 - Day X Road Inspection Process
Questions… Mike Hausser, P.Eng Director of Asset Management and Support Services Transportation and Public Works City of Cambridge hausserm@cambridge.ca