Brett A. Ferringer
1418 Pennsylvania Ave Natrona Heights, PA 15065
Email:
Website: www.brettferringer.com
Mobile: (814) 538-0306
Mission Statement
Highly motivated leader who excels in a fast-paced environment. Dedicated, trusted, and detail oriented employee who loves working with excel and other data analysis software. Currently seeking analyst opportunity that allows for career and personal growth.
Education
Clarion University of Pennsylvania, Clarion, PA
Bachelor of Science in Business Administration, AACSB International Accredited, May 2014
Dual Major: Business Management, Human Resources
Minor: Marketing
GPA: 3.2/4.0
Professional Experience
OneMain Financial
Personal Loan Specialist
September 2017-Present
● Develops and presents contracts for personal loans, automobile loans and other credit related products
● Assists customers in making financial decisions to help them achieve their financial goals
● Educates customers on the terms and conditions of the loan to ensure a clear understanding
● Creates analysis tools in excel as needed
● Created projection tool in excel that predicted how well the branch will perform if certain events took place
● Works as an individual contributor and as part of the team to achieve business guidelines and procedures
#1 Cochran
Sales Consultant
February 2017-September 2017
● Processed loan documents to ensure the bank's underwriter receives the correct documentation for contracting
● Studied and researches vehicle underwriting standards to ensure compliance with state and federal laws
● Created Finance Log in excel that manipulated data to analyze customer’s and banks financial data
● Used customer survey analysis to determine customer satisfaction
DriveTime
Senior Sales Advisor, ALP
June 2014-February 2017
● Analyzed financial statements/credit information to provide recommendations for the funding of new loans
● Prepared and delivered contracts for vehicle loans
● Produced automated data analysis tools in excel that upper management used to make key decisions
● Audited underwriting paperwork to ensure compliance and accuracy
● Created dashboards in excel that evaluated employee, department, and branch performance
● Kept excel logs to ensure accuracy in case of internal and external audits
Projects
● Uncashed app log reporting to analyze employee performance (Excel)
o Formulas used: if, sumif, countif, pivot tables, macros
● Daily recap to analyze daily/monthly store performance (Excel)
o Formulas used: vlookup, sum, macros
● Regression analysis of applications to sale visualization (Excel)
o Used regression analysis function
● Website to analyze personal performance (SQL)
● Forecasting and comparative analysis of the S&P 500 index in relation to the US unemployment rate (Tableau)
● Projection Tool (Excel)
o Formulas Used: sumif, date, macros
Software Skills
· Microsoft Excel
o Vlookup, hlookup, macros, pivot tables, countif, sumif, pmt, index, trim, etc
· SQL
o Select, order by, join, insert, update, delete, create database, create table, etc
· Tableau
· Google Charts
· Microsoft Access