An information technology (IT) consulting firm in the Seattle area, Active Solutions provides consulting and programming services for the IBM's Tivoli brand of Asset Management solutions based on Maximo. Our skills include: - System Administration, including Database Configuration, Workflows, Escalations, Conditional Expressions, Application Designer, Security, etc. - Reporting with BIRT and (for Maximo 7.x, via External Report Integration) Actuate, SSRS, Crystal Reports. - SQL programming for Oracle, SQL Server, DB2 including: Oracle packages - functions and stored procedures; views SQL Server user-defined functions, stored procedures, and views and scheduled jobs; SSIS packages DB2 queries, views - Development of TRM Rules Manager Rules - Maximo functional consultant available for Supply Chain, T & D add-on, Work Management - Professional Mechanical Engineer available for: Development of Asset / Location hierarchies and relevant Problem / Cause / Remedy codes for determination of root cause and corrective action for operational failures. Development of optimized maintenance programs using asset classification. Identification of dominant failure modes and life distributions by asset class and use of this information for determining maintenance tasks and frequencies. Implementation of system design and procedural changes to improve system availability, i.e. maintaining spares, predicting failures, & condition-based maintenance.