Shinan Li

Data Intelligence Analyst @REVOLVE

Cerritos, CA, US

Identified opportunities from in-depth analysis of performance metrics for inventory, sales, and traffic data and product tagging data to create Classifier and Regression machine learning models to establish projection and planning models that evolved to an automated suggestion system such as purchasing categories, quantity, inventory level and vendor discount Provided data insights by identifying KPI and engineering data extraction and html auto reporting template using Python html library, ClickHouse, and MySQL for accounting, data, and BI partner teams, resulting in automated recurring reporting of 10-Q data, cash flow and board meeting information such as inventory turnover, average order value, projected return rate for strategic decisions Analyzed overhead cost structure and engineered various pipelines to produce reports, primarily used by management and analysts for decision-making and analysis on 5 different versions of margin metrics with different calculation methodologies, resulting in improvements varying from 5 - 70% in accuracy Designed automatic data cleaning process using MySQL scheduled procedures, server scheduling, and Python file local scheduler, shortening system runtime by 83% and running capacity by 40% Engineered data process improvement, data verification and data collecting by optimizing data extraction code, process plan, and tool requirements for extraction and validation of site and influencer impression/sales data; building order approving console; building product tagging tools

Pepperdine Graziadio Business School

Master of Business Administration (MBA), Finance Concentration

China Agricultural University

Economics

Chapman University

Bachelor of Business Administration (B.B.A.), Accounting and Business/Management Double Major