Astha Bathla
Data Analyst
Melbourne,VIC
Summary
Data analyst specializing in business intelligence, statistical analysis, predictive analytics, and data visualization. Proven expertise in fostering stakeholder collaboration and bridging the gap between technical and non-technical teams. Committed to delivering clear, impactful insights that optimize performance, mitigate risks, and drive sustainable growth. Adept at transforming complex data into actionable strategies that support informed decision-making across all organizational levels.
Overview
4
4
years of professional experience
1
1
Certification
6
6
years of post-secondary education
Work History
Data Analyst (Work Integrated Learning Project, RMIT)
Future Group
08.2025 - 11.2025
- Developed a visually captivating Power BI Customer Engagement Dashboard to analyse financial segments (Committed, Comfortable, Disengaged) and uncover under-engaged customer groups with high transaction potential.
- Correct inconsistencies, errors and missing data and created fact and dimension views in Databricks SQL to standardise data across multiple tables, improving model accuracy and refresh performance.
- Build DAX measures to monitor transaction trends, contribution types, and engagement frequency for actionable performance insights.
- Provided analytical insights to support customer retention and re-engagement strategies, enhancing decisionmaking for the business.
Data Analyst
sbPowerDev
06.2023 - 01.2024
- Designed interactive Sales, Finance, and Inventory dashboards, driving a 30% improvement in decisionmaking efficiency.
- Wrote and optimised complex SQL queries, views, and stored logic to extract, transform, and standardise data across multiple sources.
- Automated 15+ workflows with Power Automate, reducing manual processes by 40%.
- Developed Power Apps for tracking of inventory, integrating with SharePoint to enhance collaboration and data management.
- Built Budget vs Actual reports with Power BI, DAX, and SQL, conducting variance analysis.
- Created a P&L dashboard enabling real-time financial reporting and improving analysis time by 25%.
- Conducted advanced Excel analysis using pivot tables, VLOOKUP, and statistical techniques.
Engineer
Indiamart Intermesh Limited
11.2020 - 05.2023
- Designed Python and PySpark programs for big data processing, applying data wrangling, cleaning, and transformation to ensure quality datasets.
- Reduced data retrieval times by 25% by optimizing SQL queries and indexing strategies.
- Developed and deployed Power BI reports for trend analysis, variance analysis, and predictive modelling.
- Built serverless APIs using AWS Lambda and API Gateway to expose processed PostgreSQL data in RDS for seamless integration with ERP, web applications and business intelligence tools.
- Implemented ETL pipelines to transfer data from Oracle to Redshift via S3, optimizing storage and analytics.
Education
Master of Analytics -
RMIT
Australia 03.2024 - 12.2025
Bachelor of Technology - IT
GGSIPU
India 09.2016 - 09.2020
Skills
- Data Analytics & Visualization: Power BI, Excel, DAX, Data Modelling, Data Storytelling & Reporting
- Programming & Databases: SQL, PostgreSQL, Python, R
- Data Engineering & Big Data: Apache Spark, Amazon Redshift, ETL Development
- Microsoft Ecosystem: Power Apps, Power Automate, SharePoint, Microsoft 365
- Tools & Environments: Anaconda, Jupyter Notebook, Visual Studio Code, RStudio
Certification
Microsoft Certified: Power BI Data Analyst Associate
Publications
Image Formation Using Deep Convolutional Generative Adversarial Networks, Predictive Analytics, 01/01/21, CRC Press
Languages
English
Bilingual or Proficient (C2)
Timeline
Data Analyst (Work Integrated Learning Project, RMIT)
Future Group
08.2025 - 11.2025
Master of Analytics -
RMIT
03.2024 - 12.2025
Data Analyst
sbPowerDev
06.2023 - 01.2024
Engineer
Indiamart Intermesh Limited
11.2020 - 05.2023
Bachelor of Technology - IT
GGSIPU
09.2016 - 09.2020