Oracle CC&B Support - Grant County PUD
Grant County PUD is in the process of upgrading their existing Customer Information System to Oracle’s Customer Case and Billing (CC&B) System. CaseIntel is providing setup, on-going maintenance and support of the Grant County PUD’s Oracle production, development and test databases within the newly installed Oracle CC&B environment. The full scope of the CaseIntel services includes:
Setup and installation of the District’s Oracle production, development and test environments and databases.
Oracle database configuration and operations support.
Oracle operations policy guidance and development.
Backup and recovery plan development and implementation.
Data migration process guidance and assistance.
Performance analysis, configuration and tuning.
Environment configuration, including software configuration management and promotion/migration process development.
Oracle security analysis, policy development and implementation.
Oracle security integration with existing authentication and authorization mechanisms (e.g. Active Directory).
High availability configuration planning and implementation.
Disaster recovery planning and implementation.
Legacy applications data modeling, analysis and data integration planning.
Award Date: December 2013, Completion Date: Ongoing
AUD/NetGIS Integration - Autodesk, Inc.
Seattle City Light is currently in the process of implementing the Autodesk Utility Design solution to support the design and maintenance of their network and looped radial distribution systems. The AUD product needs to interface to Seattle City Light's implementation of CaseIntel's NetGIS product. CaseIntel is providing Autodesk with business and requirements analysis support, technical advice, and the software design and development for interfaces between the two systems.
Award Date: June 2013, Completion Date: Ongoing
Southwest Power Pool CMT - Alstom Grid
The Centralized Modeling Tool is a centralized repository of effective dated generation
and load asset, and transmission line configuration data for Southwest Power Pool.
SPP market participants enter and configure asset information using Alstom's e-terrasource™
tool. Data is then transferred to the centralized data base using a SOA
based CIM/XML file transfer process. Once inserted into the centralized model
database, asset and line data is available for consumption by downstream systems
such as the market system, and the settlements system. CaseIntel provided the design
and implementation of the Oracle based centralized model database, design and
implementation of the SOA based CIM/XML data transfer process, and development of
custom PL/SQL extensions to Alstom's e-terrasource™ product to meet specific SPP
Award Date: December 2011, Completion Date: June 2013
Elbow Extraction Process for SnoPUD - Intergraph Corporation
Snohomish PUD employs the Intergraph G/Technology product for their GIS. Elbow
equipment data is not currently present in their GIS, but is required for integration of the
GIS with Snohomish PUD's implementation of the Alstom DMS (Distribution
Management System) product. CaseIntel designed and developed a custom Oracle
PL/SQL based extraction process to use GIS asset and distribution line conductor data
to infer the existence of elbow equipment in the SnoPUD electrical distribution system.
This dataset was then configured with G/Technology specific feature data for use not only for
the DMS, but within the GIS as well.
Award Date: January 2012, Completion Date: July 2013
Oracle & Topobase Support - Grant County PUD
Grant County PUD is currently using the Autodesk Topobase product for certain GIS
data. CaseIntel is providing remote Oracle RDBMS administration and support for the
Topobase database, as well implementing disaster recovery, environment configuration,
and change control processes and documentation.
Award Date: July 2011, Completion Date: Ongoing
NetGIS Ancillary Maps Tool - Autodesk, Inc.
The Ancillary Maps Tool is a configured module add-on to the CaseIntel NetGIS product
implementation for Seattle City Light. This tool uses data from City of Seattle’s ESRI
GIS system and NetGIS to dynamically generate and configure primary feeder, primary
load flow, and secondary distribution maps for its network distribution system.
CaseIntel is providing all requirements and business analysis, and software design and development.
Award Date: September 2011, Completion Date: Ongoing
Snohomish PUD Alstom Formatter - Intergraph Corporation
Snohomish PUD has implemented the Alstom DMS product which requires asset and distribution line data from the GIS. CaseIntel provided the software design and development for an interface tool that translates data from the Intergraph G/Technology GIS system to CIM/XML based files for consumption by the Alstom DMS system.
Award Date: July 2011, Completion Date: December 2011
FBI NGI AFIS - MorphoTrak
The Automated Fingerprint Identification System manages fingerprint analysis data for the US Federal Bureau of Investigation. CaseIntel provided MorphoTrak with Oracle RDBMS security hardening processes and procedures to meet DoD STIG requirements, disaster recovery processes and procedures, and Oracle database administration and environment configuration. CaseIntel also designed and developed a very large scale high availability database configuration (Oracle RAC & Dataguard) to meet the unique application server memory space requirements for MorphoTrak's AFIS application.
Award Date: February 2010, Completion Date: April 2012
US Visit AFIS - MorphoTrak
The US Visit Automated Fingerprint Identification System manages fingerprint analysis data for the US Department of Homeland Security. CaseIntel provided MorphoTrak with Oracle RDBMS security hardening processes and procedures to meet DoD STIG requirements, disaster recovery processes and procedures, and Oracle database administration and environment configuration. CaseIntel also designed and developed a high availability database configuration (Oracle RAC & Dataguard) to meet the unique application server memory space requirements for MorphoTrak's AFIS application.
Award Date: February 2010, Completion Date: June 2011
Work and Asset Management Timekeeping - Seattle City Light
CaseIntel previously designed and developed a crew timekeeping module for Seattle City Light's Maximo asset management system. Seattle City Light subsequently purchased and implemented the Oracle Work and Asset Management System as a replacement for some of its asset management needs. CaseIntel designed and developed a port of the custom Maximo timekeeping module for the Oracle WAMS implementation. CaseIntel also conducted requirements analysis sessions with Seattle City Light generation staff to implement a number of functional additions and enhancements to the timekeeping module.
Award Date: July 2010, Completion Date: December 2011
G/Technology – FRAMME Integration for Omaha Public Power District - Intergraph Corporation
CaseIntel designed and developed a data integration process for Intergraph customer Omaha Public Power District. OPPD uses the Intergraph G/Technology product for their GIS data, and wanted G/Technology data synchronized to its legacy FRAMME system. CaseIntel provided a production ETL process that continually updates FRAMME from G/Technology.
Award Date: December 2009, Completion Date: April 2010
Database Administration Support for HECO - Intergraph Corporation
CaseIntel provided Hawaii Electric Company with the design and configuration of a high availability database solution using Oracle Dataguard for the database supporting HECO's outage management wallboard application. CaseIntel provided Oracle database administration support and Oracle Dataguard training for HECO's internal database support staff.
Award Date: November 2009, Completion Date: December 2009
NetGIS Development & Deployment - Seattle City Light
CaseIntel partnered with Seattle City Light to develop the NetGIS product for the utilities’ Network Engineering group. NetGIS was developed in close collaboration with Seattle City Light to meet the unique electrical modeling needs of their underground network electrical distribution system. NetGIS uses the Oracle RDBMS, Oracle's spatial data capabilities, the AutoCAD Map tool and a set of custom developed plug-ins to the AutoCAD product.
Award Date: June 2007, Completion Date: Ongoing