Asa Wang

Asa Wang

City Ambassador

Followers of Asa Wang315 followers
location of Asa WangAuckland, Auckland, New Zealand

Connect with Asa Wang to Send Message

Connect

Connect with Asa Wang to Send Message

Connect
  • Timeline

  • About me

    Inventory Analyst | Master of Business Analytics| Data Analytics | Supply Chain Management Specialisation

  • Education

    • Victoria University of Wellington

      2019 - 2021
      Bachelor of Commerce - BCom Tourism and Travel Services Management

      Activities and Societies: work out and basketball -Minor in Information Systems.-Core papers: Average A range for Tourist Behaviour; Event Management; Tourist Destination Management; Tourism Market; Average A range for Database; Business Analytics and Business Process Design-Leaded a global team with 8 students across the world to complete a sustainable proposal report and won most creative award .

    • The University of Auckland

      2023 - 2024
      Master of Business Analytics Logistics, Materials, and Supply Chain Management Distinguished

      Core Papers : Information Management Tool (SQL Server) ; Business Analytics Tools(Python) ; Data Visualisation for Business(PowerBI) ; Predictive Modeling Business Analytics (R) Decision Analytics (Excel) ; Analysis of Business Problems (SPSS) ; Advanced Project Management; Supply Chain Optimistion

  • Experience

    • WellingtonNZ

      Jul 2019 - Mar 2020
      City Ambassador

      Seasonal Volunteer programme, worked with WellingtonNZ and helped to deal with hospitality & tourism missions.• Responsible for welcoming tourists.• Providing information consultation.• Guiding visitors to visit attractions to ensure tourists' satisfaction and comfort.

    • West Bank English

      Nov 2019 - Feb 2020
      Teaching Assistant Tutor
    • IRelax NZ

      Dec 2020 - Aug 2021
      Sale consultant
    • Seekom NZ

      Sept 2021 - Aug 2022
      System Support Specialist

      Main Duties:• Supported existing system users with requests via emails, online chats, and telephone.• Set up accounts and integrate with OTA channels like Booking.com. • Conducted monthly system training webinars.• Identified and solved booking issues or system faults promptly.Addition Duties:• Collected and analysed people's search preferences through tourism booking websites. Formulated reasonable advertising for our customers on Google Hotel Ads to increase booking volume by 3%-5% compared to previous months. • Imported and mapped the customer's previous datasets into our system database. • Conducted system testing upon the release of new functions. Show less

    • JH Electrcial and Appliance Ltd

      Aug 2022 - Apr 2023
      Retail and Wholesale Consultant

      -Created detailed sales presentations to communicate product features.-Consistently achieved the retail sales target of $55,000 for three consecutive months, with the highest sales reaching $73,000. -Successfully expanded the purchasing business by engaging in in-depth discussions with property developers and cabinet installation companies, resulting in a single order of up to $50,000.-Engaged with existing and potential customers.

    • YouTutor Ltd.

      Apr 2024 - now
      Private Tutor

      Support students (tutees) to become more independent learners, persist in school, and reach their goals.Provide individual and/or group tutoring to students across a broad range of courses based on their personal area of expertise.Meet with students to clarify and review concepts taught in class, explain processes and help students solve specific problems.

    • State of Flux

      Apr 2024 - Jun 2024
      Supply Chain Analyst

      Developed a user-friendly supplier performance metrics model using a multi-dimensional KPI scoring system to evaluate supplier performance accurately. The model not only optimized supply chain management but also enhanced overall business performance and competitiveness.Industry Research: Conducted a comprehensive industry survey to gather critical data on supplier evaluation criteria, establishing a solid foundation for model accuracy.Data Simulation and Analysis: Utilized Python to simulate supplier KPI data and implemented the Analytic Hierarchy Process (AHP) for critical indicator screening, ensuring precise KPI weight allocation for optimal scoring accuracy.Database and Reporting Enhancement: Created an Entity-Relationship Diagram (ERD) database to manage multi-dimensional KPI data. Leveraged Excel and Power BI to advance data analysis and visual reporting, providing clear decision support.Stakeholder Engagement: Collaborated with project sponsors, end-users, and technical teams to gather feedback and refine the system. This ensured the model was robust and widely adopted, aligning with business objectives and user needs. Show less

    • Fox & Gunn

      May 2024 - now

      Predictive Analysis for Inventory Needs: Conduct sophisticated inventory analysis that factor in customer demands, product levels, and ordering reviews. Utilise Python,R studio and Excel for building predictive models that simulate demand. These models support the strategic placement of orders, ensuring that inventory management is both responsive and cost-effective.KPI Tracking and Performance Reporting: Implement key performance indicators (KPIs) to monitor and report on inventory efficiency. Utilize SSIS and SSAS to integrate data effectively, creating comprehensive dashboards in Power BI that provide real-time insights and facilitate strategic decision-ordering. This strategic approach helps in optimising order timings, quantities and maintain the ideal inventory levels and minimizing costs.Data Integration and Automation: Employ SSIS and SSAS to streamline the consolidation of inventory data into a centralized system. This integration feeds into Power BI, where I design and maintain automated inventory reports. These reports provide real-time insights into inventory status, performance metrics, and potential improvements.Collaborative Reporting: Produce regular inventory reports and dashboards that offer actionable insights to stakeholders, facilitating strategic discussions and decisions that align with business goals and market trends. Show less Advanced Product Market Research: Conducted in-depth research on product pricing, features, and market potential, utilizing Python for efficient data scraping from online sources which provided a robust understanding of the product landscape.Data Extraction & Performance Analysis: Extracted critical data from Porella (ERP system) and integrated customer stock-on-hand data to monitor and adapt inventory levels. This ensured optimal performance against varying service and demand requirements.Predictive Analysis & Trend Identification: leverage various data such as sales and inventory data from Bunnings, Mitre10 Group, Placemakers, etc. Utilized Python and R studio to conduct supervisory learning models for predictive analytics, enabling the identification of customer demands and emerging market trends, and anticipating market behaviors to optimize strategic responses.Advanced Data Analytics & Reporting: Leveraged SSAS (SQL Server Analysis Services) for in-depth exploration of the data cube focusing on sales and inventory analysis. Applied data mining to extract actionable insights, which were further enhanced by integrating with Power BI to develop automated dashboards providing dynamic, insightful visualizations to the sales and inventory team for quick decision-making.Additional Duties:Cross-functional Collaboration: Worked closely with marketing and product design teams to incorporate market insights into packaging design and communication strategies, ensuring alignment with consumer preferences and market trends. Show less

      • Inventory Analyst

        Sept 2024 - now
      • Product Analyst

        May 2024 - now
  • Licenses & Certifications

    • Data Science and Machine Learning Fundamentals

      Corporate Finance Institute
      Sept 2023
      View certificate certificate
    • Fundamentals of Data Analysis in Excel

      Corporate Finance Institute
      Aug 2023
      View certificate certificate
    • Quantium - Data Analytics Job Simulation

      Forage
      Jan 2024
      View certificate certificate
    • KPMG AU - Data Analytics Job Simulation

      Forage
      Sept 2023
      View certificate certificate
    • Accenture North America - Data Analytics and Visualization Job Simulation

      Forage
      Apr 2024
      View certificate certificate