Operations / Accounts Payable / MS Access Database Manager

Vincent J. Mezza

*** **** ****** * **********, PA 15227 w Home: 412-***-**** w Cell: 412-***-**** w *******@*****.***

Highly regarded professional with expertise in program development and process improvement. Designed technology with emphasis on MS Access database systems for marketing, sales, business operations, inventory, accounting, student records, financial aid, and placement departments in for profit, non-profit business and higher education institutions. Dedicated to the development and implementation of efficient processes to serve the needs of the organization, staff, and customers.

Education

Penn State University ~ Bachelor of Science Degree, Agricultural Business Management

Penn State University ~ Bachelor of Science Degree, Economics

Key Skills Summary

Provide Leadership & Strategic Direction

Ensure Quality of Service

Sales and Sales Management

Operations Management

Business Analysis & Process Improvement

Support Educational Vision

Hiring & Training of Staff

Presentation & Delivery

Implement Marketing Initiatives

Manage Multiple Projects

Excellent Communication, Coaching & Mentoring Skills

Honest, Reliable, Dependable

Technologically Savvy

MS Access, Excel, Word, PowerPoint, Adobe, Drupal, SQL, Proprietary Software

Professional History

Tom’s Fleet & Tire Service (2015 – Present)

General Manager/Controller – Automotive Repair Center - Full Time

Schedule service for fleet and private customer vehicles, preparing repair orders and final invoices, submitting invoices for payment via various websites. Work directly with fleet managers and private owners.

Perform bookkeeping functions, accounts payable duties, accounts receivable activities, and budget analysis.

Created MS Access Database or inventory and accounts receivable tracking.

Installed technology upgrades and improved office systems.

Home Performance Coalition (2011 to 2015) (Non-Profit)

(Formerly ACI (Affordable Comfort, Inc.) Merger completed 10/1/2014))

Office Technology Manager – Full Time (2013 to 2015)

Maintained office equipment and managed inventory.

Installed technology upgrades and improved office systems

Data mine internet to provide marketing department with lists potential sponsors, exhibitors, and attendees.

Facilitate webinars, online meetings, conference calls and web conferencing

Design software systems for interdepartmental communications

Imported and exported data as needed by staff, updated website and created email marketing campaigns.

Continue in role of Database/Conference Coordinator

Database/Conference Coordinator – Full Time (2011 to 2013)

Design, develop, and maintain MS Access CRM database for resource development, sales, program, marketing, finance, and grant writing departments.

Record contact information and conference data for attendees, sponsors, and exhibitors. Assist resource development manager with fundraising, registration, and securing sponsors and exhibitors, and telemarketing.

Provide marketing manager with mailing and email lists for marketing campaigns. Design email campaigns for email distribution via MS Outlook, Constant Contact, and Mail Chimp. Research and data mine industries to create marketing list.

Website design and update weekly website content for upcoming event presenters, sponsors, and exhibitors. Daily updates of website were required 30 days prior to the start of a conference.

Import program information for conference session details and presenters. Export data to update company website to publish conference schedules, speakers, sponsors, and exhibitors.

Assist grant writing department with research and document sharing.

Prepare for conferences by performing activities assigned by program, resource development, and marketing departments. Create and update conference floor plans, provide information for marketing publications and program book, prepare for shipping of equipment and conference materials, onsite activities include setup and breakdown for event sessions and exhibitors, assist with onsite registration.

Education Management Corporation – Argosy University Online, Pittsburgh, PA - Full-time

Admissions Representative (2010-2011)

Make daily calls to perspective students, conduct quality conversations regarding potential student’s interest, needs, and plans to continue their education. Determine their eligibility for Argosy University Online programs.

Accompany potential student on a virtual online tour of college, campus, and classroom.

Enroll students into online degree programs and ensure they are successfully transitioned into the classroom.

Guide potential students through the enrollment process: completing online application, securing enrollment documentation (transcripts), assist with filing for financial aid.

Worked as a member of the Graduation Team to ensure students successfully transition into academic acceptance, financial and academic planning, and the classroom.

Community College of Allegheny County – South Campus, Pittsburgh, PA (2009 – 2014)

Athletic Coordinator (2009 to 2014) – Part-time

Responsible for 8 NJCAA Division III sports, for baseball, softball, men’s and women’s golf, men’s and women’s bowling, and men’s and women’s basketball. These sports were also members of the Western Pennsylvania Collegiate Conference (WPCC) and Pennsylvania Collegiate Athletic Association (PCAA).

Attended conference meetings, PCAA chair and PCAA co-chair for bowling and men’s baseball respectively. WPCC chair for bowling and WPCC co-chair for softball and golf.

Responsible for budgeting, scheduling for each sport, filing eligibility, scheduling vehicles, and the use of the gymnasium, hiring and supervising coaches and staff, fundraising, and program implementation and development.

Managed event staff for basketball games for CCAC teams and Point Park University.

Designed and managed website for athletics.

Submitted baseball, softball, and basketball schedules using Presto Sports as well as updated game results.

Designed MS Access database to manage athletic budgets, schedules, and to prepare contracts for games and matches.

Career Training Academy, Monroeville, PA – Full-time

School Director (2008 to 2009)

Managed operation of an Allied Health technical training school.

Hired and trained employees.

Supervise instructional and administrative staff with 4 direct reports, chief instructor, admissions supervisor, placement supervisor, and financial aid coordinator.

Created advertising and marketing campaigns for lead generation for three campuses.

Pittsburgh Institute of Aeronautics, Pittsburgh, PA (1995 to 2008)

Director of Admissions & Student Services/Athletics (2004 to 2008)

As Director of Student Services / Athletics initiated exciting new student activities programs including the inception of student golf and bowling leagues, formed alliance with the Western PA Collegiate Conference and Pennsylvania Athletic Collegiate Conference. Implemented fundraising programs and intramural sports. Responsible for all NJCAA compliance including athlete eligibility, budgeting, hiring of staff, and all ancillary duties and responsibilities associated with being an Athletic Director.

Awarded “Western Pennsylvania Collegiate Conference Athletic Director of the Year” for 2007/08 and 2006/07.

Director of Admission for 5 truck driving school campuses throughout PA and WV. Managed admissions staff at each location.

Designed and implemented MS Access database to be used at remote locations for lead management, registration processing and tracking, and placement tracking and follow-up.

As Director of Admissions of 2 aviation maintenance campuses, hired, trained, mentored and led 9-person admissions staff with an annual budget of $750,000; increased enrollment by over 50% through aggressive marketing strategies, including web presence development, radio, TV, print media production, and press releases.

Implemented new lead generation programming, developed and conducted successful High School presentations.

Assisted in the launching of the Youngstown-Warren Regional Airport campus; led all programming and implementation for admissions and financial aid activity; assisted students with securing funding and the filing of financial aid applications (FAFSA, student loans).

Interdepartmental Coordinator and Supervisor of Student Records/Student Services (1999 to 2004)

Led overhaul of tracking & database administration for Student Records Department; integrated database technologies and designed interface to allow information to be shared among faculty, staff, financial aid, bookstore, business office, and placement department.

Served as Registrar and designed database to generate transcripts, attendance records, class scheduling and led registration activities for local and international students.

Veterans Affairs certifying official.

Admissions Representative/Coordinator (1995 to 1999)

Delivered persuasive and informative in-class high school presentations to schools in PA, MD, OH, NY, and WV school districts.

Design MS Access database forms and reports to interface with SQL server for managing leads and student registration. Prepared interface for telemarketing, scheduling on-campus visits and tours, financial aid student budgets, and enrollment tracking.

Coordinated all marketing activities for direct mail, special events, promotions and open houses.

Performed new student orientation, assisted in securing housing & employment opportunities for incoming and existing students.

Database Projects

2015 – Toms’ Fleet Service – Design MS Access database for parts inventory, accounts receivable tracking, mailings, and budgeting.

2014 – Burleson LLP – Design MS Access database to track and monitor litigation for oil and gas parcels. Database used by Pennsylvania, Ohio, and Texas attorneys and staff to record and track parcel status, ownership status, and case outcomes.

2011 – Walker-Miller – Design MS Access database to be used by contractors to prepare quotes for electric customers in the Detroit metropolitan area. Database designed to be used with remote connection to main SQL server. Quotes listed products to be used in energy upgrades to show cost and energy savings.

2010 – Affordable Comfort, Inc.

oDesign MS Access database used for proposal submission and review. Import proposals submitted online and prepare data for collaborative review during 2-day summit.

oDesign MS Access database for event management, conference sessions scheduling, presenter follow-up and scheduling, input and track conference registration of sponsors, exhibitors, presenters, and attendees. Provide marketing with lists for targeted advertising campaigns. Export conference schedules and presenters and import into Drupal interface to update conference website.

2009 – Community College of Allegheny County – Designed MS Access database used for Athletic Department budgeting, preparing event contracts, CRM for recruiting, and tracking academic performance of student athletes.

2008 – Direct Line Supply – Design MS Access as CRM tool for conveyor belt customers. Database designed to manage telemarketing, generated customer quotes, and schedule shipping and installation of equipment.

1996 – 2008 – Pittsburgh Institute of Aeronautics

oDesigned MS Access database as CRM tool for managing leads. Used for telemarketing, generating mailing lists, recording and tracking registrations. Reports included registration lists, outside sales staff lead generation results, and insides sales staff appointment conversion and enrollment results.

oDesigned MS Access database for Financial Aid and bookstore. Used to generate reports for student financial aid estimates and invoices, prepare 1098T forms. Used as point-of-sale software in bookstore.

oDesigned MS Access database for Student Records. Database included instructor grading program, term report cards and student transcripts, and attendance recording and tracking.

oDesigned MS Access database for Placement Department. Used to manage employer interview schedules, track graduate placement and employment history.

Memberships

Member ~ Board of Directors Regional Chamber Alliance Foundation (2007 to 2008)

President ~ Mon-Yough Chamber of Commerce (2006 to 2007)

Member ~ Board of Directors Regional Chamber Alliance (2005 to 2008)

Member ~ American Baseball Coaches Association (1985 to Present)

President ~ Western Pennsylvania Collegiate Conference (2006 to 2008)

Co-Founder/Vice-President – The Pennsylvania State University Alumni Association of Lawrence County (1988 to 1990)

Contact this candidate