Lihao Chen Email & Phone Number

3 years of proficiency in SAS and SQL programming, leveraging SAS/EG, Macro, and SQL Pass-Through Facility for ETL tasks from databases like DB2, Oracle, and SQL Server; experienced in utilizing cloud-based services including Azure SQL Database, Data Lake Storage, and Databricks. 3 years of experience conducting diverse analyses across industries, with a focus on CRM analysis within the Telecom sector, encompassing customer profile segmentation, call center analysis, and customer churn analysis. Additionally, proficient in post-campaign analysis, including A/B testing and KPI tracking, and adept at RFM and Market Basket analysis for tailoring up/cross-sell strategies in Retail. Also, experienced in conducting loss ratio and attrition analysis within the Insurance industry. 3 years extensive experience in generating insightful reports such as Customer Segmentation, Channel, and Membership Monitoring using SAS procedures. Proficient in leveraging Tableau and Power BI to design dynamic Marketing, Inventory, and Customer Churn dashboards for KPIs visualization that drive actionable insights and inform strategic decision-making. With 3 years of experience, skilled in Excel and proficient in utilizing Pivot Tables, VLOOKUP, Macros, Offset, Index, Solver, and other functionalities for data analysis and manipulation. 2 years of model building experience in Telecom and Retail industries, proficient in techniques such as Clustering, Uplift, Logistic Regression, and Random Forest using R, Python, and SAS/EM. Advanced project management, cross-functional collaboration, and timely decision-making skills.

• 

  University Of Ottawa

  Statistics