Jay M. Johnson

*** ****** **** **. ***. S**

Chula Vista, CA 91910

E-mail: ad373j@r.postjobfree.com

Home phone: 858-***-****

Cell phone: 803-***-****

Work Experience:

GIS Consultant

Speridian Technologies subcontract for RESPEC Company LLC contract

December 2022-present

Remote

Helped the State of New Mexico Department of Information Technology respond to broadband map improvements requested by the Federal Communications Commission. Internet service providers, states, and cities were asked to provide more accurate data for the FCC National Broadband Map. This data will soon be used to allocate $42 billion of Broadband Equity, Access and Deployment funding to improve internet speeds in rural and other unserved and underserved areas. Each state serves as the intermediary between the FCC and internet service providers. Tools used included QGIS 3.30.1, ArcGIS Pro 3.1.3, ArcGIS Online and Jira.

GIS Analyst

Quartic Solutions

May 2022-November 2022

San Diego, CA

Developer for City of San Diego GIS projects under a city IT contract. Worked on ESRI ArcGIS Enterprise to create and maintain web services on REST endpoints in Portal and ArcGIS Online, as well as geoprocessing tools. Created and improved tools for transferring data using an ETL process from GIS to fire and police dispatching software and retrieved data from drafting systems for water and sewer projects. Worked with Oracle Spatial Studio to create web maps.

GIS Analyst

Ampcus Corporation

July 2021 – April 2022

Remote

Working on an update to the Santa Clara County 911 dispatch system, which uses Hexagon and ESRI technology. Corrected address data in HERE street address data as well as county government road centerline and addressing data. Created new or updated GIS data sets for inclusion in the dispatch system. Examples include tow truck dispatching, points of interest, sheriff patrol beats for regular and county park dispatch responses, medical helicopter response zones, and hospital location data. ESRI ArcGIS 10.6.1 and ArcGIS Pro 2.7 software are used to edit data for inclusion in the Hexagon system.

GIS/BIM/CAD Technician III

MARRS Services, Inc.

Nov 2020 – July 2021

San Diego, CA

Updated airport maps in ESRI ArcMap 10.8 and ArcGIS Pro 2.5, as well as floor plans and site plans in AutoCAD 2020 and Autodesk Map 2020 at San Diego International Airport. The San Diego County Regional Airport Authority plans several improvements such as a terminal replacement, relocation of the administrative offices, aviation fueling, and cargo areas, and many other improvements which require both routine and special mapping and drafting tasks. This role requires coordination with staff from multiple civil engineering and construction firms in a joint venture, as well as representing the needs of a public sector agency running the largest single runway airport in the United States. My projects so far: an airport landscaping map book, a web map of all historical projects since the era when the airport terminal was initially constructed, and multiple aviation security map and drawing requests. Oracle Spatial Studio was used to create web maps.

GIS Technical Lead

Infosys

Sep 2020 – Nov 2020

Atlanta, GA

Supported a natural gas survey mobile application meant for natural gas leak detection. Southern Company Gas, Nicor, Virginia Natural Gas, and other companies in the Southern Company portfolio were our clients on this project. Infosys has provided GIS programming support to Southern Company, as well as similar power and natural gas companies for many years. This project was in Xamarin Forms, which is a JavaScript toolset. Xamarin is a Microsoft product which allows for mobile development to happen in Android and iOS at the same time, rather than sequentially. This app is meant as a homemade replacement for a Geocortex licensed tablet and mobile GIS application.

GIS Analyst

Crescens, LLC

Raleigh, NC

January 2018-September 2020

Served as geographic information system business analyst, developer, and trainer on a renewable state contract for the North Carolina Department of Information Technology, in the spatial analysis group of the transportation GIS unit. I specialize in transportation planning data and traffic forecasting. I also map scenic byways, honorary road names, and DMV offices. This data is contained in public facing web maps using ArcGIS Online at https://ncdot.maps.arcgis.com/. Comprehensive transportation plan updates and statistical analysis of Title VI map requests for civil rights compliance were some past transportation planning projects. NCDOT uses ArcGIS 10.5.1, ArcGIS Pro 2.5, QGIS 3.8, Excel, ArcGIS Online, Python, JavaScript, and other related software for editing, analysis, and scripting. I am working on ArcGIS Desktop with both ArcGIS Pro and ArcMap 10.5.1 to develop a plan for switching our whole staff to ArcGIS Pro, as well as supporting QGIS and other platforms.

GIS Analyst and Developer

Spotlight, LLC

Pittsburgh, PA

July to November 2017

I worked onsite at our client EQT Corporation, a large natural gas exploration and production company in Pittsburgh. My primary assignment was with a statement of work and determining steps of the project in Navigator for ArcGIS and ArcGIS Pro. We were creating a tracking and routing system for trucks using Network Analyst and Street Map Premium in ArcGIS Pro, alongside ArcGIS for Server data of our access roads and gravel driveways to wellhead sites on private land. Created Python scripts for automation and testing of ArcGIS Desktop and Server. We tracked waterfall and Agile projects using JIRA and ServiceNow. The team was cross-functional and we often exchanged staff or had Scrum meetings. We solved projects and help desk tickets related to application installations of geospatial software. We used PowerBI to create maps. Change management of ArcGIS Server 10.2.2 and ArcGIS Desktop 10.2.2. Created database schema comparison to prepare for a merger of two ArcGIS databases using the APDM model. SDLC was at the development and testing stages here as it was a pilot project for Greene County, Pennsylvania.

GIS Architect

HCL

Fort Worth, TX

November 2016 to July 2017

This project was for the Burlington Northern Santa Fe Railway at their corporate headquarters in Fort Worth. The railroad is combining two independently developed GIS systems into one enterprise architecture using the ESRI ArcGIS platform as well as FME from Safe Software. This project was developed using the Agile scrum methodology, which is the BNSF standard for all GIS projects, non-spatial coding, databases, and infrastructure projects. One pilot project was an effort to use Navigator for ArcGIS to develop a mobile navigation system for corporate insurance investigators, who must drive to derailments across 32,500 miles of track in 28 states and 3 Canadian provinces. This mobile platform allows BNSF to combine commercially available map data and aerial photographs with our private roads alongside rail corridors. Mobile map packages were created using ArcGIS Pro 1.4 and ArcGIS 10.3.1 to allow data compression of several gigabytes of routable networks and company railroad track data into a reasonable size for use on iOS and Android phones and tablets. This data was stored for user download on ArcGIS Online for use within the company. Other tasks involved refinement of a series of FME scripts allowing ETL updates of both spatial and non-spatial databases through ArcGIS Online. Some scripts read from SharePoint as a source, while others were from Oracle or DB2. FME is a spatial extract transform load system that is popular within the spatial data community. FME technology is incorporated into many other commercial ETL programs such as the ESRI Data Interoperability Extension and spatial data transformations within Informatica. ArcGIS Pro is a .NET replacement for ArcMap, which BNSF uses on DB2, SQL Server, Oracle, and graph databases. ArcMap is not multithreaded and runs on only one core due to being written in C# with .COM objects.

GIS Specialist

Primus Software

Temple Terrace, FL

February-March 2016

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. I 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. This waterfall pilot project determined specific distances from central offices, cables, and off-network facilities in Seattle and Dallas. I used QGIS 2.18 to add in HTML links from a CAD system that would not display properly in ArcMap attribute tables as a hyperlink. It was in the early phase of gap analysis. This project 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 HTML source data.

GIS Infrastructure Analyst

CRG Workforce

Charlotte, NC

July 2015 to November 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. I was responsible for application installations, testing, and systems requirement review for 9 developers and answered to a waterfall product owner. 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 Windows Server 2008 R2 were used to support this Maximo workorder system upgrade and the related Maximo Spatial implementation calling REST services from Server for ArcGIS and ESRI ArcMap. The waterfall 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. The 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 by developers using ASP.NET and Java Runtime.

GIS Architect

Alexander Open Systems

Addison, TX

January 2015 to March 2015

As an architect I was responsible for GIS system architecture and design for a large IT service and equipment value added reseller. AOS was an ESRI Silver Partner, with my role being sales of GIS services in the Dallas and Fort Worth region. Our service offerings included NG911, E911, and life safety systems for schools and businesses, integrated with Cisco VOIP phones and cameras. We wrote statements of work, found gaps in existing IT systems, and solved problems for state agencies, counties, police departments, and the private sector. We offered systems requirement review services to clients for JavaScript, .NET and HTML5 programming, Java programming, ArcMap data creation, professional assistance on Oracle and SQL database tuning and database queries. We created high performance environments for ArcServer and ArcGIS as well as AutoCAD Map. AOS sold, designed, and serviced 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. AOS5.com

GIS Developer

CLS

Sugar Land, TX

July 2014 to January 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. The developer 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.

FME Developer

Iconma

Houston, TX

March 2014 to June 2014

Contracted ETL and C# developer through Accenture and Iconma LLC in a software architecture group for an unconventional shale oil data warehouse and integration project at Royal Dutch Shell in their Houston area North American IT headquarters. 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. The developer 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.

GIS Manager

Capstone Corporation

Naval Station Great Lakes, IL

November 2012 to March 2014

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. The manager shared responsibility for public safety emergency response data maintenance, emergency visual messaging, and disaster planning maps. Used idvSolutions (now Everbridge) 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.

GIS Analyst

AECOM Technology Corporation

Abilene, TX

June 2008 to November 2012

In the last assignment of three at this company in 2011-2012, the business analyst served as the Dyess Air Force Base Geographic Information Systems Analyst under a federal contract. The duties were very similar to those at Whiteman Air Force Base from 2008-2010, which is described below.

Before that, the analyst was the Database Operations Lead for Air Force Central Command domestic headquarters at Shaw Air Force Base in Sumter, SC from 2010-2011. The analyst 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. Answered questions and provided business analysis using 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. The initial assignment was as the Whiteman AFB GIS business 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. Our 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.

Electrical Distribution Designer

Sargent and Lundy LLC

Chicago, IL

September 2007 to April 2008

Project employee for electric utility transmission and distribution line design supporting a new Nevada Energy substation planned at the former Stardust Casino site in Las Vegas. This was accomplished using Autodesk Utility Design 2006, a third-party extension of AutoCAD functionality. Also worked on substation wiring revisions related to smart grid upgrades for Louisville Gas and Electric using AutoCAD 2004, Commonwealth Edison with AutoCAD 2000, and another design project involving MicroStation v8 for American Transmission Company.

Retail Visual Merchandiser

Set and Service Resources

Milwaukee, WI

April 2007 to June 2007

Reset and rebuilt fixtures, shelving and products at Home Depot, Macy's, Lowe's, K Mart, and grocery stores across the Milwaukee and Chicago areas for a visual merchandising company. This allowed products to be shown at their best.

Outside Plant Technician

Northwind Technical Services

Delafield, WI

February 2007 to April 2007

Drafting and measuring of cable television and fiber projects proposed as additions to electric power lines using Autodesk Map and ESRI ArcGIS software. Used Osmose Ocalc to determine sag, tension, guying, and capacity of power lines before and after proposed additions to the pole. Sought permits for guy wires from municipal public works departments.

GIS Technician

Ideas on Paper

Nashville, TN

January 2006 to January 2007

GIS Technician contracted by a small MBE to work at the Nashville Electric Service GIS and Mapping Department. Added many new subdivisions from AutoCAD files and also scanned and added subdivision data from paper maps. Provided ESRI ArcGIS 9.1 and IBM CICS mainframe data warehouse entry and quality control of the GIS system, mainly on multifamily housing addresses and new subdivisions. Edited maps and mainframe to reflect power poles that had been looked at in the field to see if pole numbers had fallen off and whether each pole had electric secondary, service, light, or phone attachments. Used an Oce copier and plotter to scan drawings from vault files and our work order system, which was in the process of being converted to ArcFM and Eclipse.

CAD Technician

Crouch Engineering

Nashville, TN

September 2005 to December 2005

Drafted in MicroStation CAD software to create data and drawings on Norfolk Southern rail bridges and track projects. Copied and scanned bid drawing plan sets for many short line railroads within Tennessee using a Ricoh plotter and engineering copier. Detailed and drafted office buildings using AutoCAD.

CAD Technician

Office Team

Brentwood, TN

June 2005 to July 2005

Used both AutoCAD versions 2000 and 2004 LT to detail four successive versions of 70 store remodeling projects. The purpose was to expand the equine and clothing departments in several Tractor Supply Company retail stores. Technician helped a full time CAD expert, the store planning department staff, and visual merchandisers deal with the project planogram and architectural workload.

CAD Technician

Robert Half Technology

Nashville, TN

May 2005 to June 2005

Worked on stormwater protection plans at Phoenix Environmental Engineers in Nashville, as well as other drawings for a construction project using Autodesk AutoCAD software.

CAD Technician

R.W. Beck, LLC

Goodlettsville, TN

June 2004 to February 2005

Updated electric utility system map data using ESRI ArcGIS version 9.0, AutoCAD 2004 and Autodesk Map. This data maintenance work was done for electric cooperatives and other small cities. Revised electric utility substation drawings in Bentley MicroStation v8, along with associated scanned drawings using Bentley I/RAS B. Clients included National Grid, Puget Sound Energy, and the City of Banning, California. A technician was sent on loan to Florida with short notice to supervise cleanup of hurricane debris for the City of Orlando. We used several GIS software programs including Partner Software and WindMil2Map, which are both Java based GIS systems.

CAD Technician

State of Tennessee, Department of Transportation, Structures Division

Nashville, TN

March 2004 to June 2004

Detailed and drafted box girder bridges for western Tennessee highways from scratch using a CAD software program called MicroStation J. Revised bridge plans according to comments from civil engineers and hydrologists.

GIS Analyst

Safe Harbor Group

Nashotah, WI

June 2003 to September 2003

Contract employee at American Transmission Company in the real estate department. Finished mapping of high voltage electric power transmission lines in northern Michigan and Wisconsin using ESRI ArcGIS 8.3 and aerial photographs to populate a data warehouse that helped my team create web maps. These maps led to the successful construction of over $10 million worth of badly needed electric transmission lines connecting the power grid and plants in Minnesota, Michigan, Iowa, Illinois, and Wisconsin. I was then loaned to the ATC Madison area office to help with MicroStation CAD.

Data Services Foreman

Osmose Utilities Services

Springfield, IL

February 2002 to June 2002

Collected GPS data in the field for Ameren, a large power company based in St. Louis. The data was about electric poles and the attached equipment from the power, cable, fiber optic, and telephone companies. Worked in remote rural areas alone with a Trimble backpack GPS to provide map data to data dictionaries, which were then uploaded nightly to Buffalo area GIS staff at Osmose headquarters via FTP for inclusion in an ESRI ArcGIS database.

Assistant Transportation Planner

Cowlitz-Wahkiakum Council of Governments

Kelso, WA

April 2001 to February 2002

Assistant to regional transportation planning organization for both federal and state efforts to promote intergovernmental agreements on how to best spend transportation tax dollars. The use of highway, rail, pedestrian, and bus funding in southwest Washington required agencies to rate projects in order of priority. Responsible for leadership within five rural counties alongside existing planning manager; and determined urbanized area extent of Longview-Kelso, Washington/Rainier, Oregon metropolitan area. Trained in TMODEL traffic planning software.

CAD and GIS Technician

Parsons Transportation Group

Milwaukee, WI

November 1999 to March 2001

Draftsman for traffic volume and flow studies on behalf of the Wisconsin Department of Transportation, Missouri DOT, Meijer, SuperAmerica, and other clients. Loaned by Milwaukee to draft at the Denver office on a successful bid for Interstate 25 and light rail expansion. Drafting lead for the Root River watershed flood control study by Parsons Engineering Science, on behalf of Wisconsin DNR and Milwaukee Metropolitan Sanitary District. This effort solved 20 years of flooding problems for a large residential area encompassing several cities in southern Milwaukee County. Helped fix problems with ITS system and loop detectors on Milwaukee freeway system by checking actual speeds of vehicles with radar guns as part of a team. Used Bentley MicroStation, ESRI ArcGIS, and traffic modeling software daily, as well as HEC-RAS for stormwater engineering designs.

Office Temporary

York Employment Staffing

Naperville, IL

August 1999 to November 1999

Mailroom clerk and receptionist at Deloitte Consulting, receptionist at Wall-Fill Insulation, and data entry clerk at Hinsdale Hospital.

Retail Portrait Studio Manager

Portrait Corporation of America

Concord, NH

January 1999 to June 1999

Took portraits and sold photo packages to customers in Wal-Mart and K-Mart studios across New York, Vermont and New Hampshire. Provided a day off for other employees by traveling to permanent studios.

Data Control Clerk III, Map Analysis and Review

State of New Hampshire

Concord, NH

May 1998 to December 1998

Updated town road maps and structure addresses using MapInfo 4.5 GIS software for a statewide data warehouse showing every address point and driveway in New Hampshire. Performed client and server maintenance. Collected GPS data in rural New Hampshire using a specially outfitted truck for the state Enhanced 911 agency. Our bureau served as the PSAP (Public Safety Answering Point) for police, fire, and ambulance service several cities across the state, while also enforcing rules and implementing technological improvements to the 911 system at the advent of E911 technology.

GIS Conversion Technician

Analytical Surveys

Waukesha, WI

October 1997 to February 1998

Trained in MicroStation on Clipper UNIX and then used this CAD application in Windows 95. Moved attributes derived from GPS data stacked up on one X, Y location of a power pole to a cartographically logical position on maps for inclusion in the Des Moines Electric GIS system.

EDUCATION

Master of Arts

Geography

The University of Akron

Akron, Ohio

1995 to 1997

Bachelor of Science

Geography

Carroll University

Waukesha, Wisconsin

1991 to 1995

Naperville North High School

Naperville, Illinois

1987 to 1991

Diploma

PUBLICATIONS

Johnson, J., & Costa, F. (March 1st, 1998). Hindu Temple Development in the United States: Planning and Zoning Issues. Journal of Cultural Geography, Volume 17, Issue 2, pages 115-123.

Contact this candidate