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 quality rules (SQL), Power BI reporting, etc. • 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 self-service capability.• 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 and Power Apps).• 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 opportunities.• 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 stakeholders to enable data-driven decision making.• 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%