Jonathan C. Email & Phone Number

United States

Denver County, Colorado, United States

Denver County, Colorado, United States

Denver, Colorado

Creating macros and extremely sophisticated spreadsheets in Excel to automatically run everyday business processes to help minimize staff and efficiently run day to day needs.

Downtown Denver

• Assist graduate students with obtaining their financial aid. Ensuring all needed documents are received and acceptable by the deadline.
• Assist current students with questions regarding their financial aid and account information. Recovered documents needed in order to continue obtaining federal student loans.
• Trained a team of upper management in Excel, including efficient use, functions, PivotTables, and more.
• Updated numerous spreadsheets for various departments to increase efficiency.
• Nominated for Employee of the Quarter for Quarter 3 and Quarter 4 of 2016

Denver, CO

• Claims Processor II, 2014 – 2016Examining default, disability, death and bankruptcy claims and determine whether the claim is payable or not based on guidelines provided by the Department of Education.
• Consistently exceeded the goals set for the department of 4 files per hour, averaging 6.3 files per hour, all while designing and implementing several spreadsheets to increase productivity and improve efficiency.
• Took the initiative to train coworkers in Excel, including beginner and intermediate classes. Such classes included: navigation, Excel efficiency, charts, tables, most commonly used functions, PivotTables, Pivot.
• Addressed an issue in statistical tracking by utilizing Excel to automate the process.
• Reduced turnover time for paying/rejecting claims with consistency and accuracy.
• Reduced paper waste by creating a Macro in Microsoft Word to automatically delete unneeded pages. Advisor II, 2012 – 2014Educated customers in understanding their options for student loan repayment and to responsibly.

Denver, CO

• Assisted new students through the entire enrollment process, from admissions to financial aid to entrance testing.
• Nominated for employee of the year through the Colorado Association of Career Colleges in 2011.
• The New Student Coordinator position was created based on my skill sets and talents shown in the Financial Aid and Student Services departments.
• Created numerous spreadsheets to increase efficiency including a spreadsheet that can calculate all tuition costs, expenses, etc. based on the student’s degree and financial aid award.

Managerial duties included, but were not limited to: customer services, daily deposits, inventory control, cash handling, hiring/disciplining employees, balancing safe, pharmaceutical technician, loss prevention.