Biography
As
a production and project manager for over 20 years,
Hal Payne has worked with local, national and international
clients, from restaurant chains to airlines. With his
extensive knowledge of production processes, database
administration and resource management, he has computerized
processes and procedures, ensuring the most efficient use of
time and personnel. He’s been fully involved in the
production of films, trade shows and special events, from
initial concept through execution.
Accomplishments
For Pennzoil-Quaker State
Pennzoil-Quaker
State Company is a worldwide leader in consumer car care and
maintenance products. Their Creative Services Department is
responsible for producing the collateral, packaging and
point-of-purchase materials for over forty divisions.
Projects range from updating retail packaging to creating
decals for the racing team. Various combinations of fifty
people comprising eighteen groups of approvers are included
in the routing of layouts. The old system utilized some
handwritten forms and an Access database that evolved over
the years on an as-needed basis with help from the IT
Department. We were hired to streamline the systems and
processes associated with producing the growing quantity and
complexity of projects Creative Services takes on. The
complete case history is featured in our August
2002 Newsletter.
For Stage Stores, parent company of Palais
Royal.
Creating
and maintaining schedules for hundreds of jobs is a
monumental task, but we have a client does just that. We’ve
reworked their scheduling
system, incorporating popup calendars and scripted update
capabilities that maximize the intuitive skills their
production specialists have developed over the years.
We’ve developed
scripts to automatically generate reports. Click a
button labeled “Due Today,” and you get a report
of all the steps in each schedule that’s due that day.
There are similar buttons labeled “Due Tomorrow,”
“Due Today & Tomorrow,” and everyone’s
favorite, “Past Due.” A report for any given
Date Range is also easily generated. These tools facilitate
the monitoring and maintenance of these schedules, ensuring
accurate information is disseminated to the various project
stakeholders. The old system
involved making thirty hard copies of the weekly multipage
report and distributing by hand. Now data
is exported to hyper-format Excel spreadsheets that allow
recipients to instantly filter data by Job Type, Group,
Client, Writer, Artist, etc.
For Aggreko
This
company was responsible for supplying temporary power for
mission critical functions like broadcasting, security,
timing and results operations, and information technology at
the 2002 Winter Olympics in Salt Lake City. We were hired by
their marketing department to develop a system to track jobs
and budgets as well as the results of their telemarketing
and trade show efforts. The new system tracks projects from
their inception through production, and stakeholders are
regularly updated on the status of their jobs. Read the
complete case history in our April
2002 Newsletter.
For McCrory and Associates
McCrory
and Associates is a marketing firm serving the safety
industry. They represent a small number of the finest
manufacturers of safety products, from fire-retardant
clothing to emergency drench showers to personal fall arrest
equipment. They’ve used Filemaker to generate invoice,
commission and inventory reports for over a decade. Read
their complete case history in our August
2002 Newsletter.
For Direct Marketing Network
We
were hired by this small direct marketing agency to
implement processes and procedures to better manage a
growing number of complex projects for their high-profile
corporate clients. We were onsite daily for a month, given
an office and even a few projects to manage. The old job
logbook was replaced with a modern job-tracking database
shared by the entire agency. Biweekly production meetings
were established. A process manual was developed to ensure
that existing as well as new employees would use and
perpetuate the system. Read the complete case history in our
January 2002 Newsletter.
For Jackson & Company Caterers
Assisted
development of Filemaker Pro solution for this large
catering company with 1200 contractors by creating “real-time
inventory” system that instantly calculates
specialists “Needed” and “Staffed”
in 19 different categories for events requiring up to 300
contractors (Bartenders, Cashiers, Waiters, etc.) Read the
complete case history in our August
2001 Newsletter.
For BMC Software
Increased
productivity by reworking project management system to track
over 2,500 jobs annually for in-house ad agency. Enhanced
usability, simplified reporting and continuously modified
databases as dynamic corporate marketing structure evolved.
Managed over 300 corporate marketing projects weekly through
administration of shared database. Information disseminated
globally. Precluded purchase of $10,000 scheduling software
by creating custom scheduling system for corporate video
department.
For The Houston Advertising Federation
The
HAF's ADDY Awards Show is their largest event of the year.
When the call went out for volunteers to coordinate ticket
fulfillment and table assignments, we joined the committee.
There are 400 to 600 attendees, pre-assigned ten to a table.
There are Gold, Silver and Bronze tables sold at different
rates that change as the deadline approaches. Information
comes in sporadically. Final attendee and table counts can
change up to the night of the event. Read about our
automated database solution in our February
2002 Newsletter.
For John Morgan Custom Homes
This
custom homebuilder contacted us about developing
construction management software. Their current system
consists of hyper-formatted Excel documents, one for each
project. But they envision the ultimate home construction
management database system, and we mean envision.
Read the case history in our June
2002 Newsletter.
For Occidental Arts & Ecology Center
Salvaged
corrupting database for nonprofit organization endeavoring
to track information on their 7,500 activists, volunteers
and benefactors.
Associations
Associate Member, Filemaker Solutions Alliance
Board Member, Houston Production Manager’s
Association
Member, Houston Advertising Federation
Member, Art Directors Club of Houston
In Greater Houston, dial 713-956-6940
NEWSLETTERS &
ARTICLES
1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
Project Management
in the Relatively New Millennium •
Chicken
Bones
THE COMPANY
Home
• Screen
Shots • Case
Histories
Clients
• Ideal
Projects • Nonprofit
Services
Filemaker Tech Support
$25/Call
Online
Job Tracking
System
xxxxxx