Summary
Overview
Work History
Education
Skills
Timeline
Generic

Stephen Kenyon

Box Hill,VIC

Summary

Analytical and process-driven Data Analyst with a decade of experience in the energy and utilities sector, with deep expertise in retail billing, data integrity, exception handling, and stakeholder coordination. After managing a serious health condition over the past several years, I am now fully recovered and ready to return to the workforce with renewed focus and drive. Skilled in SQL, Excel, Power BI and complex billing systems, I bring a strong track record of identifying data discrepancies, implementing process improvements, and ensuring accurate, compliant billing operations. Known for collaborating across technical and business teams to solve problems, improve performance, and support system transitions in high-volume, regulated environments.

Overview

17
17
years of professional experience

Work History

Data Analyst

ND3
Melb, Vic
12.2024 - Current
  • Developed and optimized SQL queries for data extraction, transformation, and analysis
  • Designed and built interactive Power BI dashboards and reports for key business stakeholders
  • Conducted data cleansing, validation, and transformation to ensure high data quality and reliability

Night Storeman

Coles
Croydon, Vic
06.2021 - 12.2024
  • Handled overnight warehouse deliveries, including receiving and sorting stock
  • Used RFID scanning to verify inventory and maintain accurate stock counts
  • Checked deliveries against manifests to ensure accuracy

Billing Analyst

Citipower / Powercor
Melbourne, Vic
03.2010 - 04.2020
  • Served as Billing SME for the AMI Smart Meter rollout, supporting the end-to-end billing system transition and ensuring market compliance.
  • Led the ETSA Unbilled Sites Project, ensuring all legacy sites were billed prior to smart meter upgrades—required due to system limitations.
  • Ensured accurate and timely monthly billing for Victorian and South Australian customer sites, including large commercial and industrial (C&I) clients.
  • Investigated billing discrepancies and collaborated with internal/external stakeholders to resolve data errors, missing meter reads, and retailer disputes.
  • Conducted complex billing adjustments including tariff changes, data stream reconfigurations, meter replacements, and retailer responsibility updates.
  • Developed and maintained SQL-based billing and exception reporting tools to support data analysis, performance tracking, and revenue assurance.
  • Utilized CIS/OV (Oracle Utilities Customer Information System), MSATS, and other platforms to validate and correct metering data, market transactions, and billing outputs.
  • Collaborated with IT to test billing system enhancements and upgrades
  • Collaborated with Finance and Management to design and deliver reports using Excel / Power BI
  • Designed and delivered training sessions and onboarding workshops for billing staff and cross-functional stakeholders.

Data Analyst (Transfers)

Red Energy
East Richmond, Vic
01.2009 - 02.2010
  • Managed customer transfer processes across energy retailers, ensuring accuracy and compliance with National Electricity Market (NEM) and NEMCO regulations.
  • Monitored daily market transactions and transfer exceptions, using internal systems and market portals to validate and resolve issues.
  • Investigated and actioned failed or delayed transfers, collaborating with upstream data providers and internal teams to maintain customer continuity.
  • Worked with large datasets to match and cleanse customer and meter data, improving transfer accuracy and reducing fallouts.
  • Liaised with third-party market participants and regulatory bodies to resolve data mismatches and ensure adherence to market procedures.
  • Supported the development of transfer reporting dashboards using Excel and internal tools, helping leadership track volumes, exceptions, and trends.
  • Contributed to system testing and process improvement initiatives aimed at reducing transfer delays and enhancing customer onboarding.

Education

PL-300 Power BI Data Analyst Associate -

Microsoft
03-2025

Skills

  • SQL – Data extraction, joins, views, segmentation, complex queries for billing validation, exception handling, and reporting
  • Excel – Advanced use of PivotTables, Power Query, XLOOKUP/VLOOKUP, and formula-based automation for data analysis and reporting
  • Data Modeling – Designing and managing scalable schemas and relational structures in SQL and Excel for operational and financial reporting
  • Reporting & Analytics – Building reports and databases to monitor revenue, billing accuracy, transfer exceptions, and operational performance
  • Error Analysis & Resolution – Identifying and correcting data discrepancies, including NEMCO error codes, market exceptions, tariff changes (mapping) & data stream configuration
  • Collaborative Problem Solving – Partnered with internal departments and external market participants (AEMO, LNSPs, Retailers) to investigate and resolve billing discrepancies and data exceptions across multiple systems
  • Energy Market Knowledge – Practical understanding of NEM/NEMCO regulations, market settlements, customer transfers, and billing cycles
  • UAT & Process Improvement – Leading and participating in User Acceptance Testing (UAT) and system upgrades to enhance billing accuracy and workflow efficiency
  • Retail Energy Systems Proficiency – Skilled in navigating and interpreting data across multiple internal platforms and market-facing systems for billing, metering, and customer transfers

Timeline

Data Analyst

ND3
12.2024 - Current

Night Storeman

Coles
06.2021 - 12.2024

Billing Analyst

Citipower / Powercor
03.2010 - 04.2020

Data Analyst (Transfers)

Red Energy
01.2009 - 02.2010

PL-300 Power BI Data Analyst Associate -

Microsoft

Similar Profiles

CREATE PROFILE
Stephen Kenyon