Data Analyst Specialist

Tianhui(Julia) Zhu

415-***-**** **************@*****.*** linkedin.com/in/tianhui github.com/tianhui Education

University of California Berkeley Berkeley, CA

Bachelor of Arts in Data Science, GPA:3.33/4.0 Aug. 2020 – May 2022 Summary

• Data specialist with demonstrated 2 years’ data experience in technology, finance and healthcare industries

• Language: SQL, Python(Numpy, Pandas, Sklearn), R, Excel(Lookup, Pivot table)

• Data Visualization: Tableau, Power BI, Matplotlib(Python), ggplot2(R)

• Machine Learning: Linear/Logistic Regression, KNN, Clustering, Decision Tree, Random Forest, etc. Experience

Infrrd Inc San Jose, CA

Data Analyst Intern Feb. 2022 – NOW

• Data cleaned, classified, and extracted 3k insurances PDF documents keywords with NumPy, Pandas(big data analytics tool) to generate an extensive database

• Built 6 dashboards with Tableau to visualize 10 companies’ conversion rates, enabled project managers to customize queries by simply clicking on several filters, and shortened the data retrieving time by 30% China International Capital Co. Ltd. Shanghai, China Data Analyst Intern June 2021 – Aug. 2021

• Data cleaned 16 companies’ interior data with SQL to estimate the conversion rate and employee retention rate of the companies’

• Created 12 dashboards with Tableau to present the profitability and business capabilities of 8 companies, gave investment managers more investment advice

• Established valuation model with Excel through prospectus, company announcement, industry research report, annual financial report, etc. Computed listing valuation, prepared investment analysis report, gave essential investment strategy

Shenzhen Capital Group Co. Ltd. Shanghai, China

Data Analyst Intern Dec. 2020 – Mar. 2021

• Collected information through statistical data such as Wind, brokerage research reports, consulting reports, and industry websites to determine the success of a new product launch, competitive analysis, or patterns. Used data to help drive employee productivity and save the company’s money

• Built dashboards with Tableau to visualize products’ information, enabled project managers to customize queries by simply clicking on several filters, and shortened the data retrieving time by 30 percent

• Worked closely with financial company customers to analyze potential data analytics needs for business cases based on evolving client requirements

Pfizer China Research and Development Center Shanghai, China Publishing Manager Intern May 2020 – Aug. 2020

• Filtered drug clinical phase data with SQL and standardized clinical reports to meet FDA requirements and shorten time-to-market

• Developed dashboards with Tableau to predict drug launch time and market share for maximum profitability by studying the competitive landscape of the same type of drug market Projects

Kaggle Bronze medal in ”Jane Street Market Prediction” Jan. 2021 – Apr. 2021

• Reduced the effect of data overfitting with Pytorch Resnet and Tensorflow Resnet

• Expressed the association of each feature with EMbeddings NN

• Visualized data to have a sense of data with Seaborn

Contact this candidate