William Sheldon
Willoughby,OH
Overview
25
25
years of professional experience
Work History
SPS Consultant
Robert Half, Inc.
09.2018 - Current
- Assist clients needing short-term, full-time accounting assistance. Specializing in period-end close, financial analysis, other special projects including the following:
- Chart of accounts creation and mapping for company that had recently acquired a cash-based subsidiary with 4 locations.
- Calculation of A/R reserve.
- Training of new accounting staff.
- Assisting with year-end audit including management and tracking of PBC list.
- Daily and monthly banking activity including reconciliation of operating and ZBA accounts.
ERP System Admin.
Applied Industrial Technologies
02.2015 - 10.2017
- Maintain listings of account reconciliations and periodic reporting tasks.
- Maintained various ERP systems (SAP, Host Analytics, and Blackline) to ensure all were in sync with each other.
- Maintained all user access and responsibilities for Host and Blackline.
- Performed UA testing before onboarding new entities onto the platform.
- Maintained log of all changes for all ERP systems for internal and external auditors.
- Created and maintained reports in Host Analytics for segment and cost reconciliation reporting.
Accounting Supervisor
Applied Industrial Technologies
11.2013 - 02.2015
- Managed the workload for 3 staff accountants while maintaining my own set of periodic accounting close activities.
- Scheduled periodic close duty deadlines to optimize external auditors' workload.
- Maintained periodic close checklist for all areas of Finance.
- Performed maintenance on ERP system for creation or closure of reporting locations and GL accounts and hierarchy.
Senior Accountant - Subsidiaries
Applied Industrial Technologies
03.2010 - 11.2013
- Main duty was to analyze monthly financial statements from 10 domestic and foreign subsidiaries and question subsidiary controller for statement anomalies.
- Loaded monthly subsidiary financial statements into ERP system and cross verified back to subsidiary financials for accuracy.
- Maintained full subsidiary financial info (actual vs. history and vs. budget) for reporting to Vice President - Subsidiaries.
- Assisted in the annual budget process for all subsidiaries. Built excel worksheets to calculate 'what if' scenarios during budget approval process.
Senior Inventory Analyst
Applied Industrial Technologies
09.2003 - 03.2010
- Main duty is to oversee quarterly inventory reconciliation of $2 billion industrial distribution company with 450 North American locations and inventory totaling $400MM.
- Improved inventory reconciliation from bi-annual verification to quarterly.
- Reduced time required to complete inventory reconciliation from 90 days to 25 days.
- Travel as required to train field personnel on inventory transaction troubleshooting.
- Assist in monitoring inventory cycle counting.
Staff Accountant
Applied Industrial Technologies
01.2002 - 09.2003
- Responsible for maintaining fixed asset records totaling $170MM.
- Improved annual fixed asset audit response rate to 100% from 75%.
Timeline
SPS Consultant
Robert Half, Inc.
09.2018 - Current
ERP System Admin.
Applied Industrial Technologies
02.2015 - 10.2017
Accounting Supervisor
Applied Industrial Technologies
11.2013 - 02.2015
Senior Accountant - Subsidiaries
Applied Industrial Technologies
03.2010 - 11.2013
Senior Inventory Analyst
Applied Industrial Technologies
09.2003 - 03.2010
Staff Accountant
Applied Industrial Technologies
01.2002 - 09.2003