CV

SKILLS

Power BI, Tableau, SQL, Microsoft SQL Server, Oracle PL/SQL, SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Python, pandas, Scikit-Learn, TensorFlow, Matplotlib, Plotly, R, R Shiny, Tidyverse, ggplot, ETL, statistical analysis, SPSS, Git, GitHub, Jira, Confluence, SharePoint, Excel, Qualtrics, NLP, Machine Learning

EMPLOYMENT

Columbia University, Vagelos College of Physicians and Surgeons New York, NY

Business Intelligence Developer (December 2021 – Present)

  • Develop and maintain reports, dashboards and scripts (Power BI, SSRS, Tableau, Oracle, R) to support fundraising; manage projects from start to finish, working directly with fundraisers, communications and marketing teams.
  • Improve SQL queries and workflows to enhance report performance and decrease load time.
  • Optimized fuzzy matching algorithm to link entities between databases, increased matches by >5%.
  • Develop and implement donor propensity scoring via statistical inference to identify top prospects.

Columbia University, Columbia College New York, NY

Data and Research Analyst (April 2019 – November 2021)

  • Built high impact reports and dashboards (SSRS, Power BI, Microsoft SQL Server), working with diverse stakeholders across Columbia University. 
  • Executed reporting to accurately track and implement $XXM of tuition offsets for college students taking classes during the summer of 2021.
  • Engineered ETL pipelines via SSIS and stored procedures (SSMS), which supplied internal data warehouses with XXXk records refreshed daily.

National Institutes of Health, National Institute of Mental Health, Bethesda, MD

Post-Baccalaureate Fellow (June 2016 – June 2018), Clinical and Translational Neuroscience Branch, Neuropsychology Lab

  • Initiated and oversaw the implementation of R statistical programming software in the lab’s analytical workflows; trained lab members and created sample code templates.
  • Designed and conducted statistical analysis of study data using SPSS and R. Advanced the lab’s research on variance in polygenic risk among subgroups of schizophrenia patients.
  • Selected to give an oral presentation at the International Congress on Schizophrenia Research.

Wesleyan University, Schizophrenia Cognition Lab, Middletown, CT

Research Assistant (February 2014 – May 2016)

  • Piloted a cognitive remediation program for adults diagnosed with a primary psychotic disorder at Gilead Community Services. This included writing IRB documents, performing outreach and coordinating schedules with patients and staff, administration and scoring of neuropsychological batteries, and statistical analysis of study data using SPSS
  • Authored a thesis based on my research and was awarded High Honors

EDUCATION

Columbia University, New York, NY

  • MA Quantitative Methods in the Social Sciences (August 2023)

Wesleyan University, Middletown, CT

  • BA, Neuroscience and Behavior, High Honors
  • Minor in Film Studies

Data Science Part-time Intensive, General Assembly

PUBLICATIONS

Dickinson, D., Zaidman, S. R., Giangrande, E. J., Eisenberg, D. P., Gregory, M. D., & Berman, K. F. (2020). Distinct Polygenic Score Profiles in Schizophrenia Subgroups With Different Trajectories of Cognitive Development. American Journal of Psychiatry, 177(4), 298-307. doi:10.1176/appi.ajp.2019.19050527

Kurtz, M., Trask, C., Rosengard, R., Hyman, S., Kremen, L., Mehta, S., Rispaud, S., Zaidman, S., . . . Choi, J. (2017). Verbal Learning and Memory Enhancement Strategies in Schizophrenia: A Randomized, Controlled Investigation. Journal of the International Neuropsychological Society, 23(4), 352-357.

PRESENTATIONS

Oral Presentations:

Zaidman, S., Giangrande, E., Weinberger, D., Berman, K., Dickinson, D. (March 2017). Exploring Polygenic Risk in Cognitive Subgroups of Schizophrenia: Associations Between Risk Profile Scores and Measures of Cognition. Oral Presentation given at the 2017 International Congress on Schizophrenia Research, San Diego, CA.

Zaidman, S., Kurtz, M. (April 2016). Pilot Testing CogSmart: A novel, compensatory program of cognitive remediation for psychosis. Oral presentation and poster presented at 3rd Annual Neuroscience and Behavior Symposium, Wesleyan University, Middletown, CT.

Poster Presentations:

Zaidman, S., Giangrande, E., Berman, K., Dickinson, D. (November 2017). Polygenic Risk in Cognitive Subgroups of Schizophrenia: How does it Relate to Cognition? Poster presented at the Society for Neuroscience 47th annual meeting, Washington, D.C.

Zaidman, S., Deson, J., Berman, K., Dickinson, D. (September, 2017). Personality and Associated Differences in People with Schizophrenia, their Healthy Siblings, and Controls: Analyses of Data from the Tridimensional Personality Questionnaire. Poster presented at the 19th Annual NIMH IRP Fellows’ Annual Scientific Training Day, National Conference Center, Virginia.