Resume

Sign in

Geographic Information Systems

Location:
Fort Worth, Texas, 76137, United States
Posted:
December 06, 2017

Contact this candidate

Jay M. Johnson

**** ****** ***** ***, ***. ****

Fort Worth, TX 76137

E-mail: ac3mf3@r.postjobfree.com

Phone: (817) ***-****

SKILLS

• GIS data creation, format conversion, editing, analysis, programming, and system architecture across several platforms and database types and data warehouses

• ArcGIS for Server and ArcSDE on Oracle; SQL Server 2008R2 and SQL Server 2012 on Windows Server 2012

• FME Desktop, Workbench, and Server versions 2013 to 2017

• REST and SOAP endpoint setup for ESRI map service definitions and FME transformations

• ArcGIS and ArcMap versions 8.3 to 9.3.1 and 10.0 through 10.4 in ArcView as well as ArcEditor and ArcInfo SQL data warehouses; predecessor software functionality levels in Oracle and of ArcView 3.0-3.2a, ArcView 2 using Access

• ArcGIS Pro versions 1.3, 1.4, 1.4.1 and 2.0 along with Navigator for ArcGIS

• WindMil2Map, a Java based mapping tool for electric system models in Milsoft software

• Autodesk Utility Design, AutoCAD 2000, 2004, 2004 LT, 2006, 2008, and 2009; AutoCAD Map version 5 to 2015, Autodesk Raster Design; server and client installation for 30 users; several non-spatial drafting projects such as BIM, SCADA, and electric substation wiring

• Bentley MicroStation 5.0 on UNIX, 95 on Windows and versions SE, J, v8, and v8 2004

• Intergraph I/RAS B; Bentley IRAS/C and other raster editors

• Trimble Pathfinder Office and updates to mobile devices such as the ProXL, GeoXT and GeoXH on Windows Mobile, total station, GPS base station

• Python, ModelBuilder, ArcToolbox, JavaScript, HTML5, ASP.NET and ArcObjects C# programming for ESRI

• Silverlight and Bing Maps programming and server setup on an idvSolutions product called VisualFusion GIS, on a SharePoint repository using KML, WMS, and the ArcMap Data Interoperability extension

WORK EXPERIENCE

Contract Senior Systems Analyst and GIS Developer

Spotlight, LLC July to November 2017

Worked onsite at our client EQT Corporation, a large natural gas exploration and production company

Created Python scripts for automation of ArcGIS Desktop and Server

Tracked projects using JIRA and ServiceNow

Solved or assigned help desk tickets related to GIS software

Installed 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

Contract 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. 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.

Contract 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. 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.

Contract IT Infrastructure Analyst Geographic Information Systems

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. 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. The team also must integrate GE Smallworld, Intergraph G/Technology, TomTom, and TeleAtlas GIS data. Part of the analyst’s 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.

GIS Architect

Alexander Open Systems - Addison, TX - January 2015 to March 2015

The architect was responsible for 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.

GIS Developer

Contract Land Staff, LLC – 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.

Contract 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.

Contract 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 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.

Contract Geospatial Analyst, United States Air Force, Air Combat Command

AECOM Technology Corporation, Abilene, TX - June 2008 to November 2012

In the last assignment of three at this company, the analyst served as the Dyess Air Force Base Geographic Information Systems Analyst under a federal contract. The duties were similar to Whiteman Air Force Base 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. 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 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.

Visual Merchandiser

Set and Service Resources - Milwaukee, WI - April 2008 to July 2008

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

Contract 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 for Louisville Gas and Electric using AutoCAD 2004, Commonwealth Edison with AutoCAD 2000, and another design project involving MicroStation v8 for American Transmission Company.

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.

Contract 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 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.

Contract 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.

Contract 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. 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.

Contract 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.

Contract 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.

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 KMart 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 the state. 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/Intelligraphics - Waukesha, WI - October 1997 to February 1998

Trained in MicroStation on Clipper UNIX and then used Windows 95. Moved 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

MA in Geography and Urban Planning

The University of Akron - Akron, OH

1995 to 1997

BS in Cultural Geography and Theater Arts

Carroll College

1991 to 1995



Contact this candidate