HomeMy WebLinkAbout2003-124
.'
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
RESOLUTION NO. 2003-124
RESOLUTION OF THE MAYOR AND COMMON COUNCIL OF THE CITY
OF SAN BERNARDINO AUTHORIZING THE MAYOR TO EXECUTE A MASTER
SERVICES MEMORANDUM OF UNDERSTANDING WITH THE WATER
DEPARTMENT FOR PROVISION OF CITY SERVICES FOR FISCAL YEAR
2003/2004.
BE IT RESOLVED BY THE MAYOR AND COMMON COUNCIL OF THE
CITY OF SAN BERNARDINO AS FOLLOWS:
SECTION 1. The City of San Bernardino ("City") provides certain services to the
Water Department ("Department") for which the Department compensates the City; and
WHEREAS, it is the desire of the City and the Water Department to enter into a
Memorandum of Understanding to memorialize these services;
NOW, THEREFORE, BE IT RESOLVED by the Mayor and Common Council of
the City of San Bernardino that the Master Services Memorandum of Understanding between
the City and the Water Department setting forth the services that are to be provided by the City
to the Water Department and the compensation to be paid therefore, a copy of which is attached
hereto and incorporated herein as Exhibit A, is hereby adopted,
SECTION 2. The Mayor of the City of San Bernardino is hereby authorized and
directed to execute on behalf of said City a Master Services Memorandum of Understanding,
SECTION 3. The authorization granted hereunder shall expire and be void and of no
further effect if the agreement is not executed and returned to the Office of the City Clerk
within 60 clays following the etfective date of this resolution,
/11
III
2003-124
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
RESOLUTION OF THE MAYOR AND COMMON COUNCIL OF THE CITY
OF SAN BERNARDINO AUTHORIZING THE MAYOR TO EXECUTE A MASTER
SERVICES MEMORANDUM OF UNDERSTANDING WITH THE WATER
DEPARTMENT FOR PROVISION OF CITY SERVICES FOR FISCAL YEAR
2003/2004.
I HEREBY CERTIFY that the foregoing Resolution was duly adopted by the Mayor
jt.
and Common Council of the City of San Bernardino at a regular meeting thereof, held on the
16th day of June
,2003, by the following vote, to wit:
NAYS
ABSTAIN ABSENT
Council Members:
AYES
x
ESTRADA
LONGVILLE
x
x
MCGINNIS
x
DERRY
x
SUAREZ
x
ANDERSON
MCCAMMACK
x
~~)J,c~
City Clerk
The foregoing resolution is hereby approved this
/
!
l <:tn,
2003,
S"Gsan Longvill ayor Pro Tern
City of San Bernardino
Approved as to
form and legal content:
James F, Penman,
City Attorney
"
2003-124
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
MASTER SERVICES
MEMORANDUM OF UNDERSTANDING
THIS MEMORANDUM OF UNDERSTANDING is made and entered into
by and between the City of San Bernardino, a charter city
("Ci ty"), and the Board of Water Commissioners of the City of
San Bernardino ("Board"), who agree that the City shall provide
services and the Board shall compensate City therefore as
follows:
1. EQUAL EMPLOYMENT OFFICER. The City shall provide to
the City of San Bernardino Municipal Water Department
("Department") the services of its Equal Employment Officer at a
flat annual rate of $25,000.
2, CITY ATTORNEY. The City Attorney shall act as General
Counsel to the Department and perform all of its legal work.
The City Attorney shall assign sufficient staff to perform the
legal services needed by the Department, and such services shall
be given priority.
Outside Counsel.
The parties contemplate the
A.
continued need for the Department to utilize services of outside
special counsel, partir.ularly in water rights matters. The City
At torney and the Department shall jointly determine when the
services of outside counsel are required and Department staff
shall consult with and obtain the approval of the City Attorney
prior to the employment of outside counsel and prior to the
assignment of matters to such counsel.
. All outside counsel
shall keep the City Attorney informed of their work and provide
-1-
"
2003-124
1 to the Ci ty Attorney copies of any and all correspondence and
2 documents filed in any court on Department matters and any
3 agreements to hire outside counsel shall be required,
4 B. Support Staff. In connection with providing the
5 foregoing services, the City Attorney's office will provide
6 sufficient secretarial, paralegal and investigator support
7 services.
8 C. Data to be Furnished to the City. The following
9 has been and will continue to be furnished by the Department to
10 the City: All records and information pertaining to legal
11 requirements of the Department, including any back-up materials,
12 applicable regulations, correspondence, preliminary drafts of
13 agreements, if any, and any other material pertaining to the
14 Department necessary for the performance of legal services.
15 D. Compensation.
16 (1) Attorney Services. It is anticipated that
17 the services to be supplied by the City Attorney will
18 constitute, on the average, an amount equal to fifty percent
19 (50%) of the time of one Deputy City Attorney
20 (2) Secretarial Services. It is anticipated
21 that the services to be supplied by the Legal Secretary will
22 constitute, on the average, an amot.:nt equal to fifty percent
23 (50%) of the time of one Legal Secretary I.
24 (3) Other Support Services. There shall be no
25 charge for paralegal or investigator services.
26 City Attorney services shall be provided to the
27 City of San Bernardino Water Department at a flat annual rate of
28 $80,000.
-2-
"
2003-124
1 3. CIVIL SERVICE, Department shall pay to City
2 for services of its Chief Examiner and for Civil Service
3 Administration an annual flat fee of $45,000, Typical services
4 shall include, but not be limited to, testing and certifying
5 eligible employees for outside recruitment and promotions,
6 approving job descriptions, minimum qualifications, and testing
7 standards for positions in the Department, and administra ti ve
8 hearings on discharges and reductions in rank or compensation.
9 4. EMPLOYEE ASSISTANCE PROGRAM. Department shall pay to
10 City the actual cost of services to Department's employees of
11 the Employee Assistance Program. "Actual cost" will be defined
12 as the hourly rate charged by the Employee Assistance Program
13 provider, currently $50 per hour.
14 5. RIDESHARE COORDINATOR. Department shall pay to City a
15 flat annual rate of $3,000 for the services of its Rideshare
16 Coordinator, who shall provide services to Department employees
17 as required by the Air Quality Management District (AQMD)
18 including, but not limited to:
19 A. Developing, updating and implementing a Trip
20 Reduction Plan and complying with all other AQMD Regulation
21 requirements;
22 B. Promoting the Trip ReJuction Plan and rideshare
23 activities, and tracking and documenting employee participation;
24 C. Acting as a liaison with AQMD and attending all
25 training, meetings and workshops as required by AQMD,
26 6, TELEPHONE SERVICES. Department shall pay for the use
27 of City's telephone system at the actual monthly telephone
28 charges attributable to the ports assigned to the Water
-3-
[,
2003-124
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
Department, Water Yards, Water Reclamation Plant and RIX Plant,
plus a proportionate share of the fixed costs of operations,
debt retirement/system hardware, and leased lines, based upon
the portion of total telephone ports assigned to the Water
Department, Water Yards, Water Reclamation Plant and RIX Plant.
7, WORKERS' COMPENSATION ADMINISTRATION. Department
shall pay to City for the administration of its Workers'
Compensation Program, its proportionate share of the budgeted
cost of administration based upon budget payroll costs, provided
that the Department provides to the City the budget figures for
payroll wi thin a reasonable time after Department's budget is
adopted, For any year in which payroll figures are not made
available to the City in a timely fashion, the percentage shall
be the same as that used for the prior year. For fiscal year
2003/2004, this shall be seventeen percent (17%). In addition,
the Department shall pay the actual cost of the amount paid out
on its claims.
8. INFORMATION SERVICES (IS).
A, Services. The IS Director will act as a private
contractor to provide the Department IS related services as
def ined in the attached agreement (Exhibit "AU) incorporated
herein by reference upon approval by the Board of Water
Commissioners and the City of San Bernardino.
B, Compensation. The agreed upon cost to provide this
service is a flat fee of $373,400.
9, TERMS, This Memorandum of Understanding shall terminate as
of June 30, 2004, unless terminated by either party at least
thirty (30) days prior to July 1, 2004,
-4-
APPROVED AS TO FORM AND
19 LEGAL CONTENT
20
21
22
I
8
9
10
11
12
13
14
15
16
17
18
23
24
25
26
27
28
2003-124
1 MASTER SERVICES
2 MEMORANDUM OF UNDERSTANDING
3 By and between the City of San Bernardino and the Board of Water
4 Commissions of the City of San Bernardino for the provision of
5 City services for Fiscal Year 2003/2004.
6
7
BOARD OF WATER COMMISSIONERS
Date: ~~
C~~.Vi-!/f'_ &f)-,<--
'B. Warren Cocke, President
10 ?/Jo3
f
St~f!!tt~ary
Date :-j"1.t1E ) 9\ '2 ()o3
ATTEST:
@~rk~rk
Attorney
-5-
~....
I . .' .
2003-124
Exhibi t "Au
1.5. CONTRACT SERVICES
FISCAL 2003/2004
This document details the services Information Services proposes to provide to the Water
Department during fiscal 2003/2004 at a contract price of $ 373,400.
Office Automation
. Provide technical assistance for Water Department office automation servers and
domain controllers
. Troubleshoot "malfunctioning" Microsoft operating systems and Office products
(Word, Excel, Access),
. Provide use of the City's office automation server and BackOffice Automation
service,
. Create, delete, and alter network accounts, scripts, and user folders on the City
office automation server as required,
. Create, delete, set security and alter email public folders and mailboxes,
. Maintain virus software on client and server PCs, Includes installation and
upgrades of virus software (semi-annual), virus scan engine (quarterly), and new
virus pattem files as they become available,
. Provide Outiook training classes as needed,
. Audit email content and usage upon request.
GIS
. Provide maps and/or reports as requested, (Large maps and special papers are
available at cost of materials,)
. Add Water district layers as required to ArcGIS,
. Continue ArcGIS training and establish an intemal City ArcGIS user group,
. Provide access to County Assessor data through the parcel layer,
. Provide access to year 2000 census data,
. Provide access to appropriate GIS layers,
2003-124
'.
Web Site
. Provide web site hosting on the City web server.
· Facilitate direct access to Water Department content on the City web server
through Microsoft FrontPage web site authoring software, The Water Department
is responsible for the purchase of Microsoft Frontpage,
. Provide limited web page design and development services,
. Publish web site content provided by the Water Department to the City web server.
. Provide web server administrative services including performance monitoring,
system tuning, system security, and installation of server software upgrades and
service packs,
. Maintain sbcitywater,org domain name system service,
Network
. Provide access to the City's TCP/IP network via digital spread spectrum radio
bridges,
. Provide access to the Internet via T-1 digital line,
. Set up and maintain Intemet access accounts to facilitate web browsing by
authorized individuals,
. Provide secure inbound and outbound Internet mail service using the SMTP
protocol.
. Design, configure, install and maintain WAN network links utilizing digital spread
spectrum radio bridges,
. Provide assistance in designing, configuring, installing and maintaining all
components of the City's network infrastructure,
. Provide access to the City's intranet utilizing the City's high-speed switched gigabit
Ethernet backbone,
. Administer 2 Unix-based firewalls that provide security to the City's network and
Intemet connection,
. Provide DNS naming service, including name registration and name server
management.
. Administer maintenance and service contracts for Level3, Verizon, SSC, NPA
Computers Inc, Expert City, Accent Computers, Secure Computing and Hewlett
Packard/Compaq Inc,
. Provide and maintain authorized access to the City's local network through a
secure web based Remote access system,
. Install, maintain and troubleshoot Cat Ve UTP cable plant including cables, jacks,
wallplates and punch down assemblies, (Major cabling projects, drilling, or new
conduit work may be subcontracted, and would represent a cost to Water),
2
"
2003-124
Financials (WFSl
. Administer system at operating system level, including installation and upgrades of
the following software:
. Unix operating system
. Unidata database
. System Builder 4GL
. Harris application software
. Act as technical liaison with operating system (HP), database (IBM) and financial
software (Harris) vendors,
. Provide assistance with the setup of user accounts, access, and security at both
the operating system and application levels,
. Provide after hours access and technical assistance to maintenance vendors as
necessary,
. Provide technical assistance for Harris software (Technical assistance does not
include assistance in the use of Harris application software),
. Create archive CDs of registers and reports generated during payroll processing,
. Perform accounts payable backups prior to weekly final register and check
processing, and transmit positive pay data to Wells Fargo,
. Perform payroll backups prior to biweekly processing, process payroll, and
transmit direct deposit and positive pay data to Wells Fargo,
. Provide research for WFS disaster recovery options,
Document Imaaina
. Perform system administration contingent upon receiving necessary training,
hardware, and software licenses, for I.S, personnel.
. Act as technical liaison to the software vendor in resolving problems,
. Provide after hours access and technical assistance to maintenance vendors as
necessary,
. Assist in implementation of new Cimage document imaging system,
Implementation services include:
. Providing Water project manager, water staff, and associated project
vendors with input into the development of applications,
. Participate in project planning and implementation meetings,
. Review of interface configurations,
. Technical assistance for installation and configuration of hardware and
software,
. Provide on-going technical assistance for Cimage document imaging system
(Technical assistance does not include assistance in the use of the application
software) ,
3
2003-124
Permit Trackina
. Provide access to the Accela Permits+ system,
. Perform server administrative services including performance monitoring, system
tuning, and installation of software upgrades and patches,
. Act as technical liaison to the software vendor in resolving problems,
City Business System (Sable)
. Provide access to County Assessor parcel information,
Utility Billina (UB)
. Administer system at operating system level, including installation and upgrades of the
following software:
. IBM Operating system (08/400)
. Existing UB related software programs (HTE, Itron, Acom, Standard Register,
Cog nos, WinSpool)
. Act as technical liaison with operating system vendor (IBM), utility billing software
vendors (HTE, Itron, Acom, Cognos, WinSpool), and remittance processor vendor
(Standard Register),
. Provide assistance with setup of user accounts, access, and security at both the
operating system and application levels,
. Provide after hours access and technical assistance to maintenance vendors as
necessary,
. Provide technical assistance for HTE software and existing third party applications
(Itron, Acom, Standard Register, Cognos, WinSpool), (This does not include
assistance in how to use HTE or third party software,),
. Create and/or assist users in creating reports using Cog nos Impromptu (QREP),
. Provide bill and notification design and modification services using EZlPrinl.
. Maintain "billing message" information on bills using EZlPrinl.
. Transfer utility billing transaction information to the financial system general ledger on
a daily basis,
. Transfer miscellaneous cash receipts transaction information to the financial system
general ledger on a daily basis,
. Monitor and maintain the automated derogatory file updates for the remittance
processor (DTS200)
. Create archive CDs of daily HTE billing reports,
. Generate and transmit refund check positive pay data to Wells Fargo,
. Transmittal of bank drafting data to Wells Fargo,
. Provide ongoing technical assistance with bank drafting,
4
2003-124
. Provide research for US disaster recovery options.
Miscellaneous Water Svstems
Employee Training Tracking System
. Provide administrative, technical and application support to end-users of system.
. Provide additional development as needed
Maintenance Contract Tracking System
. Provide administrative, technical and application support to end-users of system.
Vehicle and Equipment Rental Management System
. Provide administrative, technical and application support to end-users of system.
Maximo
. Assist in performing system administration functions such as application software
upgrades.
. Act as technical liaison to the vendor in resolving problems.
DataQuick
. Act as technical liaison to the vendor in resolving problems.
Experian Credit Check System
. Act as technical liaison to the vendor in resolving problems.
J.J. Keller & Associates (Compliance Information Manager & Workplace Safety
Management software)
. Act as technical liaison to the vendor in resolving problems.
".
5
2003-124
Operations
. Perform daily backups (Monday - Friday) of UB application data, WFS, and office
automation servers. The IS Division is not responsible for backing up data that is
not saved to these servers.
. Perform daily backups of Cimage document management system after go-live.
Backups prior to go-live to be completed on an as-needed basis.
. Perform weekly, monthly, and year-end full system backups of UB, WFS, and
office automation servers.
. Provide offsite storage for selected weekly, monthly, and year-end full system
backups in a secure off-site media storage facility.
. Provide backup media and related supplies.
. Maintain tape library.
. Retrieve off-site tapes and restore data as required.
. Ship equipment to vendors for repair.
. Provide utility billing print services including:
. Initial, Cycle, Off-cycle, and Final Bills
. Delinquent Notices
. 48 Hour Disconnect Notices
. Multi-family Disconnect Notices (10 Day Notice)
. Return Check Letters
. Tenant Letters
. Customer refund checks
. Bill Notices
. Install PC software including SB Client, Client Access, Maximo, HTE GUI, Cog nos
Impromptu, virus protection, Microsoft operating systems and Office suite.
. Troubleshoot PC and printer malfunctions.
. Provide preventative maintenance to printers.
. Install and relocate PCs and printers.
. Maintain inventory of PCs, laptops, printers and desktop software, on equipment
connected to the City network.
. Daily service walk-through for 2nd and 5th floors.
. Service walk-through at Water Yards Monday through Thursday.
. Service walk-through at WRP each Tuesday and Thursday.
. On-site business-hours support from 6:00 AM to 5:30 PM, Monday through
Thursday, and 6:00 AM to 4:30 PM on Fridays.
. On-site after-hours Operations support for special processing, report printing,
upgrades, etc.
. Administer maintenance contracts for desktop PCs & printers, laptops, and line
printers.
6
Other
.
.
.
.
.
.
.
.
.
2003-124
Provide monthly status report to General Manager.
IS representative attendance at department meetings (agenda setting/debriefing,
WTC, Web site committee) as requested and/or possible.
Obtain annual hardware and software maintenance contract quotes for systems
and software supported by IS.
Review annual hardware and software maintenance invoices, and forward to
Water Finance after sign-off.
Hold quarterly Links meetings & associated training.
Review & sign-off of requests for technology purchases, monitoring for department
wide compatibility and standardization.
Assist in development of an online technology master plan.
Keep the Water Department informed of City technology projects of interest.
Develop simple Microsoft Access and Visual Basic applications.
7
"
2003-124
Notes: These notes represent information that may have an impact on Water and/or reminders of topics
that have been brought up from a technology perspective for consideration in planning for the
future.
. An annual desktop equipment replacement fund should be considered, as well as a non-
desktop replacement fund, (i.e. major server hardware and software upgrades, network
upgrades, etc.)
. The current bill printers (two HP8000 series printers) should be considered for
replacement. IS recommends replacement of at least one bill printer this year, followed
by the second in the next fiscal year,
Estimated cost:
$7800.00 (per printer)
. The Cimage Document Management system requires high bandwidth networking to
remote sites (Water yards / WRP / RIX), IS recommends that the move to Fiber (or
alternative transport) be pushed forward in upcoming months for both the Yards and WRP
facilities.
. The Harris financial system currently resides on a DEC Alpha server, which was
purchased in 1994. Support for the operating system and database are approaching their
end life, The cutoff date for support on Unix 4.0G is September 30th, 2005. If Water
decides to stay with the Harris system, it is estimated at this time that the cost to migrate
to a new box, with a current operating system and latest version of the database software
is approximately $24,000.00,
. Due to budgetary constraints, the City did not pursue acquiring Intemet auditing software.
If the Water Department wishes to add this functionality, the approximate price would be
$8,000.00
8