Summary
Overview
Work History
Education
Skills
Projects
Extracurriculars
Hobbies and Interests
References
Timeline
Generic

Aryan Sharma

Sydney,NSW

Summary

Data Analyst with 1+ years’ experience delivering BI dashboards and automated ETL pipelines. Skilled in SQL, Python, Power BI and Tableau with expertise in data governance and SOC2 compliance. Adept at translating business needs into actionable insights for product and operations teams.

Overview

3
3
years of professional experience

Work History

Auditor

EVT
Sydney, NSW
06.2024 - Current
  • Automated revenue and occupancy reports save 6 hours per week and improve insight delivery to revenue teams.
  • Audited nightly financial data across ~ 1200 transactions/day, achieving 98% reconciliation accuracy.
  • Delivered dashboard insights on occupancy and revenue variance to support BI reporting.

Junior Business Analyst

M.S.Enterprises
J&K, Jammu , India
02.2023 - 01.2024
  • Designed SQL-driven KPI dashboards, reducing manual reporting by 40%.
  • Enhanced AI model reporting accuracy by 12% through data cleaning and visualization.
  • Collaborated with stakeholders to define BI metrics and automate pipeline delivery cutting reporting turnaround from 2 days to 4 hours .

Education

Master in Information Technology - Business Analytics

University of Technology Sydney
10-2025

Bachelors of Commerce (Accounting )

Jammu University
India
10-2023

Skills

  • SQL
  • Python
  • Pandas
  • NumPy
  • Power BI
  • Tableau
  • Excel
  • ETL Development
  • Dashboarding
  • Data Modeling
  • BI Reporting
  • Data Governance (SOC2)
  • KPI Tracking
  • Automation

Projects

  • Fraud detection (Python, Power BI): built a dashboard for daily fraud monitoring, improving the detection rate by 18%
  • Bank marketing campaign(SQL ,Tableau) : implemented segmentation strategy, improving response by 22%
  • Credit card fraud detection analysis: leveraged Python and SAS Studio to analyze large-scale financial transaction data, developed predictive models that effectively identified fraudulent activities, enhancing financial risk management
  • Euro Bank Direct Marketing Campaign : Applied CRISP-DM methodology and SQL/Python to analyze customer behavior.
  • Used Car Sales Market Analysis : Performed extensive data analysis using Python and Excel pivot tables to uncover market trends.
  • Provided strategic recommendations that improved pricing strategies and increased profitability.

Extracurriculars

  • Secretary, UTS Postgraduate Business Society, Increased member engagement by 35%.
  • Vice President, Rotaract Club, Led 10+ projects, coordinating 50+ volunteers.

Hobbies and Interests

  • Cricket
  • Travelling
  • Data Visualization Meetups

References

References available upon request.

Timeline

Auditor

EVT
06.2024 - Current

Junior Business Analyst

M.S.Enterprises
02.2023 - 01.2024

Master in Information Technology - Business Analytics

University of Technology Sydney

Bachelors of Commerce (Accounting )

Jammu University
Aryan Sharma