Search

Page |36— EXHIBIT C - City of Nashua, NH
RFP0611-033116 —Licensing, Permitting, Code Enforcement and Land Management System

Usability =
Provide user functions that are easy to use with proper training. User functions are intuitive and logical
in their organization and display.

Users can become proficient after training, 85% of the time on first use.

After training, users will be able to sign on and navigate password security.

After training, users will be able to access all functionality to do their assigned job.

Users will be able to understand and respond to standard error messages.

Users will know how to navigate "help" facilities and diagnose and correct at least 75% of all problems
using the standard "help" facilities.

Users will be able to execute standard reports.

Users will be able to modify standard report layouts, including selection of fonts, layout, print options.
Modifications can persist across sessions, if desired by user. Modifications are unique to the
originating user.

Users will be able to modify selection criteria for their session to run standard reports and queries
(select date ranges, permit types, activity codes, etc.).

User will be able to perform their normal daily assignments without help from "power users" or use of
the "help desk" services.

‘Performance : - ;
Provide ability for user to stay logged on for extended periods of inactivity, based upon administrator-
defined thresholds.

Provide extensive field edit features to insure data accuracy and constancy.

Provide simple to use error correction and data validation processes. System must provide audit trail for
all corrections.

Provide adequate performance. Performance tuning methods and tools must be clearly defined.

Provide comprehensive security approach, including field level masking of information, for all
modules, screens and transactions.

Provide comprehensive security approach, to communications and to sensitive data on the field device
(for example, customer data).

Support user and workgroup account management, including security. System must provide support for
roles.

Provide acceptable response time (2 seconds or less) on 90% of all transactions.

Include sufficient capacity and performance such that response time is not adversely impacted by end
of shift utilization increases.

Maintain acceptable response time even when computationally intensive functions are being
performed.

Wagsys Software Solutions (888)304-0007 - Direct (845) 590-5820 - Dean.sefrin@wagsys.com

EDUCATION

CERTIFICATIONS

University of Louisiana-
Lafayette

Certified Paralegal
FEMA Emergency
Management Institute,
Course E0381: Project
Specialist

BRENDA MATHEWS

SENIOR GRANTS MANAGER

Brenda's expenence with disaster recovery programs began in 2005 following Hurricane
Katrina where she worked with a prime contractor for the State of Louisiana. Since then,
Brenda has worked on FEMA Public Assistance grant programs, Community Development
Block Grant Recovery projects, and Hazard Mitigation Grant Programs following Hurricanes
Rita and Mana. In her most recent role, Brenda worked in Puerto Rico on Hurricane Maria
recovery with the iParametrics / Fluor team under the FEMA PA contract to conduct site
inspections, formulate DDDs and SOW, formulate project descriptions using Grant Manager,
and manage applicants requesting funding. She has strong experience in the grant’s application

process and grant management.
EXPERIENCE

FEMA Public Assistance Technical
Assistance Contract, Hurricane Maria.
Managed seven pnivate, non-profit critical
and non-critical applicants in the Health
and Social Services sector. Analyzed
eligibility of expenses based on applicant
and facility usage.

# FEMA Public Assistance Technical
Assistance Contract, Hurricanes Katrina
and Rita, Analyzed costs by developing
spreadsheet reports and verification of
information. Researched procurement
issues to ensure FEMA requirements
were satisfied.

* Hunt, Guillot and Associates, Served as
Grant Manager for a Hazard Mitigation
Grant Program, monitoring all aspects of
the program from application to
closeout. Coordinated with
homeowners,

contractors, and local, state, and federal
staff to effectively and efficiently secure
and carryout individual mitigation
projects.

Hunt, Guillot and Associates. Reviewed
and prepared projects for state
monitonng and state/federal audits under
the Community Development Block
Grants and Hazard Mitigation Grant
Program. Maintained, audited, and
ensured projects complied with current
federal and state requirements.

Shaw Group, State of Louisiana Prime
Contractor, Hurricanes Katrina and Rita
Emergency Response. Audited and
ensured all contractor files were accurate
and in accordance with federal
regulations, Monitored purchasing and
procurement records, Gathered,
maintained, and reported small business
statistics to various government agencies.

av)

Page |37- EXHIBIT © - City of Nashua, NH

RFP0611-033116 —Licensing, Permitting, Code Enforcement and Land Management System

Capable of supporting continued growth. Describe any limitations on number of accounts, activities, or

other data elements.

Support ability for field workers to utilize office automation functions from field in near real time.
System must not compromise existing access through a Virtual Private Network (VPN).

Allow simultaneous voice and data contact from field.

Manage connection status for mobile field units and automatically reconnect following wireless
connectivity interruption while preserving work in progress. A user should never notice interruption of
wireless connectivity and could continue working during an interruption.

Capacity ue

Supports over 100 users concurrent and total. No limits on maximum recommended number of

concurrent users under CIVICgov.

Support a mix of mobile and desktop users, with no performance decreases.

Other Functional Needs

The following integrations are supported:

- ESRI GIS Integration

-ODBC compliant

-Rest/Soap/API processing to other vendors
-Integrates with Microsoft Office Products and formats
-Operates on any mobile device

-Supports Crystal Reports table and data access for Ad hoc Reporting

5 Configuration, Testing and Implementation

5.4 Hybrid Fit Gap Analysis

Fit Gap Analysis is methodology utilized by WAGsys in which
customer processes and system functions are compared, evaluated
and listed down to arrive at matches (fits) and mismatches (gaps).
The objective of this analysis is adapting local processes to
indusiry best practices, assessor statutory and/or legal
requirements and to identify local practices not covered in a test or
pilot implementation.

Using the hybrid type of analysis, we start with brainstorming
workshop sessions during which a review of the customer’s
existing system is conducted. We than utilizing questionnaires
identify the weaknesses of the customer’s existing systems and
desires to implement new processes. WAGsys with the help of
presentation media will cover the system features utilizing a

i
i

Grain storming on al}
Processes.

—
|

i
Preparation of system for
simulation |

Detail discussioh on each
process by ObA

Final Fa Gap

documentation

sandbox environment. These discussions are captured by system leaders to map system requirements. The end result is

a complete list of fits and gaps (if any).

Wagsys Software Solutions (888)304-0007 - Direct (845) 590-5820 - Dean.sefrin@wagsys.com

Page |38— EXHIBIT © - City of Nashua, NH
RFP0611-033116 —Licensing, Permitting, Code Enforcement and Land Management System

5.2 Data Conversion

Data conversion is a critical component of the implementation. CIVICgov is very experienced in converting legacy and
other data types. The process will include the conversion of historic licensing and permitting data from Cityview and
Admins into CIVICgov. We will work with the City to understand the data sources and structures and obtain the
exported csv files for import. We will utilize custom tools to import and validate the data import. Upon completion of
the data import iterations, the data will be placed in the sandbox for testing by City Staff.

System Interfaces. We will work with the City to develop the required interfaces to the following products:

Cityview - Data conversion

Admins (city clerk data) — Data conversion

Patriot -— Two Way nightly data transfers

CIVICgov to ESRI for abutters list and ESRI to CIVICgov for data — Two Way real-time

5.3 Project Implementation

WAGsys’ implementation model allows for all key personnel to make decisions affecting the configuration and
implementation of the client’s software solution for their specific area of control. This model provides a dynamic and
changing implementation model based on conditions that may develop during the implementation and ‘go-live” process.
It reduces decision wait-times and increases productivity. The following staff will manage the implementation of the

CIVIC gov software solution for the City

Our proposed approach to this project is in the form of three phases. This approach allows us to provide the City
with a product that is customized to meet the needs of the City’s various departments. Our approach starts with an
initial in-depth review (Phase I) and data collection process that allows us to identify the practices and procedures
used by the City. The second phase of the implementation (Phase II) includes a unique approach of
deliverable/module based QC and training for all staff. As each module is released, the City staff become familiar
with the aspects of each section. Modules included are identified in the Project Implementation Cost section. Data
conversion processes will also be completed during this phase and follow the project implementation and
training Gantt Chart established for the City.

Phase II of the implementation will include training for all staff and release of the Citizen and Contractor portal.
Our decision to use this three phase approach is based on the need to obtain all data related to the implementation,
develop the work flow of the records system, and provide detailed training of the internal modules to staff prior to

the release of the public facing portal.

City et Meme 2, bE

Wagsys Software Solutions (888)304-0007 - Direct (845) 590-5820 - Dean.sefrin@wagsys.com

Page |39—EXHIBIT C - City of Nashua, NH
RFP0611-033116 —Licensing, Permitting, Code Enforcement and Land Management System

The sandbox will provide an area to Test, DEV/QA and PROD during implementation processes. All server configuration
documentation for the cloud servers is reviewed with City staff. Client desktop configuration is not required beyond basic
Internet browser installations. All bandwidth and network security is managed by CIVICgov in the Wagsys Cloud.

System includes daily SAN backup storage functionality. Backup configuration is managed by server engineers. Daily
exports of complete data is provided to City IT staff.

Mobile Application will be provided to City staff for configuration and QC testing on all mobile devices.

Work Plan Methodology and Assignments: At WAGsys we understand that each implementation is different, and as
such, the installation process is customized to fit the needs of the client, while still following the concepts outlined here.
This process is an evolutionary methodology that was developed after many years of implementation experience. Our
team of experienced Project Managers has collaborated to deploy the CIVICgov solution using the experiences that they
have acquired while in the field. This work plan relates to the phased-in approach.

ESTIMATE TIME
DELIVERABLES TO COMPLETION

Deliverable 1: Project Initiation Upon Acceptance

Deliverable 2: Gap-Fit Testing and Review: Creation of Statement of Work. Container Configuration and Property Management
Module including data import from export of assessor data. Includes QC and Training for this deliverable.

Deliverable 3: Module Release: Permitting, Inspections, Planning, Zoning, Fire/Safety, and Code Enforcement. Included within
Planning is a plan review utility This deliverable includes User Acceptance Testing and Training for this detiverable.
Customization of forms, checklists, and configuration of codes database is completed. Fees and financial data is configured and
tested. Creation of User Sandbox is completed and made available for testing. The City only included permits and inspection
data samples for conversion. These items are the only items included in the conversion cost estimate. Any other conversion
data such as code enforcement operations, was not included as part of the cost estimate.

Deliverable 4: Data Conversion of all legacy system data -tncludes User Acceptance Testing and Training for this deliverable.
Legacy data will be analyzed, mapped to CiVICgov fields. Decisions regarding data quality and accuracy will be reviewed with the
team. Conversion iterations will be performed to validate data conversion. The customer must provide staff knowledgeable
with the Jegacy data to assist in the conversion effort.

Deliverable 5: CIVICgov Tools and GIS Mapping as contracted. , Revu desktop. Also included is a Damage Assessment Module.
Includes User Acceptance Testing and Training for this deliverable. System tools include interface creation and testing to various
3™ party vendors such as assessor data and accounting system. API/REST/SOAP processes to the assessor data and GIS will
apply. The reporting system and general ledger codes will be configured during this deliverable. Linkage to Crystal reports

Deliverable 6: Citizen Access Portal. Includes User Acceptance Testing and Training for this detiverable. This includes the
standard configuration of the portal to meet the basic look and feel of the customer's existing web site. Standard user security
configuration settings.

Deliverable 7: Final Delivery: System-Wide User Acceptance Testing and Pre Go-Live Support Processing. Upon delivery of all
modules the client will have had the opportunity to perform quality control testing and request system changes and
configurations within the standard package. Any customization of the system tables, fieids, databases is outside the scope of
the proposal. During quality control testing, the client will also receive individual model training via remote web sessions.

Deliverable 8: Training - Provide training in report writing including database models and table design. Provide a full tine of | includes 80 hours of
initial and refresher training classes, including training for System Administrators, technical support staff, and users. Provide on-site training
documentation for users and administrators. Localize documentation to match the installation at the City. Provide updates to
documentation with each new version release.

Wagsys Software Solutions (888)304-0007 - Direct (845) 590-5820 - Dean.sefrin@wagsys.com

Page |40—EXHIBIT C - City of Nashua, NH
RFP0611-033116 —Licensing, Permitting, Code Enforcement and Land Management System

6 Training
Wagsys will provide on-site training customized to each department’s needs for the features being implemented. It

includes training related to integration of the system with the other software applications and modules and provide hands-
on learning. The following training is included:

On-site Training

Core Module Training 10-day workshops
Administrator (train the trainer) 3-day workshops
Reporting and Analytic Training 1-day workshop

Remote On-line Training

Core Module Training — 80 hours
Admin Training — 20 hours

Continual Training

On-line interactive help guides

Video “how to” presentations on-line for each module
Knowledge base customized by user

On-line support system

End user training will be matched to the deliverables. Wagsys will deliver comprehensive documentation customized for
the City.

7 Maintenance and Support

Services Description. Wagsys shall provide to the City, 6 AM- 7 PM, Monday — Saturday access to the cloud-based
system support module, live support staff and email support services as required

Start Date and End Date. Beginning on the first day of the invoice date and continuing for a 12 month period. These
dates represent the term of the Services. The Services are not required until after Customization / Integration Services,
Training Services, etc. are completed, therefore the Start Date for the Services may be later than the Start Date of the
Implementation invoice.

Authorized Users and Services Fees. Authorized users are those identified by the municipality as needing system access.
External Accounts are accounts limited to owners of property within the municipality’s defined geographical limits and
contractors who are identified as the contractor of record for identified properties (access provided by Citizen Portal).

Technical Support Description. Wagsys will provide to City telephone and an online support system as identified in the
subscription services agreement. Technical Support will include any research and resolution activity performed by Service
Provider.

a) Request for Technical Support. As outlined above.

b) Problem Severity Levels 1 and 2 Response and Resolution. For Technical Support requests not made by email,
within the Request Response Time of such a request, Wagsys shall confirm to the requestor receipt of the request
by Service Provider. If a Problem Severity Level

1 or 2 request cannot be corrected to the reasonable satisfaction of the requestor within the Request Resolution

Time after the requestor makes the initial request for Technical Support, Wagsys will: (a) immediately escalate

the request to Service Provider’s management; (b) take and continue to take the actions which will most
Wagsys Software Solutions (888)304-0007 - Direct (845) 590-5820 - Dean.sefrin@wagsys.com

Page |41-— EXHIBIT © - City of Nashua, NH
RFP0611-033116 —Licensing, Permitting, Code Enforcement and Land Management System

expeditiously resolve the request; (c) provide a hourly report to the requestor of the steps taken and to be taken to
resolve the request, the progress to correct, and the estimated time of correction until the request is resolved; and,
(d) every 2 hours provide increasing levels of technical expertise and Wagsys management involvement in finding
a solution to the request until it has been resolved.

c) Problem Severity Levels 3 and 4 Response and Resolution. For Technical Support requests not made by email,
within the Request Response Time of such a request, Wagsys shall confirm to the requestor receipt of the request
by Service Provider. If a Problem Severity Level 3 or 4 request cannot be corrected to the reasonable satisfaction
of the requestor within the Request Resolution Time after

the requestor makes the initial request for Technical Support, at the sole election of requestor: (a) Wagsys will
work continuously to resolve the request; or, (b) requestor and Wagsys will mutually agree upon a schedule
within which to resolve the request.

Technical Support Problem Severity Levels
a) Problem Severity Level 1.

1) Description. This Problem Severity Level is associated with: (a) Services, as a whole, are non-functional or
are not accessible; (b) unauthorized exposure of all of part of City Data; or, (c) loss or corruption of all or part
of City Data.

b) Problem Severity Level 2.

1) Description. This Problem Severity Level is associated with significant and / or ongoing interruption of an
Authorized User’s use of a critical function (as determined by the Authorized User) of the Services and for
which no acceptable (as determined by the Authorized User) work-around is available.

c) Problem Severity Level 3.

1) Description. This Problem Severity Level is associated with: (a) minor and / or limited interruption of an
Authorized User’s use of a non-critical function (as determined by the Authorized User) of the Services; or,
(b) problems which are not included in Problem Severity Levels 1 or 2.

d) Problem Severity Level 4.

1) Description. This Problem Severity Level is associated with: (a) general questions pertaining to the Services;
or, (b) problems which are not included in Problem Severity Levels 1, 2, or 3.

WAGsys will provide cloud-based hosting servers that comply with SSAE-16 standards and maintain PCI compliant
infrastructures. The datacenters will provide the following functionality:

e WAGsys shall provide services and support for infrastructure environments
e WaAGsys shall perform daily system backups
e WAGsys shall provide a proposed solution using MySQL.
o Options exist for other database backends as CIVICgov is database agnostic
e Physical Security
© Keycard protocols, biometric scanning protocols, and around the clock interior and exterior surveillance
o Access limited to authorized data center employees
o Thorough Background security checks for all data center employees
¢ Conditioned Power
o UPS for all servers
o N+l Redundant UPS power subsystems with failover if the primary UPS fails
o Onsite diesel generators for extended power outages

e Precision Environment
o N+tl Redundant HVAC systems

Wagsys Software Solutions (888)304-0007 - Direct (845) 590-5820 - Dean.sefrm@wagsys.com

Page |42— EXHIBIT © - City of Nashua, NH
RFP061 1-033116 —Licensing, Permitting, Code Enforcement and Land Management System

o Advanced Fire Suppression Systems
e Network Specifications
© Dedicated providers for our customers
High-performance bandwidth
9 network providers for multiple redundancies
219 CDN edge locations
Fiber carriers
Fully Redundant, enterprise-class routing equipment
Certified Network Technicians, fully trained to industry standards

000C06dC0O0U8

8. Pricing Schedule

i. PRICING SCHEDULE ATTACHMENT A: Subtotal a, b & c, then all totai a-e

oO
Amount
Written

hundred thirteen thousand and

Amount-
Numeric

$113,500.00

Item Quantit | Per Unit Comments

$

a) Software-Base

attached

thousand and five hundred attached

hundred and twenty five

$125,000.00

See next pages for detailed description of above costs

Explanation for any additional cost associated with your proposal that is not
included in the above pricing schedule.

Wagsys Software Solutions (888)304-0007 - Direct (845) 590-5820 - Dean.sefrin@wagsys.com

Page |43-—EXHIBIT C - City of Nashua, NH

RFP0611-033116 —Licensing, Permitting, Code Enforcement and Land Management System

Professional Services Cost (one time implementation costs)

ITEM MODULE IMPLEMENTATION/CONFIGURATION QTY UNIT PRICE LINE TOTAL
1.

All modules as described in the RFP $85,000.00 $85,000.00

1A OPTION: Upgrade to E-plan planning software $20,000.00
2. EIVICgov Toots $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) $10,500.00 $10,500.00
5 GIS Mapping (ESRI) complaint $15,000.00 $15,000.00
7, On-site Training and other training processes $3,000.00 $1,000.00
9. **CUSTOMER MUST PROVIDE TAX EXEMPTION CERTIFICATE SubTotal $113,500.00
SALES TAX
TOTAL $113,500.00

Wagsys Software Solutions (888)304-0007 - Direct (845) 590-5820 - Dean.sefrin@wagsys.com

Page |44—EXHIBIT C - City of Nashua, NH
RFP0611-033116 —Licensing, Permitting, Code Enforcement and Land Management System

Annual Subscription Services Agreement

ITEM SUBSCRIPTION SERVICES QTY UNIT PRICE LINE TOTAL
CIVI€gov System - User Subscription (up to 85users)
Includes: 4 manual data updates supplied by Vision Data
1. includes: 4 manual GIS data updates supplied by County GIS 1 $8,500.00 $8,500.00
If automated option selected during implementation, the manual updates are not
applicable. See option price sheet for additional manual export costs.
Citizen Access Portal -population utilizing Municipay/CIVICgov packaged
2. payment processor and all features as required in RFP $1,000 $1,000.00
3. ESRI Mapping support as defined in RFP 1 $2,000.00 $2,000.00
4. **CUSTOMER MUST PROVIDE TAX EXEMPTION CERTIFICATE
SUBTOTAL $11,500.00
SALES TAX **
TOTAL YEAR ONE SUBSCRIPTION COST $11,5000.00

Wagsys Software Solutions (888)304-0007 - Direct (845) 590-5820 - Dean.sefrin@wagsys.com