Experience

Kingfisher Mobile Ltd.

• BI Technical Lead

  • Jul 2021 - Present

  Kingfisher is the next-gen mobile experience company setting a new standard in mobile ownership. For too long, the legacy exchange of new and used connected devices has been riddled with inefficiencies. It’s bad for carriers, bad for consumers and bad for the environment. Our team of global tech & telco experts are deploying ingenious mobile experience solutions that capture greater value for carriers, give consumers more choice, and reduce the environmental impact. We’ve come together to optimize the lifecycle of smart devices and create an entirely new type of business. I'm doing data and tech stuff.



Opal Group

• United States
• Events Services
• 1 - 100 Employee

• Senior Data Engineer

  • Apr 2021 - Jul 2021

  Key Accountabilities: • Solution design. • Matillion design and build. • Snowflake data layer design and build. • Metadata control, design, and build. • ELT Logging design and build. • Setting up a snowflake security model Achievements/Highlights: • Deploying to production a metadata driven delta load model in Matillion/Snowflake within a month, with two sources. • Enabling the deployment to Matillion/Snowflake production of 21 different databases spanning 3 different system types (MS SQL, MySQL, SAP) within 3 months. • Enabling Opal, the capability to have zero code deployments of the data layer, with governance and controls.



Treasury Wine Estates

• Australia
• Beverage Manufacturing
• 700 & Above Employee

• BI Systems Manager

  • Oct 2020 - Apr 2021

  Key Accountabilities: • Delivering new data pipelines using glue and Lambda. • Documenting historical processes. • Helping to fix master data issues. • General BAU activities. • Testing and reconciliation of data pipelines. Achievements/Highlights: • Productionising new pipelines using Lambda and Glue for use on the TPM system. • Automating manual daily processes, ETL. • Providing advice and guidance on Power BI best practices. • Fixing a major data issue on an undocumented legacy system and getting it back up in running within a day.



Department of Environment, Land, Water and Planning

• Australia
• Government Administration
• 100 - 200 Employee

• Senior Business Intelligence Developer

  • Mar 2020 - Sep 2020

  Key Accountabilities: • Report design, build, testing, and deployment, both canned and adhoc. • Data analysis. • Solution design for both storage and pipelines. • Documentation of guidelines and standards. • Mentoring colleagues. Achievements/Highlights: • Designing and building a Fire history dataset containing all fires on Public land since 1972, this enables consistent reporting across years enabling less work prior to fire season and the ability to easily analyse year on year fire seasons. This will also enable DELWP to easily share their fire data to partner agencies and academics. • Designing and building bushfire recovery dashboards and reports using Power BI and SSRS. With little to no requirements, sometimes helping to create data capture tools. This work enables the Ministers, senior executive and land managers to understand how the recovery work is progressing. This work has also included some COVID economic response and recovery work. • Helping the report builders utilise Power BI in more sustainable ways through holding training sessions on some of the more complex modelling tasks, this has improved performance of some of the reports and dashboards helping overall user experience.



Hydro Tasmania

• Australia
• Renewable Energy Power Generation
• 500 - 600 Employee

• Senior Data Developer

  • Jul 2018 - Dec 2019

  Key Accountabilities: • Architect an end to end data warehouse solution in Snowflake, including security. • Architect a data warehouse ELT Framework in Matillion. • Developing conceptual, logical and physical data models. • Administering and developing Power BI • Documentation of guidelines and standards • Coaching junior team members. • Solution design. Achievements/Highlights: • Working with vendors, consultants, and internal teams, we successfully implemented snowflake. This included designing and implementing role-based access controls in snowflake. • Modelling the new data lake, including governance controls, this facilitated the decommissioning of the legacy system and realising over 200K in savings per year. • I successfully initiated and ran a review of commercially available ETL/ELT tools for snowflake. This included the business case and implementation plan — the conclusion resulting in a successful POC and implementation of Matillion.



Latitude Financial Services

• Australia
• Financial Services
• 700 & Above Employee

• Business Intelligence Manager

  • Oct 2016 - Jul 2018

  Key Accountabilities: • BI Chapter lead – Running a bi-weekly chapter meeting, peer reviews, setting standards, running brown bag sessions for the team. • Team development - provide training, mentoring, coaching and stretch opportunities to increase individual capabilities aligned with their development plans. • Scrum Master – SAFe certified. • Feature owner - BI standards, BI architecture, Analysis services design guides, Deployment and deployment processes. SAFe PM/PO certified • BI infrastructure architecture – Designed, developed and deployed Microsoft BI stack in AWS EC2 instances. Achievements/Highlights: • Deployed Power BI into the enterprise. Delivering the ability for the business to have one platform to view all their data across any device. • Created BI and DW standards across the release train; applying industry best practices and reducing complexity of solutions, therefore reducing ongoing BAU costs. • Oversaw the conversion of Tableau reports into Power BI reports while rationalising the reports from over twenty down to three, resulting in a reduction of costs, reduced complexity and a better faster user experience. • Participated in RFP to pick both vendors and cloud services vendor.



MONEY3

• Australia
• Financial Services
• 100 - 200 Employee

• BI/DW Analyst

  • Jun 2015 - Oct 2016

  Key Accountabilities: • Data warehouse design, build, testing and deployment. • Report design, build, testing and deployment, both canned and adhoc. • Data analysis. • BI infrastructure architecture Achievements/Highlights: • Deployed Power BI to the organisation. Resulting in better faster data driven decisions. • Created and deployed a usable and valid Data warehouse POC for the Branch network within three months. • Converted Excel reports into Power BI. • Brought the concept of meta data driven approach to data warehouse building to the company. This reduced build time and changes allowing faster turnaround time to deliver value to the business.



Brightstar

• New Zealand
• Events Services
• 1 - 100 Employee

• Senior BI/DW Developer

  • Jan 2012 - Jun 2015

  Key Accountabilities: • Data warehouse support • Report design, build, testing and deployment, both canned and adhoc. • Data analysis. • ETL, DW, Report design, development and testing. Achievements/Highlights: • Help develop a Global supply chain data warehouse, enabling move visibility from ordering to inventory management, driving profits from better management of those areas. • Helped build a meta data warehouse automation tool. This enabled faster to market development of our data warehouses and reporting solutions. • Ran a small offshore team to deliver a bespoke reporting solution. Helping to meet our contractual obligations to Telstra. • Optimised a suite of ETL jobs resulting in reduced delivery time from 22 hours down to 6 minutes. • Successful supported multiple data warehouse applications and kept within the agreed SLA



NXG Business Solutions

• United Kingdom

• BI/DW Consultant

  • Jan 2011 - Nov 2011

  Products: Banking data warehouse, P&L, CAPEX and OPEX Reporting system, Forecasting. Responsibilities: • ETL Development and maintenance. • Develop standard reports and functional dashboards. • Manage expectations. • Requirement gathering. • Writing and maintaining training, support and test documentation. • Database management and development. • Level 3 support. • Development of proof of concepts. • Pre-sales. • Administer user access and security. • Create disaster recovery plans.



Crane Group

• Wholesale Building Materials
• 1 - 100 Employee

• BI Report Developer

  • Feb 2010 - Jan 2011

  Products: Distribution and supply chain data warehouses Responsibilities: • Develop standard reports and functional dashboard. • Developing and execute project plans within assigned schedule and timeline. • Manage expectations. • Requirements gathering. • Writing and maintaining training, support and test documentation. • Database management and development • ETL Development and maintenance • Level 3 support Products: Distribution and supply chain data warehouses Responsibilities: • Develop standard reports and functional dashboard. • Developing and execute project plans within assigned schedule and timeline. • Manage expectations. • Requirements gathering. • Writing and maintaining training, support and test documentation. • Database management and development • ETL Development and maintenance • Level 3 support



Senetas

• Australia
• IT Services and IT Consulting
• 1 - 100 Employee

• BI Consultant

  • Feb 2008 - Jan 2010

  Products: Revenue & Target Data warehouse, CRM reports Responsibilities: • Manage ETL process. • Work with client (Telstra) to collect requirements for change requests and reporting requirements. • Constant data validation. • Writing and maintaining training, support and test documentation. • Database management and development. • ETL Development and maintenance. • Ad-hoc reporting using MDX and SQL. • Level 3 support. Products: Revenue & Target Data warehouse, CRM reports Responsibilities: • Manage ETL process. • Work with client (Telstra) to collect requirements for change requests and reporting requirements. • Constant data validation. • Writing and maintaining training, support and test documentation. • Database management and development. • ETL Development and maintenance. • Ad-hoc reporting using MDX and SQL. • Level 3 support.