Shelley Hill Email and Phone Number

Supervises a group of developers that support the Information Management division of the Water practice; Manages multiple spatial and non-spatial SQL Server databases on several servers for clients and internal project use; Serves as lead developer to provide high-quality desktop, mobile and web-based solutions focusing on dynamic, modular, and configurable properties during design for clients including these recent projects:Risk Prioritization & Capital Improvement Planning Application - Web solution that combines AngularJS, the ArcGIS JavaScript API and a custom ArcGIS Server Object Extension to assists engineering managers in building a complete picture of current risk and future cost planning. The risk module allows managers to set custom risk scoring criteria to calculate CoF, LoF & BRE scores that are used to prioritize the assets in greatest need of rehabilitation. These scored and ranked assets are displayed in multiple graphics and a map interface where they can be easily selected for capital improvement projects. The cost module provides a method to define activity-based unit costs and build well estimated projects that can be budgeted across funding years for more effective planning. Asset Assessment Program for CMMS Integration - Administrative web application provides an interface to manage a configurable framework for the solution including defining asset types, domain values and user management. A mobile field application allows crews to collection condition scores, photographs and supporting information for each asset type in a disconnected environment. A data management application provides the connection point to pass the collected data into an enterprise database. Various technologies including Universal Windows Platform, ASP.NET Core REST Services, Angular, Kendo UI, and other JavaScript libraries and SQL Server stored procedures were used to build these integrated applications.

Championed the adoption of Agile methodologies within the organization; Mentored other developers in both technical and project management related skills; Represented Woolpert as technical speaker at regional GIS user group meetings; Served as lead developer for these key projects: Network Valve Operation Field Application – Web solution that combines AngularJS, ArcGIS JavaScript API, and custom network tracing extension for ArcGIS Server to allow utility foreman to plan exercises based on network queries and their impact on critical facilities, easily update valve records in the enterprise GIS, maintain work records for valve operations and record histories of each valve for Columbus, OH.Offline Editing Application – A dynamic self-hosted Node.js JavaScript application that uses AngularJS, ArcGIS JavaScript API and ESRI REST operations to download any ArcGIS feature service layer into locally stored JSON files and base map image files into an indexed CSV file so that editing and data collection can be performed in the field where no network access is available and then easily uploaded back into the enterprise GIS. Environmental Document Management Application – An AngularJS and ASP.NET Web API application that manages the federally mandated document and review process for construction projects with environmental impact at Edwards Air Force Base using a primary software design principle that generates all form content based on stored procedures in a supporting relational database and the database schema itself. Highly Configurable Installation Map Viewer – A framework of interconnected .NET MVC, ArcGIS Flex API and Windows service applications that host unique GIS resources and tools to individual users based on role-based authorization for all nine Air Force Material Command installations providing a modular and extensible “one application – many user experience” solution that meets strict DoD cyber security requirements.

Managed agency GIS web applications in a multi-server environment; Improved end-user experience by developing customized HTML viewers that maintain the current map extent across GIS web sites and services resulting in a significant increase in Web site visitors; Expanded agency’s web-based offerings from two to four sites; Extended GIS web application functionality with a password protected download tool, custom print functions that include attribute data and the integration of ASP.NET query forms; System administrator for agency RedDot CMS & RedDot LiveServer web content management system 
supporting dynamic-content and personalization; Developed suite of ASP.NET applications to manage a large relational database for transportation projects generating query-based SQL reports; Responsible for the installation and administration of multiple ArcSDE instances and training of staff on SDE concepts

Developed GIS web applications and various user-interface tools to query and display related 
information from a separate non-GIS database; Developed several ASP.NET Applications as database front-end interfaces for data entry, querying and reporting; Customized ArcIMS HTML Viewer for various applications;Wrote ASP.NET library used for dynamically generating HTML and web form objects from database schema; Developed custom ArcObjects and Python scripted geoprocessing tools for ArcMap to automate the steps involved in managing GIS updates from CADD; Developed custom ArcScene tools to compare survey and tin (triangulated irregular network) elevations 
at specific coordinates; Designed relational databases for asset inventory management and budget tracking and schedule management of department projects; Extended the geodatabase design for CPTC base map by adding components to manage object permanence and historical versions; Wrote Visual Basic Application to automatically check consistency of all database schemas for each CPTC 
geodatabase layer to ensure structural consistency of the data

Developed a complex Visual Basic application to check the completeness and accuracy of road layers against inventory data stored in Oracle; Designed and developed a custom UI-tool in ArcMap to examine the errors found in the quality control program; Managed a large data delivery project for road coverages for 158 counties in the state of Georgia; Developed ArcObjects application in ArcCatalog to generate two related route systems in a geodatabase from an existing coverage;Developed an algorithm of geoprocessing methods that are being used to update new Urban Boundary Area measures in the road inventory database ;Wrote scripts to download real-time weather data and automatically load the data into ArcSDE for use by an internal ArcIMS application