HomeMy WebLinkAbout2000-262
,
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
RESOLUTION NO, 2000-262
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
2000/2001.
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 days following the effective date of this resolution.
III
25 III
26
27
28
2000-262
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
2000/2001.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
Approved as to
25 form and legal content:
I HEREBY CERTIFY that the foregoing Resolution was duly adopted by the Mayor
Joint
and Common Council of the City of San Bernardino at a Regular meeting thereof, held on the
5th day of September, 2000, by the following vote, to wit:
Council Members: AYES NAYS ABSTAIN ABSENT
ESTRADA X
LIEN x
MCGINNIS x
SCHNETZ x
SUAREZ x
-
ANDERSON x
-
MCCAMMACK x
J!1wJA.~~dmiiJl Ixputp
City Clerk
()~
day of September,
The foregoing resolution is hereby approved this
2000.
, (j_-L~ 1--....-
u ith Valles, Mayor
Ci y of San Bernardino
26 JAMES F. PENMAN,
C~'ty ttorney ;
By: ~ f~
\
27
28
. .
2000-262
Exhibit 1
Page 1/5
,
1
MASTER SERVICES
MEMORANDUM OF UNDERSTANDING
2
3
4
5
THIS MEMORANDUM OF UNDERSTANDING is made and entered into
6 by and between the City of San Bernardino, a charter city
7 ("City"), and the Board of Water Commissioners of the City of
8 San Bernardino ("Board"), who agree that the City shall provide
9 services and the Board shall compensate City therefore as
lO follows:
EQUAL EMPLOYMENT OFFICER.
The City shall provide to
11
1.
l2 the
City
of
San
Bernardino
Municipal
Water
Department
l3 ("Department") the services of its Equal Employment Officer at a
l4 flat annual rate of $25,000.
l5
2 .
CITY ATTORNEY. The City Attorney shall act as General
l6 Counsel to the Department and perform all of its legal work.
l7 The City Attorney shall assign sufficient staff to perform the
l8 legal services needed by the Department, and such services shall
19 be given priority.
20
A.
Outside Counsel.
The parties contemplate the
2l continued need for the Department to utilize services of outside
22 special counsel, particularly in water rights matters. The City
23 Attorney and the Department shall jointly determine when the
24 services of outside counsel are required and Department staff
25 shall consult with and obtain the approval of the City Attorney
26 prior to the employment of outside counsel and prior to the
27 assignment of matters to such counsel.
All outside counsel
28 shall keep the City Attorney informed of their work and provide
-l-
2000-262
Exhibit 1
Page 2/5
1 to the City 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
II requirements of the Department, including any back-up materials,
l2 applicable regulations, correspondence, preliminary drafts of
l3 agreements, if any, and any other material pertaining to the
l4 Department necessary for the performance of legal services.
l5
D.
Compensation.
16
(ll Attorney Services.
It is anticipated that
l7 the
services
to be supplied by the City Attorney will
l8 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
2l that the services to be supplied by the Legal Secretary will
22 constitute, on the average, an amount equal to fifty percent
23 (50%) of the time of one Legal Secretary I.
24
(3 I
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-
2000-262
Exhibit 1
Page 3/5
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 administrative
8 hearings on discharges and reductions in rank or compensation.
9
EMPLOYEE ASSISTANCE PROGRAM.
Department shall pay to
4 .
lO City the actual cost of services to Department's employees of
II the Employee Assistance Program.
"Actual cost" will be defined
l2 as the hourly rate charged by the Employee Assistance Program
l3 provider, currently $50 per hour.
l4
RIDESHARE COORDINATOR. Department shall pay to City a
5.
15 flat annual rate of $3,000 for the services of its Rideshare
l6 Coordinator, who shall provide services to Department employees
l7 as required by the Air Quality Management District
(AQMD)
l8 including, but not limited to:
19
Developing, updating and implementing a Trip
A.
20 Reduction Plan and complying with all other AQMD Regulation
2l requirements;
22
Promoting the Trip Reduction Plan and rideshare
B.
23 activities, and tracking and documenting employee participation;
24
Acting as a liaison with AQMD and attending all
C.
25 training, meetings and workshops as required by AQMD.
26
6.
Department shall pay for the use
TELEPHONE SERVICES.
27 of City's telephone system at the actual monthly telephone
28 charges attributable to the ports assigned to the Water
-3-
2000-262
Exhibit'l
Page 4/5
1 Department, Water Yards and Water Reclamation Plant, plus a
2 proportionate share of the fixed costs of operations, debt
3 retirement/system hardware, and leased lines, based upon the
4 portion of total
assigned to the Water
telephone ports
5 Department, Water Yards and Water Reclamation Plant.
6
WORKERS'
Department
COMPENSATION ADMINISTRATION.
7 .
7 shall pay to City for the administration of its Workers'
8 Compensation Program, its proportionate share of the budgeted
9 cost of administration based upon budget payroll costs, provided
10 that the Department provides to the City the budget figures for
II payroll within a reasonable time after Department's budget is
12 adopted.
For any year in which payroll figures are not made
l3 available to the City in a timely fashion, the percentage shall
l4 be the same as that used for the prior year.
For fiscal year
l5 2000/200l, this shall be seventeen percent (l7%).
In addition,
16 the Department shall pay the actual cost of the amount paid out
l7 on its claims.
l8
19
MANAGEMENT INFORMATION SERVICES (MIS).
8 .
A.
Services.
The MIS Director will act like a private
20 contractor to provide the Department MIS related services as
2l defined In the attached agreement (Attachment "A") incorporated
22 herein by reference upon approval by the Board of Water
23 Commissioners and the City of San Bernardino.
24
B. Compensa tion. The agreed upon cost to provide this
25
26
service is $313,400, which includes the addition of one Computer
Operator position (Salary Range 3355, $2608-$3l70 month) to be
27
dedicated to the Water Department.
An amount of $l33,900 has
28
-4-
2000-262
Exhibit 1
Page 5/5
1 been identified to fund Water Department Hardware and/or
2 Software Maintenance Agreements on a reimbursable basis.
3
9.
PAYROLL SERVICES.
The City shall provide to the
4 Department payroll services for the Water Department to include:
5 Completion and processing of payroll in accordance with mutually
6 agreed on policies and procedures and furnish payroll data used
7 on the Water Financial System. The City will be able to use the
8 Water Payroll modules to provide this service and for their own
9 use.
This software will be on both the City and Water
10 Department servers. The City agrees to provide the services for
II a flat annual rate of $28,000.00.
l2
lO. TERMS.
This
Memorandum of Understanding
shall
l3 terminate as of June 30, 200l, unless terminated by either party
l4 at least thirty (30) days prior to July l.
l5
16
BOARD OF WATER COMMISSIONERS
:-~~~
B. Warren Cocke, President
5~/!!I:f.eetary
17
Date:
a;;_~'o
/
l8
19
20
21
22
OF SAN BERNARDINO
q''15A:D
Date:
23 Mayor
APPROVED AS TO FORM AND
24 LEGAL CONTENT
25
26
27
7/~
es F. Penman, City Attorney
~/h {J} 'fJCt~ f)
achel Clark, Clty Clerk
~ Ja1icLwfnpdtf;1i.1~
28
-5-
", \
2000-262
Attachment A
Page 1 /6
MIS CONTRACT SERVICES
FISCAL 2000/2001
Office Automation
· Troubleshooting of "malfunctioning" Microsoft operating systems
and Office products (Word, Excel, Access)
· Access to the City's office automation server and Backoffice
Automation service.
· Creation, deletion, and alteration of network accounts, scripts, and
user folders on the City office automation server as required.
· Creation, deletion, and alteration of email public folders.
· Maintenance of virus software on client and server PCs. Includes'
installation and upgrading of virus software (semi-annual), virus
scan engine (quarterly), and new virus pattern files as they become
available.
~
· Provide maps and/or reports as requested. (Large maps and
special paper are available at cost of materials.)
· Add Water district layers as required to Internet Map Server
application.
· Incorporate water district data in new and future Internet Server
applications. .
Internet
· Web site hosting on the City web server
· Provide direct controlled access to the web server via FrontPage
2000
· Publishing of web site content provided by the Water department.
· Web server administrative services including performance
monitoring, system tuning, system security, and installation of
server software upgrades and service packs.
.Network
· Provide access to the City's TCP/IP network and to the Internet via
a T-1 digital line.
· Set up and maintain Internet access accounts to facilitate browsing
by authorized individuals.'
1
2000-262
Attachment A
Page 2/6
· Provide secure inbound and outbound Internet mail service using
the SMTP protocol.
· Design, configure, install and maintain WAN network links utilizing
frame relay.
· Provide assistance in designing, configuring, installing and
maintaining all components of the City's network infrastructure.
· Provide access to the network utilizing the City's high-speed
switched FDDI backbone.
· Monitor frame relay circuits to remote sites and provide technical
assistance to GTE.
· Administer 3 Unix based firewalls that provide security to the City's
network and Internet connection.
· Maintenance and service contract administration for GTE, PacBell,
CATG, Secure Computing and Compaq Inc.
· Maintain and provide authorized access to Remote Access Service
(RAS) to facilitate dial-up connections to the City's network.
· Install, maintain and troubleshoot Cat V UTP cable plant including
cables, jacks, wall plates and punch down assemblies. (Major
cabling projects, drilling, or new conduit work must be
subcontracted)
Financials IWFSI
· Administration of system at operating system level, including
installation and upgrades of the following software:
· Unix operating system
. Unidata database
· System Builder 4GL
· CCS application software upgrades
· Act as technical liaison with operating system (Compaq), database
(Unidata) and financial software (CCS) 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.
· Technical assistance for CCS software (Technical assistance does
not include assistance in the use of CCS application software)
· Provide and maintain a payroll transaction interface between the
City Business System and Water Financial System.
2
2000-262
Attachment A
Page 3/6
Permit Trackino
· Provide access to the new Sierra Permits+ system.
· Server administrative services including performance monitoring,
system tuning, and installation of software upgrades and patches.
City Business Svstem (Sable)
· Provide access to Metroscan and County Assessor parcel
information.
Utility Billino (UB)
· Administration of system at operating system level, including
installation and upgrades of the following software:
· IBM Operating system (OS/400)
· Application upgrades for existing UB related software programs
(HTE, Itron, Formula One, Lognet, Standard Register, Cognos)
· Act as technical liaison with operating system vendor (IBM), utility
billing software vendors (HTE, Itron, Formula One, Lognet, Cognos),
and remittance processor vendor (Standard Register)
· Provide assistance with setup of user accounts, access, and seQJrity
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, Formula One, Lognet, Standard Register, Cognos).
(This does not include assistance in how to use HTE or third party
software, or in the creation of simple reports.)
· Creation of complex reports in Cognos. Examples of reports that MIS
considers to be complex include reports that query information from at
least 2 separate sources, require generation of SOL statements or
VBA (Visual Basic for Applications) scripts, or require cross-tabulation.
· Provide Bill and Notification design and modification services using
EZlPrint.
· Maintain "Billing Message" information located on bills using EZlPrint.
. Monitor and provide technical assistance to HTE for System Change
Requests (SCRs) that were included in the HTE utility billing system
migration project.
· Review, edit, and transfer utility billing transaction information to the
financial system general ledger on a daily basis.
· Monitor and maintain automated derogatory file updates for the
3
.
2000-262
Attachment A
Page 4/6
",
remittance processor (DTS200)
Miscellaneous Water Systems
TELETRAC (Vehicle tracking and reporting system)
· Provide technical support of City Hall Monitoring station
· Assist staff with entry of new VLU (Vehicle Location Unit) information
into the system.
· Assist staff in creating vehicle location reports
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.
Employee Training Tracking System
· Provide administrative and technical support to end-users of system
Ooerations
· Perform daily backups of US application data, WFS, and office
automation servers. (MIS is not responsible for backing up data
that is not saved to these servers)
· Perform weekly. monthly, and year-end full system backups of US,
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.
· Retrieval of off-site tapes and restoration of data as required.
· Shipment of equipment to vendors for repair.
'4
2000-262
Attachment A
Page 5/6
~. ,,'
· 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
· Perform accounts payable backups prior to generation of the final
register and print AP checks.
· Installation of PC software including SB Client, Client Access 400,
HTE GUI, Microsoft operating systems and Office suite.
· Troubleshooting PC and printer malfunctions.
· Installation and relocation of PCs and printers.
· Maintain inventory of known PCs, laptops, and printers.
· Daily service walk-through at WRP, Yards, and 5111 floor.
· On-site support from 6:30 AM to 6:00 PM, Monday through
Thursday, and 6:30 AM to 5:00 PM on Fridays.
· Maintenance contract administration for desktop PCs, laptops, and
printers.
· Coordination of removal of XBMS hardware.
Admioistrative
· Provide monthly status report to General Manager.
· Attendance of an MIS representative as requested and/or possible
at department meetings.
· Request and obtain annual hardware and software maintenance
contract quotes for systems and software supported by MIS.
· Provision of quarterly links meetings & associated training. .
· Review & sign-off of requests for technology purchases, monitoring
for department wide compatibility and standardization.
This agreement details all of the services MIS is required to provide to the
. Water Department during fiscal 2000/2001 at a contract price of $313,400.
,
2000-262
Attachment A
Page 6/6
Addition of one (I) Computer Operator, range 3355, $2608. - $3170. month.
MIS has cut various materials, operations, and training budget line items within the proposed
Water contract figure in order to add a computer operator at no additional cost to the Water
Department. Analysis of Water's service requests and calls for services have resulted in the
determination that response times need to improve, and after a year of experience with the new
utility billing system, that greater flexibility in work hours is needed to avoid disruption to Water
operations during peak usage. Addition of a support technician has been concluded to be of
greater benefit to Water than materials, operations, and training expenses submitted by MIS staff
for inclusion in the 00-0 1 contract, which are being reduced or eliminated to best meet Water
department critical service needs.
The addition of a flex schedule technician is expected to:
. enhance response time to user issues at the desktop level
. provide for a swing or graveyard shift to accommodate Water needs during non-
business hours without incurring overtime costs
. to provide for existing system backups during non-business hours and backup of the
XBMS system for as long as it remains in use
. enhance Water support to include a daily walk through by a desktop support
technician at all 3 Water operations physical locations; WRP, Water Yards, and City
Hall 5th floor and at hours most convenient to each site
. provide graveyard or swing shift support for purposes of software upgrades, special
report printing, and other needs that arise and that are best suited to off hours
processing to prevent degradation of Water systems during peak usage
MIS will coordinate with Water to determine the best timeframe to have a technician on site on a
regular basis to meet all of Water's off hours operating needs.
Total 00-0 I contract amount:
Total maintenance contracts:
313,400,
133,900.
.
2000-262
Resolution
578
1
2
3 RESOLUTION OF THE BOARD OF WATER COMMISSIONERS OF THE CITY
OF SAN BERNARDINO ADOPTING A MASTER SERVICES MEMORANDUM OF
4 UNDERSTANDING WITH THE CITY OF SAN BERNARDINO FOR PROVISION OF
CITY SERVICES FOR FISCAL YEAR 2000j200l.
5
6
certain services to the Water Department
7
8
WHEREAS, the City of San Bernardino ("City") provides
("Department") for which
the Department compensates the City; and,
WHEREAS, it is the desire of the City and the Department to
9
memorialize these agreements in a Memorandum of Understanding;
10
BE IT RESOLVED BY THE BOARD OF WATER COMMISSIONERS OF THE
11
CITY OF SAN BERNARDINO AS FOLLOWS:
12
13
City and the Board of Water Commissioners setting forth the
14
services that are to be provided by the City to the Department
SECTION l.
The Memorandum of Understanding between the
15
16
17
18
19
20
21
22
23
24
25
26
27
28
and the compensation to be paid therefore, a copy of which is
attached hereto and incorporated herein as "Exhibit 1", is hereby
adopted.
I HEREBY CERTIFY that the foregoing resolution was duly
adopted by the Board of Water Commissioners of the City of San
x
regular meeting thereof, held on the
Bernardino at a
August
, 2000, by the following vote, to
15th
day of
wit:
AYES:
COMMISSIONERS
Cocke. Urata. Callicott
None
NAYS:
ABSENT:
Commissioners Matich, Battey
(Seal)
Sf~l~~
Deputy City Clerk & Ex-Officio Secretary