Siow Tek Tan

• Responsibility:
  
  1. Data Analysis in Game Industry:
  • Analyzing large and complex transaction datasets related to gaming.
  • Solving challenging and non-routine analysis problems specific to the gaming domain.
  2. Data Processing Pipeline Development:
  • Developing data processing pipelines for modeling, analysis, and reporting.
  • Handling large and complex transaction datasets efficiently.
  3. BI Dashboard Creation:
  • Building Business Intelligence (BI) dashboards using tools like Tableau and internal BI tools.
  • Enhancing data visualization to provide valuable insights for business support.
  • Making data extraction and understanding easier for end-users.
  4. Product Understanding and Advocacy:
  • Developing a deep understanding of various gaming products.
  • Advocating for changes in product development based on data-driven insights.
  5. Feature Extraction Model Development:
  • Researching and developing models to extract user transaction features.
  • Contributing to the enhancement of data-driven decision-making processes.
  6. Collaboration and Requirement Gathering:
  • Working with business users and the data platform team for requirement gathering.
  • Collaborating on processes to ensure effective data analysis and reporting.
  7. Specialization in Tableau:
  • Bringing almost 2 years of hands-on experience in Tableau to the role.
  • Specializing in data visualization to communicate insights effectively.
• EXPERIENCES GAINED:
  1. Tableau Reporting:
  • Skill Level: Familiar
  • Experience: Creating reports and utilizing the Tableau reporting tool for data visualization and analysis.
  
  2. Database and Big Data Systems:
  • Skills: Starrocks OLAP/MySQL database, Big Data Systems (Tencent Cloud)
  • Experience: Working with Starrocks OLAP and MySQL databases for data storage and retrieval. Utilizing Tencent Cloud for managing big data systems.
  3. Apache Hadoop:
  • Experience: Working with the Apache Hadoop platform, indicating expertise in distributed storage and processing of large data sets.

• Responsibility:
  1. Team Collaboration and Customer Analytics:
  • Collaborate closely with team members and analysts at various levels.
  • Capitalize on and optimize customer analytics and insight functions to drive business objectives.
  2. Data Mining and Optimization:
  • Assist in the development and implementation of data mining techniques.
  • Optimize processes to meet various business requirements effectively.
  3. Report and Dashboard Setup:
  • Setup, maintain, and automate reports, dashboards, and business processes.
  • Cater to the needs of different stakeholders and the company.
  4. Collaboration for Improved Analysis and Reporting:
  • Work with internal and external parties to enhance analysis and reporting templates.
  • Adapt to changes in customer consumption and the general environment (e.g., fuel prices, post-COVID) to improve accuracy.
  5. Data Extraction and Organization:
  • Consult with other business units to extract and organize data for developing targeted marketing campaigns.
  • Ensure accurate targeting of the right members, improving customer perception, and reducing campaign costs.
  6. Campaign List Generation and Tracking:
  • Generate campaign lists and ensure accurate fulfillment and tracking based on agreed-upon requirements with Business and Analytics.
  7. Campaign Analysis:
  • Conduct post-campaign analysis to identify campaign effectiveness.
  • Analyze overall campaign funding, compare total spend with member activity during, before, and after the campaign, and assess members' behavior from different perspectives.
  8. Ad Hoc Reporting and Analysis:
  • Handle ad hoc requests using SQL, SAS VA, and Excel.
  • Build, maintain, and analyze business performance reports, conduct trending analysis, and create KPI dashboards.
  • Facilitate business decisions and follow-up actions based on the analysis.
• EXPERIENCES GAINED:
  1. SAS VA Reporting:
  • Experience: Creating reports using SAS Visual Analytics (VA), including tasks such as uploading data marts, and maintaining aspects like user login, password, and addressing minor issues. This indicates proficiency in leveraging SAS VA for data visualization and reporting purposes.
  2. SQL Programming and Excel:
  • Skills: Strong in SQL programming and Excel
  • Additional Knowledge: Basic knowledge of Python
  • Experience: Using SQL for data manipulation and querying, Excel for data analysis and reporting. Basic knowledge of Python suggests a potential for scripting and automation tasks.
  3. Data Cleaning:
  • Experience: Engaging in data cleaning activities, indicating a strong understanding of the importance of data quality in analysis.

Responsibility:
1. Programming work using market research software to enable electronic data of market research analysis.
2. Assist in troubleshooting programming issues that may arise during field.
3. Either independently or with team members, generate report for analysis purpose.
3. Works closely with the Euro and US client, to increase the most accurate result from every research project.

EXPERIENCES GAINED:
1. Communication with client.
2. New software which is SPSS and DMS, used for running data report and checking.

Responsibility:

1. Perform all aspects of systems development such as requirements gathering, analysis, preparing functional specifications, system testing, preparing user guide and system support as assigned under the direction of project managers
2. Work closely with developers to understand user's requirements and conduct studies to ensure requirements are met
Produce quality system delivery by utilizing best practice methodology and technology
3. Document all system specifications, modifications and enhancement
Query, develop and maintain code using PL/SQL
Problem analysis of system bugs

EXPERIENCES GAINED:
1. Learn a new software which is AS4000.
2. Knowledge and experience in Data warehouse Challenge.

Responsibility:

1. Responsible for analysis, design and software development of mine assigned projects.
2. Lead or being part of the team of developers in the Bank Negara Malaysia CTCS project.

EXPERIENCES GAINED:
1. Learn a new software which are Microsoft Visual Studio .Net, SQL Server 2005.
2. Knowledge and experience in Visual Basic .Net，ASP and JAVA.

3. Experience in developing banking software.

• Responsibility:
• Using software to write a survey program, and to allow the data entry to keying the questionnaire answer into the database.
• Experience Gained:
• 1. Experience in the Survercraft & Dimensions software. These soft wares are use for the marketing research company for writing CAPI and CATI program.
• 2. Experience in the MS excel, after all the data are keying, I will using MS excel to generate report to researcher.
• 3. Experience in much software, example: SPSS. Using it and generate report.