Senior Data Analyst

• Mar 2021 - Present

Data Analyst

• Mar 2018 - Feb 2021

• Migration of CBG functionalities from legacy systems to new platform •Involved in design and development of various reports to manage the Treasury and Liquidity of the Bank• Liaise with Internal Stakeholders (SG and overseas) for any enhancements based on the portfolio/entity changes• Build Reports to get a understanding of the daily positions of Wholesale funding• Design a report to understand the standings of the HQLA• Generate Diligent Monitoring Apps to understand the various trends like Value Same Date Deals, Cancel/Reissue and to maintain optimum balance to avoid overdrafts

Business Intelligence Analyst

• Mar 2017 - Dec 2017

• Involved in IT Support for the monthly MIS Reporting for the Singapore entity of OCBC Bank• Liaise with Internal Stakeholders for any enhancements• Preventive measures and code fixes for rare and unforeseen data scenarios• Design and implement the flow of new source systems to include in MIS-Reporting and reconcile with GL • Involved in IT Support for the monthly MIS Reporting for the Singapore entity of OCBC Bank• Liaise with Internal Stakeholders for any enhancements• Preventive measures and code fixes for rare and unforeseen data scenarios• Design and implement the flow of new source systems to include in MIS-Reporting and reconcile with GL

Data Specialist

• Jul 2015 - Feb 2017

Undertand and draft a model to cater to the Finance team to generate a Management dashboard reports for the trend analysis , perfomance of RMs and so forth.To develop a Management Dashboard to analyse and understand the Targets and the Actual achieved for the Relationship Managers for the PB and TPC customers for the SG and HK region• Reports for the Local & global Rank to understand the performance of the RM• Participate in business requirements meetings and Sign off data elements and business rules• Explore the SMBB Architecture for User Enhancements and requirement changes• Liaise with the Architecture and Modelling Teams to bring in new data elements required for the project• Development of the Initial code and Functional Spec document as per the business rules specified• Develop the code through the SDLC and assist to test it across all the phases• Involved in the Unit testing of the codes and craft the changes in the code according to functional changes in the requirement

Datawarehouse Consultant

• Nov 2014 - Jul 2015

Automation of the existing process and Development of the new Monthly Risk report Generation for the Business Users .• Customized Reports for Retail Credit Risk• Customized Reports for Wholesale & Investment Credit Risk• Promote knowledge development on usage/extraction of data for analysis and ad-hoc reporting• Setup the Automation process for the Monthly reports generated manually.• Developed and delivered the ad hoc reports using the Teradata 14, and monitor to cater the needs of Business Users for monthly reports• Participate in business requirements Workshops and Agree on Report Layout• Ensure data reconciliation with the User figures against various parameters and any ambiguities duly reported• Assisted in project to implement a centralized data mart for group risk which have data from 14 different countries

Project Associate

• Mar 2014 - Oct 2014

• Design and build Data warehouse and Downstream Application as per the business requirements• Responsible for the Data Extraction, Transformation Logic changes and Loading from Source to Target Applications• Prepare Test plans to ensure the Referential Integrity and data correctness as per the business requirement• Involved in the performance Tuning for the complex business scenarios • Design and build Data warehouse and Downstream Application as per the business requirements• Responsible for the Data Extraction, Transformation Logic changes and Loading from Source to Target Applications• Prepare Test plans to ensure the Referential Integrity and data correctness as per the business requirement• Involved in the performance Tuning for the complex business scenarios

ETL Consultant

• Jun 2013 - Jan 2014

• Design and build Data warehouse and Downstream Application as per the business requirements• Responsible for the Data Extraction, Transformation Logic changes and Loading from Source to Target Applications• Prepare Test plans to ensure the Referential Integrity and data correctness as per the business requirement• Involved in the performance Tuning for the complex business scenarios • Design and build Data warehouse and Downstream Application as per the business requirements• Responsible for the Data Extraction, Transformation Logic changes and Loading from Source to Target Applications• Prepare Test plans to ensure the Referential Integrity and data correctness as per the business requirement• Involved in the performance Tuning for the complex business scenarios

Software Engineer

• Jul 2010 - Feb 2013

• Design and build Data warehouse and Downstream Application as per the business requirements• Responsible for the Data Extraction, Transformation Logic changes and Loading from Source to Target Applications• Prepare Test plans to ensure the Referential Integrity and data correctness as per the business requirement• Involved in the performance Tuning for the complex business scenarios • Design and build Data warehouse and Downstream Application as per the business requirements• Responsible for the Data Extraction, Transformation Logic changes and Loading from Source to Target Applications• Prepare Test plans to ensure the Referential Integrity and data correctness as per the business requirement• Involved in the performance Tuning for the complex business scenarios