Data Engineer

• Jul 2021 - Present

Business Data Analyst

• May 2020 - Jul 2021

•Identified potential data quality errors by using View for data quality assurance; •Performed data management and data extraction by SQL queries including window function; •Did data wrangling and data analysis via various tools including Excel, Pivot table and Python; •Created and improved Tableau dashboard to visualize valuable information to support decision making; •Provided monthly analysis reports to assist clients locating and identifying the problems and potentials; •Communicated regularly with clients to gather and clarify new and potential analysis needs; •Worked closely with business and IT team to clarify clients’ requirements and accurately translate business requirements into technical requirements. Show less

Data Analyst

• Sep 2019 - Dec 2019

• Performed cleansing and de-duplication of data in the national database to increase the data quality of national database; • Did all sorts of wrangling on the raw data in various data sources through Python, Excel and Tableau Prep for further data analysis; • Created Gymnastics Australia first national dashboard in Tableau to identify key metrics and transform raw data into meaningful and actionable information for national operation managers; • Migrated all national reports from Crystal Reports to SSRS Reporting solution with retrieving data from SQL server; • Assisted project manager in providing management status reports through pivot table on monthly basis. Show less

Marketing Specialist

• Feb 2018 - Aug 2019

• Worked with the marketing team to create marketing plans and operate the company's official account of WeChat; • Cooperated with marketing team to develop HTML email for sales promotion; • Supported online course delivering in providing technical assistance and troubleshooting; • Responded customers’ request in terms of courses and other technological issues; • Communicated to escalate and report complaints to the appropriate level to achieve improve customer satisfaction. • Worked with the marketing team to create marketing plans and operate the company's official account of WeChat; • Cooperated with marketing team to develop HTML email for sales promotion; • Supported online course delivering in providing technical assistance and troubleshooting; • Responded customers’ request in terms of courses and other technological issues; • Communicated to escalate and report complaints to the appropriate level to achieve improve customer satisfaction.

Sales Specialist

• Nov 2015 - Apr 2016

•Conducted sales analysis in multiple dimensions to evaluate retail performance and identify opportunities and potential risks by using excel and pivot table; •Provided customer focused and friendly service in a fast-paced environment; •Collaborated across teams to effectively perform daily business operation tasks including visual merchandising and stock taking. •Conducted sales analysis in multiple dimensions to evaluate retail performance and identify opportunities and potential risks by using excel and pivot table; •Provided customer focused and friendly service in a fast-paced environment; •Collaborated across teams to effectively perform daily business operation tasks including visual merchandising and stock taking.