HomeMy WebLinkAboutR-2004-012 Interlocking Software Corporation AgreementRESOLUTION NO. R-2004- 12
A RESOLUTION authorizing the City Manager of the City of Yakima to execute a
consulting services agreement with Interlocking Software
Corporation to analyze the utility billing/customer service system
requirements of the City of Yakima Finance Department.
WHEREAS, the City of Yakima Finance Department requires an analysis of the
utility billing/customer service system requirements in order to identify possible
solutions to improve communications and interdepartmental workflow; and
WHEREAS, Interlocking Software Corporation has the experience and expertise
necessary to analyze said utility billing/customer service system 'requirements and
identify possible solutions to improve communications and interdepartmental workflow
and is willing to do so in accordance with the terms and conditions of the attached
agreement; and
WHEREAS, the City Council deems it to be in the best interest of the City of
Yakima to authorize execution of the attached agreement with Interlocking Software
Corporation, now, therefore,
BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF YAKIMA:
The City Manager is directed and authorized to execute the attached and
incorporated "Consulting Services Agreement" with Interlocking Software Corporation to,
analyze the utility billing/customer service system requirements of the City of Yakima
Finance Department.
ADOPTED BY THE CITY COUNCIL this 20th day of January, 2004.
Mayor
ATTEST:
Karen S. Roberts, City Clerk
Macintosh HD:Documents:Microsoft User Data:Outlook User Data:Temporary Items: ResrelnterlockingSoftwarec.doc
BUSINESS OF THE CITY COUNCIL
YAKIMA, WASHINGTON
AGENDA STATEMENT
Item No. ` /5—
For Meeting Of I' ..0_13`f
II'EM TITLE: Consulting Agreement for Customer Services System Cortcetual Design
SUBMITTED BY: Rita Anson, Finance Director
CONTACT PERSON/TELEPHONE: Rick Pettyjohn, Information Systems
575-6098
SUMMARY EXPLANATION: The City's existing Utility Billing system is fifteen years
old, utilizes obsolete technology, and requires replacement. In addition to simply replacing
the billing system, we are expanding the new system to a full customer service system that
will better track both customers and service requests in order to provide better service to both
the citizens and the City's utility divisions. In addition, it will improve inter -divisional
communications resolve problems of tracking service requests through our internal processes
and will assist with accounts receivable tracking.
A committee composed of representatives from all the divisions involved in the utility
billing/customer service system has been meeting for the last year to identify problems with
the existing process and requirements for the new system. We now need a conceptual design
that identifies specific data requirements, processes, and inter -divisional workflows. The
Committee has selected Interlocking Software Corporation to develop this conceptual design.
The resulting products will be appropriate as either an internal design document for an in-
house developed system or as the RFP specification for a vendor -developed system.
Interlocking is a Washington State corporation based in Poulsbo. The Committee
selected Interlocking because of their familiarity with municipal government and utility
systems. Interlocking is also very familiar with the Oracle database and development tools
the City uses for system development.
The attached agreement identifies the services Interlocking will perform and the
deliverable products. Funding for this project was appropriated in the 2003 budget and will be
encumbered into the 2004 budget. The total contract amount is $64,890 including travel and
incidental expenses. Interlocking will begin interviews within a couple weeks of contract
approval. The entire process is estimated at 464 hours over a three to four month period.
Resolution XX Ordinance Other (Specify)
Contract XX Mail to (name and address): Robert Johnston, COO, Interlocking
Software, 19472 Powder Hill PI NE Suite 100, Paulsbo, WA 98370 Phone: (360) 779-2600
Funding Source General Fund c —
APPROVED FOR SUBMITTAL:
1
City Manager
STAFF RECOMMENDATION: Approve Resolution
BOARD/COMMISSION RECOMMENDATION:
COUNCIL ACTION: Resolution adopted. RESOLUTION NO. R-2004-12
Interlocking
STATEMENT OF WORK Date:
Interlocking Software Corporation (ILSC)
19472 Powder Hill Place NE Suite #100
Poulsbo, WA 98370-8720
Tel: 360-394-5900 1-800-532-8448
FAX: 360-779-2600
1/5/2004
10801
To:
City of Yakima
129 North Second St
Yakima, WA 98901
Contact: Rick Pettyjohn
Telephone: (509) 575-6098
FAX:
Estimated by: Dawn Johnson
Required Date: 1/29/2004
Work to Be Performed
Perform Business Process Analysis as described in Appendix A (attached)
Description
Hours Rate
Price
Business Process Analysis
10% discount on Interlocking list rates
Travel
Thank you
Total cost:
464
$150
464 $15
$69,600.00
($6,960.00)
$2,250.00
$64,890.00
This SOW represents at: estimate of the work to be performed -Actual time and materials will be billed
This SOW is valid_ for 30 calendar days from the issue date.
This SOW is "not to exceed without written approval from the City Of Yakima"
See Accompanying Professional Services Agreement
Billing occurs bi-weekly Terms are Net 30 Amounts past due greater than 60 days are subject to a /.5% finance charge
Ci
of Yakima, WA
Interlocking `tftw. e Corporation
Authorized Signature
Richard A. Zais Jr., City Manager
Aut orized Sign.
Robert John o , Chief Operating Officer
Print Name and Title
Date
Attest
CITY CONTRACT Q.^.— G
RESOLUTION NO:�
2-3-DL1
InterLocking Software Corporation Professional Services Agreement
Associated to InterLocking Statement of Work #10801
1. Services
Interlocking Software Corporation (Interlocking or ILSC) will provide to the City of Yakima (Client) the
Services specified on the attached ILSC Statement of Work (SOW) or applicable Client work order, under
the terms of this Agreement. Each SOW or work order shall specify the Services and applicable fees, and
will be governed by the terms of this Agreement. To the extent that the terms and conditions of any ILSC
SOW, Work Order, Proposal (or any customer purchase order) entered into between the parties conflict
with or are inconsistent with the terms and conditions of the Agreement, the terms and conditions of this
Agreement shall control.
2. Fees for Services and Termination
Unless otherwise specified in the attached SOW or work order, services shall be provided to Client on a
time and materials basis (T&M). Rates are as specified on the SOW or work order. If a dollar limit is
specified in the SOW the limit shall be deemed an estimate for Client's budgeting and ILSC's resource
scheduling purposes. The estimated dollar amount of the SOW will not be exceeded without written
approval from the City of Yakima. Unless otherwise stated in the SOW any T&M work may be terminated
by providing to ILSC three days written notice of such termination.
3. Travel Expenses
Unless otherwise stated in the SOW or Work Order, Client shall reimburse ILSC for reasonable travel
expenses incurred in conjunction with the services. The estimated dollar amount of travel expenses on the
SOW will not be exceeded without written approval from the City of Yakima.
4. Invoicing and Payment
ILSC shall invoice Client bi-weekly, unless otherwise expressly specified in a Work Order or Purchase
Order. Charges shall be payable within 30 days of invoice date and shall be deemed overdue if they remain
unpaid thereafter. All invoices overdue by greater than 60 days are subject to an interest charge of 1.5%
per month. ILSC has a right to stop services and/or withhold work product if Client fails to pay invoices
within 60 days of City's receipt of such invoices.
5. Taxes
The charges do not include taxes. Any taxes resulting from this Agreement or activities resulting from this
Agreement, including but not limited to sales and/or use tax, and exclusive of business and occupations
taxes and taxes based upon net income, will be the responsibility of the Customer.
6. Term
This agreement shall commence on its Effective Date, which is the date on the Statement of Work
accompanying this Agreement. Client may terminate this Agreement at any time, with or without cause, by
providing ILSC with three days written notice. Client will have an obligation to pay ILSC for any portion
of the work completed prior to termination of the contract.
7. Warranty and Indemnification
ILSC warrants that the Services will be performed consistent with generally accepted industry standards.
8. Limitations on Warranty
CLIENT MUST REPORT ANY DEFICIENCIES IN THE SERVICES TO ILSC IN WRITING WITHIN
SIXTY (60) DAYS OF COMPLETION OF THE SERVICES IN ORDER TO RECEIVE WARRANTY
REMEDIES LISTED IN 9 BELOW. THE WARRANTY HEREIN IS EXCLUSIVE AND IN LIEU OF
ALL OTHER WARRANTIES, WHETHER EXPRESS OR IMPLIED, INCLUDING TIM IMPLIED
WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE AS SET
FORTH IN PARAGRAPH 9 OF THIS AGREEMENT.
9. Exclusive Remedy
For any breach of the above warranty, Client's exclusive remedy, and ILSC's entire liability, shall be the
reperformance of the Services. If ILSC is unable to reperform the Services as warranted, Client shall be
entitled to recover the fees paid to ILSC for the deficient services.
10. Relationship between the Parties
ILSC is an independent contractor; nothing in this Agreement shall be construed to create a partnership,
joint venture, or agency relationship between the parties. Each party will be solely responsible for payment
of all compensations owed to its employees, as well as employment related taxes. Each party will maintain
appropriate worker's compensation for its employees, as well as employment related taxes.
11. Authority to Enter Into Agreement
2
Initials: ILS
Client
InterLocking Software Corporation Professional Services Agreement
Each party to this Agreement has the authority to enter into and form this Agreement. The individuals
signing the Agreement have the authority to act as agents of their respective organizations. Each party
acknowledges that they have read this Agreement and will abide by it.
12. Force Majeure
Neither party will be considered to be in default of this Agreement as a result of events beyond their
reasonable control. For purposes of this Agreement, such acts shall include, but are not limited to, acts of
God, catastrophe, or other "force majeure" events beyond the parties' reasonable control.
13. Assignment of Contract
The Client may not assign the Agreement or its responsibility for payments to any organization, without
written approval by ILSC. ILSC may not assign its responsibilities for performance under the Agreement
to any organization without written approval of the client.
14. Hold Harmless Indemnity
If applicable, Client asserts it possesses all the rights and interests in the data and/or licensed software
necessary to enter into this agreement, and shall indemnify and hold ILSC, its agents and employees
harmless from any loss, damage or liability for infringement of any United States patent right or copyright
with respect to the use of the licensed software; provided that Client is notified in writing within ten
calendar days of suit or claim against ILSC, ILSC permits Client to defend, compromise or settle said claim
of infringement and give Client all available information, assistance and authority to enable Client to do so,
provided ILSC fully observes all the terms and conditions of this Agreement. Further, ILSC asserts it
possesses all the rights and interests in the data and/or licensed software necessary to enter into this
agreement, and shall indemnify and hold Client, its agents and employees harmless from any loss, damage
or liability for infringement of any United States patent right or copyright with respect to the use of the
licensed software; provided that ILSC is notified in writing within ten calendar days of suit or claim against
Client. Client permits ILSC to defend, compromise or settle said claim of infringement and give ILSC all
available information, assistance and authority to enable ILSC to do so, provided Client fully observes all
the terms and conditions of this Agreement.
15. Confidentiality and Non -Disclosure
Except as legally required, the parties agree that neither party shall directly or indirectly disclose or use any
Confidential Information without prior written permission from the other party. "Confidential Information"
means any type of confidential or proprietary information or material disclosed to or known by the
Recipient of such information ("Recipient") as a consequence of or through its relationship with the party
disclosing such information, and consisting of information conceived, originated, discovered, or developed
in whole or in part by Recipient, which is not part of the public domain or otherwise generally available to
the Recipient form independent sources, including but not limited to information which relates to research,
development, trade secrets, know-how, inventions, technical data, hardware, software, source codes, object
codes, manufacture, purchasing, accounting, engineering, marketing, merchandising and selling, business
labs or strategies, and information entrusted by third parties to the party disclosing such information.
16. Nonsolicitation of Employees
During the period that this Agreement is in effect and for a period of six (6) months after termination or
expiration thereof, each party agrees not to solicit for employment any technical or professional employees
of the other party assigned to work on the Project without the prior written approval of the other party.
17. Insurance
a. Commercial Liability Insurance - On or before the date this Agreement is fully executed by the
parties, the Consultant shall provide the City with a certificate of insurance as proof of commercial liability
insurance with a minimum liability limit of One Million Dollars ($1,000,000.00) combined single limit
bodily injury and property damage. The certificate shall clearly state who the provider is, the amount of
coverage, the policy number, and when the policy and provisions provided are in effect. Said policy shall
be in effect for the duration of this Agreement. The policy shall name the City, its elected officials, officers,
agents, and employees as additional insureds, and shall contain a clause that the insurer will not cancel or
change the insurance without first giving the City thirty (30) calendar days prior written notice. The
insurance shall be with an insurance company or companies rated A -VII or higher in Best's Guide and
admitted in the State of Washington.
b Commercial Automobile Liability Insurance. - On or before the date this Agreement is fully
executed by the parties, the Consultant shall provide the City with a certificate of insurance as proof of
commercial automobile liability insurance with a minimum liability limit of One Million Dollars
($1,000,000.00) combined single limit bodily injury and property damage. The certificate shall clearly state
3
Initials: ILSC
Client
InterLocking Software Corporation Professional Services Agreement
who the provider is, the amount of coverage, the policy number, and when the policy and provisions
provided are in effect. Said policy shall be in effect for the duration on this Agreement. The policy shall
name the City, its elected officials, officers, agents, and employees as additional insureds, and shall contain
a clause that the insurer will not cancel or change the insurance without first giving the City thirty (30)
calendar days prior written notice. The insurance shall be with an insurance company or companies rated
A -VII or higher in Best's Guide and admitted in the State of Washington.
18. Survival of Rights
The rights and responsibilities of sections 14, 15, and 16 shall survive the termination of this Agreement.
19. Severability
All provisions of the Agreement are severable and no provision hereof shall be affected by the invalidity of
any other such provision.
20. Governing Law and Venue
This Agreement shall be governed by and construed in accordance with the laws of the state of
Washington. Venue shall be in Yakima County, Washington.
21.Compliance With Law.
ILSC agrees to perform those services under and pursuant to this Agreement in full compliance with any
and all applicable laws, rules, and regulations adopted or promulgated by any governmental agency or
regulatory body, whether federal, state, local or otherwise.
22. Notices
Unless stated otherwise herein, all notices and demands shall be in writing and sent or hand delivered to the
parties to their addresses as follows:
TO CITY
TO ILSC
Richard A. Zais
City Manager
City Hall
129 North 2"d Street
Yakima, Washington 98901
James Page
Chief Financial Officer
19472 Powder Hill PI NE
Poulsbo, WA 98370
Or to such other addresses as the parties may hereafter designate in writing. Notices and/or other demands
shall be sent by registered mail, postage prepaid of hand delivered. Such notices shall be deemed effective
when mailed or hand delivered at the addresses specified above.
23. Entire Agreement
This agreement constitutes the complete agreement between the parties and supersedes all previous and
contemporaneous agreements, proposals, or representations, written or oral concerning the subject matter of
this Agreement. Neither this Agreement nor a Work Order or Purchase Order may be modified or amended
except in writing signed by a duly authorized representative of each party: no other act, document, usage,
or custom shall be deemed to amend or modify this Agreement, a Work Order, or Purchase Order. It is
expressly agreed that any terms and conditions of Client's purchase order shall be superseded by the terms
and conditions of this Agreement and the applicable Work Order.
4
Initials: ILS
Client
Appendix A
SOW 10801
City Of Yakima
Business Process Analysis
Utility Billing and Customer Services
Appendix A Scope Of Services Page 1 of 7
I. Scope of Services
The objective of this engagement is to provide the City of Yakima with detailed
requirements documentation. The requirements analysis is in support of a new
Utility Billing/Customer Service Solution, with an emphasis on improved
communication and interdepartmental workflow continuity. The deliverable
documentation will be appropriate either as a conceptual design document for a
Yakima in-house system development project or as the specification section of a
Request for Proposal for a vender -developed system. In meeting this objective,
InterLocking Software will perform an in-depth analysis of existing Utility Billing /
Customer Services business practices, document existing processes and
procedures, identify areas for improvement, and recommend viable solutions.
The analysis shall include a review of the business processes within the Customer
Services, Wastewater, Water and Irrigation, and Refuge Utility Divisions. We will be
taking a close look at utility account management as well as billing and collection
processes performed within the financial and customer service departments. This
analysis effort will give substantial consideration to work areas within the Engineering
and Code Enforcement departments, which the Utility Billing process is reliant on
such as the issuing of a permit in support of establishing a new utility account. Other
processes within these departments that have potential common threads to the Utility
Billing/Customer Service processes such as complaints and inspections will also be
reviewed.
Along with the business process, this engagement will include a review of the
existing systems that the Utility Billing/Customer Service process are directly or
indirectly dependent on. The systems review will consider the common functionality
between the Utility Billing and Work Order systems and potential interface
requirements
More specifically, InterLocking Software will:
A. Review existing policy, procedure and system documentation.
1. Document policies, procedures and systems
B. Conduct exploratory interviews with management level personnel from City
Administration, Public Works, Community & Economic Development, and
Financial departments.
1. Document project vision
2. Document project constraints
C. Conduct exploratory interviews with staff level personnel from Information
Technology, City Administration, Public Works, Community & Economic
Development, and Financial departments.
1. Document policies, procedures and systems.
2. Document inter/intra-departmental functions.
3. Document business rules.
4. Document reporting requirements.
D. Develop a Utility Billing Procedure Manual
Prepare documentation which defines current Customer Service and
Billing business process. This document will take into consideration core
business processes in all functional areas and be written in a Procedure
Manual format as per attached sample documentation.
E. Develop a detailed interdepartmental Business Process Model
Appendix A Scope Of Services Page 2 of 7
Prepare a comprehensive activity decomposition model that serves as the
foundation for a detailed requirements document. This model is used to
describe how a process works (AS -IS) and/or how a process could work
(TO -BE). The activity model shows the data needed to support a
business process, identifies job roles and responsibilities of departments
and employees, uncovers process inconsistencies, identifies redundancy,
and acts as an effective communication medium between technical and
non-technical stakeholders.
F. Develop a detailed functional hierarchy diagram.
Prepare a detailed functional hierarchy diagram describing the potential
categorization of business functions into application modules. The
hierarchy diagram serves as a guide to further system design and
development efforts.
G. Draft a clear text requirements document.
Develop a detailed requirements document suitable for use as an internal
or external design roadmap This document is based on the business
rules detailed in the business process model.
II. Assumptions
As a condition of our involvement on this engagement, InterLocking Software
assumes that the City of Yakima will provide the following:
A. Open access to existing documentation.
B. Open access to management and staff.
C. Dedicated consultant workspace with Internet access.
D. Timely scheduling of on-site information gathering meetings.
E. Timely response to information gathering requests.
III. Project Management, Documentation and Modeling Tools
InterLocking Software utilizes a standard set of project management, documentation
and modeling tools comprised of the following:
A. Microsoft Project
1. Used for general project management.
B. Microsoft Office
1. Used for clear text documentation.
C. Microsoft Visio
1. Used for process flow diagramming
D. Adobe Acrobat
1. Used for portable document creation and delivery.
E. Computer Associates AllFusion Business Process Modeler (BPWin)
1. Used for activity decomposition process modeling.
F. Oracle Designer
1. Used for entity -relationship modeling and systems design.
Appendix A Scope Of Services Page 3 of 7
IV. Schedule
This engagement is scheduled to begin on January 29th 2004. The estimated length
of this engagement is ten (10) weeks. The anticipated level of effort for this
engagement is 464 hours.
V. Staffing
This project is expected to be staffed by the following InterLocking Software
personnel:
A. Dawn Johnson - Project Manager and Senior Analyst
B. Joanne Landry - Systems Analyst
VI. Reporting
Throughout the engagement, Interlocking will submit bi-weekly status reports fisting
accomplishments to date, upcoming tasks, out of scope items, risk factors, and
current service fee / expense accruals.
VII. Deliverables
The deliverables associated with this engagement are as follows.
A. Bi -Weekly status reports.
B Procedure Manual (MSVisio MSWord)
1. Bound hard copy
2. Electronic copy in PDF format
C Detailed activity decomposition model (BPWin)
1. Bound hard copy.
2. Electronic copy in PDF format.
D. Detailed functional hierarchy diagram (BPWin)
1. Bound hard copy.
2. Electronic copy in PDF format.
E. Detailed requirements document (MS Word)
1. Bound hard copy.
2. Electronic copy in PDF format.
3. Electronic copy in MSWord format.
Appendix A Scope Of Services Page 4 of 7
Activity
Financial Data
Controls on the
activity
Roquteiion VaMabn Data
Outgoing Transactions
Resided Requisilions
■
Incoming Requisition Packages
incoming Non Repine tior.
Transacilions
Mechanisms used
to perform the
activity
Input and output
related to the
activity (data)
Computer
Systeme
Communication
Devices
Storage Device
NODE
A0
I. TLE
MANAGE THE FUNDING AND PROCESSING OF OUTFTTtING REOUISITIONS
NUMBER.
Appendix A Scope Of Services
Attachment 1
Page 5 of 7
NO 0
PROPERTY IDENTIFICATION PROCESS
Level 111
Process
Definition
Document Processing
Based on recorded or submitted documents, 1) existing accounts
are updated to reflect changes in ownership, address, description,
etc., or are flagged for specific additional processing, 2) existing
accounts are eliminated or superseded, 3) new accounts are
created. This set of amended accounts are forwarded for appraisal
and or assessment
Unrecorded
Document
submitted or
retrieved
NO—
Document
Processing J
Document
Recorded?
YES
Recorded >
1/12/98?
Recorded
Document retrieval
(microfiche or
book and page)
—YES ►
HP and Paperclip
Query of Recorded
Docs, and Print
Copy
Clear Text
Description
of Process
Certain documents are not required (per Idaho Code) to be recorded for
processing for assessment purposes (proper muniment of title, court orders
- which would be part of the separate court filed documents, death
certificates, wills, etc.) These types of documents would most likely be
submitted to the Assessor's Office by the property owner or their agent.
Recorded documents have been scanned and archived after 1/12/98,
however, certain documents may have been missed, or may be referred to
within the more recent recordings. Documents recorded between 3/28/72
and 1/23/98 may be retrieved from microfiche/microfilm, and prior to 3/28/72
from the original deed books. Index searching for undetermined
instruments is performed thru Reflections (HP minicomputer terminal
emulator) for documents recorded 1/2/98 to present. and by tract sheet for
prior dates. These searches are performed routinely, both as part of current
processing tasks and internal and external customer requests. Search
criteria includes grantor/grantee name, date, legal description, document
type, etc.
Idaho Code requires the Assessor's Office to maintain parcel ownership
records based on conveyance documents recorded with the County
Recorder. Scanned documents are first queried (in PCLIP) by recording
date and document type, and printed for further workflow processing The
documents not initially queried are subsequently reviewed for possible
indexing errors, and printed as necessary for processing. An HP query -to-
print (documents by recording date and doc type) is provided to the
assessor by the recorder (or run by the mapping department) to QC that all
pertinent documents have been retrieved. Additionally, the HP will be
queried to create a digital file containing document info, for import into the
Title DB to automate data entry.
Appendix A Scope of Services Page 6 of 7
Attachment 2
UNDINE
PROCE
OF OUTF
MAINTAIN
ADMINISTER SYSTEM g ADMINISTE
FUNDING : PROCESSING SYSTEM
y CONTROLS g
Al A2g A3
PROVIDE
MANAGEMEN
DATA
A5
RECEIVE
INCOMING
REQUISITION*
PACKAGE y
A.44...142
PREPARE e.
REQUISITION:,
FILES
A4.1.2.2
PROCESS A MONITOR
REQUISITION REQUISITION•
A4 2;` A4 3
•
RECEIVE
REQUISITION .
PACKAGES `
REQUIRING ..
MANUAL !NINA:
•_,_ _ _: A41 1.1
RECEIVE
REQUISITION
PACKAGES VIA
ELECTRONIC
TRANSMISSIOt
• • • • A4.1 1 2r
-
+ REVIEW
:: REQUISITIONS:
'• FILES
A41 21
CONTACT ;•
p CUSTOMER
FORPROCESS
ADDITIONAL
INFORMATIOh�
A41 2?r•
PERFORM EDITS '
NECESSARY FOR%
CONTINUED
PROCESSING !
A4.1.23;
; DELAY INPUT
OF REQUISITION ;
WITH FUTURE
JULIAN DATE
C
A4.1.2..
SELECT TO NEVEf
THE
REQUISITION
A4 1 2,
SORT
REQUISITIONS I,
FOR
$ PREPROCESSING
_• ..
A4 1 2.5e
PROCESS
'P' FILE
A41 31
NVERT
ECOR
•
PROCESS
REQUISITION
THROUGH
NEWSTAT
A4.1.3.3.
NODE:
AO
TITLE MANAGE THE FUNDING AND PROCESSING OF OUTFITTING REQUISITIONS
NUMBER.
Appendix A Scope of Services
Attachment 3
Page 7 of 7
BUSINESS OF THE CITY COUNCIL
YAKIMA, WASHINGTON
AGENDA STATEMENT
Item No. 15—
For Meeting Of I- a0-tY
ITEM TITLE: Consulting Agreement for Customer Services System Co
SUBMITTED BY: Rita Anson, Finance Director
CONTACT PERSON/TELEPHONE: Rick Pettyjohn, Information Systems
tual Design
575-6098
SUMMARY EXPLANATION: The City's existing Utility Billing systemis fifteen years
old, utilizes obsolete technology, and requires replacement. In addition to simply replacing
the billing system, we are expanding the new system to a full customer service system that
will better track both customers and service requests in order to provide better service to both
the citizens and the City's utility divisions. In addition, it will improve inter -divisional
communications resolve problems of tracking service requests through our internal processes
and will assist with accounts receivable tracking.
A committee composed of representatives from all the divisions involved in the utility
billing/customer service system has been meeting for the last year to identify problems with
the existing process and requirements for the new system. We now need a conceptual design
that identifies specific data requirements, processes, and inter -divisional workflows. The
Committee has selected Interlocking Software Corporation to develop this conceptual design.
The resulting products will be appropriate as either an internal design document for an in-
house developed system or as the RFP specification for a vendor -developed system.
Interlocking is a Washington State corporation based in Poulsbo. The Committee
selected Interlocking because of their familiarity with municipal government and utility
systems. Interlocking is also very familiar with the Oracle database and development tools
the City uses for system development.
The attached agreement identifies the services Interlocking will perform and the
deliverable products. Funding for this project was appropriated in the 2003 budget and will be
encumbered into the 2004 budget. The total contract amount is $64,890 including travel and
incidental expenses. Interlocking will begin interviews within a couple weeks of contract
approval. The entire process is estimated at 464 hours over a three to four month period.
Resolution XX Ordinance Other (Specify)
Contract XX Mail to (name and address): Robert Johnston, COO, Interlocking
Software, 19472 Powder Hill P1 NE Suite 100, Paulsbo, WA 98370 Phone: (360) 779-2600
Funding Source General Fund
APPROVED FOR SUBMITTAL: a
City Manager
STAFF RECOMMENDATION: Approve Resolution
BOARD/COMMISSION RECOMMENDATION:
COUNCIL ACTION: Resolution adopted. RESOLUTION R-2004-12