Attachment 7 (Draft OLCC OIS Services Accomplishments .docx) INFORMATION ONLY.docx

This document is a draft accomplishments report for the Oregon Liquor & Cannabis Commission (OLCC) Office of Information Services covering the 2022-2024 period, detailing technology modernization initiatives and service improvements across the agency. The report outlines significant projects including the CAMP (Comprehensive Application Modernization Project) system implementation across three phases—Marijuana Licensing, Liquor Licensing, and Permits—with associated stakeholder demonstrations and fit/gap analysis sessions conducted throughout 2023. Additional initiatives encompassed infrastructure upgrades such as SPLUNK cloud migration, SharePoint implementation, server upgrades to Server 2019, and various hardware refresh cycles including laptops (November 2022-present), iPhones (2023), and multi-function printers (September 2023). Business application enhancements included VICE implementation for spirits pricing (2021-2022), Tracer Plus upgrades for liquor auditors (2023), OPTO phase implementations for wineries and bonded wine warehouses, and migration of over 1,200 Business Objects reports to Tableau with corresponding automated data preparation flows. The report also documents organizational change management assessments, Adobe Acrobat Enterprise licensing deployment (February 2023), email multi-factor authentication implementation (November 2022), and legacy web application rewrites to eliminate Flash dependencies.

The accomplishments report emphasizes operational efficiencies and cost reductions achieved through modernization efforts, including adoption of Spiceworks ticketing system (December 2022), Microsoft 365 implementation with Deloitte procurement support to eliminate redundant tenants, improved helpdesk processes with appointment scheduling and automated personnel action forms (November 2023), and physical resource optimization through cloud migrations and server repurposing. Notable cost-saving measures included evaluation of T-Mobile cellular services for hotspot deployments (January 2023), though the state determined rural coverage inadequacies precluded contract switching. The document identifies key financial and operational benefits such as paper reduction through online Tableau reporting for special events and local government licensing, enhanced customer service delivery, improved process management, and better internal IT resource allocation through automated workflows and centralized software repository documentation established in March 2023.