Data Analytics & Automation Expert 

Turning Data into Actionable Insights for Smarter Decision-Making

Explore My Work >>

About Me

Linkedin Envelope Address-card

I am a Data Analyst with 5 years of experience, specializing in Microsoft Power BI, Microsoft Fabric, and process automation. With a background in data visualization, business intelligence, and workflow optimization, I transform complex datasets into actionable insights that drive strategic decision-making.

My expertise lies in developing end-to-end data pipelines, integrating multiple data sources, and automating reporting workflows to improve efficiency and accuracy in decision-making processes.

Education

Master of Business Analytics

Deakin University
Jun 2018 - July 2020

Bachelor of Business Administration

IP UNIVERSITY
Jun 2018 - July 2020

Professional Experience

Data Analyst

WT PARTNERSHIP

MAR 2024 - CURRENT

  • Designed and implemented customized client portals serving 90+ construction clients, streamlining access to project data, cost tracking, and financial insights.
  • Developed interactive reporting dashboards in Power BI that provide real-time visibility into project portfolios, contract variations, and procurement strategies.
  • Led the reporting and analytics framework for project portfolios exceeding $15 billion, providing data-driven financial oversight to key stakeholders.
  • Developed end-to-end automation pipelines that integrate reporting, invoice tracking, and document management, reducing manual processing time by 80%.
  • Developed financial cash flow tracking tools that analyze multi-year trends, contract expenditures, and project forecasts.
  • Designed data-driven quality assessment dashboards for pre- and post-contract evaluations, improving compliance tracking and risk mitigation.
  • Integrated industry benchmarks and cost databases to enhance project performance assessments

ICT Business Analyst

Envirosuite

FEB 2021 - MAR 2024

  • Integrated data from finance, operations, sales, and supply chain to develop BI solutions, improving operational reporting and efficiency.
  • Designed interactive Power BI dashboards for real-time visibility into KPIs, financial performance, and strategic growth metrics.
  • Conducted market research and competitor analysis, contributing to two successful capital raises through data-driven investor reports and financial forecasting models.
  • Improved inventory management and supply chain efficiency, enhancing order fulfillment rates and customer satisfaction through automated tracking solutions.
  • Developed real-time analytics solutions for executives, enabling faster, data-driven decision-making with automated KPI tracking.
  • Automated manual data processes, reducing report generation time by 60% and improving business efficiency with ETL pipelines and workflow automation.
  • Built Power Automate & Python-based automation scripts, eliminating repetitive tasks and allowing teams to focus on high-value analytics.

Sales and Marketing Analyst (Internship)

Envirosuite

Aug 2020 - FEB 2021

  • Applied qualitative and quantitative analysis techniques.
  • Designed project cost estimation tools.
  • Assisted in business operations analysis.
  • Collaborated on systems automation projects.
  • Maintained awareness of market and technology trends.

Marketing Analyst

JUNE 2019 - AUG 2020

  • Analyzed customer acquisition and campaign data.

  • Conducted market research studies.

  • Performed trend forecasting and analysis.

  • Assessed and recommended improvements based on KPIs.

Technical Expertise

Project Work

Data Automation and Analytics

Socialsuite, an expanding startup specializing in ESG consulting and social impact services, faced significant hurdles in managing its varied marketing data sources. To address this, I revolutionized their marketing approach by automating data extraction processes and creating an intuitive Business Intelligence (BI) reporting system. This innovation enhanced data transparency and efficiency in reporting, resulting in a substantially improved Return on Ad Spend (ROAS).

Predictive analytics for weather data

In my project with an Australian weather data modelling company, I contributed by applying my expertise in data analytics and PowerBI to enhance their client-based reporting capabilities. My work involved analyzing complex datasets and developing advanced bi solution, which played a pivotal role in refining thier client-based reporting tool.

Sales and Marketing analytics

For Solar Worx, I developed a comprehensive sales and marketing dashboard designed to streamline their data visualization and analysis processes. This dashboard provided real-time insights into key performance indicators, enabling more effective tracking of sales trends, marketing campaign effectiveness, and customer engagement metrics. This tool significantly enhanced the decision-making process, optimizing Solar Worx’s sales strategies and marketing efforts.

Sales and Financial analytics

For Diet Yumm, I developed a Bi solution that provided them the holistic view of their patients, appointments, invoices and monthly revenue. This dashboard provided real-time insights into indicators, enabling more effective tracking of business effectiveness, and financial metrics. This tool significantly enhanced the decision-making process for DietYumm.

Get In Touch

Email: Rohitbali12@outlook.com

Linkedin Envelope