![Penny Robards [ Data & Analytics ]](http://images.squarespace-cdn.com/content/v1/6a7e4235e306416abe81493e/d0c2cd8e-c0ae-45fd-b300-da177313aae2/Penny-Robards-Data-%26-Analytics-Logo.png?format=1500w){kind=logo}
EXPERIENCE
Twenty-seven years in the data itself
Senior, hands-on data consultant. Independent since 2000, with engagements across government, justice, finance, energy, logistics, health, manufacturing and retail supply chains. I work in the data itself: profiling it, tracing it across systems, modelling it, and building the platform and reports on top — with checks at every layer so the figures hold when they reach the executive table.
25
years in data
2000
independent since
8
sectors
40+
organisations
How the work fits together
Data warehouse
Source data profiled before it is modelled. Views and dataflows built to a documented standard, with cleansing and exclusion rules applied consistently and figures reconciled back to source.
Power BI platform
Workspace architecture, service-principal refresh, deployment standards and a semantic model that carries the business definitions — one place where a measure means one thing.
Reports people open
Board packs, sales and operations reporting, and dashboards that read at a glance and drill down to the record behind any figure. Refreshed on schedule, so the report is ready when the meeting is.
Data quality monitoring runs through all three. Monitoring views watch the source continuously, and known gaps stay visible in the report, so the numbers can be trusted and the reason behind any exception is a click away. Everything is documented from source field to report calculation, with a data dictionary, so there is no discrepancy about what a figure means and the next person can pick it up.
selected engagements
County Court of Victoria
Senior BI Developer / Data Consultant
July 2025 – September 2026
Azure SQL · T-SQL · Power BI · dataflows · Tabular Editora
Criminal Division reporting platform over the court's case management system for the CEO and judges. Produced the reference documentation and lineage diagrams for the warehouse (four schemas, about 122 views) that the court now works from. Built the SQL view suite with a standard cleansing and exclusion pattern, service-principal dataflows, and a master semantic model (90 tables, 600+ measures). Established the court's data quality and definition register — each item with evidence, business owner and proposed rule — and monitoring views that keep the source under continuous watch. Delivered the Criminal Division, Koori Court, First Nations and CISP reports, including a unique-key design for accused individuals that makes recidivism measurable.
Linfox
Senior BI developer
April – December 2024
Snowflake · Power BI · Blue Yonder · SAP BusinessObjects · Crystal Reports
Migrated logistics reporting from BusinessObjects and Crystal Reports to Snowflake and Power BI for warehouse, fleet and freight operations serving retail and FMCG customers. Mapped each legacy dataset to its source and reconciled every legacy report against the new platform before cutover. Near-real-time warehouse reporting (inventory levels, stock flow, client billing on space utilisation); Digital Freight Network dashboards tracking delivery status end-to-end; fleet and safety reporting combining telematics with the transport management system; cold-chain monitoring with live temperature tracking for pharmaceutical and food deliveries.
NEOS Life
Senior BI developer, sole developer
January 2020 – December 2023
SQL Server · T-SQL · Power BI · dataflows · semantic models
Four years as the sole BI developer for a life insurance start-up. Rebuilt the SQL Server data warehouse — views, stored procedures, dataflows and semantic models — and built the company's sales and operations reporting from the ground up. Data monitoring reports capture data issues as they occur. Live dashboards on the office screens: applications needing attention within set timeframes, sales targets, bank reconciliation.
AGL Energy
Senior BI consultant, several engagements
2017 – 2019
SAP HANA · SAP BW · Azure SQL · Hadoop · Tableau · Power BI
Reviewed the applications, databases, tools and practices used across AGL Energy Markets and the wider business to access, analyse and distribute information; defined the assessment criteria and delivered the recommendation for the database, data modelling and BI toolset. Separately, consolidated five large sales datasets in HANA calculation views for the sales and marketing dashboards.
NSW Government
Department of Finance · Department of Property
2018 – 2019
SAP BW · SQL Server · Power BI
The NSW Government's consolidated profit and loss and capex dashboard, designed with the CFO and directors for the executive, secretary and minister. The NSW Government property portfolio dashboard, designed with the CEO and directors: asset value, sales, condition, operating cost and utilisation. Power BI training for both.
Lion
Senior BI Consultant
August 2019 – 2020
Power BI · SAP BW · SAP HANA · Essbase
Sales analytics for Australia and New Zealand and the consolidated profit and loss for New Zealand operations, built in Power BI over an SAP BW and HANA estate. Designed and delivered Power BI training for the SAP ecosystem and mentored the in-house developers.
Pillar Administration
BI consultant, several engagements
2013 – 2017
SQL Server · WhereScape RED · SAP BusinessObjects · Crystal Reports
Superannuation administration reporting in a high-volume environment: member balances, transactions, nominations and switches across client funds. APRA regulatory reporting from SQL stored procedures; consolidated the stored procedures and reports for four funds; migrated more than 500 Crystal Reports to a new version.
Earlier work
Energy Australia / Ausgrid (network asset and maintenance reporting; the executive capex, opex and HR dashboard, later featured at SAP's customer case studies event) · Subaru (national dealer-network reporting) · Central Health Care, Sigma (pharmaceutical distribution operations dashboard, showcased at SAP's 2018 conference) · Liberty OneSteel · Parmalat (SAP EWM rollout at the Lidcombe distribution centre) · GE Healthcare (maintenance of 1,000+ imaging systems across ANZ) · Cochlear (clean-room manufacturing, FDA and ISO 13485 traceability) · Australian Hearing · Sydney Cardiology Group · Downer EDI · Kimberly-Clark · NSW Health · Fairfax Media
CLIENTS BY SECTOR
Government and justice. County Court of Victoria, NSW Department of Finance, NSW Department of Property, NSW Health, Department of Immigration, Cancer Institute, The Children's Hospital
Energy. AGL, Ausgrid, Energy Australia, Macquarie Generation
Finance and insurance. NEOS Life, Pillar Administration, Commonwealth Bank, Westpac, St George, NAB, AMP, Vero, KPMG, Citibank (London)
Logistics, manufacturing and FMCG. Linfox, Parmalat, Liberty OneSteel, InfraBuild, Kimberly-Clark, 3M, BOC, Norske Skog, Toyota, Lion
Health. GE Healthcare, Cochlear, Sigma, Australian Hearing, Sydney Cardiology Group, Roche
Other. Harvey Norman, Subaru, Allen & Unwin, Optus, Fujitsu, Fairfax Media, SAP (trainer)
TOOLS
Data platforms. SQL Server, Azure SQL, Snowflake, SAP HANA, SAP BW, Analysis Services, WhereScape RED, SAP Data Services
Modelling and reporting. Power BI (semantic models, DAX, Power Query M, dataflows, Tabular Editor, Deneb), SAP BusinessObjects, Tableau
Practice. Data profiling and root-cause analysis, data quality registers, cleansing and exclusion rules, monitoring views, definitional sign-off with business owners
Education. Bachelor of Business (Accounting, Business Law), UTS · Bachelor of Fine Arts, National Art School
HOW I WORK
What you can expect
Scoped before it starts
An agreed scope, timeline and cost, in writing. Changes are variations, discussed before they happen. You'll never receive an invoice you haven't seen coming.
Readable at a glance, and to the record beneath
The story is clear on first look, and any figure drills down to the detail behind it. Metrics are defined once, in the data dictionary, and mean the same thing on every page.
No more complicated than it needs to be
The simplest design that holds up. Documented from source field to report calculation, so the next person — or your own team — can pick it up without reverse-engineering it.
Handed over properly
Documentation, a data dictionary, training where it's wanted, and a platform your people can maintain and extend.
Ready when the meeting is
Reports refresh on schedule. The board pack or the sales report is there at the push of a button, every time, without anyone assembling it by hand.
Reliable
Data quality monitoring is built into the platform, not bolted on afterwards. Source data is checked before it is modelled, figures reconcile at each layer, and known gaps stay visible rather than being quietly filtered out.
You don't have to manage it
I take the work from scoping through to handover, keep you informed as it goes, and bring you decisions, not problems. Definitional questions come to you with the evidence and a proposed answer.