Jeff M. Dorsey
Arlington, TX ***01
***********@*****.***
210-***-**** (cell)
EDUCATION
• Baylor University, Waco TX, BBA, Double Major: Finance and Management PROFESSIONAL EXPERIENCE
Labatt Food Service, San Antonio, TX August 2013-June 2015 Regional food distribution company supplying product across five states and over $1 billion in sales. Vendor Rebate Analyst
• Tracked rebate programs for over 200 vendors and reconciled payments from vendors
• Used query database to pull Labatt purchases and analyze differences with actual vendor payments utilizing Excel through VLOOKUP and pivot table tools
• Researched and resolved account discrepancies to collect missed or past due payments
• Communicated with vendors and senior management for new product rebate rates and program changes
• Maintained database system by entering and verifying item rates
• Forecasted total annual value changes for individual vendor programs by running simulations comparing potential new item rates with the current item rates
• Drafted contracts for new or updated rebate programs
• Responsible for updating managers each period with current balances for each vendor’s marketing fund
• Constructed the budget for the annual Spring Promotion AXA Advisors, San Antonio, TX Summer 2012
Wealth management company offering advice for retirement strategies. Intern
• Created Excel spreadsheet to manage/track monthly client contributions and account balances UNIVERSITY AND COMMUMITY LEADERSHIP
Baylor University Student Foundation
Student organization dedicated to raising scholarship funds for current students Alumni Relations Co-Chair
• Member of Student Foundation team raising $250,000 in scholarships
• Received Alumni Relations “Member of the Year” award Eagle Scout, Boy Scouts of America
TECHNICAL SKILLS
• Proficient in Microsoft Word, PowerPoint, Excel and Access
• Use of pivot tables and VLOOKUP within Excel
• Familiar using AS400 system