Project Manager

• Jun 2020 - Present

Applied Analytics & Big Data and Data Platform Applied Analytics & Big Data and Data Platform

Manager I - IT Application

• Jan 2019 - May 2020

Senior IT Engineer

• Aug 2013 - Jan 2019

• Qlikview – Sole Contributor of Business Intelligence Development - Designing and creating interactive dashboards and graphs to analyse important business data: sales, inventory, purchase and finance etc. Create complex data presentation using set analysis, such as profit and loss statement, purchase costing down analysis etc. - Checking and verifying users’ queries about the data to ensure that data and dashboards are telling the truth. The Dashboards are used by senior management on weekly operational / sales meetings- Coding Qlikview scripts to carry out data extraction from various sources such as Microsoft SQL Server (Microsoft Dynamics AX), SAP system (SAP HANA database), Microsoft Excel (Budget). transform data into consistent dimensional modelling- Managing Qlikview server, including: setup and migration Qlikview services to another server, data refresh scheduling, license and user access assignment- Communicate with senior management to gather requirements and feedback to identify areas for system improvement- Pioneered implementation of Business Intelligence (BI) solutions within the company by researching different BI approaches and software, and creating demo to build data flow from source data into data that is suitable for analysis • SAP ERP and HANA- Administration of SAP Business Warehouse 7.4(BW), ensure process chain execution as scheduled, troubleshooting any error occurred and fine-tuning to improve performance- Overseeing SAP HANA daily performance, setting up new Linux server with High Availability on SAP HANA for testing- Support Business Development, Production and Shipping department on label designing and printing from SAP using OpenText StreamServe- Support SAP Integration with HSBC Host-to-Host auto payment using Axway Activator for Singapore, Malaysia and China- Went through 1-month SAP functional modules training in classroom provided by implementation vendor IBM Show less

Senior System Analyst

• Jul 2007 - Aug 2013

• Microsoft Dynamics AX 2009 Implementation and Support - Worked in team of 6 to implement Microsoft Dynamics AX2009 solution for Singapore subsidiary. - Studied user requirements and new system; performed gap-fit analysis; assisted consultant with UAT, user training and data migration; managed user requests and created best practices - Provided functional & technical support including system administration and hotfixes testing for Microsoft Dynamics AX2009; liaised with consultant for issues raised, testing and verification • In-house ERP system development and support - Responsible for full spectrum of in-house ERP system development using PowerBuilder - From gathering user requirements to analysis and implementation of solutions, with oversight of financial modules covering AR, AP and GL functions - Developed new ERP system functions and configured system for new users and requirements - Liaised with and provided ERP system support to users from associated and subsidiary companies across Southeast Asia and Greater China - Supported month-end closing for group of companies, including financial ledger reconciliation, checking for variances between sub-ledger and General Ledger - Development of sales analysis reports using Qlikview by extracting data from in house ERP system Show less