HomeMy WebLinkAboutContract 39475-B12..
' APPENDIX 8-12
CITY SECRETARY .
CONTRACT NO. oq L\ 1 ~ --Bf &-
In accordance with the Professional Services Agreement signed between Matrix
Resources Inc. (Contractor) and the City of Fort Worth (Client) on October 2, 2009 City
Secretary Contract ("CSC") 39475, as amended by CSC No. 39475-A 1, on September
13, 2010, and CSC No. 39475-A2 on December 14 , 2010, (collectively the "Professional
Services Agreement"), this Appendix B-12, is incorporated into the Professional
Services Agreement and hereby read as follows:
1. The term of this work order shall be extended to end when all services have
been completed under this work order as contemplated herein, but not later
than the end date set forth below.
2. This Work Order incorporates by reference all of the terms and conditions of
the Professional Services Agreement, specifically the services to be provided
under Section 1 of said agreement.
3. The services to be performed under this Work Order shall be as follows:
3.a The STARS application review will include (Not to exceed 80 hours):
• Analysis of the process to determine the appropriate risk factors and their level
of risk
o Segregation of duties
o Written procedures
o Appropriate approval procedures
o Content of data (name, address, birth date, social security number, bank
data , driver license number)
• Verify the access security
o Individuals-active and appropriate employees, no defaults or contractors
(EDP assistance if electron ic compatible file)
o Level access appropriate-update, read , delete
o Maintenance ProceduresNersion Update Control
o Server location/security level
o Transmission security, encryption
o Data file security, encryption
o Document security
o Backups and Recovery procedures
o Employee Security Forms Signed
• Interviews should determine
o Flow of data for the work process
o Authorization process for settlement, including triggers for payment
o Determine if rotating vendor number is in use
o Obtain an electronic list of all payees and addresses for the past 2 years
for review tests by EDP Auditor
o Aging procedures/reports are active for all records to ensure processing is
timely and complete
o Department unders of data security regulations/responsibilities
• Testing issues
o Universe for selecti ~FFICIAL RECORD
CITY SECRETARY
FT. WORTH, TX
.. . -
• Open/closed
o Authenticate settlement payment
o Records in Law match the cases in the application
o M&C list matched to payments and cases in the system
• Name and address verification
• Cancelled check verification
o Stratify aging to determine stale or misdirected items
3.b The CLASS application review will include (Not to exceed 160 hours):
• Identifying revenues processed by the application and exceptions
• Documenting procedures used to determine risks for the completeness of
revenue reporting from the source (childcare is a specific concern)
• Documenting policies and procedures affecting the rates charged for the same
services
• Documenting polices and procedures for recording and verification of revenues
• Verifying the general ledger reconciliation practices by reconciling the application
revenue, interface report revenues and posted general ledger results
o 2nd quarter FY2011 (January, February , March of 2011)
o Refunds processed properly approved and accurate posting
o Refunds tested for appropriate disbursement
o Clearing accounts balances accurate
• Verifying the access security
o Individuals-active and appropriate employees , no defaults or contractors
(EDP assistance if electronic compatible file)
o Level access appropriate-update , read , delete
o Maintenance ProceduresNersion Update Control
o Server location/security level
o Transmission security, encryption
o Data file security, encryption
o Document security
o Backups and Recovery procedures
o Employee Security Forms Signed
Personnel assigned to provide services under this Work Order:
Name :
Start Date :
End Date :
Payment Terms:
Nicholas Adnani
July 18 , 2011
August 26 , 2011
Payment Rate : $80.00 per hour
AGREED AND ACCEPTED:
CITY OF FORT WORTH
~~ Assistant City Manager
Date: _ ___.?~/;L.....L..J_/(.....__! __ _
MATRIX RESOURCES INC .
~ //A~ ~.~~
Name
LJ;ea~~~ ~ Sa.h
Title
0/~0 /2-0 f,
Date I I
NO M&C REQUIRED
OFFICIAL RECORD
CITY SECRETARY
FT. WORTH, TX