Laserfiche WebLink
EXHIBIT A <br />SCOPE OF WORK <br />City of Santa Ana CARES Act Utilities Assistance Grant <br />Program First Level Data Migration Project <br />Proposed Scope of Work and Compensation Costs for <br />Post Program Close-out & Record Retention Preparation <br />and Migration <br />Submitted by Consultant, Managed Career Solutions, SPC - 12/14/2020 <br />Consultant will perform/provide the following services: <br />1. Master File <br />• Complete list of all applicants; exported from the Submittable Database <br />• Data will be cleansed to ensure data is accurate, complete, and searchable <br />• Merge all three applicant language databases into one database <br />o English <br />o Spanish <br />o Vietnamese <br />• Data will be provided to City as an .xIsx file <br />• Each applicant will have a unique identifier which will be used to link all necessary <br />documentation for an applicant <br />• Each applicant awarded a grant will be identified as such and will reference the Batch number <br />in which their grant was funded <br />2. Initial Supporting Documentation for each Applicant - submitted at time of initial application <br />• Export, from Submittable, a Zip folder for each applicant <br />• Zip folder will contain: <br />o PDF file of application submitted, by applicant <br />o Supporting documentation submitted by applicant at time of initial application <br />• Rename each folder to a standard file naming convention <br />• Identify and rename each document, within the folder, to a standard file naming <br />convention <br />3. Follow -Up Supporting Documentation for each Applicant - submitted as follow-up <br />documentation <br />• Review each application for documentation that was submitted subsequent to the initial <br />application <br />• Download PDF or JPEG/PNG (original file format) of supporting documentation <br />111'age <br />