Azteca Cityworks Upgrade Project
GeoIT Resources, Inc. is supporting the City of Sacramento Department of Utilities in a system-wide upgrade of the their existing Computerized Maintenance Management System (CMMS) based upon Cityworks Anywhere 4.5 (desktop based) to server-based Cityworks AMS 2013.
As part of the upgrade effort, the development team conducted a stakeholder needs assessment and workflow analysis to fully leverage the new environment and significantly streamline maintenance management workflows.
The upgraded Cityworks Server AMS 2013 servers are now in production and being utilized by the Wastewater group. GeoIT is currently supporting City staff during Q2 2014 as they take over the user training and rollout the system to the Drainage, Water Distribution, and Water Conservation groups (over 100 additional users).
One of the many highlights of the project is a GIS-based preventive maintenance (PM) scheduling layer created for the Wastewater group. The City expressed the need for a better way of managing preventive maintenance schedules on individual assets. Utilizing work history and condition data within Cityworks directly-linked to the GIS gives the Wastewater group a dynamic visual of where they need to prioritize their preventive maintenance work. Work order schedulers can logically group assets into preventative maintenance work orders more efficiently based on their maintenance status within their individual target windows and proximity (geography).
Another project highlight are the customized forms and panels that have been deployed. Some basic changes to the XML and CSS files made work forms more legible and utilize highlight colors to which City users were already accustomed. In addition, custom Quality Assurance panels were developed that provide a quick summary of the completion status of a work order or service request. The QA panels are useful to both the work crews in the field as an easy-to-use, color-coded, checklists and to supervisors reviewing the satisfactory completion of a work order (or service request) prior to closing.
GeoIT’s primary subcontractor on this project is Environmental Engineering & Contracting, Inc., providing proven experience at configuring and customizing Cityworks AMS.
Posted in Administrator Training, Application Design, Cityworks Implementation, Communcation Plan, Data Conversion, End User Training, Implementation Plan, Needs Assessment Report, Needs Assessments, Pilot Development, Project Management, Project Scheduling, Resource Planning, Risk Assessment, Software Installation, Stakeholder Interviews, System Architecture, System Design, System Implementation, System Integration, User Training, Water Wastewater Utility, Web Application Development, Workflow Analysis, Workplan Development
Tagged 10.1, 2013, administrator, AMS, Anywhere, ArcGIS Server, business process, Cityworks, CMMS, configuration, ESRI, integration, needs, PeopleSoft, phased, rollout, Sacramento, stakeholder, training, user, utilities, workflow
Work Management System Development
Mr. Hoefer was the project manager and system architect for the development of a 200+ user work management system for the City of Oakland, Public Works Agency utilizing Cityworks software from Azteca Systems as the foundation CMMS software. The $1.2M, two-year project included:
- Deployment of Cityworks Desktop and Server in a high-reliability system configuration two sets of parallel (redundant) servers
- Setup of an equivalent virtualized development, test, and training system using VMware
- System configuration, including: 500 employees, 68 different work groups, 280 service request templates, 300 work order templates, 340 unique tasks, and 16 department-specific map services (ArcGIS Server)
- User training for over 200 call takers, work supervisors, and work crew leaders
- System rollover from an aging call system and paper-based systems (log books) for work activities
- Deployment of over 100 field-based laptops (Panasonic Toughbook C-19) connected through Sprint Wireless
- 125-vehicle AVL deployment (Network Fleet) and ArcGIS Server integration
- Development, testing and deployment of a public service request intake website
The City of Oakland was one of the first major users of Cityworks Server in the country. The System has been well-received by City users, with new roles and users being added each year, and has provided significant financial and logistic benefits to the City.
Posted in Administrator Training, Application Design, Application Seminar, Cityworks Implementation, Client Type, Communcation Plan, Data Conversion, Data Development, Desktop Application Development, End User Training, Geodatabase Design, Hardware Installation, Implementation Plan, Mobile Application Development, Needs Assessment Report, Needs Assessments, Networking, Pilot Development, Project Management, Project Scheduling, Public Works Agency, RDBMS Setup, Resource Planning, Risk Assessment, Software Installation, Stakeholder Interviews, System Architecture, System Design, System Implementation, System Integration, User Training, Water Wastewater Utility, Web Application Development, Workflow Analysis, Workplan Development
Tagged ArcGIS, assessment, AVL, Cityworks, CMMS, design, enterprise, ESRI, fail-over, GIS, information, infrastructure, integration, management, medians, Network Fleet, Panasonic, parks, public, redundancy, service request intake, sidewalks, stormwater, streets, Toughbook, traffic signals, trees, virtualizaion
Information Technology Assessment
Mr. Hoefer was the lead consultant and project manager for an in-depth information technology assessment of a complex electronic database (system) being used by several divisions of Caltrans. He directed the technical research, conducted dozens of team interviews, compiled the resulting information, and progressively presented the results to a steering committee over the course of the 10-month project. Mr. Hoefer developed a series of enhancement recommendations that could accomplished within the available implementation funding and time window, as well as a long-term vision for an eventual replacement component architecture based upon Server Oriented Architecture (SOA) design principles. The project was well-received by the steering committee as the team was able to present highly complex subject material in an easily digestible fashion leading to a full consensus on the technological path forward.
Posted in Application Design, Client Type, Communcation Plan, Geodatabase Design, Implementation Plan, Needs Assessment Report, Needs Assessments, Project Management, Project Scheduling, Stakeholder Interviews, Strategic Plan, System Architecture, System Design, Transportation Agency, Workflow Analysis, Workplan Development
Tagged ArcGIS, assessment, Caltrans, design, enterprise, ESRI, geodatabase, GeoIT, GIS, highways, integration, needs, oriented, plan, service, SOA, transportation, web
Asset Management Workflow Review
Mr. Hoefer provided Anchorage Water and Wastewater Utility (AWWU) with an assessment of their geographic information system (GIS) and Maximo (IBM, Inc.) integration workflow environment. Mr. Hoefer performed a technical evaluation, reviewing the business processes, data models, and IT practices from the perspective of his knowledge of the GIS/IT industry as it applies to water utilities. The assessment was to find where AWWU may have departed from mainstream practices and make recommendations as to specific steps AWWU might need to take to make adjustments and move forward with its IT development.
Mr. Hoefer first conducted a onsite review of the existing asset management workflows. The review consisted of a series of meetings and staff interviews that engaged management and end users in discussions about the workflow and data models that would show any areas of concern.
After conducting the on site review, Mr. Hoefer provided AWWU with an Asset Management Workflow Review Report, which provided an assessment of AWWU’s workflows and GIS data model as compared to other utilities and recommended steps to remedy the issues discovered and presented technical alternatives as applicable. The document was well-received by both the Engineering and IT departments at AWWU.
Posted in Client Type, Needs Assessment Report, Needs Assessments, Stakeholder Interviews, System Architecture, System Design, Water Wastewater Utility, Workflow Analysis
Tagged ArcGIS, AWWA, CMMS, design, editing, enterprise, ESRI, geodatabase, GIS, information, infrastructure, integration, management, Maximo, sewer, utility, water, workflow