Resume

Rujie Cheng

Pittsburgh, PA · Willing to relocate

Last updated: 2026.10

Master of City Planning & Certificate in GIS and Spatial Analysis

2024.08–2026.05

Philadelphia, PA

GPA: 3.91/4.0; Weitzman School of Design Scholarship; Bruce J. Hansen Award
Relevant Coursework: Modeling Geographic Objects/Space, Statistical and Data Mining Methods for Urban Data Analysis, Multimodal Transport, Urban Economics and Public Finance, Public Policy Analytics

Bachelor’s Degree in Sociology

2019.09–2024.07

Beijing, China

AICP Candidate: Exam passed 2025.11
GIS & Data Analysis: ArcGIS Pro, QGIS, R, SQL, Python, STATA, SPSS, Salesforce, Microsoft Excel
Design & Visualization: Adobe Creative Suite (InDesign, Illustrator, Photoshop)
Languages: Mandarin Chinese (Native), English (Fluent), Japanese (Intermediate)

Planning Intern

2026.06–Present

Pittsburgh, PA

Used QGIS to build and manage spatial datasets, perform spatial analysis, and visualize geospatial data; produced 20+ deliverable-ready maps across multiple active transportation projects and proposal pursuits
Developed a 36-page transportation and mobility existing conditions report for the Allegheny County comprehensive plan update, translating complex datasets into clear maps and findings for client review
Supported a PennDOT Vulnerable Road User Safety Education Program pilot in Pittsburgh by engaging directly with community members, gathering feedback, and informing materials for broader public release

Planning & Real Estate Consulting Intern

2025.12–2026.05

Remote

Evaluated parcel redevelopment potential across a ~3,700-acre study area in ArcGIS Pro by analyzing and integrating transportation accessibility, POI/LBS activity, and public facilities; shortlisted 3 priority nodes for concept planning.
Conducted policy and real estate market research for Jing’an District and translated findings into client recommendations, reports, and bid presentation materials.

Navy Yard GIS & Planning Intern

2025.06–2025.08

Philadelphia, PA

Developed an employer-provided transit incentive study, authoring memos with existing policies, best practices, and 3 employer engagement strategy recommendations for Navy Yard’s multimodal campaign
Researched and prepared 4 briefs of grant opportunities, outlining potential funding sources for projects in energy infrastructure, mobility, and workforce development
Maintained and updated the Navy Yard’s campus asset and shuttle operations databases in Microsoft Excel and Salesforce, advancing data precision by 15% and enabling streamlined data-driven decision-making processes

Group Project

2025.08–2025.12

Co-developed a three-scenario redevelopment report to inform the City of Lancaster’s Small Area Plan development for Park City Center, integrating site circulation, parking, land-use allocation, and related implementation considerations
Conducted housing market analysis for Lancaster and the project-area census tract; compiled property-level rent data to support discounted cash flow inputs and scenario evaluation
Led final report production; created templates in InDesign and Illustrator and managed final QAQC for print-ready export

Individual Project

2025.04–2025.05

Built a space-time predictive model in R integrating IndeGo trip data, Census socio-economic data, and ASOS weather data to forecast hourly bike demand at the station level, achieving prediction errors within one trip per station-hour
Identified key spatial-demand patterns; devised truck-based rebalancing intervention for high-demand and underserved areas

Group Project

2025.01–2025.05

Collaborated in a team of 7 to develop a downtown revitalization action plan for Haddon Avenue in Haddon Township, NJ, translating field findings into prioritized actionable strategies for placemaking, business support, housing, and mobility
Conducted block-by-block field audits of curb ramps, street furniture, and pedestrian crossings; built a geocoded GIS inventory and mapped pedestrian infrastructure gaps to support safety and accessibility project prioritization