Post Job Free

Resume

Sign in

Excel, Word, QuickBooks, Python, Tableau, Altreyx

Location:
Brookline, MA
Salary:
20/hour
Posted:
May 25, 2021

Contact this candidate

Resume:

Lingyun (Kris) Shao MA, Brookline, *****781-***-**** ● admo3l@r.postjobfree.com

https://www.linkedin.com/in/lingyun-kris-shao/

EDUCATION

Bentley University McCallum Graduate School of Business, Waltham, MA MS in Accounting Analytics • Business Analytics - Grad Certificate GPA: 3.85 May 2021 Selected coursework: Advanced Information Systems, Statistical Modeling for Business, Financial Accounting Shanghai International Studies University, Shanghai, China Bachelor of Management in Accounting GPA: 3.67 May 2019 Major: Accounting

SKILLS

• Analytical: Data Wrangling, Data Visualization, Time Series Analysis, Financial Modeling, Database Management

• Technical: Python, Excel (Pivot Table, VBA), Access (QBE, Macro), Tableau, R, SAS, SAP, QuickBooks, Oracle ACADEMIC PROJECT

Statistical Modeling for College Football Course: Statistical Modeling for Business Feb 2019 – Apr 2019

• Performed Data Wrangling on 80+ ranking variables using SAS and R

• Applied Cluster Analysis using SAS to extract three hidden factors to succeed in 2019 College Football season results

• Built logistic regression models to identify whether defense played a more significant role on season results than offense Bentley University, Faculty-supervised research project on AI for Tax and Finance June 2020 – Aug 2020 Research Assistant

• Explored practitioner articles and reports on emerging technologies, i.e. machine learning, e-business, block chain

• Synthesized article details and key data to research effects of IoT and computerized tools on business EXPERIENCE

Pipestone Payments, NY, US Sep 2020 – Dec 2020

Business Consultant Intern

• Research target demographics, economic trends and customer needs to create strategies for business development

• Analyze financial statements and prepare effective financial plans to suit individual customers

• Visualize data collected from research with Python to evaluate market penetration and identified potential customers

• Build consistent relationships with existing partners through follow up and frequent updates on product developments Walt Disney Company, Shanghai, China Jul 2018 – Dec 2018 Financial Analyst Intern

• Remodeled daily flash template in MS Excel to collect and analyze daily sales for annual operation planning

• Communicated weekly with US headquarter about discrepancy between SAP and other systems to ensure reconciliation

• Built regression model of traffic to design monthly & quarterly forecast reports based on prior year data and holidays Beckman Coulter, Shanghai, China Nov 2017 – Feb 2018 Strategic Planning Consultant Intern

• Integrated sales data of 500+ distributors mapping from various data sources to present market sell-through reports

• Cleaned sales data with MS Excel to assess local market coverage of 1000+ dealers

• Visualized sales range of dealers with MS PowerPoint for sales strategy planning CERTIFICATIONS

• CMA and ACCA Member; CISA Candidate

COMMUNITY INVOLVEMENT

• Vice President, Graduate Accountancy Association 2020 – 2021

• Member, Beta Alpha Psi Bentley University Theta Gamma Chapter Sep 2020 – Dec 2020



Contact this candidate