Scope: Analyst for the Health, Safety, Wellbeing, & Organisational Development team, developing an extensive national dataset for consistent analysis and reporting across the organisation.• Delivering comprehensive executive reports to the Deputy Commissioner and Executive Leadership Teams, providing critical insights on organizational risk, financial status, and strategic initiatives.• Facilitate data discovery and collection across Te Whatu Ora, standardizing district datasets to significantly enhance the quality and consistency of national reporting.• Support national safety and wellbeing initiatives by providing expert advice, actionable insights, and comprehensive reporting to advance organisational safety measures.• Overcome infrastructure challenges to compile a reliable national dataset, delivering detailed and insightful reports to district managers to inform decision-making and performance evaluation.

Data Analyst Business Partner supporting People & Capability for Nelson Marlborough DHBScope: Analyst for the People and Capability Team providing reporting to internal & external parties on workforce, wellbeing, learning, and recruitment.• Developed and maintained a suite of Power BI reports for managers, including a comprehensive wellbeing report featuring current and historical statistics on overtime, appraisals, leave balances, leave taken, turnover, and various other indicators.• Integrated previously unobtainable data into reporting, enhancing visibility and operational insights for recruitment and learning departments.• Gained familiarity with numerous contracts and staffing variables while compiling detailed workforce, union, and OIA extracts.• Led the implementation of Power BI within Nelson Marlborough DHB, including strategy development, governance, and training.• Resolved issues from the AMS cloud migration, addressing collation errors and rewriting SSRS reports.• Migrated historical reports from Tableau and Crystal Reports to Power BI, significantly reducing duplication and ensuring consistent reporting.

o Delivery, development and design of BI solutions that are used across the organisation and by its stakeholders; including operations managers, clinical control, district health boards, and any number of other agencies.o End to end development, from understanding business requirements to designing the dashboards that use the data, making it easier for the business to find and use data.o Align and validate multiple data sources to create a complete dataset for contractual reporting to the DHBs, the ministry and other stakeholders.o Provide training and support to other members of the BI team to develop their SQL and PowerBI skillsets.o Serve as a source of technical expertise, sharing my experience and knowledge of the datasets including how they link and the challenges associated with each dataset.o Create and maintain national performance reporting for the Strategic Operations and Clinical Committee including traffic light reports, trajectory reports and production hours reportingo Play a key role in implementing technology best practice, guidelines and repeatable processeso Continue to develop and test datafeeds from multiple sources to improve reporting integrity across the business

o Create and maintain national performance reporting for the Strategic Operations and Clinical Committee including traffic light reports, trajectory reports and production hours reportingo Generated a process to incorporate multiple data sources to into existing patient transfer reports to satisfy ongoing contractual reporting requirements o Produce and support a numerous reports for various parts of the business and its stakeholders, including operations managers, clinical control, district health boards, and any number of other agencies. o Developed a system for reporting on operational hours produced by merging three data sources into a reportable format

o Propose solutions and provide in depth analysis to senior management for presentation and discussion in leadership meetings o Manipulated CAD data into traffic light and trajectory reports for executive level managers to monitor national performance against various KPIs.o Deliver national training and support for the Lightfoot Signals from Noise performance management tools, working with Lightfoot Solutions to provide daily performance monitoring capabilities to managers across St John.o Simulate proposed changes using Optima Predict and write reports outlining the effects of various scenarios to assist managers to make informed business decisions.

 Compilation of statistics for monthly KPI reporting and contractor invoicing, through Access database management and complex Excel calculations. Analysis and verification of obtained site data Data handling including data verifications, account maintenance and billing adjustments to ensure customer satisfaction and data accuracy Investigation of metering issues to resolve standing issues and promote accurate billing

 Scheduling and management of night and weekend meter reading project, data entry, and database maintenance. Meter reading and project management regarding hard to access sites, including investigation and handling of key room access issues. Cost analysis & reporting related to access solutions to ensure maximum success for expenditures. Data handling including data verifications, account maintenance and billing adjustments