Jiani Li Email & Phone Number

Berkeley, Ca, Us

Chicago, Illinois, United States

Denver, Colorado, United States

Hangzhou, Zhejiang, China

▪︎ Identified key business issues and assisted in delivering BI solutions (based on Galaxy - Guanyuan BI platform) on sales, products, and financial analysis for 2 potential retail clients, leading to BI project bid successes partnered with the marketing team.▪︎ Built 20+ dashboards as web & mobile applications in Galaxy for 4 corporate clients, enabling 500+ users from entry to senior level to collect updated data easily and conduct daily data-driven operations.▪︎ Provided major support in a coffee brand BI project and delivered BI solutions (platform, data warehouse, and dashboards), reducing 80% manual data collecting & reporting work. - Gathered business requirements and helped formulate the BI solutions in the form of reports - Developed ETL in Galaxy using Spark SQL to construct the data warehouse, which integrated data from 5 source systems, including 5M orders from different channels and manual-maintained CSVs. - Designed and built 7 dashboards (of both web and mobile applications) for the client to monitor routine operations and dive into the deeper business analysis.

Hangzhou, Zhejiang, China

Business intelligence support for the travel activity & attractions ticket business of Fliggy (Top Chinese travel platform):▪︎ Analysis of the repurchase rate of new users collected from offline ticket sales - Created 3 tables containing 100GB+ data with SQL on MaxCompute (Ali’s enterprise-level data warehouse), tracking the first and repurchase orders of customers. - Designed core metrics around the repurchase rate and built 3 dashboards to visualize new users’ offline ticket sales, decreasing 90% of query requests from sales, product, risk control, and finance teams. - Analyzed 10M offline tickets based on the one-year repurchase rate to diagnose issues on new user operations through SQL and dashboards, helping the sales team increase the repurchase rate of WeChat new users by 10%.▪︎ Analysis of fraud ticket transactions conducted by attraction businesses - Defined 8 indicators based on tickets per capita to diagnose offline fraud transactions and constructed 3 dashboards for other teams to identify and restrain illegal sales. - Assisted in routine monitoring and helped reduce fraud losses by 60% within a month in collaboration with 4 business teams.

Hangzhou, Zhejiang, China

▪︎ Gathered and normalized text data about the Energy Internet (EI) (key news & concepts in clean energy research and industries) for the AI team to create EI Knowledge Graph on Power Intelligence Applications.▪︎ Assisted in constructing a smart Q&A model for main equipment technical standards of the power grid with knowledge graph techniques: - Constructed 50% of the FAQ database by extracting structured content (entities, features, and relations) from text data of 30+ docs, which was used by the AI team to build the semantic matching model. - Created a tree-structured knowledge graph that encoded the hierarchy of text terms in Python, which supplemented the FAQ matching model to reach a final Q&A accuracy of 90%.

Master Of Analytics, Industrial Engineering & Operations Research

Bachelor Of Science - Bs, Management Information Systems, General

- National Scholarship (Top 2%) in 2019 & 2020 - Outstanding Undergraduates in Term of Academic Performance (Top 1%) - National First.