Business Analyst - IT Systems & Finance BI

• Dec 2020 - Present

SAP, Project management of SAP upgrade & module implementation, AWS cloud, AWS Redshift, Streaming ETL/ELT, Python BI, Apache Spark, Cloud Integration, SQL, Angular Framework, Web Development for BI reporting, XML, XSLT, Databricks, Machine Learning, Data Science, Data lake, Azure Cloud, Azure Solution Architect, MongoDB, Cloud Integration, Global Logistics, Financial Report Consolidation. Cloud IT infrastructure. Postman Testing, A/B testing, System Implementation. BPMN modelling, Tech documentation. Requirement Analysis & Management, DevOps, IT audit. Show less

Business Analyst - Global Logistics & Finance

• Dec 2019 - Jul 2020

Work in Alibaba Group Logistics subsidiary as a commercial & IT system advisor on reviewing pricing and approving commercial contracts; Perform business analysis and write requirement documents (MRD & PRD) to facilitate web development & continuous process improvement on global logistics billing & finance system, global fulfillment system and custom system; Translate business operations into GL accounts mapping and design & implement BI reporting with advanced SQL skill; Promote teamwork culture to accounts receivables, payables, billing and accounting team. Show less

Financial Controller

• Nov 2016 - Nov 2019

Work as a business transformer on finance; Perform due diligence and create normalization reports & business case for acquisition & merge decisions; Audit & analyse financial performance of SME; Enable business merge, divestment, group consolidation, cloud based finance transformation and further M&A to support expansion & development. Successfully migrate GL, AR, AP, Payroll, 3 Way Financial Reporting & Budgeting from MYOB to Xero Ecosystem; Prepare Bank Covenant reporting and Q&A; Build structured finance operation team and improve governance & finance functions. Show less

IT Project Manager

• Nov 2016 - Nov 2019

Implement Xero Ecosystem enabling a cloud based finance operation. Empower the business with biometric clocking system integrated with Payroll, credit check system minimizing SME trade credit risks and smartphone based expense management system. Also implement cloud ERP system on a group level with custom built intelligence module via REST API enabling inventory management process. Project manage Fleet Management system implementation and enable Logistics Tracking & better operation management. Upgrade telecommunication system with implementation of Office365, establish centralised group network and migrate landline telephone PBX to cloud based hosting system. Show less

Business Analyst - Global Supply Chain & Finance

• Aug 2015 - Nov 2016

Work under supply chain department analysing global supply chain modelling & financial performance. Analyse warehouse operations, reduce waste & improve DIFOT performance; Design & implement both financial & non-financial KPI reporting for warehouses, international freight and 3PL. Also assist establishing shipping team process compliant with accounting standards through journal data cleansing and enhancing ABC costing model. Build a full set of management financial reports for ELT and redesign & prepare group board reports. Show less

Assistant Accountant - JDE ERP Systems

• Dec 2011 - Aug 2015

Work on JDE system primarily focusing on integration with business operation systems. Administrate Promaster expense management system; Assist implementation of Retail Direct retail sales ERP system and audit GL sales data; Map GL accounts with BCP channel indicators and automate banking journals & accounts reconciliation. Proudly plan, design, develop and implement VBA based banking & reconciliation reporting system; Provide solutions for international FSSC team in regards to accounts payable & GL systems integration with NZ, UAE and HK branches. Achieve on auditing GL accounts and identifying large volume of system errors journals; Successfully implement JDE fixed asset and recurring payment module; implement BI reporting & training on banking & reconciliation, advanced expense management & global fixed asset management. Show less

Accounts Receivable Administrator

• Sep 2011 - Dec 2011