Resume

Sign in

Financial Analyst Data

Location:
Los Angeles, California, United States
Salary:
70000
Posted:
February 26, 2018

Contact this candidate

Feili Wu

ac4mie@r.postjobfree.com • 206-***-**** • 690 S. Catalina St. Apt. 3N, Los Angeles, CA 90005 EDUCATION

University of Southern California, Marshall School of Business – Los Angeles, CA May 2018 M.S. in Business Analytics

• GPA 3.91

• Coursework: Digital Marketing, Data Mining, Applied Machine Learning, Spreadsheet Data Modeling University of Washington – Seattle, WA Jun. 2016

B.A. in Accounting & Management Information Systems

• Honors: Annual Dean’s List; GPA 3.76

WORK EXPERIENCE

Guidance Software – Pasadena, CA Jun. 2017 – Jul. 2017 Marketing Business Analyst Intern

• Recommended a more profitable allocation of class offerings to increase margin by 30% based on demand prediction.

• Proposed to cut down internal costs by 20% by providing more virtual classes based on curriculum quality evaluation.

• Identified 5 courses requiring improvement by analyzing the historical course enrollment and student attendance data. Expedia, Inc. – Bellevue, WA Jun. 2015 – Sep. 2015 Financial Analyst Intern

• Reduced 50% manual hours spent in mass data validation by designing Excel templates to facilitate migration of legacy financial system to Oracle Hyperion.

• Created 30+ tutorials of new accounting software Blackline to drive automation strategy of financial statements.

• Engaged in data flow automation process by conducting system testing and data validation to ensure smooth implementation of Blackline.

Amazon.com, Inc. – Seattle, WA Jun. 2014 – Dec. 2014 Financial Analyst Intern

• Worked cross-functionally to develop dashboards that improved 30% efficiency in journal entry validation, leading to improved data quality of financial statements.

• Conducted variance analysis for intercompany accounts in Europe and South America; delivered findings on large variances that management used for monthly review.

• Ensure that bank records reflect book transactions accurately by performing monthly bank reconciliations. ANALYTICS EXPERIENCE

H-1B Application Status Analysis Mar. 2017 – Apr. 2017

• Developed predictive analysis based on 600K+ H-1B petition data to anticipate the certification result.

• Improved prediction accuracy by 30% by constructing complex statistical models in R including random forest, bagging, neural network, KNN, and penalized logistic regression.

• Presented insightful findings that would increase approval likelihood for H-1B applications. The Zoe Report Digital Marketing Analytics Oct. 2016 – Dec. 2016

• Identified target customer segments for the client’s next seasonal campaign by analyzing website traffic and campaign performance through two seasonal cycles with Google Analytics.

• Developed 6 KPIs for email newsletters and website content based on Organic Search analysis, Email Campaign analysis and User Behavior analysis, which were facilitated by performing data ETL.

• Proposed 6 recommendations on improving data quality to drive long-term analytics strategies. Online News Popularity Analysis Sep. 2016 – Oct. 2016

• Identified key variables that affected online news popularity using MANOVA analysis and rapid predictive modeler.

• Presented several actionable methods to increase popularity by visualizing engagement data in Tableau. SKILLS

Analytical Tools R, MySQL, Tableau, Python, JMP, Google Analytics, Excel, SAS Studio, Access, Visio, Oracle Statistical Techniques Clustering, Logistic Regression, Linear Regression, CART, Naïve Bayes, LDA, QDA, Cross Validation, KNN, Random Forest, Bagging, Neural Network



Contact this candidate