Sales Manager

*** ********* ***** *******, ** *****

203-***-**** . *****@*********.***

Andrew c. PANK

Objective

To obtain a position within a company that will enable me to utilize

and further my analytical and resource-management skills, as well as

present a new challenge with additional responsibilities.

Work experience

Futurity First Insurance Group - February 2009 - Present

Manager - Financial Reporting

Responsibilities Include

Microsoft Access database creation and maintenance

Created/supported 15+ databases for :

Daily/Weekly/Monthly/Ad Hoc production/staffing reporting for

Senior Management/investors/Filed Offices

Forecasting revenue and commission expense

Field Office result reporting

Department budget reporting

Marketing campaign assessments

Calculation of 150+ Sales Agents compensation and bonuses

Bonus modeling for Sales Management

Automation of manual processes

Tracking day-to-day departmental work

Daily/Weekly/Monthly/Ad Hoc Reporting using Microsoft Excel

Provide support for Senior Management and the Finance, New

Business, Product and

Marketing Departments

United Healthcare/Oxford Health Plans - June 1996-February 2009

Broker Commissions Manager (Financial Operations)

February 2003- February 2009

Responsibilities Included:

Manage staff of 12

Microsoft Access database creation and maintenance

Created/supported 50+ databases for :

Automation of manual processes

Tracking day-to-day departmental work

Broker correspondence creation

Monthly reporting for Senior Management

Calculation of 100+ internal Sales staff compensation

Calculation of broker bonuses resulting in $2 million+ payouts

Bonus modeling for Sales Management

Departmental Metric Report

Ad hoc reporting

Created\supported 10+ databases for multiple departments

Created training plan and conducted classes in Microsoft Access

for multiple departments

Monthly reporting using Microsoft Excel

Created training plan and conducted classes in Microsoft Access

for multiple departments

Monthly payments of $20 million to 8,500 brokers

Process improvements to increase accuracy and efficiency

Operated and oversaw a service phone queue that received

1,000+calls/month

Appointment of brokers to enable them to sell the company's

health products

Ensure compliance with various states' laws

Conduct staff meetings

Interviewing and hiring of staff

Monthly/yearly reviews of staff

Coaching and counseling of staff

Handling of escalated issues

Collections Team Leader (Financial Operations)

November 2000-January 2003

Responsibilities Included:

Manage staff of 20

Microsoft Access database creation and maintenance

Automated manual processes

Tracked department's work

Reduction of outstanding accounts receivable on 65,000+ accounts

Zero 90+ day balance when I left the department

Monthly reporting for Senior Management

Ad hoc reporting

Operate and oversee a service phone queue that received 9,000+

calls/month

Recovery of bad debt

Handling of escalated issues

Process improvement

Oversee monthly processes

Head transition of collections process of acquired companies

Conduct staff meetings

Interviewing and hiring of staff

Monthly/yearly reviews of staff

Coaching and counseling of staff

Senior Collections Representative (Financial Operations)

November 1998-October 2000

Responsibilities Included:

Supervise team of three

Reduction of outstanding accounts receivable

Monthly reviews

Handling collections on larger clients

Preparing correspondence to businesses

Creating and monitoring payment plans for clients

Monthly reporting for Senior Management

Testing of system enhancements

Process enhancements

Collections Representative (Financial Operations)

January 1997-October 1998

Responsibilities Included:

Reduction of outstanding accounts receivable

Educating clients of payment policies

Preparing financial reconciliations for review by accounts

Preparing correspondence to businesses

Creating and monitoring payment plans for accounts

Testing of system enhancements

Accounts Receivable Associate (Financial Operations)

June 1996-December 1996

Responsibilities Included:

Preparing and entering of checks to group and individual

accounts

Processing corrections to client accounts

Verifying customer check requests for payment

Education

September 1991 - May 1995 Franklin & Marshall College: Lancaster,

PA

B.A. - Music

Computer Skills

Proficient in VBA, Macros, formulas, reporting and charts for MS Access

Proficient in VBA, Macros, formulas, reporting,charts, Pivot Tables for

MS Excellent

Excellent MS Word skills including mail merge capabilities

PowerPoint

Business Object

SQL

References available upon request

Contact this candidate