Experience

Ferrari South Bay

• United States
• Automotive
• 1 - 100 Employee

• Digital Marketing Analyst

  • May 2022 - Present

  • Analyzed the performance of historical campaigns through Python, Tableau, and Google Ads; Provided an improvement plan including costly campaign postponing, placement suggestions, and budget rearranging, resulting in a Cost per Conversions reduced by 50% • Analyzed the history data through Google Analytics API and provided suggestions for Search Engine Optimization (SEO), which increased users of vanity websites by 30% • Designing and completing an A/B Test to prove the effectiveness of the new Newsletter’s delivery time, which leads to an increase in Click Rate by 25% • Utilizing Selenium to automatically download data from Salesforce and enter customer information into our Customer Relationship Management Systems(CRM) Show less



Forkaia®

• United States
• Education
• 1 - 100 Employee

• Data Scientist

  • May 2021 - Aug 2021

  •Utilized Cross-validation(CV) and Support Vector Machine(SVM) to cluster and classify the high-quality customer •Built a CDP with effective contact information of 400,000 customers by data integration and integrating 38 databases •Developed programs for automated classification and data visualization, completed data visualization for 169 startups in employee structure and 10,302 interns in background analysis according to university and major • Applied NLP (Natural Language Processing) to Talent Snapshot of Forkaia, identifying and classifying interns as lucid professional titles, like software engineer, and data scientist, out of messy descriptive data Show less



Center for Medical Insurance of Shanghai

• Shanghai, China

• Data Analyst

  • Dec 2019 - Apr 2020

  •Assured the effectiveness of long-term care insurance on each level of disability in SQL Server; De-duplicated millions of rows of data and feature engineered new columns in the database, visualized the data, and presented the effectiveness for long-term care insurance via performance back-testing •Developed an executable program using Python to automate the calculation of corresponding data from each branch's weekly reported excel files and generate a synthesized new table, resulting in a work efficiency increase by 80% •Designing and completing an A/B test to prove the effectiveness of the new serving kiosk, which saves our customers 10% of waiting time. Show less



Agricultural Bank of China

• Banking
• 700 & Above Employee

• Risk Management Analyst

  • Jul 2019 - Aug 2019

  • Communicated with client account leaders and senior executives to collect business challenges involved in customer, channel and insurance product analysis projects and optimization support to insurance team • Created customer and market trend analysis using MS excel dashboard by Tableau, tracking average deal size, customer churn and campaign revenue KPIs, the workflow resulted in a 30 percent increase in close rates and revenue for the quarter • Communicated with client account leaders and senior executives to collect business challenges involved in customer, channel and insurance product analysis projects and optimization support to insurance team • Created customer and market trend analysis using MS excel dashboard by Tableau, tracking average deal size, customer churn and campaign revenue KPIs, the workflow resulted in a 30 percent increase in close rates and revenue for the quarter



China Life Insurance Co.Ltd

• China
• Insurance
• 400 - 500 Employee

• Risk Management Analyst

  • Jan 2019 - Apr 2019

  • Checked insurance documents and analyzed insurant’s economic situation to ensure compliance with rules and legality • Participated in insurance product development, mainly engaged in running models to mitigate risks of insurance fraud • Checked insurance documents and analyzed insurant’s economic situation to ensure compliance with rules and legality • Participated in insurance product development, mainly engaged in running models to mitigate risks of insurance fraud



Prudential Life Insurance Ghana

• Ghana
• Financial Services
• 500 - 600 Employee

• Insurance Analyst

  • Aug 2018 - Sep 2018

  • Generated SQL queries to extract customer and sales data from different regions to provide more than 50 insurance products • Built regression models in R language based on demographic and historical medical information and apply models to assist senior actuaries in pricing premiums for annuity products • Developed a financial plan for customers based on their property size, expected return, risk tolerance and other relevant information to meet their personal characteristics • Generated SQL queries to extract customer and sales data from different regions to provide more than 50 insurance products • Built regression models in R language based on demographic and historical medical information and apply models to assist senior actuaries in pricing premiums for annuity products • Developed a financial plan for customers based on their property size, expected return, risk tolerance and other relevant information to meet their personal characteristics