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
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
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
Pricing: RISKMASTER Accelerator Upgrade /Business Analytics
Module
Proposal Date: March 15, 2016
Coniracts Executed by: June 11, 2016
Note: ILC, MESA and Services are estimated and are subject to change based on additional
requirements and time of execution of contract.
Pricing Summary for City of Nashua
RISKMASTER World 7.14 to RISKMASTER Accelerator
Implementation
Upgrade 15.3, DA to latest version and MMSEA Template upgrade Services
Implementation | Includes: Estimate:
Service e Installation — 4 days $15,400
e Training -3 days-onsite ($2,310)
e Project Management $13,090
Incentive
Business Intelligence Reporting One-Time
Initial vieense Fee | \nojudes: ae
(ILC) o 5 Named BOE Professional Users $20,000
o Webi/Deski Report Creation
o Crystal Reports Viewer
a Scheduler and Publisher for each user
o 5 Dashboard viewer user licenses
o 1 Dashboard Designer user
Incentive: (5,000)
Total:
$15,000
RISKMASTER Includes: BA Installation and Training Implementation
Accelerator e Installation - 3 days Services
Upgrade and ° Training —3 days- on-site Estimate:
Business e Report Consulting Hours- 15 $15,675
Analytics e Project Management
Implementation
Services ($2,352)
incentive:
$13,323
Total:
Pricing Summary for City of Nashua
Annual MESA
(Maintenance, | SuPPort Includes: Additional
Enhancements, & Annual MESA
‘ or” e Unlimited Telephone Support
Services Availability e Enhancement Releases $5,000
e Upgrades and Services Packs
Incentive:
Total: $ 3,750
Assumptions/Requirements:
1. The above requires that Customer (a) currently utilizes RM World and (b) meets all the
criteria for the upgrade outlined on attached spec document, including but not limited to
hardware setup.
2. The above does not include any custom scripting. Customers with web forms or custom
work will be expected to validate the code in a test environment where RISKMASTER X
is installed. If the web forms or custom work must be enhanced or re-written, CSC can
assist subject to a separate work order at a mutually agreed hourly rate.
3. Installation will be conducted remotely. Training will be conducted onsite unless client
prefers webex. Additional travel costs will apply for onsite training.
4. Should additional training be needed/desired for MMSEA/DA, a PCR project change
control can be issued for the additional hours.
BI- Assumptions:
4. The quote provided assumes installation for two environments. !f additional
environments need to be installed additional days would need to be quoted.
2. Creation of check stock is 1.5 hours per check stock. This includes creation, deployment
and testing. This is optional service and not included in the above packages.
e Installation Services are quoted to support the installation onto one client
environment/server, i.e., Production, Test, User Acceptance, etc. If multiple
environments/servers are required for installation, then additional services will be
required.
e Customer is not utilizing Business Entity Security (BES).
e Dashboard training participants have at least an intermediate knowledge of Microsoft
Excel. Advanced knowledge of Excel is nreferable. The training will not instruct
participants on Microsoft Excel.
e Additional/Optional Report Consulting hours listed can be used for Business Intelligence
Consultancy and customer report creation
* Client is responsible for converting all Sortmaster reports or using the optional consulting
hours for CSC to provide assistance. If additional hours are needed a PCR (Project
