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