Data Analyst Accountant

Yuanyuan (Julia) Zou

No Visa Sponsorship Required

*****.***********@*****.*** 669-***-**** linkedin.com/in/yuanyuan-julia-zou Chinese Accounting Professional Certificate (Intermediate Accountant) Python R SQL Java Machine Learning Tableau Spark Hive Hadoop SAP Oracle Big Data EDUCATION

WASHINGTON UNIVERSITY IN ST. LOUIS Saint Louis, Missouri 01/2021 Master of Science in Business Analytics GPA: 3.84/4.00

• Relevant Coursework: A/B Testing, Database Design and Data Visualization for Business Insights SAINT LOUIS UNIVERSITY Saint Louis, Missouri 12/2018 Bachelor of Science in Accounting GPA: 3.88/4.00

• Dean’s List, Graduate with Honor, Member of Beta Gamma Sigma

• Saint Louis University Housing Scholarship

PROFESSIONAL EXPERIENCE

EXPRESS SCRIPTS Saint Louis, Missouri 09/2020 - 01/2021 Data Analyst, Boeing Center Practicum

• Recommend potential mitigation strategies for drug price fluctuation.

• Analyze drug pricing components and find correlations between the price and manufacturer financial standings through data visualization and statistic tooling(R).

• Build a prophet model in python to forecast the 2,941 drug price in 2021. CLOCKWORK Saint Louis, Missouri 09/2020 – 01/2021

Data Analyst, Center for Experiential Learning Program

• Designate strategies to help Clockwork expand its product offering into the venture capital market.

• Apply quantitative problem-solving skills to the novel startup projects. NESTLÉ PURINA NORTH AMERICA Saint Louis, Missouri 06/2020 – 08/2020 Center for Experiential Learning Program Team Lead - Product Management Consulting

• Led a team of 4 to develop a marketing strategy to drive long-term customer bonding and retention.

• Conducted market research, data and trend analysis.

• Created several possible approaches corresponding to COVID-19 to keep customer loyalty. WASHINGTON UNIVERSITY IN ST. LOUIS Saint Louis, Missouri 01/2020 - 09/2020 General Teaching Assistant for the Accounting Department Director

• Designed online accounting courses for the Olin School Class of 2021.

• Collected students’ grade data, and used MySQL to generate routine students’ performance reports. DOW CHEMICAL COMPANY Shanghai, China 01/2014 - 06/2015 General Ledger Accountant (Ranked top-tier in performance review out of a team of 30)

• Managed monthly financial reporting for 32 business units and developed bank reconciliations, intra-company reconciliations, and other month-end general ledger reconciliations in the SAP system.

• Coordinated with a team of 3 in offering support and guidance such as accuracy fillings during external audits with KPMG.

• Prepared an average volume of $600,000 tax returns per month. DUPONT PHOTOMASKS INC Shanghai, China 07/2011 - 12/2013 Account Receivable Accountant (Ranked top-tier tier in performance review out of a team of 20)

• Verified, classified, computed, posted and recorded account receivable data.

• Set up new customers, requested credit references, pulled credit reports, assigned customer number in the Oracle system.

• Used SQL to manage and record 27 internal company transactions and relations with big customers. PROJECTS

• US Consumer Complaints Data Analysis 10/2019

Big Data class project. Analyzed a 15 G dataset provided by Consumer Financial Protection Bureau on consumer complaints about financial products and services among more than 5000 financial institutions in the United States.

• Tesla Stock Valuation 08/2019

Marketing class project. Collected financial, operational, developing, management, etc. data to thoroughly analyze if Tesla worth investment with regard to its products or stocks during the fiscal year 2019. Successfully forecasted that Tesla’s stock price would increase in the second half of 2019.

Contact this candidate