HomeMy WebLinkAboutAmendment to Agreement - Systems and Software - Utility CIS ProjectBUILDING
227 W. JEFFERSON BOULEVARD
R �
,
i"865
CITY OF BEND PETE BUTTIGIEG, MAYOR
BOARD OF PUBLIC
May 28, 2019
Fred Taylor
Systems and Software
10 E. Allen Street
Winooski, VT 05404
RE: Amendment to Agreement
Dear Mr. Taylor:
PHONE 574/235-9251
FAx 574/235-9171
The Board of Public Works, at its meeting held on May 28, 2019, approved the above
referenced amendment to complete data conversion for the Utility CIS Project in the amount
of $151,725.
Enclosed please find a copy of the agreement for your records.
If you have any further questions regarding this matter, please call this office at (574) 235-
9251.
Sincerely,
Linda M. Martin, Clerk
Enclosure
GARY A. GILOT GENEVIEVE E. MILLER ELIZABETH A. MARADIK LAURA L. O'SULLIVAN THERESE J. DORAU
Systems
& Software
Title: Data Extraction Process
City of South Bend
CIS Implementation Project
Project Change Order
Summary of Business Requirements & Reason for Proposed Change
S&S to provide the data extract services that were contracted to be performed by the City of South Bend. nd. This was
requested by the City due to the unplanned departure of a key resource on their core project team.
S&S will develop a repeatable data extract process and complete the associated tasks originally contracted to be
completed by the City of South Bend as follows:
• Develop an extraction process.
• Extract raw HTE data from legacy source and load into the S&S databases as Oracle tables.
• Create custom programs to populate staging tables (for tables already reviewed and in scope)
• Generate balancing / validation data from populated staging tables and reconcile to raw HTE data
• Modify conversion execution due to change in ETL strategy
• Create custom program in TalenD to convert documents
• Perform the City of South Bend conversion tasks related to Conversion 1, Conversion 2, Simulation
conversion and Go -live conversion.
The tasks identified above will added in the Statement of Work (SOW) originally defined in Exhibit 4 of the
Information Services Agreement and signed on November 28, 2018. The change order rate identified in section 6.1.3
of the SOW ($175.00/hr) will apply for this change order.
Impact to Project Schedule:
Conversion 1 to be completed within 120 days from date of signing.
The following risk is identified:
• The project cannot proceed to conversion 1 until an agreement is reached on the data extract process.
Impact on Existing Deliverables:
• Deliverable 26 that was a responsibility of the City of South Bend will become the responsibility of S&S,
however it will still be tied to Milestone 8.
« Otherwise, this will not impact the scope or milestone acceptance criteria of the existing in scope Milestones.
CO-01 Page 1 of 4
Detailed osting
Costs
Analysis
$21, 350.00
Conversion 1
$72,450.00
�_ ............ ...................
Conversion 2
$27.475.00
Simulation conversion
$15,225.00
Go -live conversion .......m .......... _... _. ._.
$ . 15,225,225.00
.._.......................... __._........... ..
Year 1 Costs
$151,725.00
Summarized Costing & Work Breakdown
Development $0.00
Professional Services - $151,725.00
Subtotal _. $151,725.00
° Development) — n/a on this _ ....... _
Year 1 Maintenance & SuPP ort 20 /° of Develo ment CO $0.00
Year 1 Costs $151,725.00
CO-01 Page 2 of 4
Terms and Conditions:
1. This change order has been submitted, assessed and approved by the PMO Team and
the Executive Sponsors. Signed Approval of this document indicates it will be executed
as described.
2. Year 1 Maintenance & Support, if applicable, will be prorated from signing date to your
Support renewal date.
Signed: Date:
C4ofSoBend Executive Sponsor: Al Greek
9 ft
L
Sined:��� Dater w
,
City of South Ben Project Manager: Stan Harris
Signed: Date: May 14, 2019
S&S Executive Sponsor: Dana Lendorf-McCarthy
Signed; Date: May 14, 2019
S&S Project Manager: Fred Taylor
V
CO-01 Page 3 of 4
BOARD OF PUBLIC WORKS
AGENDA ITEM REVIEW REQUEST FORM
Date 5-20-19
Name Kim Thompson Department Utilities
BPW Date 5/28/19 Phone Extension 5969
o ,�,n, m,. , u w�a� vnmiwuwuuimuuwuwuwuwwimiui ,wmv wnHw�mmcse✓wvar�emuumu�mmm Jffiiwwwiucman iarnmaermnisrr �v! .. .
..... .�,.�.................... . _.........
lec� cd Prior to Submittal to Board
BPW Attorney Attorney Name Clara McDaniels
Dept. Attorney ❑ Attorney Name
Purchasing Michael Schmidt
Check the Appropriate Item Type --
Professional Services Agreement n Contract
Open Market Contract E]
Amendment/Addendum
Bid Opening F
Bid Award
Quote Opening ❑
Quote Award
Proposal Opening
C/O & PCA No.
® Chg. Order, No. 1 [
Traffic Control
❑ Other:
Company or Vendor Name
New Vendor
MBE/WBE Contractor
Project Name
Project Number
Funding Source
Account No.
Amount
Terms of Contract
Purpose/Description
Information
All Submissions
Proposal
E Special Purchase, QPA
Req. to Advertise
IE] Reject Bids/Quotes
[:] PCA
E Resolution
❑ Ease./Encroach
❑ Title Sheel
Systems and Software
❑ Yes If Yes, Approved by Purchasing
❑ No
❑ MBE Completed E-Verify Form Attached ❑ Yes
❑ WBE F-1 No
Water Works O&M
620-0640-587-3910
$151,725.00
CO for S&S to complete data conversion for Utility CIS
project
For Change Orders Only
Amount of increase 1 0
Decrease �15172 � 0..
A,.. _..........
Previous Amount $
Increase�....................................__ _.....���� �...........................................................��....e............... �.�...............................................
Current Percent of Change: Decrease (10%)
New Amount $_ _
Increase__�.,,.........�..�.�.�....................................................m.m__...�. ............................................................_.�.0 ,,,,..... �....
%
Total Percent of Change: Decrease ( %)
Time Extension Amount:
New Completion Date: