Learn Data Skills
Guan Lin Lau

Guan Lin Lau

Analyst Programmer

Sift Analytics


My Portfolio Highlights

My New Course

Introduction to Python

Problem-solving virtuoso, decoding complexity with a data-driven approach.

My Work

Take a look at my latest work.


Intermediate SQL Queries


Understanding Data Science


Introduction to Python

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

My Work Experience

Where I've interned and worked during my career.

SIFT Analytics Group | May 2022 - Present

Business Analytics Consultant | Pre-Sales Consultant

End to end data solutioning services. Assisted in AWS server setup and configuration to enable seamless data connections. (GDC2, GCC, AWS with Application Load Balancer environment) Perform software upgrades according to deployment best practices. Liaise with IT in overcoming software implementation complexities. Perform catered demo unique to customer infrastructure and usecases. Drive requirement gathering sessions to ensure comprehensiveness. Advise on Data Engineering and Data Modeling best practices. Fulfilling knowledge gaps with users, with necessary means.
Show More

Nippon Paint Singapore | Mar 2020 - May 2022

Data Analyst

Building BI Report to facilitate data-driven decision making including: i) requirement gathering process with users and stakeholders, department heads ii) brainstorming solutions with department heads, AGM and IT manager, including WHAT data is required, HOW will user relate to the visualized data iii) Visualization development from pulling raw data, engineering, transformation, developing, testing (Visualization pipeline) iv) Presents the solution to users/stakeholders. Writes documentations for users/stakeholders v) Post-development improvements and maintenance after collecting user feedback Job scope: - Data Visualization with Qlik stack (QlikView, Qlik NPrinting, Qlik VBScript Macro), Tableau Prep, Tableau & spreadsheet. including: i) Demand Planning ii) Sales Performance iii) Inventory Management iv) Microeconomics approach on change of manufacturing cost based on recipe v) Production Formulation vi) Cost Reduction report vii) Cost Impact Analysis from Raw Material Price Surge situation - Working with data from SAP S4/HANA Database, HANA Studio, SQL, Excel. - Engage, maintain and coordinate with vendors on internal/external software systems. - Regional exposure working with overseas colleagues from Myanmar and Vietnam. - Manage and Coordinate Projects with software vendors on new enhancements/requirements. - Provide Support for Customer Relationship Management software (CRM) for professional painting services (Professional Painting Services, JContact by Juris Technologies)

Juris Technologies | Apr 2019 - Jul 2019

Software Engineer

-Onboarding program on loan origination process, company coding framework and SQL DDL DML. -Liaise with users on change requests, bug fixes and enhancements. -Added multiple interface features, fixed UI issues, implemented more user action logging and etc with the use of PHP, JavaScript, jQuery AJAX and Toad for DB2 SQL. -Wrote documentation and deployed updates/changes. -Version Control with git, Agile Scrum workflow with Trello and daily standup meetings to keep the team updated on progresses. -Worked a side project separately with tech lead involving JavaScript table output logic.

My Education

Take a look at my formal education

Bachelor of Information Technology(Security Technology), Computer ScienceMultimedia University | 2019

About Me

Guan Lin Lau

Guan Lin hasn't filled in a bio text

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free