Summary
Overview
Work History
Education
Skills
Certification
References
Timeline
Generic

Tanvir Khan

New York,NY

Summary

Dynamic Business Research Analyst with a proven track record at Columbia University, leveraging SQL and R programming to generate impactful analytical reports. Skilled in delivering accurate, high-quality datasets to stakeholders by verifying, validating, and continuously improving data integrity. Adept at collaborating with cross-functional teams to enhance data-driven decision-making. Recognized for developing innovative solutions that improved reporting accuracy and operational efficiency, showcasing strong analytical and communication skills.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Business Research Analyst / Analytics Developer

Columbia University
New York , New York
12.2023 - Current
  • Generated over 25 analytical reports using advanced SQL queries and various databases within Epic and Legacy Systems.
  • Extracted health information for surgery requestors utilizing Clarity, OMOP, and Legacy Information Systems.
  • Collaborated with surgery teams and external partners to analyze workflows and design targeted reporting solutions.
  • Managed routine report execution while troubleshooting issues and ensuring effective communication with stakeholders.
  • Employed standardized medical coding systems, including ICD-10 and CPT, for accurate data extraction and reporting.

Data Analyst

Columbia University
New York, New York
05.2023 - 12.2023
  • Collaborated with Neuroanesthesia division and anesthesia subspecialties to design quality control queries from historical data.
  • Developed and executed complex queries supporting retrospective research in public health and population studies.
  • Utilized Jupiter for data analysis as Clinical Data Navigator for extensive EPIC patient-physician relational database.
  • Led clinical trials assessing anesthesia effects on brain health during elective surgeries, differentiating emergence from acute recovery.

Data Scientist / Research Assistant

Columbia University
New York, New York
08.2022 - 05.2023
  • Conducted research utilizing Mendelian Randomization to assess LDL cholesterol's impact on Alzheimer's Disease risk.
  • Employed R programming for data loading, exploratory analysis, and statistical visualization.
  • Implemented R packages for efficient execution of Mendelian randomization analyses with summarized data.
  • Executed MR-Egger and inverse variance weighting methods using GWAS summary statistics to infer causal relationships.

Instructor

Columbia University
New York, New York
09.2022 - 12.2022
  • Delivered in-class programming demonstrations on various R topics including data manipulation and machine learning. .
  • Assisted students with coding inquiries, clarifying complex concepts of R programming.
  • Guided students through weekly assignments to enhance understanding and application of R skills.
  • Graded midterms and homework to assess student progress and comprehension.
  • Conducted weekly office hours for 10 hours to provide additional support and resources.

Instructor

Columbia University
New York, NY
05.2022 - 07.2022
  • Explained Machine Learning R topics, including Linear Model Selection and Regularization.
  • Assisted students with coding inquiries to enhance understanding.
  • Guided students on assignments to improve problem-solving skills.
  • Covered Logistic Models, Classification Models, and Tree Based Methods during sessions.

Data Scientist

Columbia University
09.2021 - 02.2022
  • Company Overview: Dr. Jeff Goldsmith Lab - COVID-19 New York City Trends Research - Columbia University
  • Project Goal is to examine relationships between a range of predictors (e.g., race/ethnicity, education, broadband internet access, household income / occupational income score, public vs. private health insurance) and COVID-19 health outcomes – hospitalizations, deaths, and vaccinations.
  • Used R programming to load data, perform exploratory analysis, data visualization, statistical analysis, and create dashboard and Shiny App.
  • Performed Data Visualization to show Death, Hospitalization, Vaccination rates over time for each NYC Boroughs.
  • Used Linear Regression to identify important predictors for outcomes such as the mean hospitalization rate in 2020.
  • Selected as the best Data Science Project for 2021 Academic Year.
  • Created Website to showcase the project, code, and report, Website Link: https://zacharykatz1.github.io/nyc_covid_trends/index.html
  • Dr. Jeff Goldsmith Lab - COVID-19 New York City Trends Research - Columbia University

Education

Master of Science - Biostatistics

Columbia University in The City of New York
New York, NY
05.2023

Bachelor of Science - Computer Science and Biostatistics, Minor in Mathematics

University of California, Irvine (UC Irvine)
Irvine, CA

Skills

  • SQL and Microsoft SQL Server
  • R programming
  • Python programming
  • SAS analytics
  • Microsoft Excel proficiency
  • DBVisualizer expertise

Certification

  • Epic - COG170 Cogito Fundamentals
  • Epic - Clarity Clinical Data Model
  • Epic – Caboodle Data Model
  • Epic – Clinical Data Model

References

References available upon request.

Timeline

Business Research Analyst / Analytics Developer

Columbia University
12.2023 - Current

Data Analyst

Columbia University
05.2023 - 12.2023

Instructor

Columbia University
09.2022 - 12.2022

Data Scientist / Research Assistant

Columbia University
08.2022 - 05.2023

Instructor

Columbia University
05.2022 - 07.2022

Data Scientist

Columbia University
09.2021 - 02.2022

Master of Science - Biostatistics

Columbia University in The City of New York

Bachelor of Science - Computer Science and Biostatistics, Minor in Mathematics

University of California, Irvine (UC Irvine)

Similar Profiles

CREATE PROFILE