Joel Trajan T.

CA (Singapore) | CMA | Public Finance

Singapore

About

A curious and motivated individual with experience in cash management, audit, and process improvement, keen to apply data, technology, and practical solutions to improve efficiency and tackle real-world challenges. Continuously exploring new tools, coding, and ways to contribute positively while learning and growing through hands-on experiences.

Experience

  • Accountant-General's Department (Full-time · 4 yrs 1 mo)
    • Assistant Director (Cash Management & Payments)
      Jul 2023 - Present · 3 yrs

      Responsibilities - Support Central Liquidity Management (CLM) by managing and investing surplus cash for statutory boards, optimising returns through prudent liquidity and cash management. - Manage and oversee CLM’s banking counterparties, including counterparty risk assessment and relationship management. - Drive process improvements and automation initiatives to enhance operational efficiency and accuracy. - Manage vendor records to ensure consistency, completeness, and timely resolution of queries. - Undertake additional responsibilities as required Achievements - Reviewed and operationalised an enhanced counterparty risk framework, strengthened internal reporting, and refined the liquidity and funding management approach. - Led the activation of a bank account sweeping arrangement, expanding banking access for statutory boards and improving liquidity efficiency. - Expanded CLM’s banking network by evaluating and onboarding two new banking partners, strengthening diversification and resilience. - Streamlined vendor record management by consolidating fragmented practices into a standardised and controlled framework.

    • Finance Associate Program
      Jun 2022 - Jun 2023 · 1 yr 1 mo

      - Reviewed and analysed post-payment reconciliation processes with multiple agencies, identifying opportunities to improve efficiency and financial controls. - Prepared data-driven insights and recommended automation solutions using VBA and UiPath, reducing time spent on routine tasks such as fund placements and journal entry postings. - Assisted with audit and assurance work on service procurement compliance.

    • Associate
      Jul 2022 - Jan 2023 · 7 mos

      - Supported daily operations including fund catering and fixed deposit placements, maintaining near-zero error rates. - Developed VBA Macros to partially automate repetitive tasks, saving 15–30 minutes daily. - Analysed performance benchmarks to identify opportunities to enhance operational evaluation. - Explored UiPath automation for journal entry postings to streamline manual processes.

  • Senior Executive (Audit & Assurance) at Ministry of Home Affairs Singapore
    Feb 2023 - Aug 2023 · 7 mos

    - Conducted audits on service procurement compliance, applying payment analytics to improve audit quality. - Supported a Power BI dashboard trial to visualise post-audit feedback.

  • Consulting Intern (Technology Risk) at EY
    Dec 2021 - Jan 2022 · 2 mos

    - Assisted IT audits on Access and Change Management processes under ITGC standards. - Utilised Alteryx to perform journal entry testing, improving audit accuracy and efficiency.

  • BDO LLP Singapore (Singapore, Singapore)
    • IT Audit Senior Associate
      Mar 2021 - Aug 2021 · 6 mos

      - Streamlined journal entry testing using CaseWare IDEA scripts, reducing execution time by 20–50%. - Performed IT General and Application Control assessments, reviewed Technology Risk Management notices, and conducted data analysis on procurement, payroll, and income, identifying control issues and recommending improvements.

    • IT Audit Associate
      Sep 2020 - Feb 2021 · 6 mos

  • IT Audit Intern at BDO LLP Singapore
    Jun 2020 - Jul 2020 · 2 mos