Liangce Liu Email and Phone Number

• Reduced 10% bad experience by creating new Website features through customer surveys, competitoranalysis, statisticaltesting, algorithm producing and A/B testing• Developed and optimized complex SQL queries to extract, aggregate, and analyze data frommulti-million row databases, leading to a 20% improvement in reporting efficiency. Executed over 6000SQL queries in this process.• Designed and implemented interactive dashboards in Tableau to visualize key performance metrics,enhancing stakeholder decision-making processes and reducing report generation time by 30%.• Collaborated with cross-functional teams to identify data requirements, ensure data integrity, and createautomated data pipelines using ETL tools, which streamlined data processing tasks by 25%.

• Performed data cleaning, transformation, data quality checks, and exploratory data analysis in Pythonand SQL• Utilized Python and libraries such as Pandas and NumPy to perform data cleaning, transformation, andstatistical analysis, resulting in actionable insights that increased revenue by 15%.• Created interactive data visualization dashboards using Tableau for leadership team to analyzeemployees' overall performance and track the operating conditions of the company

• Loaded data into Tableau from the database and create the action filter, parameters, and calculationsfor dashboards to prepare visualized data reports.• Developed comprehensive business intelligence reports covering eCommerce, website performance,product sales, sales forecast, P&L, and competitor analysis.• Analyzed the production and sales data of the company to establish market share and competitiveness;also forecasted future sales and inventory through time series analysis, correlation analysis, andregression analysis.