Kieran Patrick Wood

Microsoft Fabric Consultant, Data Engineer, Data Architect, Technical Author, Publisher and Trainer @Innovative Business Intelligence Ltd

Leeds, GB
MOBILE NUMBERS
+91 *********19

Signup · Get unlimited contacts

WORK HISTORY

Apr 2011 — Present

Microsoft Fabric Consultant, Data Engineer, Data Architect, Technical Author, Publisher and Trainer @Innovative Business Intelligence Ltd

View department →

Leeds, GB

Using the Microsoft Fabric stack including Dake Lakehouses, Warehouses, Data Pipelines, Gen 2 Data Flows. Also utilising Microsoft BI Stack of Azure Data Factory (ADF) including version 2, Synapse SQL Serverless and Synapse SQL Dedicated Pools, Databricks, Synapse Link, APIs, SSIS, SSAS (Tabular and Multi-Dimensional), SSRS, T-SQL and SharePoint. This includes setting up the architecture for clients with data sets consisting of 6+ million new records per day being added to a 2+ billion single fact table using partitioning, specifying BI servers and training of permanent staff for effective handover. Data analytics solutions been delivered to the following customer types, health care, financial services, music, websites with giga-byte data feeds, construction, retail and local government.Data analytics data sources included Dynamics Finance & Operations, Business Central and CRM. I successfully integrated D365 Finance and Operations with Azure Data Lake using Synapse Link. I successfully integrated D365 Business Central with Azure Data Lake using a Synapse API connection.I have successfully utilised PySpark to create data cleansing and transformation processes. I am also able to leverage PySpark to empower the customer to track, manage and continuously improve data quality. Purview has been utilised to promote effective data governance, data integrity and conformance to legislation such as the Data Protection Act and Freedom of Information Act.I am able to iteratively migrate a hybrid data warehouse from mainly snowflake to mainly star schema based in a production environment whilst keeping this data analytics solution fully operational.I am most effective where I can work in an agile scrum two-weekly sprint environment where Azure Dev Ops is fully utilised as an agile project management tool, a version control repository, configuration/change management and release deployment tool.

EDUCATION

N/A

The Open University

Postgraduate Certificate, Object Oriented Software Development

N/A

The Open University

Postgraduate Certificate, Software Development for Networked Applications using Java

N/A

The Open University

Postgraduate Certificate, Relational Database Systems

2001 — 2005

The Open University

Post Graduate Diploma, Software Development

N/A

The Open University

Postgraduate Certificate, Software Engineering

N/A

The Open University

Postgraduate Certificate, Advanced Database Technology

N/A

The Open University

Postgraduate Certificate, User Interface Design and Evaluation

N/A

The Open University

Postgraduate Certificate, Project Management

SKILLS

Business AnalysisVb.netPowerviewSoftware DocumentationSdlcStored ProceduresArchitectureCubesPowerbiBusiness IntelligenceAnalysis ServicesSharepointTestingEtlData QualitySsisVisual BasicPowerpivotRelational DatabasesPowerqueryT-SqlAccessData MigrationAgile MethodologiesMdxCrmData ModelingTabular ModelDatabasesMaster Data ManagementDimensional ModelingSsrsBusiness ProcessXmlDatabase DesignIT StrategyKimball MethodologyData AnalysisDashboardMicrosoft Sql Server

ABOUT KIERAN PATRICK WOOD

View my ebook on Amazon. \"Microsoft Certified Solutions Expert in Data Management and Analytics Consultant inc. Microsoft Fabric, Synapse and Power BI\" status on the following link. https://learn.microsoft.com/en-us/users/kieranwood-6787/transcript/vpmmrc3kjqk1wlz?source=docsKieran is one of the most endorsed and recommended Microsoft Data Platform Consultants within the UK. He is an established trainer, mentor and public speaker on Power BI, Fabric and the Microsoft Data Platform stack including Azure Architecture, Azure Synapse, Azure Data Factory and Azure SQL Database. Kieran continually invests time and resources to research into further optimising the way our customers can increase their business insights using their own data. This is while Kieran strives to spend each day delivering pragmatic solutions catering for the customer’s immediate needs.Kieran is also an expert in creating data analytics solutions which provide advanced data analytics based on multi-billion row record sets.My Microsoft Certification includes Microsoft Fabric, Azure Data Engineering, Azure Enterprise Data Analysts, Azure Data Analyst (Power BI), Azure Administrator and Expert Level certification in Azure Architecture.https://community.powerbi.com/t5/Data-Stories-Gallery/Power-BI-Best-Practice-Recommendation/m-p/745072#M2786https://community.powerbi.com/t5/Data-Stories-Gallery/DAX-Reference/m-p/729697#M2738Twitter url- https://twitter.com/KieranIBI

This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.

Kieran Patrick Wood — Microsoft Fabric Consultant, Data Engineer, Data Architect, Technical Author, Publisher and Trainer at Innovative Business Intelligence Ltd in Leeds, GB | Unifers