Loading...
HomeMy WebLinkAbout2024-08-26-minutes-it-study-sessionCreated on 10/3/2024 9:29:46 AM KITTITAS COUNTY COMMISSIONERS IT Study Session Regular Meeting Monday August 26, 2024 - 11:00 AM BOCC Conference Room 205 West 5th Room 108 - Ellensburg 1. Call to Order 2. Citizen Comments (1 min. time limit) 3. Request to Approve a New GIS Technician Position 4. Discussion: CAMAS Modernization Initiative Plan Introduction 5. Other Business - No Action to be taken 6. Concluded 8/26/24 MINUTES 1 COMMISSIONERS' MINUTES KITTITAS COUNTY, WASHINGTON BOCC CONF. ROOM REGULAR MEETING Monday 11:00 A.M. August 26, 2024 Board members present: Chairman Brett Wachsmith; Vice-Chairman Laura Osiadacz and Commissioner Cory Wright. Others: IT Director Doug Fessler; Assistant IT Director Zane Kinney; Network System Admin Bill Davis; IT Administrative Assistant Grant Shimada Regular Meeting IT STUDY SESSION COMMISSIONERS At 11:00 a.m. Chairman Brett Wachsmith opened the Information Technology Study Session. CITIZEN COMMENTS: There were no citizen comments. DISCUSSION Request to Approve New GIS Position IT Assistant IT Director Zane Kinney requested the approval to change the GIS Coordinator position to GIS Technician due to it’s vacancy for the last couple of years. Unfortunately, the IT department has been unsuccessful in filling this seat which has left a gap for GIS support. GIS software developer, Esri, will be pushing out a large update that the IT department will need professional support in implementing from our contracted consultant, Pro-West Association. Mr. Kinney warned the Board that this need for support will lead to an increased price with Pro-West. Commissioner Wright informed Mr. Kinney that other departments have been thinking of hiring their own FT GIS employee and gave advisement to reach out directly to discuss this topic. Chairman Wachsmith moved to approve the request and Commissioner Wright seconded; 2:0. DISCUSSION Executive Session IT Commissioner Wright called for an Executive Session for 5 minutes pursuant to RCW 42.30.110(G) at 11:08 a.m. The Executive Session concluded at 11:13 a.m. 8/26/24 MINUTES 2 DISCUSSION CAMAS Modernization Initiative Plan IT Assistant Director Zane Kinney brought to the Commissioners’ attention his idea to create an intranet advisory committee with plans to revitalize the County’s intranet. Commissioner Wright asked how members of this advisory committee would be selected and was given reassurance that members with a diverse mindset from department “families” who have been big contributors with subject expertise would be selected. Zane reassured the BoCC that most of the features on the intranet are outdated and unused today so removal wouldn’t cause any disruption for the County. This topic will be brought to the Central Services Committee for analysis and advisement with next steps being to finalize the resolution and charter that’ll be presented to the Management Team. DISCUSSION Other Business IT Assistant Director Kinney updated the commissioners on the progress of the code publishing services that were acquired earlier in the summer. Currently the 3rd party company, General Code, is working on coding the County’s laws and ordinances onto their platform with expectations of completion sometime in the next 6 months. MEETING CONCLUSION COMMISSIONERS At 11:37 a.m., Chairman Wachsmith concluded the Information Technology Study Session. KITTITAS COUNTY COMMISSIONERS INFORMATION TECHNOLOGY DIRECTOR KITTITAS COUNTY, WASHINGTON ________________________________ ________________________________ Doug Fessler, IT Director Brett Wachsmith, Chairman Page 1 of 2 Information Technology “Study Session Staff Report”, 8/26/24 KITTITAS COUNTY BOARD OF COUNTY COMMISSIONERS STAFF REPORT FOR STUDY SESSION Information Technology STUDY SESSION DATE: 8/26/24 TOPIC: Request to Approve IT Staffing Change ACTION REQUESTED: Board Approval LEAD STAFF: Zane Kinney RECOMMENDATION: IT Department is recommending that the Board approve removing the position of GIS Coordinator and adding the position of GIS Technician. BRIEFING SUMMARY: • GIS is currently staffed by Jesse Potts, GIS Analyst at .5 FTE, with Assistant Director, Zane Kinney, providing coordination and assistance with system administration and support to County staff interacting with GIS. • Pro West GIS is providing contracted services • Since the vacancy of the GIS Coordinator position, IT has struggled to maintain an optimum level of service to the County. • A mandatory migration from ArcGIS Enterprise 10.X to ArcGIS Enterprise 11.X will occur soon that is expected to be an extensive amount of work. BACKGROUND: The position of GIS Coordinator was vacated in Q3 of 2022. That position was previously filled by a highly skilled, knowledgeable and experienced individual in the administration of the ArcGIS environment, software engineering, and geospatial data engineering. A decision was made by IT not to immediately attempt to fill that position. That decision was made based on the perceived limited applicant pool and IT lacked sufficient understanding of position’s highly technical and specialized responsibilities. DISCUSSION: IT concludes that filling the GIS coordinator is unnecessary. Management, coordination, and oversight of the GIS program can be performed by current IT leadership, primarily the Assistant Director. ArcGIS software platforms have improved, allowing for solution creation with less need for highly customized application development. Moving to the Page 2 of 2 Information Technology “Study Session Staff Report”, 8/26/24 GIS Technician would give the county the needed staffing support to accomplish the routine tasks required to provide the variety of services essential to GIS stakeholders throughout the organization. This position will also be able to assist in the engineering and maintenance of ArcGIS low-code solutions. IT has established a business relationship with Pro-West Associates and wishes to continue to leverage their expertise during the migration process to version 11.X of the ArcGIS Enterprise Suite and, to a more limited extent in the future, leverage an escalation path for troubleshooting and solution engineering projects. This will allow IT to be flexible and scale our use of their services to our needs. The IT department’s goal is to properly staff the GIS program while controlling personnel costs. FISCAL IMPACTS: Finance and HR were consulted. Finance reviewed the below estimated projections. 2024 2025 2026 2027 2028 GIS Coordinator 122,600 Budgeted 128,200 131,700 134,200 138,000 GIS Technician 26,000 (4 months) 88,000 91,300 93,600 95,200 GIS Pro Services 26,000 75,000 7,500 5,000 5,000 ATTACHMENTS: GIS Technician Job Description Draft Kittitas County, Washington Job Description POSITION TITLE: GIS TECHNICIAN ☒ CREATED: 8/01/2024 REPORTS TO: DEPARTMENT: INFORMATION TECHNOLOGY (IT) JOB SUMMARY: The GIS Technician is responsible for supporting the GIS team by performing system maintenance tasks, administering licensing and permissions, troubleshooting issues for GIS content creators and editors, and maintaining and updating the County’s Experience Builder, Dashboard, and Survey 123 solutions. Additionally, this position may assist with mapping duties during wildfire events and other mapping projects. Must maintain courteous and cooperative working relationships with administrative and other County personnel, public agencies, and the general public, and work under the guidance of Local/State/Federal regulations and County policies/procedures. SUPERVISORY DUTIES: None CATEGORY: Full-Time OCCUPATION CODE: xxxx UNION AFFILIATION: None HOURS/WEEK: 40 FLSA STATUS: Non-Exempt DRS ELIGIBILITY: PERS PROBATIONARY PERIOD: 12 months ESSENTIAL FUNCTIONS • Perform regular updates, backups, and maintenance of GIS systems to ensure optimal performance and reliability. • Manage user accounts, permissions, and software licenses for GIS applications. • Troubleshoot and resolve technical issues for GIS content creators and editors, providing timely and effective solutions. • Work on updates and maintenance for Experience Builder, Dashboard, and Survey 123 solutions, ensuring they are up-to-date and functioning correctly. • Maintain accurate records of system configurations, procedures, and troubleshooting steps. • Provide training and support to GIS users to enhance their understanding and utilization of GIS tools and applications. • Review and make routine interpretations of data sources and use basic GIS software functions to enter, edit, and update GIS spatial data, including points, lines, polygons, and attribute data into databases or layers, following standard procedures. • Provide high-quality, timely, and user-friendly geographic information to staff for basic information requests. • Maintain rudimentary knowledge of current GIS methods, applications, and database technologies through professional literature, product research, continuing education, and supervisor-approved conferences and seminars. • Establish and maintain professional relationships with other County departments and outside agencies, such as the Sheriff’s Office, Community Development Services, and KITTCOM in order to provide excellent technical support. OTHER FUNCTIONS • Assist the Emergency Operation Center (EOC) in mapping duties or other functions in the event of an emergency. • Participate in and complete special projects as assigned. • Serve as backup to other staff performing GIS functions as needed. • Work closely with other IT staff to support the overall goals and objectives of the department and the County. This job description is a summary of the primary functions and expectations for this position. Additional department- related duties may be assigned as required. MINIMUM QUALIFICATIONS • High School Diploma or GED. • At least three (3) years of experience providing technology and/or GIS support to a wide variety of users. • College courses in GIS or Information Technology may substitute for some of the experience requirements listed above. • Valid and active Washington State driver’s license. • A criminal history and background check will be performed on qualified applicants. Convictions may preclude candidates from employment in certain circumstances. Factors such as relativity to the position, age and time of the offense, seriousness and nature of the violation, and rehabilitation will be taken into account. REQUIRED KNOWLEDGE/SKILLS/ABILITIES • Familiarity with GIS software and tools, such as ArcGIS, Experience Building, Dashboard, and Survey 123. • Proficient computer skills, including Microsoft Office programs, system maintenance and troubleshooting, and ability to quickly learn other programs specific to the position/department. • Understanding of licensing and permissions management for software applications. • Ability to assist in emergency mapping duties and geospatial analysis. • Strong problem-solving skills and analytical skills. • Maintain professionalism, friendly manner and patient communication, even in stressful situations. • Ability to work independently and as part of a team. • Strong organizational skills and attention to detail. • Ability to maintain confidentiality. PREFERRED QUALIFICATIONS • Bachelor’s Degree in GIS, Geography, Information Technology, or related field. • Knowledge of basic GIS concepts and principles. • Experience training or supporting end-users. • Experience with emergency mapping and geospatial analysis. • Previous work experience in the public sector. WORKING CONDITIONS Work is generally performed in an office environment with potential exposure to dusty conditions. Sustained posture in a seated position and prolonged periods of computer operation; use of standard office equipment; strength to lift, pull, push and/or carry up to 25 pounds (possibly more with assistance); vision to read printed materials, a computer screen, and allow installation of equipment in all lighting conditions; and hearing and speech to communicate clearly in person or over the telephone. Must be able to reach with arms, grasp, sit, kneel, stoop, bend, squat, twist, crawl under office furniture, climb a ladder and stairs. Safety rules and regulations must be adhered to at all times. Travel throughout the County is required to attend meetings and assist GIS users, with occasional travel outside of the County to attend training opportunities. Must have the ability to safely operate a motor vehicle in all types of weather and all levels of light. Regular and reliable attendance and punctuality are required and expected during regular business hours; however, extended or weekend hours may be required on occasion. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. PREPARED AND REVIEWED BY Must be completed with all revisions of the job description. Supervisor Name Title Date HR Representative Name Title Date EMPLOYEE ACKNOWLEDGEMENT I understand the job duties and responsibilities contained in this job description and as described by the immediate supervisor. Employee Name (print) Employee Signature Date Page 1 of 2 Information Technology “Study Session Staff Report”, 8/26/24 KITTITAS COUNTY BOARD OF COUNTY COMMISSIONERS STAFF REPORT FOR STUDY SESSION Information Technology STUDY SESSION DATE: 8/26/24 TOPIC: Discussion of the Intranet Modernization Initiative ACTION REQUESTED: No Action - Information Only LEAD STAFF: Zane Kinney RECOMMENDATION: IT is asking the Board to approve a resolution to acknowledge the formation of the Intranet Advisory Committee This agenda item also introduces the draft of a plan for the redevelopment of the County’s intranet site. BRIEFING SUMMARY: The process of removing functionality from CAMAS has already begun. • Business decisions or security and performance of the current feature is compromised to the point that immediate replacement is required. • Reshaping our intranet without a plan risks replacing CAMAS with something we don't want or need. • IT strongly believes that involvement by a representative group of stakeholders, who will advise us in developing a new intranet site, is vitally important. BACKGROUND: In 2023 the Board directed IT to work on modernizing CAMAS. Since then, Assistant Director Zane Kinney, has been assessing the current state of the application, taking an inventory of the tools present, and developing a plan for migrating to a new intranet solution. DISCUSSION: The Intranet Advisory Committee would provide the IT department with invaluable insight to stakeholder requirements. A small, but diverse and engaged group could provide: • Needs Assessment • Design and User Experience Input Page 2 of 2 Information Technology “Study Session Staff Report”, 8/26/24 • Feature Recommendations • A Feedback Mechanism • Adoption and Training FISCAL IMPACTS: None ATTACHMENTS: Intranet Information Packet and Resolution Draft Intranet Modernization Initiative Plan Introductfon What is CAMAS? Typically, an organizatfon's intranet is responsible for the following: Internal Communication: News, announcements, and updates. Document Management: Storage and access to company documents, policies, and procedures. Collaboration Tools: Forums, chat systems, and project management tools. Employee Directory: Contact informatfon and organizatfonal structure. Training and Development: Access to training materials and business process documentatfon. CAMAS is responsible for doing more than this while also not performing some of the functfonality listed above. Constructfon of CAMAS, in its current state, began approximately 17 years ago, and the scope of business processes the web applicatfon performs grew over tfme with more being added to this day. Major functfonality of CAMAS includes: Financial Management Meetfng Management Service Request System HR Recruitment, Onboarding, and Employee Management Asset Management System Building Planning Management Health Inspectfon Management Internal Applicatfon Authorizatfon Various Public Website Administratfon Features These are the major features of CAMAS with over 60 minor features that assist county employees with general business tasks as well as very niche specific assignments to their department or office. The level that CAMAS has served the county is a testament to the team of 1 to 2 developers who engineered it and contfnue to maintain and update it. When the project began, software solutfons for the County's needs either didn't exist or were considered too expensive to purchase. What should CAMAS be? The process of removing functfonality from CAMAS has already begun. Not because it's part of this plan but because we already see the advantage of moving some features to more modern, commercial off-the-shelf software. Business decisions or security and performance of the current feature is compromised to the point that immediate replacement is required. However, contfnuing to reshape our intranet without a plan will eventually risk replacing CAMAS with something we don't want or need. IT strongly believes that involvement by a representatfve group of stakeholders, actfng to advise us in developing a new intranet site is vitally important. Intranet Advisory Committee Concept Purpose: The Intranet Advisory Committee (IAC) is established to provide guidance, recommendatfons, and insights to the IT department regarding the purpose, design, and functfonality of the organizatfon’s future intranet site. The committee will ensure that the intranet meets the diverse needs of all departments, enhances communicatfon, and improves overall efficiency and user experience. Objectives: 1. Needs Assessment: Identffy and document the needs and expectatfons of various departments and staff members regarding the intranet. 2. Design Input: Provide recommendatfons on the design, structure, and user interface of the intranet to ensure it is user-friendly and effectfve. 3. Feature Recommendations: Suggest features and functfonalitfes that should be included to enhance productfvity and collaboratfon. 4. Feedback Mechanism: Establish a process for ongoing feedback from staff to contfnuously improve the intranet. 5. Adoption and Training: Develop strategies to promote intranet adoptfon and provide training resources to staff. Why is modernizing the County's intranet necessary? CAMAS is built on an aging applicatfon framework which offers many challenges to our organizatfon. • Performance Issues: The existfng ASP.NET applicatfon targetfng .NET 4.7 may suffer from slower load tfmes and less optfmized performance, negatfvely impactfng the user experience. • Security Vulnerabilities: Older platiorms like .NET 4.7 may not receive regular security updates, leaving the intranet site more susceptfble to cyberattacks and security breaches. • Maintenance Challenges: Maintaining and updatfng a legacy system can be more complex and tfme-consuming, as it may lack the support and resources available for newer technologies. • Developer Productivity: The outdated tech stack may hinder developer productfvity due to less efficient tooling, limited libraries, and outdated development practfces. Integration Difficulties: Integratfng the current intranet site with modern tools and services can be challenging, limitfng the functfonality and effectfveness of the applicatfon. • User Experience Constraints: The older framework may not support dynamic and responsive web design as effectfvely, leading to a subpar user experience. • Future Risks: Contfnuing to rely on an outdated technology stack risks the applicatfon becoming increasingly irrelevant and unable to adapt to future technological advancements and business needs. Monolith to Individual Services & Microservices CAMAS is currently built as a monolithic web applicatfon. Meaning all features and services interface through on single applicatfon and are supported by one business class library. We desire to break this apart into individual applicatfons that each serve a single purpose. Likewise, sole-purpose DLLs will be built for logic and business needs. Advantages to the sole-purpose architecture 1. Decomposition: The applicatfon is decomposed into multfple services, each focusing on a specific business capability. Features like purchasing, HR workflows, recruitment, etc., would be separate services. 2. Independence: Services are developed, deployed, and maintained independently. This allows for flexibility in choosing different technologies and languages for each service, if they can communicate through APIs. 3. Scalability: You can scale individual services independently based on their specific resource needs, improving efficiency and cost-effectfveness. 4. Isolation: Services are loosely coupled, which means changes or issues in one service are less likely to impact others. This makes maintenance and troubleshootfng easier. 5. Deployment Flexibility: Updates or new features can be rolled out for specific services without affectfng the entfre applicatfon. 6. Resilience: Failure in one service doesn't necessarily bring down the entfre applicatfon since other services can contfnue to functfon. Strategic Prioritfes Our focus is on enhancing efficiency, scalability, and user experience. To achieve this, we have identffied three key strategic prioritfes: 1. Replace Major Features with Commercial Off-the-Shelf (COTS) Software: Our priority is to transitfon significant features of the intranet to reliable, industry standard COTS solutfons. This approach will ensure cost-effectfve implementatfon, regular updates, robust security, and enhanced functfonality. 2. Develop Features with Low-Code/No-Code Development Software: For features that require customizatfon but do not necessitate full-scale development, we will leverage low-code and no-code platiorms. This strategy will accelerate development, reduce costs, and empower our team to quickly adapt and innovate. 3. Custom Applications Using Modern Coding Frameworks: Where specific organizatfonal needs cannot be met by COTS or low-code/no-code solutfons, we will develop custom applicatfons. Utflizing modern coding frameworks and robust platiorms, we aim to build scalable, secure, and high-performance applicatfons tailored to our unique requirements. 4. Use RESTful Web APIs for Data Access: Any custom applicatfons and integratfons will make use of Web APIs for data access, when appropriate. This approach will allow us the flexibility to host the intranet outside of our network if we so desire while keeping our data inside of our network. Component & Feature List This matrix is meant as an executfve level overview. Module/Feature Replacement Plan Status Blocked By Admission Tax Returns Undecided Not started Agency Contacts New Intranet Not started Agenderator New App - COTS or custom Early planning Alert System Manager Public Web CMS Not started Bankruptcy Tracker Undecided Not started BoCC Boards Management Unclear - New Intranet/Public Web CMS Not started BOE Petition Tracker None Currently Unused Budget Center None Currently Unused Building Inspections SmartGov/Workforce In process Business Numbers New Intranet or Cayenta? Not started Check Register Cayenta In process Cayenta Upgrade Claims for Reduction Undecided Not started Contracts Tracker Undecided Not Started County Forms Directory New Intranet Not started County Holidays New Intranet/Public Web CMS Not started Court Calendars Undecided Not started Courts: Laserfiche Lookup table admin LF Forms/WF Not started Credit Card Logger Cayenta In process Cayenta Upgrade Department Info Admin New Intranet Site Not started Departmental Pages New Intranet site Not started Destruction Log Undecided Not started Device Authorization JItbit and/or LF Forms? Not started EH Inspections (Macchiato) SmartGov Unsure, being managed by PH Elections Administration Undecided Not started Electronic Mitigation/Contested Hearing Odyssey/Laserfiche Not started Email Notification System Undecided Not started Evacuation Checklist New Intranet Not started Export Notice Undecided Not started FAQ's Administration Public Website CMS Admin site Not started FATS Asset Panda Purchased. Configuratfon FRANC New COTS app Unknown Fugitive/Most wanted Public Website CMS Admin site Not started GL District Sync Undecided Not started Hazardous Waste Disposal Laserfiche Forms/WF Not started Health Complaints Management Laserfiche Forms/WF Not started HR Onboarding NeoGov/Laserfiche In process HR Portal NeoGov/Laserfiche In process LiFT Liquidfiles In process Manage Docket Codes Laserfiche Not started Merit Increase Calculator Unknown if needed Not started Motorpool New App Planning MultiPass EntraID Planning Notes (Viper) Undecided Not started Overtime Board Undecided Not started PAS (Paperless Agenda System) New App, COTS or custom Not started Pay Stub Importer/Viewer Cayenta Not started Cayenta Upgrade PDP (Evaluations) NeoGov Purchased HR Portal to NeoGov PH: Program Reporting Undecided Not started Preliminary Site Analysis Undecided Not started Press Release Manager Undecided Not started Project Bid Documents Management Undecided Not started Public Notices Manager Undecided Not started Publish GL Report Cayenta Not Started Cayenta Upgrade Purchasing Portal Cayenta Not started Cayenta Upgrade Road Names Management Undecided Not started Security Incident Report LF Forms/WF Not started Service/Work Request System Jitbit In process Spotlight Undecided Not started SSN and Address Verification Laserfiche Forms/Workflow Not started Supervisor Management Undecided Not started Tax Roll Corrections Undecided Not started Training Tracker COTS or discontfnue Not started Transaction Notice Cayenta (plus integratfon?) Not started Cayenta Upgrade Treasurer's Export notice Cayenta (plus integratfon?) Not started Cayenta Upgrade Vouchers Cayenta Not started Cayenta Upgrade Wage Data Comparison Cayenta Not started Cayenta Upgrade Warrant Issue Notice Cayenta Not started Cayenta Upgrade Water Mitigation/Beacon Undecided Not started While you were out Outlook/Retfre Not started Work Orders JitBit Not started Notices New Intranet Site Not started GIS Data Governance manager Undecided Not started Known Challenges CAMAS and the public website interdependency Primarily, CAMAS and the public website were built concurrently and dependent on one another. CAMAS acts as an administratfon and support system for delivering content to the website. Conversely the public website is the public interface for many business processes which are currently administered in CAMAS. Sponsor and stakeholder availability Replacing or rebuilding the features of CAMAS will require input from and collaboratfon between IT, sponsors, and stakeholders involved. Scheduling meetfngs to plan, interview SMEs, configure, and test solutfons will inevitably be complex and create delays in productfon. Draft Timeline 2024 Q3 & Q4 Establish Intranet Advisory Committee (IAC) IAC to review and possibly edit this document IAC to create a "Blueprint and Vision" document for the new intranet site Strategize plan for decoupling CAMAS and the Public Website Establish lead contacts for each feature needing replacement Begin preliminary work on Authentfcatfon and Authorizatfon - Configure Basic AD Groups Build VMs for Dev, Test, and Prod environments Stop all new feature requests for CAMAS, bug fixes only 2025 Q1 Define site architecture Begin work on foundatfonal Class Libraries, Data Access, APIs, etc. Begin UI/UX development Strategize feature replacement order and schedule Finalize decision on intranet site framework, i.e. Blazor, Asp.NET, Umbraco, DevCraft, Syncfusion, etc. 2025 Q2 Contfnue UI/UX development Contfnue work on foundatfonal Class Libraries, Data Access, APIs, etc. Sandbox sites Git repository configuratfon Official dev site launch 2025 Q3 Created 14 May 2024 20:33:51 by Zane Kinney Updated 12 August 2024 23:54:15 by Zane Kinney UI/UX of main intranet site finalized Begin work on feature replacement - Major features in-house developed