David Dellenbach, Gisp Email & Phone Number

North Charleston, Sc, Us

North Charleston, South Carolina, United States

GISP CertifiedWEASC Certification Level CNASSCO Certified (PACP, MACP, LACP)Presentations:2021 WEASC/SCAWWA Conference2019 Lucity ACT2019 ESRI Water Conference2019 Innovyze Carolinas UGM2018 SCAWWA/WEASC Asset Management workshopMap Presentation:2019 ESRI Southeast User ConferencePublications:March 2020 - Use Risk-Based Asset Prioritization to Develop Accurate Capital BudgetsMatthew Grewe, Phillip Sexton, P.E., David Dellenbach, GISPOpflow Vol. 46 Issue 3Innovyze Training:InfoWorks ICMInfoMasterAsset Integrity Management and Capital Planning Software Training CourseSkills include:• Utilize Jupyter Notebook and Juypter Lab to extract SQL data for Permit Status Reports.• Utilize Web AppBuilder to create Web Apps for mobile and desktop devices.• Maintain Asset Risk and Criticality Scores using InfoAsset Planner.• Create Python scripts to automate processes.• Create SQL queries for reporting.• Maintain Portal for ArcGIS 10.7 by leveraging the WEBGISDR toolset to create backup of ArcGIS Enterprise.• Create connections to SQL Server Databases.• Manage privileges for feature classes within an Enterprise geodatabase. • Manage data validation CCTV projects for Capital Projects Division.• Maintain/Update GraniteNet CCTV inspection software.• Maintain/Update license manager for ArcGIS for Server.• Maintain/Update InfoAsset Planner software.• Link SQL views to feature classes for dynamic Customer Data Extraction.• Manage and create Lucity modules for end user.• Configure GIS feature classes to integrate with Lucity.• Handle all Sewer Extension Contracts for private development.• Curate documents pertaining to Sewer Extension Contracts.ArcGIS API for PythonPython Leaflet Maps-Folium Marker ClustersJupyter NotebookAnaconda 3Orange 3Portal for ArcGIS 10.5SQL 2012rGraniteNet 3.4Lucity 17.5InfoMaster 8.5Python Pandas DataFrameBokehSketchboardIO

North Charleston, South Carolina

GISP CertifiedClient:Berkeley County Water & Sanitation (Feb 2018-Apr 2018)Duties:Topology assessment report.QA/QC on file geodatabase.Import asbuilt information into SDE.Web Application development ArcGIS Online.Python development for geometry backups.

Charleston, South Carolina Area

GISP CertifiedESRI Training:ArcGIS for Server: Site Configuration and Administration• Analyzed REST Service consumption using System Log Parser to maintain the health of ArcGIS for Server 10.2.2.• Utilized Web AppBuilder to create Web Apps for mobile and desktop devices.• Published hosted feature layers for ArcGIS Online.• Created customized tools for ArcGIS Desktop 10.3.1 using the Python Add-In Wizard.• Deployed Calcite Maps Bootstrap applications utlizing ArcGIS API for JavaScript via IIS.• Collected GPS data from sub-meter Trimble GeoXT and differentially correct data using Positions Desktop.• Created connections to SQL Server Databases.• Managed privileges for feature classes within an Enterprise geodatabase. • Maintained/Updated versions of ArcGIS for all BCWSA employees.• Maintained/Updated versions of SQL Server Native Client for all BCWSA employees.• Maintained/Updated license manager for ArcGIS for Server.• Utilized the Publisher toolset and ArcReader for disconnected viewing.• Linked SQL views to feature classes for dynamic Customer Data Extraction.• Created and maintain applications utilizing ArcGIS Viewer for Flex.• Published services from ArcGIS Desktop in order to create Operational Layers and Basemaps for ArcGIS Viewer for Flex.• Utilized the Borrow/Return process for ArcGIS for Server for concurrent use licenses for disconnected use in the field.• Created and Validated Topologies in order to identify any geometric rule violations in the geodatabase that may hinder the usability of Infowater and other modeling software packages.• Created REST/SOAP web services for Advoco Team Members concerning the implementation of Infor EAM (Enterprise Asset Management).

Mt. Pleasant, Sc

• Created TINs using 3D Analyst extension (ArcGIS 10.1/10.2).• Created animations using ArcGlobe 10.1/10.2 and ArcScene 10.1/10.2.• Managed multiple projects for Senior Team Members.• Utilized past experiences and best practices as a GIS Analyst to create cartographic graphics for the client.• Created Digital Terrain and Surface Models using post-processed LiDAR data to aid in the identification of significant terrestrial archaeological sites (ArcGlobe 10.1/10.2, ArcScene 10.1/10.2, Quick Terrain Modeler, QCoherent, MARS, EarthEye, FugroViewer, and Fusion/LDV).• Migrated KMZ/KML files from Google Earth to ArcGIS 10/10.1/10.2 and reversed the process based on the needs of the client.• Created 3D images of conceptual development plans using building footprint information (ArcScene 9.3/10.1/10.2).• Utilized knowledge of ModelBuilder and Python to create specialized tools on a per project basis.• Worked with the production team to create finished maps in the layout frame.• Created Mapbooks using Data Driven Pages in order to produce maps for the client.• Collected GPS data from sub-meter Trimble and imported into ArcGIS 9.3/10/10.1/10.2 using GPS Pathfinder software.• Created Predictive Models in order to predict the archaeological site potential for proposal packages.• Edited geodatabases and created feature classes to SDSFIE standards for USACE, Mobile District.• Utilized the Kernel Density toolset to create Hot Spot Analysis maps.

Mt. Pleasant, Sc

• Used ArcEditor 9.3/10 and to create and manage feature classes and Geodatabase information.• Used ArcEditor 9.3/10 to create thematic maps (Choropleth, Dot Density, Pie Charts) that enabled the viewer to make informed decisions based on the analysis the GIS provides.• Imported CAD files and shapefiles into ArcMap 9.3/10 to create maps for the client (our main client was the United States Army Corps of Engineers).• Developed data frame layers by digitizing parcels and importing land use data into the database table.• Worked with the production team to create finished maps in the layout frame.• Collected GPS data from sub-meter Trimble and import into ArcMap 9.3/10 using GPS Pathfinder software.

Mt. Pleasant, Sc

• Directed the survey operations and crew for numerous projects including the Dean Hall survey E. I. Dupont de Nemours Company Inc. in Moncks Corner, S.C.• Utilized mapping skills to locate topographic locations of interest on 7.5 minute topographic quadrangle maps.• Surveyed lands in the Bahamas (New Providence and Royal Island) in search of artifacts (Colonial and Native American).• Used Ground Penetrating Radar and GIS skills to produce maps and relay information to Senior Archaeologist regarding Cultural Resources. • Collaborated with team members and implemented field survey skills and experience to locate Native American sites and relay information to Senior Archaeologist in Wisconsin (Badger Weapons Plant, Baraboo, WI). • Surveyed lands throughout the Southeastern United States in search of Civil War and Native American artifacts.

Orlando, Fl

• Ensured that the Asbestos Division was compliant with federal regulations handed down by NIOSH.• NIOSH 7402 Certified to analyze asbestos using a PCM microscope.• Produced monthly Quality Control reports to show monthly QA/QC information and report results to Quality Assurance Manager.• Utilized microscopy skills (PLM, PCM, and TEM) to analyze bulk and air samples for the presence or absence of asbestos.• Ensured employees were adhering to the company policies dealing with the Quality Control of samples.

Mt. Pleasant, Sc

• Used management skills to maximize effort and efficiency of field crew to finish projects within budget.• Produced maps and reports conveying locations of artifacts within designated survey areas to assist in identifying historically significant sites.• Catalogued artifacts recovered and pedestalled artifacts in situ for photographs and mapping purposes.

New Orleans, La

• Provided 24-hour well site analysis of sidewall cores for multiple petroleum companies in the Gulf of Mexico.• Photographed samples and prepared reports for clients.• Introduced mercury into samples to quantify porosity and permeability.• Prepared conventional soft core while aboard various oil rigs in the Gulf of Mexico and coordinated the efforts of subcontractors in order to properly transport the cores back to the mainland.

Starke, Fl

• Contracted by E. I. Dupont de Nemours Company Inc. to aid in the mine planning of the Trail Ridge Formation for the White Pigments Division of Dupont.• Identified heavy minerals and performed point counts using a plane polarized light microscope.• Concentrated on TiO2 bearing minerals and the solid solution series of Ilmenite-Leucoxene-Rutile.• Produced reports of findings to the Mine Planning Division.

Jacksonville, Florida, United States

Had the privilege to meet Lep Stewart, Founder of the zine while working for The Franklin Company. I would write reviews for some of the CDs he couldn't get to. I helped out with one of the quarterly Truckstop fundraisers which helped fund the printing. I also delivered copies once I moved to New Orleans. I really enjoyed the experience. Hopefully I can do it again someday.

Mt. Pleasant, Sc

• Surveyed lands throughout the Southeastern United States.• Catalogued artifacts recovered and pedestalled artifacts in situ for photographs and mapping purposes.

James Island, Sc

• Assisted in preparing job bids for General Contractor.• Relayed progress reports to clients and employer.• Coordinated the efforts of subcontractors to assure proper completion of projects.

Post-Baccalaureate Certificate, Gis

LiDAR Applications and Technology

B.S., Geology

Activities and Societies: Intramural BasketballB.S in Geology