SQL, R, Tableau, Microsoft Office Suite

Yutong (Gloria) Li

+1-332-***-**** ******@********.*** linkedin.com/in/yutong-li-415780229

EDUCATION

Columbia University New York, US

B.A. in Economics Expected May 2023

• Cumulative GPA: 3.7/4.0

• Honors: Dean’s List 2021-2022

• Relevant Coursework: Econometrics, Java and programming, Financial Economics, Money and Banking, Corporate Finance, Statistics

Peking University Beijing, CN

Guanghua School of Management Apr 2021 - May 2022

• Relevant Coursework: Entrepreneurship & Innovation Management, Business Communication Emory University Atlanta, US

Major in Economics Sept 2019 - May 2020

• Relevant Coursework: Micro & Macroeconomics

PROFESSIONAL EXPERIENCE

Ark Technology New York, US

Product Management Lead Dec 2020 - Present

§ Developed a road map for mobile UGC platform development, lead a cross-functional product team, manage prioritization and monitor the work to ensure whole-product readiness

§ Conducted in-depth research and analysis with 1000+ survey samples from designed survey and 50+ interview samples; compelling data gathered from various corporations’ financial reports using visualization tool (tableau/power bi); enhancing project efficiency by 25%

§ Fostered communication between stakeholders, engineering, operation, and marketing, resulting in improved speeds of production circle by 30% year over year

§ Defined key performance metrics by collaborating with C- level suite and key stakeholders to improve methodologies and operations across the company

China Poly Group Surpass Commercial Corporation Beijing, CN Business Analyst Intern May 2021 - Jul 2021

§ Evaluated profits and summarized the insights by gathering export data of different divisions through quarterly financial reports with the foreign trade team by conducting 10+ market types of research

§ Visualized and demoed quarterly financial reporting Tableau dashboards to different portfolio managers and decision-makers; improving the campaign efficiency by 3%

§ Collaborated with senior manager to propose 5+ daily reports on internal policies by gathering and organizing relevant regulations from legal instruments of different regions to develop documentation; ensure the corporation’s wide compliance with domestic and internal trading and shipping requirements EXTRACURRICULAR ACTIVITIES

Guanghua School of Management Beijing, CN

Summer Teaching Assistant Jul 2021 - Aug 2021

§ Outlined course structure with professors and lecturers

§ Collected 20+ research papers and government policies to cater the teaching goal of 9 classes on aspects of contemporary Chinese economy and market

§ Documented research procedures from a series of detailed background researches on filed including oil, wine, game industry, and science technology

McKinsey & Company Project Beijing, CN

Data Analyst Jul 2020 - Aug 2020

§ Built automatic reporting for data extraction process by introducing SQL connector on Excel

§ Assisted the senior manager in developing KPIs to track and monitor the energy vehicle market share, creating a dashboard to present the insights to stakeholders

§ Documented project study process thoughtfully and streamline the reporting procedures

§ Engaged with the marketing team to exchange the business justification with external stakeholders, optimizing profitability and mitigating the issue

SKILLS & INTERESTS

§ Languages: Mandarin (Native), English (Fluent), Japanese (Intermediate)

§ Technical Skills: SQL, Java, Microsoft Productivity Suite, Event Planning, Marketing, A/B Testing

§ Interests: Contemporary Art Practice, Curatorial Practice for Gallery and Museum, Painting, Travelling

§ Sports: Equestrian Athlete; Certificated Eighth Level Rider of German Equestrian Federation

Contact this candidate