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

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.

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.

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