top of page

Resume

Education

University of Pennsylvania

Expected May 2025

Master of City Planning, Concentration in Sustainable Transportation and Infrastructure Planning

New York University

Sep 2019 - May 2023

Bachelor of Science, Double Major in Interactive Media and Business and Social Science (Urban Studies track)

Skills

Geo-spatial and Data Analytics

ArcGIS | QGIS | R | Python | SQL | VISSIM | VISUM|

Graphic and Office Skills

Microsoft Word, Excel, PowerPoint | Illustrator | InDesign | PhotoShop | SketchUp

UX Design/ Research

Wireframing | Storyboarding | Prototyping | Usability Testing

Experiences

Reinvestment Fund

Sep 2024 - Present

Intern

  • Utilized ArcGIS to map zip codes alongside eviction and income data, highlighting the significance of the Right to Counsel.
  • Cleaned ACS data with SQL to highlight housing and mortgage lending disparities in suburban Philadelphia, visualizing findings through maps.
  • Contributed to Python script to match across different datasets about child care resources. 
Hatch Associates Consulting

Jun 2024 - Aug 2024

Port Planning Intern

  • Created visual representations of facilities and zoning for Pascagoula, Port of Los Angeles, and McKinley County Inland Port using QGIS and Adobe Illustrator for planning documentation.
  • Coordinated with over 15 and 10 sub-consultants under the NYC Development Corporation contract, drafting 30+ project sheets focused transportation planning.
  • Contributed to the Port of Philadelphia's 30-year vision memo by analyzing existing studies to improve future planning.
  • Aided business development by analyzing vacant land in Pittsburgh with ArcGIS, producing maps to suggest development strategies for urban renewal projects.
University of Pennsylvania

Sep 2024 - Present

Teaching Assistant for Social Science in GIS

  • Helped Professor Casey Ross troubleshoot technical problems and support students to apply GIS into storytelling and social research.
  • Offered office hours to provide constructive feedback on students' assignments to utilize ArcGIS in analyzing social issues.
University of Pennsylvania

Jan 2024 - May 2024

Research Assistant

  • Collaborated with Professor Erick Guerra to conceptualize the integration of Virtual Reality in urban planning for the Roosevelt Boulevard Project.

  • Conducted a comprehensive literature review as part of a team to provide support for the project, focusing on the justification, advantages, and challenges of using VR.

William(Jiyan) Wang

©2024 by Jiyan (William) Wang

bottom of page