Data analysis and data visualization

JIALU WU

Address: Queens, NY

Cell: 347-***-**** ******@***.***

EDUCATION

New York University, New York, the United States Master of Management of Technology Sep 2021- May 2023

GPA 3.36/4.0

Douglas College, New Westminster, Canada Bachelor of Business Administration Sep 2017- Jun 2021

Shanghai University of International Business and Economics, Shanghai, China Bachelor of Management Sep 2017- Jun 2021

Dual degree, Majors: Financial Service, Corporate Finance

Major GPA 3.6/4.0, GPA 3.4/4.0

PROFESSIONAL SKILLS

Data analysis: MS Excel (Formulas, Pivot table), Python

Data base: SQL, Access

Data visualization: Tableau, MS PowerPoint

Languages: Chinese(mandarin)

INTERNSHIP EXPERIENCE

Netjoy Holdings Limited, Shanghai, China Sep 2021- Dec 2021

Business analyst (part time) (I was in the go local Shanghai program.)

Consolidated firm-wide data by Excel (Pivot Table and V-lookup) and created a basic framework for presentation to customers in the investment conferences.

Participated in monthly expense reporting and budget. Managed the financial forecasting by developing financial models P&L and cash flow statement from past financial reports, for the team leader to modify business plans.

Performed data gathering and analysis of user retention weekly by SQL. Streamlined reports of the customers preference on different services for the manager.

Prepared ad-hoc reporting about the product sales and real-time inventory data, for the team leader to make business decisions quickly and more efficiently fulfill orders from consumers.

Jindong China, Shanghai, China Jun 2020- Aug 2020

Marketing analyst

Researched on 6 competitors financial reports, by abstracting related business information and financial data, using Power Point to display the performance of competitors, for the team leader to stay well informed of the position of competitors.

Analyzed equity penetration of over 300 investors by Excel. Classified them and made graphs in Tableau to support team leader to find potential investors.

Created effective dashboards by Tableau to present key performers indicators. Gave presentation in weekly meeting and led the debate about market updates and performance updates.

Examined systems to identify code problems and data errors. Cleaned the data of products by Python and Excel, by finding and replacing the missing value, corresponding format, to improve the predicted accuracy rate by 16%.

China Foreign Economy and Trade Trust Company, Shanghai, China Jun 2019- Aug 2019

Financial advisor

Utilized financial models (CAPM, company/ industry analysis) to clarify the market situation and help the team leader to find investment opportunity.

Updated clients’ information by SQL for the team leader to contact with customers more conveniently.

TRAININGS

Training for Python Data Analysis (online) Jun 2020 – Jul 2020

Shenzhen Norda Education Co., Ltd, Shenzhen, China

Mastered python programming language, such as Python basic syntax, object-oriented ideas, multithreading, and design patterns

Mastered background system development methods by Python

Mastered common machine learning algorithms, and tried to build models and conducted simple data analysis

Training for Fundamental Database Application in SQL Server July 2019 – August 2019

Shanghai Neiwei Training School, Shanghai, China

Acquired basic knowledge of SQL server system installation and management. Created and managed databases and tables

Mastered basic T-SQL language, control statements and the functions.

Learned data integrity, transaction processing, backup, storage procedures and trigger.

ACTIVITIES / INTERESTS

President of Archery Club Shanghai University of International Business and Economics Sep 2018 – Dec 2020

Volunteer for COVID-19 Prevention and Control Feb 2020 – May 2020

Contact this candidate