Solid experience in end-to-end data solution delivery across business intelligence, data warehousing, advanced analytics and rapid ubiquitous app development. Dedicated Data Reporting Analyst with a proven track record specializing in Data Insight, Management Information, Mining, Utilities, Banking, and Financial Reporting within the IT sector. Proficient in data analysis and design, with expertise in utilizing BI reporting tools such as SSRS, SSIS, MS SQL Reporting Services, Power BI, Power Apps, and Power Automate. Skilled in collaborating with cross-functional teams to transform business requirements into technical solutions. Specialise in high-performing data team development. Able to provide technical leadership and coach the team through generalising specific data solutions into solution templates. Experienced in working with reputable organizations including St John Ambulance, Ports of Auckland, Genesis Energy, Ooredoo Myanmar Telecommunication, ING insurance, ANZ Bank, MLC/NAB, National Australia Bank and BHP Iron Mine, Ivanhoe Mines.
Overview
26
26
years of professional experience
Work History
Technical Data Lead
St John
12.2022 - Current
Led analytic efforts supporting multiple cross-functional squads, ensuring consistent practices in data solution design and implementation
Developed solution templates for various use cases in data engineering, storage, analytics, warehousing, and semantic modelling using Azure services such as Azure Data Factory, Azure Data Lake, Azure SQL Database, Azure Synapse, and Azure Analysis Services
Led the ETL (Extract, Transform, Load) process, transitioning data from an existing on-premises SQL data warehouse to a cloud-based infrastructure
Implemented improved data development practices to enhance efficiency and accuracy throughout the ETL process
Played a key role in the development of valuable data assets, contributing to the organization's overall data strategy and success.
BI Report Specialist
Ports of Auckland
11.2017 - 11.2022
Led involvement in modelling projects and writing data definitions, drawing ERDs using Azure Data Lake
Actively engaged in Azure Delta Lakehouse, Power BI, MS Flow, PowerApps, and MS SQL data warehouse projects
Developed adhoc queries and created SSRS scheduled reports to provide on-demand data for Insight Analysts and Business Analysts
Designed and implemented SSIS packages for ETL processes and conducted data reconciliation between various data sources
Developed dashboard reports using Power BI for data visualization and analysis.
Data Insights Reporting Analyst
Genesis Energy Limited
09.2015 - 10.2017
Supported Genesis Data Insights Guild by sharing knowledge, developing showcase solutions and proactively exploring, testing and disseminating new technologies
Data mart design, development, testing and implementation
Designed and implemented corporate standard reports in Power BI that enabled senior executives to track overall customer operations performance
Supported the Customer Insights Team with all data extraction, integration transformation and modelling requirements
Validate data and extraction from daily data management, and ETL loading for reporting requirements.
GIS Data Reporting Snr Specialist
Ooredoo Myanmar (Telecom)
11.2014 - 05.2015
Spatial data modelling, ERD design and analytic development in SQL server 2012
Generating and processing maps in MapInfo System
Data transformations between MapInfo and SQL database
Design development for data coverage and set up map over the whole country
Extracting data and report query from MapInfo and Telecommunication SQL database by SSIS.
Database Administrator
Durack Institute of Technology (Western Australia)
01.2013 - 12.2013
Overall data warehouse architecting, design, development and implementation
Developed operationalising data pipelines and ETL templates
Managed data validation for student enrolments, lectures and all staffs and reports development
Collaborated with program managers, stakeholders, and development team from WA central
Engaged with users and effectively understand their needs turning these into requirements
Provided on-demand data and ad-hoc reporting for the senior management.
Technical Data Reporting Analyst
OnePath (ANZ) Formerly ING
07.2008 - 03.2011
Designing of high-end data visualization to meet the corporate management requirement
Developing of coding standards, comprehensive data models on top of business data warehouse
Producing technical documentation, requirement analyses and solution designs
Understanding the Business Requirement, Identifying the Source Data, documenting the requirement and preparing the technical specification.
Technical Writer
Sustainability BHP Mine (Western Australia)
05.2011 - 06.2012
Developed and maintenance for the work instruction in Vim application
Designed and developed the operational reporting data marts for the business
Produced safety procedures and standards compliance documentation
Prepared relevant technical documentation, requirement analyses working with across the safety requirement
Detailed systems design for new requirements and enhancements, technical implementation and trouble shooting.
Technical Data Reporting Analyst
MLB/NAC (National Australia Bank)
07.2012 - 11.2012
Maintenance of legacy crystal reports and developing new iNet reports
Reconciliation of data consistency for data mapping in eclipse
Stakeholder management to meet the expectations of the business users for various reporting related requirements
Trouble shooting, functional testing and bug fixing.
Data Reporting Analyst
Intelligence Technology NZ Ltd.
04.2006 - 03.2008
Designing, implementation, gathering functional requirements for purchasing, finance, management accounting business modules for Invanhoe Mines (Mongolia, Beijing, and Vancouver)
Providing the End-to-End Architecture for Reporting
Converting business requirements to technical specification for sign off
Working with key stakeholders for testing and rollout the key reports to the users.
Metallurgical Data Reporting Analyst
Myanmar Invanhoe Copper Company
09.1998 - 03.2006
Data modelling, design, and development for Mining in business Intelligence Solution
Identifying ways to improve data reliability, efficiency, and quality reports
Developing Business Objects Universe for Mincom ERP System
Co-ordinate system analysis, testing, release and support activities.
Education
Skills
Power BI Tools
Python Programming
ETL development
SQL Database Management
Transferrable Key Skills
SQL Server Data Tools (SSIS, SSRS, and SSAS), 15+, 8
SQL Programming and Data Modelling, 15+, 8
CI/CD Implementation via Azure DevOps, 3, 6
Azure Data Factory, Azure Data Lake Storage, Azure SQL Database, Databricks, and Synapse Analytics, 3, 7
PowerApps and Power Automate, 4, 7
Power BI, 7, 8
Crystal Reports and Business Object Report (BO), 10+, 8
MS Office (Excel/ Access/ Path Info /Word / Power Point), 15+, 8
Oracle SQL (PL/SQL Developer), 4, 8
Tableau, 1, 6
Personal Information
Citizenship: NZ Citizen
References
REFERENCES AVAILABLE ON REQUEST
Timeline
Technical Data Lead
St John
12.2022 - Current
BI Report Specialist
Ports of Auckland
11.2017 - 11.2022
Data Insights Reporting Analyst
Genesis Energy Limited
09.2015 - 10.2017
GIS Data Reporting Snr Specialist
Ooredoo Myanmar (Telecom)
11.2014 - 05.2015
Database Administrator
Durack Institute of Technology (Western Australia)