All the stuff prefixed with ‘Data’, database, data lake, data warehouse, as well as MS Fabric and some more stuff.

I help organise the Birmingham Power BI User Group, seek out speakers, try to find locations and run the PBIBrum Twitter account

I help organise the Data Relay event for the Birmingham location, and help out with all the admin stuff like session selection, and help out on the day(s).

I'm a consultant at Avanade, using the Azure Data Engineering & Business Intelligence suite of tools, and I do most stuff prefixed with data. Databases, Data Lake, Data Mesh and Databricks. SQL, PySpark, Python, and all the usual stuff of building data platforms for a range of organisations and industry types.

I use the Microsoft Azure IaaS, PaaS and SaaS stack of tools, such as Azure Databricks, CosmosDB, Event Hubs, Azure SQL Database, Azure SQL Data Warehouse, and other Azure services to deliver data warehouses and other analytical solutions. I'm also the main subject matter expert for the Power BI and deliver Power BI projects and training. I also engage with the wider Ricoh Europe technical community, presenting technology and development practices.Recent Project include: Working on the… Show more I use the Microsoft Azure IaaS, PaaS and SaaS stack of tools, such as Azure Databricks, CosmosDB, Event Hubs, Azure SQL Database, Azure SQL Data Warehouse, and other Azure services to deliver data warehouses and other analytical solutions. I'm also the main subject matter expert for the Power BI and deliver Power BI projects and training. I also engage with the wider Ricoh Europe technical community, presenting technology and development practices.Recent Project include: Working on the data warehouse and data streaming architecture, for the Ricoh Spaces product, using Azure SQL DWH, Event Hubs and Databricks. Transferring data from SQL Server to CosmosDB (SQL API), for use in a website to track and trace printer toner movements. I also lead training workshops currently focused on self-service technology such as Power BI Desktop, I also worked on the internal Ricoh projects such as Ricoh Smart Suite https://myworkplace.app, as a senior data engineer, pulling data from CosmosDB and IoT sensors, using a multi cloud vendor approach.Outside my job role, I have contributed to the Ricoh Digital Service vision of how we want to evolve as a division in terms of culture, and taken the Azure AD and Linked-In photos for Ricoh Digital Services. Show less

Following the completion of the acquisition of Ridgian by Ricoh, I am now in the Ricoh Digital Services division as a Senior Consultant for Data & Analytics.My main focus is on the Microsoft Data & Analytics stack of tools such as on-prem SQL Server Data Platform, and the BI stack of applications, SSAS, SSIS, SSRS. Also work in the Azure Cloud Service, such as Data Factory, Azure Databricks, Data Lake, Power BI, and R Server, for which I use to deliver Data Warehouse, Data Marts, and other… Show more Following the completion of the acquisition of Ridgian by Ricoh, I am now in the Ricoh Digital Services division as a Senior Consultant for Data & Analytics.My main focus is on the Microsoft Data & Analytics stack of tools such as on-prem SQL Server Data Platform, and the BI stack of applications, SSAS, SSIS, SSRS. Also work in the Azure Cloud Service, such as Data Factory, Azure Databricks, Data Lake, Power BI, and R Server, for which I use to deliver Data Warehouse, Data Marts, and other Database projects for a wide variety of sectors and client types. I also engage with clients to deliver training for Power BI and SSRS, and also consult on mapping out their business intelligence strategy, and guide them in the process and data challenges than an organisation may face.Recent projects:Consulting on Power BI Premium - Examining the client’s use of Premium, looking at the performance issues and the optimisation of licensing.Azure Databricks – Created an advanced survey analytical tool using PySpark, to extract data from CosmosDB, weight and analyse the results and output. Original PoC was built in Python using the Numpy and Panda librariesAzure Functions – Using a Python Function to read the Change feed from CosmosDB process and output the results to Blob storageGoogle Big Query – Ingesting sensor data to a datamart, and creating queries for data analysisCosmosDB - Using change feed and optimising performance for reading data, and integrating with Software Engineering Show less

Business Intelligence specialist, building solutions around SQL Server 2012/14 On Premise and Azure Sevrice, and contributor to the Ridgian blog on thoughts on BI, Data and coming tech themes and changes.

Embedded in a team at a global banking organisation, with focus on reporting Payment Protection Insurance (PPI) claims, issues, and financial reconciliation. Also on other projects based on business and management intelligence reporting. Working with Teradata, SQL Server 2005/2008/2012

Developing on the SQL Server 2005/2008 Environment, and Business Intelligence Reports for the implementation of the Agency Workers Directive that came into force from December 2011.

Business Intelligence DeveloperDeveloper for the new Data Warehouse using Kimball Dimensional modelling, and building ETL processes using T-SQL and SSIS. I was the lead builder of cubes and there design using SSAS, and reporting in Office+, Excel and SSRS

Supporting the SQL Server 2005/2008 BI Environment, which extracted data from Movex/M3 (AS400) based ERP system, and supported Crystal Reports based reporting requirements for the business.

Supporting the analytical requirements for the service centre management teams, and executive managers. Information gatekeeper for the national team of engineers and equipment populations.