Xue "Charlene" Mi
*** ******* **. *** *****, CA *1773
424-***-**** ablum6@r.postjobfree.com
EDUCATION
Ohio State University, Mas M Fisher College of Business
June 2014
Specialized Master in Business-Finance, Corporate Finance and Risk
Management Specialization
Columbus, OH
. Highlighted Courses: Financial Modeling, Data Analysis I, II,
Corporate Finance II, III, Derivatives
University of Cincinnati, Carl H. Lindner College of Business
August 2011-April 2013
Cincinnati, OH
Bachelor of Business Administration, Major Finance, Dual Degree
Scholarship (Exchange Program)
. GPA: 3.83/4.00 (Dean's List)
. Highlighted Courses: Corporate Finance, Real Estate Finance,
Investments, Derivatives, Financial Modeling,
. Awarded 2+2 dual degree scholarship from Beijing Jiaotong University
. Member, Beta Alpha Psi, Beta Sigma Chapter, Johnson Investment Counsel
Student Fund
Beijing Jiaotong University, School of Economics and Management
September 2009-July 2011
Bachelor of Business Administration Major: Accounting
Beijing, China
. ERP business analysis and design (SAP)
WORK & LEADERSHIP EXPERIENCE
Financial Analyst Frontier Enterprise
Sept 2014-Now
Ontario, CA
Assist in the development and analysis of Frontier Community's Strategic
Operating Plan
. Analyzing and reporting weekly/monthly business results in light of
fiscal year goals.
. Consolidating of monthly, quarterly, and annual financial results and
actual data from business units and preparing monthly financial
statements for senior management.
. Preparing and executing pro forma modeling, variance analysis and ad
hoc analysis.
Financial Analyst Intern Hilliard Lyons Investment Banking
Feb 2014-May 2014
Columbus, OH
. Served as a team leader to conduct client research project- the
natural gas reserve project, which including conducting the financial
analysis, M&A analysis, and industry research. Created new method for
doing the industry impact analyses which lead to increased efficiency.
. Led team's efforts to do industry analyses by researching historical
data, creating industry M&A transaction report; resulted in increased
awareness of the potential risks and profits.
. Conducted intense due diligence with our corporate clients creating
complex earnings and capital models in order to accurately forecast
and recommend company debt and equity capital structure and/or present
resulting financials to the management team.
Equity Research Intern Morgan Stanley Huaxin Securities
June 2012-August 2012
Beijing, China
. Participated in analysis and valuations of over 5 potential projects,
including IPOs (specialized in healthcare sector), follow-ons, helped
conducted the due diligence of Sany Group, the biggest global company
in the construction machinery industry in China and made project
viable.
. Supported the life science fund for medical centers of the public
research universities, making risk-adjusted NPV analysis and
communicating with potential universities in the country and
successfully increasing the IRR to more than 20%.
. Successfully led the team to build the company valuation analyses of
the Sany Group through data researching and assimilating which
resulted in more efficiency and time saved.
SKILLS, ACTIVITIES & INTERESTS
Languages: English, Chinese (Mandarin)
Technical Skills: HTML, Visual Basic for Application (VBA) Efficient MS
Excel, Access, Bloomberg Certificated, Capital IQ, Crystal Ball, Oracle JD
Edward. Seeking CFA this year