• ESRI
• Open Source
• Google Maps
• Bing Maps
• Misc.

Who: State D.O.T. What: Transportation Planning Tool Technology: ArcGIS Server 9.3.1 ESRI Web ADF jQuery 1.3 AJAX Tooklit SQL Server 2005 Completed: Summer 2009

Who: El Paso County, Colorado Assessor What: Public Accessor's Portal Technology: ArcGIS Server 9.3 ESRI JavaScript API jQuery 1.3 SQL Server 2005 Completed: Spring 2009

Who: Large Nonprofit What: Project Mapping Tool Technology: Bing Maps (Virtual Earth) jQuery 1.3 GeoServer PostGreSQL/PostGIS Completed: Prototype - Spring 2008 v1.0 - Spring 2009

Who: GeoEye Space Imaging What: GeoFuse Search & Discovery Technology: ArcGIS Server 9.3 (REST) ESRI Google Maps Extension API Scriptaculous SQL Server 2005 Completed: Summer 2008

Who: Portland Metro What: Build-a-System Technology: Google Maps API jQuery 1.3 Completed: Winter 2009

Who: Personal SkunkWorks Project What: Blackberry GPS Tracking Application Technology: Bing Maps (Virtual Earth) Blackberry Mobile Device J2ME Application SQL Server 2008 Completed: Summer 2008

Who: CH2M HILL What: Financial Dashboard Application Technology: Bing Maps (Virtual Earth) Flash Completed: Summer 2007

Who: Large Nonprofit What: SMS Interface for Project Mapping Tool Data Technology: SMS-Enabled Phone GeoServer DOTGO SMS Service PostGreSQL/PostGIS .NET Web Handlers Completed: Prototype - Spring 2008

Who: Personal SkunkWorks Project What: SMS Message to Bing Maps 3D Object Technology: Bing Maps (Virtual Earth) DOTGO SMS Service Google Sketchup Pro .NET Web Handlers Completed: Fall 2008

• E-mail - ryanmwhitley at gmail
• Twitter - apollolm
• Facebook - Chu88s
• LinkedIn - Me
• Read my Blog - GeoSpat
• Esteemed Colleague Grant McKenzie's website - GrantMcKenzie.com

Education

B.A., Geography (Urban and Transportation GIS), University of Washington , 2002
Minor, Earth and Space Sciences

Distinguishing Qualifications

·         7 years of Geospatial Web Application Development

·         In addition to the ESRI suite of software, a focus on open source geographic application solutions

·         Programming Languages: C#.NET; VB.NET; T-SQL; PL/SQL; JavaScript

·         Technical Knowledge Base: Visual Studio.NET; ArcGIS 8.x- 9.x; ArcGIS Server 9.x; ArcIMS 4- 9.x; ArcSDE 8 - 9.x; SQL Server 2000; SQL Server 2005; SQL Server 2008; SQL Server Integration Services; SQL Server Analysis Services (OLAP); SQL Server Reporting Services; Safe Software FME; PostGIS; PostGreSQL; Microsoft AJAX Toolkit; Microsoft Virtual Earth (Bing) API, Google Maps API, OpenLayers API

·         Other: Google Earth KML Development, GeoRSS, RSS, Web Services, REST Services, Web Handlers

·         Relational Database Design, Use, and Visualization Certification, University of Washington, 2002

Relevant Experience

Ryan Whitley is a software developer and analyst with CH2M HILL’s Enterprise Management Solutions (EMS) Business Group in Seattle, Washington . He has 7 years of Geographic Information System (GIS) and Web Application Development experience working with clients to deliver state-of-the-art spatial solutions. Mr. Whitley specializes in geospatial web application development including applications utilizing the Microsoft Virtual Earth (Bing) and Google Maps API, as well as the design, creation, and deployment of supporting business logic tiers and relational databases. These solutions, developed for public and private sector clients, include real-time fleet tracking, document management, cellular network performance visualization, and large-scale project portfolio mapping.

Representative Projects

Developer; State-Level Department of Transportation; May 2009 to July 2009. Migrated a custom ArcMap Desktop Toolbar to the web environment using ArcGIS Server. The tools helped transportation planners locate road network features, identify their status, and prioritize maintenance activities. Technologies used: ArcGIS Server Web ADF, jQuery, SQL Server 2005.

Lead Developer; Portfolio Impact and Mapping Tool 2.0; Large Nonprofit, WA; March 2009 to May 2009. Revisited the Portfolio Mapping Tool, refreshing the architecture, creating a more usable and intuitive user interface. Improved editing functionality, added custom WMS overlay library, and easier search functionality. Technologies used: Virtual Earth API, jQuery, PostGreSQL, PostGIS and GeoServer.

Lead Developer; Assessor’s GIS Website; El Paso County Assessor’s Office; Colorado Springs, CO; January 2009 to March 2009. Created two web based applications for the purposes of technical evaluation. Replaced the legacy ArcIMS website with a Virtual Earth API and ESRI JavaScript API website. Designed and implemented ArcGIS Server 9.3 with Tile Caching mixed with dynamic services for map rendering.

Developer; Build-a-System Tool; Portland Metro; Portland, OR; January 2009 to March 2009. Created a Google Maps based web application to allow the public to provide input and feedback on the Portland Metro 2040 transportation plan. Users could identify potential routes linking town centers, which can be saved and submitted to Portland Metro to identify possible demand for routes in the future. Users could also identify the environmental impact and relative cost to build each proposed link, as well as view a thumbnail of each town center. The site relies on jQuery JavaScript toolkit. Very well received by the public and Portland Metro.

Developer; eGov Real Estate Mapping System; City of Bellevue, Bellevue, WA; December 2008. Developed Virtual Earth Commercial and Residential real estate mapping system, with custom spatial search and reporting tools.

Lead Developer; GeoEye GeoFUSE; GeoEye Space Imaging; Thornton, CO; May 2008 to July 2008. Implemented production web application that allows the public to browse the vast catalog of GeoEye satellite imagery. The Google Maps API and ESRI Google Maps extensions were used to communicate with an ArcGIS Server 9.3 REST endpoint for querying and map interaction. Satellite imagery thumbnails tied to a replicated SDE database but stored on a file server could be hidden/shown on the map. A Google Earth web-service/network link system was also created to mimic the Google Maps look and feel. http://geofuse.geoeye.com/landing/Default.aspx

Lead Developer; Portfolio Impact and Mapping Tool; Large Nonprofit; Seattle, WA; August 2007 to March 2008. Designed and implemented web prototype used by client and client grantees to track worldwide project progress and impact. The architecture includes .NET/Ajax/Microsoft Virtual Earth on the front end, and the Open-Source PostGreSQL on the back end. Users can draw on the map to denote project areas, which are then saved along with tabular project information to the database. Integration with GeoServer and a custom GeoRSS interpreter for Virtual Earth highlight this project.

Lead Developer; Financial Dashboard; CH2M HILL; Seattle, WA ; June 2007 to August 2007. Designed and implemented web prototype used by internal management to easily view internal project metrics broken down by department AND by region. Interface includes dashboard-like dials to show financial health of company verticals, and capability to drill down from high-level areas into sub-regions. The architecture includes .NET/Ajax/Microsoft Virtual Earth on the front end, with hooks into the internal data warehouse to pull current financial metrics.

Lead GIS Developer; Central Title System; Plum Creek Timber; Columbia Falls, Montana; February 2007 to June 2007. Refactored and upgraded existing ESRI ArcMap Extension. Central Title System (CTS) is the ownership data management system of record for all of the land that Plum Creek owns. The system consists of a database and software application that serves as the data management tool for the ownership characteristics of all of Plum Creek's land-based assets. The core technologies were ArcMap 9.2, ArcSDE 9.2, SQL Server 2005, and the application was written in C#.NET.

Lead Developer; My Network 4.0 Prototype; Ericsson TEMS; Reston, Virginia ; July 2006 to January 2007. Developed a web-based application to assist engineers and managers in evaluating cellular network performance, calculated from telemetry data sent by mobile GPS field units. The project utilized SQL Server 2005, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services (OLAP), Safe Software FME, ArcIMS 9.2, ArcSDE 9.2, Skyline TerraExplorer Pro, Google Earth, ASP.NET 2.0 (C#.NET).

Lead Developer; Transportation Impact Visualization; Powell Butte Investments, LLC; Powell Butte , Oregon ; July 2006. Developed a presentation and underlying Google Earth visualizations to simulate the aesthetic impact of a road over a rural section of Powell Butte. The presentation was developed for use in stakeholder involvement. Imported and manipulated CAD data in Google Earth’s 3D modeling tool, Sketchup.

Lead Developer; MapComment; Internal CH2M HILL Initiative; Bellevue, Washington ; May 2006 to June 2006. Led development of a web based mapping application that allows users to leave geo-tagged comments regarding regional construction projects. The comments are then available to administrators as an RSS feed, as a Just-In-Time Google Earth layer, or in a Google Maps interface available on the website itself.

Lead Developer; GETracker; Internal CH2M HILL Initiative; Bellevue, Washington; March 2006 to September 2008. Led development of a Windows Smart Client application to show near-real-time and historical locations of cell phones deployed in the field, using Google Earth as the interface. Drew on multiple web services to provide additional information such as drive time analysis, real time traffic, SMS capability, nearest asset functionality, and driving directions for any of the phones in the field.

Lead Developer; Operational Support System; First Avenue Networks; McLean, Virginia; December 2005 to March 2006. Led development of an asset database and Web interface to track cell sites, buildings, equipment, and numerous other company assets.

Requirements Gathering; Billing and Asset Management Database; Snohomish County Water District; Everett, Washington ; November 2005. Conducted interviews at Snohomish County to gather requirements for construction of a billing database and desktop application.

Database/Web Developer; Technical Document Website; Chelan County Public Utility District; Wenatchee, Washington; October 2005 – January 2006. Developed an intranet website for Chelan contractors, consultants, and other employees to share information about contracts, task orders, etc.

Representative Projects Prior to CH2M HILL

GIS / Relational Databases / Application Development

Integral GIS; 2002-2005

Integral GIS and PJM Interconnection System Planning GIS. Developed custom GIS interfaces for engineers; real time and 3D visualizations; integrated GIS with legacy information; legacy database migration; database and geodatabase design.

Port of Tacoma Web-Based GIS Management Systems. Helped develop a web-based CAD drawing viewer and interface to search and view the entire database of engineering drawings. Also helped to create a Rail Management System for the CPC group to help port managers quickly assess track occupancy in near real time, and query the status of all inbound rail containers.

Washington Group International Border Security Analysis Tool. Helped design and develop an ArcEngine 9.0 application containing 2D and 3D views of terrain to help engineers decide where to place cameras along the United States borders with Mexico and Canada . The application suggests suitable locations for cameras based on landscape criteria and line of sight requirements, and shows areas of coverage once cameras have been placed.

Bill & Melinda Gates Foundation . Designed a tool to automatically import tabular Access database information into ArcMap. The tool was used to translate information in the database to a visual map of institutions receiving Foundation grants.