John Welsh Email & Phone Number

Rocklin, California, United States

• Create Aquatic Resource Delineation, Impact, NWI, Soil, Habitat Conservation Plan, Vegetation/Land Cover, Arborist/Nesting Bird/Plant Survey Results, Cultural maps, and more.• Convert CAD to GIS. • ArcGIS Online (AGOL), Field Maps, XTools Pro. • Process and visualize UAS flight log CSV data (Photo Location and Direction map, Video Flight Path map).• Remote Pilot Certified (Part 107).

San Ramon, California, United States

• Cartography - project site maps including CNDDB Plant & Wildlife, National Wetlands Inventory, spotted owl, and soil types within a specified radius. • Spatial Analysis - analysis of gas pipeline and areas of interest including lakes, rivers, groundwater, soil, vegetation, fault zones, parks, and more for the entire state of California.• CZU Lightning Complex wildfires - GIS data management and quality control of Best Management Practices (BMPs) to protect water quality using applications including Survey123, ArcGIS Online, Google Earth Pro, Avenza, and Wildnote. • Trimble GNSS handheld, TerraSync, and Pathfinder Office.• Stormwater inspection of PG&E work sites, city businesses, and home builder sites. • Environmental inspection of PG&E electrical work sites involving stormwater and wetland monitoring.• Vegetation Management and BMP surveys in the field using Survey123.

Sacramento, Ca

Sacramento, Ca

Sacramento, California, United States

Habitat Conservation Planning Branch (HCPB) Project:• Mapped project sites that required Incidental Take Permits (ITPs) under the California Endangered Species Act (CESA).• Examined documentation of the project location, description, and the impacted species.• Georeferenced aerial photos and images to accurately map project sites.• Added attribute data to mapped project sites.Vegetation Classification and Mapping Program (VegCAMP) Project:• Determined vegetation change by comparing current National Vegetation Classification System (NVCS) records for sensitive natural communities to past Holland Classification System records.• Updated attribute data of Holland Classification records.• Summarized classification comparison findings and documented process for employee use.

Roseville, Ca

Historical Imagery Project:• Expanded the City’s aerial image repository by using ArcMap geoprocessing tools to assemble images from various sources.• Uploaded several years of aerial imagery to the City’s Open Data Portal for public use via ArcGIS Online and as REST Services.• Created a layer file of the City’s historical geographic boundaries from 1940 to 2018 for use by City employees. Transportation Improvement Project:• Edited sections of the City’s street and address data by creating a grid to identify specific mapping areas and track editing.• Divided roadways to account for medians, added turn pockets, and created roundabouts. • Added attribute data for new feature records, calculated fields, and updated relationships between feature classes.• Data integrity and quality control performed by validating topology and using ArcGIS Data Reviewer.

San Mateo, Ca

• Worked with customers to present compliance findings, negotiate solutions, and ensure proper compensation to Actuate; earned $700,000 in revenue.• Analyzed complex license and maintenance agreements.• Partnered with Entitlement and Customer Support teams to assemble and analyze data for customer reviews.• Collaborated with Entitlement, Customer Support, License Sales, Support Renewals, Finance, and Legal teams to resolve compliance issues.

Rocklin, Ca

• Managed the entire software license review of partners to ensure compliance with license policies and proper compensation to Oracle.• Negotiated solutions with partners, including C-level executives, to resolve compliance issues; earned $3 million in revenue.• Interpreted complex license and support agreements; educated internal and external customers on license polices.• Evaluated partner’s IT environment and application architecture; analyzed sales activity and support records.• Partnered with License Sales, Support Sales, Business Practices, Executive Management, Royalty Reporting, Order Administration, and Legal teams to complete reviews.

Rocklin, Ca

• Negotiated solutions with partners, including C-level executives, to resolve compliance issues; earned over $1 million in revenue.• Used expert knowledge of Oracle systems to improve license and support report accuracy by 15% resulting in more compliance findings and higher revenue.• Trained and co-managed 7 team members on the license and support report process.• Enhanced the license and support report process by creating a process document, quality assurance checklist, and an online survey for internal customer feedback.• Assisted Principal and Senior License Consultants in performing license reviews.

Rocklin, Ca

• Sold education solutions to inbound customers (approximately 50 calls per day).• Team Lead of Customer Sales Representatives in the Western United States.• Highest sales and customer satisfaction issues resolved in the United States & Canada for 3 consecutive quarters; earned over $100,000 per week in revenue.• Created process that enabled the team to answer 20% more calls per day.

Associate Of Science - As, Geographic Information Systems (Gis)

Bachelor'S Degree, Business Management

Education record