Summary
Overview
Work History
Education
Skills
Work Availability
Timeline
Generic

RAY CHEN

Analytics Manager
San Diego,CA

Summary

SUMMARY

  • Improved business decision-making by meeting with diverse stakeholders within LPL, deriving insight from conversations along with data, and building interactive dashboards and other tools to communicate findings.
  • Served as primary analytics partner to multiple departments within LPL, including both finance and product teams, conducting analyses focused on eliminating inefficiencies and delivering automated reports tracking success.
  • Regularly transformed large amounts of disparate data points into metrics that translated to real business understanding for stakeholders. Used that mutual understanding to drive change, resulting in numerous projects that impacted LPL positively.
  • Identified data inefficiencies that bottlenecked analytical breakthroughs and communicated with data engineering team to establish business requirements, add new data, and eliminate quality issues.

Overview

11
11
years of professional experience
5
5
years of post-secondary education

Work History

DATA ANALYTICS MANAGER

LPL FINANCIAL
01.2015 - Current
  • Partnered with Technology department to lead a data science program that extracted data points from the call routing database, interpreted the data points through meetings with users, and transformed the data points into recommendations that became instrumental in configuring the call routing system to better suit the needs of LPL’s clients. Created and tracked performance of relevant KPIs using a Tableau data visualization

Result: 8.1% call misroute rate driven down to 4.3% misroute rate over the course of 12 months, or about 84,400 call mis-routes avoided per year translating to ~$1.35 million dollar annual savings


  • Developed a Speech Analytics software configuration to enable stakeholders to align call center data to operational data, and identify what operational inefficiencies manifest into costly conversations

Result: Tableau visualizations used by Finance department to help allocate budget for improvement projects

  • Communicated actionable insights from Speech Analytics findings to broad range of operations and call center stakeholders. Created a bridge between operations and call center leaders with weekly meetings diving into findings and providing investigation into subsequent business questions

Result: 65 call abatement initiatives completed, translating to savings of ~$800,000 annually

  • Engaged in communications with the Product teams to understand the interplay of LPL user behavior metrics, search term usage, and call center activity. Then blended the data from these disparate sources using SQL, and organized the results into data visualizations that informed the direction of a product aimed at improving resource center search capabilities

Result: Resource center articles re-indexed optimally to allow clients to self-service issue for each popular search term

  • Led coaching seminars on how to effectively utilize an interactive dashboard to help each call center team identify representatives who were driving repeat calls with misinformation or didn’t abide by call center standards
  • Acted as main analytical partner for the Onboarding team, extracting vast amounts of data using SQL, performing data manipulation to fit business needs via Excel, and publishing views daily on Tableau as a business intelligence dashboard
  • Developed best practices for a team focused on call sampling to solve for LPL client pain points regarding direct client communications
  • Led effort to effectively communicate the findings derived from the analysis with various Operations teams, leading to a change in daily processes aimed at resolving those pain points

Result: 27 templates for direct client communications improved, leading to higher sentiment measures and ~400 fewer follow-up calls per month in response to those communications.

TELLER OPERATIONS SPECIALIST

BANK OF AMERICA
03.2010 - 05.2013
  • Provided leadership and sales mentorship for tellers in one of San Diego County’s busiest banking centers.

Education

Bachelor of Science - Economics - Management Science

University of California San Diego
05.2005 - 05.2009

Tableau, SQL, And Advanced Analytics in Excel Certification - Business Intelligence Data Analytics Certificate

University of California San Diego Extension
05.2017 - 05.2018

Skills

SQLundefined

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

Tableau, SQL, And Advanced Analytics in Excel Certification - Business Intelligence Data Analytics Certificate

University of California San Diego Extension
05.2017 - 05.2018

DATA ANALYTICS MANAGER

LPL FINANCIAL
01.2015 - Current

TELLER OPERATIONS SPECIALIST

BANK OF AMERICA
03.2010 - 05.2013

Bachelor of Science - Economics - Management Science

University of California San Diego
05.2005 - 05.2009
RAY CHENAnalytics Manager