SQL Server Management Studio (SSMS)
Ashish M
BUSINESS DATA & REPORTING ANALYST
Truganina,VIC
Summary
Senior Insights, Reporting and Business Analyst with 5+ years of experience delivering enterprise reporting, analytics, business intelligence, data governance and process improvement solutions across insurance, education, healthcare and not-for-profit sectors.
Advanced capability in Power BI, SQL, data modelling, stakeholder engagement, requirements elicitation, business process improvement and Agile delivery. Proven experience delivering reporting solutions using Snowflake, Salesforce, Azure and Microsoft technologies while driving data quality improvements, automation opportunities and business transformation initiatives. Passionate about leveraging emerging technologies including Microsoft Copilot and AI-enabled analytics to improve productivity, reporting effectiveness and organizational outcomes.
Overview
6
6
years of professional experience
2
2
years of post-secondary education
Work History
Data Reporting and Visualisation Analyst
Royal Automobile Club of Victoria (RACV)
10.2024 - Current
- Partnered with senior stakeholders across Marketing, Customer Experience, Digital, Data and Technology teams to identify reporting requirements and develop data-driven solutions supporting strategic business objectives.
- Designed and delivered Power BI dashboards and interactive reporting solutions, enabling leaders to monitor customer engagement, campaign effectiveness, operational performance and emerging business trends.
- Developed complex data models, measures and calculations using Power BI, DAX and Power Query to improve reporting accuracy, scalability and usability.
- Analyzed large customer and operational datasets to identify trends, risks and opportunities, providing actionable insights and recommendations to support decision making.
- Collaborated with Data Engineering teams on the migration of customer and campaign data from Snowflake to Salesforce Marketing Cloud, ensuring data quality, governance and reporting continuity.
- Performed detailed data validation, reconciliation and quality assurance activities, improving confidence in business reporting and analytics outputs.
- Identified opportunities to streamline reporting processes through automation and workflow optimization, reducing manual effort and improving operational efficiency.
- Facilitated stakeholder workshops, requirements gathering sessions and discovery activities to translate business needs into reporting and analytics solutions.
- Produced business requirements, user stories, process maps, data dictionaries and acceptance criteria supporting successful project delivery.
- Leveraged AI-enabled productivity tools including Microsoft Copilot and intelligent automation capabilities to improve documentation, reporting development and analysis activities.
- Supported Agile delivery practices including sprint planning, backlog refinement, stakeholder demonstrations and continuous improvement initiatives.
Business Intelligence & Reporting Analyst
HCF
03.2023 - 09.2024
- Delivered enterprise reporting and analytics solutions using Power BI, Salesforce CRM, Snowflake and SQL to support business performance monitoring and strategic decision making.
- Partnered with senior business stakeholders to understand reporting requirements, define KPIs and develop dashboards that improved visibility of operational and customer outcomes.
- Designed and maintained Power BI reports incorporating data modelling, DAX calculations, data transformation and visual analytics to provide meaningful business insights.
- Analyzed customer, operational and campaign datasets to identify trends, risks and performance improvement opportunities.
- Developed reporting frameworks and data governance practices that improved consistency, reliability and accessibility of organizational reporting.
- Collaborated with cross-functional teams including Marketing, Data, Digital, Compliance and Technology to deliver reporting and analytics initiatives aligned with business priorities.
- Supported data quality improvement activities through data profiling, validation, reconciliation and issue resolution processes.
- Facilitated stakeholder workshops to gather requirements, document business processes and define reporting and analytics solutions.
- Automated recurring reporting activities and business processes through digital tools and workflow enhancements, reducing manual effort and improving efficiency.
- Prepared executive-level reporting packs and performance insights for senior leadership, enabling informed decision making and strategic planning.
- Contributed to Agile delivery practices including sprint planning, backlog grooming, user story development and stakeholder reviews.
- Acted as a trusted advisor to business stakeholders by translating complex data into clear, actionable recommendations and business outcomes.
Business Data Analyst
Resolution Life (formerly AMP Life)
03.2022 - 11.2022
- Worked and managed end to end marketing reporting projects, ranging from requirements gathering to delivering dashboards
- Collaborated with senior stakeholders through requirement workshops to define reporting needs and KPIs for insurance data
- Applied Agile ways of working, contributing to sprint reviews and retrospectives to track reporting delivery.
- Experienced using customers data and databases, capturing data in Salesforce CRM and Snowflake cloud data warehouse and database (SQL)
- Built relationships with the senior stakeholders, ranging from various technical and non-technical background, and helped them to come up with user stories and acceptance criteria
- Gathering data from disparate databases and sources which are in line with stakeholders requirements
- Soul point of contact for reporting purposes in agile marketing team
- Created fact (data tables) and dimension (lookup tables) in star and snowflake schemas relevant to marketing reporting projects
- Hands on experience on cutting edge technologies for reporting and dashboarding such as PowerBI
Business Data Analyst
Royal AU & NZ College Of Obstetric & Gynaecology (RANZCOG)
11.2020 - 01.2022
- Partnered with senior stakeholders and department heads to gather requirements and translate them into effective reporting solutions.
- Developed and improved integrated reporting and analysis capabilities.
- Built relationships and influenced and motivated employees to drive operational improvements.
- Designed and delivered Power BI dashboards using SQL-based data from MS Azure and SQL Server.
- Analysed data across medical education programs and workforce trends to support governance and compliance.
- Interfaced with technical and non-technical stakeholders, including senior leadership, to communicate insights.
- Assisted with data quality assessments and structured documentation for dashboards and reports.
- Worked with vendors and internal teams on updates to education platforms and membership systems.
Education
Masters of Data Analytics -
Deakin University
Melbourne, VIC 02.2018 - 11.2019
Skills
Requirements Elicitation & Documentation
Technical Translation & Communication
Customer Segmentation and Audience Building
Critical Thinking and Problem Solving
Agile Methodology
Timeline
Data Reporting and Visualisation Analyst
Royal Automobile Club of Victoria (RACV)
10.2024 - Current
Business Intelligence & Reporting Analyst
HCF
03.2023 - 09.2024
Business Data Analyst
Resolution Life (formerly AMP Life)
03.2022 - 11.2022
Business Data Analyst
Royal AU & NZ College Of Obstetric & Gynaecology (RANZCOG)
11.2020 - 01.2022
Masters of Data Analytics -
Deakin University
02.2018 - 11.2019
Software
Databricks SQL
Snowflake Datawarehouse
PowerBI and PowerBI service (Data Modelling using DAX, Calculated Fields, Measures), Power platform
Artificial Intelligence (AI) tools (Co-pilot)
Jira/Confluence for Documentation
References
Available upon Request