System Analyst
Project Migration on Enterprise Datawarehouse (EDW) and Customer Risk Management System (CRMS)▪ Build data model for the following source systems to facilitate Head Office’s Users reporting purposes on daily / weekly / monthly /quarterly / half-yearly / yearly basis:✓ Credit Card (Merchant, Individual, Commercial)✓ Trade Finance✓ Hire Purchase✓ Deposit✓ Loan▪ Data extraction and data massaging based on URD’s requirement using SAS languages mainly using data steps method▪ Assist data migration on Hire Purchase system and converted from SQL language to SAS languages▪ Handling external third-party company project on data extraction together with internal PBB’s department (involving encryption method using Linux Command function and SFTP method in SAS programming)▪ Perform positive and negative testing on data quality▪ Set up profile access with SAS Library by using SAS Management Console for different data model▪ Automation of data model based on different reporting requirement’s frequency (daily / weekly / bi-weekly / monthly / quarterly / half-yearly / yearly / adhoc) by incorporating SAS Macro script▪ Job monitoring / standby to ensure immediate action / fixes are taken during job abends▪ Act as middleperson by liaising with SAS Vendors on system maintenance (renewal of license, issues highlighted by Head Office Users