Business Analyst

iGdP*W**************

Columbia l i University i i i in the City i of New York

Applied Analytics Master School of Professional Study GPA: 3.64 / 4.00 Sep 2021 - Aug 2022

New York, NY, US

Relevant Coursework: Financial Analysis Financial Accounting Valuation Analytics Frameworks and Methods (R) Applied Analytics in Organizational Context Storytelling with Data (SQL, Tableau) Strategy and Analytics SQL & RELATIONAL DB University i i of California li i Irvine i

Business Economic minor Accounting Bachelor of Art GPA: 3.1 / 4.00 ( Major GPA: 3.70 / 4.00) Sep 2016 - Aug 2020

Irvine, CA, US

Major Course Completed: Economics (Micro, Macro, Global) Applied Economics Accounting management Honors & Awards: DEAN’S LIST earned three times

Business Analyst / Data Analyst

Proficient: Microsoft Office, Google Workspace, PostgreSQL Familiar: Python, Tableau, Financial Analysis, Accounting Excellent communication skills, always positive and motivated at work Airsoft i Wholesaler, l l Inc.

Business Analyst

Jan 2021 - Jun 2021

Santa Fe Springs, CA

Predict future selling prices according to market price trends and adjust product pricing in time; formulate inventory and replenishment plans based on sales forecast results

Use Excel and OMS ERP to carry out multiple analysis projects to support decision-making Holidale li l Inc.

Property Manager & Accountant

Sep 2019 - May 2020

Irvine, CA, US

Main Projects: House Automation Renovation Program Student Housing Plan Communicated with landlords and tenants and coordinated their relationship Performed financial analysis, calculated the company's daily profit and loss Controlled and reduced operating costs, reported the company's annual tax, and wrote the report School l Project: j Netflix li Valuation l i Feb 2022 - May 2022 Summarizes the company’s business, industry, strategy, opportunities, and risks. Perform an analytical valuation, using a relative value analysis and cash flow-based methods.

Provide company overview, strategy, and industry analysis to have a deeper understanding of Netflix and the whole industry. Provide financial Analysis using income statement. Use the balance sheet to calculate Unlevered Free Cash Flow and Net Present value. Calculate discount rate - WACC to get terminal value. Calculate Stock price using both Perpetuity and EBITDA methods. Perform sensitivity analysis for both valuation methods. School l project: j Solving l i Real l World l Problems l with i Analytics l i May 2022 - Aug 2022 Incorporating with real-world clients to generate analytical and organizational solutions for a sales training company. Use Excel to observe and understand the dataset.

Use Powerpoint to display data visualization and presentation Use Python to do data cleaning, data analysis, and data visualization. School l Project: j SQL May 2022 - Aug 2022

Design the theme and location of a music festival, then gather datasets that are needed to organize and run the festival using PostgreSQL. Gather necessary datasets in support of the creation of a new music festival Convert the datasets into a functioning relational database Utilize the data to fulfill the goal of attending and experiencing the festival Display results interactively through a Shiny app

UIS Student Union i (Ultimate l i Investment Society) i Head of Marketing Department

Sep 2017 - Aug 2018

UCI, Irvine, US

Organized several activities including Basketball Games; responsible for the outreach work and maintaining good relations with sponsors; served as coordinator among the team members

Languages: English and Chinese

Jinpu Wang

+1-657-***-**** 丨jw4194@columbia.edu

1120 W 6th Street, Los Angeles, CA 90017 Willing to Relocate EDUCATION

CAREER GOAL

SKILLS & ABILITIES

PROFESSIONAL EXPERIENCE

PROJECT EXPERIENCE

LEADERSHIP EXPERIENCE

MISCELLANEOUS

Contact this candidate