Zhongchen Jian

New York

Overview

years of professional experience

Hong Kong Land

Chongqing, China

07.2025 - 09.2025

As part of the central leasing team, conducted a comprehensive macro-economic benchmark study across major Chinese Tier-1 and New Tier-1 cities, analyzing GDP growth, consumption power, demographic trends, and high-net-worth population distribution to prepare for a new luxury shopping mall.
Supported the leasing strategy and commercial performance analysis for a portfolio of luxury shopping malls, including Plaza 66, Grand Gateway 66, focusing on tenant mix, rental efficiency, and sales trends to support brand mix and leasing decisions.
Built a data-driven retail performance dashboard using Python, Excel, and Tableau, integrating rental income, tenant sales, occupancy, and foot-traffic data from 10+ malls; improved reporting efficiency by 30% and standardized weekly financial review templates used by the leasing team.
Conducted tenant-level performance analytics to identify high- and under-performing categories, benchmarking brands under LVMH, Kering, and Richemont to support renewal decisions and store expansion proposals.

Capgemini

Shanghai, China

07.2023 - 09.2023

Partnered with a cross-functional consulting team to support a digital transformation project for a global automotive client, focusing on customer experience optimization and product feedback analysis.
Developed a scalable review-collection workflow using Python, Selenium, and MongoDB, enabling automated extraction and storage of 10,000+ online customer reviews across automotive forums, e-commerce platforms, and social media sites.
Cleaned and processed raw text data through tokenization, stopword removal, and lemmatization, and applied pretrained sentiment-analysis models to surface key themes and customer pain points.
Organized customer complaints into major issue categories (e.g., battery performance) and helped translate these insights into client deliverables, contributing to a 20% improvement in feedback-categorization accuracy and a 15% reduction in client response time.

Columbia University

New York, NY

12.2026

University of California, Berkeley

Berkeley, CA

05.2025

Data Wrangling: Pandas, SQL