Nicholas Lian Jia Hao

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