Looking For Full-time Position in Business/Financial/Data Analytics 40770 Slayton St., Fremont, CA 94539 972-***-**** email@example.com
Southern Methodist University, Cox School of Business Dallas, TX
Master of Science in Business Analytics (GPA: 3.6 / 4.0) May, 2018
Hubei University of Economics Wuhan, China
Bachelor of Science in Information Management and Information System (GPA: 3.55 / 4.0) June, 2017
Alteryx • Tableau • KNIME • R • SQL • SAS • Web Design • Java • Python • C++ • Excel (including Macros) • Hadoop • Google Analytics
PICKUP Instant Delivery Texas, United States
Business Analyst Jan 2018 – May 2018
Developed a market prioritization interactive model using R and SQL that utilized intelligence from historical data plus integration into third party data sources; Built a price sensitivity model allowing for what if’s that reflected impact on demand at individual service area levels and at the company levels.
Developed a forecasting model in Excel for orders and revenue using data that included seasonality, service area dynamics such as weather, growth characteristics of national, regional and local retailers, etc.
Built a supply side model in R that considered driver lifetime by segment and helped forecast number of drivers needed at a service area level as demand increases while also considering driver attrition and built dashboards in Tableau to measure results against forecast together with corporate and service area level KPIs.
Collin County Texas, United States
Data Visualization Analyst Aug 2017 – Oct 2017
Negotiated details with financial department and worked on the financial report of Collin County to generate annual report for the office.
Cleaned, reorganized and analyzed data by using tools including Excel, Alteryx and Tableau.
Created 4 self-updated, interactive, user-friendly and transparent dashboards in data visualization tool Tableau and effectively built communicate data insights and made a forecast on the budget of next year.
Hubei Nockert Pharmaceutical Co., Ltd Xiaogan, China
Marketing Analyst Dec 2015 – Apr 2016
Analyzed sales data by utilizing Google map and Excel to provide insights on increasing sales and profits by 5%.
Led the creation and publication of KPI’s and dashboards that were timely, insightful, and automated by working cross-functionally with multiple departments;
Developed strategy for marketing to new prospective clients in different areas by using R and product presentation about the sales.
China Citic Bank, Donghu Branch Wuhan, China
Financial Analyst July 2016 – Sep 2016
Recommended suitable financial products for customers, provided financial advice and made inductive analysis regularly.
Analyzed the frequency of mobile-banking users across different age groups and concluded that key factor were age and work, which contributed to the bank proceeding with the extension of its mobile banking clients.
Dealt with banking services as well as established long-term and stable relationship with key customers according to customer requirements.
Academic Project: Designed a Seasonal Fruit Introduction website for a fruit store in my university (HBUE) after finishing the course Web Design.
Additional Coursework: Business Statistics, Macroeconomics, Microeconomics, Management Accounting, Financial Accounting
Interests: Marathon (participated in the Wuhan Marathon Health Running and finished running 12 km.)