CMMS Implementations

From fragmented records to operational maintenance systems

Across these engagements, maintenance information and work processes were often held in text files, spreadsheets, and locally developed records. Implementing a computerized maintenance management system required more than importing that data: equipment structures, maintenance practices, responsibilities, and work processes had to be translated into a coherent operational model.

My role

I was responsible for the implementation path from requirements gathering through data conversion, system configuration, rollout, and user training. I worked with engineers from multiple disciplines at industrial sites to understand their equipment, maintenance practices, and existing workflows.

I translated those requirements into asset hierarchies, preventive and predictive maintenance structures, work-order processes, and KPI and reporting structures. This work required connecting the database model and system configuration to how maintenance was actually planned and performed.

Data migration and implementation tooling

A substantial part of each implementation involved converting legacy maintenance and equipment data from text files and Excel spreadsheets into structured databases. I wrote SQL scripts for these conversions and developed a utility that generated further conversion scripts, allowing parts of the site-specific migration logic to be produced programmatically.

The resulting systems combined converted maintenance records with configured asset structures and work-management processes. I also prepared and delivered training to support adoption by the people who would operate and maintain the systems.

Delivery evidence and limitations

Approximately ten CMMS implementations were delivered across manufacturing and petrochemical environments. The present evidence is the completed implementation work—including requirements, migration, configuration, and training—rather than a later commercial software product.

No verified post-implementation measures of downtime, maintenance cost, data quality, or user adoption are currently available. This entry therefore does not claim quantified operational improvement.

Foundation for later research

Working directly with industrial equipment, maintenance teams, and site-specific processes gave me a practical understanding of CMMS and industrial ERP implementation, asset and work hierarchies, preventive maintenance, predictive maintenance, and condition-based maintenance.

Many of the questions I later investigated through my master’s and doctoral research were motivated by this implementation experience. The delivered systems and the publications represent different aspects of the same trajectory: one concerns implementing maintenance systems in practice; the other concerns investigating the underlying methods and technical questions.