Sign in

Project Management Accounting

Downers Grove, IL
March 19, 2018

Contact this candidate


Douglass C. Young

**** ******** ***

Downers Grove, IL 60515

708-***-**** (Cell)

Key Accomplishments

Wrote manuals related to the monthly close process, daily operating procedures, journal entry procedures, fixed asset management, budgeting, and financial statement preparation

Developed and maintained 20 monthly charts and graphs for management reporting

Conducted the entire monthly close process for both a US and Canadian company, reducing it by 20%

Excel 2003, 2007, & 2010 proficiency includes pivot tables, vlookups, index/match, macros, graphs, linking, and database functions

Professional Experience

Contract Accountant June 2009 – Present


Successfully completed multiple long term assignments at large companies

Reconciled bank accounts in a variety of international currencies using PeopleSoft and Excel 2010

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).

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

Aided in the transition from PeopleSoft to WorkDay ERP, validated account balances during transition, mapped new account, cost center, and other general ledger relationships

Reconciled 600 customer accounts for the Credit and Leasing department to determine the eligibility of customer refund per FDA guidelines

Responsible for CAPEX reporting during an employee leave of absence.

Prepared financial reports for Interstate Commerce Commission in preparation for litigation

Bank reconciliations using Trintech’s Reconnet bank reconciliation software

Created management facing dashboards for 30 locations in Excel with downloaded data, using SUMIFS, INDIRECT, PIVOT TABLE, VLOOKUP, and GOALSEEK, and FORMULA AUDITING functions

Reconciled 120 Balance Sheet accounts going back 6 months on each using PeopleSoft general ledger system

Fixed Asset & General Ledger Accounting using PeopleSoft

Created 40 account reconciliations related transitioning 7 subsidiaries on to SAP

Researched and analyzed purchase orders, invoices, and leases to calculate the refund required to be given to customers for the recalled of medical equipment

Coordinated with Purchase, Sales, Marketing, Finance and Accounting divisions to determine the appropriate remuneration package for customers

Utilized MS Access Database queries to track equipment locations

Tracked the status of over 200,000 devices by creating an Access 2007 database

Managed and documented procedures for large capital projects using SAP’s Fixed Asset and Project Management Software

Prepare s weekly reports tracking over 400,000 recalled devices using Access 2007

Reviewed and wrote reports related to customer contracts in order to determine product recall remuneration

Created pivot tables and journal entries to change the corporate sales reporting structure from region to plant level, increasing the accuracy of reporting by 50%

Created reports related to fixed assets at the request of auditors, working closely with auditors to answer any questions

Supervised and reviewed all accounting related to major capital projects and fixed assets reducing report preparation time by 50%

Maintained corporate wide fixed asset system, adding, disposing, and tracking over 10,000 assets in 25 locations

Setup $8M in new fixed assets from SAP’s Project Management System

Oversaw the Project Management and Fixed Asset portions of an SAP software upgrade, including all functional and integration testing, as well as validating results

Prepared cash sweeps for over 40 banks twice a week, making related journal entries into GL system reducing task time by 50%

Reconciled four bank accounts daily and provided reports on cash-flow, reducing preparation time by 50%.

Participated in monthly close activities, including accruals, allocations, journal entries, and financial statement preparation, reducing time by 25%

Senior Accountant November 2007 – May 2009


Plastics and Distribution Industry

Wrote manuals related to the close process, journal entry procedures, and financial statement preparation

Conducted the entire monthly close process for both a US and Canadian company, reducing it by 20%

Achieved 20% reduction in leased car costs

Reconciled 30 balance sheet accounts monthly, maintaining accrual, prepaid expense, and reserve accounts on the balance sheet

Coordinated first ever corporate wide budget initiative

Created general ledger accounts, general ledger system reports, all of which were integrated into the monthly reporting process

Prepared monthly bank collateral reports for both US and Canadian companies for banks in both countries

Worked closely with outside auditors to prepare audit schedules and answer questions

Contract Accountant February 2007- November 2007

UTILITIES, INC., Northbrook, IL


Participated in monthly close activities, including accruals, allocations, closing entries, and financial statement preparation, reducing monthly close by 30%

Coordinated compilation of regulatory reports for ninety companies reducing filing costs by 10%

Put together monthly corporate reporting packages to be distributed throughout organization reducing preparation time by 50%

Senior Accountant November 2004 – February 2007


Consumer Goods

Wrote manuals for use by corporate staff for the uploading of journal entries into Baan GL System used company wide

Participated in monthly close activities, including accruals, allocations, closing entries, and statement analysis, provided administrative guidance to Accounting Staff, reducing time required by 15%

Provided headquarters accounting support for 14 – 20 retail locations

Senior Accountant July 2002 – November 2004



Accountant September 1999 – June 2002


Software & Accounting Skills

MS Access (07 & 10) SAP Journal Entry Preparation

MS Windows Fixed Asset Management Lawson

MS Excel (10, 13, & 16) Policy Documentation Account Reconciliation

Oracle/Peoplesoft JD Edwards Month End Close


Masters of Business Administration-Accounting, Northern Illinois University, 1999

Masters of Public Administration-Economics, Northern Illinois University, 1994

Bachelors of Science-Political Science & Management, Western Michigan University, 1990

Contact this candidate