Mandy (Zhiyan) Chen
**** ********* **** 317-***-****
Indianapolis, IN 46228 ********@*****.***
OBJECTIVE
Seeking a full-time position as a financial analyst
EDUCATION
Master of Science in Accounting Indiana University, Indianapolis May 2011
GPA: 3.6/4.0
Major I-CORE project: (A new product development project for Unique Home
Solution)
. Worked with 5 group members to integrate three functional areas of
Marketing, Operation Management and Finance
. Used Excel spreadsheet to analyze the NPV, IRR, and cash flows in the
Finance Section
Finance Project:
. Assessed corporate performance by calculating NOPAT, Invested
Capital, ROIC and EVA.
. Measured the risk of financial instruments and adjusted risk level
through portfolio diversification, futures and options
IDA S. Broo Scholarship - awarded based on outstanding academic
performance in accounting 2010
Bachelor of Science People's (Renmin) University of China, Beijing
GPA: 3.6/4.0
Excellent Leader Scholarship - awarded to excellent leaders of school
organizations 2007
Second Class Scholarship - awarded to top 10% students in School of
Science 2006, 2008
EXPERIENCE
Financial Planning & Analysis Intern Belden Inc, Indianapolis, IN Oct
2010-present
. Generate international weekly sales and orders report for management
to update forecast
. Coordinate with different divisions to generate corporate level
freight forecast report
. Develop Excel-based tools to analyze operational and financial
information utilizing income statement, Business Planning and Control
System (BPCS), Business Intelligence (BI) systems and Hyperion
Financial Management
Accounting Intern Better Accounting Firm, Guangzhou, China Jan 2008-
Jul 2008
. Performed bookkeeping for more than 20 clients using Yongyou ERP
System
. Participated in reconciling monthly bank statement reconciliation,
performing monthly closing and maintaining general ledger
. Assisted controller in preparing monthly financial statement and
reconciling accounts against budget
. Collaborated with clients and co-workers in generating 8 audit reports
Chief Editor & Co-founder Journal of Science School, People's University
of China 2006-2007
. Liaised with university administration to secure funding and
facilities
. Established a new publishing process by adapting different related
experiences
. Recruited staff of 25 and provided training workshop series to ensure
the staff's qualification
. Increased circulation successfully by 35% through strategic surveying
ACTIVITIES / SKILLS
. Member, Indiana CPA Society Jan 2010--present
. Volunteer, Indianapolis Community Church Aug 2008-present
. Languages: fluent in Chinese (Cantonese and Mandarin)
. Software: Proficiency in MS Office (Excel Expert)
PS. Sitting for CPA exams and willing to relocate[pic]