Jonathan L. Email & Phone Number

Norman, Ok, Us

Guides citywide long-term growth strategy by deploying advanced data science methodologies and GIS tools to interpret large, complex datasets, including spatial GIS data. This work supports the projection of population growth, fiscal solvency, and future concurrency needs, directly impacting strategic urban development initiatives. Simultaneously, as a subject matter expert in land-use assessments and long-range economic forecasting, leverages geospatial statistical modeling and satellite and… Show more Guides citywide long-term growth strategy by deploying advanced data science methodologies and GIS tools to interpret large, complex datasets, including spatial GIS data. This work supports the projection of population growth, fiscal solvency, and future concurrency needs, directly impacting strategic urban development initiatives. Simultaneously, as a subject matter expert in land-use assessments and long-range economic forecasting, leverages geospatial statistical modeling and satellite and remote sensing data to provide strategic planning recommendations, shaping the city's comprehensive plan, planokc, and future land-use policies.Directs the construction, management, and maintenance of a comprehensive Tri-County geographic parcel database. This database integrates and processes geospatial data from three counties and over 1.5 million parcels using Python, ArcGIS model builder, and SQL, forming a critical tool in urban development strategy. Additionally, leads an innovative redesign of the entire data merging process, employing SQL Server and Python libraries (Pandas & Numpy). This initiative has dramatically improved the efficiency, accessibility, and usability of data consolidation processes, setting a new standard for data management in urban development planning.Enforces rigorous data cleaning protocols, handles missing data, and resolves discrepancies to uphold the highest standards of data integrity. Leads efforts in data analysis and visualization using advanced data science techniques and GIS tools, generating insightful reports and interactive dashboards for key stakeholders. This pivotal role provides strategic leadership and direction in urban planning based on data-driven insights, contributing significantly to the city's growth, development, and fiscal solvency, while ensuring a sustainable and desirable future for the city's residents. Show less

Oklahoma City, Ok

Assessed economic base real-estate values for TIFs, BIDs, and variouseconomic districts in city; performed expert geospatial analysis with GIS software and county parcel database information on a daily basis; work has been used to inform decision-makers on establishing new TIFs, and revitalizing areas including the Oklahoma City Riverfront, provide annexation/detachment fiscal impacts, and support KPIs and land-use analyses.Responsible for updating and maintaining water, sewer, and… Show more Assessed economic base real-estate values for TIFs, BIDs, and variouseconomic districts in city; performed expert geospatial analysis with GIS software and county parcel database information on a daily basis; work has been used to inform decision-makers on establishing new TIFs, and revitalizing areas including the Oklahoma City Riverfront, provide annexation/detachment fiscal impacts, and support KPIs and land-use analyses.Responsible for updating and maintaining water, sewer, and fire service maps utilizing model-builder and ArcGIS network analysis extension; oversaw project to migrate and update planokc website to integrate interactive ArcGIS online interactive map to visually show layer to public. Show less

Oklahoma City, Ok

Provided material for comprehensive plan document update with Adobe Indesign and Adobe Illustrator; converted information in GIS to Adobe Illustrator to make professional-looking maps for the City's Base Zoning, LUTAs, and City Service Maps.Maintained (ETL) GIS feature classes and website content as it relates to longrange planning; including 2020 census decennial information, and 2019 & 2020 ACS subject tables, using US Census Bureaus back-end API and the R Tidycensus library.

Oklahoma City, Ok

Created maps in ArcGIS for comprehensive plan amendments depicting land use, zoning, service layers, and capital improvement projects, to be presented to the planning commission for comprehensive plan amendment recommendations.Report maps, graphs, and synthesized analysis of trends related to new construction permits and total development comparing urban core and fringe of city; helped generate reports for key KPI metrics for the comprehensive planning program.Built an… Show more Created maps in ArcGIS for comprehensive plan amendments depicting land use, zoning, service layers, and capital improvement projects, to be presented to the planning commission for comprehensive plan amendment recommendations.Report maps, graphs, and synthesized analysis of trends related to new construction permits and total development comparing urban core and fringe of city; helped generate reports for key KPI metrics for the comprehensive planning program.Built an interactive Excel dashboard, using VBA and macros, to project fiscal revenues for TIF district over 30 year-period. Including interactive options to project increment and base revenue showing changing economic conditions. Show less

Dallas/Fort Worth Area

Managed a crypto-mining operation operating on custom Ubuntu software, to maintain 98% uptime of ASIC and GPU Miners; primary troubleshooting difficulties was working within an Ethereum pool that would occasionally spoof hash rates to change block reward.

Dallas/Fort Worth Area

Submitted written buy-side reports on technology-sector investment opportunities; compiled and analyzed price, volume, and time-series data to project price trends and buying/selling opportunities on various tech securities on the S&P, DJI30, & Russell 3000 small-caps; was one of the first to notice, analyze, and make recommendations on Ethereum when price was at $300, due to potential value in Smart Contracts, and DAPP Potential.Built and utilized custom spreadsheet software in Excel… Show more Submitted written buy-side reports on technology-sector investment opportunities; compiled and analyzed price, volume, and time-series data to project price trends and buying/selling opportunities on various tech securities on the S&P, DJI30, & Russell 3000 small-caps; was one of the first to notice, analyze, and make recommendations on Ethereum when price was at $300, due to potential value in Smart Contracts, and DAPP Potential.Built and utilized custom spreadsheet software in Excel and Google Sheets to pull real-time data from Yahoo Finance API, which allowed custom interactive options such as forecasting price movements based on commodity prices, Dollar Index (DXY), interest rates, and put/call option price spread.Scripted and coded custom indicators using Pine script in use with Tradingview software for custom alerts for technical volume and pricing anomolies; as well as modifying MACD, Stochastic RSV, and SMA / EMA for 24/7, highly volatile crypto markets. Show less

Shawnee, Ok

Created levy data into Excel spreadsheets to update data for a downtown business project; Researched, compiled and organized various municipal codes for landscaping, sidewalks, and bike trails into visual documents for presentation to Community Developer; Participated in on the job training, monitoring building inspectors, ordinance compliance, and code enforcement.

Master'S Degree, Regional And City Planning

Bachelor Of Arts (Ba), Political Science