Excel modeling, VBA, DCF, Argus

Kaiyi Katherine Wang

*** * **** ** • Lombard, IL, 60148 • 217-***-**** • *************@*****.***

EDUCATION

University of Illinois Urbana-Champaign, IL

Master of Science in Finance, May 2014 GPA: 3.6/4.0

State University of New York at Stony Brook Stony Brook, NY

Bachelor of Science in Applied Math & Statistics, minor Economics, Dec 2011 GPA: 3.5/4.0

Cum Laude, Dean’s List Major GPA 3.7/4.0

EXPERIENCE

Research Assistant Urbana -Champaign, IL

University of Illinois, College of Business; School of Labor and Employment Relations Nov.2013 – May. 2014

• Empirical research topic: CEO Dismissal and the CEO’s Symbolic Use of Shareholder-Value Language.

• Extracted and compiled data from primary sources and data bases on US top 300 public companies in 10-year horizon.

• Identified and entered relevant qualitative and quantitative data information to define measureable model variables.

• Performed empirical data analysis on variables using Excel and STATA. Advisor: Dr. Taekjin Shin

Financial Advisory Consultant

Illinois Business Consulting Dec.2013-March. 2014

• Modeled and Completed detailed financial statement analysis for the client from scratch to provide forecasting platform.

• Performed sensitivity and ratio analysis to make business continuing and developing recommendations.

• Prepared visual and verbal analytical deliverables to meet client’s needs on a weekly basis.

Government and Public Relations Manager (Full time) Ann Arbor, MI

Global Bridges Network, Co.Ltd June.2012-May.2013

(a Michigan based legal consulting group affiliated to Kerr Russell)

• Researched developing countries real estate market in Asia-pacific region and made recommendations to investors.

• Promoted and implemented consulting services for 2 long-term developing real estate projects.

• Developed investor lists & introduced opportunities to invest in China and the US.

• Maintained effective relationships with 5 international clients including private companies and government agencies.

• Created and executed several road show and investor conference logistic schedules.

Treasury Assistant (Internship) New York, NY

Bank of Communications, Co.Ltd – New York Branch Jan.-March.2012

(one of top 5 Chinese banks, Fortune 300, over 50,000 employees)

• Completed training for Foreign Exchange, Bond & Money Market.

• Maintained accounts and daily bond and derivatives settlements with partner banks and brokers.

• Streamlined effective relationships with brokers, back office and operational departments.

SKILLS

Language: Fluent in English, Chinese

Computer: Proficiency in MS Excel, VBA; Practitioner of Argus DCF and Argus Developer.

CERTIFICATE

CFA Level I Candidate (June 2014, plan to sit for Level II exam in June 2015)

Enrolled in CPA Preparation Program – Northwestern University School of Continuing Studies

LEADERSHIP

Chinese Business Students & Alumni Association, UIUC Chapter Urbana-Champaign, IL

Co-founder, Vice President of Operations July.2013-Present

Organizing fund-raising, team building activities and day-to-day management.

•

Initiating alumni and corporation network for UofI Chinese business graduate students in the Greater Chicago Area.

•

SIFE – Students in Free Enterprise (Enactus) Shenzhen & Hong Kong, China

Vice President Dec.2007- Jan.2010

Supervised and consulted 6 projects with up to 76 agents.

•

Managed team treasury department and training activities.

•

Co-created & Developed online carpool project, successfully launched a for-profit website.

•

Recruited and managed an engineering team to design carpool information search engine.

•

Contact this candidate