Financial Analysis, Data Modeling

DI LU

***** *** ********** **., ***** Bethesda, MD 20852 • **.******@*****.*** • 240-***-**** • linkedin.com/in/dilu0324 EDUCATION

University of North America Vienna, VA

Master of Business Administrative (MBA) with specialization in Accounting July 2015 - Present Robert H. Smith School of Business, University of Maryland College Park, MD Master of Finance Aug 2012 - May 2014

• GPA: 3.70

• CFA Level II Candidate, FRM Part II Candidate

Tianjin University of Finance and Economics Tianjin, China Bachelor of Economics in International Finance Sept 2008 - July 2012

• GPA: 3.70 Rank: Top 3/150

Bachelor of Management in International Hotel Management

• GPA: 3.78 Rank: Top 5/93

• First Class Academic Scholarship (3 years consecutively), Honor of Excellent Graduation Thesis (Top 10%) WORK EXPERIENCE

Navigant Consulting Inc. Washington, DC

Risk Analyst – Project Contractor Nov 2015 - Present

• Research relevant mortgage servicing process and regulations, perform loan testing and audit test procedures to determine the compliance with current mortgage regulations

• Review legal documents, affidavits and repayment history of thousands of mortgage loans to understand the circumstances surrounding each foreclosure and bankruptcy

• Contribute to the development of models including spreadsheet and database analysis using Excel and SAS Ozburn-Hessey Logistics Brentwood, TN

Corporate Real Estate Analyst Mar 2015 – Jun 2015

• Researched industrial real estate statistics and analyzed market insights from Costar and other national reporting agencies such as JLL, CBRE and Cushman & Wakefield for internal reporting

• Performed strategic real estate market analysis such as potential clients, competitors’ location, local tax climate and labor availability on UK and Netherland for business development in Europe

• Developed financial analysis reports using Excel, Oracle Essbase and GP Anyview to track data of real estate such as straight-line rents, CAM (Common Area Maintenance), property tax and insurance expenses Hobsons Arlington, VA

Order Management Intern Jan - Mar 2015

• Accurately processed over 300 sales orders in Salesforce in 3 days to ensure the annual conference held on time

• Interacted with account executives and sales directors to review sales orders for contract integrity, data accuracy and process completion

SNOBSWAP Washington, DC

Business Analysis and Strategy Intern Aug 2014 - Jan 2015

• Analyzed sellers’ performance based on sales indicators and project financial statements under different business models to provide strategic recommendations

• Updated sales dashboard to measure business operation performance and draft monthly investor reports

• Created website dashboard with Excel and Google Analytics to analyze trends of data, pinpoint website blind points and measure the impact of website changes on traffic and conversion rates Tianjin Commodity Exchange Co. Limited Tianjin, China Project Management Intern Sept 2011 - Feb 2012

• Performed DCF (Discounted Cash Flow) valuation and scenario analysis on a wood pulp project with 500,000-ton annual capacity for determining whether to launch the project

• Prepared weekly briefings for senior management concerning project preparation status, new development initiatives and billings-to-date to support project execution, accelerating the project progress by 3 weeks SKILLS

Languages: Chinese (native), English (Fluent)

Technical: MS Office, Matlab, VBA, SAS, SQL, Oracle Essbase, GP Anyview, Eviews, SalesForce, Morningstar Direct and Bloomberg Terminal

Contact this candidate