Work Experience

LendingClub Bank
Senior Data Analyst | January 2022 - Present

• Product Management: Managed financial products with $100MM monthly origination; drove roadmap from insights to implementation for six new strategies by unwinding historical data trend; reduced 40% of annual loss
• A/B Testing: Designed and executing experiments to explore pricing opportunities; measured the demand impact based on statistical significance in pricing elasticity; delivered $1MM monthly profits by increasing interest rate
• Business Intelligence: Scraped and manipulated data from different data source in SQL, built and maintain 3 automated reporting system in Tableau; improved team efficiency by 5x for internal and external stakeholders
• Strategy Implementation: Developed 10+ business requirement documents and collaborated with engineering team to implement product strategies; performed quality control for 15 production release
• Financial Forecast: Projected internal rate of return by simulating the latest product policy in SQL and delivered results to leadership; improved the revenue control to meet the target profitability


American Credit Acceptance
Data Analyst | April 2020 - January 2022

• Product Growth: Expanded product user base profitably via experimental tests to evaluate user’s pricing elasticity of demand;boosted $2MM profits annually
• Funnel Analysis: Built data pipelines with 13 metrics to monitor $3 billion assets by SQL and Tableau; identified opportunities to improve conversion; presented insights to leadership and influenced decision-making
• Quality Control: Led a team of 3 to perform product strategy sign offs prior to each production release; transformed from manual to automated API processes in R; reduced 70% of the testing time


American Credit Acceptance
Quality Assurance Engineer | July 2019 - March 2020

• Data Engineering: Performed functional testing and ETL testing by leveraging SQL and SSIS package, maintained normalized data structure and documented testing results in JIRA
• Cloud Service: Cooperated with business and developers to automate a workflow using AWS Lambda and Step Function; reduced 60% manual interpretation
• Agile Development: Designed and executed test cycles in Agile methodology; reduced 20% production deflects


Merchants Distributors, LLC
Graduate Student Consultant | October 2018 – May 2019

•Designed a dynamic resource allocation simulator to automate staffing process, optimizing working conditions in the facility and employee schedules, promoting customer service performance, and allocating capital efficiently
•Built ARIMA time series models to predict daily customer demand, facilitating managers to make granular staffing decision

Technology

Day-to-day comfort

Microsoft Excel: Pivot table, Solver, Open Solver, Crystal Ball

Python: Pandas, Numpy, SciKit-learn, Matplotlib

R: Tidyverse, Caret, Stringr, Lubridate, Shiny

SQL: Microsoft SQL Server, MySQL Workbench

Tableau

Microsoft Suite

JIRA

Agile Methodology

Experienced with

AWS: S3, Route 53, RDS, EC2, Lambda, Step Function

SAS Base

SAS Enterprise Miner

MS Visio

Google Analytics

HTML

CSS

Education

Wake Forest University, School of Business

Master of Science in Business Analytics | May 2019
Coursework: Probaility and Statistical Modeling, Predictive analysis & Data Mining, Data Visualization, Financial and Risk Analysis


Indiana University, Kelley School of Business

Bachelor of Science in Finance, Bachelor of Science in Operation Management | May 2018
Co-Major: Technology Management
Coursework: Data Management, Project Management, Business Statistics, Financial Data Analysis, Data Programming

Certification

Financial Risk Manager(FRM): Exp: No Exp

Tableau Desktop Specialist: Exp: No Exp

AWS Cloud Practitioner: Exp Oct 2022

SAS Certified Statistical Business Analysis: No Exp

ISTQB Foundation Level Certified: Exp: Sep 2024