Yan Huang Email & Phone Number

Melbourne, VIC, AU

Melbourne, Victoria, Australia

• Participation in data governance initiatives covering asset data, maintenance data and network data. Responsibilities include defining problem statement, reviewing business processes, developing and implementing data.
• Worked as a subject matter expert in a digital project, to optimise asset management decision making between reliability, risk, compliance and cost
• Winning team of Brookfield global hackathon and participation in subsequent minimum viable product development

Melbourne, Australia

• Developed supplier spend analysis in Microsoft Power BI and delivered valuable spend insights, which enabled procurement to achieve $22.5M saving in FY21 and other process improvement benefits.
• Delivered self-service BI solutions by transforming ad-hoc spreadsheet-based reports into self-service reports and dashboards in Microsoft Power BI. Organised workshops to uplift stakeholders’ data literacy and.
• Engaged stakeholders to gather requirement on new reports while continuously improving existing reports. Automated data gathering and reporting process by leveraging Microsoft Power Platform (Power BI, Power Automate.
• Initiated and liaised with the digital team to work on a project to ingest procurement data from multiple sources to the AusNet Data and Analytics (DnA) platform.
• Co-host an organisation-wide forum to share knowledge and promote collaboration on data analytics and visualisation among data analysts, data engineers and data scientists.

Melbourne, Australia

• Reshaped procurement reporting at Myer, from manual spreadsheet-based reporting to automated cloud-based reporting in Microsoft Power BI, which generated insights and identifies cost savings and process improvement.
• Transformed and consolidated static KPI reports to an interactive KPI dashboard, which delivered a holistic view of supplier spend, contract compliance, business efficiency and risk.
• Automated repetitive data wrangling and modelling process by using Power Query and Power Pivot to better focus on turning data into actionable insights. Communicated insights to procurement team and business.
• Analysed benchmark spend, pricing proposals and supplier capability during tender evaluation.

Sydney, Australia

• Created Excel dashboards to analyse spend and report procurement KPIs
• Automated data update process in Maximo, the purchasing and inventorymanagement system
• Delivered savings exceeding $100K via strategic sourcing, price negotiation, OEMpurchasing, and locking prices under contracts in 2017
• Delivered strategic sourcing of goods and services from local and internationalsuppliers for day-to-day operational activities and CAPEX projects in forms of RFP,RFI and/or RFQ

Master'S Degree, Materials Science And Engineering, Distinction

Activities and Societies: Pimlico Connection• Studies included - advanced thin film manufacturing, polymers and composites, materials.

Bachelor'S Degree, Polymer Science And Engineering, 85%