Search

WwW GBiv3&'*

software solutions

CiVICgov One Solution — City of Nashua
Exhibit D — Statement of Work

Reporting System
GIS Map Views
Form Creation
Email System
Mobile Device Support
Crystal Reports database access
Exports of PDF, DOC, CSV files
3.2.9.1 General Processing Tools
GIS Mapping
Reporting
Data Exports
3.2.9.2 System Tools
Reporting
Data Backups
3.2.10 Online/Citizen Access
3.2.11 GIS Processing
3.2.12 Mobile Processing
3.2.13 System Security
3.2.14 Data Backups

3.3 2 System x Development
The objective includes the development/customization of the Interfaces, development of the

Government Process Management (GPM), Creation of Custom Forms, Development of Citizen Portal and
Data Intake Processing, Creation of Reports, Creation of Record Types and Uses, Development of Record
Processing Checklists. Each Deliverable will be reviewed by the appropriate department, complete User

Acceptance Testing and Approve of Process.

2.3.1 Deliverable 2: Municipal Settings
3.3.1.1 Municipal name, Address and contact numbers applied to server
3.3.1.2 Obtain logo for letter heads for various departments
3.3.1.3 Review digital signatures
3.3.1.4 Complete city. global settings.

3.3.1.5 Create user customized dashboard. Features include: My favorite modules, scheduler

weekly view, Shortlist reports of workflow items

3.3.2 Deliverable 2: Property Data
3.3.2.1 Obtain Export of GIS shape file data and assessor property data
3.3.2.2 Create CiVICgov GIS viewer and links to City’ existing GIS system
3.3.2.3 Create Adjacent/Abutter Search Process identifying map selection process for lists.
3.3.2.4 Implement parcel combination and parcel division processing
3.3.2.5 Implement Inspection records at property level not associated with any module

3.3.2.6 Implement invoice records (cart operations) at property level not associated with any

module
3.3.2.7 Track environment issues, lead paint hazards, and other records at property level

Page 6 of 13

ee W oes on Se RT eS
UY MBOSOVS
software solutions &

CIVICgov One Solution — City of Nashua
Exhibit D — Statement of Work

3.3.2.8 Implement Responsive Design for Parcel Management System
3.3.2.9 Provide Training/Review Session for applicable staff to allow User Acceptance Testing
(UAT) within sandbox for module delivery and completion.

3.3.3 Deliverable 4: Permitting System

3.3.3.1 Identify all departments responsible for plan review/workflow and collaboration for
reviews such as within the building permitting system
3.3.3.2 Identify all permit types and sub-types (called uses) to include: building, health, rental,
stormwater, operating, public works, etc.
3.3.3.3 Identify all specific types and type groupings required for permit process that are
associated with permit types and uses
3.3.3.4 Identify all permit inspection types
3.3.3.5 Link specific inspections to each permit type and use

3.3.3.5.1 Develop Inspection security

3.3.3.5.2 Identify workflow and email notifications

3.3.3.5.3 Citizen Portal Inspection Requests blocked when fees not paid.

3.3.3.5.6 Create default inspection comments pick list

3.3.3.5.7 Provide contractor information associated with inspection

3.3.3.5.8 Create recurring permit inspection

3.3.3.5.9 Limit/isolate scheduling calendar based on department login

3.3.3.5.7 Mobile Inspection application
3.3.3.6 Identify all fees associated with permit types and associated to each permit type with
identification of general ledger codes
3.3.3.7 Obtain all outbound letters, notifications, forms, placards and required report examples
3.3.3.8 Identify permits types/uses approved for application via permit portal. Identify custom
fields required for processing various permits via citizen portal
3.3.3.9 Obtain sample permit data from existing system to develop import configuration. City
staff must provide data scheme, field matrix and wireframe for processing imports.
3.3.3.10 Identify City procedure for parent/child permit relationship purpose and develop as
required
3.3.3.11 Implement linkage to Government coding, develop data to push back to assessor and
develop api/rest/soap connection to existing document management system via URL
3.3.3.12 Identify public/private process
3.3.3.13 implement email notification via status/workflow process
3.3.3.14 Create contractor database
3.3.3.15 Create building/dwelling process spreadsheet rows 19 and 20
3.3.3.16 Create user security system for permitting
3.3.3.17 Create temporary C of O Tracking with expiration dates
3.3.3.18 Implement Responsive Design for Permitting System
3.3.3.19 Provide Training/Review Session for applicable staff to allow User Acceptance Testing
(UAT) within sandbox for module delivery and completion.

Page 7 of 13

YVMWISYVS
software solutions &

CIVICgov One Solution — City of Nashua
Exhibit D — Statement of Work

3.3.4 Deliverable S: Planning
3.3.4.1 Develop security levels based on item 44, row 44 of requirements sheet
3.3.4.2 Implement user security interface
3.3.4.3 Create standard comments drop down list
3.3.4.4 Create board/commission/department types and subtypes
3.3.4.5 Create checklists based on types and subtype processing
3.3.4.6 Create Variance and conditions tables and provide ability to integrate conditions to
outbound documents
3.3.4.7 Obtain all outbound forms, reports, letters for all planning/land management processing.
3.3.4.8 Create Citizen Portal for planning/project management
3.3.4.9 Create user defined fields for application information
3.3.4.10 Create user defined flags for records and track those flags
3.3.4.11 Obtain all fees associated with planning/project module
3.3.4.12 Identify and create government processing rules with email and other notifications
3.3.4.13 Data exports include MS Word format, PDF, CSV
3.3.4.14 Link to GIS and Create searches and abutter list within project and save lists created
within GIS
3.3.4.15 Obtain Sample Data for Import
3.3.4.16 Implement Responsive Design for Planning/Project System
3.3.4.17 Provide Training/Review Session for applicable staff to allow User Acceptance Testing
(UAT) within sandbox for module delivery and completion.

in &

2.3.5 Deliverabie 6: Code Enforcement
3.3.5.1 Identify user security requirements for code enforcement operations
3.3.5.2 Review/create violation and complaint types per department to include: housing,
building, DPW, Health, police, planning, parks, street, state, waste, wetlands, and zoning.
3.3.5.3 Obtain violation fines and general ledger codes
3.3.5.4 Obtain outbound forms, placards, notifications, citations, etc.
3.3.5.5 Develop violation and complaint processing for Citizen Portal
3.3.5.6 Develop vehicle tracking process for code violations
3.3.5.7 Active “status tab” workflow within complaints and action items in violations
3.3.5.8 Automation of complaint received from portal for assignment to identified staff
3.3.5.9 Cross reference violations to licenses, permits and other modules
3.3.5.10 Create linkage to 3™ party code database
3.3.5.11 Obtain violation inspection types based on violation types
3.3.5.12 Create automated reinspection based on time frames
3.3.5.13 Implement Responsive Design for Code Enforcement System
3.3.3.14 Provide Training/Review Session for applicable staff to allow User Acceptance Testing
(UAT) within sandbox for module delivery and completion.

Page 8 of 13

> iParametrics @) ml * WEI PROPOSAL FOR THE CITY OF NASHUA
: Sarees ARPA ADMINISTRATIVE SERVICES

ORGANIZATION CHART

PROJECT EXECUTIVE
Jeff Stevens, CEM, MEP

SEMIOR ADVISORS
James Lee Witt
Margaret Larson

PROJECT IANAGER
Shanti Smith-Copeland

ASSOCIATE PROJECT MANAGERS
juliann Bertone
Entily Noyes
Ben Redifer

SYSTEMS DEVELOPMEMT OUTREACH FPRMA PURLIC ASSISTANCE

Mark Homrich Justin Cauley Mark Albright
Ariel Siegel Lindsey Holman, MPS Brenda Matthews
Tessa Hartley

TECHMICAL APPEALS SPECIALIST
ASSISTANCE LIAISON Michael L.

Gary Viola, PE Domenichelfo, JD

AUGMENTING THE TEAM WITH LOCAL INVOLVEMENT

We are committed to leveraging this contract to stimulate the local economy and grow the local workforce by augmenting our team
with carefully selected local hires and through strategic partnerships with local City of Nashua community organizations. Including
staff and trusted organizations who are part of the community increases representation of the local public in the program team.
When applicants can relate with the people serving on the program team, efficiency is increased as relationships develop organically
over shared experience. As new staff are enfolded into the program, our team will rely on a learning architecture that supports
continuous development and improvement of the program team. New staff will be trained and fully available to support the program
within one week of hire, supported throughout the life of the program with ongoing training by the Project Manager and access to
our team of subject matter experts. This group is supported by a deep bench of more than 1,500+ professionals who can be pulled
in at amoment's notice based on technical need.

PAGE 14

Y 7 2 oO SLs we,
; Ey “Nemec Gana! i eal
software solutions ™

CivICgov One Solution — City of Nashua
Exhibit D — Statement of Work

3.3.6 Deliverable 7: Inspections
3.3.6.1 Inspection supported in permits, planning/projects, complaints, violations, fire safety
operations, licensing modules
3.3.6.2 Implement Security levels and email processing
3.3.6.3 Implement Inspection Requests at the property level not associated with any record
3.3.6.4 Obtain reinspection fees across modules
3.3.6.5 Identify inspection status levels across modules
3.3.6.6 Implement scheduling tool and link email notifications to owner, occupant, contractor,
applicant, or associated party
3.3.6.7 Batch printing inspection lists, inspection notices.
3.3.6.8 Create Recurring Inspection system for use in identified modules ( Health, Fire/safety,
etc.)
3.3.6.9 display open inspections by module selector as GIS layer in CIVICgov map
3.3.6.10 Implement mobile application and isolate inspection to specific departments based on
login credentials
3.3.6.11 Implement Responsive Design for Inspection System
3.3.6.12 Provide Training/Review Session for applicable staff to allow User Acceptance Testing
(UAT) within sandbox for module delivery and completion.

3.3.7 Deliverable 8: Environmenta! Health
3.3.7.1 Identify permit types and uses to include Food Service, spa and pool, and solid waste
hauler licenses
3.3.7.2 Create Recurring inspections for processes
3.3.7.3 interface with Citizen Portal Complaint Filing and Violation processing with EH.
3.3.7.4 Obtain all outbound forms, placards, notifications, and reports
3.3.7.5 Implement Mobile Inspection for EH
3.3.7.6 Obtain all fees and fines and G/I Codes related to EH
3.3.7.7 Implement Responsive Design for Environmental Health System
3.3.3.8 Provide Training/Review Session for applicable staff to allow User Acceptance Testing
(UAT) within sandbox for module delivery and completion.

3.3.2 Deliverable 9: Fire Marshal's Office
3.3.8.1 Identify permit types and uses issued by FD
3.3.8.2 Obtain fees associated with department
3.3.8.3 identify Citizen Portal processing requirements
3.3.8.4 Obtain all outbound forms, placards, letters, and notifications. Obtain all reports
3.3.8.5 Identify all violation ticket and enforcement types
3.3.8.6 Identify/review building/suite processing and Fire Safety Equipment tracking
3.3.8.7 Implement Codes tab processing of violations within module.
3.3.8.8 Create Recurring Inspection Cycle
3.3.8.9 implement Responsive Design for Fire Marshal’s Office

Page 9 of 13

&

YE BwWwoya
software solutions ©

CiviCgov One Solution — City of Nashua
Exhibit D — Statement of Work

<3

3.3.8.10 Provide Training/Review Session for applicable staff to allow User Acceptance Testing
(UAT) within sandbox for module delivery and completion.

3.3.9 Deliverable 10: Department of Public Works
3.3.9.1 Identify permit types and uses
3.3.9.2 Identify/create workflow routing and permit approvals.
3.3.9.3 Create inspection scheduling and identify inspection types associated with permits
3.3.9.4 Obtain all outbound forms, placards, letters, notifications and all required reports
3.3.9.5 Identify all fees and general ledger codes associated with DPW
3.3.9.6 Implement Responsive Design for DPW System
3.3.9.7 Provide Training/Review Session for applicable staff to allow User Acceptance Testing
(UAT) within sandbox for module delivery and completion.

p

3.16 Deliverable 11: Police Department
3.3.10.1 Identify required permit types/uses within department
3.3.10.2 Create required inspections
3.3.10.3 Identify required fees and general ledger codes
3.3.10.4 Obtain reports, forms, letters and placards
3.3.10.5 Implement Responsive Design for Police Department System
3.3.10.6 Provide Training/Review Session for applicable staff to allow User Acceptance Testing
(UAT) within sandbox for module delivery.and completion

C3

3.3.14 Deliverable i2: City Clerk
3.3.11.1 Identify all permit and license types and uses
3.3.11.1.1 Create Dog Licensing System
3.3.11.2 Identify permit/license renewal process and requirements. Annual and temporary
3.3.11.3 Identify required government process management rules
3.3.11.4 Obtain forms, letters, placards, notifications outbound and all reports
3.3.11.5 Create Citizen Portal component and online applications
3.3.11.6 Create workflows for various permits and licenses
3.3.11.7 Identify and process automated reminders
3.3.11.8 Obtain all fees and processing general ledger codes
3.3.11.9 implement Responsive Design for City Clerk System
3.3.11.10 Provide Training/Review Session for applicable staff to allow User Acceptance Testing
(UAT) within sandbox for module delivery and completion

Sid

3.12 Deliverable 13: Inveicing & General Ledger System
3.3.12.1 Review Processing Across all departments
3.3.12.2 Create Department Sort processing based on Case type
3.3.12.3 Configure General Ledger
3.3.12.4 Obtain accounting and invoicing reports
3.3.12.5 Review default invoice format
3.3.12.6 Implement Responsive Design for Invoicing System

Page 10 of 13

. ~~ -
& on ee a &
GS oy Se

software solutions

ClViCgov One Solution — City of Nashua
Exhibit D — Statement of Work

3.3.12.7 Provide Training/Review Session for applicable staff to allow User Acceptance Testing
(UAT) within sandbox for module delivery and completion

3.3.13 Deliverable 14: System Dashboards
3.3.13.1 Create Custom Dashboards for each department
3.3.13.2 Create Custom Dashboard for user within each department
3.3.13.3 Implement “my favorite” module list
3.3.13.4 Implement scheduling tool interface
3.3.13.5 Implement Workflow Reports per user
3.3.13.6 Implement Map pushpins for user login
3.3.13.7 Sort.on department for limiting view within department dashboard
3.3.13.8 Implement Analytic Report tools and allow user selection
3.3.13.9 Implement Responsive Design for System Dashboard
3.3.13.10 Provide Training/Review Session for applicable staff to allow User Acceptance Testing
(UAT) within sandbox for module delivery and completion

3.3.14 Deliverable 15: Citizen Portal
3.3.14.1 Review Standard Public Account Creation Process
3.3.14.2 Configure Complaint System with routing to required departments
3.3.14.3 Configure Permit Applications & inspection Requests
3.3.14.4 Configure Planning/Project Applications
3.3.14.5 Configure Health Department Licenses and management
3.3.14.6 Configure City Clerk Licenses Application and management
3.3.14.6.1 Implement Dog Licensing and security
. 3.3.14.6.2 Implement other city clerk licenses
3.3.14.7 Configure Code Enforcement Processing
3.3.14.8 Configure other department portal processing
3.3.14.9 Implement Payment Processor
3.3.14.10 Begin Review Process with Municipay Payment Processing
3.3.14.10 Implement shopping card
3.3.14.11 Match User Interface to current city site
3.3.14.12 Implement My Dashboard feature
- 3.3.14.13 Implement Responsive Design for Citizen Portal
3.3.14.14 Provide Training/Review Session for applicable staff to allow User Acceptance Testing
(UAT) within sandbox for module delivery and completion

3.3.15 Deliverable 16: Back Office Pracessing/User Security /Backups/
3.3.15.1 Configure City Admin settings
3.3.15.1.1 add/manage user accounts
3.3.15.1.2 Management of workflow rules and fee processing
3.3.15.1.3 Manage departments and groups

Page 11 of 13

VV & _

id ae Ce = E24 Pe
ve © - 5 oy “

software solutions

CiviCgov One Solution — City of Nashua
Exhibit D — Statement of Work

3.3.15.1.4 Admin control to make fields mandatory
3.3.15.2 User ability to append help files
3.3.15.3 implement to add custom fields to modules and search on those fields
3.3.15.4 Implement user time tracker and audit trail within system
3.3.15.5 Implement User Role based Security settings
3.3.15.6 Implement daily cloud backup system.
3.3.15.5 Implement Responsive Design for Processes
3.3.15.6 Provide Training/Review Session for applicable staff to allow User Acceptance Testing
(UAT} within sandbox for module delivery and completion

3.3.16 Deliverable 17: System Tools (Reporting, GIS, Mobile Operations}

3.3.16.1 Reporting and Queries
3.3.16.1.1 implement User Query and Report System
3.3.16.1.2 Implement interface for City’s Crystal Reports to data sets
3.3.16.1.3 Create standard “canned” reports per module
3.3.16.1.4 Implement Report and Query User Role Security
3.3.16.1.5 Implement ‘favorite’ reports in dashboard

3.3.16.2 GIS
3.3.16.2.1 Link to existing GIS from-within each module record
3.3.16,.2.2 Utilize CIVICgov GIS Viewer for creation of abutter list using click on property
feature to add selections to abutter list
3.3.16.2.3 Create permits, projects, complaints, add licenses, violations, create fire
inspections directly from within map
3.3.16.2.4 Email map view within system.
3.3.16.2.5 Provide measuring tools
3.3.16.2.6 Query map by multiple fields within parcel data

3.3.16.3 Mobile Operations
3.3.16.3.1 Complete Record Access to all modules from mobile systems
3.3.16.3.2 Mobile Printing
3.3.16.3.3 Mobile offline inspection system for all modules using inspections
3.3.16.3.4 Mobile sync processing

rh)

tar

fast

—s
ne

to

4. Data Conversion & 3r¢e Party Sofiware

Sa y"sh
a
a4 Rid

3.4.1 Deliverable 18: Data Conversion
3.4.1.1 Import historic permitting data based on test records within modules from Cityview
3.4.1.2 Import historic licensing data from Admins software
3.4.1.3 Being Data conversion testing by City for UAT

3.4.2 Deliverable 19: Software Integration
3.4.2.1 Lawson Financial System
3.4.2.1.1 Export General Ledger transaction to Lawson based on field requirements

3.4.2.2 Patriot Assessing

Page 12 of 13

=a SVG
SQV Oo

Pe

CiVICgov One Solution — City of Nashua
Exhibit D ~ Statement of Work

3.4.2.2.1 Create REST/SOAP/API automation to pull property data updates

3.4.2.2.2 Create REST/SOAP/API to push permit data updates to Patriot
3.4.2.3 ESRI GIS interface to update parcel data. Use WMS or similar to download updated
layers. Utilize data to populate abutter list to permitting and planning
3.4.2.4 Onbase Document Management — Link via URL to record repositories of 3 party system

3
3

20 Terining anc Tactinag
So. 1 PRINS ana PeSune

2.5.4 Deliverable 26: Training

3.5.1.1 On-site Training
3.5.1.1.1 Core Module Training - 10 day workshops
3.5.1.1.2 Administrator Training — 3 day workshop
3.5.1.1.3 Reporting and Analytic Training — 1 day workshop

3.5.1.2 Remote Training
3.5.1.2.1 Core Module Training — 80 hour total
3.5.1.2.2 Admin Training — 20 hours

3.5.1.3 Continual Training
3.5.1.3.1 Online help guides
3.5.1.3.2 Video “how to’ presentations
3.5.1.3.3 Knowledge base and online support system

5.5.2 User Acceptance Testing{UAT}

3.5.2.1 Provide Sandbox environment for testing. All modules are tested within each deliverable
with final User Acceptance Testing (UAT} at end of this objective.

3.5.2.2 Implement 4 week testing period with complete system in sandbox environment

3.5.2.3 Implement Issue tracking/ticket system for UAT results

3.6 System Deployment
3.6.1 Pre Go-live
3.6.1.1 Develop Cut-over Plan
3.6.1.2 Develop cut-off date for old system data imports
3.6.1.3 Develop pre-production checklist
3.6.2 Go-Live
3.6.2.1 Establish Go-live date
3.6.2.2 Provide Staff support during go-live week
3.6.2.3 Implement issue tracking system during go-live process for 30 days after go live
3.6.3 Post Go-Live
3.6.3.1 Introduction to Support team and processes
3.6.3.2 Completion and sign off on project closure

END OF DOCUMENT

Page 13 of 13

WaGsys

* softwere sy

Exhibit E — Professional Costs and Annual Subscription Services

Professional Services Cost

ITEM MODULE IMPLEMENTATION/CONFIGURATION QTY UNIT PRICE LINE TOTAL
1.
All modules as described in the RFP 1 $85,000.00 $85,000.00
2. CIVICgov Tools 1 $1,000.00 $1,000.00
3. Citizen Access Portal ' $1,000.00 $1,000.00
4. Data Conversion (based on review of existing data) 1 $10,500.00 $10,500.00
5 GIS Mapping (ESRI) complaint 1 $15,000.00 $15,000.00
7. On-site Training and other training processes 1 $3,000.00 $1,000.00
9. **CUSTOMER MUST PROVIDE TAX EXEMPTION CERTIFICATE SubTotal $113,500.00
SALES TAX **
TOTAL $113,500.00
a vom a PS We, 7 me me, Wea eC & sity
fi Gm aS, a" Gon PB i (poe
Mitestone Payment Sche
MILESTONES PAYMENT DUE BALANCE
Payment 1: Completion of Statement of Work Objective 3.1 -
Upon Acceptance, Signing of Contract and Project Initiation to
include creation of Production and Sandbox Environments. 919, 500/00 974,000.00
Deliverable 1.
Payment 2: Completion of Statement of Work Objectives 3.2 -
Gap Fit Process through 3.3.5 System Development -Permitting $45,000.00 $29,000.00
Deliverables 2 - 6
Payment 3: Completion of Statement of Work Objective 3.3.6 -
Inspections through 3.4.2 -Software Integration. Deliverables 7- $20,000.00 $9,000.00
19
Payment 4: Completion of Statement of Work Objectives 3.5 $9,000.00 0
Training and Testing and 3.6 System Deployment. Deliverable 20 _—
Total payments $113,500.00