2017-398-E IT - Computer Aid, Inc. for staff augmentation services for Crystal Reports resource

Browse Search

DocuSign Envelope ID:AA2ADDIB-1E78-4ECF-92C7-C463C4C2E397 Statement of Work: Attachment A August 21st, 2017 Description of Services: Computer Aid, Inc. will provide Kenneth Lawrence, Crystal Reports and SQL consultant, in a staff augmentation, time and materials capacity. The resource will be under the direction of Orange County management. Provider agrees to make best efforts at the following: - The schedule is 40 hours per week. The person is expected to be on site in the West Campus Office Building at 131 West Margaret Street, Hillsborough, NC for 40 hours per week. - The job requirements for experience and background: o 3+ years of experience writing crystal reports from SQL databases o SQL database knowledge sufficient to allow the individual to be self-starting when it comes to looking at tables, finding fields needed for the reports, etc. o Ability to work independently with limited supervision o Strong organizational skills with attention to detail o Ability to consult with customers to assist with SQL and data concerns - The primary function of this resource is Report writing using Crystal Reports. To accomplish this they will need to use their knowledge of SQL and data modeling to understand where to retrieve appropriate information required for the reports. - It is expected that after one week of familiarizing themselves with the data model and the environment, the resource will be able to begin writing reports. - The reports are of various complexity and length so cannot be quantified ion a "reports per hour" expectation. Knowledgeable staff will be managing the function and will meet regularly with the resource to discuss expectations, manage workload, and give feedback. The resource will need to meet productivity and accuracy as would be expected when hiring a person with the skills listed in the job outline above. - The listing of required reports is compiled and the resource will need to work through this listing until complete. - If the resource cannot meet productivity and accuracy expectations, Orange County will request a replacement. - No training from Orange County will be necessary Start Date: August 21st, 2017 End Date: December 16th, 2017 Pricing: Computer Aid, Inc. will bill Orange County on a Time and Materials basis. This Statement of Work will be valid for up to 4 months of approved budget for the Computer Aid, Inc. consultant to bill against. Upon completion of the 4 month contract, this SOW will either be closed as complete or Orange County will have the option to extend this engagement using a CAI Change order. Approved expenses will be billed as incurred at actuals. The billing rate is $60.00 per hour. Billing will occur on a monthly basis. Payment Terms: Net 30 days. The duration of this effort may be modified or amended as mutually agreed to by both parties in writing.