BOARD MEETING DATE: April 10, 1998 AGENDA NO. 12




PROPOSAL:

Amend Contracts with COMSYS Technical Services, Cordoba Corporation, Majesco Software, Inc., and Sierra Cybernetics to Provide Short- and Long-Term Systems Development and Maintenance Support

SYNOPSIS:

The AQMD currently has task order-type contracts with four companies for short- and long-term system development services. These contracts are amended as additional automation needs are identified. This action is to amend the contract with the four companies. Funds for these services ($245,000 to COMSYS Technical Services, $252,630 to Cordoba Corporation, $446,070 to Majesco Software, Inc., and $335,550 to Sierra Cybernetics, Inc.) are included in the FY 1997-98 Budget.

COMMITTEE:

Administrative, March 20, 1998, Recommended for Approval

RECOMMENDED ACTION:

Authorize the Chairman of the Board to execute amendments to the contracts for systems development services with COMSYS Technical Services, Cordoba Corporation, Majesco Software, Inc., and Sierra Cybernetics to increase the contract amount for each by $245,000, $252,630, $446,070, and $335,550 respectively.

Barry R. Wallerstein, D.Env
Acting Executive Officer


Background

At the February 14, 1997 meeting, the Board approved contracts with several vendors for systems development services, both routine system maintenance for newly migrated systems and additional system development. At the time these contracts were executed, it was expected that the contracts would be modified in the future to add funding from approved budgets as system development requirements were identified and sufficiently defined so that task orders could be prepared. At the September 12, 1997 meeting the Board approved amendments to the contracts to add additional funds.

These contracts are Basic Ordering Agreements where individual task orders are issued on a competitive basis. Development efforts are needed to enhance system functionality and to provide AQMD staff with additional automation for improving productivity. At the same time, Information Management is developing and/or acquiring systems capable of efficiently implementing new and evolving rules such as RECLAIM and NSR rules. The estimated cost to complete the work on these additional system development tasks exceeds the amount of funding in the existing contracts.

The current contracts are for one year with the option to renew for two one-year periods. Renewal of these contracts is contingent upon performance, competitiveness, percent of tasks bid, and overall customer satisfaction. The Mosakin Corporation has failed to bid any task orders during the contract period and the option to renew will not be executed.

This item is listed on the "Status Report on Major Projects for Information Management Scheduled to Start During Last Six Months of FY 1997-98."

Proposal

The contracts should be amended to add additional funding in the amount of $1,279,250 to cover this anticipated effort: $245,000 for COMSYS Technical Services, $252,630 for Cordoba Corporation, $446,070 for Majesco Software, Inc., and $335,550 for Sierra Cybernetics.

Resource Impacts

Funds for these services are included in the Fiscal Year 1997-98 Budget.

Funding Totals, By Contractor:

Funding to Date

This Addition


Contractor

FY 96-97

FY 97-98

FY 97-98

Total

COMSYS Tech. Svcs.

$372,834

$150,000

$245,000

$767,834

Cordoba Corporation

0

$100,000

$252,630

$352,630

Majesco Software Inc.

$337,833

$300,000

$446,070

$1,083,903

Mosakin Corporation

$125,000

0

0

$125,000

Sierra Cybernetics

$337,833

0

$335,550

$673,383

TOTALS

$1,173,500

$550,000

$1,279,250

$3,002,750

Task Orders Awarded to Date:

Company

Task Order No.

Task Order Title

Amount

COMSYS

IM01-97

CLASS Compliance System/16- to 32-Bit Migration

$18,816

COMSYS

IM02-97

New System Development/Hearing Board

$114,630

COMSYS

IM04-97

Finance Systems/Address Modifications

$7,250

COMSYS

IM09-97

Financial Systems Remote Procedure Revision

$32,680

COMSYS

IM13-97

Financial System, Finance Enhancements I

$20,940

COMSYS

IM15-97

Interim Title V Tracking

$8,030

COMSYS

IM17-97

Financial System, Facility Transfers

$12,870

COMSYS

IM18-97

Financial System , 16 to 32-Bit Migration

$11,084

COMSYS

IM19-97

Agenda Tracking System Migration

$38,900

COMSYS

IM21-97

Contracts Tracking System New System Development

$45,080

COMSYS

IM29-97

Ad Hoc Reporting

$13,440

COMSYS

IM36-97

Document Imaging System Migration RFP Work Stmt

$12,690

CORDOBA

IM30-97

Rule 461 Permit Processing

$57,638

CORDOBA

IM31-97

STAR Permit Processing

$58,828

MAJESCO

IM03-97

Facility Permit System/16- to 32-Bit System

$53,200

MAJESCO

IM05-97

Rule 301 Fee Changes

$31,000

MAJESCO

IM06-97

AQMD Permitting System/16- to 32-Bit Migration

$38,200

MAJESCO

IM08-97

Title V Tracking System, Part I

$99,800

MAJESCO

IM08-97

Title V Tracking System, Part II

$51,800

MAJESCO

IM10-97

RECLAIM Trading System and PowerBuilder Migration: Trading Screens

$52,300

MAJESCO

IM11-97

RECLAIM Trading System and PowerBuilder Migration: Reports and RTC Adjustment Screens

$52,300

MAJESCO

IM12-97

RECLAIM Trading System and PowerBuilder Migration: Facility and Certificate Information Screens

$49,800

MAJESCO

IM16-97

AQMD Permitting System Enhancements

$10,180

MAJESCO

IM20-97

CLASS Compliance System

$27,800

MAJESCO

IM24-97

AQMD Permitting System: Application Tracking

$24,840

MAJESCO

IM25-97

CLASS Permitting System

$38,540

MAJESCO

IM32-97

Finance System Cancelled Applications

$11,580

MAJESCO

IM33-97

Finance System Facility Permit Billing

$54,400

MAJESCO

IM35-97

Finance System AQIP Posting Screens

$10,130

SIERRA

IM07-97

16- to 32-Bit Migration of the Current Central Station Computer System

$45,550

SIERRA

IM14-97

Smoking Vehicle Tracking

$39,740

SIERRA

IM22-97

Finance System Invoice Printing

$25,757

SIERRA

IM26-97

Finance System Replacement

$40,827

SIERRA

IM28-97

Web Access to Emission Reporting System

$15,849

SIERRA

IM34-97

B of A Link System 16- to 32-Bit Migration

$15,317

Task Order Awards Pending Board Approval:

Company

Task Order No.

Task Order Title

Amount

COMSYS

IM38-97

Database & Application Migration DBEDS to DBCIR

$117,500

COMSYS

IM50-97

Permit Streamlining: R219 and R222

$50,000

COMSYS

IM51-97

Hearing Board: 518.2

$77,500

CORDOBA

IM30A-97

R461 Permit Processing

$17,000

CORDOBA

IM40-97

Small Business Enhancements

$19,300

CORDOBA

IM41-97

CLASS Library Identification

$5,000

CORDOBA

IM44-97

Chief Prosecutor’s Office New System Development

97,230

CORDOBA

IM47-97

Central Station: APEP, Mapping & RECLAIM Audit

$89,100

CORDOBA

IM52-97

Permitting System: R1401

$25,000

MAJESCO

IM12A-97

Trading System Enhancements

$50,000

MAJESCO

IM24A-97

Permitting System: Application Tracking

$68,880

MAJESCO

IM33A-97

Finance System: Facility Permits Billing

$75,990

MAJESCO

IM39-97

STIMS/CEMS Migration

$59,000

MAJESCO

IM43-97

Facility Permits: Prescreening and Fee Module

$139,000

MAJESCO

IM46-97

Compliance System: RECLAIM & Title V

$53,200

SIERRA

IM37-97

Finance Enhancements

$170,000

SIERRA

IM45-97

New Source Review New System Development

$87,000

SIERRA

IM48-97

Public Access to AQMD Records

$78,550

/ / /