Uploaded File
add photo
Jay
jaymjohnsonclt@gmail.com
803-431-9975
1133 Catherine Avenue
Chula Vista, CA 91910
Contract GIS Specialist
14 years experience W2
0
Recommendations
Average rating
21
Profile views
Summary

Accomplished project manager focused on leveraging technology for process improvement and new product development initiatives. Over 12 years experience in public accounting with both client service and internal operational focus. MBA, NPDP. Specialties: Project management; process improvement; relationship management; technology strategy.

Experience
Contract GIS Specialist
Information Technology
Mar 2016 - present
  • This project was for the Verizon Data Systems group near Tampa, which handles fiber optic lines between cities rather than the wireless service Verizon is best known for.
  • Calculated the nearest locations of fiber optic network cables and central offices on the national Verizon network to compare it to assets in our recent acquisition, the former XO Networks fiber optic system.
  • Determined specific distances from central offices, cables, and off-network facilities in Seattle and Dallas.
  • This was accomplished using geocoding to assign latitude and longitude to street addresses, and ArcToolbox in ESRI ArcGIS mapmaking software to generate the nearest locations.
  • Microsoft Excel and Notepad were used to work with the dBase and comma separated values formats, in order to create new shapefiles from limited or missing information.
Microsoft Excel GIS ArcGIS ArcToolbox ESRI
Remove Skill
Contract IT Infrastructure Analyst
Information Technology
Jul 2015 - Nov 2015
  • Geospatial system server setup and design for ESRI ArcGIS for Server and Maximo Spatial mapping software products at Duke Energy, a Fortune 250 electric utility.
  • This multi-threaded software was deployed on a VMWare server farm of over 50 virtualized servers.
  • These solutions were developed using an event-driven geoprocessing and ETL system with SQL and stored procedure triggers derived from an IBM Maximo enterprise message service, using a tool built with Java Spring.
  • Oracle on Red Hat Enterprise Linux, Windows Server 2012 and Citrix on 2008 R2 were used to support this Maximo work order system upgrade and the related Maximo Spatial implementation.
  • The project integrates more than 50 technology systems, introduces mobile computing to daily workflow.
  • Android and iOS mobile phones and tablets running on ESRI and IBM platforms are being used to improve data collection.
  • IBM Maximo Spatial is being used to serve ESRI web map services and provide a bidirectional data flow from end users.
  • My team also must integrate GE Smallworld, Intergraph G/Technology, TomTom, and TeleAtlas GIS data.
  • Part of my work on ArcGIS for Server required tuning web map database queries for high performance by altering the map scale and hydrologic data.
  • The web maps were displayed using ASP.NET and Java Runtime.
SQL VMWare Linux RedHat ETL Windows Server Spring Oracle Java iOS ASP.NET Citrix Stored Procedure Windows
Remove Skill
GIS Architect
Information Technology
Jan 2015 - Mar 2015
  • GIS system architecture and design for a large IT service and equipment value added reseller.
  • AOS is an ESRI Silver Partner, with my role being sales of GIS services in the Dallas and Fort Worth region.
  • Unusual service offerings included NG911, E911, and life safety systems for schools and businesses, integrated with Cisco VOIP phones and cameras.
  • Solved problems for state agencies, counties, police departments, and the private sector.
  • We offered JavaScript, .NET and HTML5 programming, Java programming, ArcMap data creation, professional assistance on Oracle and SQL database tuning and database queries, and creating high performance environments for ArcServer and ArcGIS as well as AutoCAD Map.
  • AOS sells, designs, and services EMC, Brocade, and many other large, high performance servers and networking equipment.
  • SharePoint system design was also offered. HP computers were sold in bulk to many companies.
System Architecture .NET JavaScript Java System Design Cisco ArcGIS ArcMap Brocade EMC ESRI GIS Oracle SQL Database Design MS SharePoint
Remove Skill
GIS Developer
Information Technology
Jul 2014 - Jan 2015
  • Python scripting and REST based web map service updates in ESRI ArcGIS for Server for a medium sized right of way consulting firm serving pipeline owners and electric utilities.
  • Used both ModelBuilder and ArcPy scripting in IDLE to accomplish geoprocessing tasks and automate database versioning, map book updates, SQL queries, data driven pages, and web map maintenance.
  • I regularly updated 150 JavaScript based web map viewers within ArcGIS for Server on a SQL Server database.
  • One sample task was the editing of ASP.NET configuration files for web maps.
  • Data was often derived from CAD, KML and Google Earth. Our projects used multiple coordinate systems in various EPSG and WKT formats.
  • We ran five physical and VMWare servers to support right-of-way projects across the United States.
  • Clients included Kinder Morgan, Energy Transfer, TransCanada, Sunoco, Buckeye, and AEP.
  • Map services, geodatabase services, and feature services were updated nightly to reflect the edits of sixteen people based on input from over 600 field agents working with landowners.
  • Mobile maps were supported on iOS phones and iPad tablets for constant use by ROW agents to ensure data quality.
  • This high performance system was expected to have constant availability for engineers, right-of-way staff and landowners, so we had to script maintenance and update tasks for weekends and overnight hours.
Python SQL SQL Server ASP.NET JavaScript iOS VMWare ArcGIS ESRI GIS REST Scripting
Remove Skill
ETL and C# Developer (Contract)
Information Technology
Mar 2014 - Jun 2014
Houston, TX
  • The overall result was to get sixteen large databases arranged to provide content to a reporting system, as well as greater amounts of data exchange.
  • There were servers and data warehouses containing Tobin, LandWorks, MDM, SQL tables and Oracle databases in Windows and Linux environments.
  • FME is a spatial ETL software program for converting over 400 different GIS, CAD, and database formats.
  • It is similar in nature to Informatica or the ESRI Data Interoperability Extension.
  • I completed the transition of ESRI ArcGIS data to SSIS (SQL Server Integration Services) for logging after translation in FME.
  • This was accomplished using REST and SOAP on FME Server.
  • This process allowed us to create coordinate transformations in EPSG and WKT formats, and provide detailed email alerts to map editors and people maintaining each local data warehouse.
  • Our web maps were displayed using JavaScript and ASP.NET.
C# SQL SQL Server Oracle ASP.NET JavaScript ETL SSIS Linux REST Informatica GIS Data Warehousing ArcGIS ESRI SOAP Windows
Remove Skill
GIS Manager (Contract)
Government
Nov 2012 - Mar 2014
Great Lakes, IL
  • Cartographer and GIS lead at Navy Region Midwest in the Regional Operations Center.
  • This was an emergency operations center at the executive level, overseeing 911 and emergency management operations and plans in 12 states.
  • I shared responsibility for public safety emergency response data maintenance, emergency visual messaging, and disaster planning maps.
  • Used idvSolutions Visual Fusion for Silverlight to host web maps using .NET, a SharePoint repository for high performance data storage in KML and Google formats, and ESRI ArcGIS for Server to share data warehouses with the civil engineering and GIS functions of the Navy within NAVFAC.
  • My operation was within another Navy branch called CNIC.
Project Management Data Warehousing .NET GIS ArcGIS ESRI MS SharePoint
Remove Skill
Contract Geospatial Analyst
Government
Jun 2008 - Nov 2012
  • I was responsible for ArcServer and ArcSDE data warehouse maintenance, user support, and interaction with other database and system administrators.
  • AFCENT directly supports airmen at several Air Force bases in the Middle East and Asia.
  • Used and answer questions about ArcGIS 10, AutoCAD Map 3D, and AutoCAD Civil 3D as well as aerial imagery, airfield obstruction, and aircraft parking software.
  • Several coordinate systems and software programs were used.
  • My initial assignment was from July 2008 to June 2011.
  • I was the Whiteman AFB GIS Analyst on base at Knob Noster, Missouri.
  • Created electronic maps, provided ESRI ArcGIS and Trimble GPS user assistance, and provided relational database maintenance on ESRI ArcSDE and ArcServer at Whiteman Air Force Base just east of Kansas City.
  • Air Combat Command GeoBase used a mixture of Bentley MicroStation, AutoCAD Map 2010, and ArcGIS 9.31 from ESRI running on ArcGIS Server in a multiuser relational database via ArcSDE.
  • Oracle 10g was used for our data warehouse which had 17 servers and multiple backups using database replication and SAN network storage.
  • My team of enlisted and civilian personnel helped support many large environmental and real estate initiatives that required considerable adaptability to new software, and readiness for changing tasks and decisions.
Oracle GIS Database Maintenance Data Warehousing Data Replication AutoCad ESRI
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Master's in Geography and Urban Planning
The University of Akron 1997
Bachelor's in Cultural Geography and Theater Arts
Carroll College 1995
Skills
ESRI
2021
10
GIS
2021
7
ArcGIS
2021
6
Data Warehousing
2014
6
Oracle
2015
5
AutoCad
2012
4
Data Replication
2012
4
Database Maintenance
2012
4
ArcToolbox
2021
3
MS SharePoint
2015
2
.NET
2015
1
ASP.NET
2015
1
Microsoft Excel
2021
1
Project Management
2014
1
Scripting
2015
1
SQL
2015
1
ArcMap
2015
1
Brocade
2015
1
C#
2014
1
Cisco
2015
1
Citrix
2015
1
Database Design
2015
1
EMC
2015
1
ETL
2015
1
Informatica
2014
1
iOS
2015
1
Java
2015
1
JavaScript
2015
1
Linux
2015
1
Process Improvement
0
1
Python
2015
1
RedHat
2015
1
REST
2015
1
SOAP
2014
1
Spring
2015
1
SQL Server
2015
1
SSIS
2014
1
Stored Procedure
2015
1
System Architecture
2015
1
System Design
2015
1
VMWare
2015
1
Windows
2015
1
Windows Server
2015
1