Analytics

Sue Yanshu Zhu

+1-682-***-****· *********@*****.***

EDUCATION

Southern Methodist University Dallas, TX

M.S in Business Analytics, GPA 3.52 May 2018

M.S in Accounting, MSA Scholarship, Ernst &Young Scholarship May 2017 Nanjing Audit University Nanjing, China

BBA in Accounting, GPA 3.80 June 2015

TECHNICAL SKILLS

SQL, Python, R, SAS, Tableau, Power BI, Alteryx

EXPERIENCE

CBRE Dallas, TX

Data Scientist, Analytics March 2019 – April 2020

• Improving efficiency of facility management for commercial real estate clients between sites and vendors, translating clients’ request to visualized dashboards by extracting, analyzing and reporting business metrics including specific operation risks and financial valuation based on performance in SQL

• Partnered with operations and accounting team by providing exploratory data insights, running linear and logistic regressions and statistical tests such as f-test and t-test on cost, work order duration and investigating outliers

• Improving the accuracy of geometric dashboards by converting sites locations to radius distance calculation in Python

Nestlé Skin Health Fort Worth, TX

Strategic Analyst April 2018 – March 2019

• Designed strategies to evaluate the impact of government pricing requirements, market dynamics and the competitive landscape on formulary coverage, market share, and profitability fluctuations in Oracle SQL to presenting Tableau

• Developed analytics reports to measure profitability metrics down to the territory level by adjusting average selling price

• Created P&L of insurance contracts including accruals, invoice and reporting to ensure proper forecasting, budgeting for rebates plans

Rosewood Management Corporation ( Hunt, family office ) Dallas, TX Trust Fund Financial Forecasting, PTA June 2016 – Nov 2017

• Performed financial forecasting and budgets analysis and verified spending analysis by classifying accounts

• Developed annual financial statements and footnotes for funds and trusts

• Prepared sales reports for non-profit programs at Patrick Wetland by recording and reconciling journal entries PwC Shanghai, China

Auditing Intern, Financial Institutions Nov 2014 – Jan 2015

• Developed auditing report and internal controls; identified potential operation risks and credit risks in auditing tests

• Increased team efficiency by working creatively to join mortgage loans data in Access SQL and Excel PowerPivot

• Analyzed auditing sampling based on size considerations resulting in successful auditing confirmations PREDICTIVE PROJECTS

Predictive Analytics, R

• Predictive Analytics (CRM) Projects: forecasted customer lifetime value and adoption of new products, modeled segmentation in survival analysis based on maximum likelihood and probability Bayesian models based on beta- geometric model, beta-binomial model;

• Multivariate Analytics Projects: clustered segmentation for DirectTV and provide marketing strategy suggestions based on revenue index, exploratory factor analysis, principle component analysis in R Retailing Analytics, SAS

• Defined critical fractile levels in non-perishable models for replenishment buying

• Determined consumer responsiveness to price and promotions by estimating price elasticity by comparing AIC, BIC in log-log, semi-log and linear regression models, built enrollment model in logistic regressions

• Created estimation and validation samples randomly and score the data buying

Contact this candidate