Sales Administrative Assistant

TERRI L. LANCASTER

**** ********* ****, *********, ******** 80116

Phone: 303-***-**** Email:

*****.*********@*****.***

SUMMARY OF QUALIFICATIONS

Competent, professional Administrative Assistant with over 15

years' office experience supporting all levels of management.

. Proficient in Microsoft Office Suite including Outlook, Word,

Excel, PowerPoint and Access as well as SharePoint and Adobe

Writer.

. Extensive knowledge and experience creating, validating and

distributing reports using Access databases and Excel pivot

tables.

. Experience with accounts payable, accounts receivable and

accounting reports using Appgen accounting software as well as

payroll submission and 401K deductions and account maintenance.

. Excellent written and verbal communication.

WORK EXPERIENCE

Westwood College, Inc., Denver, CO

5/2007 - 5/2011

Admissions Operations Data Analyst - Provided data collection,

analysis and reporting for the Admissions Operations and Training

departments of a large private college.

. Created daily, weekly, monthly and term lead and application

reports for Admissions Teams and all levels of management for

lead conversion and productivity analysis.

. Coordinated with the Directors of Admissions, Area Vice

Presidents and Human Resources to obtain accurate new hire

and termination data for Admissions Representatives and

entered this data into the Campus Management data tables.

. Increased the accuracy and efficiency of key databases used

for manpower, tenure and turnover analysis reporting via ad

hoc requests and weekly and monthly reporting.

. Maintained an Access database to create reports for Training

course evaluation.

Nestl USA, Englewood, CO

11/2001 - 4/2007

Systems & Data Analyst, FoodServices Division - Developed and

maintained Access databases for collecting, cleansing and reporting

of On-Site sales data and the creation of quarterly and ad hoc

reports for all levels of management via Excel pivot tables.

Programmer-Sales System Support, Prepared Foods Division -

Responsible for the design, modification and validation of Daily

and Period End reports for both the Retail and FoodServices sales

organizations.

. Received the Nestle' Very Best Spirit Award for the Prepared

Foods' Supply Chain Consolidation Project. This involved

mapping 2,800 customer accounts into SAP.

. Created programs in Progress to extract data and imported this

data into complex Access databases to create user-friendly

reports for the Sales, Marketing, Finance, Customer Service and

Inventory Departments.

. Developed and managed daily data feeds for the Glendale Retail

Sales and Foodservices Sales Divisions.

. Updated and processed SQL OLAP Cubes with current sales data

monthly.

TERRI L. LANCASTER

Page 2

Phone: 303-***-****

*****.*********@*****.***

WORK EXPERIENCE - Continued

Programmer-Sales System Support, Prepared Foods Division

(Continued)

. Created a broker extranet for publishing sales data to the

broker community.

. Responsible for the security access, plan and fund maintenance,

system support and monthly and ad hoc reporting for the Account

Review trade spending program.

. Trained and supported administrative assistant on creating and

distributing monthly sales' reports to all departments.

Comeg USA, Aurora, CO

10/1997 - 10/2001

MIS Specialist - Responsible for all administrative processes for a

medical instrument sales and repair facility.

. Developed and maintained Access databases to integrate data

between the Sales, Accounting, Quality Control and Repair

Departments.

. Responsible for creating reports as requested by management

and customers.

. Compiled and submitted payroll and 401K data.

. Responsible for accounts payable, accounts receivable and

monthly financial reports using Appgen Accounting Software.

. Maintained all computer systems including network

administration, Internet connections and Appgen Accounting

Software.

. Ordered all office and shipping supplies.

Roller Hockey International, Parker, CO

1/1994 - 1/1997

Administrative Assistant - Part-time position consisting of word

processing, spreadsheets, database design and implementation,

bookkeeping, payroll, and general office duties.

TECHNICAL SKILLS

Microsoft Office (Advanced skills including Outlook, Word, Excel,

and Access), SharePoint, SRM and CampusVue Campus Management

Software, Proclarity Analytics data cube software and Business

Objects 5.1.

EDUCATION

New Horizons Computer Learning, Englewood, CO

Sept. 2000

Completed Advanced Microsoft Access Course

Red Rocks Community College, Lakewood, CO

1990 - 1995

Associate of Applied Science, Microcomputer Programming

GPA: 3.85

Mile Hi Reporting College, Lakewood, CO

1978 - 1980

Completed Court Reporting Course

Contact this candidate