Project Administrator (Excel)

Administrative Duties

1. Perform administrative duties of data entry, e-filing and data maintenance into the authorized and designated template, systems and websites timely
2. Organized, schedule, book meetings for financial matters, particularly budget and expenditure
3. 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)
4. Prepare documentations and reports
5. Ensure proper update and filling of Budget and Expenditure information and reports in an organized and structured manner
6. Budget Planning and Development
7. Support to collaborate with Project Managers, Operation Managers, relevant Vendors and stakeholders to develop detailed project budgets Daily/ Monthly/ Quarterly
8. Align budget planning with the scope, timeline and deliverables of the project

Financial Monitoring and Reporting

1. Update the relevant systems/spreadsheets daily/ weekly/ monthly to capture the budget and expenses timely and accurately
2. Track actual project expenses versus budgeted amounts monthly/ quarterly and yearly
3. Perform Data Analytics on the financial data and generate reports on expenses versus budget planned regularly for management
4. 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.
5. Prepare periodic financial reports including variances on expenditure and budget utilization
6. Work with stakeholders to ensure timely goods receipt and payment to vendors to complete the payment cycle within the financial year
7. Collect Goods Receipt and payment documents, PO, Certificate of Completion proof from stakeholders (e.g. PM, HR POC, etc)
8. File the Payment Receipts, Good Receipts and Certificate of Completion (COC) into the team website in an orderly and timely manner

Communication

1. 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)
2. 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
3. Communicate budget updates, differences or financial risks to stakeholders in a clear and timely manner

SKILLSETS REQUIRED

a. Proficient in Microsoft Excel using formula such as VLOOKUP, INDEX/MATCH, Pivot Table and/or Macro Programming knowledge (optional).

b. Proficient in Microsoft Office, such as creation of web pages, customization of Share point List and management of site permissions.

c. Proficiency in Microsoft Office, Excel, Power Point for creation of dashboards and presentation purposes for management.

d. Knowledge of Power BI or Tableau and Qlik Sense (optional).