Sales Financial Analyst

Yingzi Hou

Looking For Full-time Position in Business/Financial/Data Analytics 40770 Slayton St., Fremont, CA 94539 972-***-**** ****@***.***

EDUCATION

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

TECHNICAL SKILLS

Alteryx • Tableau • KNIME • R • SQL • SAS • Web Design • Java • Python • C++ • Excel (including Macros) • Hadoop • Google Analytics

WORK EXPERIENCE

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.

ADDITIONAL INFORMATION

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.)

Contact this candidate