Data Analyst Sales

Weiwan Zhao

**** ******** ******, ************, ** 19104 · 267-***-**** · ****************@*****.*** Education

Drexel University Philadelphia, PA

Bachelor of Science in Business Administration Graduation: September 2018 Majors: Finance and Business Analytics

Skills

Software: Metatrader, Google Analysis, DoubleClick for Advertisers, Adobe, Excel(Pivot table,Vlookup,IF Functions), Word, PowerPoint, Endnote, SPSS, MATLAB, R, SQL, JIRA, XML, Postman, UI, GitHub, SON, CRM,Tableau

Language: Fluent Chinese and Basic German

Professional Experience

ClarionDoor, Inc. Philadelphia, PA

Junior Business Analyst November 2018 to Current

• Build Algorithms and analyze client’s insurance rates by using Excel, JSON and XML to provide strategic business decisions

• Implement and update business procedures by using internal analytics tools to ensure client’s production operation smoothly

• Monitor and code for company's web services and UI for most updated client's information to maintain the efficiency of the company's process

• Communicate with customers in order to help them be competitive in current market by presenting analysis of relevant data FMC Corporation

Sales Analyst

• Prepared sales forecasts and analyzed internal data to estimate growth and accuracy of sales goals by using SAP tools

• Researched current market trends for evaluating consumer needs and competitor’s strategies to increase product sales by 30%

• Created sales budgets in Excel for upcoming year based on the forecasts to ensure accurate expenses and inventory Digitas Health-Life Brands Philadelphia, PA

Data Analyst September 2015 to March 2016

• Edited weekly reports in the form of visualizations such as graphs and dashboards to review customers’ performance

• Processed technically clients ‘products performance analysis by using Google Analytics and functions in Excel to accelerate client’s sales revenue

• Improved visual appeal of product campaigns through Photoshop and supported managers on daily analytical initiatives Environmental Engineering Department at Drexel University Data Analyst

Philadelphia, PA

September 2014 to March 2015

• Analyzed audience feedback and attendance through VLOOKUPs and PivotTables to create monthly reports to improve the quality of seminar

• Collected and organized environmental data using Excel and SPSS to determine plants ability to survive in various climates

• Built models in Excel combining with datasets to support the creation of quantitative analysis and update the database China Forex International Beijing, China

Assistant Foreign Exchange Trader December 2014 to January 2015

• Monitored and dissected financial, statistical, and operational data trends by using MACD, Bollinger Bonds and MA indicators to determine opportunities for investment

• Managed, tracked, and monitored financial updates, watch lists, and insurance files by using FactSet and Bloomberg to explore the financial markets

Business Analytics Capstone Project

Drexel University June 2018 to September 2018

• Analyzed customer data using statistic methods by age and zip code to identify consumer demographics

• Implemented the data analysis and presentation to demonstrate the business insights to the law firm to find potential customers

• Created customer behavior clusters for Pond Lehocky by using SPSS to determine market strategy and segmentation Volunteer & Leadership Experience

Asian American Voter Registration Drive

Voter Advocate

Philadelphia, PA

April 2015 and April 2016

• Educated Asian Americans on voting rights by conducting workshops to promote community voting participation

• Completed registration forms for 50 Asian immigrants to facilitate application process due to the language barriers Honors and Awards

Manhattan College Business Analytics Competition; 2017; Drexel Undergraduate Datathon Competition 2017; Pennsylvania Phi Beta Lambda 2015-2016 State Leadership Competition; 2016 Philadelphia, PA

September 2016 to March 2017

Contact this candidate