Experience

Harris Technology Group Limited (ASX: HT8)

• Australia
• Information Technology & Services
• 1 - 100 Employee

• Data Analyst

  • Jul 2023 - Present



Instock Windows

• Australia
• Construction
• 1 - 100 Employee

• Data Analyst

  • May 2022 - Jul 2022

  Instock Windows is a company that sells home building products. It gathers real estate website transaction information by various data collection methods, analyses those and uses the analysis outcome to increase sales by focused customer promotion. Being a member of Instock Windows’ cross functional technical team, I conducted the following activities: Activities and Achievement:  Performed requirements analysis and developed strategies on which data is required, specific data analysis methodology, finding patterns, trends and reporting via visualisation  Forged and maintained solid rapport with stakeholders to understand, analyse, communicate, and validate requirements for various projects  Collaborated and communicated effectively with internal stakeholders and Subject Matter Experts (SMEs) such as Business Analyst and Product Owner to brainstorm, breakdown requirements in actionable task.  Consolidated and integrated different sources of data to make a single source of truth. Transformed structured and unstructured data and verified its quality, accuracy and reasonableness.  Created Data Scripts for extraction, transform and loading (ETL), data manipulation etc by using SQL, MySQL, and Python. Merged historical datasets to remove data redundancy and duplicates. Conducted data cleaning and batch processing saving the company's time and cost  Converted traditional report structure into Business Intelligence app/dashboard using tools such as Tableau, and Power BI.  Created visual reports on intended variables’ performance, mining a massive set of data by using tools such as MySQL, Python, Seaborn, Matplotlib, and Tableau and documented interpretation  Optimised client performance KPIs through delivering strategic insights and recommendation for improvement initiatives in the form of “storytelling” by using visual reports developed from data analysis Show less



Kinet

• Data Analyst

  • Feb 2022 - Apr 2022

  Kinet is an Australian online retail shop of technology products. To better perform in online marketplace, Kinet collectes and analyses various online data to find buying trend etc. As a Product Operation Data Analyst, I have conducted the following activities for the company: Activities and Achievement:  Collected online site traffic data and used those to optimise listing page to increase user (potential buyer) success rate by recommending keywords, description, site layout, and fluency etc.  Analysed sales data, product stock data, compared the analysed outcome and identified gap. Recommended action for back-office product ordering from wholesalers.  Identified trend in sales data, customer interest while hovering over the online site (product demand) and recommended promotion for specific products, recommended following up customers on specific products  Develop visual report based on data analysis to identify client groups’ payment behaviour, key deadlines etc that helped management to send payment reminder, fulfill deadline etc  Conducted customer segmentation analysis and built customer life-cycle representation by RFM model. Formulated sales strategy. Develop and maintain a full database of IT assets and conduct data analysis to predict upgrade forecast for individual asset type. Show less



Deakin University

• Australia
• Higher Education
• 700 & Above Employee

• Data Analytics Projects

  • Aug 2020 - Aug 2021

  As part of final year projects, I have conducted the following data analytics and machine learning projects: Activities and Achievement: Project – Analyse Effectiveness of Online and Offline learning  Aggregated structured and unstructured data from multiple sources to create a master database of various attributes of the students’ enrolment, learning behaviour, time spent online, online/on-campus student type etc  Conducted data evaluation, data validation, data cleaning (via python or RapidMiner) by filtering out outliers and filling missing values and visualised existing trend  Developed analytics methods, proposed hypotheses about case study, determined whether the hypotheses were correct and supported by the analysed results.  Conducted exploratory analysis, built models via machine learning / statistics to make clustering, classification, multi-liner model, and dimensionality reduction.  Developed data trend visualisation in charts and dashboard by using Python, Tableau, Power BI. Activities and Achievement: Project - Predicting Airbnb Customer Sentiment  Aggregated structured and unstructured data from multiple sources to create a master database of various attributes of the customers and their feedback. Conducted customer feedback analysis.  Created a model in Python to predict customer sentiment. Analysed all available feature data and visualised outcome by tools such as pandas and seaborn  Achieved up to 70% customer sentiment prediction accuracy rate by using advanced data analysis methodology (logistic regression, SVM etc) and artificial intelligence/machine learning Show less



Travel Agency of Kanghui

• Analyst

  • Mar 2018 - Jul 2018

  Travel Agency of Kanghui is a Chinese travel agent. As an analyst, I have conducted the following activities there: Activities and Achievements:  Analysed company's current profile and collected data about areas requiring urgent improvements. The business intelligence helped build strategies to resolve financial issues and improve cost efficiency  Created business reports and analysed customer preferences. Analysed customer data, their previous travel data, future interest, destination, mode of transport, hotel star preference, budget etc to recommend appropriate travel plan to customers and increase sales  Maintained electronic equipment operation. Debug and solve faults of various electronic products such as computers, and network. Show less