Master of Regional Planning candidate at Cornell University (2025 – 2027). I build decision tools, optimization models and spatial analytics for cities and the people who move through them — from a live web product to routing models and accessibility studies — and I am currently applying AI methods (RAG, agent workflows) to enterprise digital-transformation research.
jg2582@cornell.edu · LinkedIn · Résumé (PDF) · Project index with reports
| Project | What it is | Stack |
|---|---|---|
| Stay or Return · live site | Explainable decision tool for Chinese international students weighing a U.S. or China career: 24 questions across 6 dimensions, a transparent weighted-gap model, sensitivity analysis, private sharing by URL fragment | Next.js 15 · TypeScript · Vercel |
| low-altitude-vrpd | Truck-drone collaborative delivery for the low-altitude economy: MILP (Gurobi) with a genetic-algorithm warm start, tested reproduction of a 50-customer Shenzhen case study; the mixed fleet is the most efficient option in the case study and in 10/10 random instances | Python · Gurobi · pytest · CI |
| manhattan-mobility-access | Walking-time access to bus, subway and bike share for 303 Manhattan census tracts and 3,221 service nodes; K-means typologies and OLS linking poverty share to longer walks | OSMnx · GeoPandas · scikit-learn · statsmodels |
| shenzhen-multimodal-accessibility | Door-to-door travel times to hospitals, schools and parks by walking, cycling, driving and metro for 77 neighbourhoods; 70 % face a metro-vs-car gap above 15 min | ArcGIS Pro Network Analyst · pandas · matplotlib |
| hainan-rainforest-storymap · read it | First Prize, 2024 Esri China GIS Development Competition (team of 4): a five-chapter story map of Hainan Tropical Rainforest National Park; I built the web maps and 3-D scenes and the Landsat-based ecological-index assessment, 1987 vs 2007 | GeoScene Pro / Online · Google Earth Engine · Python |
Planning and research reports (TOD plan, historic-district design guidelines, 15-minute city, community research) are collected in My_Projects/reports.
Digital Transformation Research Assistant — China Academy of Information and Communications Technology (CAICT), Shenzhen · May 2026 – present
- Audit an enterprise digital-diagnostics platform (42 business modules, 1,134 function points) and catalogue 164 industrial digital products across 27 categories.
- Apply RAG, agent workflows and tool calling to connect knowledge retrieval, product matching and report generation, cutting report-processing time by about 30 %.
- Lead 12 manufacturer interviews and turn business pain points into platform requirements and consulting proposals.
Research Assistant, Prof. John I. Carruthers — Cornell University · Oct 2025 – present
- Build research databases from BEA, BLS, FRED, Census and GIS sources (3,080 U.S. counties × 99 indicators; a 31-province Chinese panel with 2,790 observations × 45 variables).
- Location quotients, instrumental-variable and panel models, gravity models in Stata / Python / QGIS.
- Built a 67-sector 2022 U.S. input–output model and traced a construction-demand shock through inter-industry linkages (output multiplier ≈ 1.76).
Strategic Research Intern — ZTE Corporation, Beijing · Feb 2025 – Jun 2025
- Industry and siting research for advanced displays, semiconductors and biopharma: 40 white papers and market sources synthesised, 7 industrial parks surveyed, 5 candidate plans compared; three recommendations entered the final plan.
Strategic Analysis Intern — Guangzhou Urban Planning & Design Survey Research Institute, Liwan Branch · Jun 2024 – Aug 2024
- Building–site–risk framework in ArcGIS for 132 buildings and 300+ risk locations; risk maps, treatment lists and a green-space plan (≈ 15 % more site green area).
Industry Research Assistant — University of Cambridge (multi-city indicator study) · Sep 2023 – Jan 2024
- Twelve-city database of density, infrastructure spending, emissions, green space, housing prices and air quality; regression models with robustness checks packaged as a reproducible pipeline.
- Cornell University — Master of Regional Planning, College of Architecture, Art & Planning, 2025 – 2027. Coursework: Machine Learning and AI; Urban Data Analytics; Systems Engineering and Optimization; Regional Economic Analysis.
- Hainan University & Arizona State University — B.S. in Human Geography & Urban–Rural Planning, Haiya International College, 2021 – 2025. GPA 3.88 / 4.00 (rank 10 / 103). First Prize, 2024 Esri GIS Development Competition; Dean's Scholarship.
Gong, J. (2024). Strategic Analysis on Improving the Proximity and Accessibility in China: An Exploratory Development Based on the Study of the 15-Minute City. Highlights in Science, Engineering and Technology, 86, 66–73 (CEAT 2024).
| Data & econometrics | Python (pandas, scikit-learn, statsmodels), SQL, Stata, SPSS, Excel; regression, clustering, panel and IV models, robustness testing |
| Spatial | ArcGIS Pro, QGIS, OSMnx / GeoPandas, network analysis, spatial matching and visualization |
| Optimization | Gurobi, mixed-integer programming, heuristics and genetic algorithms, scenario simulation |
| AI applications | RAG, agent workflows, tool calling, prompt / context design, source-grounded generation, baseline evaluation |
| Product & web | B2B customer interviews, requirements analysis, PRDs and prototyping; Next.js, TypeScript, Vercel |
| Languages | English (professional), Mandarin Chinese (native) |
2027 graduate roles in AI application products, enterprise solutions, product strategy, business analysis and technology consulting.
Libraries I lean on for transportation data: transbigdata · transdim · TrafficIndex