Nicole Fragoso
Bankstown,New South Wales
Summary
Results-driven Business Intelligence Analyst with over 7 years of experience specialising in data analysis and reporting using Power BI and Excel Power Query. Proven ability to collaborate effectively with finance, operations, HR and technical teams to transform complex requirements into automated reporting solutions and user-friendly dashboards. Expertise in streamlining processes to enhance operational efficiency and drive informed decision-making.
Overview
9
9
years of professional experience
Work History
Senior Project Reporting Analyst
Corrs Chambers Westgarth
06.2025 - 12.2025
- Designing end-to-end financial reporting solutions using SQL, Power BI, and advanced Excel (Power Query, DAX, VBA)
- Creating Financial KPI dashboards for partners, CFO, and LPM team with drill-through insights and real-time WIP visibility.
- Developing reusable report templates and frameworks to standardise matter reporting across the firm.
- Managing stakeholder feedback to refine reporting logic, improve accuracy, and ensure fit-for-purpose outputs.
- Collaborating with Finance, LPM, and Data Governance teams to align reporting with firmwide standards.
- Enhancing reporting visuals using UX/UI best practices to support decision-making and partner adoption.
- Building interim analytics tools (Excel/Power BI hybrids) to bridge gaps between systems and stakeholder needs.
- Documenting all reporting logic, business rules, and data definitions for internal knowledge management.
- CONTRACT POSITION
PowerBI Business Analyst
WSP Australia
04.2020 - 11.2025
- Migrating manual flash reporting (including P&L and operational flash reports) from Excel to Power BI, streamlining reporting processes and reducing manual effort.
- Built and delivered automated reports for Project Performance, Group FP&A & Executive team using Power BI, enhancing reporting efficiency through timely scheduling and maintenance.
- Managed the delivery of monthly reporting for project performance, providing key insights to senior leadership
- Implemented data governance practices to strengthen data accuracy, reduce reporting gaps, and improve trust in organisational data
- Provided insights, analysis, as well as identifying & review any potentials risks from sales, financial, project and HR data to Business Executives and Group Leaders
- Optimized existing Power BI reporting structures (Semantic Models), reducing report generation time by improving performance and usability.
- Managed JIRA and Confluence to document updates, changes, and manage change requests, ensuring compliance with governance frameworks.
- Extracted and transformed data from multiple sources for Power BI integration.
- Automated and improved existing forecast models, reducing manual errors and ensuring compliance
- Reviewed and streamlined existing processes and reports in Planning Analytics (TM1) and Power BI
- Prepared Monthly Business Reviews and Weekly Dashboards for Finance Business Partners and Business Units, ensuring data accuracy and relevance.
- Acted as a point of contact between Project Teams, Business Groups, Applications Development Team and IT
- Achievements:
- Developed and deployed a comprehensive Business Development Costs, Utilisation & Project Review Dashboard using Power BI, successfully implemented across the entire organization, enhancing data driven decision-making and operational efficiency.
PowerBI Business Analyst
Active Tree Services
01.2025 - 06.2025
- Migrating manual flash reporting (including P&L and operational flash reports) from Excel to Power BI, streamlining reporting processes and reducing manual effort.
- Integrating finance data into the enterprise data warehouse to support consolidated reporting across finance, commercial, and field operations.
- Developing reusable report templates and frameworks to standardise matter reporting across the firm.
- Managing stakeholder feedback to refine reporting logic, improve accuracy, and ensure fit-for-purpose outputs.
- Designing and optimizing Power BI reports for mobile use, enabling field teams (e.g. arborists) to access key information on phones and tablets.
- Assisting the IT team with the development of Power BI dashboards for tracking and managing service desk tickets.
- Continuously enhancing reporting performance, layout, and accessibility to improve usability and stakeholder engagement.
- CONTRACT POSITION
Account Receivable Manager & Reporting Analyst
WSP Australia
10.2016 - 03.2020
- Management of team of 6 AR Officers (5 Sydney based, 1 in Philippines)
- Implementation of new processes and reporting modules
- Creation and maintenance of reports for executive team – DSO, Month End Results, Cash Flow, Bad Debt, Invoicing Statistics
- Reviewing data and providing insights and analysis to Senior Leadership, as well as identifying any potential issues and applying strategies to mitigate risks
- Cash Forecasting and Trend Analysis
- Recruiting and training of new staff
- Achievements:
- Development of first AR PowerBI and Transactional Reports
- Reduction of Property DSO from 115-88 in FY18-19
- Initial Set up of Finance Helpdesk Forms and Queues – JIRA
- Set up of Finance Confluence pages for Helpdesk
- Successful UAT testing for new programs as well as UAT for acquired companies
Education
Masters of Analytics -
UTS
01-2027
Advanced Diploma of Information Technology Business Analysis - undefined
01.2021
PowerBI for the Business Analyst - undefined
01.2020
Foundations of Project Management -
01.2018
Skills
- Business Requirements Gathering
- Stakeholder Communication: presenting to partners & senior leaders
- Process Automation & Improvement
- Reporting & Dashboard Creation
- Financial & Sales Reporting
- Data Analysis: descriptive statistics, segmentation, trend analysis
- Data Quality & Governance: anomaly detection, integrity checks
- Risk Analysis
- Power BI & Data Visualisation: DAX, data modelling, dashboard design
- SQL & Data Extraction: query optimisation, dataset preparation
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse