OBJECTIVE

I am a responsible self - motivated individual who offers knowledgeable programming and development skills with a specialization in geographic data particularly street networks. I have a proven ability to produce attractive and efficient results using learned programming techniques and intricately document my work. My experience includes the manipulation of both grid and feature data as well as maintaining their properties in a database.

PROFESSIONAL EXPERIENCE

GIS Software Developer Contract Employee

Confidential

• Office of Coast Survey OCS Coast Survey Development Laboratory Marine Chart Division
• Develop and support software for cartographers in maintaining marine chart updates
• Designed new reporting engine connected to a live database using both Crystal Reports and BIRT templates to emulate existing Excel worksheets containing tabular data charts and summary statistics which ultimately resulted in the dramatic reduction of report-generation time from several hours to a couple minutes
• Built SQL statements to compile a monthly statistics table based on a complex set of rules across multiple date fields embedded in the VBA module of an Excel spreadsheet
• Developed transitional code to transfer data between databases in support of legacy algorithms written for the database format currently being phased out
• Tailored new ArcGIS tools to be integrated into the cartographers SOP s for making nautical chart updates which perform functions like modifying tables in an internal database to reflect the current status of a particular update
• Worked as part of a large team supporting a massive in-house nautical chart extension for ArcGIS where tasks are assigned to individual developers and progress is shared

GIS Programmer / Analyst

Confidential

• Analyze prepare and maintain local and statewide street databases for real-time traffic analysis
• Designed and created a Mileage Calculation Tool using VBA ArcObjects which joins point locations to their nearest linear features and calculates their mileages based on starting and ending distance attributes as well as the relative positions of the points with respect to the nearest segments topologies
• Modified and updated geographic tables stored on a MS SQL Server box by downloading attributes from the server using ArcGIS to edit changes to geographic intersection coordinates line lengths and other feature attributes and then reloading the changes back onto the server while maintaining the proper schema and unique ID keys
• Developed a routine in ArcGIS to generate highway offset lines used for displaying real-time traffic information on a web-based interface from centerline polygon buffers
• Extracted street centerlines from public and government street databases unifying all segments associated with a specific route name and then re-splitting them at predefined point intersections all while recalculating the original distance attributes to apply to the redefined segments

GIS Programmer

Confidential

• Research and development of automation for environmental and GIS Services
• Designed a program to create KMLs with features containing time stamps that allow the user to play video-like sequences in Google Earth that chronologically hide and show features based on a rolling time window
• Upgraded code originally designed to execute as an AML in ARC/INFO to execute as a tool in ArcMap using VBA ArcObjects
• Designed and created a Temporal Summary Tool using VBA ArcObjects including 3D Analyst which creates 3-dimensional layers that represent date field attributes as Z-values elevations and allows changes over time at the same location to be mapped vertically in ArcScene
• Developed a client-specific custom app to apply MetaCarta s document geo-tagging web service to locational information found within a database to associate geographic coordinates with each record
• Developed a text-parsing algorithm to convert Excel data from an obsolete database format into a new format requiring data from a single record to be split over many based on chronological and locational information found inside a text field
• Designed and created a VB.NET desktop app to launch a new session of ArcMap and automatically build new project files MXDs with predefined legends and naming conventions for change analysis based on a variable number of input raster layers taken chronologically at the same location
• Designed and created a Grid Summary Tool using VBA ArcObjects including Spatial Analyst which summarizes multiple raster cell values at a geographic point or area and produces a colorized page layout that details how the score was tabulated layer-by-layer
• Designed and created a web service using VB.NET and ASP which utilizes the MetaCarta document geo-tagging service to locate index and display the location of geographic text within a document
• Designed and created an Ellipse Summary Tool using VBA ArcObjects to select and analyze feature points within a fixed ellipse and date range

Programmer / Analyst

Confidential

• High-volume optimization systems for fleet routing of customer service locations with detailed travel path instructions created from up-to-date street networks
• Prepared linear shapefile data for address routing including fixing disconnected nodes overlapping address ranges and joining seams on data from multiple vendors
• Created new C DLLs for use with flagship product to check network connectivity assign segments to route zones and generate travel-path delivery instructions
• Assisted tech-support staff in tracking down the cause of any bugs experienced by clients whether caused by memory leaks or faulty data
• Updated existing code to be internationally compliant supporting instructions in other languages and turn penalties with respect to left-side driving
• Converted text reports of route statistics customer lists and driving directions into parameter-driven Crystal Report templates
• Utilized cross-street information and vendor-specific street properties to expand a routing solution based on 4 turn types to display over 20 different types of more intuitive instructions reflecting real-world driving conditions
• Created custom Crystal Report templates on demand for specific clients including FedEx US Postal Service newspapers and local government services e.g. trash pickup meter reading
• Composed original scripts in Avenue to prepare data for use with flagship routing product
• Self-educated to use advanced Visual Basic programming concepts such as polymorphism
• Created original object and interface classes in Visual Basic to interact with ArcObjects Converted Avenue scripts written for ArcView to Visual Basic functions for use with ArcGIS

Software Developer

Confidential

• Custom GIS applications for both government and private agencies
• Developed custom GIS applications in both ArcView and ARC/INFO environments
• Used Spatial Analyst to analyze hydrology grids with original Avenue scripts
• Created custom dialogs in both Visual Basic and ArcView Dialog Designer
• Maintained menu-driven AMLs to perform stormwater modeling
• Devised a system of reach-node topology for ArcView shapefile themes
• Built DLLs in Visual Basic allowing ArcView to utilize an Access database
• Designed output format of database queries using Crystal Reports

Map Designer / Avenue Programmer

Confidential

• Development of an interactive tutorial to expose non-geographers to the world of GIS
• Created Avenue scripts to take student users through interactive tutorials
• Developed ArcView extension with custom GUIs to be run on UNIX PC and Mac
• Instructed lab sessions on Avenue programming
• Digitized map data using ARC/INFO and converted into ArcView format

COMPUTER EXPERIENCE

Programming Languages and Concepts

• .NET Technologies VB.NET C ASP
• ESRI ArcObjects Visual Basic C Python
• Visual Basic C C SQL some JAVA
• Charts Reporting Crystal Reports BIRT Excel
• Databases MS SQL Server Oracle
• Web File Formats HTML XML KML Google Earth
• Object-Oriented Programming Inheritance Interface Classes Polymorphism
• Legacy GIS Scripting Avenue ESRI GISDK Caliper AML ESRI

Operating Systems

• Windows 7/XP/2000/NT 4.x Windows 98/95 UNIX MS/DOS MAC/OS

GIS Software and Data

• ESRI ArcGIS 9.x 8.x including ArcObjects Spatial Analyst ArcScene 3D Analyst
• ESRI ArcGIS Server
• ESRI ArcView 3.x 2.x including Spatial Analyst and Dialog Designer
• ESRI ARC/INFO 7.x including ArcPlot ArcEdit Grid Tables INFO
• Google Earth
• NAVTEQ/NavTech NavStreets Premium Street Data
• MetaCarta GeoTagger
• Caliper Maptitude

Other Software

• MS Visual Studio 2005 6. x MicroSoft IIS
• MS SQL Server some Oracle
• Actuate BIRT
• MS Word 97 WordPerfect vi
• MS Excel 97
• MS Access
• Apache OpenOffice
• SourceGear SourceOffsite MS Visual SourceSafe Araxis Merge
• Compuware DevPartner Visual Build Professional
• MS Outlook 98 97 Google Chrome Mozilla Firefox Netscape Internet Explorer FTP Pine
• Image Editing Software MS Paint GNU Image Manipulation Program 2.6