Sim Kwong Wui

SIM KWONG WUI Contact no: - Email:-LinkedIn Profile: https://www.linkedin.com/in/simkwongwui/ Profile Versatile data enthusiast with experience in executing data-driven solutions. Possess extensive hands-on experience in big data analysis work flow: ETL (extract, transform & load), data cleansing, feature engineering, visualization, predictive modeling and automation. Skills Languages Technical Skills English, Malay, Mandarin and limited understanding of Chinese dialects SAS, SQL, R, Python, Docker, Business Intelligence tools (Power BI, Tableau), ETL tool (Pentaho Data Integration), VBA, Microsoft Office Suite, Batch programming Working Experience Manager, Ambank Malaysia Bhd. (Sep 2017 – Present) Part of team of 4 in developing predictive models and conducting in-depth analysis so as to identify opportunities to improve ROI of bank portfolios. Details of selected experiences as per below:  Produced several predictive models using various modeling techniques, like decision trees, gradient boosting and model ensembles.  Models built for the purposes, i.e: merchants’ sales revenue prediction and acquisitions of products like internet banking channel sign-up, credit card cross-selling and investment-linked products take-up.  Models implemented have successfully achieved better precision in direct marketing initiatives, out-performing generic business criteria and optimised return of campaigns.  Automation of data extractions, model training and model evaluation processes in order to provide leads in timely manner as well as monitoring model performances. Actively working on model improvements.  Pioneered work on obtaining external data to complement with internal data, for instance, scrapping registration numbers of companies or retrieving financial information for public-listed companies. Manager, Alliance Bank Malaysia Bhd. (Sep 2016 – Sep 2017) Key person in supporting bank-wide credit card portfolio. Oversee every credit card activities (acquisition, activation, utilisation, revolving balances and churn) for reporting and analysis purposes. Details of selected experiences as per below:  Streamlined and consolidated information into actionable and comprehensive pivots reports to be readily available at timely manner in order to support business needs.  Participated in developing automated reports for on-going value assessments of the business.  Implemented data enrichment and ensure data quality check is in place to drive quality analytic process.  In-dept analyses were performed in order to assist business personnel to make sound business decisions.  Presented data and conclusions to internal stakeholders on bank’s credit card customers’ profile, segmentation and opportunities to tap on. Analyst, Think Big Digital Sdn. Bhd. (AirAsia Loyalty Program) (Jun 2015 – Aug 2016) Part of newly-founded analytics team for AirAsia frequent flyer program(BIG). The main function of the team is to derive business insight and to drive marketing activities. Details of selected experiences as below:  Collaborated with external vendor in order to eliminate data inconsistencies.  Successfully created full-scaled automation for ETL process (daily) from multitude of data sources to create internal data mart.  Internal data mart built has further allowed time-saving for data extraction by internal team for doing analyses or rolling out leads for marketing campaigns.  Completed various analytical projects in order to further optimise the ROI of campaigns, i.e.: identifying members who were gaming the reward system, rank-ordering of users based on RFM (recency, frequency & monetary) and identification of duplicated member profiles. Executive, Risk Analytics and Infrastructure, Group Risk CIMB (Dec 2013 – May 2015) Part of team in developing product-specific credit scorecards in compliance to Basel II Accord. Details of selected experiences as below:  Tasked to gather large amount of banking data from source systems for different credit facilities in order to study customers’ credit profile.  Transformation of data and data for analysis purpose. Created code templates for effective data massaging.  Collaborated with data owners in order to fix data issues. Managed to identify the misalignment in data warehouse definitions due to system migrations within the historical data.  Created and enhanced user-friendly excel templates (Using VBA) to ease analysis coupled with usage guidelines, i.e.: VBA templates for doing auto chi-merge of variables and PD calibration. Education Profile 2010 – 2013 1st Class Honours in BSc in Mathematics from University of Bristol with full sponsorship from JPA 2008 – 2010 Cambridge International Examination (CIE) A-Levels in Cempaka International School with full sponsorship from JPA 4A* in Mathematics, Physics, Chemistry and Biology Scored 7.5 overall out of 9 in IELTS (International English Testing System- SPM (Malaysian Certificate Equivalent to GCE O-Level) from Methodist Secondary School, Sibu, Sarawak Scored 11A1 straight, including Mathematics and Physics Extra Achievements Have taken initiatives to participate in Hackathons held locally in the past few years outside of work. These events allowed me to meet and collaborate with other professionals, share skills and exchange ideas.  Axiata Datathon Urbanlytics 2019 (Team of 7) Champion of the overall competition & Best Business Idea award (Overall prize money: MYR 18,500) - Assisted in solving multiple technical questions, including a multi-class classification problem that topped the leader board among 32 teams. - Introduction of business idea: solar-based cycling infrastructure to solve the last-mile connectivity.  Design Unlocked KL 2019 (Team of 2) Top 10 out of 40 teams - Produced HR analytics dashboard and attrition prediction model that beat the online benchmark within 24 hours. - Introduction of business idea: retention of employees who’re likely to leave based on survey feedback.  Axiata Data Unchained 2018 (Team of 5) Second Runner-up of the overall competition & Best Business Idea award (Overall prize money: MYR 8,500) - Route predictions and drivers’ behavior segmentation and mobile usage analysis. - Introduction of business idea: smart recycle bins that are incorporated with IOT technologies & rewards program that could ease as well as promoting recycling habits among citizens.  Maybank Hackathon 2016 (Team of 5) First Runner-Up for ‘Datahack’ session (Overall prize money: MYR 10,000) - Main programmer in putting forward proof of concept to increase current account base for SME customers without increasing interest rate. - Introduction of business idea: made data-driven suggestions on opportunities to tap on (i.e.: targeted campaigns based on seasonality of CASA trend and location of the CASA holders) Referee References are available on request