Andrew Rundell
Troy, Michigan **085
248-***-**** *.*************@*****.***
Objective: I am a highly detailed and organized person looking for a challenging
environment in which I can utilize my expertise.
PROFESSIONAL SKILLS
4 Advanced knowledge of Microsoft Excel and Access
5 Basic to proficient SQL experience
6 Advanced knowledge of database management – running reports, importing and
exporting data into Excel and Access, etc.
7 Proficient in Microsoft Word
8 Microsoft Outlook experience and other email systems such as gmail, etc.
9 Experience conducting extensive internet research
WORK EXPERIENCE
Motor Information Systems, Troy, Michigan 6/1999 - 5/2011
Parts Analyst
10 Managed a comprehensive automotive parts database - assigned numbers to all
parts and ensured data accuracy.
11 Successfully addressed and responded to all customer inquiries within 24 hours.
12 Collaborated with team leader to set and achieve individual goals for annual parts
update. I consistently met all expectations for updating and entering all new
model year info, accurately and met all deadlines.
13 Accurately identified all parts for the graphics departments to enable them to
accurately draw pictures for instruction manuals.
14 Conducted internet research and obtained sales brochures from local dealerships
for all changes made to new and existing vehicles to ensure consistent accuracy of
the database parts information.
15 Made adjustments to completed parts information for labor editors when required.
16 Investigated service repair information and wiring diagrams to ensure accuracy of
information.
17 Assigned special projects to enter and manipulate data in Microsoft Excel and
Access databases.
Michigan Caterpillar, Novi, Michigan 8/1998 - 6/1999
Service Supervisor Assistant
18 Ensured all daily repair orders for all construction equipment are prepared and in
order each morning to ensure timely and efficient completion of repairs.
19 Assessed and provided estimates of rental equipment damages to management for
timely and accurate repairs.
20 Manipulated, updated, and managed data in tables using structured query
language (SQL).
21 Maintained schedules of construction equipment in for service.
22 Updated customers about status of construction equipment repairs.
23 Explained completed repairs on work order for customers to ensure their
understanding and to ensure customer satisfaction of work.
24 Acted as interim supervisor of the office when supervisor was on a leave of
absence or vacation.
The following 3 dealerships are all owned by the same individual/company.
I was assigned to work at all 3 throughout my employment from 1/1991 to 8/1998
Golling Chrysler Jeep, Bloomfield Hills, Michigan 5/1997 – 8/1998
Service Dispatcher
25 Responsible for distribution of repair orders to technicians and monitoring
completion of vehicles in proper sequence.
26 Organized repair orders according to type of repair required.
27 Provided updates to customers on vehicles waiting on parts.
28 Prepared daily time sheets for technicians containing all jobs completed and made
any necessary adjustments.
29 Tabulated customer pay and warranty repair times on repair orders.
30 Contacted sublet vendors for repairs.
31 Issued purchase orders as payment for service department supplies and sublet
repairs.
Southfield Chrysler Jeep, Southfield, Michigan 3/1996 - 5/1997
Service Consultant
32 Summarize descriptions of vehicle problems on repair orders for technicians.
33 Arrange appointments to have customers bring vehicles in for service.
34 Prepare estimates for required and recommended repairs then contact customer
for authorization.
35 Document completed repairs on printed invoices.
36 Calculate technician compensation for customer pay and warranty repairs.
37 Explain repairs and answer questions concerning service upon delivery.
38 Follow up telephone calls to insure customer satisfaction.
Bloomfield Dodge, Bloomfield Hills, Michigan 1/1991 - 3/1996
Service Consultant and Warranty Assistant
39 Assisted service consultants by performing follow up telephone calls and updating
customers waiting on vehicles for service.
40 Created weekly graphs and charts displaying customer satisfaction.
41 Discussed results of survey at monthly service meeting.
42 Supported warranty clerk in entering Chrysler warranty claims, downloading
claims in computer and correcting rejected claims.
EDUCATION
Ohio University, Athens, Ohio
Bachelors Degree in Business Administration