SAP Implementation Project. Responsible for OTC Business Process and its integration to other areas, PP, MM and Planning. Which involves: Conducting the scooping / design workshops for the business people. GAP analysis between their existing SAP system and their legacy system and preparing the business blueprint documents. Preparing the functional design documents for conversion requirements in SD like customer material, item proposals, customer info records and other RICEFW objects. Completing analysis and configuration of Order management, availability check with ATP logic and product allocation, shipping billing and pricing. Defined custom availability checks, rules in ATP. Data mapping, transformation. Created new sales organizations, distribution channels and assigned the distribution channels to the sales organizations. Defined various billing plan types for milestone and periodic billing and assigned to the sales document types and item categories. Designed VOFM copy routines to handle the SD and PP integration delivery output documents. Configured basic and control data relevant for foreign trade for SD documents for the export processing.

SAP Retail Implementation for NTT client in retail industry. SAP Retail as a packaged business solution that was designed to automate and integrate business processes, share common data and practices across the enterprise and provide access to information in a real time environment. The level of Areas of retailing which have been improved and implemented: Retail Supply Chain and Retail Procurement, Pricing Calculation, allocation, replenishment, Warehousing and Distribution, Store Operation, analytics and SAP-POS real-time connections.

Company Consolidation between OMNI and Celestica. Responsible on combining two high tech companies (OMNI and Celestica) into a single company, blending cultures, joining workforces, capturing synergies, and harmonizing processes—all while maintaining ongoing operations—can challenge even the most successful companies.

Defined MAP future retail merchandising business process. Areas of retailing which have been improved: Open-To-Buy Dynamic Calculation and Multi Business Units Organization. Retail Purchasing with adaptive landed costs calculation. Dynamic Retail Pricing Calculation & Retail Pricing Optimization. Retail Allocation, Inventory Visibility and Master Data Processing. Distribution Process, solutions for complex warehousing where all Retail Business Units shared the same warehouse facilities. SAP-POS real-time connections. Faktur Pajak Customisation.

SAP Implementation Project. Led OTC Team who was responsible on designing the OTC business process model for South East Asian Market. Such responsibilities that are incorporated are: Business Process Improvement based on best practices, Prototyping and CRP with key business users, Configurations, Customisation and Integration between SAP and non-SAP system, Maintenance support includes solving the service request raised by the end user by providing effective solutions for business within the time frame agreed upon in the SLA, Created and maintained the Organizational entities, Customizing Alternative Product selection, Material Determination, Material Listing/ Exclusion, Service Contracts, and Free Goods, Involved in preparation of Technical Specifications, review of Routines & User Exits, Developed and customized reports in SD module such as sales order report, which covers all organization levels, delivery status, invoice status, shipping details and partner function details, Pricing Procedure Determination and maintenance, Interactions with cross Functional consultants, Developed Cut-Over activities.

Supply Chain Management Project. The key challenges were data integration which has been solved by integration of the data, business process, system and information system and the information management system of logistics on the way etc. Configured sectors include: Master Data for Customer, Material, and Customer-Material Info Records, Created Various Sales Documents, Preparing the functional design documents for conversion requirements in SD. SD pricing, Billing components comprising billing document types, Invoices based deliveries and services, Periodic and milestone billing, and Collective processing of billing documents and the Output Determination Procedures.

e-Commerce Supply Chain Optimization to improve stock availability and reduce excess stock in the Distribution Centers and Stores. Implemented adaptive forecasting and dynamic Distribution Center redetermination to fulfil demands from e-commerce customers. The benefits of planning throughout the supply chain include: Realistic Ordering Lead-Times, Averting Problems and Facilitating Resource Planning and Allocation Retail Business Process Re-engineering based on Retail Best Practice and Suning’s own competitive advantages. Key business process which have been re-engineered: Bulk PO Processing and Consignment processing, Vendor Inventory Visibility, Integrating SAP System with SAP Business Warehouse, Suning e-commerce business process design and implementation, Retail master contract management.

Large transformation project, which covered all aspects of business process. One key activity to migrate BAAN ERP to SAP ERP. The end-to- end business modeling designed for Levi’s Strauss Europe include: Retail Master Data Integration, Merchandising Process, Intercompany Transaction, Supply Chain Management & Distribution, VMI/Auto-Replenishment to reduce out of stock situation in stores and SAP-POS real-time connections. SAP (Fashion and Retail) is implemented for Levi’s Strauss in Japan to improve its areas of retailing which include: Distribution Process, Dynamic Billing Generation, Open-To-Return Process, SAP-POS real-time connections and Retail Inventory Visibility.

SAP Retail Implementation for Al-Futtaim Group. Designed and implemented SAP solutions which focused on Retail Business Division, Retail inter-company business process, output determination procedures and Unit Test Plan activities. Sectors involved include: Retail Pricing Calculation, Retail Distribution and Billing, Downpayment processing at retail stores, Retail Store Operation and SAP-POS real-time connections. SAP Implementation for Automotive Industry. Design the business process and implement SAP and its integration to other external systems for Astra Automotive Division, which was covering Daihatsu, Isuzu, BMW and Toyota.

Mobile & Fixed Line Data Mining Provide services on design, development and implementation of Mobile and Fixed Line Data Mining requirements for CWHKT. Data requirements for Data Mining were cutting across multiple Legacy system: Demographic, Contact Information, Subscriber Profile, Acquisition Related Information, Spending Usage, VAS Subscription etc are incorporated into the Data Mining Data Mart. MOD/TPM Report Repository Provide consulting services on setting-up, study, design, development and implementation of ETL standards for MoD. MoD/TPM stands for MIS on Demand/Total Performance Management. The scope of Phase II was on CPE, Customer Premises Equipment, covering PABX, Keyline, Desktop Solution and Fax, and deal with the performance measurement of various parties, such as PABX Service Support and Keyline Service Support Teams. Marketing Data Mart for Campaign Management Provide consulting services to CWHKT in developing Marketing Data Mart based on users’ design. The MDM are extracting data from Fixed-Line & Mobile OLTP applications and derived Line-, Customer-, and Super Customer-Levels on different periods of analysis-Daily, Weekly, Bi-Weekly, & Monthly. Massive data manipulation and transformation are done to calculate multiple customer behavior indicators for comparison purpose in the data mart. This data mart uses SAS/WA extensively to store the metadata, program flows and SAS programs.

Report Automation for SCB Singapore & SCB Malaysia Automation of 170 reports covering SCB Singapore and SCB Malaysia within 8 months time frame. Business Report Automation Develop and deploy a framework for ETL & Report Automation for the Credit Risk & Analytics in Standard Chartered Bank Malaysia. Customer lifetime value (Standard Chartered Bank Hong Kong) Provide SAS programming expertise in preparing justification for customer life time value (LTV) model. Customer Segmentation Exercise (Standard Chartered Bank Malaysia) Provide SAS programming expertise in preparing customer data for Customer Segmentation Exercise. Mortgage Profitability Model (Standard Chartered Bank Singapore) Develop a Front-End (FE) Application, using SAS/AF, to capture the parameter values to be used for profitability computation in Mortgage Profitability Model.

Hire-Purchase & Industrial Hire-Purchase EIS The HP EIS was built for Senior Management to monitor a multi-billion Hire-Purchase business. It includes a wealth of information such as, NPL, New Business Done, Remaining Maturity and Original Maturity Analysis etc. for management to analyze and monitor their business. This system provides details information up to individual accounts level to simplify the identification process. Bank Negara Data Submission System (BNDSS) A fully automated reporting system specifically designed for Bank Negara’s (Central Bank) Statutory Reporting. This system read operational data from 16 sources ranging from manual input, PC-based sources to Mainframe-based system and consolidated the data to create item codes reporting. Extensive validations and conditions have been built in to ensure the correctness of reported value. This system was developed for Arab-Malaysian Finance Berhad.

Customer Segmentation Develop a company-wide customer segmentation information reporting for use by the company’s top management, marketing department and finance department. This project segregate the customer into different categories e.g. Consumer, SME & Corporate customers. It covers customer profile, detailed usage patterns including SMS, Content Download, Voice, IDD, Roaming, Interconnect and other recurring and non-recurring revenues. Mobile Settlement and Alert System Develop and maintain a backend system that provides on-going support for the content provider’s settlement requirement. This project involves getting the billed revenue and matching with the platform data for reconciliation purpose and, subsequently use the billed revenue as the settlement amount to the respective Content Providers.With this alert system, our customer is able to detect missing revenue and revenue leakage and thus preventing the revenue leakage from occurring. Product Performance Report This project is to develop and maintain a front-end and backend system that provides Revenue, Traffic, and Active Subscriber Information for all launched product to both the Product Manager and Management. Customer Services Data Mart The purpose of this project is to design and implement the customer service data mart to facilitate the customer service department to further improve the allocation of customer service consultants to address the right calls and to improve the customer service quality. Enterprise data warehouse support and development Provides on-going supports and improvements to current Maxis Enterprise Data Warehouse. Maxis Mobile Customer Profitability Model Data Mart The objective of this engagement was to plan, design, and develop a data mart for the Mobile (Prepaid and Postpaid) Customer Profitability Model. It involved accessing data from the existing Postpaid and Prepaid Warehouse, Inter Connect source systems and Costing data from their SAP Financial System.The project also includes designing and developing a Front-End Application using SAS/AF software to query the Customer Profitability Model Data Mart and generate reports in HTML format. Maxis Mobile Network Data Warehouse Provide planning, design, and develop a data warehouse for the Raw Network CDR (Call Detail Records). Since the volume of data was very large, it involved extraction of Raw CDR in a concurrently manner and at some predetermined interval period.Also involved in designing and developing of reports using Brio software regarding Drop Calls, Handset used by customer in relation to the Customer Profile and Segment. Maxis Mobile, Fixed Line, and Prepaid Data Warehouse The objective of this engagement was to study, plan, design, and develop the first Data Warehouse for Maxis. The scope of Phase I of this project was to incorporate GSM Mobile Post-Paid data into a Data Warehouse/Information Factory (DW/IF) and, in Phase II, to incorporate the Fixed-line and Pre-Paid data into the same DW/IF. The scope of consulting includes: 1. Setting up of Data Warehouse development and production environment, 2. Study user requirements, analyze existing sources and design Post-paid Data Model, 3. Implementing eCTL’s Extraction, Transformation and Loading methodology, and 4. Implementing of Mobile Metadata for Post-paid Data Model

Customer deposit winner selection application Develop a winner selection mechanism based on the given business rules from BCB. It also facilitates business users to compute the cumulative chances of each customer (Account Holder) for weekly & grand prize draws. Motor Insurance Renewal winner selection application Develop a winner selection based on the given business rules from BCB. It also facilitates business users to compute the cumulative chances by each customer (Motor Insurance Purchasers) for weekly & monthly draws. Data Mining Skill & Knowledge Transfers Transferring of skill sets & knowledge to CIMB Data Mining Team in the topics below : – a. Data Mining Project Implementation for specific business issues. b. Business Problem formulations. c. Define predictive modeling target variable & a list of variables for model development d. Model Development using various Data Mining Techniques e. Model evaluation, assessment & fine-tuning Consolidated Statement Utilizing our in-house developed cleansing & matching algorithm to help and enable CIMB bank to generate quarterly consolidated statement for their customers. The project involved in reading multiple customer products and investment data as according to the defined and agreed criteria by CIMB business users. CMDM Datamart Improvement Improving the SAS ETL processing for CM Datamart from 40 hours to 14 hours.

Executive Information System (EIS) Covers the following major modules: Finance, Technical, Operational, and Personnel. Finance Module Includes GL, Cash-on-hand, Budgeting and Costing Operation Module Includes On-Time Performance, Cause of Delay, PAX Load Factor, Booking Position and Seat Load Factor Technical Module Includes Dispatch Reliability and Aircraft Status Personnel Module Includes Employee Performance, Employee Statistics and Medical.

Computerized Statistical Process Controls This is a large-scale factory -wide data capturing for quality control and analysis system developed for Siemens Semiconductors Sdn Bhd in Malaysia. This on-line system linked directly with Royce tester to capture test results to eliminate typo error and highlights any violation based on the Western Electric Rules defined by users. Any violation will be automatically trapped and buzz the technician for immediate corrective action. Once corrective action has been taken, the system will be updated with the information stored for future reference.

Computerized Statistical Process Controls This is a large-scale factory -wide data capturing for quality control and analysis system developed for Siemens Semiconductors Sdn Bhd in Malaysia. This on-line system linked directly with Royce tester to capture test results to eliminate typo error and highlights any violation based on the Western Electric Rules defined by users. Any violation will be automatically trapped and buzz the technician for immediate corrective action. Once corrective action has been taken, the system will be updated with the information stored for future reference.

Airline Information System This is a data mart developed for Malaysian Airline. This data mart contained all Pre-Flight information, such as, Seat Factor, Pax No/Revenue, and Booking Status and Trend breakdown by Route Area, Route, Sector, Stage, Flight No, Class, and Subclass. A front-end developed in OS2 was used to assist the exploitation of the Pre-Flight information. The data mart was capturing data mainly from KOMMAS system and stored in the mainframe system.

Migration of SAS 6.12 to SAS 8.2 The objective of this engagement was to ensure seamless migration of the SAS System to new Super Server Environment. This migration covered the new HP SuperDome 64-bit hardware and OS together with the new 64-bit version of Oracle 8i and 9i. The migration covered the full ETL process in PCCW with the following requirements: 1. To maintain long & short field names from sources 2. Convert more than 400 Oracle Extraction Programs 3. Convert more than 500 Text files Extraction Programs 4. Migration with minimum impact and changes to existing Transformation & Loading programs 5. Changes to be reflected in PCCW’s SAS Warehouse Administrator Weekly Line Installation, Disconnection and Port-Out Data Mart The objective of this engagement was to design, develop and implement a data mart for keeping track of line level quantity counting and PSEF usage that contribute revenue to the company. The data mart will store 56 week of weekly data. This weekly process will identify line quantity of movement of customer including newly Installed, Disconnected, Port-In, Port-Out and Port-Back at line-level. Weekly VAS Product Installation, Disconnection & Port-Out Data Mart The objective of this engagement was to design, develop and implement a data mart for keeping track of in-service quantities for the list of VAS product provided by users for both Business & Residential Customers. The Datamart will store 56 weeks of weekly data.This weekly process will identify VAS product counting at line level. This counting includes newly Installed VAS, Disconnected VAS and Move & Change with VAS. Sales Performance Tracking System (PTS) – BR & CT The objective of this engagement was to build a Data Mart to support the Billed Revenue Performance Tracking System (PTS-BR) and Customer Trend Performance Tracking System (PTS-CT). The new PTS-BR and PTS-CT is to improve sales effectiveness and motivation, and to build up a reliable and timely performance tracking and management system for all different group of users from the management, planning, sales and marketing team.This data mart will consolidate all daily, bill cycle, and monthly revenue from multiple sources such as IDD, Rental, and Equipment Sales etc. It will store 24 months of historical data for Performance Tracking purpose. In PTS-BR, historical Salesman-Customer Relationship Table is used to map with customer revenue to get the salesman-level revenue information and, in PTS-CT, current Salesman-Customer Relationship Table is used to map to full 24 months of customer revenue information to get current Salesman performance. Sales Performance Tracking System (PTS) – Sales Revenue The objective was to build a Data Mart in SAS format to support the Sales Performance Tracking System and to assist in building the front-end application for Sales Performance Tracking System itself using SAS Web and SAS MDDB Technology. The objective of this system was to improve sales effectiveness and motivation, and to build up a reliable and timely performance tracking and management system for all different groups of users from the management, planning, sales and marketing team. Loyalty program system (LPS) Study, design, develop and implement a LPS Data mart. An extensive analysis and study was done on the new LPS functionality and data model with the LPS vendor and PCCW-HKT business users to build a comprehensive LPS Data Mart. The LPS system took data from all sources of information within and outside of PCCW-HKT, such as Customer Profile, Spending Data, Member Website Login Data, External Partners Transfer-in and Transfer-out. This project stresses the integration of these interfaces and data flows between Legacy, LPS and External Sources to Information Factory and from Information Factory back to Legacy, LPS, and External Sources. This project was built on top of the existing Information Factory (IF) Architecture and has proven the flexible and powerful of the IF/ETL Methodology in a complex data warehouse environment. Revenue Management System (RMS) The objective of this project was to improve on the accuracy and timely reporting of existing Insight data. The current monthly updates would be improved to daily/weekly/bill cycle updates, which in turn provide an up-to-date and accurate revenue forecast in RMS Forecasting system.

Customer De-duplication Exercise To perform quarterly exercise to identify repeating churn customers based on address and other customer information. During the exercise, we manage to achieve at least an accuracy of 95% based on our lookup table and system.