Nathan Ziegler Email & Phone Number

Cincinnati, Ohio, United States

// Collaborated with key stakeholders to implement Microsoft Dynamics 365 ERP software rollout// Engineered reorganization of pipelines in Microsoft Dynamics 365 to establish a novel way to calculate production costs (direct and indirect) for semi-finished goods by conducting time studies to capture the total production cost and finished goods cost// Utilized Data Management workspace in Microsoft Dynamics 365 to maintain item master data and production control parameters including routes, BOMs, operation relations, resources, and resources groups// Created and managed Bills of Material and Routing Operations in Microsoft Dynamics 365// Integrally involved in the organization and implementation of multiple inventories// Designed and implemented forecasting tools in Excel and Power BI to help Haag-Streit USA reach goal of doubling production in 2022// Ensured that new product launches and changes to existing products are conducted in compliance with appropriate regulations and internal procedures, primarily by the Engineer Change Request(ECR/ECN) process and make sure those changes are reflected across the company physically and in Microsoft Dynamics 365// Project Manager for project to fully expense consumable parts and reflect those changes in physical reality and in Microsoft Dynamics 365// Designed and implemented tools in Microsoft Excel and Microsoft Dynamics 365 to forecast labor needs// Worked with floor leads to create up-to-date product instructions// Responsible for issuing and managing requisitions and production orders// Researched and rectified product variances in Microsoft Dynamics 365 to account for inventory discrepancies

Mason, Ohio, United States

// Responsible for helping with Microsoft Dynamics 365 ERP software implementation// Design and implement forecasting tools in Excel and Power BI that helped Haag-Streit USA reach goal of doubling production in 2022// Create customized tools to break down silos between the Sales Department, Planning, and the Shopfloor to get overdue service orders to customers in a timely manner// Create and manage Bills of Material and routing operations in Dynamics 365// Responsible for issuing and managing Requisitions and Production Orders

Cincinnati, Ohio

// Develop and maintain regional traffic model for long-range planning // Perform fieldwork to collect bicycle, pedestrian, and motor vehicle traffic data// Maintain SQL Server Database for bicycle, pedestrian, and motorized vehicles// Write and update VB.net Script to read files into the SQL Server Database // Use ArcGIS to create new count stations for SQL Server Database// Model and validate transit network files in CUBE Travel Demand Modeling Software and RStudio// Prepare data for public interface website (traffic.oki.org)// Compile report summarizing transit data and results for OKI management// Collaborate with other agencies in Ohio, Kentucky, and Indiana to collect and interpret traffic data and share best practices// Train and managed five graduate student interns// Represent OKI at meetings of Green Umbrella Transportation Action Team, to promote the use of public transit, bicycles, and alternative modes of transportation in the region

Cincinnati, Ohio

// Analyze and manipulate data using Excel and ArcGIS// Manipulate recycling cart data for the City of Cincinnati recycling program to create monthly and yearly recycling tonnage reports, track changes in recycling patterns, create baseline data for studies, and to create canvassing campaign data and maps// Track specific addresses for case studies// Reassign geocoordinates to recycling carts that migrated

Blue Ash

// Responsible for vending machine route planning for the State of Indiana// Plan and create routes to be executed by drivers// Coordinate with Full Service Supervisor and Distribution Center management to ensure schedulecompliance// Use software and the insight of field personnel to predict optimal time to refill machines while considering geospatial factors

// Researched the applicability of including inclusionary zoning in Comprehensive Plan by comparing Cincinnati to cities of similar size and demographics. Cincinnati’s Comprehensive Plan won the national 2014 Daniel Burnham Award// Attended Zoning Board of Appeals hearings// Conducted community outreach programs to solicit feedback for use in the comprehensive plan update

Cincinnati, Ohio

// Solicited funds from corporate sponsors through direct phone contact// Initial intake for individuals with tenant’s rights issues// Participated in a funding drive via mail correspondence

San Pablo, California

// Saved the city in excess of $15,000 by performing a role that would otherwise have gone to aconsultant// Received a cash reward from the City of San Pablo in recognition for my contribution to this project// Updated city-wide inventory of vacant properties and matched house addresses to correspondingGIS parcels// Developed site design schematics to redevelop an underutilized 16 acre property// Performed a range of administrative tasks including: working at the permitting counter, conductingzoning compliance checks at construction sites, delivering zoning hearing notifications to boardmembers, setting up for zoning change hearings, illustrating signage regulations for the zoning code,and attended General Plan Update meetings// Designed notifications in English and Spanish for General Plan Update meeting -10,000 distributed

Master Of Science (M.Sc.), Infrastructure Planning

Master Thesis: "Identifying Urban Heat Island Hotspots in Hamilton County, Ohio"

Bachelor Of Urban Planning, Urban Planning

Activities and Societies: // The National Society of Leadership and Success// Alpha Epsilon Pi Fraternity