Doris Chen Email & Phone Number

Taiyuan, Shanxi, China

• Manipulated large volumes of credit cards’ data at customer and account level to build 10+ key Performance Metrics on customer engagement and sale performance for customer acquisition analysis, which improved YoY participation rate by 4%• Integrated, standardized and manipulated 14M+ customer data across different data sources using SQL server, and delivered monthly and quarterly portfolio business reports and forecasting analysis(SARIMA) to the senior management teams• Built 15+ key performance metrics and thresholds in multiple LOBs to assess different levels, deep dive data investigation to identify, analyze and synthesize material losses and ensure high data accuracy• Built code leakage reports for Customer Loyalty team to track offer abuse, and updated 3,000+ lines of scripts and stored procedures in Alteryx to improve readability and query efficiencies, lowering revenue loss by 3%

Toronto, Ontario, Canada

• Managed a start-up business; improved the overall performance with regards to products, services, profit, and customer relationships; achieved initial success• Analyzed the clients’ marketplace and preference data by Excel and Tableau; acquired better KPI performance by proposing some competitive offers• Created a new business account and performed marketing on social media platforms; Enhanced both financial liquidity and customer acquisition

Beijing, China

• Maintained, monitored, and measured key risk indicators, and delivered the findings to internal teams and external stakeholders, enabling the management team to identify potential risks and mitigants.• Manipulated and analyzed 3M+ customer and news data across different data sources (AWS, UQ20) using Pyspark, terminal and Brain, and delivered monthly and biweekly portfolio report to senior management team.• Built 15+ self-serve dashboards via SQL and Tableau to analyze campaign performances and develop campaign strategies; improved customer acquisition and response rates by 12% and 17% YoY separately on 3 main product lines• Presented analytical results to management and stakeholders, and delivered customer insights and business solutions, identified marketing opportunities and developed competitive strategies

Toronto, Canada Area

• Collaborated with global teams to process travel expenses for 12 legal entities across multiple regions, analyzed the summary of exception data, and presented suggestions for improvement in policy implantations• Automated a daily summary tracker of exception data with Excel, improved data processing efficiency by 20% and data accuracy by 15%• Analyzed internal transaction data at member and account level and built 10+ key metrics and thresholds to determine and forecast potential expense risk by building interactive dynamic excel sheets• Prepared monthly general ledger accruals using Concur system to ensure revenues and expenses record in the correct periods, and consolidated data to be used for performance analysis and data reference