Dan Fordyce

About Dan Fordyce

A creative and analytically minded Financial Planning, Forecast and Budget Analysis Manager with over 15 years of experience adept in creating reports tailored to fulfill ad hoc reporting needs related to Projects, Departments, Grants, Payroll Allocation, Hospital and Managed Care Metrics. and develops plans, budgets, and forecasts to enable the achievement of organizational strategic short and long-term goals. Utilize analytical ability to solve complex problems; takes a new perspective using existing solutions. Experienced Excel user with management of large quantities of data sets within Corporate Healthcare, Managed Care, and Higher Education industries. Created a shadow accounting system in Excel to manage $7.2 million-dollar budget, accounts payable and receivables, and over 250 projects allocated to 10 different Directors. This was completed within 3 months while managing current processes, and tied to the penny at the end of that fiscal year- TECHNICAL SKILLS - MICROSOFT OFFICE: Access, Excel - advanced (HLOOKUP, VLOOKUP, Pivot Tables, Formulas, Conditional Formatting, Data Validation, Hyperlinks, Functions, Slicers, Dashboards, etc.), Business Intelligence, Data Mining, Excel 365, Google Sheets, PowerPoint, Project, Visio, Word. SOFTWARE APPLICATIONS: JDEdwards, JIRA, Ariba, FileMaker Pro, Tableau, MediClick, Oracle Enterprise Management System Workspace - Fusion Edition, Oracle Hyperion Planning (HFM), Smart View to Hyperion Planning & Essbase, Kaufman Hall Budget and Hospital Advisor, ENUFF, Active Trader Pro / Think or Swim.

Experience

1. Information Technology Project Analyst

   City of Hope

   Apr 2023 — Present

   Reconcile $142 million budget and expenses monthly with General Ledger, allocate and track CAXEX / OPEX expenses by line item, account code, and PO number, for presentation executive reports. Prepare and submit invoices for Epic implementation in support of projects Analyze and develop financial information required to successfully support the CTCA COH Epic Project Analyze contracts, reports, and other department adhoc requests Submit and track accruals and expenses against the budget Maintain accurate allocation of 150 contractors’ expenses and contract duration

Education

• Belmont University

  BBA, Business Administration Management, Marketing, and Music Business