Hey! I am

Divyank Arora

I'm a

About

About Me

As an experienced Reporting Analyst, I specialize in transforming complex data into actionable strategies. Skilled in tools like Power BI, SQL, Python, and Excel (including advanced VBA macros), I excel at delivering efficient, user-friendly reports and dashboards. My expertise spans data visualization, automation, financial planning, and claims analysis. I thrive on cross-team collaboration, making data accessible and impactful for strategic decision-making.

Download CV

Education

2019-2021

Master of Business Analytics [Major: Business Intelligence]

La Trobe University

La Trobe School of Business, Victoria, Melbourne, Australia. | Score - 73%

2016-2019

Bachelor of Business Administration

Indraprastha University

Vivekananda Institute of Professional Studies (VIPS), Delhi, India. | CGPA - 8.68

Experience

November 2022 - Present

Reporting Analyst

Allianz Australia, Melbourne, Australia

  • As a Reporting Analyst in the finance team, I specialize in transforming data into actionable insights, supporting strategic decision-making.
  • I develop user-friendly reports, manage daily performance dashboards, and work closely with finance, risk, and distribution teams to streamline reporting processes and enhance data accuracy.
  • With a focus on automation and data visualization, I drive efficiency and clarity in financial reporting.

    • May 2022 - November 2022

    Reporting Analyst

    City Facilities Management, Mulgrave, Australia
    • In my previous role as a Reporting Analyst, I specialized in generating and analyzing reports on greenhouse gas emissions from refrigeration and air conditioning systems in retail stores.
    • I ensured accurate data collection, compliance with environmental regulations, and provided actionable insights to support sustainability initiatives.
    • Extensive use of PowerBI, Advanced Excel and SSRS
    October 2021 - May 2022

    Project Administrator

    City Facilities Management, Mulgrave, Australia
    • Coordinated project schedules, timelines, and documentation to ensure seamless execution.
    • Facilitated communication between teams and stakeholders for efficient collaboration.
    • Monitored project progress and maintained records to support asset management initiatives.
    August 2020 - January 2021

    Institutional Performance Analyst

    La Trobe University, Melbourne, Australia
    • Created a Course demand Analytics tool for the university with a vision of Reporting based solution via extensive use of Power BI and R programming and reported to the vice chancellor with excellent written communication skills.
    • Goal oriented testing of Business information technology systems with the tool to check accepting criteria and use case of the product and managed results with an Agile methodology based on industry trends.
    • Provided innovative recommendations for process improvement and growth leading to continuous improvement in business performance.

    Skills

    Advanced Excel

    Python

    PowerBI

    R Studio

    Tableau

    SQL

    PowerQuery

    Training and Workshops

    • Risk management and Compliance regulations
    • Customer Satisfaction and Complaints training
    • Data Governance
    • Data Preparation and Analysis on SQL
    • Digital Marketing by Google
    • Business Analysis Foundations
    • Six Sigma: White Belt Training

    Achievements

    • Project Lead for Regulatory and Compliance Report for the Claims Department.
    • Achieved 70% efficiency by developing VBA automation for the Credit team Reporting.
    • Team member of the Quarter at Allianz Australia in Q2 2023.
    • Event coordinator at VIPS National Conference for 3 consecutive years.
    • Participated at Multi United nations (MUN) - General Assembly United Nations.
    • Successfully supported VIPS International Conference’17 with Sponsorship from Bombay Stock Exchange.
    • Placement Cell Coordinator of VSBS (Vivekananda School of Business Studies)
    • Vice President of College dance Society (Danzaire).

    Proficiency

    Proficiency

    Being an Experienced Analyst and a Business Analytics Student, I'm proficient with certain technologies where still most of the work is done using Excel.

    Data Analysis and Visualization

    Data Analysis using Advanced Excel and SQL and Visualization of data using PowerBI, MicroStrategy and Tableau is my cup of tea.

    Teamwork

    Teamwork with me means turning 'I can't' into 'we absolutely got this'—because when I’m in, you’re never tackling data (or chaos) alone!

    Collaboration and Communication Expertise

    Great collaboration is when we all pretend to understand each others ideas and somehow make it work!

    0 Years of Study
    0 Projects Completed
    0 Subjects Completed
    0 Cups of coffee


    I'm Available for Full Time job opportunites in the field of Analytics.

    With a blend of analytical precision and a knack for transforming data into strategic insights, I bring three years of experience in finance reporting to streamline processes and support data-driven decisions. I’m not just about numbers; I’m about making them work smarter. Ready to bring my advanced Excel, automation, and data visualization skills to your team for impactful results!

    Contact

    Contact Me

    Contact Number

    +61 432690357

    Email Address

    aroradivyank2@gmail.com