Education
California State University, Northridge
Bachelor of Arts in Geography (view)
- Summa Cum Laude (GPA – 3.95)
- Tau Sigma Honor Society (view)
Los Angeles Valley College
- Phi Theta Kappa Honor Society (view)
Relevant Skills
Software
- Esri ArcGIS Desktop
- Esri ArcGIS Pro
- Esri ArcGIS Online
- Esri ArcGIS Collector
- Quantum GIS (QGIS)
- Erdas Imagine
- Microsoft Visual Studio
- JetBrains PyCharm
- Jupyter Notebook
- Adobe Photoshop
- Google Earth Pro
- Microsoft Office
Languages
- English (native proficiency)
- Spanish (conversational proficiency)
Skills
- Vector and raster analysis/processing
- Vector digitizing/editing
- Satellite imagery processing
- LiDAR processing
- Geocoding
- Georeferencing
- Suitability analysis
- Least-cost path analysis
- Spatial interpolation
- Network analysis
- Data management
- Dataset cleaning
- Image editing
- Python scripting
- Basic programming
- Excel, SQL, C#, C++
- Basic web coding
- HTML, CSS, Javascript
GIS Projects
- Awarded Employee of the Quarter (view)
- ArcGIS Online Workshops (Bureau of Ocean Energy Management)
- Proofread final workshop training manuals for two training workshops
- End-user workshop manual – 113 pages
- Technical workshop manual – 253 pages
- Proofread final workshop training manuals for two training workshops
- Aliquot Grid project (phase 1 and phase 2) (Bureau of Ocean Energy Management)
- Served as intern lead and principal GIS technician
- Processed multiple datasets that are currently in use by various agencies for preliminary offshore energy site suitability analyses
- Python – Corrected ID discrepancy across 18,000+ records in a 323,000+ record dataset 1
- Python – Performed multiple field conditional summation of a 323,000+ record dataset 2
- Python – Created a script to generate class limits for a 40-class raster colormap 3
- Python – Performed multiple phase table preprocessing of various point feature classes 4
- Generated FGDC-compliant metadata for multiple datasets
- Produced PowerPoint presentations documenting data processing methodologies
- Fisheries project (Bureau of Ocean Energy Management)
- Served as intern lead and liaison between biology and GIS staff
- Developed biology staff workflow documentation (in conjunction with project manager)
- Python – Created multiple scripts to add various fields to existing datasets (including field domains and default values) 5 6 7 8 9
- Excel – Created dataset attribution and biology/GIS staff work progress trackers
- Los Angeles Urban Forests project (United States Forest Service)
- Served as principal GIS technician
- Aggregated and processed multiple vector, raster, and tabular datasets to be joined to USFS monitoring plots for later analysis
- Python – Created a script to slice census tract values and add sliced values to new fields 10
- PurpleAir Monitor Air Quality project (United States Forest Service)
- Served as intern lead and technical lead
- Python/Pandas – Extracted 5162 unique air quality monitoring device IDs from an R dataset (.rds) containing 21,585,000+ records 11
- Los Angeles Landscape History project (phase 2) (Multi-Institutional Collaboration)
- Served as intern lead and technical lead
- Developed staff workflow documentation for 2nd phase of project work
- Python – Created a script to slice image file URLs from embedded HTML anchor tags in feature dataset table 12
- Excel – Updated GIS staff work progress tracker to reflect 2nd phase of project work
- Geological & Geophysical project (Bureau of Ocean Energy Management)
- Performed archival data transcription to Excel
- Developed Python segment of final Excel data migration workflow documentation which included documentation for Python/library install requirements
- COVID-19 web mapping project (Center for Geospatial Science & Technology)
- Aggregated and processed data for Orange County, CA COVID-19 infections
- Excel – Created spreadsheet with automated statistical calculations which would later be joined to spatial data
- Earth Station Lab online educational pilot project (Polymath Geo)
- Served as principal GIS technician
- Aggregated and processed multiple vector, raster, and remote sensing datasets
- Generated data for import into the WISE learning environment
- Produced imagery and textual content for learning module
- Solar Panel pilot project (Portable Solar, Inc.)
- Served as principal GIS technician
- Aggregated and processed multiple vector, raster, and LiDAR datasets for portable solar panel location suitability assessment
- Camera trap stations location map
- Created a map describing wildlife camera trap locations in the San Francisco Bay Area
- Irrigation mapping project (California State University, Northridge)
- Assisted in mapping irrigation system of university’s 356-acre campus
Personal Projects
- St. Paul, MN neighborhoods georeferencing project
- Georeferenced a PDF map to create a neighborhood boundaries feature class
Programming
Here are some examples of small programs that I have written. Although my main focus is GIS – and I don’t consider myself a full-on software developer by any means – I must say that I do enjoy creating little tools that make my life (or anyone else’s for that matter) a little easier in some way. When time permits I will likely create executables for these and link to them in case anyone else might want to check them out. In the meantime, the GitHub repository links are available so that the source code can be viewed.
Arc Distance Calculator
This is a calculator that I wrote that computes the arc distance of one degree, minute, and second of longitude and latitude from any given latitude (expressed in the user’s choice of miles, feet, nautical miles, kilometers, or meters). The values derived with this calculator are based on the World Geodetic Survey 1984 (WGS84) reference ellipsoid. Importantly, the north/south distance calculations take into consideration the oblateness of the earth due to the centrifugal force exerted by its rotation.
The radii used in the formulas are as follows:
Semi-major (equatorial) – 6,378,137.0000 meters
Semi-minor (polar) – 6,356,752.3142 meters
Written in C# with Microsoft Visual Studio
The GitHub repository can be found here.
Sample Rate Calculator
This was a quick little conversion tool that I created for a friend of mine who works as an audio engineer. The purpose of the converter is to be able to find the sample rate value required to stretch or shrink an audio file so that it matches the duration and pitch of another like audio file. This situation is often encountered in audio post production where PAL (25fps) non-English audio needs to be stretched to match an NTSC (23.98fps/29.97fps) version of the same program material (usually in English).
Written in C# with Microsoft Visual Studio
The GitHub repository can be found here.
Elapsed Time Calculator
This is a calculator I wrote a long time ago and I still use it regularly. Basically, it allows the user to enter start/end times and outputs the elapsed time in both hours/minutes as well as decimal hours.
Written in C# with Microsoft Visual Studio
The GitHub repository can be found here.
Clearance & Shim Calculators
These calculators were also written a while back when I was heavily involved with motorcycles (website to be updated in the near future). They came in very handy whenever I needed to not only perform valve clearance measurements but also to determine the proper size valve shim in the event that valve lash was out of spec.
Written in C# with Microsoft Visual Studio
The web versions of these calculators can be found here.
