Joy Gao
Business Intelligence Development Associate at Jia Law Group- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
Chinese Native or bilingual proficiency
-
English -
-
French Elementary proficiency
Topline Score
Bio
Credentials
-
Tableau Desktop Specialist
TableauMay, 2022- Sep, 2024
Experience
-
Jia Law Group
-
United States
-
Law Practice
-
1 - 100 Employee
-
Business Intelligence Development Associate
-
Feb 2019 - Present
• Managed inquiries and client database by using Google sheets, Excel and Salesforce• Generated and presented weekly, quarterly and annually report to support manager-level’s decision-making• Analyzed 5000 historical client data by using Excel and R, and created user image report to help marketing team budget and target user groups • Collaborated with teammates and vendors to design and launch new products; meanwhile run effective marketing campaign • Managed inquiries and client database by using Google sheets, Excel and Salesforce• Generated and presented weekly, quarterly and annually report to support manager-level’s decision-making• Analyzed 5000 historical client data by using Excel and R, and created user image report to help marketing team budget and target user groups • Collaborated with teammates and vendors to design and launch new products; meanwhile run effective marketing campaign
-
-
-
Society of Actuaries
-
United States
-
Insurance
-
100 - 200 Employee
-
Opioid Overprescribing Behavior Research Project
-
May 2017 - Aug 2017
• Processed and handled 5,000,000 Medicare provider data in the past 5 years using R and SAS• Researched public health background and determined the measurements of the data pattern with public health professionals• Built linear regression predictive models, distribution fitting and K-means clustering methods by R, and chose the optimized one• Presented final results to SOA health actuaries, and composed project paper for publication • Processed and handled 5,000,000 Medicare provider data in the past 5 years using R and SAS• Researched public health background and determined the measurements of the data pattern with public health professionals• Built linear regression predictive models, distribution fitting and K-means clustering methods by R, and chose the optimized one• Presented final results to SOA health actuaries, and composed project paper for publication
-
-
-
-
Actuarial Intern
-
Jun 2016 - Aug 2016
• Frequently communicated with the claim and underwriting department and built VBA programs to automate daily claim reporting process which accelerated processing time by 1000 times- Audited and recorded 9,000 quarterly claim reports, performed extensive experience analysis on policyholder behaviors, provided key findings to the pricing team, and assisted in product designs, modeling, and model validations- Constructed stochastic models in Excel to simulate costs in 10,000 scenarios and tested the impacts on profit margins- Fitted loss data in the past 3 years in various aggregate loss models, estimated future losses, and presented results to managers- Updated descriptive statistics for ad-hoc projects and presented study results to multiple stakeholders in different departments
-
-
-
-
Researcher
-
Sep 2015 - May 2016
- Constructed the Emory campus spatial database independently using ArcMap and Excel VBA- Successfully collected spatial data from 74 categories by communicating with eight different departments - Designed and built a web map using basic Python in ArcMap by cooperating with IT professionals - Constructed the Emory campus spatial database independently using ArcMap and Excel VBA- Successfully collected spatial data from 74 categories by communicating with eight different departments - Designed and built a web map using basic Python in ArcMap by cooperating with IT professionals
-
-
-
Emory University School of Medicine
-
United States
-
Higher Education
-
700 & Above Employee
-
Lab Assistant
-
Jun 2015 - Aug 2015
• Assisted with lab researches by transferring 120 sample patients’ fMRI images into numerical data using MATLAB • Provided descriptive statistics for 325 patients’ information records using Excel and suggested model improvements• Improved QBIL website by independently learning HTML and added 40 new lab publications with teammates• Introduced relevant researches and discovered new topics to the lab group by summarizing and explaining research papers • Assisted with lab researches by transferring 120 sample patients’ fMRI images into numerical data using MATLAB • Provided descriptive statistics for 325 patients’ information records using Excel and suggested model improvements• Improved QBIL website by independently learning HTML and added 40 new lab publications with teammates• Introduced relevant researches and discovered new topics to the lab group by summarizing and explaining research papers
-
-
-
-
Student Research Assistant
-
Sep 2014 - May 2015
• Constructed a spatial database for the “Senufo Art” project using Excel and ArcGIS• Collected and arranged relevant data from historical documents and used SAS to output merged datasets into Excel workbooks• Visualized art trading route in Senufo area in a web map by cooperating with teammates- Introduced relevant researches and discovered new topics to the lab group by summarizing and explaining research papers • Constructed a spatial database for the “Senufo Art” project using Excel and ArcGIS• Collected and arranged relevant data from historical documents and used SAS to output merged datasets into Excel workbooks• Visualized art trading route in Senufo area in a web map by cooperating with teammates- Introduced relevant researches and discovered new topics to the lab group by summarizing and explaining research papers
-
-
Education
-
2016 - 2017
Columbia University in the City of New York
Master of Science (MS), Actuarial Science -
2012 - 2016
Emory University
BS, Applied Mathematics
Community
