DOROTHY E. JOHNSON
Dearborn, Michigan 48124
*******************@*****.***
CAREER SUMMARY
Administrative assistant with an extensive and broad-based background of
diversified responsibility and accomplishments. Acquired strong
proficiency with data entry, customer service, data tracking, database
development and management, newsletter formatting and distribution,
conference and meeting planning, purchasing, and accounts receivable and
payable. Proficient in Microsoft Word, Excel, Access and PowerPoint, good
organizational skills, friendly, creative, quick learner, reliable,
motivated and enthusiastic, and able to work independently and as a team
member.
PROFESSIONAL EXPERIENCE
MASCO CORPORATION, Taylor, MI 1984-2008
One of the world's largest manufacturers of brand-name consumer products
for the home improvement and new home construction markets.
Administrative Assistant, Health and Safety
Performed clerical, word-processing duties, accounting and database
implementation and maintenance for eight member staff of safety
professionals.
. Directly responsible for collecting and entering injury data from
plants into Microsoft Access database and also maintained and updated
database, resulting in measurables for quarterly reports.
. Answered telephones, took messages and transferred calls to the
correct person to handle the request of the callers.
. Booked travel arrangements for my supervisor and other staff members.
. Created and implemented a system using the mail merge function in MS
Word to streamline the distribution of quarterly safety performance
reports and copies sent to 300 individuals including division
executives, plant managers and safety coordinators.
. Designed a new template to format graphs and print graphs directly
from the Microsoft Access database as part of the quarterly safety
performance reports.
. Formatted and electronically distributed two safety newsletters; one
monthly with a poster and the other quarterly, to impart safety
information to employees and safety coordinators using Microsoft Word.
. Developed and implemented a system to catalog and track Health and
Safety video library to eliminate lost items and reduce costs.
. Created forms from rough drafts which were used by staff when in the
field auditing for better time management utilizing the form function
in MS Word.
. Developed and maintained mailing lists and email lists used for large
mailings and provided lists to manager when needed in order for
management to send emails in a time efficient manner.
. Created and maintained a database to reconcile payment of invoices
from vendors that were processed and submitted to accounts payable to
track against the proposed budget.
. Compiled list of action items discussed at staff meetings for manager
to track progress and completion of action items.
MASCO CORPORATION (continued)
Administrative Assistant, Health and Safety
. Teamed with manager and staff to plan and coordinate annual Health and
Safety Conference for 100 to 150 attendees including food, beverage,
entertainment, hotel accommodations, local transportation, and
conference materials in paper and electronic formats.
. Initiated a template used by staff for monthly status reports compiled
into one document for the department director.
. Organized and labeled cabinets with office supplies so that it was
easy for staff to find the items they needed at any given time.
EDUCATION
BS Degree, Education and Psychology, Mt. Pleasant, MI 1972
Successfully completed an Accounting Fundamentals on-line course offered by
Henry Ford Community College.
ADDITIONAL TRAINING
. MS Word
. MS Excel
. MS Access
. MS PowerPoint
. AS/400
. SurveyTracker
. Enablon
. Medgate
. Visio
. Crystal Reports
. Type 55 words per minute
. Fax Machines
. Copiers
. Printers
. Calculator
. Lotus Notes