Donald P. Royal
Arlington, TX 76017
H: 817-***-**** C: 903-***-****
Email: ******.*****@*********.***
CPA: MD 26121 (ACTIVE)
SUMMARY
A seasoned Financial Analyst/Project Controller with over 13 years combined
experience in the Commercial Services and Public Services (Federal
Government DoD) sectors seeking a position utilizing in-depth knowledge of
Financial Analysis, Accounting, Project Control, and Information
Technology.
WORK HISTORY
Bearingpoint, Inc.
Sr. Financial Analyst/Project Controller (Commercial Services)
2006 to 2009
. Involved in the review/audit of financial binder information for
various CS Contracts/Projects.
. Knowledge of Project Management, Internal Financial Software and
Database Programs required.
. Advanced Excel Spreadsheet skills required such as creation of Pivot
Tables, Charts and other financial models to provide reports such as
variance and trend analysis as well as other ad hoc reports as needed.
. Creation of Estimate-To-Completes (ETCs), Spend Plans (Forecasts), and
other project control documents for the Engagement Teams.
. Auditing and Reconciliation of Timesheet/Other Direct Cost (ODC) Data.
. Accounts Payable, Accounts Receivable reconciliation and Invoice
overview.
. Responsible for in-house training on new procedures and software.
. Ensured compliance with contract terms and obligations.
Unisys Corporation
Financial Analyst/Project Controller (Public Services - DoD)
**1996 to 2006
Involved in all aspects of project control which in part includes the
following:
. Monthly/Quarterly/Yearly Forecasting and Budgeting.
. Creation of Project Status Reports (PSR).
. Creation of Work Breakdown Structures (WBS).
. Auditing and Reconciliation of Timesheet/Other Direct Cost (ODC) Data.
. Advanced Excel Spreadsheet skills required such as creation of Pivot
Tables, Charts and other financial models to provide reports such as
variance and trend analysis as well as other ad hoc reports as needed.
. Creation of Estimate-To-Completes (ETCs), Spend Plans (Forecasts), and
other project control documents for the Engagement Teams.
. Experience in writing of JAMIS database queries utilizing
OMAR/IMPROMPTU (Oracle).
. Required knowledge of FAR, CAS, and JTR.
. Accounts Payable, Accounts Receivable reconciliation and Invoice
overview.
. Beta Testing for internal Business Objects Support System (BOSS).
Federal Government Group's primary forecasting and management tool.
Responsible for reporting on the look and feel of all BOSS user
interfaces and their conduct.
**Also worked for 4 months during this time for a CPA Firm as an Audit
Supervisor (11/98 - 3/99), Mitchell and Titus in Washington DC, after
which I returned to Unisys.
CommonWealth One Federal Credit Union
Accountant 1993 to
1996
Involved in all aspects of Credit Union Accounting which includes in part
the following:
. Preparation of financial statements to include Statement of Income,
Statement of Financial Condition, and Statement of Changes in Equity.
Also the Budget vs. Actual, Investment Schedule, Operating Expenses
and Treasurer's Report.
. Reconciliation of bank statements, including the corporate account,
and various ATM and mortgage accounts.
. Experienced in all aspects of General Ledger reconciliation, input and
preparation.
Bally's Total Fitness Centers
Corporate Account Executive 1988
to 1993
Involved in general operation of the health clubs including the following:
. Responsible for auditing of transactions and cash handling.
. Evaluated, developed and presented corporate health and fitness
program packages.
Executive Life Insurance Company
Supervisor/Senior Analyst 1984
to 1988
Involved in all aspects of Insurance product servicing including the
following:
. Trained personnel in concepts of premium, pour-in, and save-plus
applications through Life-70 and KeyMaster systems and in the
fundamentals of cash clearing.
. Audited and reconciled detailed suspense accounts.
. Prepared end-of-month closing journal entries.
Jim Dandy Fast Foods, Inc.
Office Manager 1982 to
1984
. Responsible for the general operation of the corporate office.
. Required the supervision of a staff of 4 assistants.
. Duties included but not limited to the handling of Accounts Payable
and Payroll for the corporate office.
EDUCATION
B.S. Business Administration (Accounting), University of Maine at Orono
B.A. Performing Arts (Theater), University of Maine at Orono
From 2003 to 2005 I attended Graduate School at George Mason University,
Fairfax VA and worked on a MSCS/Software Engineering degree but did not
complete.
CERTIFICATES/LICENSES
Certified Public Accountant (CPA)
SKILL SET
MS Office (Word, Excel, PowerPoint, Project, Access, etc.), Hyperion
Enterprise, PeopleSoft, Earned Value Management (EVM), Crystal Reports,
MicroStrategy, SAP ERP, Deltek/CostPoint, Micro-Frame Program Manager
(MPM), C++ Programming in a Unix Environment, and Visual Basic 6.0.