James Tsang

Experience

• 

  SUNY at Stony Brook

  Jan 1995 - Jan 1997

  Lab Manager

  Performed fluorescence measurements to study lipid-protein interactions. Managed the daily operations of the laboratory such as coordinating the laboratory research and purchasing supplies. Utilized equipment such as ultra/micro-centrifuge, spectrophotometer, analytical balance, pH meter, and laboratory computers. Trained and supervised National Science Foundation fellows, research aides and graduate students doing rotations through the laboratory. Interfaced, maintained and upgraded six networked computers in the laboratory. Show less

• 

  Yale Cancer Center

  Jan 1998 - Jan 1999

  Statistical Consultant

  Collaborated with physicians by providing statistical and computer technical support. Utilized SAS and S+ in performing statistical data analysis on cancer data sets involved with Phase I Clinical Trials. Prepared/ cleaned raw cancer data sets for statistical analysis. Prepared data analysis reports and charts for interpretation of data analysis results to principal investigators.

• 

  MSKCC

  May 1999 - Mar 2002

  Database Administrator

  Created/executed SQL queries/stored procedures that quality assured the picture archiving communications system (PACS). Installed/configured server/client database applications. Created reports of exam activity from the Radiology Information System (QuadRIS) for physicians. Analyzed and resolved problems with the interfaces between the department’s database systems and the various hospital systems.Biostatistics Consultant, Department of Anesthesiology/Epidemiologists and BiostatisticsCollaborated with a physician and a senior biostatistician in determining the patient characteristics associated with the development of atrial fibrillation after undergoing thoracic surgery. Utilized SAS and SPSS for the data entry, cleaning and analysis. The results will then be used to make clinical recommendations for patients undergoing thoracic surgery.Research Study Coordinator, Department of Epidemiology and Biostatistics, Data Management Resource Group. Collaborated with Research Study Assistants/Physicians working on Phase I-III clinical trials by providing relational database querying support using Oracle Browser (SQL) and technical support in our Clinical Research Database. Managed an enterprise level Oracle relational database which involved modifying data entry forms and questionnaires and updating valid lists. Collected, compiled and maintained clinical trial data using a relational database. Provided classroom and one-to-one training for new personnel in the use of a relational database. Reviewed, audited and assisted in amending clinical trial protocols for the Institutional Review Board (IRB). Tested new database module changes and resolved programming errors. Created technical documentation for use in training and administrative purposes. Show less

• 

  Northwell Health

  Mar 2002 - now

  Performed extensive data mining/wrangling/harmonization, validation and interpretation of EMR data (Allscripts SCM/Touchworks, SIS, Radiology, Billing Data etc.) using SQL/Python/SAS in meeting COVID-19 research requests and other data requests of the research community.Designed and developed an online scalable custom search interface (akin to PubMed’s Advanced Search Builder) allowing users to query data across multiple domains (demographic, laboratory, medication, procedure, encounter etc.). Search results were then used for grant submissions and for data analyses. Managed the Biostatistics Randomization Management System (BRMS), a web-based system that I developed which plays a crucial role in executing the many clinical trials of FIMR, including the new COVID-19 trials.Managed SAS user accounts and provided programming guidance to SAS users. Collaborated with infrastructure team to resolve SAS Server performance issues. Show less Utilize SAS to create logical checks on clinical data from pharmaceutical clinical trials and internal research projects; to perform statistical analyses; to create standard reports for submission to government agencies; and to manage/back-up data from various sources across network. Create web-based databases for clinical data management purposes using Coldfusion and JavaScript. Collaborate with physicians and investigators in writing protocols/grants for submission to the IRB and for government funding. Provide support and management of department network of Windows 7 workstations. Show less

  • Senior Data Engineer

    Jan 2022 - now

  • Senior Data Analyst - Center for Research Informatics & Innovation

    Mar 2021 - Jan 2022

  • Senior Software Engineer - Center for Research Informatics and Innovation

    Apr 2019 - Mar 2021

  • Project Manager - Department of Biostatistics

    Mar 2015 - Apr 2019

  • Senior Applications System Analyst - Department of Biostatistics

    Mar 2002 - Mar 2015