Raymond Gu's Email Addresses & Phone Numbers

Insurance Data Analyst Intern @ AAA • Created dynamic dashboards and reports that delivered industry insights to key business stakeholders.• Devised budget forecasting models using SAS and Excel for insurance revenue, building revenue targets and predictive analysis. • Enhanced service offerings and drove related revenue by designing insurance product targeting preferred customer segment by using cost analysis...

Insurance Data Analyst Intern @ AAA • Created dynamic dashboards and reports that delivered industry insights to key business stakeholders.• Devised budget forecasting models using SAS and Excel for insurance revenue, building revenue targets and predictive analysis. • Enhanced service offerings and drove related revenue by designing insurance product targeting preferred customer segment by using cost analysis in Excel and A/B testing•Performed root cause analysis for first year retention gap in customers in California. From 2014 to 2014 (less than a year) Walnut CreekStatistical Analyst Student Assistant @ UC Davis • Programmed in Excel and R to analyzed 5 years of previous tutoring data to portray trends of monthly drop in and the consistency of international student visitation to general population ratio• Designed hypothesis test through R to determine the effectiveness of tutoring on student grade point average• Created marketing ideas for the Center's brochure and new student surveys to attain data and test retention rates From 2013 to 2013 (less than a year) Solutions Analyst @ CLARA analytics Analyze data to define metrics and produce reports - identifying gaps and improving processes in the product delivery processManage the product delivery process while designing standardized workflows to improve tracking of team responsibilities, product roadmaps, and technical milestones with customersValidate data integrity from customers to ensure data qualityQuantify impact for customers in terms of claims closure rates, litigation rates, adjuster workload balance, and provider managementCreate data visualizations and graphs using tools like Tableau and Superset to identify usage trends and validation of customer data Product Operations Data Analyst @ Google Drive business initiatives with complex analytical thinking, utilizing both data-driven and e-commerce shopping platform knowledge.Analyze usage in Express Shopper app such as adoption, abandonment, churn and conversionsLead and support the development process for both the improvement of legacy product features and the implementation of new product features.Develop and manage scalable, automated SQL queries in Google Plx and Google Sheets via Google Apps ScriptBuild NLP models to automatically tag text and create segmentation space to increase efficiency of reporting processesAutomate SQL queries and email notifications that monitor the performance of our internal toolsInvestigate e-commerce fraud using user behavior and geolocation analytics Onsite via Adecco From 2017 to 2019 (2 years) San Francisco Bay AreaData Analyst @ Teradata • Reduced operational time and costs by breaking down customer resumes to granular level and building ranking models using SQL, KNN, and Random Forest, shortening client recruiters’ resume reading time.• Increased test accuracy 30% for client’s digital marketing segmentation project by creating machine learning models with Decision Trees in Python, filtering customers into different clusters.• Cut operational time and costs of manually matching images by using unsupervised machine learning to match up similar customer and client images.• Prevented revenue loss and identified customer attrition targets by creating predictive models for path to purchase and identified areas of attrition risk with retention analytics in SQL.• Communicated effectively with team members and customers by thoroughly documenting processes and results with run-books and SQL codebase for clients.• Maintained catalog of data sources, calculations, metrics, and uses in a data dictionary, used in identifying objects and relationships for future use. From 2015 to 2017 (2 years) San Francisco Bay Area