Jay
M. Johnson
OBJECTIVE
I want
to increase user comprehension of electronic maps, while preserving the paper
ones. I hope to set an example for my
peers through great work, excellent attention to detail, and considerable
patience.
SUMMARY
Seventeen years in geographic information
systems and computer aided drafting. Have used ESRI, Bentley, Trimble GPS
devices, Autodesk, Intergraph, Google Earth Pro, and MapInfo products. Also,
once employed as a transportation and land use planner. I have worked on city, state, and federal CAD
and GIS projects in both the public and private sector. My subject matter
expertise is mainly in traffic planning and engineering, railroad surveying,
and electric power transmission and distribution.
SKILLS
GIS data creation, editing, analysis, programming,
and system architecture across several platforms and database types
ArcServer on Oracle 9g and 10g, SQL
Server 2008R2 and SQL Server 2012
FME Desktop, Workbench, and Server integration
with SQL Server Integration Services
REST and SOAP endpoint setup for ESRI
map service definitions and FME transformations
ArcGIS 9.0 to 9.3.1 and 10.0 through
10.3
ArcView 3.0-3.2a, ArcView 2
WindMil2Map, a Java
based mapping tool for electric system models in Milsoft
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 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 and GeoXH, total
station, GPS base station
Python, JavaScript,
and ArcObjects programming for ESRI
Silverlight and Bing
Maps on VisualFusion GIS, on a SharePoint repository using KML, WMS, and the
ArcMap Data Interoperability extension
LINKS
http://www.linkedin.com/in/jaymjohnson1
WORK EXPERIENCE
Alexander Open Systems - Addison, TX -
January 2015 to March 2015
GIS system
architecture and design for an ESRI Silver Partner, with an emphasis on sales
of GIS services in the Dallas and Fort Worth region. Unusual products 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.
Contract Land Staff, LLC Sugar Land,
TX - July 2014 to January 2015
Python scripting and REST based web map
service updates in ESRI ArcGIS 10.2.2 Desktop and Server for a medium sized
right of way consulting firm serving the pipeline industry and electric
utilities. Updated an ESRI Java Flex based web map viewer and ArcServer
ecosystem of five servers to support 150 map services for 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 16 people based on input from over 600 field
agents working with landowners. Mobile
maps were supported on phones and tablets for constant use to ensure data
quality.
Shell - Houston, TX - March 2014 to
June 2014
Contracted developer through Accenture
and Iconma LLC in a software architecture group for an unconventional shale oil
data project. FME is an ETL software program for converting over 400 different
GIS, CAD, and database formats. Completed
transition of ESRI ArcGIS and LandWorks data to SQL Server Integration Services
for logging. This was accomplished using
REST and SOAP on FME to create transformations and user email alerts to map
editors. The project was within a 63
person data integration project in an Agile scrum workflow. Tools included Visual Studio for C#
scripting.
Navy Region Midwest, federal contract
through Capstone Corporation - Naval Station Great Lakes,
IL - November 2012 to March 2014
Cartographer and GIS lead at Navy
Region Midwest Regional (Emergency) Operations Center. Had responsibility for
public safety emergency response data maintenance and disaster planning maps.
Used Visual Fusion for Silverlight for web maps, a SharePoint repository for
data storage, and ESRI ArcSDE to share data with the civil engineering and GIS
functions of the Navy.
AECOM Technology Corporation, federal
GeoBase contract holder- June 2008 to November 2012
June 2012 to October 2012: Dyess Air
Force Base Geographic Information Systems Analyst, which was very similar to
Whiteman AFB below.
July 2011 to June 2012: Database
Operations Lead for Air Force Central Command domestic headquarters at Shaw Air
Force Base in Sumter, SC. Responsible
for ArcServer and ArcSDE 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. We use and answer questions about ArcGIS 10,
AutoCAD Map 3D, and AutoCAD Civil 3D as well as aerial imagery, airfield
obstruction, and aircraft parking software.
July 2008 to June 2011: Whiteman AFB
GIS Analyst on base at Knob Noster, Missouri.
Created electronic maps, provided ESRI and Trimble GPS user assistance,
and provided relational database maintenance 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 10 was also used.
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.
Sargent and Lundy LLC - Chicago, IL -
September 2007 to April 2008
Temporary project employee for
distribution design supporting a new substation planned at the former Stardust
Casino and future Echelon Resort in Las Vegas using Autodesk Utility Design
2006. Also worked on substation wiring revisions for Lousiville Gas and
Electric using AutoCAD 2004, Commonwealth Edison with AutoCAD 2000, and another
design project involving MicroStation v8.
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. 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.
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 ArcGIS 9.1 and IBM CICS mainframe data entry and
quality control, mainly on multifamily housing addresses. 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 secondary, light, or phone
attachments.
Crouch Engineering - Nashville, TN -
September 2005 to December 2005
Drafted in MicroStation on important
Norfolk Southern railway bridge and track projects. Copied and scanned bid sets
for many short line railroads within Tennessee. Detailed office buildings in
AutoCAD.
Tractor Supply Company/Office Team -
Brentwood, TN - June 2005 to July 2005
Responsibilities
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 these stores.
Technician helped a full time CAD expert, the store planning department staff,
and visual merchandisers deal with the project planogram and architectural
workload.
Phoenix Environmental Engineers/Robert
Half Technology - Nashville, TN - May 2005 to June 2005
Worked on some stormwater protection
plans as well as other drawings for a construction project.
R.W. Beck, LLC - Goodlettsville, TN - June
2004 to February 2005
Updated electric utility system maps
using ArcGIS version 9.0, AutoCAD 2004 and Autodesk Map. 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.
State of Tennessee, Department of
Transportation, Structures Division - Nashville, TN - March 2004 to June 2004
Detailed box girder bridges for western
Tennessee highways from scratch using MicroStation J. Revised bridge plans
according to comments from engineers and hydrologists.
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 lines in northern Michigan and Wisconsin using ESRI ArcGIS
8.3 and aerial photographs. Helped
reduce the workload for a web mapping guru, and loaned to Madison area office
to help with MicroStation CAD.
Osmose Utilities Services -
Springfield, IL - February 2002 to June 2002
Collected GPS data in the field for
Ameren UE, a large power company based in St. Louis. 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 GIS staff via FTP.
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;
personally responsible for determining urbanized area extent of Longview-Kelso,
Washington/Rainier, Oregon metropolitan area. Trained in TMODEL traffic
planning software.
Parsons Transportation Group -
Milwaukee, WI - November 1999 to March 2001
Draftsman for traffic volume and flow
studies on behalf of the Wisconsin Department of Transporation, 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 Root River watershed flood control study by Parsons
Engineering Science, on behalf of Wisconsin DNR and Milwaukee Metropolitan
Sanitary District. 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.
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
Portrait Corporation of America -
Concord, NH - January 1999 to June 1999
Took portraits and sold 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.
State of New Hampshire - Concord, NH -
May 1998 to December 1998
Updated town road maps and structure
addresses using MapInfo 4.5. Collected GPS data in rural New Hampshire by truck
for Enhanced 911 agency.
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 Des Moines
Electric.
Akron Area Association of
Churches/CEOSS - Akron, OH - June 1996 to August 1997
Hired as community development intern
for AAAC, then stayed on as newsletter folder and library book organizer for
AAAC and CEOSS, a fundraising organization.
EDUCATION
The University of Akron - Akron, OH
1995 to 1997
Carroll College
January 1991 to January 1995
College of DuPage - Glen Ellyn, IL
1989 to 1992