Tee Chian How

Tee Chian How

Demo (Tutor) University

Followers of Tee Chian How136 followers
location of Tee Chian HowSingapore, Singapore

Connect with Tee Chian How to Send Message

Connect

Connect with Tee Chian How to Send Message

Connect
  • Timeline

  • About me

    Data Analyst at ComfortDelGro | Ex-Tencent | Data Visualisation(Power BI & Tableau), Data Analysis, Python & SQL

  • Education

    • High School Muar (Malaysia)

      -
      STPM SCIENCE STREAM 1A , 2A - , 1B (3.583)

      Activities and Societies: - President of SPORT Team - Vice President for Basketball Club - Participate in INTERNATIONAL COMPETITON AND ASSESSMENT FOR MATHEMATICS Subject - Dean List for Semester 1 2013/2014 and Semester 2 2014/2015

    • University of putra malaysia

      2012 - 2016
      Bachelor’s Degree Mathematics (major in statistics) CGPA = 3.557
  • Experience

    • University of Putra Malaysia

      Jan 2016 - Jun 2016
      Demo (Tutor) University

      • Teach and explain the theory of MTH 3003, Statistics for social science in tutorial class• Helping student who facing the problem on this subject• Discuss and explain the tutorial/exercise with students

    • Capital Dynamics Asset Management

      Oct 2016 - Apr 2017
      Performance Analyst

      • Main responsibility included conducting performance measurement and analysis within strict deadlines, researching on performance measurement methodologies and conducting attribution analysis.• Work closely with the Fund Managers and the Back office team to ensure the data is of the highest quality and ensure accurate delivery of equity performance attribution.

    • The Nielsen Company (Malaysia) Sdn Bhd

      Jun 2017 - Aug 2018
      Category Specialist

      • Responsible for instructions of client deliverables, coding and data input validation focusing on specific industry/category or set of categories (e.g. Beverages, Food, Health and Beauty Products)• ETL through Nielson Answer Portal • Be contact for commercial queries, leading the resolution in a client focused and timely manner in cooperation with Client Liaison and Commercial teams• Identify Establish database management for collecting, cleaning, storing, managing, and accessing data from multiple sources • Plan and execute a complex daily personal workload and support to meet departmental and company schedule• Working across relevant Operations/Enablement teams to ensure delivery to client expectations and satisfaction• Database Setup which involved in using the SQL processing script. For example, only calling all the information requested.• Using of the SQL script in order to obtain the information of the product. For example, getting the store list of the product.• Create and Deliver Outputs in a correct and timely manner Show less

    • Mattress international pte ltd

      Oct 2018 - Apr 2022
      Data Analyst

      • Perform all the analytical and reporting related activities on Omni channel, e-commerce platforms, retail operations, different market places like Q10• Present and deliver either weekly/monthly/ad-hoc reports to management.• Using SAP Crystal Report 2016/Oracle Fusion for data extraction• Assisting sales executives on reconciliation of sales data especially for Court sales data and verify the monthly incentive reports for the SA • Work across the department for data collection and validation.• Provide any ad-hoc analytical reports • Monitoring the performance of the e-commerce through Google analytics• Responsible on Content Management System for e-commerce• Support on SAP project, setup a new system called Zyllem for logistics department, coordinating and maintaining the new e-commerce website • Responsible on giving the training for new system users when needed.SAP Project Preparation• Understanding on the product classification and map it correctly to the SAP master data template.• Identify the operation process and choose which is the most suitable designs for SAP system• Data cleansing to prevent the misleading on interpretation of dataZyllem Project lifecycle• Investigate and prepare the data points to integrate the current legacy system with new system, Zyllem• Understanding current logistics process and listing down requirement needed. • Work across team to gather the different kind of scenario for UAT testing. • Mock up the few data sets which fulfill the test scenario for system testing.• Carry out the testing on the system configuration to make sure fulfil the requirement listed.• Inform and follow up with vendor on those system’s missing functional spec• On field training to the driver on the use of mobile apps• Troubleshoot the data enquiry.• Carry out the training for new user• Prepare and present the reports needed to the management Show less

    • Tencent

      May 2022 - Dec 2022
      Data Analyst Engineer

      1. Communicate with business users and the data platform team for requirement gathering and process collaboration.2. Extract big data and manipulate these data to derive aggregations using PostgreSQL based on business users' requirements and analysis.3. Develop data processing pipelines for data modeling, analysis, and reporting from large and complex transaction datasets using Apache Spark and T-Hive.4. Ensure that extraction of operational data from the data warehouse is always working and debug any loss of data due to server connection or change in structural data.5. Build Bl dashboards for both basic and customized visualization frameworks using Tableau for data insights and business support. Show less

    • ComfortDelGro

      Dec 2022 - now
      Data Analyst

      1. Communicate with business users to gather requirements and provide the solution.2. Support business user in term of extraction of data, maintain Tableau/Power BI dashboards and provided valuable analysis based on their requirement3. Carry out an in-depth finding and research to provide a valuable analysis and recommendations4. Data extraction from AWS/Azure/Oracle/GCP platform by SQL query.5. Using python for exploratory data analysis(EDA).Eg. Boxplot,Histogram,Data Profiling, Matplotlib,Ploty6. Using of data visualisation tools : Power BI,Tableau Show less

  • Licenses & Certifications