Nicholas Wear
Camden,NSW
Summary
Detail-focused data analyst with expertise in data warehousing, process validation, and business needs analysis. Skilled in understanding customer requirements and transforming them into actionable project plans. Committed and diligent, with a genuine passion for big data. Enthusiastic about sharing knowledge and coaching others in the field of Power BI as a power user.
Overview
8
8
years of professional experience
1
1
Certification
Work History
DATA ANALYST
Sydney Water
2022.08 - Current
- Responsible for developing and maintaining reports and dashboards for Sydney Water's Business Connect teams and partners.
- Utilised data visualisation tools to effectively communicate business insights.
- Integrated multiple sources of disparate data into cohesive datasets using ETL processes, improving overall analytic capabilities.
- Leveraged business intelligence tools including Power BI, Power Automate, Power Apps, SAP Analytics Cloud, Databricks.
- Managed over 50 dashboards, 30 data sets, 30 workflows and 6 apps with other Data Analysts.
- Acted as Team Manager Support Services whilst they were on leave and represent them in stakeholder meetings when they are unable to attend.
- Assisted Team Manger with recruiting additional Data Analyst, including shortlisting applications, designing a technical assessment and forming part of the interview panel.
- Coaching new team members on Power BI best practices and advanced techniques such as Power Query custom functions and calculation groups.
- Worked with People & Culture leadership team to transition the People & Culture Corporate Performance Report from PowerPoint into Power BI, including automating the data extraction and KPI calculations.
- Developed dynamic row level security model to provide secure access to HR dashboards including excessive leave and workplace relations.
- Worked with Team Manager Support Services to implement a project register, using Power Platform tools to develop an app, workflows for managing data updates and a dashboard.
- Liaise with external vendors to set up data sharing and collection processes such as Inseego, LeasePlan, Poppulo and Lifeworks Health Services.
- Collaborate with other report analysts across Sydney Water including providing advice and technical assistance.
- Selected to be part of Emerging Leaders forum to discuss management principles and experiences.
BUSINESS INTELLIGENCE & PERFORMANCE REPORTING ANALYST
Camden Council
2020.02 - 2022.07
- Responsible for coordinating and implementing performance reporting mechanisms to support the monitoring of Council's key activities, services, strategies and plans.
- Increased efficiency by streamlining data analysis processes and implementing automation tools.
- Streamlined reporting procedures by creating user-friendly dashboards for easy access to key performance indicators.
- Enhanced customer satisfaction rates through detailed analysis of customer feedback data and subsequent improvements in service offerings.
- Coordinated the monthly reporting on Council's Corporate Health Indicators.
- Responsible for the development and ongoing administration of a dozen Power BI data sets and reports at Council, including service level monitoring, contact centre analytics, project portfolio analytics, safety occurrence reporting, land acquisitions register and innovation.
- Managed Council's engagement of Deloitte Consulting to develop an Organisational Corporate Performance Measurement & Reporting Framework, provided input and feedback as a subject matter expert and managed Deloitte's engagement with key Senior Managers and Executives.
- Performed a review of Council's Corporate Health Indicators (KPIs) in 2020 to provide recommendations on relevant KPIs for measuring organisational health.
- Worked as project manager and subject matter expert on a financial integration project between finance and CAMMS systems.
- Played a key role during COVID-19 pandemic and lockdown by providing weekly insights to Council's executives and Crisis Management Team.
ACTING PROJECT PORTFOLIO MANAGEMENT COORDINATOR
Camden Council
2022.02 - 2022.05
- Improved team productivity with regular communication and progress updates, fostering a collaborative work environment.
- Led the implementation of changes to ePMO business papers including new project analytics.
- Recruited a new ePMO Business Partner.
- Performed audit of CAMMS project system to ensure project portfolio data accuracy.
- Fostered a relationship with Deputy Chief Financial Officer to ensure collaboration between ePMO and Finance to better support the Project Manager community at Council.
- Managed relationship with Council's CAMMS Customer Experience Manager through fortnightly meetings to assist with management of CAMMS software.
BUSINESS IMPROVEMENT OFFICER ANALYST
Camden Council
2017.02 - 2020.02
- Acted as Corporate Performance Coordinator from Oct 2019 – Feb 2020 which included transitioning the team's projects into the corporate project management system.
- Responsible for coordinating and implementing continuous improvement projects to support and facilitate a continuous improvement culture and best practice service delivery across Council.
- Coordinated cross-functional teams to address complex issues, leading to more efficient problem-solving processes.
- Implemented process improvements that streamlined workflows, reducing redundancies and increasing operational efficiency.
- Utilised data-driven decision-making techniques to inform strategic planning processes and measure progress towards goals.
- Provided analytical evidence for a successful business case for additional staffing for the Customer Relations team.
- Call Centre KPI improved from 78% to 83% for 14 consecutive months.
- Managed the Customer Request Management (CRM) Review, successfully delivering the project within the proposed deadline, despite a major system upgrade and organisational changes.
PROJECT MANAGER COMPLIANCE INSPECTIONS AUDIT
Camden Council
2019.01 - 2019.06
- Planned, designed, and scheduled phases for large projects related to a process improvement audit.
- Developed project schedules for the documentation of key inspection processes and implementation of a register to manage key data and track workflows for the Onsite Sewage Management program.
- Supported the Manager of Environment and Regulatory Services and their team leaders during implementation.
- Engaged and negotiated timeframes with several key stakeholders including SMEs, senior managers and executives.
Education
Microsoft Certified - Power BI Data Analyst Associate
Microsoft
01.2021
Bachelor of Mechanical Engineering -
The University of Sydney
Sydney, NSW01.2019
Skills
- Data Visualisation and Presentations
- Data Analysis
- Excel Functions
- SQL
- Data Cleaning
- Attention to Detail
- Data Modeling
- ETL processes
- Project Management
- Data Storytelling
Training
- Finance for Non-Finance Managers 2024
- SAP Analytics Cloud Training by Bluetree Solutions 2024
- Putting ITIL Into Practice: Applying ITIL 3 Foundation Concepts by LinkedIn Learning 2023
- Plain English Training by Sydney Water 2022
- Local Government Australasian Management Challenge Mentor 2022
- Camden Council Leadership Capability Development Program 2021
- Data Visualisation & Storytelling Course, USYD Centre for Continuing Education
- Power BI Advanced Data Visualisation, Agile Analytics
- Dashboard In a Day (DIAD) Power BI training, Microsoft presented by Altis Consulting
- Power BI Training for Government Course, DataTale
- Introduction to Information & Data Governance, Camden Council
- Personal Development Training Communication Skills, Camden Council
- Local Government Australasian Management Challenge participant 2020
- Part Qualification Diploma of Project Management (SG00004903), Upskilled
- Enhancing Local Government Service Delivery, UTS Institute for Public Policy and Governance
- Facilitation Skills Masterclass, Australian Institute of Training and Development
- Lean Six Sigma Foundations, UTS Business School
- Corporate High Performance: Lean Competency Development, City of Sydney
- Registers Administration Training & Module Configuration Training, Civica
- Registers Operational Training, Civica
Certification
- Finance for Non-Finance Managers 2024
- SAP Analytics Cloud Training by Bluetree Solutions 2024
- Putting ITIL Into Practice: Applying ITIL 3 Foundation Concepts by LinkedIn Learning 2023
- Plain English Training by Sydney Water 2022
- Local Government Australasian Management Challenge Mentor 2022
- Camden Council Leadership Capability Development Program 2021
- Data Visualisation & Storytelling Course, USYD Centre for Continuing Education
- Power BI Advanced Data Visualisation, Agile Analytics
- Dashboard In a Day (DIAD) Power BI training, Microsoft presented by Altis Consulting
- Power BI Training for Government Course, DataTale
- Introduction to Information & Data Governance, Camden Council
- Personal Development Training Communication Skills, Camden Council
- Local Government Australasian Management Challenge participant 2020
- Part Qualification Diploma of Project Management (SG00004903), Upskilled
- Enhancing Local Government Service Delivery, UTS Institute for Public Policy and Governance
- Facilitation Skills Masterclass, Australian Institute of Training and Development
- Lean Six Sigma Foundations, UTS Business School
- Corporate High Performance: Lean Competency Development, City of Sydney
References
Able to provide referees upon request
Timeline
DATA ANALYST
Sydney Water
2022.08 - Current
ACTING PROJECT PORTFOLIO MANAGEMENT COORDINATOR
Camden Council
2022.02 - 2022.05
BUSINESS INTELLIGENCE & PERFORMANCE REPORTING ANALYST
Camden Council
2020.02 - 2022.07
PROJECT MANAGER COMPLIANCE INSPECTIONS AUDIT
Camden Council
2019.01 - 2019.06
BUSINESS IMPROVEMENT OFFICER ANALYST
Camden Council
2017.02 - 2020.02
Microsoft Certified - Power BI Data Analyst Associate
Microsoft
Bachelor of Mechanical Engineering -
The University of Sydney
- Finance for Non-Finance Managers 2024
- SAP Analytics Cloud Training by Bluetree Solutions 2024
- Putting ITIL Into Practice: Applying ITIL 3 Foundation Concepts by LinkedIn Learning 2023
- Plain English Training by Sydney Water 2022
- Local Government Australasian Management Challenge Mentor 2022
- Camden Council Leadership Capability Development Program 2021
- Data Visualisation & Storytelling Course, USYD Centre for Continuing Education
- Power BI Advanced Data Visualisation, Agile Analytics
- Dashboard In a Day (DIAD) Power BI training, Microsoft presented by Altis Consulting
- Power BI Training for Government Course, DataTale
- Introduction to Information & Data Governance, Camden Council
- Personal Development Training Communication Skills, Camden Council
- Local Government Australasian Management Challenge participant 2020
- Part Qualification Diploma of Project Management (SG00004903), Upskilled
- Enhancing Local Government Service Delivery, UTS Institute for Public Policy and Governance
- Facilitation Skills Masterclass, Australian Institute of Training and Development
- Lean Six Sigma Foundations, UTS Business School
- Corporate High Performance: Lean Competency Development, City of Sydney
Similar Profiles
John Van DykJohn Van Dyk
Civil Maintenance at Sydney WaterCivil Maintenance at Sydney Water
Imtiaz ChowdhuryImtiaz Chowdhury
System & Assurance Lead at SYDNEY WATERSystem & Assurance Lead at SYDNEY WATER
KATHERYN LARAKATHERYN LARA
Acting Operations Lead at Sydney WaterActing Operations Lead at Sydney Water