John Danson Email & Phone Number

Wellington, New Zealand

Designed and implemented a comprehensive data warehouse system, streamlining data operations.Established ETL processes and wrote integral code to enhance data management.Led the setup of Power BI and Reporting Services, generated detailed reports, designed workspaces, and utilized DAX scripting knowledge effectively.Developed an efficient Azure DevOps board for ticketing and change requests, improving project tracking and workflow.Designed a connected repository system that synchronizes with the Azure DevOps board, enhancing version control and change management.Analyzed and interpreted complex datasets, providing actionable insights to drive business growth and efficiency.Collaborated with IT teams to ensure data security and adherence to compliance standards.Supervised and mentored a team of coders, providing guidance, troubleshooting support, and promoting a productive learning environment.Educated various business units on the intricacies of data handling and report interpretation, empowering data-driven decision-making.Worked collaboratively with multiple departments such as Operations, Sales, Legal, Finance, and Clinical to deliver tailored BI solutions.Navigated resource constraints to support a substantial user base, producing quality reports that received positive feedback.Championed a culture of data-driven decision making, ensuring all stakeholders understand and utilize available data tools and insights.Took on an array of BI-related tasks, demonstrating adaptability and dedication to the organization's data objectives.

Wellington

New Zealand

Delivered End to End BI solutions using Microsoft BI tools (SSIS, SSAS, SSRS, Power BI) Experience including: Data Warehousing• Analysis and Design• Data Modelling• ETL • Data Quality Analytics, Reporting and BI• Report Development• Dashboards and Scorecards• VisualisationPlatform Optimisation• Performance Tuning• Architectural Design ReviewTraining and Application SupportSQL Training to private and public sectors

Wellington

Developed end to end Power BI solution utilizing Microsoft BI Stack (3 Tier architecture):Data Warehouse DesignETL Data Modelling Analysis and Metric elicitationUI Design

Dunedin, New Zealand

Developed and maintained reporting suite using relevant toolsDesigned and developed NZCU South's data warehouse and reporting environmentMaintained database to ensure integrity and availabilitySet up and configured ETL workflowsTransformed and converted dataMaintained relationships with key internal and external stakeholders to ensure requirements are met and integrations are maintainedAd Hoc and Scheduled ReportingVisualizationsCore CompetenciesMicrosoft BI Stack (SSIS, SSAS, SSRS)Power BIOracle Business Intelligence Enterprise Edition Oracle BI Publisher & AnalyticsMicrosoft Office Suite (Excel Expert)MS SQL / Oracle 11g,12cPL/SQL C# Scripting VBAKimball methodology

Dunedin

Creating and configuring workflows in MS SQL Server Integration Services (SSIS).Analyzing, coding, implementing and creating complex query reports using SQL Server 2012Managing the timely flow of business intelligence information to senior managers and users.Providing data and analysis in support of the company's initiatives and projects.Making sure that reports are delivered accurately and on time.Coming up with analysis that is cogent and timely.Liaising with stakeholders to develop BI solutions.Implementing changes to existing BI systems.Optimizing data for scale and performance.Providing end user training Visualizing data

Dunedin, New Zealand

Owned and operated internet cafe/coffee shop business. My role consisted of software installation, purchase of hardware and installation, hiring and training of staff, managing of marketing, inventory, profitability and reporting.

Dunedin

Responsible for operation of business and stakeholder relationships while provided a high level of customer service to general public and assisting the facilitation of polytechnic students.

Bachelor Of Science, Information Science

Diploma In Film And Tv Production

Studied For Bcom In Marketing & Management

Oracle Bi Publisher 11G R1: Fundamentals Ed 2, Information Technology

Oracle Bi 12C: Create Analyses And Dashboards Ed 1, Information Technology