JOHN R. ANDERSON

P.O. Box *** cell 765-***-****

Dayton, IN 47941 ac4xhs@r.postjobfree.com

SUMMARY OF QUALIFICATIONS

Versatile, analytical operations and accounting professional with experience in a variety of settings including manufacturing, service, and retail. Areas of expertise include computation and administration of qualitative and production records. Proven success in developing, formulating, and administering computerized reports using Excel spreadsheets and Access. Bachelor of Science in Industrial Management from Purdue University. Able to connect both verbal and quantitative data for use by all. Sought out as a tenacious, persistent problem solver.

AREAS OF EXPERTISE

Planning and Operations Skills

Constructed and maintained stationary and portable bottle attainment schedules using the monthly forecast. Exceeded monthly goal of 95%.

Provided daily and monthly bottle attainment reports for management and resolved issues dealing with production. Met weekly deadlines 100% of the time.

Created and maintained plan orders in the MRP (material resource planning) for bottles based upon the 12 week schedule using vertical lookup tables.

Analyzed daily actual attainment of bottles versus scheduled amounts and reconciled discrepancies using pivot tables.

Determined monthly subassemblies for production and shipping requirements. Administered Kanban production system for shipping and production requirements for subassemblies.

Compiled daily backorder and coordinated with buyers, production supervisors, and leads corrective actions.

Researched and identified material variances in shop orders.

Assessed and resolved daily material negatives' root causes.

Compiled daily purchase orders for outside processing of machined parts. Reconciled PO (purchase orders) problems with vendors. Coordinated special deliveries for production issues.

Analytical and Computing Skills

Recorded and tracked weekly and monthly quantity, quality, and incentive bonus statistics for employees with interconnected Excel spreadsheets; increased productivity 15%.

Streamlined the use of an Access database to figure employee productivity, efficiency, and overtime bonus plans on a weekly and monthly basis.

Projected six-week production plan for quantity and quality control for all departments taking into account all personnel situations for vacations, overtime, personal days, and absences.

Coordinated and recorded regular and overtime projections of several teams for future work week schedules.

Calculated daily, weekly, and monthly production numbers and quality statistics for all units in customer service.

Accounting and Administration Skills

Synchronized information with different areas of accounting to ensure expenditures met departmental requirements and cash availability; met deadlines 100% of time.

Answered and investigated queries from vendors and customers about issues with payments, invoices, and orders. Documented answers for all parties.

Organized and balanced monthly records for all accounts receivable. Consistently met deadline which enabled all other departments to begin end of month procedures.

Prepared annual reports on outstanding accounts receivable.

Reorganized spreadsheets into more efficient permanent records and connected spreadsheets to reduce time on sheets by 25%; made them instantly updated for all users in the department.

COMPUTER EXPERIENCE

Windows ~ Excel ~ Access ~ Word ~ SAP ~ PowerPoint ~ SAS ~ JD Edwards

MS Works ~ Impact/Encore ~ BPCS

EDUCATION

Purdue University West Lafayette, IN

Bachelor of Science, Industrial Management & Economic Honors GPA: 5.4/6.0

PROFESSIONAL EXPERIENCE

Conduent 2017+

Self-employed 2010 - 2017

Covidien 2007 - 2009

Lead Material Specialist

Accountemps, Indianapolis, IN 1999 - 2007

Landis+Gyr Inc. (Accountemps) 2004 - 2005

Accounts Payable Lead

Pen Products 1999 - 2003

Accounts Receivable Specialist

Contact this candidate