State of New Hampshire NH State Liquor Commission

heavyweightuttermostMechanics

Nov 5, 2013 (3 years and 10 months ago)

63 views

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


NHSLC

2

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

3

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

4

NHSLC Organization


Governor & Council




Commissioners

5/5


Chief

Bureau of Enforcement

32/32


Chief

Bureau of Administrative Services

34/34

Chief

Bureau of Marketing & Sales

251/227

Deputy Chief

Administration

Operations

Special Services

Store Operations


Wine & Spirits Marketing

Purchasing

Warehouse & Transportation


Financial Management

Information Technology

Human Resources

General Administration

NHSLC

5

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

6

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

7

Strategic Business Issues


Marketing & Sales:


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



NHSLC

8

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

9

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

10

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

11

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


ACR2000


Point of Sale


POS system used at the stores for cash register
functionality


License2000
-

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

12

IT Projects Summary



16 Projects


7
Active Projects


(Funded & Active)


6
Pending Projects (Funded & Not

Active)


4
Future Projects (Not Funded & Not

Active)



NHSLC

13

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

14

Active IT Projects (
Funded & Active) con’t’d


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


NHSLC

15

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 License2000


Extract activity for NNEPAC statistics

NHSLC

16

Future IT Projects (
Not Funded & Not Active)


Enterprise Content Management


Electronic filing and retrieval of paper work


Workflow



NHSLC

17

Major Projects Requiring Project Concept
Document

Project Name



Agency Priority / Expected Start
Date

POS Hardware Replacement


1



(create RFP, December release)



September 2005


(Installation)





April 2006


Video monitoring

Remote training

Register Lottery Sales

Enterprise Content Management


NHSLC

18

Attachments


Project Concept Documents (PCD)


System Overviews