Post Job Free

Resume

Sign in

Business Analyst Forest Products

Location:
Madison, WI
Posted:
January 29, 2023

Contact this candidate

Resume:

XI YANG

+1-708-***-**** •linkedin.com/in/xi-yang-0101/ • adu0hi@r.postjobfree.com

PROFILE

Solid background in data and business analysis skills. Two years of working experience in the trade financing industry developed my financial knowledge as well as communication skills and allowed my passion for quantitative analysis for business and research to soar. I am interested in expanding my skillsets through an analytics internship. EDUCATION

University of Wisconsin-Madison, Wisconsin School of Business, Madison, WI 09/22 – 12/23 Master of Science in Business Analytics (STEM-designated)

• GPA: 3.92/4.00

• Key Coursework: Machine Learning, Data Technology for Business Analytics, Prescriptive Modeling and Optimization, Marketing Analysis, Data Visualization, Experiments and Causal Methods for Business Insights, Cloud Computing University of Chicago, Chicago, IL 10/18 – 06/20

Master of Public Policy

• Key Coursework: Principles of Microeconomics and Public Policy, Statistics for Data Analysis, Program Evaluation, Corporate Finance, International Trade, Banking and Capital Markets, Financial Accounting, Strategic Behavior and Regulation of Firms

• Scholarship from China Scholarship Council

• China Night at Harris School of Public Policy Activity Manager (2018-2019) University of International Relations, Beijing, China 09/14 – 06/18 Bachelor of Management in Administrative Management

• GPA: 3.71/4.00

• Students’ Life Department Leader (2015-2016)

PROFESSIONAL EXPERIENCE

China National Forest Products Group Company Limited (CFPC), Beijing 10/20 – 06/22 Business Analyst, Treasury Department

• Trade Financing Business: Cooperated with 12 financial institutions on various trade financing businesses, such as banker’s acceptance, working capital loans, letters of credit, and finance leases, with a total financing volume of 4.4 billion RMB

• Data Analysis: Collected, monitored, and analyzed monthly data concerning wholesale and retail commodity sales and inventory, production, financial, and operation status; reported to Beijing Municipal Bureau of Statistics

• Financial Monitoring: Monitored the financial status of CFPC and 43 subsidiary companies by conducting monthly and weekly financing status tables, 6-month debt maturities, and payment status to improve capital management Deloitte Enterprise Consulting, Beijing 01/18 – 06/18 Consultant Intern, Department of SOE Reform & Belt and Road Initiative Services

• Conducted survey among 166 state-owned enterprises regarding outbound investments to analyze responses and policy trends of “Belt and Road”

• Composed 100-page white paper “Trends and Solution of Outbound Investment under Belt and Road Initiative”, putting forward suggestions on overseas investments

SELECTED PROJECTS

Examining the Effectiveness of National Peace Policies (R, Stata): Mined statistics of 13 factors measuring peace situation, including Economic Inequality, State Legitimacy, Refugees and IDPs, Human Rights, etc., among 19 countries. Applied R to realize data cleansing and visualization and carried out hypothesis testing and regression analysis on factors for each country. Adopted

“Difference-in-Difference” model in Stata to implement in-depth analysis of the effectiveness of peace policies on different factors and presented report for cooperative partner “+Peace”, an NGO advocating peace establishment. Analysis of Dollar Effect of Insurance Coverage on Annual Illness-related Hospital Visits (R): Processed first stage & second-stage regression analysis, OLS regression, reduced form regression, and IV package in R to determine appropriate instrument variable. Analyzed treatment effect among different age groups in Chicago, finding expanding health insurance will reduce hospital visits for people aged between 25-64, while it will be the opposite for those aged 65+. Build Optimization Model for MSBA Course Scheduling Problem (Python): Applied the Pyomo glpk package to build the model Kaggle Competition - Predict Future Sales (Python): Participated in the competition and applied the additive model to predict sales TECHNICAL SKILLS

Advanced Excel (Solver, Pivot Tables, VLookup), R, Python, Stata, SQL, Tableau, Power BI, cloud platforms and tools (e.g. Snowflake, AWS Redshift, S3, Google Cloud)

ADDITIONAL INFORMATION

Languages: Chinese (Native), English (Fluent). Interests include: video editing, playing the Guzheng.



Contact this candidate