Loading...
HomeMy WebLinkAboutGCS_City_of_Bozeman_RFPRESPONSE TO CITY OF BOZEMANGIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK 01.15.2021 2 GCS GCS | CITY OF BOZEMAN RFP RESPONSE | CONTENTS CONTENTS EXECUTIVE SUMMARY 3 FIRM PROFILE 4 PROPOSED SOLUTION 5 SCOPE OF PROJECT 6 RELATED EXPERIENCE 7 STATEMENT OF QUALIFICATIONS 12 REFERENCES 21 PRESENT AND PROJECTED WORKLOADS 27 KEY PERSONNEL 28 COST PROPOSAL 47 GCS GCS | CITY OF BOZEMAN RFP RESPONSE | ExECuTIvE SuMMARY EXECUTIVE SUMMARY 3 Point of Contact and Company Address Michael Beltz, President GCS 115 S. 4th St. W. Missoula, MT 59801 USA Office:406-747-8393 Mobile: 406-546-7240 Email: mbeltz@yourdatasmarter.com January 15th, 2021 To the City of Bozeman: GCS understands that the City of Bozeman seeks a review of their existing GIS system enivronment and practices. From that review, the City is requesting recommendations for how to best improve current operations, how to effectively balance a mixed in-house and web-hosted environment, and how to better leverage the existing technology footprint. Looking forward, the City of Bozeman seeks recommendations on what new practices and technologies would be beneficial to implement given the constraints and requirements of their environment. GCS has the expertise to review the City’s use of their SQL Server Enterprise Geodatabase, ArcGIS Enterprise (referenced as well as hosted data), ArcGIS Online, data integrations using FME, and the use of ArcGIS Desktop and Pro to update and publish data consumed by internal as well as external users. We recognize that the City of Bozeman’s GIS division has expanded to provide support across every department within the City, and we are prepared to conduct a review of that expanded system and provide recommendations as to best practices moving forward. Located in Missoula, MT, GCS has over 20 years of experience in the GIS industry. We have assessed, designed, and implemented geospatial systems for our customers in both the public and private sectors. Our current clients include organizations such as the Montana Department of Natural Resources, and the largest private landowner in the United States, Weyerhaeuser. Our muti-decade experience in the GIS industry makes us a great fit for the City of Bozeman’s needs. As GIS is an integral part of all operations in the City’s organization, GCS is prepared to provide an assessment of the current system and recommendations for future developments. Sincerely, ATTENTION: Shannon Hughes Innovate Montana Governor's OfÞce of Economic Development P.O. Box 200801 Helena, MT 59620-0801 PROJECT TITLE: Innovate Montana Website Changes PROJECT DESCRIPTION: Modify and revise Innovate Montana Website according to re- quirements identiÞed by Innovate Montana. Changes include modiÞcations to content on the Home, Work Here, Live Here, Business Development and Jobs Board Pages. QUOTE NUMBER: 12512 (revised) DATE: January 30, 2012 QUOTE EXPIRES: March 1, 2012 Description Amount Rate Total Custom Programming Services* 120 hours $125.00 $15,000.00 FIRM FIXED PRICE TOTAL!!!!! $15.000.00 *Services to be performed are detailed in Appendix A Thank you for your inquiry! Sincerely, Michael Beltz, Vice President of Sales and Marketing 115 South Fourth Street West Missoula, Montana 59801 USA T 406.532.3254 F 406.532.3255 mbeltz@gcs-research.com www.gcs-research.com QUOTATION Michael W. Beltz President GCS 115 South Fourth St. West Missoula, MT 59801-27821 4 GCS GCS | CITY OF BOZEMAN RFP RESPONSE | FIRM PROFIlE Company’s Legal Name: GCS Holdings Company Address: 115 S. 4th St. W. Missoula, MT 59801 USA Phone Number: 406-747-8393 Website: gcs.yourdatasmarter.com Point of Contact: Michael Beltz, President Mobile: 406-546-7240 mbeltz@yourdatasmarter.com FIRM PROFILE 5 GCS GCS | CITY OF BOZEMAN RFP RESPONSE | PROPOSEd SOluTION PROPOSED SOLUTION A narrative describing the Consultant’s proposed approach to conducting a database & data architecture review and recommended plan Our team of geospatial IT and cloud certified professionals help organizations unlock and enable GIS technology. With over 200 years of combined technical expertise, GCS converts your ideas into reality through customer-driven, innova-tive applications. GCS customers gain strategic value through increased produc- tivity, efficiency and profitability, optimizing mission-critical business processes. Working across various business practices, we bring technical and domain expertise with value-driven focused delivery. Our project teams are coached by GCS certified PMP and PMI-ACP project managers. We maximize success and ease process through industry standard methodologies. Based on customer culture and requirements, we lead and work within agile, waterfall, or hybrid approaches. GCS will work with the City of Bozeman to conduct a full review of existing data- base architecture and provide best practice recommendations for transitioning to a modern web-based Enterprise GIS. Assuming a February 1st start date, project work will be conducted in phases over a four-month period of perfor-mance with final acceptance of deliverables on Monday, May 31, 2021. Month Project Phases February Plan and Design Define project team, detailed scope definition, define deliverables, review work- flows, business processes, existing technology, identify challenges, risks, and issues. March & April Implementation Deep drive with City of Bozeman on each scope task to define best practices and supporting documentation, prototyping, and/or Proof of Concept (PoC) activities. May Finalize Deliverables Review, refine, and finalize all deliverables through interactive meetings with City of Bozeman. 6 GCS GCS | CITY OF BOZEMAN RFP RESPONSE | SCOPE OF PROjECT SCOPE OF PROJECT Project Deliverables GCS will provide the City of Bozeman’s GIS department with a full review of their existing database architecture (both traditional databse as well as hosted data), and provide recommendations for best practices, especiall in regard to areas where transitioning from a traditional GIS to a web based Enterprise Geodatabase would be considered best practice. Additionally, GCS recognizes and understands the following areas of requirements as detailed in Section II B, Project Scope, of the Request for Proposal document: 1) Review of the existing use of Enterprise Geodatabase 2) Review of the existing use of File Geodatabases 3) Review of the existing use of Hosted data (ArcGIS Enterprise Data Store and ArcGIS Online) 4) Recommendations for improving database maintenance and overall performance 5) Recommendations to improve data management (including integrations) 6) Recommendations for migrating to new data models (i.e. ArcGIS Solutions for Local Government, Utility Networks, etc.) 7) Recommendations on when to use a File Geodatabase, Enterprise Geodatabase, and Hosted Feature Services (ArcGIS Enterprise or ArcGIS Online), including best practices 8) Review of the existing GIS integrations and how to more efficiently use FME to channel data to the appropriate repositories (File Geodatabase, Enterprise Geodatabase, Hosted Feature Service, etc GCS will provide documentation on the review process, findings, and recommenda-tions. The documentation will consist of an executive summary as well as a detailed report of the process, findings, and recommendations for each of the requirement areas. Recommendations will include line-item detail with a high-level estimate of the effort involved, highlights of any anticipated dependencies and challenges, and a ranking of relative impact of the improvement (low, medium, high). For the best practices in requirement 7, GCS will provide a white paper addressing the use of each of the elements listed. A decision tree will be provided that is tai-lored to the City of Bozeman’s architecture and operational goals. 7 GCS GCS | CITY OF BOZEMAN RFP RESPONSE | RElATEd ExPERIENCE WEYERHAEUSER Weyerhaeuser needed a simple, user-friendly, easily accessible way to market and manage leasable land for people looking to hunt, camp, fish, or engage in other recreational activities. They wanted a publicy-accessible web portal which would show areas on a map, display the type of forests available, and also display any accessible amenities available on the property. Problem Solution Weyerhaeuser contracted GCS to create Recreation Lease Management (RLM), a publicly accessible web portal that allowed the company to offer their land for lease and keep track of who was leasing it at any given time. GCS developed an interactive mapping portal which displayed all relevant information about the properties, as well as pricing and availability. This streamlined system helped Weyerhaeuser cut down on complicated, time-consuming tasks related to the leasing process, and made it easier for the public to find what they were looking for. Weyeraeuser’s Recreation Lease Management system is available at: https://wyrecreation.com/ RELATED EXPERIENCE 8 GCS GCS | CITY OF BOZEMAN RFP RESPONSE | RElATEd ExPERIENCE Rangers and field personnel need functioning radio repeaters that boost weak signals over long distances. These sites are monitored by instrument telemetry, but the Forest Service wanted to manage their operating status spatially in an integrated dashboard through a web application. GCS developed a process of collecting, transmitting, and importing instrument data into a database. Hourly records from multiple sources are compiled and analyzed in a standard database storage structure. GCS spatially enabled the database, created a web service that distributed “health” metrics derived from the data, and consumed the service in our web mapping application to display the health data spatially. The application includes a map interface accessed through a browser, with data layers compiled from the real-time instrument data. The application provides up-to-date instrument statistics for each site and radio repeater unit at a site, along with historical data search and visual charting. Custom map layers generated on-the-fly from the most recent data show whether radio repeaters were healthy (green) or unhealthy (red) according to the most recent metrics. GCS enhanced the system with four user levels, an enhanced dashboard with quick searches, savable bookmarks, favorites list, map tips, and additional map layers. An administrative interface offers control functions such as enable/disable repeater locations and define alerts. The system supports mobile devices, and optimizes FTP access and the data import process for new repeaters. Problem Solution MOBILE ANALYTICS U.S. FOREST SERVICE - RADIO REPEATER RELATED EXPERIENCE GCS GCS | CITY OF BOZEMAN RFP RESPONSE | RElATEd ExPERIENCE 9 AGREN Agren was looking to develop a web interface which would enable users to accomplish in minutes what farmers have traditionally waited weeks, to months, for from local public agencies. They wanted to empower farmers and land managers to make profitable decisions while simultaneously enhancing agricultural productivity and supporting sustainability. Problem Solution Working closely with Agren, GCS delivered, from the ground up, Agren’s precision conservation suite of geospatial based web tools: WaterwayBuilder, PondBuilder, BasinBuilder, and WetlandBuilder. In addition, GCS supplemented Agren’s internal agile development team to support operations and create new feature enhancements to SoilCalculator and BufferBuilder solutions. Agren SoilCalculator allows service providers to plug in various crop rotations, tillage systems, and conservation practices and view the resulting erosion predictions for up to three scenarios. Color-coded maps, similar to a GIS yield map, pinpoint areas of high erosion. Growers can easily evaluate alternatives side by side to maximize profits, conserve soil, preserve yields, and reduce nutrient inputs. RELATED EXPERIENCE 10 GCS GCS | CITY OF BOZEMAN RFP RESPONSE | RElATEd ExPERIENCE Project Spotlight - Stream and Gage Explorer (StAGE) The Montana Department of Natural Resources required the implementation of a data warehousing and distribution system for streamflow data, allowing for ease of access for internal employees, stakeholders, and public. After engaging GCS to develop this browser-based, geospatial web application, the Stream And Gage Explorer (StAGE), project began in July of 2020. The project is currently in progress. The DNRC identified the project as Business Critical in order to address several crucial processes. These include: • Collecting, analyzing, and presenting accurate, high-quality ‘real-time’ streamflow data in Montana’s rivers, streams, and other critical surface water locations, not monitored by the National USGS program • Providing stream flow data and information to a user friendly, publicly accessible web site developed by the Montana Bureau of Mines and Geology • Enabling water users and managers to make water use and distribution decisions based on real-time information • Creating ways to access and utilize data to aid in water resources and conservation duties The application itself required several concrete aspects: • The Main Page - Includes selectable base map and navigation buttons to other areas of the application. Also includes pop-ups that appear by selecting symbolized points with information such as Site Name, Site ID, hyperlinks to the site’s Report Page, most recent discharge values, stage, and temperature. • The Table View Page - Includes a list of all DNRC gages, broken down by basin, with columns representing attributes such as Site Name, Site ID, lat/long, and County. • The Report Page - Each gage has its own specific URL Report Page containing information such as the most recent values, the 7 day stage, the 7 day discharge, and the 7 day temperature. • The Data Downloader Page - Allows users to query and download gage data and gage statistics as needed. The user selects a gage, then they select the data Development for StAGE began in July 2020 and is currently ongoing. MONTANA DEPARTMENT OF NATURAL RESOURCES RELATED EXPERIENCE GCS | CITY OF BOZEMAN RFP RESPONSE | RElATEd ExPERIENCE 11 GCS MONTANA DEPARTMENT OF NATURAL RESOURCES types they want for that gage/the data ranges and statistics they want. From there, the application generates an Excel file based on their query. This intuitive solution will enable the DNRC to internally manage water conservation efforts while additionally providing the public easy access to stream gage information, with several different types of cross-referenced data available in a browser-based geospatial application. RELATED EXPERIENCE 12 GCS STATEMENT OF QUALIFICATIONS GCS | CITY OF BOZEMAN RFP RESPONSE | STATEMENT OF QuAlIFICATIONS CORPORATE OVERVIEW GCS delivers highly customized solutions that communicate meaningful geographic information and enhance workflow optimization. Our clients come to us from a broad spectrum of industry sectors with a common need: streamlined access to business insights distilled from complex data. Our technical expertise and collaborative client relationships allow us to design the powerful, elegant solutions needed to maximize productivity. Our systems are crafted at the convergence of cloud, analytics, and mobility to ensure access to answers everywhere, all the time. Since 2002, we have delivered award-winning solutions for public and private organizations in diverse disciplines, including Natural Resources, Defense/Intelligence, Insurance, and all levels of Government. We bring decades of technical expertise to the table in designing these customized geographic intelligence systems. For nearly 20 years, our award-winning team of experts has integrated and adapted best-of-class GIS platforms with cutting-edge technology to extract value from data, and opportunities from information. Dedicated teams work with clients for the life of a project to ensure the delivery of precise solutions for unique business challenges. Our ability to remain agile and responsive sets GCS apart from industry giants. Clients choose GCS – and engage us again and again – because our solutions exceed their expectations, and because our team demonstrates unwavering commitment to harnessing innovation that works. In every project and for every client, we judge our success by the satisfaction of the people who use the solutions we craft for them. With our solutions, clients will: • Boost access to spatial data and tools by serving apps on the web or in mobile devices people regularly use • Add geospatial context to previously unmapped data to produce new insights • Optimize business processes and workflows • Minimize data maintenance costs by establishing cloud databases • Receive stable hosting and dynamically expanding user capacity • Minimize cost by serving applications in the cloud • Reduce expense and simplify workflows through systems integrations • Achieve insights and intelligence through advanced analytics • Save time with intuitive, accessible tools for non-GIS professionals 13 GCS GCS | CITY OF BOZEMAN RFP RESPONSE | STATEMENT OF QuAlIFICATIONS GCS GCS staff have demonstrated professional expertise by achieving several Esri Certifications. GCS is an Esri Silver Partner. Further, as an Esri partner in the Release Ready Specialty, GCS is recognized for keeping pace with Esri technology, expertise, and the community by helping users make smart decisions using Web GIS. GCS is a long-standing Microsoft Partner. Our team has achieved the Application Development competency. STATEMENT OF QUALIFICATIONS COMPANY & STAFF CERTIFICATIONS 14 GCS GCS | CITY OF BOZEMAN RFP RESPONSE | STATEMENT OF QuAlIFICATIONS GCS Our project teams are coached by GCS certified PMP and PMI-ACP project managers. GCS is a member of The SuiteCloud Developer Network (SDN). It is a comprehensive developer program for independent software vendors (ISVs) who build apps for SuiteCloud. Our SuiteApp, GeoBusiness for NetSuite, achieved “Built for NetSuite“ status in 2019. Our team is comprised of AWS Certified Cloud Practitioners, who are qualified to advise our customers in all aspects of AWS infrastructure. STATEMENT OF QUALIFICATIONS COMPANY & STAFF CERTIFICATIONS 15 GCS GCS | CITY OF BOZEMAN RFP RESPONSE | STATEMENT OF QuAlIFICATIONS GCS solutions increase efficiency and productivity by communicating intelligence distilled from complex data. Complex data is most valuable when it’s communicated in a way that people understand. Our solutions organize unstructured geographic information to deliver meaningful answers for unique challenges. Elegant interfaces connect our client’s organizations seamlessly with the insights needed to move the organization forward and reach out to the public. STATEMENT OF QUALIFICATIONS SOLUTIONS OVERVIEW 16 GCS GCS | CITY OF BOZEMAN RFP RESPONSE | STATEMENT OF QuAlIFICATIONS We make your data smarter by leveraging the convergence of the cloud, analytics, and mobility. Harnessing the power of the cloud allows us to design your customized geospatial solution in a secure, scalable environment. Tapping into the cloud with analytics and mobility creates the perfect storm, bringing the right answers to the palm of your hand, whenever you need them. Instant access to precise information transforms insights into action, and data into profit for our clients. Big Data or niche, GCS solutions put advanced tools and reports in the right hands at the right time advanced geospatial mapping complex data processing access anywhere, anytime ANALYTICS MOBILE CLOUD GCS Advanced Analytics Mobility Cloud Technology Web applications, smart resizing, or custom apps for Android, Apple and Windows - GCS makes Smarter Data everywhere you go. Improved performance, superior security from distributed systems, scalable to unlimited users, Cloud technology answers myriad tech dilemmas. STATEMENT OF QUALIFICATIONS SOLUTIONS OVERVIEW 17 GCS GCS | CITY OF BOZEMAN RFP RESPONSE | STATEMENT OF QuAlIFICATIONS GEOBUSINESS FOR NETSUITE GeoBusiness for NetSuite is a location intelligence platform product available in the SuiteApp store. With a variety of workflow-enhancing features, such as asset management functions and geographic scheduling, GeoBusiness also includes geo-analysis capabilities, which Executives and CEOs can use to make informed decisions, and maximize profits. GeoBusiness supports and augments NetSuite via GIS technology. It empowers users to identify and manage supply chain disruptions, forecast profits for potential locations, determine service reach and response, and coordinate field-based business sales activities. Our Field Operations solution enables organizations to track employees, schedule deliveries with optimized routing, with the goal of ensuring a seamless order progression throughout the NetSuite order to cash life cycle. Field Sales More time with customers. Less time planning. Sales Managers and Executives Empower key decision makers to increase profits. Field Operations Track employees. Schedule assets. Coordinate field deliveries with optimized routes. Customer Service Go beyond gut instinct or guesswork to connect and optimize customer experiences. Situational Awareness React to large-scale disasters. Respond to supply chain distruptions. STATEMENT OF QUALIFICATIONS PRODUCT OFFERINGS 18 GCS GCS | CITY OF BOZEMAN RFP RESPONSE | STATEMENT OF QuAlIFICATIONS ArcGIS ENTERPRISE CLOUD SERVICES IN AWS & MICROSOFT AZURE GCS is a professional services firm helping customers of all types and sizes design, architect, build, migrate, and manage their ArcGIS workloads, applications, and data on Amazon Web Services (AWS), Microsoft Azure, and ArcGIS Online. GCS CLOUD SERVICE OFFERINGS Our team provides assistance through a collection of offerings that help you achieve specific outcomes related to ArcGIS Enterprise cloud adoption and success. GCS provides ArcGIS cloud migration services, from assessing migration readiness, to defining strategy, to implementing a Proof of Concept (POC) cloud deployment. Our team will evaluate your existing on-premise architecture to a comparable system in the cloud. We aim to help define and meet your specific cloud implementation objectives. ArcGIS MANAGED CLOUD SERVICES GCS manages your GIS cloud’s activities, such as: change requests, monitoring, patch management, security, and backup services. GCS provides full life-cycle services to provision, run, and support your infrastructure. ArcGIS CLOUD-NATIVE SERVICES ArcGIS CLOUD MIGRATION GCS helps you move away from monolithic architectures to Cloud-Native server-less architectures. ArcGIS CLOUD SECURITY ASSESSMENT GCS is committed to delivering ArcGIS Security IT services that meet the needs of customers, from individuals to large organizations. GCS’s team is comprised of certified ArcGIS and cloud professionals who are solution architects, system integrators, native cloud developers, data scientists, and professional project managers. STATEMENT OF QUALIFICATIONS SERVICES OFFERINGS 19 GCS GCS | CITY OF BOZEMAN RFP RESPONSE | STATEMENT OF QuAlIFICATIONS We provide solutions to organizations of all sizes in both the private and public sectors, including agencies at all levels of government and Native American tribes. Our diverse clientele spans a broad spectrum of industries and professions, such as Natural Resources, Forestry, Defense/Intelligence, Insurance, Health Care, Cyber-Security and Energy. For every challenge, we create a fully customized solution. Local & State County Government Boulder County, CO Flathead County, MT Missoula County, MT Lake County, MT Lewis and Clark County, MT Clearwater County, ID Colorado State Land Board Clark Fork Coalition (River Health NPO) Municipalities including: City of Billings City of Columbia Falls City of Missoula Montana Information Technology Services Division Montana Governor’s Office of EconomicDevelopment Montana Department of Natural Resources and Conservation Montana Department of Health and Human Services University of Montana Montana Department of Fish, Wildlife, and Parks Montana Historical Society Montana Dept. Transportation STATEMENT OF QUALIFICATIONS CLIENT OVERVIEW 20 GCS GCS | CITY OF BOZEMAN RFP RESPONSE | STATEMENT OF QuAlIFICATIONS Kalispel Tribe of Indians Fort Peck Tribes Fort Belknap Reservation Nooksack Tribe Tribal United Nations Private Sector While many of our clients are in the Rocky Mountain West and Pacific Northwest regions, we support clients as far away as Vienna, Austria. Federal Government Esri Sarnoff Inc. The SI Organization GeoEye OmniTRAX Weyerhauser PlAL Idaho Survey and Rating Bureau GeoNav Group International Oxford University Press Firewise Communities Program Missouri Botanical Garden CACI Inc.Immersive Media Inc. Alion Science & Technology Inc.National Fire Protection Association Economic DevelopmentLethbridge, Canada Washington Survey and Rating Bureau Institute for Health Metrics and Evaluation Agren International Atomic Energy Agency U.S. Army - NVESD DOE - Idaho National Laboratory U.S. Marine Corps - 1 - MEF U.S. Geological Survey U.S. Navy - NUWC - NAVSEA Army Corps of Engineers USDA Foreign Agricultural Service U.S. Forest Service - Fire Sciences Lab U.S Fish and Wildlife Service STATEMENT OF QUALIFICATIONS CLIENT OVERVIEW GCS GCS | CITY OF BOZEMAN RFP RESPONSE | REFERENCES 21 Project Name: Protection Class Calculator (PCC) Project Description The Protection Class Calculator uses embedded GIS web service logic and data, allowing Washington Survey and Rating Bureau to provide highly accurate protection class scores to their insurance clients in near real-time. WSRB approached GCS in 2003 to help them design and implement a Protection Class Calculator (PCC) web service with an elegant user interface. The PCC was a complex algorithm designed to determine risk for commercial property and produce a score (1-10). WSRB sells these calculated PCC scores to the largest insurance companies in the world that underwrite property in the State of Washington. WSRB needed to develop an automated Service Oriented Architecture (SOA) using a combination of Microsoft .NET and Esri ArcGIS technology and custom GCS code that could be readily accessed as a complete, integrated solution for the insurance risk system. GCS delivered a Protection Class Calculator system using embedded GIS web service logic and data, allowing WSRB to provide highly accurate protection class scores to their clients in near real-time. The SOA optimized WSRB workflow, reduced labor costs, and allowed them to sell more scores at a faster rate to their Project Dates: 2009 - 2019 Project Reference Name: Daniel Ander Company: WSRB Position: Assistant Vice President Address: 2101 4th Avenue Ste 300, Seattle, WA 98121 Phone: 206-778-9546 Email: daniel.ander@wsrb.com Project Location All development work for Protection Class Calculator was conducted at our office in Missoula, MT. REFERENCES WASHINGTON SURVEY AND RATING BUREAU 22 GCS GCS | CITY OF BOZEMAN RFP RESPONSE | REFERENCES 22 insurance industry customers. GCS has maintained a close working relationship with WSRB over the past ten years, developing multiple upgrades and new versions of the PCC system, and is pursuing additional engagements with the client. REFERENCES WASHINGTON SURVEY AND RATING BUREAU 23 GCS GCS | CITY OF BOZEMAN RFP RESPONSE | REFERENCES Project Name: Trustlands Application Project Reference Name: Nick Massie Company: Colorado State Land Board Position: Chief Financial Officer/Chief Operating Officer Address: 1127 Sherman St., Room 300, Denver, CO 80203 Phone: 308-866-3454 ext. 3316 Email: nick.massie@state.co.us Project Dates: 2012 - Present Project Description The Colorado State Land Board manages millions of acres of state lands. To track sales, leases, and revenue, CSLB used several separate systems, making it difficult to sync data organization-wide. CSLB engaged GCS to centralize this data into a single viewer, with the end goals of improving management efficiency, and relieving the burden from CSLB staff bogged down by labor-intensive information requests. This resulted in the development of the Trustlands web application, which represented a custom integration between ArcGIS and NetSuite. CSLB reengaged GCS after the initial development to perform upgrades and modifications based on their organization’s business needs.The latest series of upgrades occured this year and included the following aspects: 1. Application Changes: Migrate Trustlands application to an ArcGIS Web Application with the latest version of ArcGIS Web AppBuilder and ArcGIS API for JavaScript 2. Map Popups: Modify the map popup template to appear in a side panel rather than a popup on the map. Add custom dropdown UI for choosing from clustered/multiple-selected features. 3. NetSuite Integration: Add UI button to the popup panel linking to the se- lected feature’s asset information in NetSuite. 4. Laserfiche Integration: Add UI button to the popup panel for viewing the selected feature’s associated documents in Laserfiche. 5. Select Tool Changes: Add custom styling to the Select tool to highlight Project Location All development work for Trustlands was conducted at our office in Missoula, MT. REFERENCES COLORADO STATE LAND BOARD 24 GCS GCS | CITY OF BOZEMAN RFP RESPONSE | REFERENCES the selected feature in the list and automatically zoom to the selected feature in the map. 6. About Widget Changes: Modify the About widget to include a Login tab and form for employees to login and access Netsuite features. 7. Layer List Groupings: Create a widget group for organizing layers into custom groups independent of feature server layout. 8. Print Map Service: Setup an ArcGIS print service to print the map using custom layouts. 9. .NET Web API: Create a web API that the Trustlands app can use to ac- cess NetSuite services and act as a login controller for employees. This user-friendly system that GCS created, and then upgraded, for CSLB allowed the public to identify specific locations on State Land Board maps. Simultaneously, CSLB staff can log in to see restricted data and run reports. Automations allowed fast, accu- rate updates without extensive employee training. Consolidating this data from multiple sources optimized CSLB’s workflows. By simplifying the process of location available lands to lease from the state, the web app reduced assistance requests, saving the CSLB staff time and money. Previously labor- intensive requests for printed maps are now managed directly from the CSLB web app, cutting costs for CSLB, and taxpayers. REFERENCES COLORADO STATE LAND BOARD 25 GCS GCS | CITY OF BOZEMAN RFP RESPONSE | REFERENCES Project Reference Name: Mark Slaten Company: Montana Department of Natural Resources Position: Forest Informatics Analyst Address: 2705 Spurgin Rd, Missoula MT, 59804-3111 Phone: 406-212-9604 Email: mslaten@mt.gov Project Name: NextGen Cruiser The DNRC manages Montana’s forested trust lands, with the goal of maximizing long-term revenue while promoting healthy and diverse forests. Revenue from forested trust lands is mainly derived from the sale of forest products. The DNRC needed custom tools to meets its legislative mandate, maintain inventory of for- ested trust lands, and meet harvest volume goals. In 2015, they were searching for a new timber cruising platform that would replace a legacy system that was no longer supported by their IT department. The Esri ArcGIS Online/Collector platform seemed to be a great fit, but they needed a contractor to customize this off- the-shelf software to enable them to design cruises and allocate plots via a web interface, collect tree data in Collector, and compile/report the results. With over 700,000 acres of School Trust Lands to manage, they needed a solution to allow timber inventory to be accomplished internally through field data devices, GIS, and server-based data systems. To address the need for this functionality, GCS created NextGen Cruiser via the ArcGIS API for JavaScript. The DNRC then reengaged GCS in 2017 to create Version 2.0 of the application, using Version 1.0 as the existing platform upon which to build new features/expand existing Project Dates: 2015 - Present Project Description Project Location All development work for NextGen Cruiser was conducted at our office in Missoula, MT. REFERENCES MONTANA DEPARTMENT OF NATURAL RESOURCES 26 GCS GCS | CITY OF BOZEMAN RFP RESPONSE | REFERENCES GCS capabilities. The enhancements contained geoprocessing tools along with specificed AGOL web maps/web applications. The enhancements are summarized below: • Archive Cruise/Delete Cruise -: added a user interface button allowing the user to permanently archive a zipped copy of a timber cruise’s data in a specified location while removing the cruise from the list of active cruises by deleting its feature service and map. This feature also warns the user of this action/awaits user response before executing. • Propose Harvest Units - an enhacement which allows users to choose polygon(s) from an existing DNRC feature service for cruise design, with the schema of these polygons including all of the needed existing attribute fields • Old-Growth Design & Reporting - an enhancement allowing users to collect data for old-growth determination, with an updated related table for data collection. • Regen Cruise Design & Reporting - allows users to collect small tree data on fixed radius cruise plots. Plot allocation is taken directly from user input, rather than being calculated automatically. • Plot Allocation Flexibility - allows users to override the current restric- tion of disallowing plots to be allocated within 66 feet of another plot. • Individual Tree Volume Calcuation - created a standalone application using the individual tree volume calculation formula from V.1.0 com- piler to calculate individual tree volumes. Also allows users to submit a formatted Excel form that has each tree’s diameter, height, and defect. The DNRC’s timber inventory has been accomplished internally through field data devices, GIS, and server-based data systems. Their field data collection devices (Apple iPads with the Esri Collector Application), cruise designer and subsequent data compil- er are all included within the custom AGOL web application, NextGen Cruiser. NextGen Cruiser worked efficiently in its initial Version 1.0 form, and has been a key component for countless timber cruises since its development and implementation. The enhanced features added in Version 2.0 allowed DNRC to continue to meet its legislative man- date to maintain inventory of forested trust lands and to meet harvest volume goals. The DNRC continues to engage GCS on a yearly basis to provide maintenance and support for the application. “We found GCS to be: easy to communicate with, conscientious and mindful of budget & timelines, willing to provide advice when they discovered a better/ more efficient way of accomplishing a task, and very supportive after the release to fix bugs.” - Mark Slaten, Forest Informatics Analyst, Montana DNRC REFERENCES MONTANA DEPARTMENT OF NATURAL RESOURCES 27 GCS GCS | CITY OF BOZEMAN RFP RESPONSE | PRESENT ANd PROjECTEd WORklOAdS PRESENT AND PROJECTED WORKLOADS GCS is currently engaged in several projects across the public and private sectors in 2021. Current clients include Weyerhaueser, Colo- rado State Land Board, the Montana DNRC, Idaho Survey and Rat-ings Bureau, and the Property Insurance Association of Louisiana. Project Managers Mike Beltz, John Waterman, and Fred Spataro have assessed our obligations to current clients and the workloads associated with each project. They have concluded that our team has availability to take on additional projects while adhering to all deadlines, and providing exceptional customer support throughout all stages of the project. 28GCS | CITY OF BOZEMAN RFP RESPONSE | kEY PERSONNEl GCS Mike has served in many roles, such as: Vice President of Sales and Marketing, strategic planner, business developer, and project manager/Director of the Northern Rockies Geospatial Training Center. Frequently acting as project manager and liaison for GCS clients, Mike handles communication, and tracks progress throughout solution development. He oversees all project phases, from planning and design, to programming and implementation, to training, quality assurance, and final delivery. He works closely with clients to define their specific expectations and to set goals for delivery. His guidance ensures that GCS produces milestone deliverables on or ahead of schedule. He also leads our sales team in drafting/submitting proposals, and networking for business development. GCS clients continue to benefit from his team-focused leadership and his extensive work experience in the GIS industry. He has worked with public and private institutions including: United Nations International Atomic Agency, National Geospatial Intelligence Agency, U.S. Department of Agriculture, U.S. Geological Survey, U.S. Fish and Wildlife Service, and the Department of Energy - Idaho National Laboratory. MIKE BELTZ ACCOMPLISHMENTS Highlights Years of Experience: 24 Senior level experience with Esri GIS products Extensive expertise in teaching and training GIS Domestic and international GIS experience Cartographer and GIS Analyst Education Bachelor of Arts from Alfred University in New York Graduage Coursework in Geography, emphasis in Computer Cartography Organizations International Society for Conservation GIS - Past President and Board Member While Mike held the role of Vice President of Sales and Marketing, GCS was awarded: ESRI New Business Partner of Year, ESRI Business Partner of the Year, ESRI Foundation Partner of the Year, ESRI Gold Partner and Microsoft Gold Partner. Sales grew by 400%. He oversaw the completion of a project for the International Atomic Energy Agency (IAEA, a division of the United Nations), where GCS developed and delivered a Geospatial Exploitation System. Mike’s role involved: managing client expectations, overseeing development and testing of the system, handling scope issues, monitoring on-site installations and beta tests, conducting training classes, and achieving final acceptance of the system. Frequent travel abroad for over two years was necessary to achieve final system acceptance. He oversaw projects that involved GIS data development and highly specialized user interfaces, such as Economic Development Lethbridge, county government web GIS apps (Flathead, Lake, Missoula, and others), GeoNav, and the Institute for Health Metrics and Evaluation. He has participated and presented at numerous conferences including: Defense Geospatial Intelligence Conference, ESRI International User’s Conference, ESRI European User’s Conference, U.S. Geospatial Intelligence Foundation GEOINT Symposium. PRESIDENT WORK HISTORY GIS Director for Ecosystem Research Group - an environmental consulting firm in Missoula, Montana. His maps for the Jefferson- Martin Transmission Line Project were key to the Association of Environmental Professional’s “Best Statewide Environmental Impact Award.” KEY PERSONNEL 29 GCS GCS | CITY OF BOZEMAN RFP RESPONSE | kEY PERSONNEl EMPLOYER POSITION/TITLE DATES GCS President 2015 - Present GCS Vice President of Sales and Marketing 2004 - 2015 Ecosystem Research Group GIS Program Director 2001-2003 The Ecology Center International GIS Program Director 1998-2001 Bicycle Federation of America GIS Program Director 1996-1998 International GIS Program Director - for a non-profit, public-interest conservation organization. The Ecology Center was dedicated to helping grass roots activists and scientists protect and restore biodiversity and intact ecosystems. Worked with international conservation programs to use GIS for more scientific and ecologically sound management of priority lands, and to help keep wild lands wild. International GIS Capacity - building workshops, training, and GIS lab development including various sites in Russia, Japan, Turkmenistan, and Chile. Organized and held the first Conservation GIS Conference in Russia. Provided GIS mapping support for the International Gondwana Forest Sanctuary Project in Tierra del Fuego, Chile. International Scholarship Program - Directed an international GIS Scholarship program designed to bring scientists from Russia, Central Asia and Chile to The Ecology Center’s GIS lab for intensive GIS training, grant writing workshops and professional development. GIS Program Director - Responsible for incorporating GIS tools and analysis into non-motorized transportation planning programs for the Bicycle Federation of America based in Washington, D.C. MIKE BELTZ PRESIDENT KEY PERSONNEL GCS | CITY OF BOZEMAN RFP RESPONSE | kEY PERSONNEl 30 GCS JOHN WATERMAN, PMP, PMI-ACP, GISP John joined GCS in 2004. As CTO, his main focus is driving customer projects to successful completion. John oversees the company’s research and product development activities, and professional development/training for team members, driving the company to explore and expand into new technologies to meet GCS clients’ changing business needs across various industries. CTO ACCOMPLISHMENTS Highlights Education Years of Experience: 20+ GIS Architect and Developer Extensive International Experience Bachelor of Science in Forestry Management from Oregon State University Master of Science in Forestry Management from the University of Montana John’s numerous professional certifications demonstrate his wealth of experience, education, and competency to lead and direct geospatial technology projects to successful completion. The Project Management Professional (PMP) is the most important industry-recognized certification for project managers. The PMI Agile Certified Practictioner (PMI-ACP) formally recognizes knowledge of agile principles and skill with agile techniques. The GISP is a certified geographic information systems (GIS) professional. TECHNICAL CAPABILITIES John’s technical skills focus primarily on the Esri, Microsoft, and AWS technology stacks. He started his GIS developer career working with early Esri server technologies, including the first builds of ArcGIS Desktop with ArcObjects, while at Esri in Redlands, CA. John built the first ever Android mobile app utilizing ArcGIS Server technology to be deployed in the Google Play Marketplace. Awards • Esri Enterprise Geodata Management Associate Certification • Esri Enterprise System Design Associate Certification • ArcGIS Online Administration Specialty • Esri Enterprise Administration Professional Certification • Esri Enterprise Administration Associate Certification • Esri Web Developer Associate Certification • AWS Certified Cloud Practitioner • AWS Certified Cloud Solutions Architect - Associate • PMI Agile Certified Practicioner (PMI-ACP) • Project Management Professional (PMP) CERTIFICATIONS 2019 The Future of Forestry & Agriculture in Vermont Hackathon - First Place 2017 7th annual HACKVT - 24- hour hackathon - First Place 2008 Esri ArcGIS Server Code Challenge - First Place 2007 Esri ArcGIS Server Code Challenge - Honorable Mention KEY PERSONNEL 31GCS | CITY OF BOZEMAN RFP RESPONSE | kEY PERSONNEl GCS EMPLOYER POSITION/TITLE DATES GCS CTO 2004 - Present microDATA GIS Inc.Senior GIS Programmer and Spatial Data Administrator 2004-2006 Esri Consultant 2000-2004 WORK HISTORY John brings a wealth of expertise and experience to GCS. He has worked for Esri’s Implementations Services in Redlands, CA, and the Esri Denver office, where he provided consulting and technical services to clients working with desktop and server technologies. In addition, he served as an ArcSDE database administrator and ArcObjects programmer for an Enhanced 911 software company, microDATA GIS Inc. Most recently at GCS, John completed a project for the International Atomic Energy Agency (IAEA, a division of the United Nations), where GCS, within a highly restricted environment, implemented a custom geospatial SOA solution with integrated COTS GIS and imagery exploitation software, custom security software, and multiple data repositories/services to create one enterprise solution for over 400 users. He is currently leading GCS efforts in product development, marketing, and sales for GeoBusiness, a location intelligence platform for NetSuite available in the SuiteApp store. JOHN WATERMAN, PMP, PMI-ACP, GISP CTO KEY PERSONNEL 32GCS | CITY OF BOZEMAN RFP RESPONSE | kEY PERSONNEl GCS Fred joined GCS in 2005. He’s an information technology specialist with experience as a project manager. As a leader in project development, he has directed the team in developing spatially and non-spatially referenced databases and applications related to environmental permit compliance, chemical air emissions, utility systems, wildlife populations, and urban/natural resource planning. As lead systems engineer, Fred assumed an instrumental role in a number of significant projects, including; GeoMarc, the digital geospatial watermarking extension for ArcGIS; GAIN, the situational awareness common operational picture built on ArcGIS; and for several high-profile consulting contracts such as Weyerhaeuser, OmniTRAX, ISRB, Colorado State Land Board, PIAL, and the Montana DNRC. He was also the technical lead and systems engineer for a research and development contract with Adelos for the S4 Senor Array, which mapped intrusions detected by fiber-optic acoustic sensors. VICE PRESIDENT OF SOLUTIONS, PROJECT MANAGER ACCOMPLISHMENTS Highlights Years of Experience: 24 Systems Architect Project Manager Technical Lead and senior advisor on GIS development Education Bachelor of Science in Chemical Engineering from the University of Rochester Certifications Esri Certified ArcGIS Desktop Developer Associate Esri Certified Enterprise System Design Associate Mr. Spataro led the development of a COTS software extension to the Esri ArcGIS platform the provides a modeling framework for decision tools and analysis in the planning industry. He has performed extensive work as a GIS user manipulating data, performing analysis, and creating cartographic output with Esri ArcGIS Desktop, Pro, and Enterprise. Fred has a thorough understanding of most GIS data formats and data management, as well as metadata specifications, all Esri formats, CAD and Geographic Markup Language data. He designed and developed custom extensions to ArcGIS Desktop and Server using Python and Microsoft.NET languages. Bringing comprehensive knowledge of ArcGIS SDKs, including ArcObjects and JavaScript API, Fred’s expertise also encompasses administration and implementation with ArcGIS Enterprise and ArcGIS Online. Currently at GCS, he is actively involved with platform integration projects that bridge data and workflows between the ArcGIS platform, CRM systems including Microsoft Dynamics 365 and Oracle NetSuite, and big data analytics such as Microsoft PowerBI and IBM. Watson. TECHNICAL CAPABILITIES • Database experience: strong understanding of relational database systems (including Oracle and Microsoft SQL), SQL as needed for client applications (connecting through ADO, ODBC, Entity Framework, etc.) and development with the Esri ArcSDE Geodatabase, including schema design and data structures. • Operating Systems Experience: Windows Desktop and Server, Ubuntu Linux • Programming Languages: JAVA, C/C++, Visual Studio.NET(VB & C#), UNIX shell, FORTRAN, PASCAL, ASP, JSP, JavaScript, VBScript, XML/HTML FRED SPATARO KEY PERSONNEL GCS | CITY OF BOZEMAN RFP RESPONSE | kEY PERSONNEl 33 GCS EMPLOYER POSITION/TITLE DATES GCS Vice President of Solutions 2013 - Present GCS Project Manager 2010 - Present GCS Senior Geospatial Systems Engineer 2005 - 2015 CommunityVis from The Orton Family Foundation Software Architect 2003-2005 Esri Geospatial Systems Engineer - Technical Services 2000-2003 URS -Radian Chemical Engineer - Environmental Information Systems 1998-2000 U.S Fish and Wildlife Service Geographical Information Systems Analyst 1996-1998 Eastman Kodak Company Chemical Engineer - Material Safety Information Systems 1995-1996 WORK HISTORY Fred has experience installing and customizing Esri products including ArcGIS for Server and various client APIs. He has software development life-cycle experience, including project management, bug tracking systems, code source management, end-user technical support, and documentation. FRED SPATARO VICE PRESIDENT OF SOLUTIONS, PROJECT MANAGER KEY PERSONNEL GCS | CITY OF BOZEMAN RFP RESPONSE | kEY PERSONNEl • Helped architect and integrate automatic processes to assist and enhance the business workflows at Weyerhaeuser. Tasks included: integration of a custom WebMap into a Microsoft Dynamics 365 instance, and setting up connection between the spatial data and Dynamics data to drive automatic business processes • Responsible for crucial operational support tasks for Weyerhaeuser products including: responding to customer tickets, and maintaining Weyerhaeuser’s Forest Management System and Parcel to Market program through production data changes • Helps maintain and update spatial data for Idaho State Ratings Bureau including: development of scripts to apply business rules to spatial updates, and building quality assurance tools • Aided OmniTRAX by developing a method to validate and augment railroad crossings dataset, allowing them to comply with Federal Railroad Administration safety record stipulations • Developed a series of scripts to integrate OmniTRAX business data in NetSuite CRM software to other applications, allowing real-time communication between apps • Developed a series of tests and flow charts to help OmniTRAX quickly diagnose any connection issues • Developed several tools for Agren (now Land ‘o’ Lakes) leveraging hydrological models to simulate the effectiveness of various irrigation channel paths, cross-sectional cuts, and dam designs on a landscape 34 GCS Jay joined GCS in 2016. He is a technical professional with half a decade of experience in spatial analysis, process automation, testing, and operational support. With extensive experience coding solutions in Python and SQL, maintaining online ticketing solutions with SQL and HTML, and creating custom scripting with JavaScript, Jay has expertise that benefits all GCS clients looking to derive actionable intelligence from their spatial data. ACCOMPLISHMENTS Highlights Education Years of experience: 5 Geospatial Analyst with programming experience Bachelor of Arts in Mathematics from University of Montana Certifications Certificate in GIS Science & Tehnologies from University of Montana JAY EGENHOFF SENIOR GIS ANALYST WORK HISTORY EMPLOYER POSITION/TITLE DATES GCS Senior Data Scientist 2017 - Present GCS Data Scientist 2016-2017 GCS Intern 2015-2016 Rocky Mountain Labs IT Consultant 2015-2016 University of Northern Iowa Remote Sensing Intern 2012, 2014 KEY PERSONNEL GCS | CITY OF BOZEMAN RFP RESPONSE | kEY PERSONNEl 35 GCS TECHNICAL CAPABILITIES Programming Languages: • Proficient in: SQL, Python (including ArcPy), JavaScript, R • Familar with: C/C++, Shell Scripting Software and Technologies: • Database: Microsoft SQL Server • CRM/ERPS: Microsoft Dynamics 365, NetSuite, Microsoft Flow, XRMToolbox • Operating Systems: Microsoft Windows, Linux • IDE: Visual Studio, Visual Studio Code, Geany • Network: Postman • Spatial: Esri Products (ArcMap, ArcPro, ArcGIS Online), Erdas IMAGINE, ENVI, QGIS, MapBox, OGR/GDAL • Project Management: JIRA, Microsoft DevOps, git • Other: MovieMaker, GIMP, InkScape Hardware: • Mapping grade GPS • Laser spectrometer • Field spectoradiometer • Mavic Drone JAY EGENHOFF SENIOR GIS ANALYST KEY PERSONNEL 36 GCS GCS | CITY OF BOZEMAN RFP RESPONSE | kEY PERSONNEl 36 GCS Highlights Years of experience: 20+ IT Management Education Master of Science in Geographical Information Science and Technology from the University of Southern California Graduate Certificate in Geographical Information Science and Technology from the University of Southern California Bachelor of Science in Business Administration-Management, Graduated Magna cum Laude from San Jose State University Awards University of Southern California Spatial Science Institute - 2018/2019 Thesis Award, Second Place UNIGIS International Association 2019 Academic Excellence Prize University of Southern California 2020 Esri Development Center Student of the Year SENIOR GIS ANALYST AND SOFTWARE DEVELOPER Cass is a senior management professional with deep experience in highly complex, cross functional environments. He joined GCS in 2020. As a seasoned leader with demonstrated ability to create efficient, motivated teams in everchanging business environments, Cass is experienced in system implementations and transformations. He has an outstanding ability to deliver value through the practical application of technology. A graduate of the GIST master’s program at the University of Southern California’s Spatial Science Institute, Cass brings a wealth of GIS experience to the GCS team as well as a wide breadth of IT knowledge and skills honed over years of experience in the industry. ACCOMPLISHMENTS TECHNICAL CAPABILITIES Software and Technologies: • GIST: Esri ArcGIS Pro, ArcMap • Machine Learning: Maxent, NetLogo, R • Enterprise: SAP ECC and R3, SAP APO, Oracle Applications, Hybris Billing (aka BRIM), Hyperion Essbase, Business Objects, Longview Khalix, HP PPM, Peoplesoft, COBOL Programming Languages: • Proficient in: R, Python, Java, VBA, Basic, C, C++ • Masters of Geographical Information Science and Technology (GIST) • Studies focused on spatial analytics and modeling using Esri tools as well as external modeling methods such as Maxent and NetLogo. Technical aspects of GIST such as geodatabase design, programming (R and Python), and systems (ArcGIS, QGIS) were surveyed • Research topics included slope characterization of trail networks, least-cost path analysis in both land-based and maritime study areas, watershed analysis • Thesis topic was “Building Better Species Distribution Models with Machine Learning: Impacts of Covariate Scale and Model Tuning on Maxent Modeling”, demonstrating the need to properly configure species models and assess the appropriateness of model resolution choices CASS KALINSKI KEY PERSONNEL 37 GCS GCS | CITY OF BOZEMAN RFP RESPONSE | kEY PERSONNEl EMPLOYER POSITION/TITLE DATES GCS Software Developer Sep. 2020 - Present Adobe Systems Sr. IT Manager Chief of Staff for VP Global IT Business Services Sr. IT Manager, Portfolio Management Office 2011 - 2017 Cisco Systems Sr IT Manager, Customer Order and Value Chain: Project Delivery Office Sr. IT Manager, Technical Services: Project Delivery Office Sr. IT Manager, Finance Applications 2007 - 2011 Levi Strauss (LS&CO.)Sr. IT Manager, Application Services 2003 - 2007 3Com Corporation Sr. IT Manager, Sales and Service Logistics Applications 2002 - 2003 Palm Inc. Sr. IT Manager, Supply Chain Applications 2000 - 2002 In addition to his GIS education, Cass has extensive and varied work experience, from roles encompassing software engineering management, IT operational management, and integration software development, to roles in system implementations. His prior experience also includes operational, non-IT roles in production control, manufacturing, distribution, and warehousing. WORK HISTORY CASS KALINSKI SENIOR GIS ANALYST AND SOFTWARE DEVELOPER KEY PERSONNEL GCS | CITY OF BOZEMAN RFP RESPONSE | kEY PERSONNEl GCS 38 Tory joined GCS in 2013 as a systems engineer. He is a technical professional with over a decade of experience in software development, testing, administration, and networking. He has worked extensively with coding solutions in Javascript and PHP, has done custom scripting in Perl, and has maintained online ticketing solutions with Microsoft SQL and HTML components. His experience in Amazon Web Services (AWS) and other web service platforms enabled his projects to find createive, stable solutions to supplement infrastructure and functions that were not yet readily available. His cloud computing experience, with Microsoft Azure, HPC, and AWS, continue to benefit GCS clients throughout the custom solutions development process. ACCOMPLISHMENTS Highlights Education Years of experience: 15 Software Engineer with knowledge of client/server, mobile, and cross-platform app development. Cloud deployment experience Studied Computer Science at University of Montana • Key developer in Upstream Health - IBM Watson integration. Reponsible for building the web app to interface with Watson via queries, and to populate Watson with necessary data, compiled from sources like PubMed. • Built front-end webmap for NextGen Cruiser, where customers can set up Timber Cruises, and run reports gathered against date gathered during the cruise in Collector • Maintained legacy system Recreation Lease Management (RLM) system for Weyerhaeuser • Created the public facing interactive webmaps for RLM, used to search, display, and sell recreation access leases/permit area access • Maintained legacy system and helped with modernization effort for Weyerhaeuser’s Parcel to Market app (P2M), with a focus on integrating ArcGIS webmaps into Microsoft Dynamics 365 pages and forms. • Responsible for deployment efforts and documentation for Weyerhaeuser’s test environment. • Assisted with infrastructure tasks, including: spinning up new servers, installing services, to facilitate Weyerhaeuser’s migration efforts from on-premises servers to cloud-based data storage. • Assisted in migration of PIAL’s insurance calculator app from Bing maps to a Portal for ArcGIS platform. Certifications Microsoft Certified Solutions Developer - New Horizons Training Center WORK HISTORY EMPLOYER POSITION/TITLE DATES GCS Systems Admin, Software Developer 2013 - Present SameSky Systems Systems Engineer, Consultant 2011-2012 Skytics, LLC Software/Systems Engineer 2009-2012 EDSD, LLC IT Consultant 2007-2008 Education Logistics, Inc.GPS Implementation and Support 2006-2007 Intralogix Consultant 2004 TORY WEBER SENIOR SOFTWARE DEVELOPER KEY PERSONNEL GCS | CITY OF BOZEMAN RFP RESPONSE | kEY PERSONNEl GCS 39 TECHNICAL CAPABILITIES Programming Languages: • Proficient in: PHP, JavaScript and various frameworks (jQuery, Dojo, Angular, 1.x/2.x, Apache Cordova/PhoneGap), SQL, HTML, Java, C# (asp.net/.net core, cross-platform apps) • Familiar with: C/C++, Perl, Shell Scripting, VB Software and Technologies: • ArcGIS products: ArcGIS Desktop, ArcPro, ArGIS JavaScript API, Web AppBuilder, ArcGIS Server, Portal for ArcGIS • Android Studio • VMWare/Hyper-V desktop and server-based virtualization products: Esxi/vSphere server, vCenter server, Workstation, Hyper-V Hypervisor • Database: MySQL, Microsoft SQL Server (Amazon RDS & Standalone) • Web Services: LAMP Stack, IIS, FTP, RADIUS, Email • IDE: Eclipse, Visual Studio, NetBeans • QR code: Generation/Validation • Networking: network Admin, Domain/DNS Admin, RADIUS, VLANS, wiring • Other: 3D modeling/Animation software (maya, 3DSMax), Photoshop Hardware: • Cloud Systems: Amazon AWS (EC3,S3, Route 53), Windows Azure, Private Clouds (AppCore, Nimbula) • Networking; LAN/WAN, Routers, Switches/Hubs (managedand unmanaged), Wi-Fi • Other: GPS, Scanners (barcode/Qr), Mobile (tablet/phone) TORY WEBER SENIOR SOFTWARE DEVELOPER KEY PERSONNEL GCS | CITY OF BOZEMAN RFP RESPONSE | kEY PERSONNEl 40 GCS John is a highly-credentialed, Senior Software Development professional who joined the GCS team in 2016. GCS clients benefit from his extensive expertise in full stack software development. He’s held a key role in several projects with GCS, creating innovative solutions for back-end software infrastructures and their associated user interfaces. ACCOMPLISHMENTS Highlights Education Years of experience: 6 Full Stack Web Developer Bachelor of Science in Civil Engineering from Montana State University - 3.31 GPA Master of Science in Computer Science from Montana State University - 3.91 GPA Certifications EIT License from the National Council of Examiners for Engineering and Surveying (NCEES)• Developed report generator and browser UI for Agren’s (now Land ‘o’ Lakes) Pond Builder, Wetland Builder, and Basin Builder apps • Maintained backend infrastructure/created UI for Montana DNRC’s NextGen Cruiser • Assisted with Montana DNRC’s Survey123 integration, culminating in development of FMBPro app • Contributed to UI work in various projects for OmniTRAX, in addition to building a report API and various configurable dashboards • Built Version 2 of ISRB’s Protection Class Calculator • Created a rudimentary fallback geocoder for addresses that cannot be geocoded within ArcGIS EMPLOYER POSITION/TITLE DATES GCS Senior Software Developer Apr. 2016 - Present Montana State University Networks Lab Research Assistant Apr. 2014 - Aug. 2016 WORK HISTORY TECHNICAL CAPABILITIES Main programming languages: • C#, Python, JavaScript Secondary programming languages: • Java, Perl, R, C++ Experience with: • AWS, MS SQL Server, PostgreSQL, MySQL, HTML, CSS JOHN MCINTOSH SENIOR SOFTWARE DEVELOPER KEY PERSONNEL 41 GCS GCS | CITY OF BOZEMAN RFP RESPONSE | kEY PERSONNEl Kyle is a full stack web developer and a recent graduate of the University of Texas at Austin’s Computer Science program. He joined GCS in 2019. He has a strong background in database development and data mining, in addition to expertise in producing compelling data visualizations. GCS clients benefit from Kyle’s ability to find creative solutions to complex problems, and to derive significant insights from complicated datasets. ACCOMPLISHMENTS Highlights Education Years of experience: 1+ Full Stack Web Developer Bachelor of Science in Computer Science from the University of Texas at Austin • Assisted in the delveopment of a network enumeration tool to scan and analyze thousands of hosts and devices across the UT campus to evaluate potential network vulnerabilities. The tool produced graphs and visualizations to describe the data. • Data mined over one million construction permit records for the city of Austin to deduce trends about the construction of business and real estate in the city over time • Developed UI for calculating and displaying KPIs in the OmniTRAX OAMA web app and crunched data to populate the KPIs • Developed backend infrastructure for OAMA, including writing SQL queries to hosted feature layers in ArcGIS server, according to user specifications EMPLOYER POSITION/TITLE DATES GCS Software Developer Nov. 2019 - Present ArtStartArt Student Advocate Intern Jan. 2019 - Nov. 2019 WORK HISTORY TECHNICAL CAPABILITIES Programming Languages: • Java, C/C++, C#, Python, JavaScript, Swift Software and Technologies: • Database: MySQL/SQLite, Google Firebase, SQL Server • Operating Systems: Windows, Linux, macOS • Mobile: iOS, Android • Data Mining: pandas, Jupyter Notebook, scikit-learn • IDE: Visual Studio, Xcode, Android Studio • Networking: nmap, WireShark, Metasploit, Burp Suite KYLE MCCARVER SOFTWARE DEVELOPER KEY PERSONNEL GCS GCS | RFP 2021-0012lS4 RESPONSE | kEY PERSONNEl 42 Highlights Years of experience: 3Full Stack Web Developer Education Bachelor of Science in Computer Science from the University of Arizona, 2019 Graduated Magna Cum Laude with 3.85 GPA Awards University of Arizona Wildcat Excellence Award Scholarship, 2015 U. S. Army Reserve National Scholar Athlete Award, 2015 Garrett is a full stack software developer who joined the GCS team in February 2020. During his time at GCS he has contributed to several key projects. GCS clients benefit from his attention to detail, and his ability to find creative solutions to complex problems that arise during the development process. ACCOMPLISHMENTS • Worked in the agile development process to develop a back-office recreational lease/permit management portal for Weyerhaeuser employees • Developed a membership solution for Whacking Fatties, allowing for the acceptance of customer payments and the restriction of various features to members only • Contributed to the design and development of the upcoming GeoBusiness Field Delivery Solution, with specific focus on UI • Facilitated the integration of ArcGIS geospatial capabilities into NetSuite with the goal of streamlining customer field operations TECHNICAL CAPABILITIES Programming Languages: • Proficient in: Java, JavaScript, HTML, CSS, AngularJS, ASP.NET Web API, C# • Familiar with: C, Haskell, Prolog, SuiteScript 2.0 Software and Technologies: • Database: SQL Server Management Studio, Oracle • Operating Systems: Windows, Linux • IDE: Eclipse, Visual Studio, Git, Azure DevOps WORK HISTORY EMPLOYER POSITION/TITLE DATES GCS Software Developer Feb. 2020 - Present University of Arizona Facilities Management Student Web Applications Developer Aug. 2016-2019 NPL/Centuri Construction Group Intern - Application Development Jun. 2015 - Aug. 2016 GARRETT SEALE SOFTWARE DEVELOPER KEY PERSONNEL GCS | CITY OF BOZEMAN RFP RESPONSE | kEY PERSONNEl GCS JERIS MANNING SOFTWARE DEVELOPER 43 Highlights Years of experience: 1+ Full Stack Web Developer Education Full Stack Web Development Program Graduate - Lambda School Bachelor of Science in Marketing & Media Arts from the University of Montana Jeris is a graduate of Lambda School’s full stack web development program. His background in digital art and marketing complement his technical knowledge of the modern web app ecosystem. His passion for creative problem solving and tackling complex logic puzzles have honed his ability to approach solutions with multiple perspectives considered. ACCOMPLISHMENTS • Lead programmer on an app allowing users to create t-shirts with custom graphics and configurations, produce them to order, have them shipped, and make payments all within a single interface • Developed route mapping display for forthcoming GeoBusiness Field Delivery application • Developed interface to display data from over 100 Montana streams as part of the browser-based StAGE application for the Montana Department of Natural Resources, with thousands of data points, allowing for monitoring current conditions or viewing graphs of data over longer periods of time TECHNICAL CAPABILITIES Programming languages: • JavaScript, Python, PHP Software and technologies: • Database: PostgreSQL/SQLite, Knex.js • Frameworks/Libraries: React.js, Redux, Angular, Node, Express • Design: Adobe CC • Web-Animation: Adobe After Effects with bodymovin/lottie plugin WORK HISTORY EMPLOYER POSITION/TITLE DATES GCS Software Developer Aug. 2020 - Present FPA PROJECT ROLE KEY PERSONNEL 44 GCS GCS | CITY OF BOZEMAN RFP RESPONSE | kEY PERSONNEl GCS Tara joined GCS in 2019. She is an experienced customer service and sales professional with a variety of analytical, technical, and creative skills. She graduated summa cum laude from Simmons University with a dual degree in History & East Asian Studies, and a minor in English. She won several awards for her academic work, and was recognized in previous roles for her contributions in establishing new department-wide business processes. She’s involved in several projects at GCS, from sales and marketing, to creation of brand collateral, to simple user interface design/Python-based dataset manipulations with ArcGIS Online and ArcGIS Pro. Tara is able to occupy multiple roles, and transitions seamlessly from customer- facing sales activities to backend product development tasks as needed. GCS clients benefit from her dedication to customer service, her attention to detail, and her creative problem-solving skills in various business activities. ACCOMPLISHMENTS Highlights Years of experience: 4 Sales and customer service professional Technical and creative writer Education Bachlelor of Arts in History and East Asian Studies with an English Minor from Simmons University, GPA 3.99 Awards Henry Halko Award for Achievement in History - Simmons University, 2012 Award for Excellence in Customer Service - Zoetis, 2017 During her time at GCS, Tara has designed user dashboards based on NetSuite roles, using ArcGIS Operations Dashboard, for GeoBusiness marketing activities. She updated hosted feature layers in ArcGIS online to populate the dashboard KPIs with data. She was tasked to create realistic data to display GeoBusiness’s capabilities to potential clients, and achieved that goal by manipulating and perfecting the dataset with Python, ArcPro, and ArcPy methods. She has also developed marketing content for GCS, including: writing promotional content for GeoBusiness, creating profiles on past projects, and designing graphics to publish on the GCS website. Currently, she is assisting in developing client and partner relationships for GeoBusiness, and continuing her efforts to promote the company through compelling written content and social media marketing. TECHNICAL CAPABILITIES Software and Technologies: • Graphic design and web publishing: Adobe Creative Suite, WordPress • CRM/ERP: SAP, Zoho, NetSuite, and Salesforce • Spatial: ArcGIS Online, ArcGIS Pro • IDE: Visual Studio, Jupyter Notebooks Programming Languages: • Familiarity with Python Certifications TARA WASTART SALES & MARKETING ASSOCIATE KEY PERSONNEL 45 GCS GCS | CITY OF BOZEMAN RFP RESPONSE | kEY PERSONNEl 45 EMPLOYER POSITION/TITLE DATES GCS Sales & Marketing Associate 2019 - Present File Savers Data Recovery Content Writer May 2019 - Aug. 2019 Zoetis, LLC Poultry Account Specialist 2016 - 2018 Zoetis, LLC Veterinary Customer Service Representative (Billing Focus) 2015 - 2016 Tara occupied a customer service role at Zoetis in Exton, PA, where she created training collateral, and presented to co- workers regarding new critical business processes related to billing and invoicing. She was promoted, and tasked to collaborate with other team members in creating a new customer service department for high-value agricultural customers. She participated in documentation for product allocations and assisted executives in handling critical product shortages. TARA WASTART SALES & MARKETING ASSOCIATE WORK HISTORY KEY PERSONNEL 46 GCS GCS | CITY OF BOZEMAN RFP RESPONSE | kEY PERSONNEl 46 Mike BeltzPresident Fred SpataroVice President of SolutionsJohn WatermanCTO Tara WastartSales & Marketing Associate Tory WeberSenior Software Developer Jay Egenhoff Senior GIS Analyst Garrett Seale Software DeveloperJohn McIntoshSenior Software Developer Kyle McCarver Software Developer Jeris ManningSoftware Developer TECHNICAL STAFF & DEVELOPMENT TEAM SALES & CUSTOMER SUPPORT PROJECT MANAGERS Cass Kalinski Senior GIS Analyst KEY PERSONNEL ORGANIZATIONAL CHART 47 GCS COST PROPOSAL GCS | CITY OF BOZEMAN RFP RESPONSE | GCS | CITY OF BOZEMAN RFP RESPONSE | GCS anticipates approximately 200 hours to complete the scope of work. Our team uses a flat-blended rate for all personnel. The GCS cost proposal is $30,000 Fixed-Firm Price (FFP) to deliver on the City of Bozeman GIS Data and Database Architecture and Data Maintenance Health Check. Appendix B NONDISCRIMINATION AND EQUAL PAY AFFIRMATION ____________________________________(name of entity submitting) hereby affirms it will not discriminate on the basis of race, color, religion, creed, sex, age, marital status, national origin, or because of actual or perceived sexual orientation, gender identity or disability and acknowledges and understands the eventual contract will contain a provision prohibiting discrimination as described above and this prohibition on discrimination shall apply to the hiring and treatments or proposer’s employees and to all subcontracts. In addition, ____________________________________(name of entity submitting) hereby affirms it will abide by the Equal Pay Act of 1963 and Section 39-3-104, MCA (the Montana Equal Pay Act), and has visited the State of Montana Equal Pay for Equal Work “best practices” website, https://equalpay.mt.gov/BestPractices/Employers, or equivalent “best practices publication and has read the material. ______________________________________ Name and title of person authorized to sign on behalf of submitter GCS Holdings, Inc. (d/b/a GCS) GCS Holdings, Inc. (d/b/a GCS) Michael Beltz, President