Extracted text (via ocr_local)
41274 characters
AGREEMENT FOR
Operations, Analytic and Reporting System (OARS) RFP 22-20
This Agreement for Operations, Analytic and Reporting System (OARS) ("Agreement") is effective and entered into
between CITY OF GLENDALE, an Arizona municipal corporation ("City"), and NJBSoft, LLC, an Arizona
limited liability corporation (the "Contractor"), as of the day of 2022.
RECITALS
A. City intends to undertake a project for the benefit of the public and with public funds that is more fully set
forth in Exhibit A, pursuant to Solicitation No. RFP 22-20 (the "Project");
B. City desires to retain the services of Contractor to perform those specific duties and produce the specific
work as set forth in the Project attached hereto;
Cc. City and Contractor desire to memorialize theit agreement with this document.
AGREEMENT
In consideration of the Recitals, which are confirmed as true and cortect and incorporated by this reference, the
mutual promises and covenants contained in this Agreement, and other good and valuable consideration, City and
Contractor agree as follows:
1. Key Personnel; Sub-contractors.
11
1.2
Services. Contractor will provide all services necessaty to assure the Project is completed timely
and efficiently consistent with Project requirements, including, but not limited to, working in close
interaction and interfacing with City and its designated employees, and working closely with others,
including other contractors or consultants, retained by City.
Project Team.
(1)
2)
Project Manager.
(3)
Contractor will designate an employee as Project Manager with sufficient training,
knowledge, and experience to, in the City's option, complete the Project and
handle all aspects of the Project such that the work produced by Contractor is
consistent with applicable standards as detailed in this Agreement;
The City must approve the designated Project Manager; and
To assure the Project schedule is met, Project Manager may be required to devote
no less than a specific amount of time as set out in Exhibit A.
Project Team.
(1)
(2)
The Project Manager and all other employees assigned to the project by
Contractor will comprise the "Project Team."
Project Manager will have responsibility for and will supervise all other employees
assigned to the Project by Contractor.
Discharge, Reassign, Replacement.
(1)
(2)
Contractor acknowledges the Project Team is comprised of the same persons and
roles for each as may have been identified in the response to the Project's
solicitation.
Contractor will not discharge, reassign or replace or diminish the responsibilities
of any of the employees assigned to the Project who have been approved by City
-1-
4/29/2021
without City's prior written consent unless that person leaves the employment of
Contractor, in which event the substitute must first be approved in writing by City.
(3) Contractor will change any of the members of the Project Team at the City's
request if an employee's performance does not equal or exceed the level of
competence that the City may reasonably expect of a person performing those
duties or if the acts or omissions of that person are detrimental to the
development of the Project.
d. Sub-contractors.
(1) Contractor may engage specific technical contractor (each a "Sub-contractor") to
furnish certain service functions.
(2) Contractor will remain fully responsible for Sub-contractor's services.
(3) Sub-conttactors must be approved by the City, unless the Sub-contractor was
previously mentioned in the response to the solicitation.
(4) Contractor shall certify by letter that contracts with Sub-contractors have been
executed incorporating requirements and standards as set forth in this Agreement.
Schedule. The services will be undertaken in a manner that ensures the Project is completed timely and
efficiently in accordance with the Project.
Contractor’s Work.
3.1
3.2
3.3
Standard. Contractor must perform services in accordance with the standards of due diligence,
cate, and quality prevailing among contractors having substantial experience with the successful
furnishing of services for projects that ate equivalent in size, scope, quality, and other criteria under
the Project and identified in this Agreement.
Licensing. Contractor warrants that:
a. Contractor and Sub-conteactors will hold all appropriate and required licenses,
registrations, and other approvals necessary for the lawful furnishing of services
("Approvals"); and
b. Neither Contractor nor any Sub-contractor has been debarred or otherwise legally
excluded from contracting with any federal, state, or local governmental entity
("Debarment").
(1) City is under no obligation to ascertain or confirm the existence or issuance of any
Approvals or Debarments or to examine Contractor's contracting ability.
(2) Contractor must notify City immediately if any Approvals or Debarment changes
during the Agreement's duration and the failure of the Contractor to notify City as
required will constitute a material default under the Agreement.
Compliance. Services will be furnished in compliance with applicable federal, state, county and
local statutes, rules, regulations, ordinances, building codes, life safety codes, and other standards
and criteria designated by City.
Contractor must not discriminate against any employee or applicant for employment on the basis
of race, color, religion, sex, national origin, age, marital status, sexual orientation, gender identity or
expression, genetic characteristics, familial status, U.S. military veteran status or any disability.
Contractor will require any Sub-contractor to be bound to the same requirements as stated within
this section. Contractor, and on behalf of any subcontractors, warrants compliance with this
section.
4/29/2021
3.4 Coordination; Interaction.
a. Fot projects that the City believes requires the coordination of various professional
setvices, Contractor will work in close consultation with City to proactively interact with
any other professionals retained by City on the Project ("Coordinating Project
Professionals").
b. Subject to any limitations expressly stated in the Project Budget, Contractor will meet to
review the Project, Schedule, Project Budget, and in-progress work with Coordinating
Project Professionals and City as often and for durations as City reasonably considers
necessary in order to ensure the timely work delivery and Project completion.
c. For projects not involving Coordinating Project Professionals, Contractor will proactively
interact with any other contractors when directed by City to obtain or disseminate timely
information for the proper execution of the Project.
3.5 Work Product.
a. Ownership. Upon receipt of payment for services furnished, Contractor grants to City,
and will cause its Sub-contractors to grant to the City, the exclusive ownership of and all
copyrights, if any, to evaluations, reports, drawings, specifications, project manuals,
surveys, estimates, reviews, minutes, all "architectural work" as defined in the United States
Copyright Act, 17 U.S.C § 101, é seg., and other intellectual work product as may be
applicable ("Work Product").
63) This grant is effective whether the Work Product is on paper (e.g., a "hard copy"),
in electronic format, or in some other form.
(2) Contractor warrants, and agrees to indemnify, hold harmless and defend City for,
from and against any claim that any Work Product infringes on third-party
proprietary interests.
b. Delivery. Contractor will deliver to City copies of the preliminary and completed Work
Product promptly as they are prepared.
c City Use.
(ay City may reuse the Work Product at its sole discretion.
(2) In the event the Work Product is used for another project without further
consultations with Contractor, the City agrees to indemnify and hold Contractor
harmless from any claim arising out of the Work Product.
(3) In such case, City shall also remove any seal and title block from the Work
Product.
Compensation for the Project.
41 Compensation. Contractor's compensation for the Project, including those furnished by its Sub-
contractors will not exceed $241,500 as specifically detailed in Exhibit B (the "Compensation").
4.2 Change in Scope of Project. The Compensation may be equitably adjusted if the originally
contemplated scope of services as outlined in the Project is significantly modified.
a. Adjustments to the Compensation require a written amendment to this Agreement and
may tequite City Council approval.
b. Additional services which are outside the scope of the Project contained in this Agreement
may not be performed by the Contractor without prior written authorization from the City.
c Notwithstanding the incorporation of the Exhibits to this Agreement by refetence, should
any conflict arise between the provisions of this Agreement and the provisions found in
4/29/2021
5.
the Exhibits and accompanying attachments, the provisions of this Agreement shall take
ptiority and govern the conduct of the parties.
Billings and Payment.
5.1 Applications.
a. Contractor will submit monthly invoices (each, a "Payment Application") to City's Project
Manager and City will remit payments based upon the Payment Application as stated
below.
b. The period coveted by each Payment Application will be one calendat month ending on
the last day of the month or as specified in the solicitation.
5.2 Payment.
a. After a full and complete Payment Application is received, City will process and remit
payment within 30 days.
b. Payment may be subject to or conditioned upon City's receipt of:
(1) Completed work generated by Contractor and its Sub-contractors; and
(2) Unconditional waivers and releases on final payment from Sub-contractors as City
may reasonably request to assure the Project will be free of claims arising from
required performances under this Agreement.
5.3 Review and Withholding. City's Project Manager will timely review and certify Payment
Applications.
a. If the Payment Application is rejected, the Project Manager will issue a written listing of
the items not approved for payment.
b. City may withhold an amount sufficient to pay expenses that City reasonably expects to
incur in correcting the deficiency or deficiencies rejected for payment.
Termination.
6.1 For Convenience. City may terminate this Agreement for convenience, without cause, by
delivering a written termination notice stating the Effective Termination date, which may not be
less than 30 days following the date of delivery.
a. Contractor will be equitably compensated for Goods ot Services furnished prior to receipt
of the termination notice and for reasonable costs incurred.
b. Contractor will also be similarly compensated for any approved effort expended and
approved costs incurred that are directly associated with project closeout and delivery of
the required items to the City.
6.2 For Cause. City may terminate this Agreement for cause if Contractor fails to cure any breach of
this Agreement within seven days after receipt of written notice specifying the breach.
a. Contractor will not be entitled to further payment until after City has determined its
damages. If City's damages resulting from the breach, as determined by City, are less than
the equitable amount due but not paid Contractor for Service and Repair furnished, City
will pay the amount due to Contractor, less City's damages, in accordance with the
provision of § 5.
b. If City's direct damages exceed amounts otherwise due to Contractor, Conttactor must pay
the difference to City immediately upon demand; however, Contractor will not be subject
to consequential damages of more than $250,000 or the amount of this Agreement,
whichever is greater.
4/29/2021
Conflict. Contractor acknowledges this Agreement is subject to A-R.S. § 38-511, which allows for
cancellation of this Agreement in the event any person who is significantly involved in initiating,
negotiating, securing, drafting, or creating the Agreement on City's behalf is also an employee, agent, or
consultant of any other party to this Agreement.
Insurance.
8.1 Requitements. Contractor must obtain and maintain the following insurance ("Required
Insurance"):
a. Contractor and Sub-contractors. Conttactor, and each Sub-contractor performing work or
providing materials related to this Agreement must ptocure and maintain the insurance
coverages described below (collectively referred to herein as the "Contractor's Policies"),
until each Party's obligations under this Agreement are completed.
b. General Liability.
(1) Contractor must at all times relevant hereto carry a commercial general liability
policy with a combined single limit of at least $1,000,000 per occutrence and
$2,000,000 annual aggregate for each property damage and contractual property
damage.
(2) Sub-contactots must at all times relevant hereto carry a general commercial liability
policy with a combined single limit of at least $1,000,000 per occurrence.
(3) This commercial general liability insurance must include independent contractors’
liability, contractual liability, broad form property coverage, XCU hazards if
requested by the City, and a separation of insurance provision.
(4) These limits may be met through a combination of primary and excess liability
coverage.
c. Auto. A business auto policy providing a liability limit of at least $1,000,000 per accident
for Contractor and $1,000,000 per accident for Sub-contractors and covering owned, non-
owned and hired automobiles.
d. Workers' Compensation and Employer's Liability. A workers’ compensation and
employer's liability policy providing at least the minimum benefits required by Arizona law.
e. Notice of Changes. Contractor's Policies must provide for not less than 30 days’ advance
written notice to City Representative of:
(D Cancellation or termination of Contractor or Sub-contractor's Policies;
(2) Reduction of the coverage limits of any of Contractor or and Sub-contractot's
Policies; and
(3) Any other material modification of Contractor or Sub-contractor's Policies related
to this Agreement.
f. Certificates of Insurance.
(1) Within 10 business days after the execution of the Agreement, Contractor must
deliver to City Representative certificates of insurance for each of Contractor and
Sub-contractor's Policies, which will confirm the existence or issuance of
Contractor and Sub-contractor's Policies in accordance with the provisions of this
section, and copies of the endorsements of Contractor and Sub-contractor's
Policies in accordance with the provisions of this section.
(2) City is and will be under no obligation either to ascertain or confirm the existence
or issuance of Contractor and Sub-contractor's Policies, ot to examine Contractor
and Sub-contractor’s Policies, or to inform Contractor or Sub-contractor in the
event that any coverage does not comply with the requirements of this section.
-5-
4/29/2021
(3) Contractor's failure to secure and maintain Contractor Policies and to assure Sub-
contractor policies as required will constitute a material default under the
Agreement.
Other Contractors or Vendors.
(a) Other contractors or vendors that may be contracted with in connection with the
Project must procure and maintain insutance coverage as is appropriate to their
particular contract.
(2) This insurance coverage must comply with the requirements set forth above for
Contractor's Policies (e.g., the requirements pertaining to endorsements to name
the parties as additional insured parties and certificates of insurance).
Policies. Except with respect to workers’ compensation and employer's liability coverages,
City must be named and properly endorsed as additional insureds on all liability policies
required by this section.
(1) The coverage extended to additional insureds must be primaty and must not
contribute with any insurance or self insurance policies or programs maintained by
the additional insureds.
(2) All insurance policies obtained pursuant to this section must be with companies
legally authorized to do business in the State of Arizona and reasonably acceptable
to all parties.
8.2 Sub-contractors.
a.
Conttactor must also cause its Sub-contractors to obtain and maintain the Required
Insurance.
City may consider waiving these insurance requirements for a specific Sub-contractor if
City is satisfied the amounts required are not commercially available to the Sub-contractor
and the insurance the Sub-conttactor does have is appropriate for the Sub-contractor's
work under this Agreement.
Contractor and Sub-contractors must provide to the City proof of the Required Insurance
whenever requested.
8.3 Indemnification.
a.
To the fullest extent permitted by law, Contractor must defend, indemnify, and hold
harmless City and its elected officials, officers, employees and agents (each, an
"Indemnified Party," collectively, the "Indemnified Parties"), for, from, and against any and
all claims, demands, actions, damages, judgments, settlements, personal injury (including
sickness, disease, death, and bodily harm), property damage (including loss of use),
infringement, governmental action and all other losses and expenses, including attorneys’
fees and litigation expenses (each, a "Demand or Expense"; collectively, "Demands or
Expenses") asserted by a third-party (i.e. a person or entity other than City or Contractor)
and that arises out of or results from the breach of this Agreement by the Contractor or
the Contractor’s negligent actions, errors or omissions (including any Sub-contractor or
other petson or fitm employed by Contractor), whether sustained before or after
completion of the Project.
This indemnity and hold harmless provision apply even if a Demand or Expense is in part
due to the Indemnified Party's negligence or breach of a responsibility under this
Agreement, but in that event, Contractor shall be liable only to the extent the Demand or
Expense results from the negligence or breach of a responsibility of Contractor or of any
petson or entity for whom Contractor is responsible.
4/29/2021
10.
11.
c. Contractor is not required to indemnify any Indemnified Parties for, from, or against any
Demand or Expense resulting from the Indemnified Party's sole negligence or other fault
solely attributable to the Indemnified Party.
E-verify, Records and Audits. To the extent applicable under A.R.S. § 41-4401, the Contractor warrant
their compliance and that of its subcontractors with all federal immigration laws and regulations that relate
to their employees and compliance with the E-verify requirements under A.R.S. § 23-214(A). The
Contractor or subcontractor’s breach of this warranty shall be deemed a material breach of the Agreement
and may result in the termination of the Agreement by the City under the terms of this Agreement. The City
tetains the legal right to randomly inspect the papers and records of the other party to ensure that the other
party is complying with the above-mentioned warranty. The Contractor and subcontractor warrant to keep
theit respective papers and records open for random inspection during normal business hours by the other
party. The parties shall cooperate with the City’s random inspections, including granting the inspecting party
entry rights onto their respective properties to perform the random inspections and waiving their respective
tights to keep such papers and records confidential.
No Boycott of Israel. To the extent A.R.S § 35-393 through § 35-393.03 are applicable, the parties hereby
certify that they are not currently engaged in and agree for the duration of the Agreement to not engage in,
a boycott of goods or services from Israel, as that term is defined in A.R.S § 35-393.
Attestation of PCI Compliance. When applicable, the Contractor will provide the City annually with a
Payment Card Industry Data Security Standard (PCI DSS) attestation of compliance certificate signed by an
officer of Contractor with oversight responsibility.
Notices.
12.1 A notice, request or othet communication that is required or permitted under this Agreement (each
a"Notice") will be effective only if:
The Notice is in writing; and
b. Delivered in person or by overnight courier sevice (delivery charges prepaid), certified or
registered mail (return receipt requested); and
c Notice will be deemed to have been delivered to the person to whom it is addressed as of
the date of receipt, ift
(1) Received on a business day, or before 5:00 p.m., at the address for Notices
identified for the Party in this Agreement by U.S. Mail, hand delivery, or overnight
courier service on or before 5:00 p.m.; or
(2) As of the next business day after receipt, if received after 5:00 p.m.
d. ‘The burden of proof of the place and time of delivery is upon the Party giving the Notice;
and
e. Digitalized signatures and copies of signatures will have the same effect as original
signatures.
12.2 Representatives.
a. Contractor. Contractor's representative (the "Contractor's Representative") authorized to
act on Contractor's behalf with respect to the Project, and his or her address for Notice
delivery is:
NJBSoft, LLC
c/o Pranam Joshi, President
202 E Earl Drive, Suite 110
Phoenix, AZ 85012
ptanam. joshi@njbsoft.com
602-629-0206
4/29/2021
14.
City. City's representative ("City's Representative") authorized to act on City's behalf, and
his or her address for Notice delivery is:
City of Glendale
c/o Connie Schneider
Glendale, Arizona 85301
623-930-2868
cschneider@glendaleaz.com
With required copy to:
City Manager City Attorney
City of Glendale City of Glendale
5850 West Glendale Avenue 5850 West Glendale Avenue
Glendale, Arizona 85301 Glendale, Arizona 85301
Concurrent Notices.
(1) All notices to City's representative must be given concurrently to City Manager
and City Attorney.
(2) A notice will not be deemed to have been received by City's representative until
the time that it has also been received by City Manager and City Attorney.
(3) City may appoint one or more designees for the purpose of receiving notice by
delivery of a written notice to Contractor identifying the designee(s) and their
respective addresses for notices.
Changes. Contractor or City may change its representative or information on Notice, by
giving Notice of the change in accordance with this section at least ten days prior to the
change.
Financing Assignment. City may assign this Agreement to any City-affiliated entity, including a non-
ptofit corporation or other entity whose primary purpose is to own ot manage the Project.
Entire Agreement; Survival; Counterparts; Signatures.
14.1
14.2
Integration. This Agreement contains, except as stated below, the entire agreement between City
and Contractor and supersedes all prior conversations and negotiations between the parties
regarding the Project or this Agreement.
a.
Neither Party has made any representations, wartanties or agreements as to any matters
concetning the Agreement's subject matter.
Representations, statements, conditions, or watranties not contained in this Agreement will
not be binding on the parties.
The solicitation, any addendums and the response submitted by the Contractor are
incorporated into this Agreement as if attached hereto. Any Contractor response modifies
the original solicitation as stated. Inconsistencies between the solicitation, any addendums
and the response or any excerpts attached as Exhibit A and this Agreement will be
resolved by the terms and conditions stated in this Agreement.
Interpretation.
a.
The parties fairly negotiated the Agreement's provisions to the extent they believed
necessary and with the legal representation they deemed appropriate.
The patties ate of equal bargaining position and this Agreement must be construed equally
between the parties without consideration of which of the parties may have drafted this
Agreement.
4/29/2021
15.
16.
17,
14.3
14.4
14.5
14.6
14.7
Term.
15.1
15.2
c The Agreement will be interpreted in accordance with the laws of the State of Arizona.
Survival. Except as specifically provided otherwise in this Agreement, each warranty,
representation, indemnification and hold harmless provision, insurance requirement, and every
other right, remedy and responsibility of a Party, will survive completion of the Project, or the
eatliet termination of this Agreement.
Amendment. No amendment to this Agreement will be binding unless in writing and executed by
the parties. Any amendment may be subject to City Council approval. Electronic signature blocks
do not constitute execution.
Remedies. All rights and remedies provided in this Agreement are cumulative and the exercise of
any one or more right or remedy will not affect any other rights or remedies under this Agreement
or applicable law.
Severability. If any provision of this Agreement is voided or found unenforceable, that
determination will not affect the validity of the other provisions, and the voided or unenforceable
provision will be deemed reformed to conform to applicable law.
Counterparts. This Agreement may be executed in counterparts, and all counterparts will together
comprise one instrument.
Renewals. The term of this Agreement commences upon the effective date and continues for a one
(1) year initial period. The City may, at its option and with the approval of the Consultant, extend
the term of this Agreement an additional four (4) years, renewable on an annual basis. Consultant
will be notified in writing by the City of its intent to extend the Agreement period at least thirty (30)
calendar days prior to the expiration of the original or any renewal Agreement period. Price
adjustments will only be reviewed during the Agreement renewal period and will be a determining
factor for any renewal. There are no automatic renewals of this Agreement.
Extension for Procurement Process. Upon the expiration of the Term of this Agreement, including
the initial term and any renewals, at the City’s sole discretion, this Agreement may be extended on a
month-to-month basis for a maximum of six (6) months to allow for the City to complete its
ptocutement process to select a vendor to provide the services/materials similar to those provided
under this Agreement. The City will notify the Contractor in writing of its intent to extend the
Agreement at least thitty (30) calendar days prior to the expiration of the Term. Any extension
provided under this subsection will continue under the same terms and conditions as in effect
immediately prior to the expiration of the then-current term.
Dispute Resolution, Any controversy or claim arising out of or relating to this contract, or the breach
thereof, shall be settled by arbitration administered according to the American Arbitration Association’s
Commercial Arbitration Rules, and judgment on the award rendered by the arbitrator may be entered in any
court having jurisdiction thereof.
Cooperative Use of Contract. This agreement may be extended for use by other governmental agencies
and political subdivisions of the State. Any such usage by other entities must be in accord with the
ordinances, charter, rules and regulations of the respective entity and the approval of the Contractor and
City. For a list of SAVE members, click on the following link:
http: / /Awww.mesaaz.pov/business/purchasing/save
4/29/2021
18.
Exhibits. The following exhibits, with reference to the term in which they ate first referenced, are
incorporated by this reference.
Exhibit A
Exhibit B
Exhibit C
Appendix A
Appendix B
Project
Scope of Services
Compensation
Software License Terms
Software Support Services
-10-
4/29/2021
The patties enter into this Agreement as of the Effective Date shown above.
City of Glendale,
an Arizona municipal corporation
By: Kevin R. Phelps
Its: City Manager
ATTEST:
Julie K. Bower
City Clerk SEAL
ty
APPROVED AS 'TO FORM:
Michael D. Bailey
City Attorney
NJBSoft, LLC
an Arizona limited liability company
—=
4
By: Pranam Joshi
Its: President
-ll-
4/29/2021
EXHIBIT A
Operations, Analytic and Reporting System (OARS)
PROJECT
Contractor will provide project as described in the attached RFP 22-20.
0.00
0.0 Project Management Questions EXHIBIT A
Requirement
Provide a proposed project plan
(see attached)
0.01
Provide a RACI table for key tasks by project phase
(see attached)
0.02
Provide a listing of recommended City staffing/skillsets and estimated number of hours per month for the duration of the
The resources require for City staff include:
1. Project Manager — BA/PM role. This role will ensure that project keeps on track and all items are resolved
2. Business Champion — This skill set is a cross functional skill set of a business SME plus a BA to help ensure all adequate requirements
are understood for all team members.
0.03
Provide a resource plan for consulting staff assigned to the project with corresponding role
Consultant resource plan:
1. Pranam Joshi — 20%
2. Ken Marshal — 20%
3. Phil Ponce — 10%
4. Jason Scoville — 10%
5. Implementation Support Team 20%
‘ 1.0 Technical Questions
S
Glendale
wPIZ DEA
IT Review
Requirement
Comments
Available in
Modified/
Alternative
Available
Future Release
(Provide
Expected Date)
Not Provided
Provide application architecture diagram
Does application require software to be installed on a
1.01 Windows machine? xX Not required. It is a web based software
1.02 |Software has a web browser component x Yes
1.03 |Software has a native Android app Xx Yes
1.04 |If yes, is it full-featured? Xx Yes
1.05 |Software has a native iOS app x Yes
1.06 |If yes, is it full-featured? x Yes
1.07 Application is fully supported on latest versions of x Yes
Google Chrome, Firefox, Safari, and Edge
1.08 |Supports SSL encryption in transit x Yes
1.09 |Supports encryption for data at rest (database/file) X Yes
We use azure cloud hosting and azure is
FIPS compliant and validated. Depending
on the hardware chosen for role out, we
can be either level 2 or level 3 compliant
ls FIPS (Federal Information Processing Standard) 140-
1.10 |2 Compliant x
- If YES, which level (e.g., 1, 2 , 3. or 4)?
1.11 |Communicates via TCP/IP network protocol x
1.12 |Database has the ability to archive data x
1.13 |Database has the ability to restore archived data x
It is implementation and client dependent and we can set any frequency that is meaningful and
1.14 |What frequency is the data archived? reasonatbe for client
It is implementation and client dependent and we can set any frequency that is meaningful and
1.15 |What is the retention for archived data? reasonalbe for client
1.16 |Database has the ability to query archived data xX
1.17 |Database provides encryption of data at rest X
Provide a data dictionary with clear definitions, down
1.18 |to the column level, and entity-relationship diagrams x
available
1.0 Technical Questions
Glendale = 5S 2 ee 8
at g 222 326 5 IT Revi
Lame pla : re 2s Y 2 ES eview
Requirement a ges «38 2
ig giz 5a o # Comments
< Pe | BIO 3
we uw
Describe the reporting tools (e.g., SSRS, SQL, SANS has in-built report development tools similar to crystal reports, it has inbuilt tool that :
Business Intelligence) delivered with your software emulates excel and uses excel engine for reporting, it has predefined queries (ad-hoc) reporting
1.19 dh dard , l » |that can be created with minimal query writing capabilities and it dynamically creates reports and
e-8..ad hoc) standar feportingstco executive has ability to automatically send out emails and messages, Mail-merge reports capabilities, SSRS
dashboard and level of integration with all modules | _.apabalities, Dashboards, maps based queries and views
Will the City have direct sql access to the
1.20 |application database (e.g., ETL, reporting, data x Yes
quality tools)
. 4 Through direct SQL Access to the database through a designated ports, web api (SOAP, REST, WCF,
1.21 |Explain how solution will support Data Warehousing etc) and automated import export through sftp and file and email based exports
Application offers a full featured API (Application
1.22 |Programming Interface) x
*If yes, provide documentation
Yes we have an extension using form
Other than an API, application has the capability to builder that can be used for any level of
1.23 be configured, modified, or extended via Component x access to the application. Form builder
“~ |Object Model interfaces, a vendor-supplied scripting can be used as a full enterprise as well as
language, or other such means acceptable to the City mobile workflow solution and one-stop
shop tool
Vendor shall be required to apply all security and
1.24 |critical updates for all components of the proposed X
solution within 90 days of release
Does the application support Active Directory or ADFS
1.25 me x
authentication?
Describe the user login experience when Active
1.26 |Directory/ADFS authentication is enabled. Is Yes, we use SAML login or ADFS access to the LDAP login. This allows a logged in user to directly log
passthrough supported?
On Premise (skip this section if hosted solution )
Glendale
ARIZ OWA
Requirement
1.0 Technica
Questions
Comments
(Provide
Expected Date)
Not Provided
Available in
Modified/
Alternative
Available
Future Release
IT Review
Comments
1.27 Proposed solution compatible with VMWare ESXI 6.5
~~ jor later
1.28 Database version should be SQL Server 2017 or higher x We prefer 19 as well but support 16 or
““~ |Note: SQL Server 2019 is preferred higher
1.29 Operating systems shall be Microsoft Windows Server x
“~ 12012 R2 or higher
1.30 MiG Sensi ITB Veveslel e CA CASING xX We prefer latest versions of IIS server
current supported version of Apache/Tomcat
Hosted Environment (skip this section if on premise solution )
1.31 |Which hosting service will be used (Ex. Azure/AWS) Azure is proposed but we can do AWS as well
1.32 |Will City data be stored outside of the United States? No
1.33 |City owns all data Yes
Describe the process and timing for the City to . . .
e Automated evi eek on City's sf ith a 24 hour noti
1.34 Pecreverrillliconvomitstdstat utomated everyweek on City's sftp or with a jour notice
Will City data be hosted on a multitenant
environment?
35 : No. We h ed dedicated r
; If so, how is the data logically separated from the 0. We have proposed’ cealcated serve!
other tenants?
1.36 What is your Incident Response Plan in the event of a See attached
data breech?
1.37 What is your Business Continuity and Disaster See attached
Recovery Plan?
1.38 |Provide latest SOCII Report We currently do not have a SOCII certification but we will have it by 06/30/22
We can put whatever security requirements that City would prefer. But none of our clients have
1.39 |Does hosting party require a VPN connection VPN requirements to access software right now. However, to access RDP (server configuration) we
need a VPN connection.
1.40 |Does hosting party require a firewall? We always use a firewall provided through azure or AWS Portal
Glendale
ec)
ARIZIWA
Requirement
Attach Server/Workstation/Mobile Device
Hardware/Network Specifications
—
1.0 Technica
Questions
Comments
Available in
Modified/
Alternative
Available
Future Release
(Provide
Expected Date)
Not Provided
Hardware/Network Specifications
See attached
IT Review
Comments
Support
We offer On-Prem as well as SAAS deployment models including private/hybrid cloud. Both costs are
1.42 |Provide the software deployment model “_ — eploymen attached g private fnyor
1.43 |Attach SLA Maintenance Contract See attached
Vendor shall supply all pertinent documentation in
1.44 both printed and electronic forms for end-users, Agreed
*"* Jadministrators, and information technology support
personnel
pelts m Our support includes unlimited support along with updates and upgrades as long as you are on the
1.45 shad a description of on-going product support and support plan. We also have a dedicated account manager that is ready to answer all your questions
maintenance program(s). without going through standard support line. See SLA for further information.
4 es Through support or account manager a product enhancement should be requested. Generally NJB
1.46 vee ire process for the City to request future includes this at no cost to the client if this is a reasonable request and not specific to glendale.
peocucheananeeinen ts Team will decide the timeline and send out an update on the agreed upone time frames.
Describe the technology to communicate standard
1.47 |and unplanned downtimes to the application users We use list server, emails and Monday.com to plan and communicate with users about the downtimes
and administrators
1.48 ferns Gigy eS ee ATS em UeeraTine Via product release notes and phone calls as applicable, if there is a critical upgrade needed.
1.49 How much notice will the City be given of an Generally, if it is not a critical upgrade then we will work on City's timeline and City will never be
“"* lupcoming upgrade? forced into an upgrade.
1.50 What isithe frequency and|timing of'standard Approximately 1 per month and generally on Sunday evenings after 10 pm and before 2 am
maintenance windows?
1.51 Describe the frequency and types of Software We usually release minor patches once every quarter and major release twice a year. These do not
Upgrades included in Ongoing Maintenance
include any critical patches.
Requirement
Describe how upgrades will be applied to City’s
1.0 Technical Questions
Comments
Available in
Modified/
Alternative
Available
Future Release
(Provide
Expected Date)
Not Provided
Designated individuals will log into RDP and create a backup fo the current system, machine and
database. They will upgrade the database for the changes, upgrade the software, run automated
IT Review
Comments
1.52 iN
environment by Contractor staff. tests and assign manual testers to ensure no critical errors.
Describe level of effort required by City staff for
1.53 Yes
upgrades applied by Contractor staff.
Will there be a “sandbox” environment available for
1.54]. A Yes
City staff to test the upcoming upgrade?
3.0 GIS - Technical Questions
Glendale
IT Review
Comments
Comments
Requiremen
Available in
Current Release
Modified/
Alternative
Available
Future Release
(Provide Expected
Not Provided
Software has ArcGIS Integration & Mapping funtionality
Provide the latest version ESRI ArcGIS Server supported. Minimum | All version above 10.3 are all supported. We use ESRI Rest API to connect to
ie 10.3 ESRI servers and display sampling location as well as all infrastructure
2.03 Software has the ability to consume ArcGIS recources and web Yes
““~ |services
2.04 |Software has Spatial Analysis Tools Yes
2.05 | Software can directly read from ESRI Enterprise Geodatabases Yes
Software will integrate with the City’s Master Address database
2.06 |within ArcSDE (containing all parcel/property information) to Yes
validate address information.
2.07 | Ability to track activities by map location. Yes
2.08 Ability to link GIS data to get address, location, zoning, land use, Yes
~~" information, council district, inspection area, FEMA flood zone, etc.
2.09| Ability to integrate with ESRI ArcGIS online Yes
Assuming the question is that
2.10| Software has ability to publish ArcGIS web service(s) Yes can we integrate using arcgis
web services. Answer is yes.
Ability to query, view, and export proposed system database for
integration with City's GIS database.
Ability to identify and utilize all unit addresses (e.g.unit, suite,
apartment, etc.)
2.11 Yes
2.12 Yes
3.0 Systemwide Requirements
Glendale
Za8a
IT Review
Comments
Comments
Requirement
Available in
Current Release
Modified/
Alternative
Available
Future Release
(Provide Expected
Not Provided
Ability to maintain a record for laboratory readings
3.02 |Ability to have User-defined fields on screen forms/page Yes
3.03 |Ability to have User-defined “mandatory” fields Yes
Ability to review, edit readings or provide comments and status
for readings
3.05 Ability to lock down historical fields as “read-only” Yes
Ability to define fields that are confidential and limit access to
3.04 Yes
Sas those fields and/or information Yes
3.07 Ability to provide an Audit Trail with Users Name, date & time Yes
i when a record is created, updated or deleted
3.08 Ability to perform searches across all records within the system Yes
System must provide an error message when a duplicate record is
3.09 Yes
created
3.10 |Ability to provide FAQ or online help within the system Yes
3.11 |Ability to export data to Microsoft Excel, PDF Yes
3.12 Ability to enter data using mobile devices (e.g., tablets or phones)} Yes
System shall have ability to create templated letters in Word and
SB PDF and scan them to upload into the system Yes
3.14 System shall have ability to modify templated form/notice and Yes
- add additional fields and data other than the standard fields
3.15 Ability to create charts/bar diagrams/line diagrams based on data Yes
entered into the system
3.16 |Provide standard dashboards to monitor daily lab readings Yes
3.17 |Provide ability to upload photos and documents Yes