- Used Python’s selenium library to scrape internal websites to extract, rename and send monthly payroll reports to appropriate directories- Used Python (pandas, numpy) to manipulate payment reports into accounting entries, then created an EXE file with the code and integrated it into VBA to make a user-friendly application- Analyzed the group annuity population (25K+ members) using relevant factors (age, location, etc.) to determine if audit letters needed to be sent to them

- Transformed and cleaned athletes’ data in SAS using DATA step programming, SAS SQL queries, and macros developed to streamline calculations- Used R and SAS to help develop a benchmarking methodology in order to model future athlete performance using statistically significant metrics- Built interactive dashboards in Tableau using the benchmarking methodology, allowing NSOs (National Sports Organizations) to make informed decisions about their athletes- Took full responsibility of… Show more - Transformed and cleaned athletes’ data in SAS using DATA step programming, SAS SQL queries, and macros developed to streamline calculations- Used R and SAS to help develop a benchmarking methodology in order to model future athlete performance using statistically significant metrics- Built interactive dashboards in Tableau using the benchmarking methodology, allowing NSOs (National Sports Organizations) to make informed decisions about their athletes- Took full responsibility of all update calls with NSOs during the term, developing professional speaking skills and learning how to create engaging presentations Show less

- Cleaned client data files with macros developed in Excel’s VBA, which automated the process of validating and comparing data- Completed data reporting by creating visually impactful dashboards monthly with Excel’s Power Query, using arrays, pivot tables and VLOOKUP to transform data into meaningful and actionable information that guided management decisions- Took on a leadership role by onboarding 2 new co-op students, and developed documentation of employee duties to facilitate… Show more - Cleaned client data files with macros developed in Excel’s VBA, which automated the process of validating and comparing data- Completed data reporting by creating visually impactful dashboards monthly with Excel’s Power Query, using arrays, pivot tables and VLOOKUP to transform data into meaningful and actionable information that guided management decisions- Took on a leadership role by onboarding 2 new co-op students, and developed documentation of employee duties to facilitate training for future team members Show less

- Provided instruction in the Arduino and Python languages, CAD (computer-aided design), and other STEM principles to 15 middle school students once a week- Effectively communicated content by individualizing lessons according to students’ interests, strengths, and needs, and using critical thinking to troubleshoot technical difficulties- Collaborated with coworkers to develop ideas that would further advance the program