Unique Modern Signs
Fri, 01 Mar 2019 00:00:00 GMT -
Tue, 31 Mar 2020 00:00:00 GMT
* Performed bookkeeping task using QuickBooks, including Journal Entry, Reconciliation, General<br> entry, etc.<br>* Performed different types of data process jobs using Excel. Proficient at using Vlookup and Pivot<br> Table and other basic formulas.<br>* Successfully helped with checking variance and provided variance explanations.<br>* Successfully built the Excel budget model.<br>* Performed daily A/R data management, handling Daily Cash, issuing A/R other invoices, maintaining<br> vendor relationship and other multi-task jobs.<br>* Prepared financial statements.<br>* Understood other accounting service procedures, such as payroll, sales tax, individual income tax,<br> etc.
Real Estate Analyst
Sun, 01 Jul 2018 00:00:00 GMT -
Sun, 30 Sep 2018 00:00:00 GMT
* Developed multifamily financial models and cash flow models using Excel and fulfilled cash flow<br> and sensitivity analysis for multifamily properties.<br>* Developed Real Estate market research and trends analysis.<br>* Completed 3 Harvard Review real estate case studies.<br>* Understood Waterfall framework and analysis of other types of commercial real estate.
Researcher & Project Development Manager
Urban Planning and Design Institute; Land & Resource Center of Pingshan
Sun, 01 Aug 2004 00:00:00 GMT -
Tue, 31 Jan 2017 00:00:00 GMT
* Presided over or participated in over 30 urban study projects. Project types included Urban System<br> Plan, Master Plan, and other urban study topics. Successfully finished research topic regarding<br> population prediction, tourist source market and development scale forecasting, land use & industry<br> analyses, and ecological carrying capacity analysis.<br>* Successfully performed qualitative and quantitative analysis, such as Linear Regression Analysis,<br> Analytic Hierarchy Process, Index System, Economic Division, Sensitivity Analysis, using ArcGIS,<br> SPSS, Excel.<br>* Successfully developed skills in SWOT analysis, economic FAR analysis, large-scale public service<br> facility site selection analysis, Scenario Analysis, etc.<br>* Mastered at project execution abilities, such as plan formulation, data collection, qualitative and<br> quantitative analysis, conclusion refining and presentation.<br>* Co-authored 10 published articles. Achieved Senior Engineer Rank awarded by country government.
Beijing Normal University
Sat, 01 Sep 2001 00:00:00 GMT -
Sat, 31 Jul 2004 00:00:00 GMT
* Performed research in three National Natural Science Foundation projects related to<br> biodiversity. Responsible for data analyzing in projects "Optimization of Ecological Production<br> Paradigm in the Farming-pastoral Zone of Northern China", "Policy Sustainability Analysis on<br> Industrial Transformation on the Loess Plateau, China", and "Vegetation Biodiversity Differentiation<br> in Helan Mountain".<br>* Successfully analyzed data using SPSS Cluster, Time Series method, Excel Scenario Analysis and<br> Mapinfo Thematic Map Production.<br>* Successfully calculated diversity index and did breakout point analysis.