Enterprise Asset Management Solutions

Geographic Information System plays an vital role in Asset Management for Electric, Gas and Water utilities. We design and develop end to end solution for complete Asset Life cycle for Assets such as Pipes, Valves, Transformers, SupportStructures, Fittings & Manholes.  We also design and automate syncing process to update both GIS and EAM systems based on CRON Tasks, REST Services, Geoprocesing tasks. 

 Enterprise GIS holds both Location and Asset info in geographical context  which is extensively used to deploy field crews, create Service Requests, Workorders against the Asset to be serviced or replaced.  

With our experience we can quickly identify and formulate data source matrixfor Locations, Location Specifications,  Assets, Asset Specifications & System Of Record. We create data mapping excel sheets to run and configure FME, other ETL tools to extract Source and update Target attributes.   

 
 
IbmMaximo2.jpg

Asset Management Integration

IBM Maximo is leading the Asset Management software used in Electric and Gas industries. Maximo is system of record for all Assets and Locations. Based on the utility standard operating procedures the Attributes are synced between GIS and Maximo systems. The maintenance records such as Installation Date, Inspection Date, Owner are synced between system for FERC reporting purposes. The attributes are identified and classified as source and target in each system and the attributes are synced between two systems using Maximo Automation Scripts, CRON Tasks, Published Channels, JSON Mapping and ESRI Rest Services. The sync process will not only sync attributes but also designed to maintain the data integrity between two systems such as Asset/Asset Specifications, Location/Location specifications, Parent / Child Workorders, WorkOrder/Task relationships.

Softwares

ESRI REST Services, Python Scripts, ArcGIS Desktop, ArcFM Designer, Oracle 11c, IBM Maximo 7.5.0.1, Maximo Automation Scripts, Launch Points etc.

Tools

Visual Studio, Javascript, JSON, SQL Developer, Eclipse, Notepad++, GrayLog

 
SAP.png

SAP Asset Management Integration

SAP® Work Management -Plant Maintenance module is also a popular software used for Asset Management software used in Electric and Gas industries. SAP® is system of record for all Assets and Locations. Based on the utility standard operating procedures the Attributes are synced between GIS and SAP systems. The maintenance records such as Installation Date, Inspection Date, Owner are synced between system for FERC reporting purposes.

Softwares

ArcGIS Desktop, ArcFM Designer, Oracle 11g, SAP

Tools

Visual Studio, Javascript, JSON, SQL Developer, Notepad++

 
Oracle.png

Oracle Asset Management Integration

As always Oracle is system of record for all Assets and Locations.  The attributes are synced between GIS and Oracle.  The GIS changes are captured through version differences and updated into Oracle Staging tables. The records in Staging table are compared with Oracle WAM  and updated in Oracle. It can be a two way sync but mostly it is one way sync to Oracle. 

Softwares

ArcGIS Desktop, ArcFM Designer, Oracle 11g, Oracle Apps 11

Tools

Visual Studio, Javascript, JSON, SQL Developer, Eclipse, Notepad++