Subject matter expert (SME) on Python and the arcpy (ArcGIS) Python library.SME on spatial databases and standard Unicode character data, BLOB, CLOB, SDO, other geometry.ReportAll uses service and micro-service based data infrastructure with Oracle SQL/PostgreSQL.

• Writes Python 2 & 3 iterative geoprocessing scripts for ArcGIS Pro 2, Desktop 10.7• Conducts ETLs, data loads/transfers to Oracle/Microsoft SQL databases for data visualization• Publishes and consumes REST feature layers for enterprise ArcGIS Portal/Online• Administers configuration management database for 3GIS Admin & rest services/APIs (browser based GIS production environment with API sourced tools)• Identify stakeholders, objectives, environments as technical requirements for data & deliverables solutions• Develops logging API in node.JS and Winston for proprietary mapping software development

Ohio Department of Transportation• Integrates data from legacy SQL servers to Production & Warehouse data servers through a multi-step process of modeling, mapping, querying, relational modeling• Develops schemas and keys to serve the needs of internal and external clients• Creates executive dashboards and applications utilizing SQL & Python in PowerBI, SSMS and ArcGIS to provide greater insight to DBOs• Documents requirements, workflows, methodologies, action items, stakeholders and test results for SQL data and GIS data integration projects• Writes Python script using ArcPy, Py 27, Anaconda, pandas, other libraries for layer Geoprocessing, SQL data and Cursor updates• Tests, debugs, and modifies Python scripts for Geoprocessing and data updates

• Drafts & designs Planned Development (PD) plansets in AutoCAD Civil 2015 for future land & property developments within Orange County• Engineers new data & extracts open source data to build P&B's new GIS server structure• Monitors Orange County, municipal, & state code compliance in conjunction with engineering leads for PDs, Land Use Plans (LUPs), & in pre-design research report preparation• Generates residential/commercial (AM/PM) road trip demand tables/matrices using ITE 9th & 10th Generation Term rates for given PD subdivisions' plan approvals• Forecasts neighborhood school demand given expected dwelling units and use type using Orange County student generation rates• Calculates Transfer of Development Rights credits based on ratios per acre for conservation of "upland greenbelt" (growth boundary) & surveyed wetlands to meet County unit density code• Designs map exhibits in ArcGIS (ArcMap 10.7) for client & Commission Future Land Use (FLU) and Zoning reviews• Creates legal property exhibits in ArcMap & AutoCAD for use in Transfer of Development Rights (TDR) & Adequate Public Facilities (APF) agreements between clients, developers per County

• National Fiber Cable Audit—nation-wide audit of Crown Castle’s GIS database to reconcile acquired/merged fiber optic cable networks in key regional markets (QA/QC)• Edits GIS database from remote server locations—exports .KMZ files for Google Earth Pro, .CSV sheets for VLookup attribute record compiling• Inspects engineering diagrams and plans, Google Earth imagery, field survey data to inventory underground and aerial infrastructure • Configures fiber optic spatial data in 3GIS server environment for infrastructure audit/planning

(Short Term Contract)• Brainstorm new workflows for GIS implementation from ArcGIS 10.5 to AutoCAD 2015• Build dashboards in Excel sheets to facilitate efficient work order tracking• Write SQL Queries in Excel & AutoCAD in PL/SQL Oracle format• Edit, write attributes in AutoCAD 2015 3D Draw—Oracle Production GIS database• Create generator point data from field crew Excel spreadsheets to map units for New Jersey

Part of the paraprofessional internship program • Identified legal & billing area conflicts for contract revisions in NEORSD’s Service Area • Calculated billable revenue by acre for CAMA parcel datasets using PL/SQL Queries & Python • Analyzed frequency, category, & location for EPA sewer/CSO permit data in relation to building permits to target public records requests & streamline project management • Created spatial data of contracts & Facilities Planning Areas (FPA) utilizing land use studies • Drafted maps for internal & external clients for flooding, contractual, & maintenance problems • Edited attributes, exported data & published content in ArcGIS Online, Pro, & Desktop • Debugged, edited & tested Python scripts for ArcGIS Desktop, PyScripter, & ModelBuilder • Monitored code compliance with Ohio Utilities Protection Services (OUPS) & state/federal law • Reviewed plans, tracked permits, & acreage for stormwater mitigation projects in ArcGIS & Excel • Utilized ArcGIS Advanced & toolkits: 3D Analyst, Spatial Analyst, Network Analyst, Data Reviewer • Read hydraulic parcel feasibility design studies & legal documentation for spatial & tabular data creation of NOACA's (Northern Ohio Areawide Coordinating Agency) Facilities Planning Area (FPA) land use polygons • Calculate delta values for change per annum over a 4 year period of "District Criticality" scores • Formulate regression models for percent probability of District asset corroding due to Beta spatial variables (proximity to landfills, brownfields, superfund sites, waste dumps) • Extract elevation data & create raster datasets (TIN, LiDAR) using ArcGIS 3D Analyst & Spatial Analyst • Analyze client accounts in ArcGIS & cross-research to Cuyahoga County GIS Parcel Database, SWFT (billing), CCB (billing) systems & Google Earth aerials for Wastewater Billing Analysis "Long Range Plan"

• Managed multiple construction projects with receivables ranging from $200,000 - $1,000,000• Monitored project compliance according to Ohio Revised Code (ORC) Building & Fire Regulations• Plotted parking lots & buildings in CAD to print maps, blueprints, plans, & surveys for projects• Wrote Spill Prevention, Control & Countermeasure (SPCC) plans & project plans for construction• Wrote plat & parcel reports for billable projects using Cuyahoga County GIS data• Took field notes on grading & foundation surveys with Professional Engineers

• Downloaded, classified County Residence & Workplace spreadsheets/feature classes from LEHD Origin-Destination Employment Statistics for County development investment application• Valuated median property values and assessed changes in value for property tax reporting on Cleveland Heights & eastern suburbs using VBA & SQL (Excel, Access)• Catalogued, rebound & interpreted archival maps of municipal & regional planning• Inventoried every County municipal zoning code, hyperlinked, & collated in Excel for plan review

• Surveyed every pedestrian right-of-way in Downtown Cleveland, mapped in ArcGIS• Graded qualitative right-of-way condition(s); categorized facilities, poles, trees• Produced maps illustrating Streetscape Audit & ADA Accessibility Survey