Oracle ERP
Proven finance professional with extensive experience in ERP systems like Oracle and SAP, demonstrated at UNDP and Experian Marketing Services. Excelled in reconciliations and financial reporting, achieving significant process improvements and training initiatives. Skilled in Microsoft Excel and adept at fostering team collaboration, consistently delivering results beyond expectations. High performance team member by excellent results shown by being nominated on Financial Flyer awards every year while working in Experian Marketing Services.
REVENUE (Sep 2023 - PRESENT)
Achievements:
-Record and vet agreements signed by UNDP with internal & external counterparts are according to standard template set by Legal team & that revenue recognition is according to UNDP rules & regulations.
-Assisting the revenue team to reduce backlogs during the financial year end 2023 and during the first year end closure of the new Oracle ERP system migration.
-Assisting the team to train 3 new joiners in Revenue, providing offline & online training, even though just joined the team less than a year.
-Good relationship with country offices counterpart
BANK RECONCILIATIONS - HQ ACCOUNTS (Jan 2021 - Sep 2023):
Achievements:
-Successfully close B2B's month end reporting before the deadline of 10th every month for average of 80 bank accounts single handedly whereby previously HQ accounts were handled by 2 headcounts.
-Consistently kept B2B's dashboard green 90% of the time
-Participate in the roll out of new Oracle ERP to replace the previous People Soft ERP & identify any process improvements that can enhance the effectiveness of month end close process & daily tasks.
-Good relationship with HQ & UNV HQ counterparts & highly proactive in investigating any IT issues
ASSETS & INVENTORY (Jan 2018 - Dec 2020):
ASSETS:
Achievements:
- Collaborate with other team members in producing up to date Standard Operating Procedure (SOP) for Assets task (Disposal) and share the latest final version to the OSO team in New York.
- Prepare the monthly KPI Reporting for Global Process Owner's review.
- Proactively set up bi-weekly meeting to discuss team's progress and report preparation that shows the current Average Days Close (ADC), Weekly KPI and brainstorming session on resolving the outstanding cases.
- Actively participating in Oracle CX UAT testing before Go Live & contribute ideas and highlighted issues during conference meeting with OIST team in New York.
INVENTORY:
Achievements:
-Lead the team in processing the inventory certification data submitted by Country Offices & prepare Journals to post the inventory balances into Atlas.
-Providing guidance to UNDP Country Offices to ensure inventories data are submitted according to UNDP policies and guidelines.
-Provide training & guidance to assets team to fully deliver the inventory certifications within tight deadline amidst existing assets related tasks.
SERVICE CLEARING ACCOUNTS - SCA (Apr 2015 - Dec 2017)
Achievements:
- Manage to reduce the SCA rejects drastically from $1.9million (when first taking up the role in May 2015) to $181k (as at 3rd Feb 2017).
-Preparation of SCA rejects & SCA monthly reporting successfully sent every month without delay. Report sent in advance for Dec 2016 report, Mar, June, July, Sep & Dec 2017 reports.
-Provide training to new team members, send the 12a reconciliation template to agencies within dateline (17th February) & perform 2016 & 2017 12a reconciliation, whereby previously coordination task were handled by higher post NOB staff.
-Leveraging the newly created Agency Sharepoint portal to upload all monthly SCA reports, the Agencies & UNDP Country Offices updated email addresses and ensure all SOPs, Best Practice & reference documentations are uploaded on regular basis instead of sending monthly reporting via email which takes a lot of administrative work.
-SOP & Agency Handbook reviewed and updated regularly to reflect the current practice & to ease Agency in understanding the process better.
-Good teamwork with HQ counterpart
-Managing the Accounts Payable team for APAC region which includes Australia, New Zealand, India, Malaysia, Singapore, China, Hong Kong, Japan & UK/EMEA with 12 people in the team.
- Training new joiners & existing team members for any new processes.
- Manage the month end close process and resolving any End of Month issues within the country.
- Manage User Acceptance Test (UAT) projects for Oracle system customization / standardization and major Oracle R.12 upgrade.
- Key person for i-Expense issues within APAC region & liaise closely with Subject Matter Expert of i-Expense in USA.
- Process improvements.
- Ensure Audit and control takes place for the end to end AP process.
- Attended stakeholder meeting with each entities in APAC and discuss key points in enhancing & improving the Payables support from SSC.
- Monthly meetings with UK Global Payables team for Global standardization project.
- Involved in project planning and task migration for entities outside SSC moving in the accounts transactional task into SSC, working together with Procurement, IT & Finance leadership team.
Achievements:
- Standardization according to Global Process for i-Expense receipts submission using Imaging system.
- Automation of AMEX outstanding reminder being sent out from Oracle instead of manual chase.
- Setup within the team internal control & audit is in place & in 2013 Experian APAC SSC achieve green rating for internal audit.
- Successful Roll out of I-Expense and face-to-face training of I-Expense submission process (cash claim & corporate card claim) to Australian & New Zealand employees.
-Perform daily AP, AR, FA, Cash Management & Intercompany transactions using Oracle system
& liaise closely with Singapore & New Zealand country office Person In Charge.
-Ensure month end close are performed for all modules in Oracle (Except General Ledger) within the stipulated timeline.
ACHIEVEMENTS:
- Promoted from Associate Accounts Executive role to Accounts Executive within 4 months, promoted to Senior Accounts Executive after 1 year , and after 2 years plus promoted as AP Supervisor managing 12 staffs.
-One of the pioneer group that was employed to set up the first Shared Services Center (SSC) for Experian in Malaysia.
- Perform work shadow initially from the Melbourne SSC Team for 3 months before Go-Live, attend training via Live Meeting & tele-conference to ensure a smooth transition.
- Participate in Oracle UAT & ensure projects are successfully roll out for each of the process improvement Go Live, example: i-Procurement project for SG, Expense Express for SG & NZ, Asset Category Listing change to Global variance for SG & NZ, Imaging Project for NZ, Auto Bank Recon Project for SG & etc.
- Proven track record of stabilizing the transition of the migration work from Australia SSC to KL SSC quickly & effectively especially the country transactional processes (AP/AR).
- Received Financial Flyer awards nomination since November 2011 - 2014 without fail for every half year; nominations by business partner, client, managements & colleagues.
Was in a rotational role helping out various department:
2011:
-Accounts Payable & Fixed Assets
2010:
-Tax GL & Accounts Receivable (BP Shipcare Sdn Bhd)
2009:
-Statistical surveys for BP Singapore Ptd Ltd & Bank Negara Malaysia
-Ad Hoc supporting role for Reporting Accountant
Achievements:
-Bank accounts reconciliations are closed on timely manner.
-Reconciling all daily collections tally with sales report & credit collections report.
-Assist & guide sales admin staff at sales branches to resolve front end AR issues.
-Preparation of cash flow statements on weekly basis.
-Commission computation for external marketer before commission payout on every 20th of the month
-Proactively liaising with banks for any EDC machine problem located at sales branches.
-Follow up with Trustee bank for any trust account matters & attending query from internal/external auditor.
-Liaise with banks for any credit card disputes by member & provide relevant documentation to counter disputes.
-Supervise & train junior AR officer.
Achievements:
-Monthly accounts closing & financial/management reporting using MYOB software.
-Bank reconciliation & manage cashbook
-End to end Accounts Receivable process including credit collection & relevant debtors report.
-End to end Accounts Payable process including Telegraphic Transfer & Bank Drafts for overseas supplier.
-Monitor stocks received & stocks delivered.
-Inter-company transactions.
Shared Service Center Task Migration & Work shadowing
Reconciliations
ERP: Oracle, SAP, JDE, MYOB
Financial record keeping
Monthly Reporting
Microsoft Excel expertise
Oracle ERP
People Soft ATLAS
SAP
MYOB