This position will support the production of the departmental analytical and financial reports.
Additionally, this position will participate in special projects as required.
Departmental Reporting
Upload the actual data from the GL system into the Infor budgeting system daily and update the transactional data for all operating expense and selected balance sheet accounts for use in analyzing daily account activity.
Assist in the monitoring of operating expense accounts in the Bank’s general ledger for accuracy and integrity of the transactions.
Prepare the necessary adjusting journal entries and advise other units of the Bank on operating expenses.
At month-end, support the preparation of analytical reports to the CFO such as operating expense variance analysis, allocation, and compliance expense analysis.
Monitor the project expenditures charged to the Lawson Project and Activity Accounting module for accuracy and integrity of the transactions that includes the capitalization of the projects and disposal of fully depreciated assets.
Also, advise managers in other units of the Bank on how to charge these expenditures correctly.
Publish the monthly project tracking reports that capture the actual vs.
budgeted project expenditures by Bankwide and Group.
At quarter-end, assist in the preparation of the service fee income analysis report.
Support the development, maintenance, and enhancement of analytical reporting tools for the preparation of financial reports such as revenue and expense variance analysis, and cost allocations.
Provide ad-hoc reports for the managers of the department to be used when preparing in-depth analytical reports.
Participate in special projects as requested by the CFO or other senior managers of the Bank.
Annual Budgeting and Forecasting
Participate in the development of the annual business plan and forecast, including the review of the baseline operating expenses and service fees revenue submissions in the Infor Budgeting and Reporting application.
Participate in the review of new projects that were submitted in the ServiceNow project module.
Assist in the development of the annual capital forecast for the current year and in the development of the forecasted and planned depreciation expenses by cost center.
Participate in the preparation of the budget packages for group heads review and the Board of Directors’s approval.
Maintain and update the operating expense reports that query the data from the Bank’s budgeting and reporting application, and prepare the operating expenses report by business units, by line items, and by trend reports (actual vs.
plan and forecast vs.
plan).
Assist in developing the activity codes and account categories for approved project expenditures to be loaded into the Lawson Project and Activity Accounting module.
Applications Maintenance and Enhancement
Participate in the maintenance of the Infor budgeting application.
Assist in the maintenance and enhancement of Infor Lawson Project & Activity Accounting (AC) and Asset Management (AM) applications.
Participate in the implementation of the new Workday ERP and Workday Adaptive Planning systems.
Salary: $100,000 - $115,000
Skills: