WEBEAA is consumer-based loans (Personal loan & credit cards, housing/mortgage/renovation/educational loans) for the bank’s loan origination system. Responsibilities: • Enhanced the WAA system to perform customer to Fund Transfer for Cards and Creditable through Internet/Mobile Banking (Completed online application from IB/MB will be further process in WAA for AA creation). • Enhanced the WAA system to implement the Credit Policy exception checklist (MAS regulation) process • Enhanced the system to download the AAs from Credit Card Outsourcing staging system (CCOS) • Playing a major role to create the new Environment (infrastructure) for WAA (SIT/UAT/Pre-prod/production) during windows severs 2008 R2 standard migration (Oracle web logic severs installation, cluster creation and deploy the Waa application successfully in new environment). • Enhanced the system to download the AAs from Credit Card Outsourcing staging system (CCOS) • Enhanced the system to implement email notification for the overdue AA based on lending units. • Design and implementation of flat file extraction for data warehouse module (DWH). • Coordination with sub system owners to get the necessary approval for FSD, release related checklists and post implementation review approval. • Communication with SEMA, SIBS, BWCIF team for interface related issues.
2016-2 - 2017-9
CBES (Credit bureau exchange system), Maybank Singapore
Credit bureau exchange system (CBES) is a system to basically check the customer credit worthiness and derive the scoring and accordingly approve cards and disburse loans. Responsibilities: • Involved in CBES Monthly extraction for Regular, outstanding balance, credit exceeds and credit limits, bad dept Records and upload to credit bureau Singapore every month using MQ JMS Provider. • Enhance the existing cbes system to include the file download features to make easy to download and view the balance sheet • Creating new batch job to extract the user requested data in CBES system. • Involved in delete the old ERROR enquiry to help the user to re-trigger the new enquiry for the customer. • Responsible for file processing in UAT for any change in the SIBS SFTP conversion. • Involved in handling CBES Enquiry production issues
2016-2 - 2017-9
ELIXIR (Group Insurance) / Aviva Asia Pte Ltd., Singapore
Elixir is a GIL (Group life insurance product) that is providing end to end processing for group life insurance business. . Responsibilities: • Developed front end (UI) components using AngularJS. • Discuss with user and BA’s to understand the requirement and prepare high-level design, effort estimation for new business requirements and feature enhancements(CHR) • Responsible for coding, unit testing and general quality assurance of the web applications • Involved in solving the BAU activities and responsible for code review and data patch coordination. • Responsible for writing the store procedure for the CHR business logic and also involved in creation of UI change. • Implement claim refund detail screen to facilitate to generate the refund receipt. • Implement to add the new commission agent after lock the policy in policy service mode.
2015-1 - 2016-2
1. Financial Product Management System 2. Foreign Account Tax Compliance Act (FATCA) 3. Navisys Migration / Great Eastern Life., Singapore
Financial Product Management System (FPMS) is a fully Java based, three-tier, customer-centric back office administration system for life insurers, covering the whole policy life cycle such as new business, underwriting, claims, renewal, general ledger, re-insurance, sales channel management, and so on. Responsibilities: • Designed the physical data model, generated DDL scripts, and wrote DML scripts for Oracle 11g database. • Implemented the MVC Architectural Pattern using Struts Framework including JSP, JSTL, Form Bean and Action classes. • Implemented Java/J2EE Design patterns like Business Delegate and Data Transfer Object (DTO), Data Access Object. • Developed packages, procedures, functions and triggers using PL/SQL. • Interacted with users for production issues and new enhancements. • Code review of the team members.
2011-6 - 2014-12
1.EBS server Migration for Global Product down Stream Data Adaptations 2. Vehicle Mass Auditing System 3. Weblogic9.2 & Struts Migration for Global Product Down Stream Data Adaptations 4. Spring & Torsion bar Certification System (STC) / GM, Germany
• SPOC for migration activity • Involving in the live deployment process moving the code to production environment and fixing on the day deployment issues if any on time without impacting or less impact to the deployment schedule. • Involved in modified the existing the Elite client setup and test the GVOC interface from GPDSDA • Interact with all in bound and out bound interface owner for testing. • Interact with the DBA team to make sure the new DB refresh with the current production data • Involved in preparing and validating the UNIX script based on the new proposed volume separation. • Share the plan with web logic team to apply the new configuration change. • Responsible for build & deployment, bug fixing during the SIT testing in new server • Involved in preparing the cadence for the major activities(Data refresh, web logic change, SIT testing, interface testing) • Responsible for creating the data source in ebsmo60 and ebs60 server and deploying the application with new server • Responsible for validating the application, interface test cases and validate the DB response time with both 10G and 11 G • Provide the technical help to the team for web logic 10.3 & Top link version upgrade