1. Developing Qlik Sense dashboards for business users to monitor their performance2. Assist in developing future forecast figures for Operations KPI figures3. Create inventory trend reports to let management and sales teams understand inventory trends4. Communicate with the sales team about future vehicle production figures to ensure that the booking figures are reasonable5. Use Python and Excel VBA to automate existing process

Preparing quotation for customers

1. Conduct regular and ad-hoc analysis on inventory performance for different sales teams2. Extract data from Oracle database and maintain queries in Oracle system for regular and ad-hoc analysis3. Develop new templates and methodologies for inventory performance analysis4. Streamline existing process by amending or creating VBA and SQL codes5. Monitor and driving aging inventory performance

1. Conduct weekly sales performance analysis for different sales team and salesman of the group in term of sales order value and quantity2. Develop templates for calculation of incentives program and other analysis3. Conduct analysis on the sales performance for different types of products sold4. Streamline existing process by amending or creating VBA codes5. Conduct other ad-hoc analysis in order to support management decisions

1. Conduct weekly sales performance analysis for different sales team and salesman of the group in term of sales order value and quantity2. Develop templates for calculation of incentives program and other analysis3. Conduct analysis on the sales performance for different types of products sold4. Streamline existing process by amending or creating VBA codes5. Conduct other ad-hoc analysis in order to support management decisions

1. Conduct weekly sales performance analysis for different sales team and salesman of the group in term of sales order value and quantity2. Develop templates for calculation of incentives program and other analysis3. Conduct analysis on the sales performance for different types of products sold4. Streamline existing process by amending or creating VBA codes5. Conduct other ad-hoc analysis in order to support management decisions

1. Maintain client related data in the system2. Extract relevant data from databases by writing queries in Microsoft Access and making use of SQL3. Set up and maintain client commission and marketing fee schedule of clients

1. Tested the validity and accuracy of financial models handed in by different regional offices of the Group by making use of Microsoft Excel and debugging in VBA2. Generated Excel VBA coding used for scenario testing3. Assisted in generation of solvency capital requirement of different regions of the Group4. Liaised with Group Head Office in London for the testing of new system