STEPHANIE SAEPHAN, GISP

Email: 
stephanie@opengislab.com

Website: 
opengislab.com

GISP (#91282) certified professional with 20 years of experience specializing in customized trainings, technical writing, geospatial database design, workflow process development, web mapping applications, spatial analysis, data visualization, and needs-assessment. 

GIS SOFTWARE

  • ESRI Desktop and Server Products (ArcGIS Desktop, ArcGIS Pro, ArcGIS Online, Web App Builder, GeoPortal)

  • QGIS Desktop and Server

  • GeoServer

  • PostgreSQL/PostGIS

  • LizMap Web Mapping Client Application

  • OpenGeo Suite Stack (Boundless)

  • Leaflet

KEY SKILLS

  • Technical Training and Writing

  • Geodatabase Design 

  • Workflow Process Development

  • Cartographic Production and Standards

  • Metadata Creation and Standards (SDSFIE, FGDC, ISO)

  • GIS Needs Assessment

  • Data Interoperability (CAD, LiDAR, KML/KMZ)

  • Remote Sensing and Image Analyses

ACTIVITIES

Board of Directors, Hawaii Geographic Information Coordinating Council (2016 - Current)

Annual GIS Day Volunteer (2016, 2017)

Oahu ESRI User Group Member (2010 - Current)

EDUCATION

University of Hawaii at Manoa, Honolulu, HI
M.S. Botany (2006)          

Clark University, Worcester, MA
B.A. Geography (1997)      

EXPERIENCE

G70 (GROUP 70 INTERNATIONAL)
GIS Lead (4/2012 - Current)

  • Lead in creating, improving, and developing GIS project strategies

  • Manage GIS-based project, write project proposals and scope of work

  • Manage GIS server and provide technical support for 30 users

  • Implement an opensource GIS server stack to create an in-house web mapping application

  • Develop company cartographic standards and GIS manual

  • Customize ArcGIS user interface so deployment of software and updates is consistent for all users

  • Train Environmental Planners, Civil Engineers, & Architects in GIS

UNIVERSITY OF HAWAII AT MANOA (8/2002 - 4/2012)
Worked in various positions within the University system over a 10-year period, either concurrently at 0.50%FTE or on consulting basis

Department of Botany
GIS Lab Manager/Jr. Researcher

  • Provided GIS services, needs-assessment, trainings, and workshops for students, faculty, and affiliates

  • Conducted GIS-based ecological research on avian diseases, invasive species spread, and seabird foraging in the Hawaiian-Pacific islands

  • Managed the operation (hardware & software) of the joint, Pacific Cooperative Studies Unit/Botany Department’s GIS research lab

MAGIS Geospatial Center, Hamilton Library
GIS Coordinator/Data Manager

  • Acted as the University-wide, point-person for GIS help and services to students, faculty, and general library users

  • Implemented a Hawaii/Pacific Rim centric geoportal that searches and harvests all GIS data and maps available in-house and from external cooperating partners. 

  • Managed, inventoried, and prepared all in-house digital map collection for web deployment on the center’s website

Environmental Systems Lab, School of Architecture
GIS Specialist

  • Developed GIS-based web mapping application for a campus-wide Building Information Modeling and campus planning project

  • Conducted spatial analyses of residential energy consumption and efficiency for the Forest City military housing complex on Oahu

School of Ocean and Earth Science and Technology
GIS Consultant

Developed a private, GIS-based web mapping application for the State of Hawaii’s renewable energy project to route an underwater, inter-island transmission cable to distribute wind generated energy from Lanai and Molokai to Oahu 

MASSACHUSETTS WATER RESOURCES AUTHORITY
GIS Consultant (9/1999 - 10/2000, 4/2001 - 7/2002)

  • Contributed to studies of water quality and reservoir risk assessments and mapping and analyses of facilities distribution system

  • Redesigned, cleaned, coded, and mapped legacy spatial and non-spatial databases

  • Trained interns and staff members in the use of customized GIS applications

  • Performed tests on legacy GIS system and resolved problems related with system upgrade and ArcGIS and ArcSDE migration

URBAN DATA SOLUTIONS, INC.
GIS Programmer/Customer Applications Manager (10/2000 - 4/2001)

  • Developed programming-based solutions to client problems in the 3D spatial data and services industry

  • Writing proposals for consulting projects

  • Resolved client issues and acting as client liaison providing project needs assessments

  • Trained clients in use of customized GIS applications and software

  • Designing company-wide centralized client database

OCEANSPRAY CRANBERRIES, INC.
GIS Analyst (5/1997 - 4/1999)

  • Assessed cranberry bog health and production acreage by analyzing high resolution aerial imagery

  • Self-taught Arc Macro Language (AML) coding in ArcInfo to perform geoprocessing functions

  • Created cranberry atlas and assisted with content creation and maintenance of intranet and Grower-Owner extranet site

HOUSING DEMOGRAPHICS CONSULTING PROJECTS

NEIGHBORHOOD HOUSING SERVICES OF CHICAGO (5/2005 - 9/2005)

Consultant for project examining if subprime mortgage loans with escrow provisions perform better than those without escrow. Involvement included: cleaning, preparing, and standardizing data from mortgage loan originators and servicers; run competing hazard models (failure versus prepay) of loan performance for six vintages of subprime loans.

U.S. DEPT. OF HOUSING AND URBAN DEVELOPMENT (8/2004 - 8/2005)

Consultant on project examining if increasing rates of home-ownership among minorities are leading to lower levels of residential segregation in U.S. metropolitan areas using Census and Home Mortgage Disclosure Act loan data. Involvement included: assembling and cleaning geographic boundary files, and performing segregation analysis on population and mortgage lending data for 50 large U.S. metropolitan areas.

NEIGHBORHOOD REINVESTMENT CORPORATION (5/2002 - 7/2002)

Worked on the Campaign for Home Ownership 2002 project. Performed location analysis used for strategic planning and implementation of NRC service delivery and expansion. Consulted on project research design and helped reorganize client database. Cleaned and prepared data for use in presentations.

JOINT CENTER FOR HOUSING STUDIES, HARVARD UNIVERSITY (7/2000 - 3/2002)

Consultant for various GIS-based projects for the Joint Center for Housing Studies at Harvard University. Some selected projects:

  • Evaluating Multi-ethnic Segregation Patterns: Implemented spatial segregation measures for project and evaluating multi-ethnic segregation using 1990 and 2000 census, and Home Mortgage Disclosure Act loan data.

  • Impact of the Community Reinvestment Act.: Used census and mortgage lending data for spatial analysis of case study data for Ford Foundation-funded comprehensive evaluation of federal anti-redlining legislation.

  • Low-Income Homeownership Symposium: Provided GIS research support for the Center’s Low-Income Homeownership Symposium including spatial analysis of economic and demographic variability in home-buying at the census tract level in ten metropolitan areas.