Vicky Leng Email & Phone Number

Toronto, Ontario, Canada

Toronto, Ontario, Canada

• Achieved 96.6% prediction accuracy for bad debts and write-offs by developing a forecasting model using SAS; determined top 3 bad debt factors from past 8 years’ data
• Visualized booming volumes for involuntary churn in new immigrants and international students by categorizing demographics in location, credit level, product combination, purchase method, etc., by analyzing 1M data.
• Achieved 97.9% accuracy forecasting involuntary churn and annual budget daily, monthly, and yearly from ETL (Extract, Transform, Load) of 110k financial information by SQL, Oracle and SAS
• Evaluated and forecasted monthly and annual 6M customers’ bad debt, write-off, and 12 internal Finance Stakeholders’ KPI in wireless products using SAS, Python libraries such as Pandas, NumPy
• Visualized credit, collection, finance KPIs, and involuntary churn by developing 3 dashboards, 30+ cards using DOMO and Tableau for monthly executive reporting, collaborated with cross-functional teams to understand.
• Led a team of 3 to prepare wireless and wireline monthly and annual performance reports in bad debt and involuntary churn, presented to VPs, directors, finance and marketing managers, data scientists

Toronto, Ontario, Canada

• Increased 3k clients total by collecting and analyzing monthly campaign and sales data by Excel, SQL, and SAS, identified trends, patterns, and opportunities for optimization
• Checked 10k+ customer information data quality by SQL monthly, improved customer information accuracy
• Managed regional sales performance and segmented client base and probability of purchase, collaborated with cross-functional teams including marketing, sales and product to align data analysis with business goals
• Analyzed customer behaviour data to identify opportunities and improved customer retention rate by 5% yearly
• Evaluated monthly sales performance, and created a dashboard with Tableau for marketing KPIs

Master'S Degree, Applied Economics

Bachelor Of Commerce - Bcom, Business Administration And Management, General