Administrative Duties
• Perform administrative duties of data entry, e-filing and data maintenance into the authorized and designated template, systems and websites timely
• Organized, schedule, book meetings for financial matters, particularly budget and expenditure
• Coordinate with various departments such as Project Managers, Operation Managers, Vendors and stakeholders to support management in developing the detailed accurate and updated expenses vs budgets regularly (monthly/ quarterly/ annually)
• Prepare documentations and reports
• Ensure proper update and filling of Budget and Expenditure information and reports in an organized and structured manner
• Budget Planning and Development
• Support to collaborate with Project Managers, Operation Managers, relevant Vendors and stakeholders to develop detailed project budgets Daily/ Monthly/ Quarterly
• Align budget planning with the scope, timeline and deliverables of the project
Financial Monitoring and Reporting
• Update the relevant systems/spreadsheets daily/ weekly/ monthly to capture the budget and expenses timely and accurately
• Track actual project expenses versus budgeted amounts monthly/ quarterly and yearly
• Perform Data Analytics on the financial data and generate reports on expenses versus budget planned regularly for management
• Ability to identify variances on expenses, budget utilization vs budget forecast.
Work with stakeholders to establish legitimate reasons of budget variances and update line manager accordingly.
• Prepare periodic financial reports including variances on expenditure and budget utilization
• Work with stakeholders to ensure timely goods receipt and payment to vendors to complete the payment cycle within the financial year
• Collect Goods Receipt and payment documents, PO, Certificate of Completion proof from stakeholders (e.g. PM, HR POC, etc)
• File the Payment Receipts, Good Receipts and Certificate of Completion (COC) into the team website in an orderly and timely manner
Communication
• Handle queries and manage all form of correspondences with stakeholders, being the Point of Contact team, for all budget-related information with project teams and stakeholders (internal and external)
• Support management by organizing meetings with project Point of Contact to review financial performance regularly in order to produce accurate and up to date budget plan and expenditure reports
• Communicate budget updates, differences or financial risks to stakeholders in a clear and timely manner
SKILLSETS REQUIRED
• Proficient in Microsoft Excel using formula such as VLOOKUP, INDEX/MATCH, Pivot Table and/or Macro Programming knowledge (optional).
• Proficient in Microsoft Office, such as creation of web pages, customization of Share point List and management of site permissions.
• Proficiency in Microsoft Office, Excel, Power Point for creation of dashboards and presentation purposes for management.
• Knowledge of Power BI or Tableau and Qlik Sense (optional).