Philip Penn

Providing Geospatial Development for PG&E Electric Distribution (EDGIS) Project

WEBR: ArcGIS Server/ArcFM Server solution.

• Lead Developer, assisting with requirements, architecture and design
• Implementation in Silverlight with MVVM
• Provided operational assistance, utilizing ESRI System Test/Monitor

Change Detection: Point to point systems integration between GIS & Enterprise applications.

• Created framework for integrating GIS with OMS/SAP/TLM
• Extensive use of ST_GEOMETRY for data-level integration with external systems/li>

Data Conversion: Ad-hoc assistance and tools for migrating from custom GIS to ESRI.

• Developed one-time ArcObjects tools and ArcFM autoupdaters

AutoCAD Extract: ESRI to DWG conversion process

• Gathered requirements for providing Estimators with DWG feed from GIS
• Implemented FME Server solution

Providing GIS consulting, application development, systems integration, technical architecture and database design for clients.

NSTAR: ArcGIS/ArcFM 10 Upgrade.

• Designed Integration between mainframe CIS and GIS
• Developed ArcGIS Desktop AddIn to link Premises to Service Points

Port Of Portland: Technical Lead on this $7m Enterprise GIS implementation.

• Authored technical architecture, including hardware & infrastructure plan
• Analyzed existing AutoCAD system and modeled it in ESRI SQL Server platform
• Implemented business rules for geodatabase in T-SQL and Python
• Wrote User Stories and code for a mapping web portal in Flex, including Sharepoint Web Part
• Responsible for implementing Workflow Management System (ESRI JTX/WMX)
• Migrated TRC Viewer from ArcIMS to ArcGIS Javascript API
• Developed Sharepoint Property-Lease Web Part using ESRI Javascript API / Dojo

Time Warner Cable: ESRI and Integration support for Outside Plant Oracle Spatial GIS.

• Black-belt ArcObjects SOE for Map Production C# REST Service
• Developed Flex Web Mapping components using Cairngorm framework

Georgia Power Company: Integration Lead on $19m Enterprise GIS project.

• Designed / developed FME-based ETL solution for updating ArcSDE from GPC Autodesk system
• Gathered requirements for integrating GPC’s Work Management tool with Editing Workflow tool (ArcFM Designer)
• Built interface using C# Web Services and MSMQ
• Implemented Partial Posting solution for interfacing with Outage Management system

Smart Meter Map Reporting: Data Warehouse solution for Utilities

• Implemented Data Warehouse to aggregate Water & Electric Meter Read data, using SSIS/SSAS
• Created map-based Reports showing usage using SSRS

Conference Me In: Mobile App for iOS.

• Designed UX for mobile application to dial into conferences, using calendar
• Implemented solution in Objective C & guided application from testing through to AppStore
• 4/5 review on AppCraver, Leading App on Appolicious.
• http://itunes.apple.com/us/app/conference-me-in/id510881378?mt=8.

RWE Thames Water: Consulting on GIS Foundation project, to centralize data access onto Oracle Spatial 10g and rationalize applications.

• Conducted Vendor Selection with major GIS vendors to find suitable candidates to meet Business Requirements
• Interviewed business departments as part of determining Application Rationalization strategy
• Coordinated with Wipro to conduct Proof-Of-Concept tests off-site in Hyderabad

Department of Food, Rural Affairs & Agriculture: Responsible for delivering Genesis GIS Toolkit, leading-edge GIS Systems Integration Project for web-enabling farmer grant applications.

• Conducted client workshops to define Functional Specification
• Project Lead, managing 6 person development team
• Responsible for designing, loading and managing a terabyte-sized spatial database in Oracle

Developed enterprise GIS systems for Utility and local government clients.

• Integration Developer for Cinergy's eBusiness site, a high volume B2C site using WebMethods middleware to interface to Billing, CIS and Outage Management systems
• Lead Developer for City of Portland GIS Enterprise Data Warehouse
• Established Convergent Group's software reuse repository, wrote VB, PL-SQL & Java coding standards

Worked in Cambridge, Denver and Melbourne on a Facilities Management, Network Modeling and Map Production system on C/HP Unix platform for Bell South Telecommunications.