DOUGLASS YOUNG
SENIOR ACCOUNTANT
ad0urg@r.postjobfree.com
**** ********, ******* *****, ** 60515
SKILLS & ABILITIES
JD Edwards, SAP, PeopleSoft/Oracle, Advanced Excel, MS Office, Blackline, Journal Entries, Month End Close, Fixed Asset Management, Account Reconciliation & Analysis, Budgeting & Forecasting, Cost Accounting/Analysis, Vendor Review, Inventory Management, Technical Writing, & Audit Prep
EXPERIENCE
Oct 2021-Oct 2023 Senior Cost Accountant, Contractor
Silgan Containers
Prepared journal entries for posting in JDEdwards/E1.
Reconciled inventory reports between outside processors and internal ERP (JDEdwards).
Setup manufacturing work orders from outside Processors into JDEdwards.
Prepared monthly forecasts of inventory levels and purchasing.
Tracked carrying, transportation, and spoilage costs of manufacturing materials.
Reviewed and corrected journal entries prepared by plant accountants.
Used Blackline and MS Excel (Vlookups, PivotTables, SumIf(s), Macros, and other data functions).
Prepared monthly account reconciliations.
Responsible for the monthly close process.
Prepared Bridge Reports comparing Actuals to both Budget and Forecasts
Apr 2021-Oct 2021 Senior Accountant, Contractor
Signode
Apr 2019-Apr 2021 Senior Cost Accountant, Contractor
ComEd/Exelon
Prepared journal entries for posting in PeopleSoft ERP.
Reviewed and corrected journal entries prepared by cost analysts and project managers.
Provided accounting support and direction to a large team of cost analysts and project managers.
Responsible for month end close process.
Prepared bridge reports comparing monthly financial results to trends, plans, forecasts, and budgets.
Used Blackline, Hyperion, and MS Excel (Vlookups, PivotTables, SumIf(s), Macros, and other data functions).
Prepared monthly account reconciliations related to customer deposits for construction.
Mar 2018-Apr 2019 Senior Cost Accountant, Contractor
Dean Foods
Prepared monthly reports of costs associated with the production of milk products.
Setup products in cost database based on Bills of Materials and other inputs.
Used JD Edwards, DMS, and MS Excel (Vlookups, PivotTables, SumIf(s), Macros, and other data functions).
Prepared journal entries during the monthly close for four production facilities.
Aug 2017-Mar 2018 Senior Cost Analyst, Contractor
Havi Solutions
Reviewed Budget to Actual results, analyzing, pricing, cost, and quantity variances.
Used JD Edwards, Hyperion, and MS Excel (Vlookups, PivotTables, SumIf(s), Macros, and other data functions).
Nov 2016-Aug 2017 Senior Accountant, Contractor
Nicor Gas
Wrote and posted journal entries using PeopleSoft ERP and Microsoft Excel
Set up capital projects and budgets in PeopleSoft ERP System
Prepared weekly and monthly reports using Microsoft Excel (PivotTables, VLookups, and other Data & Financial Functions.
Mar 2016-Oct 2016 Senior Accountant, Contractor
Devry Education Group
Reconciled 150 balance sheet accounts.
Responsible for monthly close using Lawson ERP System, preparing and posting numerous journal entries.
Prepared schedules for outside auditors
Responsible for CAPEX reporting during an employee leave of absence.
Prepared financial reports for Interstate Commerce Commission in preparation for litigation.
Responsible for Fixed Assets during employee leave of absence
Prepared Excel reports using VLookup, PivotTable, SumIfs, Goal Seek, and DatedIf functions in Excel.
Oct 2015-Mar 2016 Senior Accountant, Contractor
Follett Higher Education Group
Prepared commission calculations for 250+ college bookstores using standardized formats.
Prepared database of commission, rent, and other compensation reports in Excel using Vlookups and PivotTables
Prepared schedules for outside auditors
Prepared Excel reports using Solver, Goal Seek, and DatedIf functions in Excel.
May 2015-Oct 2015 Internal Auditor, Contractor
Jordan Knauff & Co Investment Bank/Energy Distribution Partners
Created account 70 reconciliations for 8 business units for periods going back 4-14 months utilizing QuickBooks & Excel (VLookUps, PivotTables, Hyperlinks, SumIf(s), and Formula Tracing functions)
Created 1,000+ Fixed Asset Database in Excel (VLookUps and DatedIf functions) by using compiled acquisition data of 8 business units
Prepared schedules for outside auditors
Prepared reports for parent company management
EDUCATION
MBA-Accounting
Northern Illinois University
MPA-Economics & Finance
Northern Illinois University
BS-Management & Political Science
Western Michigan University
LEADERSHIP
Served in capacity of acting manager on several occasions, mentored less experienced coworkers, and served as an officer in the US Army in a variety of leadership roles