Analyst Intern

Tianlin Zhou

Mobile: 551-***-**** Email: *********@*****.***

Address: *** ******* **, **** ****, Morrisville, NC 27560 1

EDUCATION

Columbia University, New York City, NY Sept. 2021– Dec. 2022 Master of Science: Major in Applied Analytics GPA: 3.58/4.0 Washington State University, Pullman, WA Aug. 2017 – Dec. 2020 Bachelor of Business Administration: Major in Finance and International Business GPA: 3.91/4.0 ACADEMIC PROJECTS

Traffic Pattern of CitiBike in New York City - APAN 5800 Storytelling With Data Sept. 2021

• Utilized Python and Tableau Visualization to analyze rental bike usage length, trend and distribution in New York City to provide suggestions about how to improve bike utilization, increase consumer satisfaction and grow profits.

The Future of Direct to Customer (D2C) Model - ACTU 5030 Life Insurance Jan. 2022

• Conducted SWOT and PESTLE analysis of D2C approach in the insurance industry to identify the potential for business model transformation, includes cost reduction, technology and market change. Employee Attrition Factors in Wells Fargo - APAN 5900 Solving Real World Problems Sept. 2022

• Employed Python, R and Tableau to explore factors including job category, level, location and vacation period pattern to understand employee behavior and help reduce the operational risks. EXPERIENCE

Aerospace Science & Industry Financial Leasing Co., Ltd, (Wuhan, China) 2021.03 – 2021.06 Business Analyst Intern

• Researched, reviewed and integrated complex data from multiple sources and helped prepare detailed due diligence reports. Performed analysis of financial statements to support decision-making around investments and other strategic initiatives

• Conducted in-depth analysis on assigned topics, utilizing both primary and secondary sources, to support company objectives. Evaluated critical factors including the financial and business status of the potential targets to prevent possible risk and loss.

• Analyzed and interpreted investment factors, including industry trends, legal barriers, business structures from a variety of sources to make suitable project recommendations for clients. Orient Securities Co., Ltd, (Nanning, China) 2017.05 – 2017.06 Marketing Analyst Intern

• Perceived client needs through visits and desk research, assisted in building client profiles and capital portfolios. Conducted regular phone visits to target clients to update client information and collated team views from weekly team meetings minutes to provide clients latest market information.

• Worked closely with the team to launch strategic marketing plan on relevant topics, including the collation of product financial data and historical market information, completing the collation of data on twelve wealth management products during the internship, and completing the collation of historical information on dozens of listed companies corresponding to the products. SKILLS

● Financial Risk Management (FRM)

Program: Passed Exam Part I.

● Languages: English, Mandarin Chinese

● Microsoft Office (Word/Excel/PowerPoint)

● Programming Language: R, Python, SQL

● Visualization Software: Tableau

● Logic And Regression Analysis

● Data Science Research Methods

Contact this candidate