Data Analyst(BI)

Zilin Li

**********@*****.*** 979-***-**** Home: 312 2nd W Ave, Seattle, WA 98119

Note: Available for and looking forward opportunity to relocating to Seattle EXPERIENCE

MaxDecisions, Inc. Dallas, TX

Data Analyst 05/2017-Present

• Distilled 50MM+ data database using SAS, SQL to extract, and aggregate raw data from over 30 sources to support to create portfolio risk monitor and risk control report, dashboard and metrics report for three clients, loan company

• Facilitated lenders to select their most excellent potential customers to send mail, avoided fraud to minimize risk, which by coding 20MM+ data points about various personal loans and mortgage in SAS and Python

• Optimized SAS and SQL queries with Macro, which accelerated analysis and report processing by 15%+

• Presented to client per week, and answered ad-hoc questions by analyzing data base with business view PahRoo Appraisal & Consultancy Chicago, IL

Data Analyst Intern Investment & Risk Analysis 06/2016-09/2016

• Collected and joined 3,500+ sales data each city of 37 cities/7 counties by SQL and illustrated data in maps by Power BI, and conducted in-depth research on the Chicago Metro residential/commercial real estate pricing trend

• Built multivariate regression models by SAS to identify investment opportunities with various factors (e.g. seasonal sales/building area/total land/build year/neighborhood) and back-tested with 83% accuracy)

• Prepared and published reports on findings, and presented to the senior management/clients in a concise way Accenture PLC Beijing, China

Data Analyst Intern Compensation Strategies 11/2014-01/2015

• Developed a benchmark salary package for a multi-national client by analyzing 3M+ compensation data

• Constructed a regression model by R to predict the client’s compensation, compared which with the industry standard

• Incorporated profitability, liquidity risks to the client’s compensation solution to maximize its shareholders’ benefits EDUCATION

Texas A&M University College Station, TX

Master of Econometrics & Quantitative Economics (GPA: 3.5/4.0) 08/2015- 05/2017 Coursework: Economic Forecasting, Financial Econometrics, Econ. Analytics, Modeling and Banking, Accounting. Capital University of Economics and Business Beijing, China B.S. in Statistics (GPA: 3.5/4.0) 09/2011-06/2015

Honors: Beijing Government Scholarship (Top 10%), 1st Place in the Beijing Student Reach Tournament PROJECT

Credit Risk Management & Modeling (Excel/SAS) 01/2016-02/2016

• Designed a risk management framework for a $100MM simulated loan portfolio comprised of mortgage/auto-loans

• Established delinquency/prepayment models per clients’ FICO scores/income/behaviors with Big Data analysis

• Developed risk hedging plans involving MBS/ABS (securitization) and CDS/CDO (derivatives) per risk exposure SKILLS & INTERESTS

• Technical Skills: Advanced Excel (VBA/Macros/Pivot-Table/Charts), SAS, SQL, SPSS, R, Eviews

• Risk Modeling: Financial Loss Model, VaR, PD/EAD/Prepayment Model, Enterprise Risk Management

• Statistical Modeling: Non-parametric/Regression Models, Time Series, Trend/Correlation/Sensitivity Analyses

• Languages: English (Fluent), Mandarin (Native)

• Interests: Volunteering (Senior Care/Gardening), Tennis, Piano, Swimming, Boxing

Contact this candidate