Curriculum Vitae

Teaching/Research Interests

Applied Computing (R, Stata, Julia, AutoIt, LibreOffice Basic, VBA), Applied Data Science, Literate Programming, Pension Economics

Education

The University of Texas at Dallas

2015 December

  • Master of Science in Economics, 3.704 GPA

  • Graduate Certificate in Economic & Demographic Data Analysis

2014 May

  • Bachelor of Science in Economics

Employment

Data Analyst | Leverage Retirement, Inc.

2020 June - Present

  • Improved efficiency by 86% by employing loops via the AutoIt programming language to condense 7 existing scripts into 1 reduced executable program.

  • Written over 60 AutoIt functions to manage files and vectorize string functions.

  • Developed 6 parameterized Crystal Reports to automate quarterly documents.

Statistical Consultant | Self-employed

2016 January - Present

  • Promoted evidence-based research by writing statistical reports grounded on economic, agricultural, and public health data.

  • Restructured datasets of 10,000+ observations and 100+ variables to ensure the quantitative methods generated valid estimations.

  • Developed programming scripts in R, Stata, and SPSS to facilitate reproducible results for social scientists.

  • Accumulated 300+ hours of tutoring with a 4.9 / 5.0 overall rating on WyzAnt in R, Stata, statistics, and econometrics for regression modeling and data management.

Research Analyst IRO | Collin College

2019 April - 2019 November

  • Automated via R/R Markdown a semesterly report averaging 60+ pages of frequency distribution tables.

  • Written an Argos query and developed R loops to determine the number of contact hours generated by students enrolling after their courses’ census date.

  • Designed a questionnaire of 20+ items in the Snap Surveys software with my supervisor to inquire about communication preferences among Collin College employees.

  • Prepared a slide deck to teach co-workers introductory data management in the R programming language, including importing, aggregating, and recoding data with the tidyverse packages.

Research Analyst | Collin College

2018 January - 2019 April

  • Increased data cleaning efficiency by 67% by creating an R script with 3 custom functions to merge, deduplicate, and correct discrepancies.

  • Refactored existing R code for classroom utilization graphs to reduce the number of scripts from 12 to 3, producing alongside a Power BI equivalent.

  • Extracted via SQL over 1,000 records of students with AP-credited courses in the 2016-2017 academic year for the THECB to comply with H.B. 1992.

  • Constructed an Excel dashboard of tables and comparison charts to report monthly registration headcounts and contact hours by division on continuing education students.

Jr. Business Analyst | HireGenics (Client: J.C. Penney)

2017 April - 2017 August

  • Performed summary computations on 3 years of transactional data with R, SQL, and Datameer to track product-level sales and costs.

  • Assisted in pricing experiment efforts that resulted in a 40% increase in MUNS across 25,000 products, with 33% being the expectation.

  • Analyzed two weeks of hourly conversion rates for 4,000 products to determine the company-wide impact of mid-week and weekend events.

  • Advanced analytical standards by testing the effects of city-level weather conditions on overall e-commerce sales via autoregressive models with distributed lags.

Analyst | Schnitman & Associates, Inc.

2007 September - 2015 June

  • Executed money transfers and disbursement requests according to the client’s 401(k) plan with Schwab Retirement Technologies®. Evaluated cash flows to check sufficiency of reserved funds. Performed daily cash reconciliation.

  • Served as an editor of distribution request forms, Plan Specifications, and participant statements to ensure consistency and increase readability.

  • Maintained participant information for record-keeping purposes.

  • Assisted CEO in treasury functions by tracking revenues and expenses.

  • Trained new employees to process money transfers, complete distribution requests, and conduct the daily operations of the firm.

Software

  1. 2022 Schnitman, R. XLops: Utility functions for Excel/VBA. https://github.com/robertschnitman/XLops

  2. 2022 Schnitman, R. LBops: Utility functions for LibreOffice Basic/Calc. https://github.com/robertschnitman/LBops

  3. 2020 Schnitman, R. AutoOps: AutoIt utility functions. https://github.com/robertschnitman/AutoOps

  4. 2020 Schnitman, R. RubyOps: Ruby utility functions. https://github.com/robertschnitman/RubyOps

  5. 2020 Schnitman, R. stringops: String-processing tools and synonyms for R. https://github.com/robertschnitman/stringops

  6. 2020 Schnitman, R. dm: Data management tools for R as inspired by Stata, SPSS, and other software. https://github.com/robertschnitman/dm

  7. 2020 Schnitman, R. Price Analysis of Select Funds, 2007-2019. https://robertschnitman.shinyapps.io/funds

  8. 2019 Schnitman, R. Scatterplots with the Gapminder Dataset. https://robertschnitman.shinyapps.io/scatter

  9. 2018 Schnitman, R. afpj: Applied Functional Programming in Julia. https://github.com/robertschnitman/afpj

  10. 2018 Schnitman, R. afp: Applied Functional Programming. https://github.com/robertschnitman/afp

  11. 2018 Schnitman, R. diagnoserjl: Residual Diagnostic Tools for Julia. https://github.com/robertschnitman/diagnoserjl

  12. 2017 Schnitman, R. diagnoser: Residual Diagnostic Tools. https://github.com/robertschnitman/diagnoser

Acknowledgment

  1. 2016 Arocha, D. Characteristics of Adult ICU Patients with Device Associated Nosocomial Infections. Walden University.

Publications

  1. 2020 Schnitman, R. stringops: String-processing Tools for R. https://stringops.netlify.app/

  2. 2020 Schnitman, R. Handbook for the dm R Package. https://dm-rs.netlify.app/

  3. 2020 Schnitman, R. A Short Introduction to Applied Statistical Programming in R. https://aspr.netlify.app/

  4. 2020 Schnitman, R. Handbook for the diagnoser R Package. https://diagnoser.netlify.app/

  5. 2020 Schnitman, R. Data Science and Beyblades. https://robertschnitman.netlify.app/2020/03/25/data-science-and-beyblades

  6. 2020 Schnitman, R. The Narrator and the Noise: The Use of Statistical Bias in a Minigame to Emphasize a Thematic Outcome in Act 1 of Doki Doki Literature Club. https://ddlc-nn.netlify.app

  7. 2020 Schnitman, R. Using the R Programming Language to Report the Sachse, TX January 2020 Special Election Pre-runoff Results. https://sachse2020-rs.netlify.app/

  8. 2020 Schnitman, R. Handbook for the afp R Package. https://afpr.netlify.app/

  9. 2020 Schnitman, R. OLS in R Tutorial. GitHub. https://github.com/robertschnitman/Reports/blob/master/Tutorials/R%20OLS%20Tutorial.pdf

  10. 2019 Schnitman, R. TukeyHSD in R Tutorial. GitHub. https://github.com/robertschnitman/Reports/blob/master/Tutorials/R%20TukeyHSD%20Tutorial.pdf

  11. 2015 Schnitman, R. International Confidence and Retiree Welfare: Effects of Foreign Direct Investment in the United States on Pension and Social Insurance Contributions. Academia.edu. https://www.academia.edu/19789042/International_Confidence_and_Retiree_Welfare_Effects_of_Foreign_Direct_Investment_in_the_United_States_on_Pension_and_Social_Insurance_Contributions

  12. 2015 Schnitman, R. Incentivizing Labor Productivity through Pension Contributions: A Time-Series Approach with Annual Data, 1929-2014. Academia.edu. https://www.academia.edu/19789101/Incentivizing_Labor_Productivity_through_Pension_Contributions_A_Time-Series_Approach_with_Annual_Data_1929-2014

  13. 2015 Schnitman, R. The Effects of Employer Contributions on the Labor Force Participation Rate over Time. Academia.edu. https://www.academia.edu/12373461/The_Effects_of_Employer_Contributions_on_the_Labor_Force_Participation_Rate_in_the_United_States_over_Time

  14. 2015 Schnitman, R. Pension Portfolio Preferences since the Great Recession. Academia.edu. https://www.academia.edu/12373438/Pension_Portfolio_Preferences_since_the_Great_Recession

  15. 2014 Schnitman, R. An SEM Approach to Examine the Effects of Defined Contribution Plans and Socioeconomic Status on Portfolio Preferences. Academia.edu. https://www.academia.edu/10519927/An_SEM_Approach_to_Examine_the_Effects_of_Defined_Contribution_Plans_and_Socioeconomic_Status_on_Portfolio_Preferences

  16. 2013 Schnitman, R. Effects of Education, Health Behavior, and Media Consumption on Cigarette Demand. Academia.edu. https://www.academia.edu/5826780/Effects_of_Education_Health_Behavior_and_Media_Consumption_on_Cigarette_Demand

  17. 2012 Schnitman, R. Cluster Analysis on the Effects of US Family Income and Human Capital on Bond-and Stock-allocation under Pension Restrictions in 1992. Academia.edu. https://www.academia.edu/5826779/Cluster_Analysis_on_the_Effects_of_US_Family_Income_and_Human_Capital_on_Bond-and_Stock-allocation_under_Pension_Restrictions_in_1992

  18. 2011 Schnitman, R. Ignoratio Elenchi: Faith and Reason in Robert Louis Stevenson’s Dr. Jekyll and Mr. Hyde. Academia.edu. https://www.academia.edu/41688127/Ignoratio_Elenchi_Faith_and_Reason_in_Robert_Louis_Stevensons_Dr._Jekyll_and_Mr._Hyde

Organizations

  1. 2017-2022 American Economic Association, Member

  2. 2015-2015 Consulting Club, University of Texas at Dallas, Member

  3. 2013-2015 Delta Epsilon Iota Academic Honor Society, Member

  4. 2013-2015 Omicron Delta Epsilon, Member

Honors and Awards

  1. 2020-2020 Retirement Plan Fundamentals Certificate Course (Credential ID 54135451), ARA Education

  2. 2017-2017 Certificate of Completion: Ruby (Credential ID 1081-2617798), SoloLearn

  3. 2017-2017 Certificate of Completion: Python 3 (Credential ID 1073-2617798), SoloLearn

  4. 2016-2016 Certificate of Completion: SQL Fundamentals (Credential ID 1060-2617798), SoloLearn

  5. 2014-2015 Fast-track status, EPPS, the University of Texas at Dallas

  6. 2011-2012 Merit Scholarship, Cairn University (Formerly Philadelphia Biblical University)

  7. 2011-2011 Dean’s List, Collin College