Rotation III: Credit Loss Forecasting - Card (CECL)Rotation II: Quality Assurance Risk-Home Lending• Streamlined production time of weekly reports by 90% utilizing Visual Basic (VBA) to create a macro that quickly generates weekly and monthly reports in a user-friendly format• Leveraged Excel, Tableau and Access to create daily and weekly efficiency report of the QA team• Implemented the use of pivot tables, vlookups, if statements and other advanced Excel techniques to streamline various processesRotation I: CCB Treasury – Financial Deposit Modeling & Analytics• Utilized Excel to create pivot tables and analyze forecasted results of $1 Trillion+ deposits in various stressed scenarios to help identify the financial health of the consumer and business bank• Collaborated across multiple finance teams to accurately program the statistical models for firm-wide use• Identified and corrected potential in our forecast scenarios by running detailed financial analyses of forecasted results and collaborating with team members regarding the best corrective course of action

• Researched and analyzed various methods of assisting clients in their efforts to reduce tax liability• Analyzed client financial statements to best understand which tax laws would be applicable in reducing tax liability• Demonstrated a client-focused attitude by identifying the best options for the clientele regarding their taxes and by consistently delivering their return well before the communicated deadline• Effectively communicated with management with regards to client information and status of tax returns

• Advised BYU-I students on the entire job/internship application process,including helping them with cover letters, resumes, and interviews• One on one interaction with the students, seeking to understand their career goals and needs in an effort to optimize their application materials

• Assisted the professor with grading of Excel projects and offered feedback to the students

• Led efforts on analyzing all accounting and finance processes with the intention of identifying and capitalizing on opportunities to increase efficiency and enhance processes• Increased efficiency and reduced reporting times for the payables manager by using Visual Basic to reprogram an Excel workbook to automate the tedious process• Collaborated effectively with finance employees to better understand their roles and processes; reported my findings directly to the CFO, CEO and consultant in an effort to find solutions

• Assisted the Chief Financial Officer in analyzing the financial performance of city-owned entities and making business suggestions relating to their performance• Managed the pricing, budgeting and forecasting analysis for the major city recreation entities• Audited the cash and credit accounts for the recreation entities and utilized my findings to suggest and implement more effective policies and procedures regarding the handling of cash and payments

Managed and oversaw the set up, take down, and use of interactive entertainment attractions at county fairs and university events. Hard work and management skills were key in this job. It often involved 12-16 hour days of manual labor, problem solving, and managing teams of volunteers and co-workers.

As Assistant Manager I helped manage the restaurant's inventory, resolve customer issues, and manage other employees. Managing many of the aspects of the restaurant took management, interpersonal, and problem solving skills.