Financial Analyst 3, Temporary Assignment
• BUDGETING AND FORECASTING: Worked with utilities operation to develop FY24 budget and forecast through FY28 of revenue, commodity expense, repairs and maintenance, salaries and benefits, and debt service. Entered all utilities budget model items in Oracle Hyperion Enterprise Planning and Budgeting Cloud Services financial system.• FINANCIAL MODELING: Prepared monthly utilities model and variance analysis including preparation of comments for operational and financial executive management. Used general ledger and project cost subledger to calculate revenue and expense as well as analyze transactions, trends, and balances by campus fund, account, and vendor.• ACCOUNTING: Performed utilities general ledger journal entries in Oracle Fusion Cloud and subledger for monthly reporting as well as to correct previous entries. Uploaded facilities management bills to record expenses. Prepared analysis for accrual journal entries. Researched general ledger and project cost subledger items to help campus customers understand transactions, recharge billings, and expenses.