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.Written over 30 VBA subroutines and functions to assist verifying the data-quality of clients' submitted payrolls.Developed 6 parameterized Crystal Reports to automate quarterly documents.

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 produced 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 rating on WyzAnt in R, Stata, statistics, and econometrics for… Show more 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 produced 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 rating on WyzAnt in R, Stata, statistics, and econometrics for regression modeling and data management. Show less

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… Show more 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. Show less

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 it 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… Show more 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 it 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. Show less

Transformed and 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.Prepared technical document on testing the effects of… Show more Transformed and 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.Prepared technical document on testing the effects of city-level weather conditions on overall e-commerce sales via autoregression models with distributed lags. Show less

Verified and executed money transfers and disbursement requests as 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… Show more Verified and executed money transfers and disbursement requests as 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.Acted as a consultant to clients regarding validation of distribution processes and money transfers.Trained new employees to process money transfers, complete distribution requests, and conduct the daily operations of the firm. Taught new employees the reasoning and importance behind these procedures. Show less