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
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
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
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