Albert Soh Email & Phone Number

Sydney, Australia

Sydney, Australia

• Participate in requirements study, design, development, and testing of SAS customer data mart, to create a single data repository for 360 degree of customer view• Fully manage the report mart design and customer management BI reports development using SAS Visual Analytics• Self-learn and explore Tableau and Microsoft PowerBI to compare the different features of data visualisation tools• Data extraction for Reinsurance and enable business users to monitor transactions that meet certain threshold for further action• Involve in migration project of Allianz front-end sales & quotation system (Safire), perform impact analysis on existing reports to identify source tables and columns, and data mapping to the new version of Safire platform and database in order to redevelop the reports using new data source• Develop data extraction including XML data in DB2 for insurance sales & quotes and generate leads files for Peakbound Call Centre Consultant to contact customers, and front-end sales and transactions reports for Direct distribution manager• Perform testing on front-end sales & quotation system (Safire) to create various scenarios and test cases for data warehouse data extraction and reports testing• Development tools: SAS Base, SAS DI Studio, Macro, Visual Analytics, Enterprise Guide, DB2 SQL

Sydney, Australia

• SAS Developer in Business Performance and Analytics (BPA) unit, Risk Quantitative and Decisioning System Department• Participate in the full cycle of development, both waterfall and agile method, that include requirement study, design, development, various testing (unit test, SIT, UAT), implementation, and support of credit risk data mart for use in BPA and ABR• Prepare documentation for all stages from design until testing, and production migration deployment• Perform impact analysis for project enhancement and change request• Ensure deliverables meet the agreed timelines and are of a high standard complying to the Data Management Framework• Working with the BPA Quantitative Analytics, Credit Risk Modelling team and the PCODM Release Management team to ensure models and risk estimate are implemented to a high standard• Develop Qlikview to perform data profiling analysis

Kuala Lumpur, Malaysia

• Team leader in Decision Management (Data Management and Infrastructure)• Managing the design, operations of the SAS Data Mart for consumer analytic team• Ensure ETL Operations, on time with quality. ETL involves data aggregation from multiple host systems including Business data warehouse, AS400, loan origination systems, CRM and external files• Create processes for monitoring data quality comprehensively. Partner with diverse system owners, to initiate data quality improvement and data cleansing initiatives• Enhance productivity and analysis turnaround time for the Customer Analytics team, by understanding data requirements of the users and creating customized data sets that can be leveraged across the team; and by optimizing infrastructure design• Develop automated scripts for standard and periodic data reports and data feeds into downstream systems• Manage user access to the system. Maintain system and perform UAT for Infrastructure upgrades• Single point of contact with SAS vendor for technical issues. Responsible for maintaining SAS data mart and SAS customer intelligence studio

Kuala Lumpur, Malaysia

• Contract in RHB Bank Malaysia, using SAS to reverse engineering of risk scorecard model development which developed by FICO, and handover the source code to RHB risk modelling team• Work closely with risk modelling team and involve business requirement study, reverse engineering model development, and testing• Scorecard model include: Commercial Property Financing (Term Loan and Overdraft), Personal Financing

Kuala Lumpur, Malaysia

• Contract in Scope International (which is the Standard Chartered Group’s Global Technology & Operations hub, a wholly owned subsidiary of Standard Chartered Bank), supporting Asian region and develop and manage data warehouse related project end-to-end, involve requirement study, analysis, design (functional and technical specification), development, testing, implementation and support. • Perform impact analysis for project enhancement and change request.• Prepare all documentations: functional and technical specification, unit testing, SIT, UAT (test case), and implementation

Kuala Lumpur, Malaysia

• Develop and manage project of SAS Enterprise Business Intelligence (EBI) solution for various industries: healthcare, education, marketing• Involve in full cycle process, include pre-sales demo preparation, business requirement study, analysis, design and development, implementation, and support• Built periodic ETL process from disparate data source into SAS datamart, OLAP cube, management & operational reports, and BI dashboard, enable users to analyse business in different perspective and generate insights• As a SAS trainer in SAS Institute Malaysia, conduct various courses (SAS Programming 1, Programming 2, Enterprise Guide, Macro 1, Web Report Studio)

Kuala Lumpur, Malaysia

• Developing and managing data warehouse and OLAP reports with SAS EBI solution• Involve full cycle process, include business requirement study, analysis, design and development, implementation, maintenance, and support of data warehouse• Built data warehouse for National Sales, Hotel Operation & Planning, and Casino Treasury for Genting Highlands Group• Build OLAP Cube, enable users to analyse the business in different dimension/perspective• Automate operational, KPI, and management reporting for business users decision making