Chunyan Li Email and Phone Number

Used SQL to extract data for my own reports and others’ demands effectively, such as for McKinsey’s constant program of cooperation between Pingan Life and Peking University International Hospital to extract demography data of claimsUtilized Python seize the key risk factors of complaints based on linear regression and formed analysis report, built sales department complaints and renewal risk level data model. Wrote analysis report of main plans at high premium and critical illness, the critical illness model, long-term insurance short-term claims, cardiovascular vascular diseases, temporary manpower basis on variance analysis and other methodsUsed Python to speed up data processing, visualized data by Power BI and Excel and completed data reports: KPI report of risks control center for Beijing branch, complaint daily reports, complaint KPI measurements, gold sales department selection, manpower of risks control center, sales staff service data, one-customer multi-agencies and month-end policiesUsed VBA to generate large volumes of correspondences and TEXT messages, and implemented manual blood glucose calculator basing on an internal underwriting handbook

Designed projects and wrote proposals of investment and financing. Valued underlying assets based on materials in hand. Researched equity structures, financial reports of benchmarking enterprise, and study laws and regulations about partnership and oversea investment. Projects: Acquisition of oversea hotel and land, Acquisition of technical corporations, Found of travel digital platform, Found of industry fund, Due diligence of technical corporationPrepared documents and answered questions to financial institutions. Systematized filing documents and structured effective working patterns

Analyze and report the data of maturity benefit; Offer the list to the agents, promote the services, and control the risk of complaints; Designed and improve workflow

Accomplished consulting programs as leader: completed the different kinds of reports on retail, and gave presentations to clients; designed and pretested the questionnaires, led over 10 men team to collect and audit data; wrote the proposals, translated supplier application forms and secondary resourcesProjects: Designed KPI of sales and retail stores for smart TV team; Analyzed siting strategy of 3C stores for PC team; Researched on marketing segments, pricing and products design for display team; Designed retail store for smart TV team; Graded the retail stores and offer the solutions to the weak links of retail service for many famous brands of PC, household appliances and automobiles

The sales and services promotion project of service agencies for China Mobile and wrote the graduation thesis about it based on queuing theory Drafted KPI solution of HR under guides and benchmarking cases of sales. Collected data of service duration. Classified business and processed data. Translated materials of the proposal for 4G strategy and smart card of China Telecom

Managed cash and bank accounts: Completed check register and cash account. Paid with deposits and cash. Tackled with payment requestAssisted auditors to finish annual audit. Dealt with other finance works