Nicholas Lian Jia Hao

Nicholas Lian Jia Hao

Marketing Assistant

Followers of Nicholas Lian Jia Hao271 followers
location of Nicholas Lian Jia HaoSingapore, Singapore

Connect with Nicholas Lian Jia Hao to Send Message

Connect

Connect with Nicholas Lian Jia Hao to Send Message

Connect
  • Timeline

  • About me

    Business Operation Analyst at Dyson

  • Education

    • Nanyang Polytechnic

      2014 - 2016
      Diploma in Business Enterprise IT Information Technology GPA 3.23/4
    • Singapore University of Social Sciences (SUSS)

      2019 - 2023
      Bachelor of Science - Business Analytics Data Processing
  • Experience

    • Global Sources

      Mar 2016 - May 2016
      Marketing Assistant

      • Compiling And Distributing Statistical Information Using Microsoft Excel• Organize Market Research• Comparing Of Keyword Trends And Proposing New Keywords For Search Engine Optimization (SEO)• Admin Work For PPC Keywords

    • Singapore Army

      Jul 2017 - Jul 2019
      Network Signaler
    • Oddity Studios

      Nov 2019 - Apr 2021
      Data Quality Analyst

      • Cleaned real life customer data and built Forecasting and Expected Item charts to understand better and improve business efficiency and processes.• Provided a list of clean and accurate test case data for testing of client’s work to ease the Testing process in a web development process in which has led to the swift succession of project completion.• Improved client’s database structure by restructuring and editing existing database tables, in which has led to the implementation of more user-friendly functions.• Expanded client’s excel workbook by implementing VBA macros and formulas into existing sheets to automate sheets.• Worked directly with major stakeholders of companies to coordinate and improve on existing projects in which has played a part in the client’s satisfaction to go ahead with subsequent projects.• Participated in project pitch presentations to clients. Managing to secure two successful projects from these project pitches. Show less

    • Bosch ASEAN

      Jun 2021 - Jan 2022
      Marketing and Business Coordination Intern

      • Constructed three dashboards to ensure data cleanliness from product managers in which has led to an increase in 80% improvement in overall pending data cleanliness for the APS region.• Performed market research on pending innovations to monitor competitors and current market standings.• Extended my knowledge of excel pivot table and queries to ensure that data is cleaned and properly managed.• Ensuring that data from current data suppliers are corresponding to current data and no overlaps in the database system.• Crafted out three different excel VBA macros to automate processes within Bosch, in which has led to an increase in 90% productivity when done manually.• Assisted in the yearly data audit process to ensure that data security is not compromised and adhering to the standards of the law and company policies. Show less

    • NielsenIQ

      May 2022 - Oct 2022
      Customer Success Team (Retail Intelligence)

      • Constructed an automated PowerBI dashboard to display top brands in each category using Excel VBA that had led to a 50% increase in generation time.• Crafted out bi-weekly newsletter for the APAC region on top trends in the various industries.• Automated in-house program scripts to build and churn out necessary data for client references.• Performed data cleaning processes to ensure that data is accurate to clients. • Generated data samples for potential clients to view based on their customized needs and wants. Show less

    • Dyson

      Sept 2023 - now
      Graduate Business Operation Analyst
  • Licenses & Certifications

    • Personal Money Management and Financial Planning

      Singapore Polytechnic
      Jul 2020
    • Introduction to Stocks & Bonds

      Singapore Polytechnic
      Jul 2020
    • INTRODUCTION TO PERSONAL INVESTING

      Singapore Polytechnic
      Jul 2020
    • DEVELOPING A STRATEGIC BRAND BLUEPRINT

      Temasek Polytechnic
      Jan 2020
      View certificate certificate
    • 101 OF A WINNING BUSINESS PLAN

      Temasek Polytechnic
      Jan 2020
      View certificate certificate
    • Python Bootcamp From Zero to Hero in Python

      Udemy
      Nov 2020
      View certificate certificate
    • The Complete SQL Bootcamp 2020: Go from Zero to Hero

      Udemy
      Dec 2020
      View certificate certificate
    • INTRODUCTION TO BRAND STRATEGY

      Temasek Polytechnic
      Jan 2020
      View certificate certificate
    • Google Analytics Essential Training

      Tertiary Infotech Pte Ltd
      Nov 2020
    • 12 ESSENTIALS OF DIGITAL MARKETING

      Temasek Polytechnic
      Jan 2020
      View certificate certificate
    • PROFESSIONAL F&B MENU PLANNING

      Temasek Polytechnic
      Jan 2020
      View certificate certificate
  • Volunteer Experience

    • Student Volunteer

      Issued by BLESS Reading Programme on Jan 2020
      BLESS Reading ProgrammeAssociated with Nicholas Lian Jia Hao