Caleb Keener Email & Phone Number

Kingman, Az, Us

Arizona, United States

Responsibilities•Manage Windows servers, SQL databases, and various software systems (ESRI/ArcGIS, EAM, Permits, Utility Billing, SCADA, and Fleet Management)•Design/build geospatial databases for county asset/projects that support versioned editing processes and weekly reconcile/post processes in an SDE database.•Develop and maintain a portfolio of data visualization solutions including public works asset inspections, road maintenance projects, ARPA projects, and the county’s Covid-19 Dashboard•Analyze business processes to optimize performance, integrate systems, and automate data flow.•Provide support, technical guidance, and documentation for all systems and technical solutions for various county departments. Accomplishments •Optimized the Public Works mobile data collection and asset inspection processes, resulting in a 75% increase in efficiency and enabled 4x more assets to be inspected through offline digital data collection using GIS tools•Developed interactive dashboards that enabled real-time analysis of data entry results and increased the efficiency of data flow between the county and the public as well as provided management with KPI’s and metrics to track performance•Reduced county expenditures by over $30,000 in one budget year through the self-implementation of Enterprise Asset Management system functionality and in-house data migration•Developed various web mapping applications using ArcGIS tools, and automated the updating processes using SQL, Python, ArcGIS ModelBuilder, and ETL techniques. This automation reduced the staff's weekly maintenance time by 93.75%•Integrated the county’s Enterprise Asset Management (EAM) System with the GIS System using feature services on the ArcGIS Enterprise Portal that automated data sync/updates between the two systems reducing staff data entry time by over 50%

Kingman, Arizona, United States

Responsibilities•Created and maintained various geospatial databases for county assets and capital project data that was used to create public map viewers.•Conducted version editing of county geospatial datasets on the county’s SDE (spatial database engine)•Managed the Public Works ArcGIS Online content and created web-services, map viewers, and story maps that shared the county’s road maintenance projects with the public.•Performed field data collection using surveying equipment/tools, analyzed and prepared data to be used by engineering staff.Accomplishments•Spearheaded the development of the Public Works Department’s first digital asset inspection process using ArcGIS software and a geospatial database architecture that was configured to allow offline data collection and sync capabilities and supported real-time data processing and visualization for staff members•Developed interactive dashboards that provided real-time analysis of asset inspection results and inspection progress, which in turn increased the efficiency of data flow across divisions of the organization•Collaborated with the road maintenance staff to create the first online road maintenance map that shared with the public a forecast of road maintenance activities that were scheduled to occur on a weekly basis for areas across the entire county.

Associate'S Degree, General Studies, 3.82

Graduated with Honors 2020 Coursework heavily revolved around Business Administration and included the following: -Business Statistics.

High School Diploma