A Training Data Visualization

Li Tian

Email: ********@*****.*** Tel: +1-347-***-****

EDUCATION

Columbia University in the City of New York, New York, U.S. 08/2023 -05/2025 M.S. in Biostatistics

The College of Wooster, Ohio, U.S. 09/2018-05/2022 B.A. in Mathematics

Skills: R(advanced), SQL(Medium), SAS(Medium), Python (Medium), LaTeX (Medium), Maple (Medium), Stata (Medium) ACADEMIC EXPERIENCE

Analyzing 2024 League of Legends World Championship Data 12/2024

• Utilized MySQL to design and implement a relational database from scratch, analyzing player and champion performance in the top eight teams of the 2024 League of Legends World Championship. Created a normalized schema, executed complex queries with joins, aggregate functions, and subqueries, and extracted insights into champion win rates, player preferences, and team strategies, demonstrating strong data manipulation and analysis skills. Statistical Analysis in a Study on Metabolic Syndrome and Cognitive Function 12/2024

• Utilized SAS to analyze baseline demographic characteristics and neuropsychological test scores by metabolic syndrome

(MetS) status. Conducted independent t-tests to compare group differences, linear regression to evaluate associations between MetS risk scores and cognitive outcomes, and multivariable regression to adjust for confounders such as age, sex, and education.

• Applied advanced statistical techniques to identify significant predictors of cognitive impairment, emphasizing the impact of elevated glucose levels and blood pressure. Developed visualizations, including forest plots, to effectively present regression results and highlight key findings.

Exploring the Relationship between Blood Pressure Control and Disease History

• Applied survey design techniques using R to analyze NHANES 2015-2016 data, incorporating survey weights and strata in logistic regression models. Conducted descriptive analysis, performed missing data imputation, and identified significant associations between chronic kidney disease, coronary heart disease, and BP control. Predicting the factors affecting the severity of COVID-19 infections 05/2024

• Utilized R to predict the response variable covid-19 severity infections. The data was partitioned into a training dataset (20%) and a test dataset (80%). Factors influencing the severity were categorized into numerical and categorical variables, which were visually analyzed to assess their impact.

• Five different models were employed to fit the data for predicting the response variable. The accuracy of these models was compared using resampling techniques to select the optimal prediction model. L-theanine on top of Escitalopram for Major Depressive Disorder RCT 02/2024 – 05/2024

• Design for an NIH phase III two parallel group superiority RCT for L-theanine on top of Escitalopram for Major Depressive Disorder which meets the seven requirements for an RCT.

• Included clinical question, primary and secondary outcomes, detailed process of trail design, and statistical consideration, etc. Mathematical Analysis and Reporting on YouTube Subscriber Numbers 10/2023 – 12/2023

• Utilized R to create a website for display of video performance analysis results, combining data visualization and predictive modeling to make findings clear and actionable. Conducted detailed analyses to assess the effectiveness of video strategies on view counts and audience engagement.

• Developed predictive models to identify content that effectively attracts viewers, providing insights to optimize YouTube channel growth.

WORKING EXPERIENCE

Servier, Beijing, Intern 06/2024-08/2024

Worked with SAS programmers to collect and prepare data for analysis, performing data cleaning and preliminary data quality checks to ensure the accuracy and integrity of datasets for subsequent statistical analysis.

Collaborated closely with statisticians to write and proofread clinical trial protocols in both Chinese and English, ensuring accuracy and clarity in statistical and methodological descriptions. Everbright Securities, Beijing, Research Institute 10/2022-01/2023

Deepened my understanding of financial knowledge through sorting out information of different banks as well as the tier1 asset and tire 2 asset.

Collected relevant information about the Lehman Brothers bankruptcy and Western National Bank WNB to analyze whether the US government invoked the orderly liquidation fund (OLF) to save them.

Analyzed foreign pension mechanism including defined benefits and defined contribution, summarized all details of the information.

Made a summary of the third quarter's performance reports regarding PICC, Bank of China and Agricultural Bank of China. CPCEP Company, Beijing, Intern 06/2019

Managed exhibitions and staffs for company.

Used Microsoft office to create meeting materials for introductions of different energy saving websites.

Contact this candidate