Wei Jie Tan

data analyst

WP. Kuala Lumpur, Federal Territory of Kuala Lumpur, Malaysia

About

Experience

  • Portfolio Analytics and Reporting at OCBC
    May 2024 - Present · 2 yrs 2 mos

    - Prepare and maintain a monthly database for Commercial and Corporate Banking portfolios using data from multiple internal and external sources. - Uphold data integrity across systems to ensure consistency, accuracy, and reliability in reporting. - Prepare comprehensive credit and risk reports, including trend analysis and performance insights, for various stakeholders (Local Subsidiary, Group Office, C-suite, BNM, MAS) on a timely basis. - Develop, enhance and maintain monthly dashboards using Power BI, Excel Macros, and SAS to support business insights and track portfolio performance. - Participate in the data migration process from SAS to Python by validating datasets and aligning methodologies for Wholesale Banking portfolios. - Supported User Acceptance Testing (UAT) for system migration and data patching related to SME portfolios and credit scoring models. - Implemented an Early Warning Trigger Model by integrating CCRIS data, financial metrics, and other risk indicators to streamline the monthly credit review process and enhance efficiency. - Attend to other ad hoc assignments and projects assigned by immediate superiors.

  • Accounts Payable Analyst at Roche
    Oct 2022 - May 2024 · 1 yr 8 mos

  • Baker Hughes (Full-time · 1 yr 9 mos)
    • Inventory Analyst
      Jul 2021 - Oct 2022 · 1 yr 4 mos

      -Handling 11 Europe entities for Turbomechinery manufacturing specific in inventory analysis -Extraction of data mining -Analyse relavance inventory data by preparing monthly analysis report (slow moving inventory report, scrap analysis report, Wip aging report and intransit report) -Conduct quarterly reconciliation on general ledger and sub ledger (eg. opening/closing stock account, intransit account, WIP account) -Engage with local operation team to boost the aged inventory utilization -Review, approve, and analyse scrap inventory propose by operation team -Main liaison with internal and external auditor regarding stock related accounting -Continuous process improvement

    • Reporting and Statutory
      Feb 2021 - Jul 2021 · 6 mos

      -Extraction of data mining -Prepare ad-hoc/monthly reporting -Coordinator between local affiliate and kpmg auditors