Victor Tan

Data Analyst (Engineer) at RPG Commerce
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Petaling Jaya, Selangor, Malaysia, MY
Languages
  • Chinese Native or bilingual proficiency
  • English Limited working proficiency
  • Malay Elementary proficiency

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • Python for Data Visualization: Matplotlib & Seaborn
    Coursera
    Sep, 2022
    - Nov, 2024
  • Databases and SQL for Data Science with Python (with Honors)
    Coursera
    Sep, 2022
    - Nov, 2024
  • Introduction to Relational Databases (RDBMS)
    Coursera
    Sep, 2022
    - Nov, 2024
  • Hands-on Introduction to Linux Commands and Shell Scripting
    Coursera
    Aug, 2022
    - Nov, 2024
  • Data Engineering Essentials
    Coursera
    Aug, 2022
    - Nov, 2024
  • Introduction to Data Engineering
    Coursera
    Aug, 2022
    - Nov, 2024
  • Python for Data Science, AI & Development
    Coursera
    Aug, 2022
    - Nov, 2024

Experience

  • RPG Commerce
    • Malaysia
    • Technology, Information and Internet
    • 1 - 100 Employee
    • Data Analyst (Engineer)
      • Dec 2022 - Present

      Data Ingestion and Transformation (Python and Bigquery) - Wrote and maintained Python script (REST API) in Google Collabs to ensure the weekly data ingestion from various workspaces to Bigquery - Wrote and maintained scheduled query in Bigquery to transform the ingested data Data Validation (Bigquery) - Ensured the data quality from different workspaces and platform - Identified the definition of each attribute and performed data accuracy testing in Bigquery with the sources - Drafted a data dictionary to explain the definition of tables and columns to end users and stakeholders Workflow Automation (Python and Windows Batch Script) - Merged weekly inventory data of various brands from the supply chain planning platform and aggregated them into useful information - Generated and sent daily sales data in accordance with the specification required by the mall POS - Used Selenium to create a bot (within 4 days) to automate daily inventory data download from 6 warehouse management systems. This enabled the strategy and supply chain team to have visibility on daily inventory levels. Create Apps (Appsheet and Data Studio) - Created a purchase order management system to replace the usage of an ERP system that cost 641 USD per month - Created a Kanban App to manage the B2B deals - Connected the data from the apps to Data Studio and displayed in the dashboard in accordance with the needs of users Show less

  • CARSOME
    • Malaysia
    • Internet Marketplace Platforms
    • 700 & Above Employee
    • Data Insight Analysis
      • Jul 2022 - Oct 2022

      • Performed customer relation management analysis by using data. • Performed data cleaning on scrapped competitors’ data. • Assisted on various analysis tasks prior to model implementation. • Conducted customers’ online (website) and offline behavior analysis. • Performed customer relation management analysis by using data. • Performed data cleaning on scrapped competitors’ data. • Assisted on various analysis tasks prior to model implementation. • Conducted customers’ online (website) and offline behavior analysis.

  • Omni Capital Partners
    • Malaysia
    • Financial Services
    • 1 - 100 Employee
    • Investment Analyst
      • Jun 2021 - Aug 2021

      • Fundamentally analyzed and presented Mainland China and Hong Kong listed companies. • Conducted research on the semi-conductors industry and contemporary hot topics (5G, AR and so on). • Fundamentally analyzed and presented Mainland China and Hong Kong listed companies. • Conducted research on the semi-conductors industry and contemporary hot topics (5G, AR and so on).

  • Pusat Tuisyen Minda Cekal
    • Keluang, Johore, Malaysia
    • Parttime Tutor
      • Dec 2017 - Jul 2018

      - Teached year 4 to year 6 Math, Science and Chinese - Developed teaching plan and assisted in holding curricular activities - Trained 3 part time tutors - Teached year 4 to year 6 Math, Science and Chinese - Developed teaching plan and assisted in holding curricular activities - Trained 3 part time tutors

Education

  • The Chinese University of Hong Kong, Shenzhen 香港中文大学（深圳）
    Bachelor of Business Administration - BBA, Professional Accountancy
    2018 - 2022

Community

You need to have a working account to view this content. Click here to join now