State of New Hampshire NH State Liquor Commission

1
State of New HampshireNH State Liquor Commission

• Chairman Anthony C. Maiola
• Comm. John W. Byrne
• Comm. Patricia T. Russell
• Agency Information Technology (IT) Plan
• SFY 2006-2009

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.

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

4
NHSLC Organization
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
•  
•  
•  

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
•  
•  
•  

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

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 licensees 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

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)

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)

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 OITs WSD
• Masterpiece Financial Management
• GL, AR, AP and FA
• PMS Police Management System
• Arrest and violation tracking and reporting

12
IT Projects Summary

• 16 Projects
• 7 Active Projects (Funded Active)
• 6 Pending Projects (Funded Not Active)
• 4 Future Projects (Not Funded Not Active)

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

14
Active IT Projects (Funded Active) contd

• IP Renumbering
• Change network addresses so that Liquor can be
  included natively in the States 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

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

16
Future IT Projects (Not Funded Not Active)

• Enterprise Content Management
• Electronic filing and retrieval of paper work
• Workflow

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

18
Attachments

• Project Concept Documents (PCD)
• System Overviews