Jian Liang Lew Email & Phone Number

Federal Territory Of Kuala Lumpur, Malaysia

-Responsible for the investment risk limit monitoring, fund performance analysis & attribution report preparation and presentation to fund managers & investment committee, Bloomberg CMGR rule coding on investment parameters & limits, Bloomberg AIM admin related maintenance.- Created multiple new report templates, which involved fund performance analysis and competitor analysis used in the investment team discussion. These involve the analysis and processing of thousands of rows of data… Show more -Responsible for the investment risk limit monitoring, fund performance analysis & attribution report preparation and presentation to fund managers & investment committee, Bloomberg CMGR rule coding on investment parameters & limits, Bloomberg AIM admin related maintenance.- Created multiple new report templates, which involved fund performance analysis and competitor analysis used in the investment team discussion. These involve the analysis and processing of thousands of rows of data and logic setting. Show less

Federal Territory Of Kuala Lumpur, Malaysia

-Main responsibilities included assisting fund managers in order execution, client & management report preparation, performance & economic analysis.- Wrote monthly and quarterly market reviews, prepared fund factsheets, assisted with private mandate performance & unit trust commentary for quarterly reports, and co-managed a local quantitative fund based on dividend yield strategy.-Reduced time usage from a full working day to 2 hours using VBA in the monthly rebalancing of an… Show more -Main responsibilities included assisting fund managers in order execution, client & management report preparation, performance & economic analysis.- Wrote monthly and quarterly market reviews, prepared fund factsheets, assisted with private mandate performance & unit trust commentary for quarterly reports, and co-managed a local quantitative fund based on dividend yield strategy.-Reduced time usage from a full working day to 2 hours using VBA in the monthly rebalancing of an international quantitative fund involving more than 100 private clients, improving efficiency and minimizing potential error due to time constraint. Show less

Kuala Lumpur, Federal Territory Of Kuala Lumpur, Malaysia

-Daily tasks involve the vetting of application documents, analysis and evaluation of application, and submission for review to credit analysts. I am mainly responsible for permanent credit line extension.-Notable achievements include above 95% applications are completed within our Service Level Agreement, 99% is the best record achieved, and highest credit line evaluated involves request for MYR 1 million.-Apart from contributing in terms of credit, I have also made significant… Show more -Daily tasks involve the vetting of application documents, analysis and evaluation of application, and submission for review to credit analysts. I am mainly responsible for permanent credit line extension.-Notable achievements include above 95% applications are completed within our Service Level Agreement, 99% is the best record achieved, and highest credit line evaluated involves request for MYR 1 million.-Apart from contributing in terms of credit, I have also made significant achievements in automation efforts by my department.-I mainly use excel, and vba that I learnt on my own. To date, I have created 4 excel macros that serve as mini programs which automate monthly tasks such as billing and management reporting. Show less

Selangor, Malaysia

- Performed daily Position Reconciliation, Bank & General Ledger Reconciliation, Collateral Transfers & Reconciliation, and uploading Bank Statements primarily using SAP and Microsoft Excel.- One of my major achievements during the internship is that I have created an excel worksheet involving excel functions and basic Visual Basic Advanced under the supervision of my manager and the help of team members in testing it. It replaced the previous procedures in the Business Process… Show more - Performed daily Position Reconciliation, Bank & General Ledger Reconciliation, Collateral Transfers & Reconciliation, and uploading Bank Statements primarily using SAP and Microsoft Excel.- One of my major achievements during the internship is that I have created an excel worksheet involving excel functions and basic Visual Basic Advanced under the supervision of my manager and the help of team members in testing it. It replaced the previous procedures in the Business Process Manual, and is still being used by my previous colleagues in performing their daily task.-The worksheet I have created reduced dependency on information to be provided by colleagues from other business units, effectively increasing accuracy up to 99% and decreasing time consumed by about 50%, eliminating the problems caused by human errors during month-end closure. Show less