Laserfiche WebLink
Systems <br />& Software <br />Title: Data Extraction Process <br />City of South Bend <br />CIS Implementation Project <br />Project Change Order <br />Summary of Business Requirements & Reason for Proposed Change <br />S&S to provide the data extract services that were contracted to be performed by the City of South Bend. nd. This was <br />requested by the City due to the unplanned departure of a key resource on their core project team. <br />S&S will develop a repeatable data extract process and complete the associated tasks originally contracted to be <br />completed by the City of South Bend as follows: <br />• Develop an extraction process. <br />• Extract raw HTE data from legacy source and load into the S&S databases as Oracle tables. <br />• Create custom programs to populate staging tables (for tables already reviewed and in scope) <br />• Generate balancing / validation data from populated staging tables and reconcile to raw HTE data <br />• Modify conversion execution due to change in ETL strategy <br />• Create custom program in TalenD to convert documents <br />• Perform the City of South Bend conversion tasks related to Conversion 1, Conversion 2, Simulation <br />conversion and Go -live conversion. <br />The tasks identified above will added in the Statement of Work (SOW) originally defined in Exhibit 4 of the <br />Information Services Agreement and signed on November 28, 2018. The change order rate identified in section 6.1.3 <br />of the SOW ($175.00/hr) will apply for this change order. <br />Impact to Project Schedule: <br />Conversion 1 to be completed within 120 days from date of signing. <br />The following risk is identified: <br />• The project cannot proceed to conversion 1 until an agreement is reached on the data extract process. <br />Impact on Existing Deliverables: <br />• Deliverable 26 that was a responsibility of the City of South Bend will become the responsibility of S&S, <br />however it will still be tied to Milestone 8. <br />« Otherwise, this will not impact the scope or milestone acceptance criteria of the existing in scope Milestones. <br />CO-01 Page 1 of 4 <br />