Weiran “Maria” Zhang

Alhambra, CA ***** Mobile: 818-***-**** ac7f1o@r.postjobfree.com

SUMMARY

Applied analyst who graduated with a Master of Science degree in Pepperdine University.

Accounting audit background who is bilingual in English and Chinese Mandarin.

CPA candidate who passed Regulation exam and expects pass all exam on May 2019.

Results driven, critical, analytical thinker, quick learner individual who seeks a full-time data analyst position.

EDUCATION

Master of Science in Applied Analytics - GPA: 3.6/4.0 August 2018

Pepperdine University, Graziadio Business School, Malibu, CA

Awarded Academic Excellence Scholarship Top 10% of class total 55 students

Business of Administration in Accounting June 2017

Nanjing Audit University, School of Accounting, Nanjing, China

Awarded Top 15% of Academic Excellence Scholarship

Honored the Outstanding Student Leader and Culture Establishment Pioneer

TECHNICAL SKILLS

Programming Languages: SQL, R, VBA

Data Visualization: Power BI, Tableau

Data Analytics Statistics: Alteryx Designer, IBM SPSS Statistics, Stata

Data Warehouses Database: Hadoop, mongoDB, SQLite

Data Mining Predictive Modeling: JMP Pro, Regression

Software Applications: MS Office (Word, Excel, Outlook, PowerPoint) & Google Analytics

COURSEWORK

Big Data Management: Experienced in SQL, Salesforce.com.

Social Media Analytics: Exploited Meltwater & Metricool in marketing, Amazon AWS.

Advanced Statistical Tools: Adept at Advanced Excel skills (Solver, Pivot tables, v-lookups, VBA), IBM SPSS to analyze users' behaviors, market share, etc.

Communications with Data: Structured data in Alteryx and visualized data in Tableau.

PROJECT

Data analysis:

1.Helped an ecommerce subscription company to their high value customers by data processing, analysis, visualization, and machine learning in their customer database (millions of data).

2.Reorganized the budget on those who meet the definition of high value customers and increased their revenue by 9.2%.

Optimization modeling:

1.Advised a market to solve problems including transshipment and assignment problems, inventory management.

2.Slashed cost 30% by leveraging advanced Excel skills(QM), Queuing Analysis, and EOQ analysis.

Risk consulting:

1.Visualized and prioritized risks affecting a company by using visual tool(ACCESS) to report to executives.

2.Minimized 3 risks and increased the probability for profit. Increased profit by 2% through data-driven strategy recommendations.