Data Manager

• Jun 2020 - Present

Data Scientist

• Mar 2020 - May 2020

· Created and maintained Tableau user journey dashboard under company ETL pipeline via Google cloud platform (Google Cloud Function & BigQuery), providing user behavior insights and increasing work efficiency across operations and marketing departments · Designed and performed marketing email AB testing campaign through MailChimp to improve marketing effectiveness · Created and maintained Tableau user journey dashboard under company ETL pipeline via Google cloud platform (Google Cloud Function & BigQuery), providing user behavior insights and increasing work efficiency across operations and marketing departments · Designed and performed marketing email AB testing campaign through MailChimp to improve marketing effectiveness

Software Developer (Namei Group Inc.)

• Aug 2019 - Mar 2020

· Participated in designing, developing, and testing back-end flight search engine which manages company group travel orders and ticket orders, and auto-retrieves information from vendors, drawing 12% more ticket orders per month · Designed SQL database tables and Integrated with flight search engine API, automating data storage and upgrading operation efficiency by 40% · Participated in designing, developing, and testing back-end flight search engine which manages company group travel orders and ticket orders, and auto-retrieves information from vendors, drawing 12% more ticket orders per month · Designed SQL database tables and Integrated with flight search engine API, automating data storage and upgrading operation efficiency by 40%

Data Scientist

• Nov 2019 - Dec 2019

· Performed data cleaning and analysis, such as text mining, correlation analysis, mapping with Excel, Python and Tableau on sexual assault data to summarize customer characteristics and assist making marketing strategies · Visualized data findings using Python folium, seaborn, plotly and Tableau under visualization principles of Edward Tufte and communicated with C-level executives to help operation decision making · Performed data cleaning and analysis, such as text mining, correlation analysis, mapping with Excel, Python and Tableau on sexual assault data to summarize customer characteristics and assist making marketing strategies · Visualized data findings using Python folium, seaborn, plotly and Tableau under visualization principles of Edward Tufte and communicated with C-level executives to help operation decision making

Tax Intern

• Sep 2017 - Dec 2017

· Assisted clients to online file for new Business Corporations, corporation dissolution, and patent application · Communicated with corporation and partnership taxpayers to e-file Form 941 payroll tax using AME tax preparation software, and paid tax online · Interviewed individual taxpayers to e-file tax return using DRAKE tax preparation software · Assisted clients to online file for new Business Corporations, corporation dissolution, and patent application · Communicated with corporation and partnership taxpayers to e-file Form 941 payroll tax using AME tax preparation software, and paid tax online · Interviewed individual taxpayers to e-file tax return using DRAKE tax preparation software

Audit Intern

• Jun 2016 - Jul 2016

· Worked with audit team members to help audit Wind-energy company’s financial statements in 2015, including doing physical inventory verification, preparing the letter of confirmation of several accounts, such as account receivables, account payables, inventory, and sales expenses, used Excel to prepare audit reports in the end · Communicated with clients about the materials the team needed and discussed the problems the team had · Worked with audit team members to help audit Wind-energy company’s financial statements in 2015, including doing physical inventory verification, preparing the letter of confirmation of several accounts, such as account receivables, account payables, inventory, and sales expenses, used Excel to prepare audit reports in the end · Communicated with clients about the materials the team needed and discussed the problems the team had