Solana F. Email & Phone Number

Seattle, Wa, Us

West Chester, Pa, Us

I manage the Data/GIS program for the EPA Region 9 START Contract, covering California, Nevada, Arizona, Hawaii, Guam and the Northern Mariana Islands. Our team works closely with EPA on removals and emergency responses, including spills, terrorist attacks, and federal disasters involving chemical, biological, radiological and nuclear releases.I led the Data Team on the 2020 & 2021 California Fires, Red Hill Drinking Water contamination, Typhoon Mawar, and 2023 Maui Fires responses.

San Ramon, Ca, Us

Leads the development and drives delivery of Digital Initiatives on the CEMREC GIS strategic roadmap. Gathers user stories and develops opportunities to apply GIS throughout the company, from Operational Excellence, Health and Environmental Safety, Legacy Asset Tracking, Environmental Remediation, Beneficial Reuse Opportunities, and Indoor mapping.Provides GIS expertise during requirements gathering with business. Acts as in-house subject matter expert on contracts with numerous consultants. Responsible for design, development, prioritization, and maintenance of CEMREC GIS applications and maps. Provide web-based mapping support, develop spatial and non-spatial databases, and provide technical support to Portal users.

Sacramento, Ca, Us

Lead GIS Analyst at the Oakland Water Resources Department of Wood Rodgers. Provided workflow automation, data manipulation, mapping, and analysis support to the Engineering Team. Developed innovative GIS solutions in a fast-paced consulting environment. Responsibilities included:- Coordinate and schedule GIS tasks for a variety of departments and projects;- Develop solutions using Python, GIS, SQL and Batch File scripting;- Spatial data management using SDE and SQL Server, including connected and disconnected replication;- Design, create and develop spatial datasets and models using GIS, ArcHydro and inputs for ICM;- Create tools for workflow automation;- Perform data conversions;- Create and publish maps;- Assist with development and submission of proposals;

San Francisco, Ca, Us

Lead position for GIS Data Organization at MTC. First point of contact for GIS data requests from the public and internally. Manages users and roles in SQL Server, maintains data on multiple Amazon Cloud servers, ensures the upkeep of metadata, designs system architectures, and assists with back-end database design for webmaps. Automated the sorting, merging, and importing of large updates of TomTom basemap data into SQL Server using batch files and ArcPy. Created a GIS Inventory that catalogues all map services/layer files/datasets we have in our distributed geodatabases using Python and SQL. Worked with a developer to design a clean front-end interface for the Inventory. The website allows users to search everything in the Inventory, add search results to ArcMap/AGOL, and view and update the metadata. Implemented full text searching on the metadata to enable a Google-like search for users Developed a Regional Parking Database to collect parking regulation and occupancy data for each block face in the Bay Area. Published Collector App for field crew to update parking occupancy data from the field. Developed the Regional Transportation Plan Database for the 2017 RTP. Maintained the development, test, and production databases for the Call for Projects website.

Built mapping classes in PHP for import into Postgres PostGIS database. Updated code in Flex to allow Cartograph's map viewer to handle display of DigiGlobe imagery. Worked with ESRI Flex API to pull in basemap for map viewer and obtain digitized coordinates for online digitizing.

Currently studying how to model light and shadow, building constructs for figure drawing, and abstracting shapes to get a better likeness using graphite and carbon. Working up to realist oil painting.

I was in charge of seeding, transplanting, watering, fertilizing, harvesting, storing, bouquet-making and selling at Tierra Madre Farms.I also started serious studies in realist painting.

Santa Barbara, Ca, Us

GIS Analyst doing cadastral mapping in AutoCAD and ArcGIS. Processed lot-line adjustments, subdivisions, and other parcel changes in AutoCAD. Incorporated changes into GIS Parcel Base. Became interface between IT and non-technical staff. Automated processes with VBA and Python. Verified Legal Descriptions of parcels. Did Elections, Special District, and Emergency Fire mapping. Secretary of California Cadastral Mapping Association (CCMA), 2010.

Corte Madera, Ca, Us

San Francisco, Ca, Us

Taught employees how to use ArcGIS 8.1 software for non-profit housing development, planning, and tenant organizing. Developed the Center's GIS database using Census data, centerline data and cadastral data from the City of San Francisco's DTIS. Created several maps and wrote a report on how non-profit community development agencies in San Francisco could use GIS for grant-writing, community planning and organizing, and affordable housing development.

San Francisco, Ca, Us

Applied Data Science Certificate, Data Science, Machine Learning

B.A., Geography

Gis Certificate Program

Education record