Management Microsoft Office

Shanshan (Sunny) Li

607-***-**** ** Andrea Dr, Apt A, Vestal, NY 13850 *****@**********.***

EDUCATION AND HONORS

Binghamton University, State University of New York, School of Management Master of Science in Accounting Expected May 2018

Bachelor of Science in Accounting, Concentration in Management Information Systems Expected May 2017 GPA 3.90/4.00 Dean’s List: Fall 2013 - Spring 2016 CPA Eligible

PROFESSIONAL EXPERIENCE

Whole In The Wall Binghamton, NY

Accounting Intern September 2016 - Present

Assisted supervisor to formulate a customized Excel spreadsheet model to perform monthly sale tax calculation based on state and local tax regulation using and enhanced the efficiency and accuracy of taxation process by 35%

Process payroll by reconcile employee’s timesheet with time clock system, input data into Excel to calculate individual wage, and issue paycheck for all employees through ADP system

Prepare monthly financial statements including income statement and payment summary report to analyze restaurant’s performance Blue Diamond Advisory New York, NY

Financial Analyst Intern July 2016 - August 2016

Performed trend analysis on relevant financial indexes using historic 4 year data to project companies revenue in 5 years

Built financial models including Discount Cash Flow and Comparable Companies tables in Excel to evaluate companies’ fair value

Consulted clients on business development and improvement by constructing an investment thesis and competitive landscape analysis based on financial researches

Binghamton University Libraries, Inventory Management Research Project Binghamton, NY Inventory Management, Bookkeeping Intern January 2016 - May 2016

Improved department efficiency and productivity by at least 20% through designing an inventory database system using Microsoft Excel and Access for management and analytical purposes

Strategized improvement methods for library inventory management based on calculated inventory error ratios and investigation

Handled monetary transactions and prepared commercial invoices with credit and debit balance for each patron Binghamton University, Global Health Impact Project Binghamton, NY Data Research Assistant September 2015 - January 2016

Collaborated with a team of 6 students to organize global health data from various sources such as World Health Organization

Modeled Global Health Impact Indexes using Excel functions including VLOOKUP and Pivot Table to gain quantitative insight on the current medical research topics

Researched independently on healthcare analytical software packages with various simulated scenarios LEADERSHIP EXPERIENCE

Binghamton University Chapter, Golden Key International Honour Society Binghamton, NY Vice President January 2016 - Present

Manage club activities and internal affairs through timely communication with Executive Board and organize weekly meetings

Collaborate 4 colleagues to maintain strong relationships with the officers from campus and Golden Key headquarter

Coordinate 3+ information sessions every semester by inviting guest speakers to share their academic and career experiences Binghamton University, International Connection Binghamton, NY Secretary September 2015 - May 2016

Generated budgets and forecasts for the food committee by estimating customer demand, reviewing the club’s financial situation and analyzing local vendor’s pricing

Negotiated with the restaurant manager about the IC Night food catering to achieve the most cost-effective budget planning

Incorporated marketing strategies into ticket sale around campus which successfully attracted more than 250 participants for the 4th Annual IC Night – Binghamton’s Got Talent

PwC xTax Case Competition Binghamton, NY

Team Leader September 2014

Led a team of 5 to analyze the tax case and brainstormed possible tax regulations towards bitcoin trading and business in Uqana

Conducted financial analysis on relevant ratios in terms of ROI and break-even analysis to support the feasibility of the strategy

Presented the final solution to the PwC panel including strategy recommendation, researched data and corresponding calculations ADDITIONAL INFORMATION

Activities: Binghamton Student Volunteer Center, Student Ambassador, Management Consulting Group, Ascend – Binghamton Chapter Language Skills: Fluent in Mandarin and Cantonese

Computer Skills: Proficient in Microsoft Office Suite; interested in Python, SQL, Visual Basic and R Programing and QuickBooks Interests: Nonprofits, Networking, Communication, Consulting, Modeling and Food Science

Contact this candidate