Sergio Valencia | GIS Portfolio

About Me

I'm a dedicated GIS professional with over 5 years of experience transforming complex geospatial challenges into innovative solutions across utility, architectural, and technology sectors. My expertise spans the full spectrum of GIS development—from advanced spatial analysis and database administration to enterprise application development and automation.

Currently serving as a GIS Developer at PG&E, I specialize in supporting critical Electric and Gas utility operations through sophisticated geospatial analysis, custom web application development, and enterprise system integrations. My technical proficiency encompasses the entire ESRI ecosystem, including ArcGIS Desktop, ArcGIS Pro, ArcGIS Enterprise, and ArcGIS Online, complemented by strong programming skills in Python, JavaScript, and SQL.

What sets me apart is my ability to bridge technical expertise with business impact. I've consistently delivered measurable results, such as enhancing data extraction efficiency by 30% through API optimization, reducing project hours by 20% with custom tooling, and improving data accuracy by 25% through strategic automation initiatives. My experience with cloud technologies like AWS Lambda and proficiency in database management with PostgreSQL enable me to architect scalable, enterprise-grade solutions.

With dual Bachelor's degrees in Environmental Science and Spatial Analysis, plus a Master's in Geographic Information Science from the University of Redlands, I bring both theoretical depth and practical application to every project. I'm passionate about leveraging geospatial technology to solve real-world problems, whether it's optimizing utility asset management, enhancing accessibility compliance, or streamlining complex data workflows.

📄 Download Resume

Featured Projects

Utility Asset Insights Dashboard

Interactive Tableau dashboard showcasing utility asset performance trends, maintenance schedules, and key metrics to support data-driven decision-making.

View Full Dashboard

ProtectedSeas Severity Classification Tool

Python CLI that ingests any CSV, auto-detects Navigator-style attributes, and computes a 0–100 Severity Score using equal weights across detected columns. Outputs a new CSV with a Severity Score column appended (e.g., file_New.csv).

View on GitHub

Geocoding & Reverse Geocoding ETL

Python ETL that batch-geocodes addresses or reverse-geocodes coordinates, with retries, rate limiting, and CSV + GeoJSON outputs.

View on GitHub

Field Data Collection App

Status: In progress

Web app built with Leaflet.js to track field crews collecting utility asset data, syncing with ArcGIS Enterprise.

Live Demo

🏆 Professional Recognition

2025 GIS Employee of the Year - Sergio Valencia

PG&E Geographic Information Systems – 2025 Employee of the Year

Recognized for outstanding contributions to PG&E’s Access Roads Management (ARM) and Defensible Space programs.

Process Automation: Developed Python scripts using arcpy and ArcGIS libraries to automate workflows, improving data accuracy and saving time.
Data Management: Designed and implemented an archive layer for work orders and herbicide application data, streamlining reporting processes.
Workflow Optimization: Optimized a critical Python script to refine Defensible Space reports, ensuring compliance with project requirements while avoiding information overload.
Team Impact: Demonstrated adaptability, problem-solving, and collaboration—enhancing team efficiency and fostering innovation.

Contact

You can reach me at: