Yao Zheng

acpwon@r.postjobfree.com Cell: (***) *** – 5183 2341 Reen Drive Lima, OH 45805

EDUCATION

The Ohio State University Columbus, Ohio

Dual Bachelor of Science Degrees, Majors: Actuarial Science and Economics June 2012

Cumulative GPA: 3.4/4.0

EXPERIENCE

Transworld System Inc. Dublin, Ohio

January 2013 – April 2015

Financial Business Analyst

Consolidated and automated extensive data into daily and hourly reports on business operation through the use of Windows

Task Scheduler, VbScript, and VBA Macro in conjunctions with Access queries, Excel pivot tables and intricate formulas.

Projected end of month revenue and operating expense based on recent statistics on a weekly basis

Developed financial models to research client profitability and programs' return on investment

Prepared weekly and monthly consolidation of numerous company dashboards, bu siness reviews, and key performance

indicators

Forecasted long term corporate income and constructed yearlong budgets

Developed project staffing plans, track actual productivity and allocated credits based on collective support

Analyzed and interpreted data to formulate conclusions and make recommendations on areas of concern or opportunity

Ohio Department of Youth Services Columbus, Ohio

September 2012 – January 2013

Intern

Assisted in developing and implementing ODYS' performance based standards for juvenile facilities

Helped maintain the Administration of the Ohio Standards’ Quality Assurance and Improvement Program to ensure that it

follows compliance with recent changes in Stipulations Agreements

Provided assistance as needed with the various auditing processes, design audit tools, conduct data analysis, and policy

development

Sodexo Columbus, Ohio

January 2009 – May 2012

Group Leader

Appointed 10-20 group members with assignments for numerous OSU football games

Managed cash and inventory flows averaging around $10,000 per event

Generated sales revenue of $2,000 within an event hour

ACTIVITIES

Pi Delta Psi - Cultural Fraternity

January 2012 – June 2012

President

Promoted Asian culture through organizing events such as Lunar New Years, Fire Lanterns, and Sumo Wrestling

Spearheaded the first academic program where the fraternity sponsor tutors for struggling brothers

Drafted the chapter’s first bylaws

Implemented a historical documentation system where future generation can learn from the chapter’s past succ esses and

mistakes

Improved chapter’s cumulative GPA by .4

Awarded the Most Improved Chapter of the Year by The Ohio State University

Awarded the chapter’s Brother of Year and Jeopardy Award for the brother who went above and beyond

January 2011– March 2012

10th Annual National Convention Weekend Chair

Obtained the record of highest attendance

Negotiated with Kappa Phi Lambda Sorority, Inc. to share facilities

Accumulated profits exceeding $2,000

January 2009 – June 2011

Treasurer, Academic Chair, Brotherhood Chair, Warden, Lion Dance Chair

Managed over $30,000 in revenue from fundraising, university sponsorship, and membership dues

Increased overall fraternity ending treasury and exceeded the previous year ending amount by $5,000

Awarded the chapter’s Neophyte of the Year

SKILLS

Languages: Conversational in Chinese and Spanish

Computer: Proficient in Microsoft Excel, Access, Word, PowerPoint, VBA Macro and VBScript. Experience with SharePoint,

Eclipse, and Eviews.

Contact this candidate