Don Royal Email & Phone Number

Frisco, Texas, Us

Dallas, Texas, Us

U.S. Anesthesia Partners (USAP)Senior Financial Analyst/Programmer July 2013 to July 2020Company provides Healthcare and Financial Services for various Hospitals and Medical Centers within the United States. Corporate Office located in Florida. I worked in the Dallas Office which covered DFW and Oklahoma.• Provided ACCESS and EXCEL based Applications (using VBA and SQL) used in generating monthly, quarterly, and yearly reports.• The following is a partial list of some of the reports provided:o Case Logso Graphso Reconciliationso Revenue/Costo Statisticalo Utilizations• Created ADHOC reports as needed.• C# Programmer for intracompany billing analyzer. Providing maintenance updates and expansion as needed.

Contractor for Timberhorn IT Solutions (Staffing Agency) working for ALCON Laboratories, Inc. (a division of Novartis) April 2013 to June 2013Senior BPA Financial AnalystGlobal Franchise Support (Pharmaceutical, Surgical, Vision care, and Digital Marketing) - involved in the following:• Budget and Forecast Report creation and automation.• Advanced Excel Skills requiring Pivot Tables, V-Lookups and H-Lookups, Linking, as well as being able to incorporate Essbase (add-in) into the reports.• Short term assignment to streamline the Budgeting and Forecasting process.• Incorporated Purchase Order Reports (Open and Committed) utilizing J.D. Edwards and Showcase to aid in the accrual process.• Developed a management tool that incorporated all information above into one report.

Bethesda, Md, Us

Contractor for DCR Workforce (Staffing Agency) working for Lockheed Martin, Missiles and Fire Control (MFC) Division October 2011 to August 2012Senior Financial Analyst/Sr. Computer Finance SpecialistTactical Missiles – Finance area involved in the following:• Life Cycle Launcher Support (LCLS) and International Contract Support• Provided reporting and Financial Analysis to Program and Contract Area Managers as well as to Government and Commercial Clients. Some of the reports provided were:o Project Control (PCRs)o Contract Trackingo Target – Baselineo Profitabilityo Rate Impactso Quarterly Contract Status (CSRs)o Variance Analysis• Knowledge of various financial applications required, such as EFS, SAP, ADAS and ECE.• Advanced Excel skills requiring Pivot Tables and Charts.• Interface with and adequate knowledge of multi-functional areas required as well as the ability to effectively communicate within these groups.• Required basic working knowledge of EVMS

Company provided Logistics and Training Services for various government clients.• Involved in the creation of the Senior Program Manager Financial Package which included Job Summary Reports, Trend Analyses, Monthly and Bi-Weekly Labor Reports, and other ad-hoc reports for program and project managers along with the analysis of those reports.• Started the creation of a PCO (Project Control Department) where one was not in place before.• Advanced Excel skills requiring Pivot Tables and Charts.• Knowledge of various financial applications required, such as DELTEK/Cost Point and Impromptu/Oracle.• Work required working remotely (from home) and quarterly visits to the corporate office in Lawton, Oklahoma.

Menlo Park, Ca, Us

• During this time primarily involved in providing research and reporting during DCAA (Defense Contract Audit Agency) audits for various government contractors (Example – AECOM). Work was short term and temporary in nature.• Knowledge of various financial applications required, such as DELTEK/Cost Point.• Advanced Excel skills requiring Pivot Tables, V-Lookups, and Charts.

Amsterdam, Nl

Commercial Services• 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..

Blue Bell, Pennsylvania, Us

Public Services (DoD)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.

Alexandria, Va, Us

Involved in all aspects of Credit Union Accounting which included the following:• Preparation of financial statements to include Statement of Income, Statement of Financial Condition, and Statement of Changes in Equity.• Also involved in the creation of other reports such as the Budget vs. Actual Variance Report, Investment Schedule, and Treasurer's Report.• Involved in the reconciliation of bank statements, including the corporate account..• Experienced in all aspects of general ledger reconciliation, input and preparation.

Ba, Performing Arts - Theater

M.S. Computer Science - Software Engineering

Bs, Business Administration - Accounting