Loading...
HomeMy WebLinkAbout09-City Manager ORIGINAL CITY OF SAN BERNARDINO - REQUEST FOR COUNCIL ACTION From: Lori Sassoon, Acting City Manager Subject: Resolution re-authorizing execution of a Master Services Memorandum of Understanding by and between the City of San Bernardino and the Water Department for City-provided services for FY 2008/09. Dept: City Manager's Office Date: August 27,2008 MICC Meeting Date: Sept. 15,2008 Synopsis of Previous Council Action: June 16, 2008 - Resolution 2008-235 was approved authorizing execution of a Master Services Memorandum of Understanding by and between the City of San Bernardino and the Water Department for City-provided services for FY 2008/09. 1997 through 2007 - Resolutions are adopted annually authorizing Master Services Memorandums of Understanding with the Water Department for the provision of City Services. Recommended Motion: Adopt resolution. r \,-~ ~J/<-- Signature Contact person: Tl>ri R",kl>r Phone: 5122 Supporting data attached: SR resolution & MOU Ward: FUNDING REQUIREMENTS: Amount: Reimbursement to be made to various City funds for services provided, as outlined in the staff report. Source: (Acct. No.) (A"'" n",C:Nirtinn) Finance: Council Notes: &.>0 d.oOcf'-..:5' 6.3 Agenda Item No. q '1-1'5 -09 CITY OF SAN BERNARDINO - REQUEST FOR COUNCIL ACTION Staff Report Subiect: Resolution of the City of San Bernardino re-authorizing the City Manager of the City of San Bernardino to execute a Master Services Memorandum of Understanding with the Water Department for provision of City services for Fiscal Year 2008/2009. Back!!round: The Mayor and Common Council approved Resolution 2008-235 on June 16, 2008, authorizing the City Manager to execute the Master Services Memorandum of Understanding (MOU) between the City and the Water Department, for various services provided by the City to the Water Department during FY 2008/2009. However, the Master Services MOU was not signed by the Water Department within the 60- day time period required by the Resolution due to questions from the Water Department regarding the Information Technology section. All questions have been answered and no changes to the Master Services MOU are needed. However, as a result of the time delay, Resolution 2008-235 has expired and a new Resolution re-authorizing the City Manger to execute the Master Services MOU must be approved by the Mayor and Common Council. Financial Impact: No Change. Recommendation: Adopt resolution. CITY OF SAN BERNARDINO Interoffice Memorandum CITY CLERK'S OFFICE DATE: September 19, 2008 TO: Teri Baker, Assistant to the City Manager FROM: Margaret Fedor, Executive Assistant to the City Clerk RE: Transmitting Documents - Resolution No. 2008-363 At the Mayor and Common Council meeting of September 15, 2008, the City of San Bernardino adopted Resolution No. 2008-363 - Resolution of the Mayor and Common Council of the City of San Bernardino re-authorizing the City Manager to execute a Master Services Memorandum of Understanding with the Water Department for provision of City services for Fiscal Year 2008/2009. Attached are one (I) fully executed original agreement and one (I) copy of the executed original agreement to be delivered to the other party. We have retained a duplicate original agreement to be filed with the Resolution. If you have any questions, please do not hesitate to contact me at ext. 3206. Thank you. I hereby aCknyledg~ receipt of the above mentioned documents. Signed: ~ {:+-t-.... Date: "'5//"7/6i? / I PLEASE SIGN AND RETURN C(Q)[Pl( 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. RESOLUTION OF THE MAYOR AND COMMON COUNCIL OF THE CITY OF SAN BERNARDINO RE-AUTHORIZING THE CITY MANAGER TO EXECUTE A MASTER SERVICES MEMORANDUM OF UNDERSTANDING WITH THE WATER DEPARTMENT FOR PROVISION OF CITY SERVICES FOR FISCAL YEAR 2008/2009. BE IT RESOLVED BY THE MAYOR AND COMMON COUNCIL OF THE CITY OF SAN BERNARDINO AS FOLLOWS: WHEREAS, 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; and WHEREAS, Resolution 2008-235 previously authorized the City Manager to execute the FY 2008/2009 Master Services Memorandum of Understanding, but the document was not executed within the specified time frame; 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 Attachment I, is hereby adopted. SECTION 1. The City Manager of the City of San Bernardino is hereby re-authorized and directed to execute on behalf of said City the Master Services Memorandum of Understanding. SECTION 2. 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 90 days following the effective date ofthis resolution. :/:19 f.15-'()~ ~. . 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 RE-AUTHORIZING THE CITY MANAGER TO EXECUTE A MASTER SERVICES MEMORANDUM OF UNDERSTANDING WITH THE WATER DEPARTMENT FOR PROVISION OF CITY SERVICES FOR FISCAL YEAR 2008/2009. I HEREBY CERTIFY that the foregoing Resolution was duly adopted by the Mayor and Common Council of the City of San Bernardino at a meeting thereof, held , 2008, by the following vote, to wit: day of on the Council Members: AYES NAYS ABSTAIN ABSENT ESTRADA BAXTER BRINKER DERRY KELLEY JOHNSON MCCAMMACK Rachel G. Clark, City Clerk day of The foregoing resolution is hereby approved this 2008. Patrick J. Morris, Mayor City of San Bernardino Approved as to Form: O,,_f~ ~ 4/?-1 James F. Penman, City Attorney ATTACHMENT 3. 1 2 MASTER SERVICES 3 MEMORANDUM OF UNDERSTANDING 4 5 THIS MEMORANDUM OF UNDERSTANDING is made and entered into by and 6 between the City of San Bernardino, a charter city ("City"), and the Board of Water 7 Commissioners of the City of San Bernardino ("Board"), who agree that the City shall provide 8 services and the Board shall compensate City therefore as follows: 9 I. EQUAL EMPLOYMENT OFFICER. The City shall provide to the City of San 10 Bernardino Municipal Water Department ("Department") the services of its Equal Employment 11 Officer and support staff at a fiat annual rate of $42,400. 12 2. CITY ATTORNEY. The City Attorney shall act as General Counsel to the 13 Department and perform all of its legal work. The City Attorney shall assign sufficient staff to 14 perform the legal services needed by the Department, and such services shall be given priority. 15 A. Outside Counsel. The parties contemplate the continued need for the 16 Department to utilize services of outside special counsel, particularly in water rights matters. 17 The City Attorney and the Department shall jointly determine when tht;: services of outside 18 counsel are required and Department staff shall consult with and obtain the approval of the City 19 Attorney prior to the employment of outside counsel and prior to the assignment of matters to 2 0 such counsel. All outside counsel shall keep the City Attorney informed of their work and 21 provide to the City Attorney copies of any and all correspondence and documents filed in any 22 court on Department matters and any agreements to hire outside counsel shall be required. 23 B. Support Staff. In connection with providing the foregoing services, the 24 City Attorney's office will provide sufficient secretarial, paralegal and investigator support 25 services. 26 C. Data to be Furnished to the City. The following has been and will 2 7 continue to be furnished by the Department to the City: All records and information pertaining 28 to legal requirements of the Department, including any back-up materials, applicable -1- 1 regulations, correspondence, preliminary drafts of agreements, if any, and any other material 2 pertaining to the Department necessary for the performance of legal services. 3 D. Compensation. 4 (I) Attornev Services. It is anticipated that the services to be 5 supplied by the City Attorney will constitute, on the average, an amount equal to fifty percent 6 (50%) of the time of one Senior Deputy City Attorney. 7 (2) Secretarial. Other Staff and Services. It is anticipated that the services to be 8 supplied by the Legal Secretary will constitute, on the average, an amount equal to fifty percent 9 (50%) of the time of one Legal Secretary II and 10% of the time of other staff. City Attorney 10 services shall be provided to the City of San Bernardino Water Department at a flat annual rate 11 of$181,800. 12 3. CIVIL SERVICE. Department shall pay to City for the services of its Chief 13 Examiner and for Civil Service Administration an annual flat fee of $69,200. Typical services 14 shall include, but not be limited to, testing and certifying eligible employees for outside 15 recruitment and promotions, and testing standards for positions in the Department, and 16 administrative hearings on discharges and reductions in rank or compensation. 17 4. HUMAN RESOURCES AND FINANCE. Department shall pay to City for the 18 services of its Human Resources and Finance departments an annual flat fee of $56,200. 19 Typical services shall include, but not be limited to, conducting outside recruitments; 20 administering employee health, dental, vision, and life insurance programs; approving job 21 descriptions, minimum qualifications, and administering the Public Employees Retirement 22 System contract. Department shall also pay to City the actual costs of recruitment-related 23 advertising that is requested by Department. 24 5. EMPLOYEE ASSISTANCE PROGRAM. Department shall pay to City the 25 $650 per month for the Employee Assistance Program. Department shall also pay to City a flat 26 annual fee of $2,200 for its proportionate share of the administrative costs of the Employee 27 Assistance Program (total of $10,000). 28 -2- 1 6. RlDESHARE COORDINATOR. Department shall pay to City a flat annual rate 2 of $5,200 for the services of its Rideshare Coordinator, who shall provide services to 3 Department employees as required by the Air Quality Management District (AQMD) including, 4 but not limited to: 5 A. Developing, updating and implementing a Trip Reduction Plan and 6 complying with all other AQMD Regulation requirements, including the provision of trip 7 reduction incentives for Department employees; 8 B. Promoting the Trip Reduction Plan and rideshare activities, and tracking 9 and documenting employee participation; 10 C. Acting as a liaison with AQMD and attending all training, meetings and 11 workshops as required by AQMD. 12 7. TELEPHONE SERVICES. Department shall pay for the use of City's telephone 1 3 system at the actual monthly telephone charges attributable to the ports assigned to the Water 14 Department, Water Yards, Water Reclamation Plant and RIX Plant, plus a proportionate share 15 of the fixed costs of operations, debt retirement/system hardware, and leased lines, based upon 16 the portion of total telephone ports assigned to the Water Department, Water Yards, Water 1 7 Reclamation Plant and RIX Plant. 18 8. WORKERS' COMPENSATION ADMINISTRATION. /Department shall pay 19 to City for the administration of its Workers' Compensation Program, its proportionate share of 20 the budgeted cost of administration based upon budget payroll costs, provided that the 21 Department provides to the City the budget figures for payroll within a reasonable time after 22 Department's budget is adopted. For any year in which payroll figures are not made available 23 to the City in a timely fashion, the percentage shall be the same as that used for the prior year. 24 For fiscal year 2008/2009, this shall be twenty percent (20%). In addition, the Department shall 25 pay the actual cost of the amount paid out on its claims. 26 9. INFORMATION TECHNOLOGY (IT). 27 A. Services. The IT Director will act as a private contractor to provide the 28 Department IT related services as defined in the attached agreement (Exhibit "A") incorporated -3- 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 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 $710,700. 10. POLICE AND FIRE DEPARTMENTS. Department shall pay to City a flat fee of $500,000 as reimbursement for safety-related costs associated with the Water Reclamation Plant. 11. WATER DEPARTMENT LAND SALES. Department shall pay to City 10% (ten percent) of the net revenue from each land sale. 12. TERMS. This Memorandum of Understanding shall terminate as of June 30, 2009, unless terminated by either party at least thirty (30) days prior to July 1,2009. III III III -4- 1 2 MASTER SERVICES MEMORANDUM OF UNDERSTANDING 3 By and between the City of San Bernardino and the Board of Water Commissioners of the City 4 of San Bernardino for the provision of City services for Fiscal Year 2008/2009. 5 6 7 8 9 Date: ~ r7b -01 10 BOARD OF WATER COMMISSIONERS ~~HQt~~t j(~-~ '~:.~Secretary 11 12 13 14 CITY OF SAN BERNARDINO 15 Date: 16 17 Lon Sassoon, Acting City Manager 18 Approved as to Form: ATTEST: 19 Rachel Clark, City Clerk 20 James F. Penman, City Attorney 21 22 23 24 25 26 27 28 -5- ~. . INFORMATION TECHNOLOGY CONTRACT SERVICES FISCAL 2008/2009 This document details the services Information Technology proposes to provide to the Water Department during fiscal 2008/2009 at a contract price of $ 710,700. Office Automation . Provide technical assistance for Water Department office automation servers and domain controllers . Troubleshoot "malfunctioning" Microsoft operating systems and Office products (Word, Excel, Outlook, PowerPoint and Access). . Provide use of the City's file, anti-virus, anti-spam and email servers and processes. . Create, delete, and alter network accounts, scripts, and user folders on the City office automation server as required. . Create, delete, set security and alter ernail, public folders and mailboxes. . Maintain anti-virus software on client and server PCs. Includes installation and upgrades of anti-virus software (semi-annual), anti-virus scan engine (quarterly), and new virus pattern files as they become available. . Provide introductory Outlook training classes as requested. . Audit email content and usage upon request. . Department-wide upgrade to Microsoft Office 2007 GIS . Provide maps and/or reports as requested. (Large maps, map series and special papers are available at cost of materials.) . Add Water district layers as required to ArcGIS. . Continue ArcGIS training and establish an internal 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. . Provide assistance to Water GIS personnel. Web Site . Provide web site hosting on the City web server. . Facilitate direct access to Water Department content on the City web server through the Civica Content Management System (CMS). . Provide Civica CMS user training. . Provide limited web page design and development services. . Publish web site content provided by the Water Department to the City web server. Exhibit "A" . 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. . Set up and maintain Internet 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, fiber gigabit links and switched frame relay. . 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 Internet connection and also provide virus filtering on all protocols. . Provide DNS naming service, including name registration and name server management. . Administer maintenance and service contracts for SSC Intemetworking, SSC, NPA Computers Inc., Citrix, 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 and standards-based VPN. . Install, maintain and troubleshoot Cat Ve UTP cable plant including cables, jacks, wall plates and punch down assembiies. (Major cabling projects, drilling, or new conduit work may be subcontracted, and would represent a cost to Water). . Provide for 'first-defense' anti-spam protection at the firewall level. Financials (WFS) . Provide technical assistance for Harris software (Technical assistance does not include assistance in the use of Harris application software). . This system has been discontinued from active use. However, IT will continue to house and support this system. Exhibit "A" 2 Financials (Sunqard Public Sector) . Administer system at operating system level, including installation and upgrades of the following software: . IBM operating system (OS/400) . HTE Naviline . HTE application software (GMBA, payroll, purchasinglinventory, fleet, etc.) . Develop form and check definitions as required (ACOM EZeDocs) . Perform accounts payable backups on request prior to weekly final register and check processing, and transmit positive pay data to Wells Fargo. . Transmit direct deposit and positive pay data to Wells Fargo. . Provide after hours access and technical assistance to maintenance vendors as necessary . Document Imaqinq . Administer system at server level, including installation and upgrades of the following software: . Microsoft operating system (Windows 2000, 2003 Server) . Microsoft database (SQL Server 2000, 2005) . Provide assistance to Water Department personnel in installation and troubleshooting of client applications. . . Act as technical liaison to the software vendor in resolving problems as needed. . Provide after hours access and technical assistance to maintenance vendors as necessary . . Provide implementation support of Laserfiche document imaging system. Implementation services include: . Participation in project planning and implementation meetings. . Review of interface configurations. . Technical assistance for installation and configuration of hardware and software. . Assist with the installation and integration of OptiView/OptiSpool. Integration to include working with Water staff to develop back-end interface to Laserfiche. Exhibit "A" 3 Permit Trackinq . 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 (Linus) . Provide access to County Assessor parcel information, Utility Billinq (UB) . Administer system at operating system level, including installation and upgrades of the following software: . IBM Operating system (OS/400) . Existing UB related software programs (Sungard Public Sector (SPS), Naviline, HTEDMS, Itron, Acom, ITRAN (Remittance Processor), Cog nos QREP) . Act as technical liaison with operating system vendor (IBM), utility billing software vendors (SPS, Itron, Acom, Cognos), and remittance processor vendor (TUI), . Provide assistance with setup of user accounts, access, and security at 00llt the operating system levels, . Provide after hours access and technical assistance to maintenance vendors as necessary, ' . Provide technical assistance for Naviline software and existing third party applications (Itron, Acom, Standard Register, Cog nos) , (This does not include assistance in how to use Naviline or third party software.). . Maintain support for internally created interface applications (ECC, positive pay, bank drafting), . Provide Cog nos Impromptu (QREP) training to report writing staff. . Create and/or assist users in creating reports using Cognos Impromptu (QREP). . Provide bill design and modification services (QREP). . Provide notification design and modification services using HTEDMS. . Monitor and maintain the automated derogatory file updates for the remittance processor (ITRAN). . Generate and transmit refund check positive pay data to Wells Fargo. . Transmittal of bank drafting data to Wells Fargo. . Establish methods for customers to directly access account information. . Establish procedures for correction and maintenance of service addresses. . Maintain Microsoft SQL 2000 database for Remittance Processing. Exhibit "A" 4 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. . Perform server migration to new hardware as needed. 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. Exhibit "A" 5 Operations . Perform daily backups (Monday - Friday) of Sungard application data, Cimage OMS, Triton (HRlRemittance), WUServer, and office automation servers. . Perfonm weekly, monthly, and year-end full system backups of Sungard, Cimage OMS, Triton (HRlRemittance), WUServer, and office automation servers. . Provide remote backup monitoring for remote servers (ARIEL) . The IT Division is not responsible for backing up data that is not saved to these aforementioned 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, HTE Naviline, Cog nos Impromptu, virus protection, Microsoft operating systems and Office suite. . Troubleshoot PC and printer malfunctions. . Provide preventative maintenance for 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 support for special processing, report printing, upgrades, etc. . Administer maintenance contracts for desktop PCs & printers, laptops, and line printers. Exhibit "A" 6 (. . Other o Provide training and guidance to Water Department BSG staff. o IT representative attendance at department meetings (agenda setting/debriefing, WTC, Web site committee) as requested and/or possible. o Obtain annual hardware and software maintenance contract quotes for systems and software supported by IT. o Provide hardware / software maintenance tracking and payments for items listed in Attachment 'A'. Water Department shall be responsible for costs in excess of, or in addition to this attachment. o Review & sign-off of requests for technology purchases, monitoring for department wide compatibility and standardization. o Keep the Water Department informed of City technology projects of interest. o Develop simple Microsoft Access and Visual Basic applications. o Complete disaster management plan for mission-critical systems. o Create IT Strategic plan for technology resources. o Develop tools for management to more easily access reports and data from systems. o Manage catalog of all applications, systems and databases that identifies assets available to management. . Manage and coordinate technology projects. o Attend training provided by systems vendors and provide follow-up training to Water Department staff. Notes: The following 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. o A technology replacement fund should be considered (i.e. major server hardware and software upgrades, network upgrades, PC replacements, printers, etc.) o Additional Civica licensing has been acquired for Intranet Development. Water may wish to review this option for internal needs. o See Attachment A for Hardware / Software / Subscription costs o Enterprise backup system has been placed on hold for current fiscal year, but should be addressed in 09/10. Tom Marek, Director of Infonmation Technology City of San Bernardino Stacey Aldstadt, General Manager San Bernardino Municipal Water Department Date Date Exhibit "A" 7 .. o o N ;;; o o N o C .2 a. '5 o .c ~ III ." C ~ <n ~ ~ ~ ~ .2e u 0 ~'; < g ~ C .!l C ;; ::! C ~ E 1: ~ 0. ~ C ~ .!l ~ ;= n u l! C o U o ~ 15 z '" o o '" <:a '" ~ U ~ C e ~ ,5 ~ o C OJ '(ij 1; E ~ "E ~ ~ i; 'E sa .~~ 8 ~:3.!i~ ~~ !> ~ en I'll ~ Cii 0 '" "'en ~ ~'- ~ 00, ~ ::l.~I..6.... <I' ~ co_.Q"ltOenoo", r:: tOOO(a .!! ':i:C!<Oo~~ ...... IV ctI lO...- >- .~ v 5 CLCL..-COLl..j2 eft ""'_01.0 l;:: (II cnlntsu~"""NnlE 1il+f!I'll"C"O :I:= 8"C......:::CqQ~Ch:3 $.!!ggClOCO.......~- UCOUUeeO'l:O~ ~.E3:3~~UlEo Q)U;Q)Q)>>~OCll cr:WZZlJ..u.;>UC) OOClcooooooooo ooccooooooooo .uici~Ili"":NU;O..noci<oi .....,.... C N.... 100'1 co 0 1000..... 'ltIOONOM<DvOd)C)IO.... ..........MCDr-......."'ItOCO Mai .... .....mN lD ~ .. o ;;; o >- ... '" o ;:: o >- ... gSgg885i lriOOOOcON MO CDNI"-- ("')U1 10..... co ....,... C'O.....l() ~O ~ ('O)OOOOM MOOOOI'-- r.r:iocnociai ~8~~~~ oeo (")0 N ~ ~ u .~ ~ III :;:, u ~ ." e 0. o E 'x ~ ~ C o I~ '5 o C .c e ~ ~ c: ~'5a~ Q).2 o en i ~ ~ cn.c::l Cll-= (,) ~ '~~ Ul g::> 0 III II) ,f: .ERI~'t::gl'llC)cn::!2.g ljl cm('llO'_C _mill g '~"OQ) 1:g~:g.a~:6~ ~ :;Eg~t,l'ii5. ~cu' u o.!!t1I"'CEE~'::IJ::r::: _l!! Q)UlCC::lCl)~fI.l"Cra 'ficn.!!tlI(1)-D:::e;E "3 "Cc.58"O'"'wCllQ)C en ~.2 E r:: ai~a::i~ iii:8 ~ i'l ;;"0 ~ g < 01 Iii ~ ~ ~ .-Eg_';;;~0;gO 0 '0.2 in.E c~ g=:.2 Ee III l: 5~ Rl8o:';:;! ~..5.!! ou 1I).:':i:::; ... fJ .5 Q) Ul ~ f!! :o.~Q~D<:aoigUl4ic :Co ~'Ey<.g 90 e!~.5 VI 0 ce.:;: Uc<<lO'-~3:<<IU e:.s:=G)o=::;;w~.!eVl.g~ N:::I:2:;Sl::~Cf.lQ)o 00 w<O....tc(<:I:O:!:UOWI- ~ o ." C ~ > u .5 o C .2 "5 Ciio ~!!! c Cf.l_ O.g_!!!~a::w~ ~<~~B~~CD o E ~ QiUi :a)(/) 13~(/)~ ~~Oa:: Q; 1ii ~ .c ." ~ 1ii C .~ 2 ." ~ U l!! " o u ~ ~ E U o n u l! C o U ." ~ 'Ii .5 E ~ ........ NN cDuj 00 ~~ ...... NN i'l0 ~u C l!! ",- _C CO .(ij CJ :;." ~ en1ii :!: .5 ClE "'~ ,,- E.!!! .- 0 tH- "E ~ en t;r~!;t ujo(luj ~-~ ~~ n u l! C o u ! ~ ~ o en ~ U .... .... ... ... uj cD '" '" O)~ ~ ~ u C ~ C ~ C ." E o 1ii 'C ~ 1ii E ." C " ~ E E Q):= U; Q) . U) "E 'C C :g .~ ~- >="" .:1 0 .~ ~ ~ ~ o.C ." ~ C .~ ~ ;; ~." - ~ ~.c 80 <>- .... ... c:i o ~ o o N '" or; ~ ;:: ~ .... ... N '" N u; '" '" o ;;; o >- ... ;;; o u 1ii "0 >- '" ~ .... o >- ... i'l c ! ~ is ;; z 1 2 MASTER SERVICES 3 MEMORANDUM OF UNDERSTANDING 4 5 THIS MEMORANDUM OF UNDERSTANDING is made and entered into by and 6 between the City of San Bernardino, a charter city ("City"), and the Board of Water 7 Commissioners of the City of San Bernardino ("Board"), who agree that the City shalI provide 8 services and the Board shalI compensate City therefore as folIows: 9 I. EOUAL EMPLOYMENT OFFICER. The City shalI provide to the City of San 10 Bernardino Municipal Water Department ("Department") the services of its Equal Employment 11 Officer and support staff at a flat annual rate of $42,400. 12 2. CITY ATTORNEY. The City Attorney shalI act as General Counsel to the 13 Department and perform alI of its legal work. The City Attorney shalI assign sufficient staff to 14 perform the legal services needed by the Department, and such services shall be given priority. 15 A. Outside Counsel. The parties contemplate the continued need for the 16 Department to utilize services of outside special counsel, particularly in water rights matters. 17 The City Attorney and the Department shalI jointly determine when the services of outside 18 counsel are required and Department staff shalI consult with and obtain the approval of the City 19 Attorney prior to the employment of outside counsel and prior to the assigrunent of matters to 20 such counsel. AII outside counsel shalI keep the City Attorney informed of their work and 21 provide to the City Attorney copies of any and alI correspondence and documents filed in any 22 court on Department matters and any agreements to hire outside counsel shall be required. 23 B. Support Staff. In connection with providing the foregoing services, the 24 City Attorney's office wilI provide sufficient secretarial, paralegal and investigator support 25 services. 26 C. Data to be Furnished to the City. The folIowing has been and wilI 27 continue to be furnished by the Department to the City: AII records and information pertaining 28 to legal requirements of the Department, including any back-up materials, applicable -1- 1 regulations, correspondence, preliminary drafts of agreements, if any, and any other material 2 pertaining to the Department necessary for the performance of legal services. 3 D. Compensation. 4 (1) Attornev Services. It is anticipated that the services to be 5 supplied by the City Attorney will constitute, on the average, an amount equal to fifty percent 6 (50%) of the time of one Senior Deputy City Attorney. 7 (2) Secretarial, Other Staff and Services. It is anticipated that the services to be 8 supplied by the Legal Secretary will constitute, on the average, an amount equal to fifty percent 9 (50%) of the time of one Legal Secretary II and 10% of the time of other staff. City Attorney 10 services shall be provided to the City of San Bernardino Water Department at a flat annual rate 11 of$181,800. 12 3. CIVIL SERVICE. Department shall pay to City for the services of its Chief 13 Examiner and for Civil Service Administration an annual flat fee of $69,200. Typical services 14 shall include, but not be limited to, testing and certifying eligible employees for outside 15 recruitment and promotions, and testing standards for positions in the Department, and 16 administrative hearings on discharges and reductions in rank or compensation. 17 4. HUMAN RESOURCES AND FINANCE. Department shall pay to City for the 18 services of its Human Resources and Finance departments an annual flat fee of $56,200. 19 Typical services shall include, but not be limited to, conducting outside recruitments; 20 administering employee health, dental, vision, and life insurance programs; approving job 21 descriptions, minimum qualifications, and administering the Public Employees Retirement 22 System contract. Department shall also pay to City the actual costs of recruitment-related 23 advertising that is requested by Department. 24 5. EMPLOYEE ASSISTANCE PROGRAM. Department shall pay to City the 25 $650 per month for the Employee Assistance Program. Department shall also pay to City a flat 26 annual fee of $2,200 for its proportionate share of the administrative costs of the Employee 27 Assistance Program (total of $10,000). 28 -2- 1 6. RIDESHARE COORDINATOR. Department shall pay to City a flat annual rate 2 of $5,200 for the services of its Rideshare Coordinator, who shall provide services to 3 Department employees as required by the Air Quality Management District (AQMD) including, 4 but not limited to: 5 A. Developing, updating and implementing a Trip Reduction Plan and 6 complying with all other AQMD Regulation requirements, including the provision of trip 7 reduction incentives for Department employees; 8 B. Promoting the Trip Reduction Plan and rideshare activities, and tracking 9 and documenting employee participation; 10 C. Acting as a liaison with AQMD and attending all training, meetings and 11 workshops as required by AQMD. 12 7. TELEPHONE SERVICES. Department shall pay for the use of City's telephone 13 system at the actual monthly telephone charges attributable to the ports assigned to the Water 14 Department, Water Yards, Water Reclamation Plant and RIX Plant, plus a proportionate share 15 of the fixed costs of operations, debt retirement/system hardware, and leased lines, based upon 16 the portion of total telephone ports assigned to the Water Department, Water Yards, Water 17 Reclamation Plant and RIX Plant. 18 8. WORKERS' COMPENSATION ADMINISTRATION. Department shall pay 1 9 to City for the administration of its Workers' Compensation Program, its proportionate share of 20 the budgeted cost of administration based upon budget payroll costs, provided that the 21 Department provides to the City the budget figures for payroll within a reasonable time after 22 Department's budget is adopted. For any year in which payroll figures are not made available 23 to the City in a timely fashion, the percentage shall be the same as that used for the prior year. 24 For fiscal year 2008/2009, this shall be twenty percent (20%). In addition, the Department shall 2 5 pay the actual cost of the amount paid out on its claims. 26 9. A. INFORMATION TECHNOLOGY (IT). 27 Services. The IT Director will act as a private contractor to provide the , 28 Department IT related services as defined in the attached agreement (Exhibit "A") incorporated -3- 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 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 $710,700. 10. POLICE AND FIRE DEPARTMENTS. Department shall pay to City a flat fee of $500,000 as reimbursement for safety-related costs associated with the Water Reclamation Plant. II. WATER DEPARTMENT LAND SALES. Department shall pay to City 10% (ten percent) of the net revenue from each land sale. 12. TERMS. This Memorandum of Understanding shall terminate as of June 30, 2009, unless terminated by either party at least thirty (30) days prior to July 1,2009. III III III -4- (', . 1 MASTER SERVICES 2 MEMORANDUM OF UNDERSTANDING 3 By and between the City of San Bernardino and the Board of Water Commissioners of the City 4 of San Bernardino for the provision of City services for Fiscal Year 2008/2009. 5 6 7 8 9 Date: ~ -)l-,-O~ 10 11 Robin L. Oharna, Secretary 12 13 CITY OF SAN BERNARDINO 14 15 Date: Lon Sassoon, Acting City Manager 16 17 Approved as to Form: ATTEST: 18 19 20 21 22 23 ~ ~ ' t~f James F. Penm~Ci Attorney Rachel Clark, CIty Clerk 24 25 26 27 28 -5- INFORMATION TECHNOLOGY CONTRACT SERVICES FISCAL 2008/2009 This document details the services Information Technology proposes to provide to the Water Department during fiscal 2008/2009 at a contract price of $ 710,700. Office Automation o Provide technical assistance for Water Department office automation servers and domain controllers o Troubleshoot "malfunctioning" Microsoft operating systems and Office products (Word, Excel, Outlook, PowerPoint and Access). o Provide use of the City's file, anti-virus, anti-spam and email servers and processes. o Create, delete, and alter network accounts, scripts, and user folders on the City office automation server as required. o Create, delete, set security and alter emaH, public folders and mailboxes. o Maintain anti-virus software on client and server PCs. Includes installation and upgrades of anti-virus software (semi-annual), anti-virus scan engine (quarterly), and new virus pattern files as they become available. . Provide introductory Outlook training classes as requested. o Audit email content and usage upon request. o Department-wide upgrade to Microsoft Office 2007 GIS o Provide maps and/or reports as requested. (Large maps, map series and special papers are available at cost of materials.) o Add Water district layers as required to ArcGIS. o Continue ArcGIS training and establish an internal City ArcGIS user group. o Provide access to County Assessor data through the parcel layer. o Provide access to year 2000 census data. o Provide access to appropriate GIS layers. o Provide assistance to Water GIS personnel. Web Site o Provide web site hosting on the City web server. o Facilitate direct access to Water Department content on the City web server through the Civica Content Management System (CMS). o Provide Civica CMS user training. o Provide limited web page design and development services. o Publish web site content provided by the Water Department to the City web server. Exhibit" A" . 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/lP network via digital spread spectrum radio bridges. . Provide access to the Internet. . Set up and maintain Internet 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, fiber gigabit links and switched frame relay. . 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 Internet connection and also provide virus filtering on all protocols. . Provide DNS naming service, including name registration and name server management. . Administer maintenance and service contracts for SSC Internetworking, SSC, NPA Computers Inc., Citrix, Accent Computers, Secure Computing and Hewlett Packard/Compaq Inc. . Provide and rnaintain authorized access to the City's local network through a secure web based Remote access system and standards-based VPN. . Install, maintain and troubleshoot Cat Ve UTP cable plant including cables, jacks, wall plates and punch down assemblies. (Major cabling projects, drilling, or new conduit work may be subcontracted, and would represent a cost to Water). . Provide for 'first-defense' anti-spam protection at the firewall level. Financials (WFS) . Provide technical assistance for Harris software (Technical assistance does not include assistance in the use of Harris application software). . This system has been discontinued from active use. However, IT will continue to house and support this system. Exhibit "A" 2 Financials (Sunqard Public Sector) . Administer system at operating system level, including installation and upgrades of the following software: . IBM operating system (OS/400) . HTE Naviline . HTE application software (GMBA, payroll, purchasing/inventory, fleet, etc.) . Develop form and check definitions as required (ACOM EZeDocs) . Perform accounts payable backups on request prior to weekly final register and check processing, and transmit positive pay data to Wells Fargo. . Transmit direct deposit and positive pay data to Wells Fargo. . Provide after hours access and technical assistance to maintenance vendors as necessary. Document Imaqinq . Administer system at server level, including installation and upgrades of the following software: . Microsoft operating system (Windows 2000, 2003 Server) . Microsoft database (SOL Server 2000, 2005) . Provide assistance to Water Department personnel in installation and troubleshooting of client applications. . . . Act as technical liaison to the software vendor in resolving problems as needed. . Provide after hours access and technical assistance to maintenance vendors as necessary. . Provide implementation support of Laserfiche document imaging system. Implementation services include: . Participation in project planning and implementation meetings. . Review of interface configurations. . Technical assistance for installation and configuration of hardware and software. . Assist with the installation and integration of OptiView/OptiSpool. Integration to include working with Water staff to develop back-end interface to Laserfiche. Exhibit "A" 3 Permit T rackinq . 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 (Linus) . Provide access to County Assessor parcel information, Utility Billinq (UB) . Administer system at operating system level, including installation and upgrades of the following software: . IBM Operating system (OS/400) . Existing UB related software programs (Sungard Public Sector (SPS), Naviline, HTEDMS, ltron, Acorn, ITRAN (Remittance Processor), Cog nos QREP) . Act as technical liaison with operating system vendor (IBM), utility billing software vendors (SPS, Itron, Acorn, Cog nos), and remittance processor vendor (TUI), . Provide assistance with setup of user accounts, access, and security at llelA the operating system levels, . Provide after hours access and technical assistance to maintenance vendors as necessary, . Provide technical assistance for Naviline software and existing third party applications (Itron, Acorn, Standard Register, Cognos), (This does not include assistance in how to use Naviline or third party software,), . Maintain support for internally created interface applications (ECC, positive pay, bank drafting), . Provide Cognos Impromptu (QREP) training to report writing staff, . Create and/or assist users in creating reports using Cog nos Impromptu (QREP), . Provide bill design and modification services (QREP), . Provide notification design and modification services using HTEDMS. . Monitor and maintain the automated derogatory file updates for the remittance processor (lTRAN). . Generate and transmit refund check positive pay data to Wells Fargo. . Transmittal of bank drafting data to Wells Fargo. . Establish methods for customers to directly access account information. . Establish procedures for correction and maintenance of service addresses. . Maintain Microsoft SQL 2000 database for Remittance Processing. Exhibit "A" 4 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. . Perform server migration to new hardware as needed. 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. Exhibit "A" 5 4'~ . Operations . Perform daily backups (Monday - Friday) of Sungard application data, Cimage DMS, Triton (HR/Remittance), WUServer, and office automation servers, . Perform weekly, monthly, and year-end full system backups of Sungard, Cimage DMS, Triton (HR/Remittance), WUServer, and office automation servers, . Provide remote backup monitoring for remote servers (ARI EL) . The IT Division is not responsible for backing up data that is not saved to these aforementioned 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, HTE Naviline, Cognos Impromptu, virus protection, Microsoft operating systems and Office suite, . Troubleshoot PC and printer malfunctions, . Provide preventative maintenance for 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 support for special processing, report printing, upgrades, etc, . Administer maintenance contracts for desktop PCs & printers, laptops, and line printers, Exhibit "A" 6 Other . Provide training and guidance to Water Department BSG staff. . IT 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 IT. . Provide hardware / software maintenance tracking and payments for items listed in Attachment 'A'. Water Department shall be responsible for costs in excess of, or in addition to this attachment. . Review & sign-off of requests for technology purchases, monitoring for department wide compatibility and standardization. . Keep the Water Department informed of City technology projects of interest. . Develop simple Microsoft Access and Visual Basic applications. . Complete disaster management plan for mission-critical systems. . Create IT Strategic plan for technology resources. . Develop tools for management to more easily access reports and data from systems. . Manage catalog of all applications, systems and databases that identifies assets available to management. . Manage and coordinate technology projects. . Attend training provided by systems vendors and provide follow-up training to Water Department staff. Notes: The following 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. . A technology replacement fund should be considered (i.e. major server hardware' and software upgrades, network upgrades, PC replacements, printers, etc.) . Additional Civica licensing has been acquired for Intranet Development. Water may wish to review this option for intemal needs. . See Attachment A for Hardware / Software / Subscription costs . Enterprise backup system has been placed on hold for current fiscal year, but should be addressed in 09/10. Stacey Aldstadt, General Manager San Bernardino Municipal Water Department Tom Marek, Director of Information Technology City of San Bemardino Date Date Exhibit "A" 7 z !!. o ~ @ ~ 2 ." -< o .... c; co ." -< o co c; <0 .:. !" - 0> N o o -i o !i!: n o ~ co en N 0> N :.. .... (0 i.o co co en en ~ . .... .... ~ - o o :.. .... .~ -i ~ ~Qopl ~~~ -i:> o n 0"2 ~iii" " m 3 S' " c. 0" " " ~ " ~ ;!. 0- ~ ~ m 3' 3 " " ~ c. 3 " !! ;r '" 3 " S' m ~ " ~ n " -in 0-' -3 !!!." ;;'" 3 0 S' :;: "(Jl ~:;: () e!. o ~ ~ - -" - ~ " " a~ ~ 0 " n ~ (Jl o ~ - CD o o ~ - iil & NN ...... :0:0 en en f.,,)N ........ (Jl ~ o a. o n 3 " " n o a iil n m c. m 3 S' " m c. 0" :;; " !! ~~~a _ VI "::I ,Cf} g, u; " m- 3 ~ ~~rn~a?~~c.-~ =-m;;O-(Qi'-DJO -g>~ ji)!: s- o' ~ U> ;;- o -imgo;;::o::r:>:>J;g:>m s.o.~OC'DCf.I-InSll)s.s.t:! ~g.Ul 3 Cii;m::=.o (II <'O"tl I>>:!E "'o~:s('):,%'3::::!. (')cn-'="'O O')>o~O::l gC'D~~~o_ o::r:s.~; -iii".s~oc.. c)")o,CD9C'D= Ql 0" ~ CD;:!'... !a a -. s:: oS. -. - n.~ C'D :j"u !acr<fil Gl ~'a.::J UI Dl 3 - en -. ::I -. ::l :r ~ 0 0 0" Oo::lcn~!!.(fo3=-' ~ ~i'~o)>5il!2.J!i2 ro g~!e.~Q~~~,r~ tIl :::J (!) G)Q.(bs.::lQ. ~ 3 ~ 3~-cnQ) iD~ g. lUo.U10Cl)C:::l::JVJal Ql ::l::r~ l2 3 0" a. I>> iD 0 ~ D)~tQ~!!.~~g3~ .~. (D Co 0 0 a .2.1-6 (II a. ::I. .... "'::T;+LUI_CD~t2QlI>>::J <II Ui CD _;:-::J 0' 0::1 iir =:: o C::2rcn,...I>>::J~Q. ,;! 0" en 0 \,II::J UJ (II W f Q =*~2 Bg.~ :i g: ~ !il'l=o g.; g~ ~ ::l g> g ii1 0" ~ ~ g. ;;' 3 3' " .. c. o o ::. iil o lit 0' ~ 3: " x 3' o 0; 00> :..'" 0>0 <00 ~o 0>0 - NO- c>>o c.n...... en OO(DO~CD.....OI (J1W O'lOOco.....N<n ow O<OOOlNOOOOOOO1 888~~8g8gg8 - en <0 0> :... 01(0 -00 ...00 00.0. 000 NCO...... ...... CDO"..........O)W............ tOO~cnWONC(11,Jlo. ~8~lS!::!Jtn!::t8~~ OOOOOOc.coo 0000000000 ~Q~~~ii~~ 03=OO~~=3';;!' L:::! C" ....,...., ,.. ra; _.l.Ooo()()Q:I 0- .;~8.CD~gg(jjCll ~CIl. fQ=t~o.o ::::::I:....... !=L Q:I Q:I + 5: 3Q:1~....O)flflOlU) Q:I a 0) O. "#. (jj~"T1CD~1J"'O 5 q,~-<m!J1~g: g. -...J~~ogilro .... CDC/)-,Ilo. -0 ~ o 0 0 lcr ~ ell !" i' .... ~r< m (Jl ~ 0" c::;;-:o- ~_ 0.... <Q:I en Q:I ~ or ell a (jj c: ~ en i:: ell.... (i" g ~Q:I .... 00' a- m ~. ::+ a ~ .... 0 g 0- ~ ii :r Ul (jj ~ ~ a ~ ~ " :0- en W o c; <0 < " ~ c. Q " - o c. c o C!: (Jl " ~ n " ." -< o :::! o co ~ o co a ... z o li U> ~ ~ - c CD 1l g " ~ - o o ~ ~ o lit ;:: " 5' .. ~ " 5:> .. if 00 O::r ::'3 iil " &; " " c. (Jl C 0" ~ o - .;;' - 0- " .. N o o co ;;; o o ...