Summary
Overview
Work History
Education
Skills
Websites
Certification
Project Highlights
References
Timeline
Generic

DHRUV PATHAK

Melbourne,Australia

Summary

Business & Data Analyst with over 4 years of experience across fintech, hospitality, and government sectors. Expertise in delivering actionable insights and optimizing operations through data-driven decision-making using Python, SQL, Power BI, and CRM tools. Strong communicator adept at aligning technical teams with business objectives to implement scalable solutions. Seeking to leverage analytical skills in fast-paced, growth-oriented environments.

Overview

7
7
years of professional experience
1
1
Certification

Work History

Auditor

Pullman Melbourne on the Park
Melbourne, Australia
06.2022 - Current
  • Automated daily audit reports and created dashboards to support revenue forecasting and compliance tracking.
  • Built management reports tracking guest trends, departmental KPIs, and booking behaviour using Excel pivot tables and slicers.
  • Developed Power BI dashboards to visualize RevPAR, ADR, and occupancy trends for operational briefings.

Data Analyst Intern

Merri-Bek City Council
Melbourne, Australia
08.2023 - 11.2023
  • Company Overview: Melbourne
  • Extracted, cleaned, and analysed expenditure datasets from multiple council departments using SQL and Excel.
  • Built Power BI dashboards to visualize community spending behaviour and patterns across 200+ businesses.
  • Developed interactive Power BI dashboards for performance reporting and executive insights, using DAX for calculated measures, KPIs, and time intelligence functions.
  • Wrote complex SQL queries for data extraction, cleaning, and validation across large, multi-table relational datasets.
  • Melbourne

Business Development Analyst

Agpaytech Ltd
08.2021 - 01.2022
  • Conducted sales and lead analysis across regions using Excel and SQL; built automated reports for weekly management review.
  • Designed Power BI dashboards to track KPIs, sales funnels, churn rate, and customer conversion.
  • Collaborated with product and marketing teams to align business strategies with customer analytics.

Quality Control Manager

Corporate Alliances (Britannia Industries)
06.2020 - 06.2021
  • Led analytics-driven quality audits across 5+ units, enhancing compliance scores by 20%.
  • Created Excel-based models for tracking KPIs like production errors, downtime, and safety incidents.
  • Utilized root cause analysis (RCA) and control charts to monitor and improve manufacturing consistency.

Marketing Research Analyst

OYO Rooms
09.2019 - 04.2020
  • Designed dashboards to evaluate market trends, campaign efficiency, and CRM data analytics.
  • Developed competitor benchmarking reports and marketing performance summaries for senior leaders.
  • Created and tracked KPIs for over 50+ B2B client events using automated Excel tools.

Senior Associate - Customer Insights & Support

Sutherland Global Services
07.2018 - 07.2019
  • Built support ticket tracking system and created dashboards on issue resolution time and CSAT.
  • Conducted cohort analysis and weekly insights reports to assist team leaders in optimizing support operations.
  • Drove automation in reporting tasks, saving ~10 hours per week.

Education

Master of Analytics -

RMIT University
Melbourne
12.2023

Bachelor of Business Administration -

SRM University
Chennai, India
06.2018

Skills

  • Power BI
  • DAX
  • M Query
  • Tableau
  • Excel
  • SQL
  • Python
  • Pandas
  • NumPy
  • Scikit-Learn
  • VBA Automation
  • Microsoft Dynamics CRM
  • SAP
  • Salesforce
  • PostgreSQL
  • JIRA
  • Confluence
  • Trello
  • Git
  • Forecasting
  • Financial Modelling
  • Stakeholder Engagement

Certification

· IBM: Make an Impact with Data Analytics

· DataCamp: Introduction to SQL, Power BI, Python for Data Science

· Agile Business Analyst Foundation.

Project Highlights

· Regression Analysis (RMIT): Built multiple regression models in R to predict credit card expenditure. Improved adjusted R² from 0.41 to 0.72 via feature selection and diagnostics.

· Forecasting Project (RMIT): Applied ARIMA, ETS, and Holt-Winters models to air passenger data; validated models using RMSE and residual plots.

· Classification Model: Designed a hybrid job title classifier using keyword mapping and weight-based scoring; achieved 95% accuracy in real-world dataset.

· Azure ML Studio: Built pipelines for cell phone price prediction and wine clustering with data cleaning, normalization, and model evaluation steps.

· Machine Learning: Investigated how different vehicle characteristics can affect CO2 Emissions using techniques like K- Nearest Neighbour, Random Forest, Decision Tree, and Support Vector Machine, with Decision Tree displaying the highest Accuracy.

References

References available upon request.

Timeline

Data Analyst Intern

Merri-Bek City Council
08.2023 - 11.2023

Auditor

Pullman Melbourne on the Park
06.2022 - Current

Business Development Analyst

Agpaytech Ltd
08.2021 - 01.2022

Quality Control Manager

Corporate Alliances (Britannia Industries)
06.2020 - 06.2021

Marketing Research Analyst

OYO Rooms
09.2019 - 04.2020

Senior Associate - Customer Insights & Support

Sutherland Global Services
07.2018 - 07.2019

Master of Analytics -

RMIT University

Bachelor of Business Administration -

SRM University
DHRUV PATHAK