● Collect and analyze office building market information data in Chicago's urban and suburban areas (approximately 4,000+ data per quarter), including rent, vacancy rate, supply and absorption, etc. Use tools such as Excel and MySQL to analyze the market status and future trends, conduct q-o-q and y-o-y comparisons, and use Tableau tools to form quarterly market reports.● Use MySQL from 0 to 1 to build an online database specifically designed for brokerage teams, customers and operations teams, covering a total of 200+ office buildings and industrial parks in urban and suburban areas of Chicago. Also, use Tableau to build a dashboard for the above data, and maintain the database weekly.● Use Excel to build a series of data statistical tables for the brokerage team, asset management team and engineering team, streamlining the previous form process by 50% and increasing the accuracy by 70%. At the same time, Python was used to analyze transaction information to increase the accuracy of project advertising and increase the transaction rate by 11%.

● Led a four-person team to manage the group's leasing and acquisition business of 135 office buildings across the country, totaling 400 million SF and more than 1,300 contracts. Use Excel and Python to analyze the group's leasing data to find the best cost-reduction solution in different cities according to their specific business budget and labor cost. Ultimately, through leasing data analysis and strategic negotiations, a cost reduction of $6.07 million was achieved in fiscal year 2022.● The rental cost in the next year is predicted based on the business department's future growth plan and the city's rental trend forecast using the regression model, providing a reference to formulate labor costs.● Designed the commuting heat map of the group's employees by Python to provide a reference for the group's office relocation selection, and assisted HR in reducing the turnover rate caused by office relocation to 3%.● Cooperated with the group platform technology team to build the contract management platform design, redesigned the functional presentation and dashboard, and helped the real estate team increase document processing speed by 27%.

• Mainly provide on-site office leasing and investment consulting services for two Chinese clients, Bytedance (parent company of Tik-Tok) by cooperating with global JLL brokers, mainly in the area of Chinese mainland, South& East Asia, Europe, and Africa• Provide contracts examination service for the client with about a hundred contracts as an expert• Cooperate with the team to bid for new clients, including Oracle, Starbucks, Jindong Group, Meituan Group, etc.• High praised by the clients and get an average of 25% pay rise annually

• As a broker both in LR and TR fields; in LR projects, as a leader in a team of 4 of 2 Grand A office buildings and a team member in another office building• To Wantong Center, in the case the vacancy rate of Tianjin core area market reached nearly 50%, the pre-lease rate reached 30%; at the same time, the average monthly rent of the project ranked first in the city• Provide TR service for more than 20 clients, such as Amazon, PPG, NNIT, Astellas, etc.

• Draft and present project marketing strategy reports for developers, governments, and strata title individuals, including market research, project analysis, recommendation marketing channels, cost budget, timelines, and follow-up monitoring methods.• Negotiate prices and contract clauses with various marketing channel providers, sign cooperation agreements, monitor execution status, adjust as necessary, and provide feedback promptly.

• Independently responsible for the activities section, formulating annual event arrangements, and organizing various node activities such as weekend house viewings, project openings, old customer networking, media conferences, house viewing group receptions, etc. The number of participants ranges from 50 to 500.• Find target customers through various means, including but not limited to Weibo, radio, outdoor advertising, LED screens, various magazines and website media, and establish long-term cooperative relationships on each platform.• Actively communicate with inside and outside the industry to keep abreast of market trends, constantly look for and learn marketing innovation models, and promote sales growth.