Loading...
HomeMy WebLinkAbout2009-002 Tax - BSCA Systems Consulting - Contract for System Evaluation (Software Consulting-Revenue-Assessors)County.of Orange,.NC: and BSCA,~Inc~-.Software....Consultin~ ........................................._........................1 of.4.,. ...................~,5~ BSCA Systems Consulting CONTRACT FOR :ounty of Orange North Car 1 i na ~e ~ S Uc o~ ~ ¢~ cc ~ N y • • ~~C ~~ h~o~o SYSTEMS CONSULTING C O N T R A C T BARRY STROCK CONS IG ASSOCIATES, INC. 154 ROSEMONT STREET, ALBANY, NY 12206 JANUARY 8, 2009 County of.Orange,.NC:.and BSCA, Inc. -Software...Consulting ..................................................................2.of 4........................................... BSCA Consulting Contract with Orange County, North Carolina Barry Strock Consulting Associates, Inc., (hereinafter referred to as BSCA) offices located at 154 Rosemont Street, Albany, NY 12206, will provide consulting services to Orange County, North Carolina (hereinafter referred to as "COUNTY") with offices located at County of Orange, Finance Department, 129 East King Street, Hillsborough, North Carolina 27278. As defined in the proposal for services attached as Exhibit A and incorporated herein by reference to the same, BSCA will provide consulting services in scope and general quantity as descnbed more fully on Attachment A. II. Cha es Ex nses and Pa ent Terms Expgnses Expenses include: gravel costs such as lodging, meals for BSCA staff or for County staff during working meals, public transportation (taxis, bus, train, plane or car rental) or private transportation at forty-five cents (.45) per mile from BSCA offices plus tolls and parking charges. Additional reimbursable expenses include telephone, postage or shipping chazges and any Orange County or other local or state or other required licensing permits, fees or taxes. Countv Provisions The County will be responsible to provide printing, duplication or reproduction services and will assume all distribution costs for sending materials to the desired parties. ~,avm~ent_Terms Terms of payment are net thirty days (30) from the date of receipt of an "Approved Invoice". For purposes of this Agreement, an Approved Invoice is an invoice submitted to the County containing specific and detailed entries and that is approved by the County's Information Technology Director. Deposit A refundable deposit of $500 (five hundred dollars) shall accompany the return of this Agreement to BSCA once it is executed by the County. This refundable deposit will be credited towards the first invoice rendered to the County under this Agreement. Hours Rate An hourly rate of $I60.~ per hour will be charged for all services rendered under this Agreement plus travel time and other costs incurred during the carrying out of the duties associated with this Agreement. BSCA will provide a detailed itemization of all tasks and hours expended. Howly rates will be billed as the actual time expended at 15-minute minimum intervals. Thus, for example, if 25 minutes is expended, then one half hour is billed. Billing will be as follows: On-site hours at the County or other directed sites as time is expended. Travel Hours will be billed at 60% of the time expended in traveling from BSCA Geneva [near Rochester] or Albany offices in New York. Off-site hours for services rendered that are to be provided for any preparation, consultation, research, analysis, evaluation, or presentations associated with this contract are billed as time is expended. Amount Payable The total BUDGETARY amount payable to BSCA pursuant to this Agreement, including all hourly rate charges and expenses, shall not exceed $45,000.00. This Agreement must be amended in writing if the parties desire to contract for services or expenses in excess of County of Orange, NC. and BSCA, Inc. -Software Consulting 3 of 4 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $45,000.00. Since BSCA cannot project exact tasks and hours before BSCA begins this contract, the not-to-exceed is a budget limit, but it does not imply that all services will be included for this amount. Relationship of Parties BSCA is an independent contractor of the County. BSCA represents that it has or will secure, at its own expense, all personnel required in performing the services under this Agreement. Such personnel shall not be employees of or have any contractual relationship with the County. All personnel engaged in work under this Agreement shall be fully qualified and shall be authorized or permitted under state and local law to perform such services. It is further agreed by BSCA that it shall obey all State and Federal statutes, rules and regulations which are applicable to provisions of the services called far herein. Neither BSCA nor any employee of BSCA shall be deemed an officer, employee or agent of the County. Term & Cancellation The term of this Agreement shall be for a period of twelve months from the latest date written on the signature page of this Agreement. This Agreement may be cancelled by BSCA upon thirty (30) days' written notice to the County, and the County may terminate this agreement upon thirty (30) days' written notice to BSCA. County shall be responsible for payment for all charges and services rendered by BSCA up to and through the date of the written notice of termination, subject to the "Payment Terms" Section of this Agreement. Indemnification BSCA agrees to defend, indemnify, and hold harmless the County, for all loss, liability, claims or expense (including reasonable attorney's fees) arising fram bodily injury, including death or property damage, to any person or persons caused in whole or in part by the negligence or misconduct of BSCA, except to the extent same are caused by the negligence or willful misconduct of the County. It is the intent of this section to require BSCA to indemnify the County to the extent permitted under North Carolina law. Non-Assignment BSCA shall not assign this Agreement, including rights to payments, to any other party without the prior written consent of the County. Entire Agreement The parties have read this Agreement and agree to be bound by all of its terms, and further agree that it constitutes the complete and exclusive statement of the Agreement between the parties. Governing Law This Agreement shall be governed by the laws of the State of North Carolina. BSCA makes no representation or warranties, express or implied, with respect to the services it has or will furnish including, but not limited to, any implied warranties or merchantability or fitness for a particular purpose and assumes no liability to the County except as specifically set forth in this contract, or any.mutually agreed amendments thereto. Any loss is limited to fees paid to BSCA for services rendered during this contract. County of Orange, NC. and BSCA, Inc. -Software Consulting 4 of 4 /~ Shock ssoc '~ \ ~ ,-r President ~2t °~ Title Date r~.,.. ~CG...__ ~.i ~ Z !a ~a~j Title Date of Signatory: This instrument has been p-audited in the manner required by the Local Government Budget and Fiscal Control Act. COUNTY FINANCE OFFICER 0 PIMS Contract Consultant Statement of Work ~Xh~ b11 a Business Background Orange County has relied on an internally developed tax and land management system for the past 30 years. This system has served the County well over the years and has played a signfcant role in keeping the County's high collection rate. However, as technology has advanced, this legacy system has become increasingly difficult to integrate with newer systems and expertise needed to support it is becoming increasingly rare in the marketplace. Because of these reasons, Orange County's departments of Information Technologies, Revenue and Tax Assessment are leading a project in which the entire property tax system and processes, inducting Land Records fundaons will be replaced with new applications and concomitant business processes. To date, Orange County has released a detailed RFP, received vendor responses and performed an evaluation of the solutions proposed. Based on this analysis, Orange County has identified two primary vendors, IIS Systems of Durham, NC and Patriot Systems of Boston, MA as the intended solution providers. IIS is to provide custom¢ation, implementation and support services for the North Carolina Property Tax System that is owned and managed by the North Carolina Association of County Commissioners, spec~cagy to manage the collections, billing and personal property taxation functions of our overall program. Patriot Systems is to provide software, customization, implementation and support services for AssessPro, their product used to manage property assessment data, including land records data. The unavailability of a viable single vendor solution yield significant challenges in integrating the two primary vendors. Each of these vendors may in turn work with subcontracting firms. Additionally, the taxation system must also integrate with existing GIS, Register of Deeds, Property Inspections, Finandal software. Because of the complexity of implementation and the imperative need to ensure a smooth transition, Orange County feels that project planning and detailed contract negotiations will be essential to produce a successful product. Orange County is seeking outside assistance in defining detailed contractual requirements for the vendors to be engaged, assist in developing a detailed project plan and provide assistance in measuring and enforcing vendor performance. Tasks The work will include the following tasks: • F~sure the detailed business requirements for all relevant taxation and related activities are covered, unambiguously and enforceable in contracts, using the body of process documentation available • Identify all functionalities required by Orange County, vetting the need in the context of vendor recommended best practices. • Oversee contract development to ensure the following vendor and County deliverables are documented in speck, detailed, measurable and enforceable language: o software functionalities o data conversion responsibilities Sept 8, 2008 - I - Orange County IT 0 PIMS Contract Consultant Statement of Work o acceptance testing . o integration responsibilities (including vendors of other systems for which we'll be integrating) o user trainir~ Assist in the development of change management process Work with vendor, County tax offices and County's Information Technology department to develop a detailed project schedule, with milestones, dependences, resource requirements to be managed by the County's• Information Technology department Technology Background The Tax Assessor and Revenue Collection Departments currently use legacy database applications. They are installed on IBM RISC hardware running the AIX operating system, with the Universe database and application environment. Information Technologies has expertise on staff that will be instrumental in converting data and other project support roles. The Planning/Inspections division has installed the Permits' Plus version 4.7.73 (vendor. Acxela Inc.) application for the management of inspections data.. It also has an interface with the legacy applications as well as the GIS system. The Information Technology/GIS Department has developed and currently supports a GIS system, based on ESRI software products. The legacy system is used to populate the attribute fields in GIS for all parcel data. The County also has the Master Orange Address Database (MOAD) application that is intended as the foundation for future address-related applications. MOAD is an Access 2000 database. The Register of Deeds office. has installed the AiLIS application (vendor. American Cadastre) for the storage and management of deeds information as well as vital records information. This application has an intertace with the Land Records/GIS, Tax Assessor and Revenue Collection legacy applications. The County has implemented the Munis version 2004 (vendor. Munis, Inc.) financial and business systems software package. The Munis application also intertaces with the legacy applications. Project Goals and Objectives This project will define and prioritize the requirements for an integrated, enterprise vide Land Records and taxation application and. business processes that meet the needs of all stakeholders. Primary Orange County stakeholders include: • Revenue Collections • Tax Assessor • Register of Deeds Sept 8, 2008 - 2 - Orange County IT 0 P1MS Contract Consultant Statement of Work • Information Technologies, including GIS division Secondary stakeholders include: • Finance • Planningllnspections • Town of Chapel Hill Finance Department • Town of Carrboro Finance Department • Town of Hillsborough Finance Department • Town of Mebane Finance Department • City of Dufiam Finance Department • • Adjacent ,County's Land Records divisions (Durham, Chatham, Alamance, Caswell and Person) This project will also identify areas of improvement in the stakeholders' business process related to taxation. Areas to be considered include: • Customer queries for all aspects of land records, property valuation and payment status. Phase Details Orange County sees three distinct phases in which consulting work may be needed. Contract Development Phase This phase involves the development of a detailed contract between Orange County and the proposed software vendors, Patriot Systems and~IlS, Inc. The consulting vendor would take a primary role in outlining the specific deliverables of the.contrail, the milestones for delivery and payment, enforcement mechanisms and all other aspects of the contrail ensuring successful delivery of software to Orange County. The County's attorney, the County's Purchasing department, the vendors and the stakeholder departments will be closely involved. Implementation Plan Development Qhase This phase involves developing a detailed implementation plan in which individual tasks are identfied, prioritized, dependencies are established and documented in a project plan. Also included would be a risk management plan and communication plan. Project Management Phase This phase would involve consultants actively tracking the progress of all project related tasks, noting slippages, providing communications to all involved and tracking all activities relevant to the project. Scope of Work and Deliverables -Contract Development Phase The primary requirement of this phase of the overall project is to develop a contract which ensures a • successful, implementation of a property records management and taxation business process and software application suite that is within time, budget and performance specifications. Sept 8, 2008 = 3 - Orange County IT io PIMS Contract Consultant Statement of Work • Convert documented functional requirements into enforceable contractual deliverables of delivery schedule, budget and performance standards • Attribute all deliverables to spedfic parties (vendors and Orange County) • Contractually assign integration roles to specific parties • Contractually assign data conversion roles to specific parties • Develop mechanisms for monitoring and enforcing contract deliverables Scope of Work and Deliverables -Implementation Plan Phase The following outlines the scope of work to be undertaken to complete the initial project planning phase of the overall project and may be augmented by addfional tasks: • Confimn stakeholders' areas of interest and validate the scope, organization, and direction of the project to all identified ~stakehokiers • Work with stakeholders, IT, and vendors to develop and manage a full and detailed implementation plan • Establish and document task dependencies • Document resources available for project and develop resource plan • Project plan for negotiating a comprehensive set of vendor contracts • Create and maintain detailed project plan with tasks, resources (both internal and vendor supplied), milestones, and deliverables • Develop and maintain business processes • Develop change management processes • Work with IT Senior Analyst and vendor to plan data conversion • Assist in estimating full project implementation costs, induding (but not limited to) software acquisition, hardware acquisition, software configuration and enhancement, project management casts, training costs, and data conversion costs • Estimate ongoing sustaining costs • Work with IT Business Analyst to create communications plan • Develop and manage a change management strategy • Work with stakeholders to develop and coordinate a test plan with go-live criteria Include integration planning in implementation Scope of Work and Deliverables -Implementation Plan Phase The following outlines •the scope of work to be undertaken to complete the project management phase of the overall project and may be augmented by additional tasks: • Trade performance of vendors and County staff against project plan • Escalate any slippages of performance against schedule to stakeholders • Advise on contingency•options in the event of delivery slippage or resource .disruptions • Conduct regular meetings among stakeholders • Update project plans at detailed and executive levels • Manage all scope change requests within change management process ' Sept 8, 2008 - 4 - Orange. County TT DIMS Contract Consultant Statement of Work • Analyze impacts of change orders to overall project delivery. Material changes to the project scope, schedule, and budget will be documented and presented to the project steering committee for impact review, discussion of options and decision. Submittal ~ Consultant Quallflcations The Consulting Firm must have the expertise in-house or through third parties to provide the services required by the scope of work. Interested firms or subcontractors must not be vendors for or affiliates of any Hardware, Software, or Equipment suppliers or providers. The firm must have a project manager to serve as the point of contact, coordinator and the liaison between the County and the Finn and any subcontractors. i~ Sept 8, 2008 - 5 - Orange County TT