Hao Data Jiang Analyst Bai

https://github.com/Haobai24 Sunnyvale, CA adkjua@r.postjobfree.com 408-***-**** EDUCATION

University of California, San

Diego,

Bachelor of Science, Biology

CERTIFICATION

Udacity Data Analyst

Nanodegree,

Used Python, SQL and statistics

to analyze data, visualize

critical findings and create

data-driven solutions

SKILLS

SQL Relational Database

Big Data Pipeline (ETL)

Python in Data Analysis

A/B Testing

Statistical Modeling

Data Wrangling

Data Visualization

Pandas & Numpy

Matplotlib & Seaborn

Tableau

Excel

PROFESSIONAL PROFILE

Data Analyst with a background in Biotechnology. Experienced in finding, retrieving, wrangling, and delivering insights in the fields of user behavior and product performance. WORK EXPERIENCE

PV Operations Associate (Data Analyst) – Genentech/South SF, CA, Oct 2019-Present

• Manage Tableau dashboards to forecast patient case volume and streamline workflow assignments with internal teams and vendor leads.

• Analyze data from multiple sources to track and investigate cases contribute to late submissions and metrics.

• Run macros and scrips to automate case processing in data preparation and other operational supports.

Reliability Quality Control – Nanosys/Milptas, CA, Nov 2017-Jan 2020

• Managed over 20,000 sample test results into MySQL database. Extracted, imported and reported samples information to support R&D team developing higher quality quantum dots.

• Tested optical performance and reliability of quantum dot samples using LabVIEW program. Performed data analysis with excel macros to calculate lifetime expectancy on each sample.

Research Associate – Coretests inc/Carlsbad, CA, Feb 2015-July 2017

• Developed parameter for pregnancy/drug test kits based on lateral immune assay. Designed and conducted experiments for FDA 510k submissions.

• Gene cloning for HIV, Dengue and Malaria antigens. Monitored cell culture, expressed recombinant DNA and purified proteins in Ni-NTA affinity chromatography. PROJECTS

Communicate Data Findings (Loan Data from Prosper)

• Performed data cleaning and create univariate, bivariate and multivariate analyses on over 80 characters that affects the borrower’s APR to understand relative importance of features, given over 11,000 loans.

• Created a explanatory data visualization that provides two significant factors to improve efficiency in loan approval process.

Data Visualization with MySQL and Tableau (Northwind Dataset)

• Created a database schema to connect relationships between products sold by companies within U.S.

• Extracting, wrangling, and organizing sales data with SQL queries. Built Northwind Sales Performance Dashboard with Tableau to suggest top KIPs to improve sales performance. A/B Test on New Page Design

• Ran a hypothesis test and built a logistic regression model using Python statistics packages to explore number of people converted from the old page to the new page.

• Generated a p-value of 0.190, which concluded the company should keep the we old page to attract more users.

Contact this candidate