Ken Box Email & Phone Number

St Louis, Missouri, United States

Manage daily cash in and outputs for multiple bank accounts for ach, cash, and credit card payments.Prepare monthly journal and reversing entries.Manage a team responsible for ensuring checks and money orders are properly entered while following AML rules.

St Louis, Missouri, United States

Reviewed tax credit requests and prepared credits and refunds as necessary while also updating the tax software (Avalara).Ran daily reports identifying billing errors and entered system corrections.Work with existing process owners to document current methodology and create business requirements for the creation of automated reports.Financial reporting: Credit and rebills for clients in newly implemented M3 ERP system – transfer finance coding, validate and test.Lead the creation of reports by following up with the developers to ensure reports are created in a timely manner and meet the needed report expectations.Create user guides for all the reports that thoroughly detail the report purpose and all the associated fields and filters within the report.Extract financial reports from multiple ERP systems and import into FDM (Hyperion) for financial consolidations. Run validation reports confirming data imported into FDM ties to input files and mapped properly to expected GL accounts. Review balance sheet, P&L, and cash flow for multiple divisions and investigate any variances. Review budget numbers and run a system extract prior to update and then after update to validate entry processed as expected. When variances are found working with the divisions for needed corrections.Prepared a daily report that calculated the plant productivity. It was then analyzed for any anomalies which could vary from corrupted data to actual productivity variance per shift. Supervised plant physical inventory to ensure data integrity and look for opportunities for process improvement. Worked with the Engineering group to provide costing amounts and ensure they were within expected parameters.Reviewed the sales accounting process for internal controls. Documented the sales accounting processes and created SOP’s. Investigated sales and use tax to ensure taxes were properly accounted for due to the change in the law for interstate drop shipments.

Created and modified queries for data extraction used in PowerPoint presentations and high level Excel (Pivot tables, Vlookups, nested if formulas) reporting Prepared and utilized UI test scripts for new system integration and system upgradesProcessed daily reconciliations from the bank feed to the AR finance module and processed correcting entries as needed.Collaborate with multiple data owners to consolidate data from several different ERP systems (PeopleSoft, Oracle, Delta, and Great Plains) used in analyzing customer activity and employee productivityWork as PeopleSoft SME for AR outsource group in India, and the Philippines. This involved daily calls with the group to discuss any outstanding issues as well as the handling of escalated items. Prepare analysis for recent acquisitions to determine if their product can be integrated into current finance systems currently utilized by ElsevierDo Ad Hoc reporting as detailed by the Elsevier Americas Global head

Prepared sub-ledger to ledger month end reconciliations.Supervised cash applications teamProcessed daily cash and credit card reconciliations.Created SOP's detailing the processes for the AR group.Acted as the main point of contact with internal and external audit. .

Certificate, Big Data Analysis

B.S In Bus Adm., Bus Mgmt

Activities and Societies: Alpha Kappa Psi