State of New Hampshire NH State Liquor Commission

State of New Hampshire NH State Liquor Commission Chairman Anthony C. Maiola Comm. John W. Byrne Comm. Patricia T. Russell Agency Information Technology (IT) Plan SFY 2006 -2009 3/19/2018

NHSLC Mission For the benefit of the citizens of New Hampshire, the New Hampshire State Liquor Commission (NHSLC) will optimize profitability by serving customers well and maintain proper controls over the sale, distribution and use of alcoholic beverages. NHSLC 2

NHSLC Overview • Three Bureaus • 322 Authorized Full-Time Positions – 400 to 500 Part-Time and Temps • Locations: – Headquarters – 50 Storrs Street, Concord – Enforcement & Licensing – 8 Commercial Street, Concord – 75 Statewide Retail Sales Stores NHSLC 3

NHSLC Organization Governor & Council Commissioners 5/5 Chief Bureau of Enforcement 32/32 Chief Bureau of Marketing & Sales 251/227 Chief Bureau of Administrative Services 34/34 Store Operations Deputy Chief Administration Financial Management Wine & Spirits Marketing Information Technology Purchasing Human Resources Operations Special Services Warehouse & Transportation NHSLC General Administration 4

NHSLC Structure • Marketing & Sales Bureau – Marketing directs all aspects of the commission's marketing, merchandising, purchasing, store operations, warehousing and transportation, as well as wholesale and direct delivery programs – Manages the 75 New Hampshire Liquor & Wine Outlet stores – Daily interface with 1700 on-premise licensees and 1400 off-premise licensees • Enforcement & Licensing Bureau – Enforce the laws of the State of New Hampshire in a fair and uniform manner – Work towards the elimination of underage drinking thereby reducing the problems associated with underage consumption – Reduce the incidents of over consumption of alcohol and thereby reducing the incidents of drinking and driving – Provide the citizens of our state with prompt and courteous service NHSLC 5

NHSLC Structure • Administrative Services Bureau – Responsible for all general administrative support operations to the Liquor Commission – Responsible for all finance and accounting-related services, credit management, grants management, and financial reporting – Responsible for handling of all personnel related matters to include recruitment, hiring, employee relations, benefits administration, union relations, worker safety, loss prevention and training – Responsible for all automated computer system activity at the NHSLC. Anticipate and plan for system enhancements, install and maintain systems, and oversee their operation at the main office and 75 retail liquor stores. IT interfaces with liquor vendors, warehouses, licensees, banks and other business partners and is responsible for ensuring the accuracy of data, maintaining accurate records and for recovery in error situations NHSLC 6

Strategic Business Issues • Marketing & Sales: – – – NHSLC Electronic filling of supplier price offers Reduce cost and waste of preprinted retail collateral Outdated POS system hardware in retail stores Improve information flow of vendor advance shipping notifications Reduce checkout line wait during peak sales periods Enhance in-store electronic marketing capabilities Expand ability to offer extensive stored value card programs Improve and increase training of store personnel Public and staff safety via observation Reduce shrinkage in retail stores via observation Eliminate need for clerk to leave their registers to process lottery ticket requests 7

Strategic Business Issues • Enforcement & Licensing: – – – Remote access for field personnel to move license and arrest data to HQ Need to extract arrest information for NNEPAC Space for paper storage of license information is limited. Retrieval of a licensee’s paper file is time consuming and error prone Want to issue new liquor licenses in the field • Administrative Services: – Space for paper storage of financial and other archived information is limited – Retrieval of a paper files is time consuming – Too much time spent on phone with licensees regarding their accounts – Difficulty in providing training to decentralized locations NHSLC 8

Agency IT Architecture • Hardware Platform(s) – 115 PC Servers, mostly Dell – – 335 PC Desktops, mostly Dell– – 87 Dell Laptops • Operating System(s) – Windows 2000 on HQ servers – – Windows NT 4 on store servers – – Windows XP on HQ desktops and some laptops– – Windows NT 4 on store lanes and some laptops– • Software Development Environment – – Unisys BIS – – Microfocus Cobol – – MS. NET (VB) – – MS WSH – MKS KORN – • Database(s) – – Unisys BIS – – MS SQL Server – • Print / File Platform(s) – – Windows 2000 – • Email Platform – – MS Exchange – NHSLC 9

Current Production Systems • 6 Business Applications – 0 Supported by Agency – 2 Supported by OIT – 2 Outsourced § ACR Systems § Software Automation – 2 Commercial Off-The-Shelf Application(s) NHSLC 10

Summary of System Overview • LIDS – Liquor Inventory and Distribution – Tracks all product through the Liquor Commission from purchasing to sale. • WIMS – Warehouse Inventory Management – Maintain inventory, billing and order processing • ACR 2000 – Point of Sale – POS system used at the stores for cash register functionality • License 2000 - Licensing – Licensing system for all liquor licenses. This is shared other agencies and managed by OIT’s WSD • Masterpiece – Financial Management – GL, AR, AP and FA • PMS – Police Management System – Arrest and violation tracking and reporting NHSLC 11

IT Projects Summary • 16 Projects – 7 Active Projects (Funded & Active) – 6 Pending Projects (Funded & Not Active) – 4 Future Projects (Not Funded & Not Active) NHSLC 12

Active IT Projects (Funded & Active) • Disaster Recovery – Complete testing of hot site – Implement Business Recovery Plan • Price filings – Web enable supplier price offers • Store collateral printing – Method to print marketing material (shelf labels, shelf talkers, signage) specific to the store • Advanced Shipping Notice – Web enable • License 2000 – final phase – Web enable renewals – Allow field inspections NHSLC 13

Active IT Projects (Funded & Active) con’t’d • • • NHSLC IP Renumbering – Change network addresses so that Liquor can be included natively in the State’s network for improved security and management Homeland Security – Product lot tracking for identification and retrieval of tainted product lots Video monitoring – Address public safety and shrinkage issues – Possibly assist in remote training Remote training – Provide tools to create and distribute training Register Lottery Sales – Add ability to sell on-line lottery tickets directly at or from the register 14

Pending IT Projects (Funded & Not Active) • POS Hardware replacement – Replace all store servers, desktops, scanners, printers, etc. – WAN Enhancement • Increase bandwidth to address remote access, video observation and remote training issues • Line buster – Have POS software vendor utilize the HHP Dolphins for pre-sales • Enhanced stored value card offers – Add more brand specific capabilities and expand the number of concurrent promotions • Electronic merchandising – Utilize the terminal display and customer display for merchandising • Licensee Account Access – Web enable licensee access to their account information to reduce their need to call • Coupon Tracking – Automate billing to suppliers for coupon use • PMS Interfaces – Extract license activity for interface to License 2000 – Extract activity for NNEPAC statistics NHSLC 15

Future IT Projects (Not Funded & Not Active) • Enterprise Content Management – Electronic filing and retrieval of paper work – Workflow NHSLC 16

Major Projects Requiring Project Concept Document Project Name Date Agency Priority / Expected Start POS Hardware Replacement (create RFP, December release) (Installation) 1 September 2005 April 2006 Video monitoring Remote training Register Lottery Sales Enterprise Content Management NHSLC 17

Attachments • Project Concept Documents (PCD) • System Overviews NHSLC 18