Tyler - EnerGov Data Asset Inventory and Structure

The City of Rancho Cordova, IT Department is soliciting request for proposals for a business-readable inventory of the data assets maintained within the City’s existing Tyler EnerGov environment.

The purpose of this engagement is to provide City business and technical staff with a clear understanding of:

• What data exists within each EnerGov module used by the City
• What information is standard Tyler/EnerGov versus City-configured or custom
• How the information is structured
• How major data elements and modules relate to one another
• What historical information is maintained

This engagement is for data discovery and documentation. The City is not requesting a data dump, data migration, new integration, report development, or system development as part of this scope.

The Consultant shall perform professional services for a business-readable inventory of the data assets maintained within the City’s existing Tyler EnerGov environment. [...] The selected consultant will be expected to manage and control costs and resources, and complete work in adherence to the agreed upon Project schedule and will assign a Project Manager who will act as the City’s primary contact and will be entirely responsible for project management activities throughout the life of the Project (including subconsultant work, if applicable).

Data Inventory by Module

Professional shall identify and document the data assets maintained within each EnerGov module or functional area implemented for the City.

Business-Readable Data Inventory and Dictionary

For each module or functional area, Professional shall provide a business-readable inventory of the information maintained in EnerGov.

Standard Tyler vs. City Configuration

The Professional shall classify significant City-configured, City-custom, and other data elements identified through discovery as material to City business processes.

Technical Data Mapping

The business-readable inventory shall include or reference the corresponding technical information necessary for City IT staff to understand how the information is represented within EnerGov.

Data Relationships

Professional shall document significant relationships among data within each module and across EnerGov modules.

Professional shall provide an entity relationship diagram (ERD), data model, or equivalent visual representation showing significant within-module and cross-module relationships.

Historical Data

For each applicable module or functional area, Professional shall identify the historical information maintained by EnerGov.

Discovery and Validation

Professional shall conduct discovery sessions with appropriate City business and IT staff as necessary to confirm EnerGov modules and functional areas currently in use by the City.

Professional shall provide a complete draft deliverable package for City review and shall conduct validation with appropriate City business and technical representatives.

Deliverables

• One complete draft deliverable package for City review; and
• One final deliverable package incorporating mutually agreed corrections and clarifications resulting from the City’s review.

All inquiries and request for clarification must be submitted through the Question & Answer section of this project on OpenGov. Do not contact any City staff for inquiries regarding this RFP.

Any submittals received prior to the due date and time specified for proposals may be withdrawn or modified by clicking the "Unsubmit Proposal" button in OpenGov. To be considered, however, the modified submittal must be re-submitted within the timeframe shown above.

Submittals received after the time and date specified above will be considered nonresponsive. No late submittals will be accepted.

Information provided in the following sections is not to exceed 20 pages and shall be 8-1/2 inches by 11 inches in size. Font size shall not be less than an 11 point.

The Cover Letter must be signed by an officer empowered by the Consultant to sign such material and thereby commit the Consultant to the obligations contained in the RFP response.

Insurance

• Workers’ Compensation and Employer’s Liability: not less than **$1,000,000.00** per accident.
• Commercial general liability: not less than **$2,000,000.00**.
• Automobile liability: not less than **$1,000,000.00**.
• Professional liability: not less than **$2,000,000**.

Billing shall be on a monthly interval as designated by the City.