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
08.2022 - 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
02.2020 - 07.2022
- 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
02.2022 - 05.2022
- 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
02.2017 - 02.2020
- 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
01.2019 - 06.2019
- 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
08.2022 - Current
ACTING PROJECT PORTFOLIO MANAGEMENT COORDINATOR
Camden Council
02.2022 - 05.2022
BUSINESS INTELLIGENCE & PERFORMANCE REPORTING ANALYST
Camden Council
02.2020 - 07.2022
PROJECT MANAGER COMPLIANCE INSPECTIONS AUDIT
Camden Council
01.2019 - 06.2019
BUSINESS IMPROVEMENT OFFICER ANALYST
Camden Council
02.2017 - 02.2020
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
Imtiaz ChowdhuryImtiaz Chowdhury
System & Assurance Lead at SYDNEY WATERSystem & Assurance Lead at SYDNEY WATER
Phil ManningPhil Manning
Water Quality Analyst, at Sydney WaterWater Quality Analyst, at Sydney Water
KATHERYN LARAKATHERYN LARA
Acting Operations Lead at Sydney WaterActing Operations Lead at Sydney Water