Jiayan Wang Email & Phone Number

Shanghai, China

• Collected and analyzed data from variety of sources, including sales, production, and financial data, to identify trends, patterns, and opportunities for the company and lead the development of analytics pipelines• Transformed data into structured formats using OpenRefine, Python pandas, and PostgreSQL for analysis• Built models such as SVMs, random forest, and classifiers to predict churn rate and boost CLV• Modeled the costs and risks associated with disruption of transportation due to pandemic controls and provided Power BI dashboard for logistics managers to visualize spending of alternative options• Adopted decision analysis techniques to achieve 92% on-time delivery and service when industry average was measly 36% during random lockdowns across four major sales and service regions in China• Collaborated with VP of sales, VP of engineering, and service managers to provide data-informed strategies regarding recovery plans after China had lifted pandemic control

Shanghai, China

• Facilitated telemarketing campaigns to promote and sell 1,000+ investment products to 6,000 customers.• Researched market segments and renewable energy policies with 500 surveys and 33 focus group studies; developed campaign strategies and information brochures for six sub-markets in 20 cities.• Curated over 6,000 prospects’ info in CRM system; automated sales pipelines with scripting.• Performed analytics to increase conversion rate by 35%; achieved 64 contracts in two months.