Data Analyst · Sydney, AU

Aniket
Solanki

MBAn graduate from UTS with a focus on supply chain and financial analytics. Certified in Power BI (PL-300) and AWS, with hands-on experience building end-to-end pipelines on Azure and delivering dashboards that drive business decisions.

Currently seeking Data Analyst or BI Analyst roles across Australia. Full working rights, no sponsorship required.

LinkedIn GitHub

Power BI SQL DAX Python Azure AWS Tableau ETL Excel

10+

Projects

Certifications

15+

Skills

Open to opportunities

Core Skills

BI & Visualisation

Power BI DAX Tableau Power Query

Data & Engineering

SQL Python ETL Pipelines Star Schema

Cloud & Platforms

Azure ADF AWS Excel Git

PL-300 Microsoft Power BI Certified

AWS Cloud Practitioner Certified

About

Who I am

Data Analyst with Microsoft PL-300 & AWS Cloud Practitioner certifications. Proficient in Power BI, DAX, SQL, Python, and cloud-based ETL pipelines, with a proven ability to automate workflows, build scalable data models, and deliver actionable insights that support business decision-making.

Experienced in equity trading analytics and building executive-ready dashboards across financial and supply chain domains. Comfortable working across the full data stack — from raw ingestion to polished stakeholder reporting.

Profile: Power BI Data Analyst
Education: Master of Business Analytics, UTS
Location: Parramatta, Sydney AU
Availability: Open to relocate across Australia
Work Rights: Subclass 485 · Full working rights · No sponsorship required (Jan 2029)
Language: English (Fluent)
BI Tools: Power BI, DAX, Power Query, Tableau
Data Eng.: SQL, Python (Pandas, NumPy), ETL Pipelines
Platforms: Azure (ADF, Blob, SQL), AWS (S3, Glue, Athena), Git, JIRA, Google Analytics
Interests: Travel · Photography · Cricket · Football

Experience

Where I've worked

Reporting & Data Analyst Intern

Jul 2023 – Feb 2024

Kalash Shares & Securities · India

Built 3 Power BI dashboards tracking portfolio performance and account-level KPIs, enabling weekly rebalancing decisions by senior analysts and replacing manual Excel reporting for 50+ client accounts.

Validated and reconciled 10,000+ financial records using SQL to ensure reporting accuracy across monthly client performance reviews, reducing data discrepancies by 30%.

Integrated SQL and Excel data sources via Power Query and developed DAX-based KPI measures to support consistent stakeholder reporting, cutting weekly manual reporting time by 25%.

Power BI DAX Python SQL Power Query Excel

Warehouse & Inventory Assistant

Sep 2024 – Present

The Fruit Box Group · Sydney, AU

Part-time operational role undertaken alongside MBAn studies at UTS (completed Dec 2025).

Utilise NetSuite ERP to manage real-time inventory tracking, stock updates, and order fulfilment.

Conduct regular stock-takes and audits to maintain accuracy between physical inventory and system records.

NetSuite ERP Inventory Management Operations

Projects

Work I'm proud of

Data engineering, analytics dashboards, and end-to-end pipelines built with SQL, Python, Power BI, AWS, and Azure.

AzureADFETLSQL

Azure Data Factory ETL Pipeline & Power BI Reporting

End-to-end ADF pipeline ingesting live retail data from REST API → Azure Blob Storage → Data Flow transformations (null filtering, text cleaning, nested JSON flattening) → Azure SQL Database. Automated with daily triggers.

Watch Demo → View on GitHub →

Power BIDAXStar SchemaSupply Chain

Samsung Supply Chain & Logistics Power BI Dashboard

Multi-fact star schema with 5 fact tables and 5 dimension tables across 100,000+ records. DAX measures for YoY revenue variance, supplier risk classification, stockout risk %, and profit margin %. 5-page interactive report with drill-through navigation and KPI cards.

View on GitHub →

SQLETLAnalytics

SQL Data Warehouse & ETL Pipeline

Full Bronze–Silver–Gold SQL data warehouse pipeline with Kimball star schema modelling. T-SQL data cleaning, joins, aggregations, and NULL handling for analytics-ready datasets.

View on GitHub →

AWSPower BIPython

AWS Analytics Pipeline & Power BI Reporting

Serverless pipeline using S3, AWS Glue & Athena delivering Power BI dashboards with 98% validated data accuracy. Automated schema detection with Python, improving ETL efficiency by 25%.

Watch Demo →

PythonMySQLAutomation

Enterprise Payments ETL & Analytics Platform

Incremental Python ETL pipelines with scheduled refreshes and scalable MySQL schema. DAX measures for YoY growth, margin analysis, and KPI comparisons.

View on GitHub → View on LinkedIn →