Jack Mcdonald Email & Phone Number

Rolling Meadows, Illinois, United States

Huntington, West Virginia, United States

Create new tables and views in Oracle SQL to interpret student data, allowing myself and others easier access to key performance indicatorsUse Power BI to create reports for university administrators, such as enrollment, admissions, and retention dashboardsCreate deployment strategies for Power BI datasets in our workspaces to minimize redundancy, allowing one dataset to refresh 5 reportsSpearheads efforts to convert legacy systems over to Power BI, allowing faster and more customizable access to up to 250,000 usersTeach 5 other employees proper practices to optimize Power BI, such as query folding, by creating training materials and leading meetingsPrepare standardized reports using a linux server to send weekly data to contractors

Advised business on how to improve existing systems, such as implementing proper password and firewall protectionsAutomated several tasks using Python, shortening monthly reports that would take 3 days to complete to taking only 3 hoursImplemented a new TPS accounting system for the business and taught 6 employees how to navigate it

Urbana-Champaign, Illinois Area

Provided support to non‑technical internal users through remote software and communicationEvaluated user problems using test scripts, personal expertise, and probing questionsMaintained network security and integrity through remotely managed firewalls

Urbana-Champaign, Illinois Area

Developed online version of Introduction to Social Psychology course and taught first course.Designed course materials, including syllabi, writing assignments and exams for online and in-class environments.Lectured on Social Psychology to approximately 100 students per semester, both in class and online.

Urbana-Champaign, Illinois Area

Organized and ran day-to-day functions of psychology lab and ensured experiments were being conducted properly and efficiently.Interviewed, hired, supervised, and trained team of 10 research assistants.Performed coding for multiple meta-analytic projects related to health psychology.

Master Of Science - Ms, Social Psychology

Bachelor Of Arts - Ba, Psychology