Manager Sales
Resume:
RUSSELL KELSALL
**** *. ***** ***** **** ( Phoenix, AZ 85008-3113 602-***-**** (
******@***.***
Gannett
Dear Human Resources:
I am writing to express my interest in the open Business Sales Analyst
position.
We just finished the budget cycle and my project work as a temporary Budget
Analyst at Paradise Valley Community College is completed.
Please find a copy of my resume, references, and letter(s) of
recommendation.
I am a Microsoft Certified Application Specialist for Excel and Access.
Formerly these certifications were known as Microsoft Office Specialist -
Expert.
In my position as Principal Budget Analyst, I worked with Vice-Presidents,
Deans, Department Chairs and Charge Center Managers to develop their Fund 2
budgets for FY10-11. This work made a positive impact on the college as a
whole. Stimulating many conversations between the different levels of the
college and initiated a greater understanding of each budget manager's
budget.
I developed a process for collection of requests for new, increased or
decreased course fee information. I updated the course fee request in the
Budget Development System (BDS). These requests were then presented to the
Governing Board.
I developed a Multi-Year Financial Plan and Projection spreadsheet that
considers the impact of enrollment growth, budget cuts, and tuition
increases.
Additionally, I developed ad hoc reports as required by various parties
within the organization using the College Financial System (CFS), Oracle
Web Financials, Discover 2000 NT (Browsers 2.0), the Budget Development
System (BDS) and the Automated Planning & Budgeting System (APB).
In my previous work as an Accounting Analyst at the New Song Center I did
all of the monthly reporting and analysis. Unfortunately, income was down
and the New Song Center reduced its staff in response. The good news is
that the Executive Director will be an excellent reference. (See the last
page for Letter of Recommendation.)
When I was in college I worked as the Computer Lab Manager at the Eberhardt
School of Business. I managed six computer lab assistants, taught computer
introduction classes, and instructed students one-on-one on computer and
application usage. Since that experience, I have maintained a superior
knowledge of several computer applications.
After graduating from the Eberhardt School of Business at the University of
the Pacific with a finance degree, I took a Marketing Manager / Office
Manager position at a Law Office. While at the Law Office I planned and
implemented marketing to bring in new clients for Estate Planning seminars.
This included producing booklets, brochures, and advertisements (Radio &
Newspaper) to support the monthly seminars. I was able to obtain the City
of Phoenix as a client for their retirement seminars. I also managed
office personnel and was responsible for major procurement decisions.
Through my work I was able to double income through process improvements
and cost reductions.
Since working at the Law Office I think that my most important work
experience comes from starting and managing an importing company called
Zepter Sports International for seven years. One area where my education
helped was in performing the accounting and finance functions for the
company. My work as the Operations Manager included forecasting and
performing cost accounting for each product and potential project. I also
created budgets comparing actual to budget on a regular basis.
Additionally, my work involved issuing Letter of Credits to foreign
suppliers and various domestic and international banking transactions.
At Zepter Sports, I worked independently and successfully managed multiple
large projects on a continuous basis. I have many years experience working
in a variety of groups as the group leader and also as a supporting group
member. Many of these projects went from initial conception to completion.
I am also a good writer and have the unique experience of writing for an
audience consisting of non-native speakers. This experience has taught me
to think about each word I write and to choose words carefully to concisely
convey the intended message. I have learned to be a much better
communicator.
My past business experience translates into a better understanding of
future finance projects and will allow me to better convey financial
information to the managing executives.
I have intermediate to advanced skill in Microsoft Office 2007 Suite of
products. Furthermore, my computer skills have always been advanced and I
have always learned new applications quickly.
Please call me at 602-***-**** with any additional questions.
Sincerely,
Russell Kelsall
RUSSELL KELSALL
4030 E. Monte Vista Road ( Phoenix, AZ 85008-3113 602-***-**** (
******@***.***
OBJECTIVE
Obtain a position as Financial Analyst - Business Decision Support.
EDUCATION
University of the Pacific
Eberhardt School of Business (AACSB accredited)
School of Business and Public Administration
Bachelor of Science - Business Administration - Concentration in Finance
(Finance Degree)
Austro-American Institute - Vienna, Austria University of Innsbruck
- Innsbruck, Austria
EMPLOYMENT HISTORY
Paradise Valley Community College, Principal Budget Analyst
November 2009 to March 2010
Phoenix, Arizona Temporary position
Worked with Vice-Presidents, Deans, Department Chairs and Charge Center
Managers to develop their budgets for FY10-11.
Developed Multi-Year Financial Plan and Projection. Comparison of FTSE
trends vs. Actual Expenses.
Growth of Actual Indirect Expenses by Function.
Comparison of Actual Expenses by Function and Enrollment
Developed monthly reporting and analysis. Developed ad hoc reports as
required by various parties within the organization using all available
systems.
Met with College Financial Planning Advisory Committee on regular basis.
The committee discussed methodologies for addressing the structural
deficit, and guiding principles for use of fund balances.
Developed process for collection of requests for new or increased course
fee information. Updated course fee request in the Budget Development
System (BDS); for presentation to the Governing Board.
New Song Center, Accounting Analyst April 2008 to December 2008
Scottsdale, Arizona
- Create, analyze, and communicate reports measuring actual performance of
revenue and expense to budget.
- Identify budgetary issues; ensure accuracy and integrity of data.
- Work daily with Executive Director. . Present to Treasurer & Finance
Committee regularly.
- Created Projected Budget, Administration Budget, Fund Raising Budget, and
Programs Budget in Excel.
- Prepare Profit & Loss: Month to Date Budget vs. Actual, Previous Year
Comparison in Excel.
- Prepare Profit & Loss: Year to Date Budget vs. Actual, Previous Year
Comparison in Excel.
- Prepare Balance Sheet, Previous Year Comparison in Excel.
- Monthly close. . Reconciliation of Bank Account.
- Explain variance(s) on reports such as Profit & Loss.
- Invoicing of government contract in Excel.
- Prepared for audit of 2007 records, worked with auditor during field
work.
- Improved credit card billing efficiency by setting up automatic
reoccurring billing.
- Increased efficiency by integrating credit card processing with
accounting software.
- Negotiated better credit card rates. . Increased the number payment
options available.
- Implemented invoicing procedure.
- Improved efficiency of reporting through process improvements and better
accounting software utilization.
Arizona Agritainment, Accounting Analyst September 2003 to January 2008
Gilbert, Arizona
Prepare reports, explain variance(s) on Profit & Loss (similar to work at
New Song Center)
Cost Accounting for children's discovery farm activities and crops.
Sales and profitability reporting by product. Recommendations based on
findings.
Calculated ratios with goal seek in Excel.
High volume daily and monthly reconciliation of bank account September to
December.
Daily sales reporting September to December.
Resolution of reconciliation balance issues.
Press releases to media outlets.
Responded to media request.
Zepter Sports International, Operations Manager January
1993 to January 2000
San Diego, California
- Company specialized in manufacturing sports related bags.
- Performed company accounting and finance functions.
- Profit & Loss, Balance Sheet (similar to work at New Song Center)
- Cost Accounting, Pricing, Budgeting & Forecasting.
- Design and development of prototypes, price and terms negotiations,
importation of products.
- Design and development of marketing materials to support sales.
- Planned and exhibited at two large sporting goods trade shows every year.
- Product sales to sporting goods chains, discount retailers, and large
sporting goods companies.
ADDITIONAL INFORMATION
Mesa Community College, Adjunct Faculty
Department of Business & Information Systems
Mesa, Arizona
- Teaching Excel.
- Computer spreadsheet skills for solving business problems using Excel,
including calculations using formulas and functions, forecasting,
projections, macro programming, database searching, extraction, linking,
statistics, and matrix manipulation. Production of graphs, charts, and
reports. Project design using multiple, integrated spreadsheets,
formatting workbooks, developing an Excel application, financial
analysis, connecting to external data, automating a spreadsheet via
macros and Visual Basic for Applications (VBA) programming code.
- HLOOKUP, VLOOKUP, IF, SUMIF, Conditional Formatting, Conditional
Statements, Macros, Tables, Pivot Tables and Pivot Charts.
- Microsoft Certified Application Specialist - Excel
- Microsoft Certified Application Specialist - Access
- College Financial System (CFS), Oracle Web Financials, Discover 2000 NT
(Browsers 2.0), Budget Development System (BDS), Automated Planning &
Budgeting System (APB), Novell Network, Oracle Collaboration Suite
Calendar, and Zimbra Collaboration Suite.
- BASIC, Pacific Programming Language (PPL)
- VBA & SQL in Access and VBA in Excel.
- Microsoft Office 2007 (Excel, Access, PowerPoint, Word, and Outlook)
Windows XP, Internet Explorer, Firefox, Thunderbird, WordPerfect,
QuickBooks Pro, ACT.
- Delta Sigma Pi Fraternity
- USA Hockey registered referee
RUSSELL KELSALL
4030 E. Monte Vista Road ( Phoenix, AZ 85008-3113 602-***-**** (
******@***.***
References
Larry Fields
Special Projects (former Director of College Business Services)
College Business Office
Paradise Valley Community College
18401 N. 32nd Street
Phoenix, AZ 85032
Relationship: Co-worker
Sandy McDill
Director College Business Services
V.P. Administrative Services
Paradise Valley Community College
18401 N. 32nd Street
Phoenix, AZ 85032
Relationship: Supervisor
Lisa Schmitt
Executive Director
New Song Center
6947 East McDonald Drive
Scottsdale, AZ 85253
602-***-**** (Cell)
Relationship: Supervisor
Speros Pavlatos
Senior Director of Worldwide Field Sales Operations
Force10 Networks, Inc.
517 Cedar Street
San Carlos, CA 94070
408-***-**** (Cell)
Relationship: Former Employee at Zepter Sports International
Bill Melvin
Attorney
Maricopa County Public Defender's Office
3332 N. 24th Place
Phoenix, AZ 85016
Relationship: Friend
Art Flores
Owner
Admiral Printers
377 First Avenue
Chula Vista, CA 91910
619-***-**** (Cell)
Relationship: Vendor for Zepter Sports International
[pic]
Date: December 16, 2008
To: Whom it May Concern
From: Lisa Schmitt, Executive Director
RE: Russell Kelsall
This letter is to recommend Russell Kelsall as an excellent Accounting
Analyst. I hired Russell in the spring of 2008 to provide structure and
protocols in our accounting department. He immediately stepped into his
work needing very little direction and guidance. He took initiative and
worked independently, seeking out direction and guidance as needed and
quickly grasping the scope of work.
He maintains a high level of attention to detail and has the ability to
work effectively in an open environment that was occasionally crowded and
noisy with other workers and volunteers. He demonstrated the ability to
make good and timely decisions without overstepping his level of authority.
He was willing to make suggestions that would enhance the work environment
and improve outcomes.
Russell also worked well within the existing culture of the staff. He
demonstrated an ability to work effectively with all members of the staff,
being willing to take on whatever responsibilities that were needed. His
behavior at work was always professional and he was willing to "go the
extra mile" whenever asked.
I highly recommend Russell as a knowledgeable and professional colleague
and would be willing to hire him again in the future.
Sincerely,
Lisa Schmitt
Executive Director
New Song Center for Grieving Children
Contact this candidate