Lan Nguyen
Data Analyst, SQL, Power BI and Python
Dunedin · 022 555 0224 · lan.nguyen@email.com
Profile
Data analyst with six years turning operational and customer data into reporting people actually use. Strong in SQL, Power BI and Python, careful about data quality, and good at explaining a finding to a room of non-specialists.
Skills
SQL (SQL Server, PostgreSQL) · Power BI and DAX · Python (pandas) · Excel and Power Query · Data modelling · Statistical analysis · Data quality and validation · Presenting to stakeholders
Experience
Data Analyst, Taiaroa Energy
Dunedin · 2022 to now
- Built the Power BI reporting suite for the customer operations team, used by 120 staff each week
- Replaced 14 manual Excel reports with automated dashboards, saving the team about 30 hours a month
- Analysed 3 years of fault call data to find the streets with repeat outages, which shaped the next year's maintenance plan
- Set up data quality checks on the billing feed that catch around 200 bad records a month before they reach reports
Junior Data Analyst, Kōwhai Mutual Insurance
Dunedin · 2020 to 2022
- Wrote SQL queries and monthly reports on claims, sales and customer retention
- Built a customer churn model in Python that flagged at-risk policies, helping the retention team keep 9% more of them
- Cleaned and joined data from three legacy systems for a migration to a new data warehouse
Education
Bachelor of Science, Statistics, University of Otago
2019
Microsoft Certified: Power BI Data Analyst Associate, Microsoft
2023
Other details
- Work rights
- New Zealand resident
- Portfolio
- github.com/lannguyen
Referees
Available on request