Data Analyst · Sydney, AU

Aniket
Solanki

Transforming complex, multi-source data into executive dashboards and clear business insights. Microsoft PL-300 certified and AWS Cloud Practitioner — with deep expertise in Power BI, SQL, DAX, and Python.

LinkedIn GitHub

Power BI SQL DAX Python Azure AWS Tableau ETL Excel

10+

Projects

Certifications

15+

Skills

Open to opportunities

Core Skills

Power BI & DAX95%

SQL & T-SQL90%

Python (Pandas, NumPy)85%

Azure (ADF, SQL, Blob)82%

AWS (S3, Glue, Athena)85%

ETL Pipelines88%

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, inventory operations, and building executive-ready dashboards across both corporate and freelance settings. 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
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

Inventory & Operations Assistant (Part-time)

Sep 2024 – Present

The Fruit Box Group · Sydney, AU

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

Conduct regular stock-takes and audits to ensure 100% accuracy between physical inventory and system records.

Maintain strict hygiene, quality, and compliance standards while meeting daily productivity targets.

Netsuite ERP Inventory Management Operations

Reporting & Data Analyst Intern

Jul 2023 – Feb 2024

Kalash Shares & Securities · India

Performed equity trading data cleaning and preprocessing using Python (Pandas, NumPy), eliminating manual Excel preparation for weekly reports.

Extracted and aggregated client transaction records via SQL to support monthly performance reviews.

Developed 2–3 interactive Power BI dashboards using DAX and Power Query to visualise portfolio performance and trading activity.

Integrated SQL and Excel data sources using Power Query to ensure consistent reporting across client accounts.

Power BI DAX Python SQL Power Query Excel

Projects

Work I'm proud of

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

Azure ADF ETL SQL

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 →

SQL ETL Analytics

SQL Data Warehouse & ETL Pipeline

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

View on GitHub →

AWS Power BI Python

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 →

Python MySQL Automation

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 →