Microsoft Office Manager

Patricia M. McGuire

**** ***** ************ *******, ******** 60638 312-***-**** ********@***.***

SUMMARY

A driven and resourceful professional with communications experience in broadcasting, cable network relationships, continuity, air scheduling, distribution, and copywriting. Looking to redirect my energies into a more administrative role, which many of my skills could easily transfer. I possess additional operations capabilities covering administrative functions, compliance and specifications, purchase orders, invoicing, and logistics. Carries out objectives with accuracy and timeliness in diverse environments and complex situations. A self-motivating and communicative contributor who works well individually and with others to see corporate goals through to completion.

EXPERIENCE

OGILVY & MATHER, Chicago, Illinois

Freelance Production Traffic & Legal Clearance Manager

(Production Business Management/Content Production), 2014 – 2015

Worked on Kimberly Clark BabyCare Hispanic and General Markets, Sargento Cheese, BP Fuels, and others. Composed and Provided Traffic Instructions to networks, syndicators and cable networks, spot stations and local cable systems. Secured complete buy details from media or outside buying agency, generating instructions for billboard information, live read copy, and media and time restrictions. Liaison between Ogilvy’s legal firm and Account Services after submitting new commercial concepts and finals for legal review. Provided storyboards/roughs and finals for Network Clearance and relayed information given by Networks to Account Services. Gathered quarterly costs for Estimates for each client and submitted into SAP and ASPEN for Billing/Finance.

Provided accurate deadline and shipping information as well as technical feedback to account service and producers.

Submitted talent reports to business affairs to ensure payment of talent.

Provided shipping deadlines and mastered shipping details, calculated necessary elements for assigned clients and jobs, and entered estimates in EAS, sisters, and cross-matches station lists.

Generated and maintained dub and shipping estimates for each client as mentioned above.

Created purchase orders in SAP for encoding, captioning, and distributing orders for client copies.

Estimated totals for each purchase order, checked and approved vendor invoices, entered final total in SAP, and forwarded approved invoices in ASPEN 360 to accounting for payment. Checked proof of delivery.

Logged in master and viewing copy to library and verified vendor receipt of masters.

Maintained all agency traffic records for each client according to company policy.

DDB CHICAGO, Chicago, Illinois

On Call Freelance Broadcast Traffic Coordinator, 2013 – 2014

(See below)

DDB CHICAGO, Chicago, Illinois

Broadcast Traffic Coordinator, 2005-2013

Worked with clients, including Capital One, Aveeno, Wrigley/Mars, and McDonald’s hispanic and youth segments and local owners/operators. Provided traffic instructions to networks, syndicators, cable networks, spot stations, and local cable systems. Secured complete buy details from media or outside buying agency, generating instructions for billboard information, live read copy, and media and time restrictions. Handled supervisor workload during absences and vacations. Worked closely with media to clear discrepancies. Maintained database of network specifications and requirements, coordinator information, and contact information, including phone and fax numbers.

Issued Ad-ID codes and distributed to producer and appropriate teams.

Provided accurate deadline and shipping information as well as technical feedback to account service and producers.

Submitted talent reports to business affairs to ensure payment of talent.

Provided shipping deadlines and mastered shipping details, calculated necessary elements for assigned clients and jobs, and entered estimates in EAS, sisters, and cross-matches station lists.

Generated and maintained dub and shipping estimates for each client.

Created purchase orders for encoding, captioning, and distributing orders for client copies.

Estimated totals for each purchase order, checked and approved vendor invoices, entered final total in Donovan, and forwarded approved invoices to accounting for payment. Checked proof of delivery.

Logged in master and viewing copy to library and verified vendor receipt of masters.

Maintained all agency traffic records for each client according to company policy.

WLS AM RADIO, Chicago, Illinois

Continuity Director, 2004-2005

Scheduled placement of commercials for station’s clients on daily broadcast logs. Prepared and entered revisions of commercials at a moment’s notice. Confirmed air schedules. Conducted copy writing of billboards for clients.

NORTHWESTERN ORTHOPEDIC INSTITUTE, Chicago, Illinois

Scheduler, 2003-2004

Scheduled appointments for an office of ten orthopedic surgeons. Handled all incoming calls and questions from patients, sent out welcoming letters to new patients, and confirmed upcoming appointments. Other duties included scanning old patient charts for update in computer e-chart system, sorting mail for entire office, and providing support to medical records, when needed.

EDUCATION

COLUMBIA COLLEGE, Chicago, Illinois,

Bachelor of Arts, Concentrations in Broadcasting and Commercial Art

PROFESSIONAL DEVELOPMENT

SECOND CITY TRAINING CENTER, Chicago, Illinois

Graduate of the Improv Training Program

COMPUTER SKILLS

SAP, Aspen 360, Microsoft Office, Outlook, Donovan, ADID, ISD, Marketron

Contact this candidate