Keith Hogsed

Traffic Engineering & Transportation Planning

Challenge: Analyze traffic impacts of new developments and transportation system changes
Skills & Tools: Data collection and industry-specific data analysis tools, Excel
Products: Traffic impact studies and transportation models
Outcome: Local government able to plan for system improvements such as turn lanes and traffic signals and assess proportionate costs to developers

Geographic Information System (GIS) Spatial Analysis

Challenge: Developer sued local government after several permit denials claiming that the local ordinance regarding adult entertainment development was too restrictive
Skills & Tools: Spatial analysis of parcel data using ESRI ArcGIS, Excel
Products: Maps and tabular data
Outcome: It was determined that there were sufficient parcels available meeting ordinance criteria so developer dropped the law suit.

Transit System Passenger Count & Origin-Destination Data Collection

Challenge: Learn transit system operational data formats such as runs & blocks and develop systems to collect count and O-D data
Skills & Tools: Transit operations, field data collection logistics, managed development of data collection tools using handheld computers, data cleaning, data visualization, Excel
Products: Passenger count and O-D datasets
Outcome: Transit agencies were able to use data to meet Federal reporting requirements in order to maintain funding as well as improve operational efficiencies

Manage Manufacturing Company ERP System, Plant Technology & KPI Reporting

Challenge: Support SQL Server-based ERP system for manufacturing plant including reporting; Develop and maintain production tools such as inventory labels; Develop and produce data visualizations for KPIs
Skills & Tools: SQL Server, ProcessPro ERP, Deacom ERP, Zebra Printers, Qlik BI tool, PowerPoint, Excel
Products: Inventory reports, Financial reports, Inventory labels, KPI dashboards
Outcome: Company operations improvements and personnel morale improvements due to increased transparency of production and financial data

Search Engine Optimization (SEO) For Local Small Businesses

Challenge: Assist local small businesses with online visibility
Skills & Tools: Keyword research, competition research, Google Local listings
Products: Provided SEO plans, website creation/updates, Claimed and optimized Google Local listings
Outcome: Online visibility improved due to first position placements in local map searches and multiple top five placements in organic search results

Nonprofit Educational Organization Student & Instructor System Management and Data Reporting

Challenge: Arriving after initial system implementation there was a need for someone to understand the system structure and assist with system troubleshooting and data reporting
Skills & Tools: PowerBI, Excel, PowerPoint, Configio data system
Products: Financial and operational data reporting in the form of tables, graphs and maps
Outcome: Organization now able to depend on internal system support instead of having to wait on vendor support and functional departments are able to regularly review updated operational and financial data that used to be delayed and sporadic.