John Volz Email & Phone Number

Princeton, New Jersey

Princeton, NJ

Provide advanced Excel and JetReports (BI) solutions to Management, Customer Service, Sales, Marketing, and Finance.Process AP and AR, perform daily bank account reconciliations, calculate and remit monthly and annual sales commissionsTroubleshoot staff computer issues before escalating to IT support.Train temporary and full time staff in AP, AR, Order.

While employed as a contract employee in their Raritan location, my main project was assisting with the repeated analysis of several thousand records as they test for accuracy in advance of a large system implementation. Creating Access databases and Excel pivot tables to analyze areas needing attention and further action. Using Sharepoint for document.

Receive and process all vendor invoices through full cycle for three companies. Create and maintain Purchasing Logs in Excel that highlight variances needing further action. Work directly with management to produce cash requirement reports and accrual data for monthly closing. Handle vendor inquiries of payment and invoice adjustments. Budget reductions.

Review new data on global energy assets for use in Bloomberg applications. Confirm accuracy of data using internet sources, making corrections as required Perform quality control on asset data already reviewed. Interact with other team members to improve search techniques and minimize errors. Provide feedback to Project Manager on progress of searches.

Began as AP Coordinator and implemented use of Adobe scanning and MS Office to dramatically speed the invoice approval process. Promoted to Contracts Analyst in July, 2009. Responsibilities included preparing data for ad hoc management reports including budgeting, project costing and cash flow projections. Ensured documentation is SOX compliant. Created.

Responsible for input and payment of invoices in a timely manner utilizing a multi-company system in Oracle Financials. Charged with preparing AP records for off-site archiving. Improved Discoverer reports for creating hard copy of payment reports. Initiated the use of Oracle for 1099 reporting data. Created Excel database to contact all vendors and.

Prepared general ledger entries for all Prepaid accounts and accrual entries for monthly close. Reviewed monthly expenses to budget variances for investigation. Prepared monthly and ad hoc reports for use by senior management. Ensured the timely processing of invoices and employee expense reports. Reviewed Purchase Order creation and matching processes.

Managed daily operations of branch, including supervising staff of four to ensure efficient operations and regulatory compliance. Increased branch core deposits by 20% in one year. Developed visibility by creating local advertising and utilizing a self-designed 600+ customer database in Q&A.

Member of Cash Management team charged with settling $200MM private bank’s daily activity. Initiated, executed and verified wire transfers as part of operations team. Reconciled daily inter-company activity and initiated cash settlement transfers. Created illustrated Operations Manual for employee use in my absence. Cross-trained coworkers for backup.

Aa, Associates Of Accounting

Attended classes part time while working in order to broaden my career options.

Ba, Applied Music

Received degree in applied music (double bass). Ultimately returned to school for an Associates Accounting degree for a more consistent.