Summary
Overview
Work History
Education
Skills
Websites
Certification
Languages
Hobbies
Timeline
Generic

Elia Lanza

Northcote

Summary

An accomplished Senior Data Analyst and certified Scrum Master (PSM I) with a successful spanning Banking, Consulting, and Insurance sectors. I specialise in distilling intricate data into concise, actionable insights through proficient use of data wrangling and business intelligence tools. My professional journey underscores a dedicated commitment to data integrity, process automation, and impactful visualisation.

As a seasoned Scrum Master for analytics and data initiatives, I have refined my skills in effective problem-solving and demonstrated adept project leadership.

Overview

8
8
years of professional experience
1
1
Certification

Work History

Senior Data Analyst

Hollard Insurance
05.2023 - Current
  • Collaborated with engineers and played a pivotal role in the successful migration of complex datasets to a new platform, ensuring seamless continuity of operations and data integrity within the data warehouse environment.
  • Developed over twenty interactive comprehensive dashboards using Microsoft Power BI that empowered stakeholders to make informed decisions based on real-time data, improving operational efficiency through insightful calculations.
  • Designed and deployed automated ETL processes, reducing manual data entry errors by 95%, and ensuring the transformation of raw data into usable formats with improved accuracy.
  • Utilised Python and SAS to streamline data analysis workflows, resulting in an 80% increase in efficiency and faster decision-making processes.

Senior Data Analyst

ANZ
11.2020 - 04.2023
  • Utilising SQL, Power BI and Python I developed custom dashboards, visualisations, and interfaces to deliver meaningful and actionable insights to the C-Suite
  • Automated many legacy Excel reports through Python reducing touch time by up to 95%
  • Delivered, managed and maintained ANZ Leave portfolio - YoY product valuation of $400m+
  • Built legacy Excel models in Power BI to refresh in real-time that utilised modelling techniques to ensure that data was cleansed and refreshed without the need of manual interaction, managing a reduction in touch time from days into minutes
  • Delivered financial analysis reports of restructure and divestment of service centres in key geographic locations to COO office.
  • Served as a subject matter expert on various projects, sharing valuable insights derived from extensive industry experience as a Senior Data Analyst.
  • Contributed to overall organizational growth through continuous improvement of data analytics capabilities and processes.

Senior Consultant

Deloitte
08.2019 - 10.2020
  • Delivered high-quality solutions for clients through comprehensive research and analysis of industry trends.
  • Conducted research and analysis of customers' current business processes to identify areas of improvement
  • Prepared reports that provided year on year profitability and sustainability of the business whilst assessing and utilising various valuations methodologies to encourage further buy-in and funding from senior management
  • Increased client satisfaction by providing tailored consulting services and effective problem-solving strategies.
  • Created a bespoke dataset which showcased the market practise of ASX300 equity programs and compared them to global companies of similar stature, industry, and market capital in EMEA, APAC and the Americas.

Analyst

Barclays
09.2015 - 04.2019
  • Developed detailed financial models and analysis to evaluate current and future performance of team
  • Developed new analytical models that improved forecasting accuracy and reduced risk exposure.
  • Identified trends and patterns in large datasets, leading to actionable insights for business growth.
  • Designed and implemented a VBA Macro to effectively mass-onboard clients that resulted in an uptick of clients being to trade electronically by 80% and ensured weekly KPI and service levels were met.

Education

Masters in Analytics -

RMIT
Melbourne, VIC
06.2022

MBA -

Melbourne Business School
Melbourne, VIC
06.2020

Bachelor of Arts -

Monash University
Melbourne, VIC
09.2012

Skills

  • Microsoft Power BI
  • R Programming
  • Python Programming
  • SAS
  • SQL
  • Project Management
  • Trend Data Analysis
  • Statistics

Certification

  • Professional Scrum Master 1, 08/01/22, Scrum.org, www.credly.com/badges/21d6aeab-2548-43a1...
  • Foundations of Data Science, 06/01/23, Coursera, www.coursera.org/account/accomplishments...

Languages

English
Italian
French
Japanese

Hobbies

  • Triathlons
  • Web Development
  • Utilised programming and maths skills to determine if crowds at EPL matches have a significant effect on home team performance
  • Built an interactive dashboard to showcase Formula 1 results over the last ten years based on team performance

Timeline

Senior Data Analyst

Hollard Insurance
05.2023 - Current

Senior Data Analyst

ANZ
11.2020 - 04.2023

Senior Consultant

Deloitte
08.2019 - 10.2020

Analyst

Barclays
09.2015 - 04.2019

Masters in Analytics -

RMIT

MBA -

Melbourne Business School

Bachelor of Arts -

Monash University

Similar Profiles

CREATE PROFILE
Elia Lanza