Wenting (Jackie) Chen
**** **** **, ** *****?Tel: 218-***-****?Email: ******.*****@*****.***
QUALIFICATION
. Extensive work experience in real estate brokerage firm and investment
firm.
. Skilled in due diligence, discounted cash flow modeling, waterfall
analysis, and risk analysis.
. Proficient in Argus, Excel/VBA, SPSS, Oracle/SQL, PowerPoint,
PhotoShop, ArcGIS.
EXPERIENCE
ASK CAPITAL, New York, NY
Acquisitions Analyst (Apr 2010-Present)
Investment Analysis Intern (Oct 2009-Jan 2010)
. Conducting due diligence and market research to screen over 100
multifamily acquisitions.
. Developing cash flow models in Excel with VBA to evaluate properties
worth 300k -1mm.
. Structuring financing scenarios and waterfall analysis to evaluate the
ROIs for equity investors and debt investors.
. Sourcing hard money lenders and construction loan factoring programs to
smooth the cash flow.
. Preparing performance overview presentations for the investment
property portfolios.
BERKO & ASSOCIATES, New York, NY
Market Research Intern (Aug 2009-Jan 2010)
. Prepared property-level pro forma and location analysis maps for
marketing set-ups.
. Searched over 500 sales / rent comparables within StreetEasy, Loopnet,
Costar, PropertyShark.
. Conducted cold calls and internet research to identify potential deals
and clients.
SOUTHEAST MICHIGAN COUNCIL OF GOVERNMENTS, Detroit, MI
Data Analyst (Jun 2008-May 2009)
. Built the land use geodatabase of the seven-county region using ArcGIS
for forecast modeling.
. Acquired paper-based data through cold calls and imported raw data into
Oracle database.
EDUCATION
UNIVERSITY OF MICHIGAN, Ann Arbor, MI
MS in Urban Planning / Real Estate (2007-2009)
. Financial knowledge: loan pricing, waterfall analysis, discounted cash
flow models, financing option evaluation, sensitivity analysis,
appraisal, CMBS, portfolio returns and risk
. Computing techniques: Argus, Excel/VBA in financial settings, SPSS,
Oracle/SQL, ArcGIS
. Projects: calculated NPV, IRR, DSCR and structured financing options to
evaluate a Renovation Project of the Rental Lofts in Woodward Center in
Detroit; composed a professional business plan with 5-year cash flow
analysis for a transit-oriented mixed-use development
PEKING UNIVERSITY, Beijing, China
BS in Economics / Real Estate (2003-2007)
. GPA: 3.72/4.0, one of the best two universities in China
. Selected Coursework: econometrics, accounting, probability and
statistics, economics, economic evaluation of construction projects,
value assessment of real estate
. Summer Internship: 1/100 applications that worked for the real estate
research team of University of California, Berkeley Institution of the
Environment to study on green communities
HONORS
Best Design Prize, Ross School of Business, University of Michigan, 2007
Wallenberg Scholarship, University of Michigan, 2007-2009
Good Performance Prize, Sun Hung Kai Properties Campus Contest, 2006