Financial / Marketing Analyst

YIYANG GAO

Phone: 812-***-**** Email: adrrlh@r.postjobfree.com Work Authorization: Green Card

EDUCATION

**/****-**/**** ******* University Bloomington Bloomington, IN Bachelor of Science in Informatics

Minor: Marketing

WORK EXPERIENCE

06/2021 – 08/2021 CORNING Shanghai, China

Marketing Analyst Intern

• Read market financial reports, researched competitive market and customer buying trends, analyzed competition and potential growth opportunities, and submitted weekly industry analysis reports to supervisors, accelerated supervisors' workflow by 50%.

• Analyzed financial report using Excel and Python, comparing Year-Over-Year changes in market performance by products. Performed market analysis and research on the latest trends. Enabled the department to respond quickly to changes in industry behavior.

• Managed the company's business introduction applet on the WeChat platform and participated in the system design, construction, and release, which increased the page views of the platform by about 46% after two months. 12/2020 - 02/2021 VSTECS Holdings Limit Beijing, China Financial Analyst Intern

• Utilized Excel to analyze the product line between 2019 to 2020 in different area and month, data contains 20000+ rows and 60+ column. By comparing revenue, capital cost, storage cost, EBITDA and various factors to find the trends of the business.

• Created pivot table to catch the key information the product manager needed, filtered and sorted data. Generated pivot charts to visualize information.

• Analyzed financial performance of product lines by region, time, and other attributes, produced data-visualized presentations using Microsoft PowerPoint, communicate with financial and logistics department to verify the data, accelerate the business process. PROJECT

03/2021 – 05/2021 Ernst & Young Case Study: Marketing Plan for Tierra Encantada Bloomington, IN

• Wrote a 35-page marketing report describing a differentiation strategy to improve customer experiences and awareness. Presented to the founder of Tierra Encantada.

• Analyzed domestic childcare industry current issues, found focus points and target groups.

• Created implementation process for our project, including a specific timeline explanation and visual of financials. Applied SWOT method to analyse feasibility of our project. 08/2020 - 05/2021 Undergraduate Capstone Project: Web Application Development Bloomington, IN

• Completed an 85-page project document, divided into 15 parts, comprehensively considering the expectations and needs of external customers and internal members.

• Determined the project contents, including release platform, project features, social considerations, UI/UX design, the overall framework, database construction and timeline.

• Coded with HTML/CSS/PHP to build websites and used SQL to construct and manage the database. Communicated weekly with project leaders to improve processes. 01/2020 - 05/2020 Data Analysis Covid-19 Infection and Death in the United States Bloomington, IN

• Collected raw data online, imported various modules/packages, calculated statistical indicators to analyze covid-19 infection factors using Python & R Studio.

• Predicted future trends using regression line analysis and used two sample t-test for hypothesis tests.

• Visualized data by creating line, bar, and other types of charts, wrote the research report. CERTIFICATION

• The Fundamentals of Digital Marketing Certification 05/22/2022 Google Digital Garage

• Project Management Essentials Certified 05/22/2022 Management and Strategy Institute

• Lean Six Sigma White Belt Certified 06/26/2022 Management and Strategy Institute ADDITIONAL INFORMATION

IT Skills

Python, R, SQL, Microsoft Excel (VLOOKUP/Pivot Table)/Word/PPT/Visio, HTML, CSS, PHP Business Skills

Accounting, Financial Report Analysis, Digital Marketing, PowerBI Languages

Chinese (Expert)

Contact this candidate