Cindy Zhuo Sun Email & Phone Number

Columbia, Sc, Us

Vancouver, British Columbia, Canada

Greater Vancouver, British Columbia, Canada

Job Responsibilities:• Performed data extraction, integration and manipulation using SAS, SQL and Python• Conducted descriptive and summary analyses based on the research project targets and generated summary reports using SAS/Graph, PROC Report/Tabulate and Tableau dashboard• Performed regular data integration to identify and report data issuesProject #1: Telecom Customer Churn Analysis and Dashboard Reporting• Performed data profiling, consolidation and manipulation on one-year historical datasets (service subscription tables, customer information table, churn list and service charge summary table)• Generated summary table based on segmentation/retention analysis on monthly count of newly activated/churned customers and ARPU of current customers• Designed Tableau dashboard using table calculations and advanced visuals (e.g., donut, waterfall, cards) to exhibit the MoM customer churn/gain and ARPU summaryProject #2: Auto Insurance Customer Retention Analysis and Reporting• Retrieved data from Oracle and Access Database using SAS/SQL pass-through facility• Performed sophisticated data cleansing, manipulation and validation on datasets concerning multiple information levels and complex data issues• Applied segmentation analysis (customer age/credit group and discount combination) on the key customer retention and risk KPIs including loss count, loss ratio, and churn rate based on the 3-year historical transactional data• Generated dashboard report using SAS/ODS HTML panel and G-Procedure that visualized shifts of risk qualities with respect to different discount combinations and showcased groups with high possibility of customer churn

Job Responsibilities:• Retrieved large datasets on loan applications and previous term-deposit product campaigns• Performed segmentation analysis on post-campaign data and derived insights to inform future marketing• Conducted data cleansing, imputation, and simple statistic analysis for the risk modeling teamProject #1: Bank Loan Risk Prediction Data Preparation• Prepared data from large for bank loan risk prediction modeling, including null value imputation, data values standardization, and data type conversion using Python NumPy and Pandas data manipulation and analysis packages• Performed data profiling and validation by visualizing data using Python Matplotlab and Seaborn• Authored Python self-defined functions to generate Seaborn graphs and heatmaps for inferential analysis on variables strongly associated with customer’s default behaviors and provided reliable reference for the modeling teamProject #2: Segmentation Analysis on Term Deposit Product Campaign• Retrieved the historical post-campaign data and segmented customers based on their demographic information and financial status (bank account balance, personal/house loan status, default record)• Calculated customer response rate, contact duration and average contact number during the campaign• Delivered results using SAS SG Procedure and identified customer groups with high acceptance rates

Master Of Science - Ms

Bachelor'S Degree