Search

FINANCE COMMITTEE

JUNE 1, 2016

7:00 PM Aldermanic Chamber

ROLL CALL

PUBLIC COMMENT

COMMUNICATIONS

From:
Re:

From:
Re:

From:
Re:

From:
Re:

From:
Re:

From:
Re:

From:
Re:

From:
Re:

From:
Re:

Dan Kooken, Purchasing Manager

Financial (Lawson/Kronos ERP) System Consulting Services Contract (Value: NTE $90,000)
Department: 122 Information Technology; Fund: Capital Projects — Technology; Activity
Description: “NGIN” ERP System

Dan Kooken, Purchasing Manager
Contract Award to Purchase a Riskmaster Upgrade for the Risk Department (Value: $42,975)
Department: Information Technology; Fund: Bond NGIN Project

Dan Kooken, Purchasing Manager
Purchase Award for City Hall Firewall Replacement (Value: $64,490)
Department: Information Technology; Fund: Bond NGIN Project

Dan Kooken, Purchasing Manager
Award Purchase of Microfilm Scanner (Value: $12,982); Department: Library; Fund: General
Fund; Account Classification: 71 Equipment

Dan Kooken, Purchasing Manager

City Arts Nashua Contract (Value $20,000); Department: 109 Civic and Community Activities;
Fund: General Fund; Account Classification: 56 Human Service Agencies — Downtown
Improvement Fund

Dan Kooken, Purchasing Manager
Contract Award for Single Stream Recycling (Value: Not-to-Exceed $249,925); Department:
168 Solid Waste; Fund: Solid Waste; Account Classification: 55 Other Contracted Services

Dan Kooken, Purchasing Manager

Contract Award for Renewal of USDA Wildlife Management Service Agreement
(Value: Not-to- Exceed $67,696); Department: 168 Solid Waste; Fund: Solid Waste
Account Classification: 53 Professional & Technical Services

Dan Kooken, Purchasing Manager

To Approve a Professional Services Contract with Sanborn, Head & Associates, Inc. for
Gas Collection and Control Services (Value: $45,000); Department: 168 Solid Waste;
Fund: Solid Waste; Account Classification: 81 Capital Improvements

Dan Kooken, Purchasing Manager
Castings Purchase for the 2016 Street Paving Program (Value: $57,536)
Department: 169 Wastewater; Fund: Wastewater; Activity: Sewer Structures

UNFINISHED BUSINESS — None

NEW BUSINESS — None

DISCUSSION

RECORD OF EXPENDITURES
PUBLIC COMMENT
NON-PUBLIC SESSION

ADJOURNMENT

THE CITY OF NASHUA The Gas Cis

Financial Services

Purchasing Department

May 26, 2016
Memo #16-147

TO: MAYOR JIM DONCHESS
FINANCE COMMITTEE

SUBJECT: FINANCIAL (LAWSON/KRONOS ERP) SYSTEM CONSULTING SERVICES
CONTRACT (VALUE: NTE $90,000)
DEPARTMENT: 122 INFORMATION TECHNOLOGY; FUND: CAPITAL PROJECTS —
TECHNOLOGY; ACTIVITY DESCRIPTION: “NGIN” ERP SYSTEM

By way of background, the City of Nashua implemented the Lawson Software suite of financial
applications as part of its ERP Project. The FINPRO (Financial and Procurement) modules were
implemented and went live during April 2012. FINPRO includes modules such as general ledger,
accounts payable, requisitions, purchase orders and cash book. In January 2013, the HCM (Human
Capital Management) modules were implemented and went live. HCM modules include payroll, benefits
and human resources. During 2013, the Kronos timekeeping was also implemented.

As discussed by the Human Resources Director Larry Budreau during the FY2017 Proposed Budget
Hearing on May 18, 2016, the Payroll Manager will be retiring in July 2016. This retirement has created
the need to more fully document the current payroll processes and work flow in advance of hiring a new
Payroll Manager. In addition, as the Human Resources and Benefits staff have completely turned over
during the past year, Lawson and Kronos training is required.

The City has contacted professional services companies that specialize in Infor/Lawson and Kronos
implementation and training. As of the date of this communication, interviews with prospective
consultants are still taking place. It is our expectation that a consultant will be chosen early next week
and in advance of the Finance Committee June 1, 2016 meeting. Once the consultant is chosen, a scope
of services, fee schedule and timeline will be created.

The Director of Human Resources, Director of Information Technology, Accounting Manager and Chief
Financial Officer are participating in the interview process. Their plans call for providing additional
information to the Finance Committee next week.
Respecttully,
CO Un. JA Ute
an Kooken

Purchasing Manager

Cc: L. Budreau J. Griffin

229 Main Street » Nashua, New Hampshire 03061 © Phone (603) 589-3330 e Fax (603) 589-3344

THE CITY OF NASHUA eee

Financial Services

Purchasing Department

May 12, 2016
Memo #16-139

TO: MAYOR DONCHESS
FINANCE COMMITTEE

SUBJECT: CONTRACT AWARD TO PURCHASE A RISKMASTER UPGRADE FOR THE RISK
DEPARTMENT (VALUE: $42,975)
DEPARTMENT: INFORMATION TECHNOLOGY; FUND: BOND NGIN PROJECT
ACCOUNT CLASSIFICATION: 81 CAPITAL IMPROVEMENTS

Please see attached communication from Bruce Codagnone, CIO/IT Division Director dated May 4, 2016
for the information related to this contract award.

This purchase is being made pursuant to NRO § 5-84 (A) (4), Sole-source procurements, where the
proposed purchase is manufactured by only one company.

The CIO/IT Division Director and the Purchasing Department recommend awarding the contract to
CSC, of Falls Church, VA in an amount of $42,975.

Respectfully,

Aen le
Dan Kooken
Purchasing Manager

Co: B Codagnone J Graziano

229 Main Street » Nashua, New Hampshire 03061 © Phone (603) 589-3330 » Fax (603) 589-3344

. THE CITY OF NASHUA hee ca

Information Technology Diviston

To: John Griffin
From: Bruce Codagnone
Date: May 04, 2016

Re: RiskMaster Upgrade — NGIN Project

The City’s Risk Management department uses an application called “RiskMaster” for
the operation of their department. The version currently installed is no longer
supported by the vendor and only runs on an unsupported version of the Microsoft
operating system. Our maintenance contract allows us to get the new version free;
however, due to the complex nature of this client server application, we need the
assistance of the vendor to perform the upgrade. This purchase request covers the
services to perform the upgrade and end-user training in the new version.

In addition to the RiskMaster Application, the City needs to purchase a new reporting
tool. The second portion of this purchase is for the reporting tool license and

configuration, and the required end-user training.

Regards,

Bruce R. Codagnone
ClO / IT Division Director

229 Main Street * Nashua, New Hampshire 03060 * Phone (603) 589-3300 » Fax {603} 594-3434

b

OAKERY

ee

SECTION 3 PROPOSED WORK PLAN

BUSINESS SOLUTIONS
TECHNOLOGY
OUTSOURCING

eee rene
FAA ESN?

March 15 , 2016

CSC:
Behe Wilson Blvd.
Blythewood, sc Tey ; :
Kat y Rhodes, Advisor is re Applications Sales

©2016 CSC
Falis Church, Virginia

Statement of Purpose and Use

Information contained in this document is intended solely to provide information
necessary for the recipient to become acquainted with CSC’s Financial Services
Groups’ products and services and does not constitute the definitive statement
of system capabilities (which is contained in the documentation to the system).
Under no circumstances shall any information contained in this document be
deemed to be incorporated into any contract or legal agreement without the
express written consent of an officer of CSC’s Financial Services Group.

In consideration of receipt of this document, the recipient agrees to maintain
such information in confidence and to not reproduce or otherwise disclose this
information to any person other than those employees of the recipient directly

responsible for evaluation of its contents.

However, there is no obligation to maintain the confidentiality of any information
which was rightfully known to the recipient prior to receipt of such information
from CSC, becomes publicly known through no fault of recipient, or is received
by recipient from a third party not under obligation to keep such information
confidential.

All pricing and conditions in this document are valid for 30 days unless
extended in writing. All prices are quoted in U.S. dollars unless specifically
Stated otherwise.

All rights reserved. No part of this publication may be reproduced by any means without written
permission from CSC.

Printed in the U.S.A.
All questions regarding this proposal should be routed through:
Contact:

Kathy Rhodes, Advisor Software Applications Sales
Phone: 803.422.8636

Email: krhodes6@csc.com

City of Nashua
Jennifer Deshaies
Risk Manager

229 Main St
Nashua, NH 03060

Dear Bruce/Jennifer,

CSC appreciates the opportunity to present to you our special pricing proposal to City of Nashua
for an upgrade to RISKMASTER Accelerator and for the Business Analytics reporting module
which will allow you much more flexibility in reporting and drilling into your data.

CSC is excited about this opportunity to expand our partnership with The City of Nashua. Please
do not hesitate to contact me with any questions you may have after reviewing the attached
proposal.

Sincerely,

Kathy Rhodes

Advisor, Software Applications Sales
10301 Wilson Blvd.

Blythewood, SC 29016

803.422 8636

Krhodes6@csc.com

it

RISKMASTER ACCELERATOR

RISKMASTER® Accelerator is integrated browser-based software that consolidates multiple business
functions into one cohesive solution to provide accurate, up-to-date data. It offers multicurrency processing,
automatically converting financial amounts to your preferred currencies. And it also provides out-of-the box
support for multiple languages. The system helps you gain the knowledge you need to take
advantage of opportunities and mitigate future losses. It also improves your efficiency and
effectiveness and gives you the flexibility to implement best practices and simplify workflow
across the enterprise.

Why Upgrade?

e RMA is 100% web-based. All users will need is internet access from any location.

e Maintenance from an IT perspective is much easier to manage.

e New powerviews will allow users to customize their screens and users will also have the
ability to move supplemental fields onto their core screens.

e There are numerous enhancements to diaries and notes.

e Microsoft Outlook integration.

e Removes the risk of the operating system hot patch which could potentially crash your
system.

e Enhanced/modern reporting capabilities-full web-based reporting

« No major enhancements or bug fixes for older versions.

Business Analytics Module

RISKMASTER Business Analytics uses SAP Business Objects to access and report on the
information stored in your RISKMASTER database. Business Objects is an integrated query,
reporting and analytical tool that enables you to access data, format it and deliver it as
information inside and outside your organization. Business Analytics enables interactive access
to claims and loss reports and database information, as well as other business information. You
can use Business Analytics’ drag-and-drop capability to easily create and format reports. Based
on your specific needs, you can also customize the simple, organized workspace. Use Business
Analytics with Web Intelligence (WEBI) for browser access to reports, or use the Business
Objects Reporting Module for access in Windows.

Business Objects Power User

A Power User license combines the ability to create new ad-hoc reports using the report
designer tool along with the ability to view, edit and schedule existing reports.

se for any

Rat