Summary
Overview
Work history
Education
Skills
Timeline
Certification
Generic
Diptesh Patel

Diptesh Patel

London,UK

Summary

Microsoft Certified Data professional 15+ years’ experience delivering comprehensive BI solutions, data visualization, and advanced Analytics solutions utilizing on Azure Data Platform to empower organizations in making data-driven decisions and fostering digital transformation across Finance, Asset Management, Insurance, Healthcare, and Public Sectors


University of Cambridge (Sep-2025-current) - Data Science with ML & AI

University of Cambridge Professional and Continuing Education (PACE) project-based program to advance data science career.

Overview

24
24
years of professional experience

Work history

Senior Power BI consultant(Contract)

The ArchCo (Asset Management)
City of London
09.2024 - Current

The Arch Company, Blackstone partner is the UK’s largest provider of commercial spaces for SME businesses

  • Engineered advanced Power BI reporting system throughout Archco organisation to provide detailed insights into essential Enquiry, Lettings, Termination, and Finance cash collection procedures.
  • Utilized onyx datahub build on metadata-driven Medallion Architecture on Microsoft Azure, Databricks, Dbt, python notebook
  • Implement Fabric solution to extract third-party GoCardless and Safety Culture Audit API data within lakehouse.
  • Integrate AI Copilot with fabric data agents to advance Agentic self-service reporting functionalities for Business Modelling team.
  • Documented semantic models with LLMs in Tabular Editor

Power BI Portfolio

  • Asset Management(Portfolio Analysis,Asset,Capex,Acquisitions & Disposals)
  • Lettings(Marketing,Enquiries,Lettings,Terminations)
  • Occupied Estate(Professional Services,Customer Cases)
  • Operations(LCP,Exams,FM,Capital works,EPC)
  • Finance(Debt Collections, Income Analysis,Rates & IO)
  • AI driven Insight for Customer Letting enquiry of chatbot history

Senior Power BI Developer(Contract)

Reassured (Insurance)
Basingstoke
12.2022 - 08.2024

Reassured is an award-winning, largest, FCA registered life insurance broker in the UK.

  • Spearheaded Central Data Platform Hub construction in Azure Databricks, employing Python notebooks for Power BI analytics framework.
  • Enabled Digital department to extract valuable insights from Digital policy sales analysis, focusing on Policy Conversion Rate trends, Drop-Off Performance, and Customer policy sales demographics.
  • Engage with Marketing department to obtain insights for Lead Optimization to boost lead conversion rate, Lead Cost Analysis
  • Created dynamic streaming dashboards with Confluent Kafka to enabling Sales Agent reporting team to analyse Sales call log velocity and revenue performance
  • Client servicing EMS dashboard designed for detecting early policy cancellations and SMS messaging text analysis to limit revenue loss
  • Finance cash and claw back reporting to Compiled P&L reports &
    Executed headcount reporting to track workforce metrics.


Senior Data Consultant (Contract)

Ascent (Microsoft Gold Partner Cosultancy)
London
11.2021 - 12.2022

Ascent, an Acuity Knowledge Partners company, is data, software and cloud business specialises in advanced analytics and AI.

  • Delivered high-level analytical solutions tailored to client project needs within Ascent Data Practice.
  • Developed bespoke data models in Azure Synapse to enhance strategic decision making.

Client's project:

• Medical Drug Research Trail : Leveraged Power BI Embedded Analytics for visualising tailored charts, such as drug trial history on timeline series and comparative milestones across various drugs in client's Angular JS web application.

• Facilities Management : Extracts Azure Data lake source files from Salesforce (Pipeline, commercial contract details Sales) and transform using Databricks to deliver Group Executive dashboards like Supplier Payment statistics, Net Debt & Cash Flow, National Minimum Wage Analytics , Expenses Dashboard

• Sports : Constructed Performance BI dashboard enhancing England Women's Cricket team analytics. Implemented Power App to facilitate swift performance tuning decisions. Designed pitch-side real-time dashboard for player engagement, aiding coaching strategies.

Senior Data/Power BI Engineer (Contract)

Mango Solutions (DataScience Consulting)
London
07.2021 - 11.2021
  • Work with cross functional team of Data scientist and Data Engineer at Mango Solution for E-Commerce client
  • Retail Client (BrewDog) : Develop E-comm Performance Dashboards in Power BI for Global Sales Revenue, PVM(Price Volume Matrix) Variance Analysis, AoV, Product Sales Trend & Clustering, Customer Churn and cohort analysis reports
  • Extracts data from Brewdog Amazon Web Services (AWS) Cloud source and other API Source.
  • Build Semantic Layer in Azure Synapse to utilize through Power BI data model

Azure BI/ POWER BI DEVELOPER

NHS Property Services
City of London
08.2018 - 07.2021
  • Built and managed Enterprise Data Hub via Azure solutions serving 300+ business users across Finance, HR, and Asset Management.
  • Leveraged ADF, Azure Logic Apps, and Azure Function app to ingest pertinent data from Property (Horizon), finance (Dynamics Nav), and Customer Services (Microsoft Dynamics) source systems into Azure SQL DB and BI Data Warehouse.
  • Construct dashboard for lease finance calculations for IFRS16 audit, Leasing Tracker(headlease,sublease) reporting.
  • Created Covid-19 testing dashboard (PCR & LFT), supporting NHSPS fm staff.
  • Construct Disposal Programme dashboard for regional analysis of disposal properties and market value visualisation



BI DEVELOPER/ ANALYST

Queen Mary University of London
London
08.2013 - 07.2018
  • Developed DW/Tabular Model solution to identify student lifecycle reporting(Application, Enrollment, Award)
  • Create and implement E-Learning Analytics Tabular Model with PowerBI Dashboard for evaluation of student learning activity and performance indicators for ELU department.
  • Implemented MDM strategies and DQS solutions utilizing MDS(Master Data Services) tools

SQL DATABASE DEVELOPER

Sports Alliance Ltd
London
07.2012 - 06.2013
  • Developed SRM Console using ETL pipelines and reporting for Premier League football clubs, managing 1m+ fan records
  • Built scalable database integrations for third-party API tools, enhancing email and messaging functionalities.

DATABASE DEVELOPER

Ratchit Solutions Ltd, East London
05.2009 - 06.2012
  • Developed comprehensive database solutions for custom web applications using SQL Server.
  • Designed and implemented data models and analytical structures to enhance system performance.

NET DEVELOPER

ICS
London, Croydon
05.2007 - 03.2009
  • Developed client web projects using SQL Server and .NET/C#
  • Revamped Microsoft Certification (MCSD.net)


IT SYSTEM SUPPORT ENGINEER

Miraj Financial Services
East London
04.2006 - 04.2007
  • Improved system functionality by diagnosing and resolving complex technical issues, Administered database systems.

SOFTWARE DEVELOPER

LCC Infotech Solution
India
06.2001 - 01.2005
  • Developed and implemented software applications for commercial, private, and public clients across various sectors.
  • Utilised VB 6 & PL/SQL and Oracle technologies

Education

MASTERS DEGREE - Computer Science

Matrix Institute of Computer Technology
India
2001

BACHELOR OF SCIENCE - Chemistry

Gujarat University
India
1999

Skills

  • Microsoft Fabric (Lakehouse, OneLake, DataFlow)
  • Business Intelligence & Reporting: Power BI, KPIs, Tabular & Semantic Models, Data Warehousing
  • Cloud & Data Platforms: Azure Synapse, Azure Data Factory, Azure Databricks, Microsoft Fabric, SQL Server, Data Lakes, Snowflake, Google BigQuery
  • Data Engineering: ETL, Data Pipelines
  • Programming: SQL, Python, R, DAX, MDX
  • Project Methodologies: Agile Scrum, CI/CD, DevOps, TFS

Timeline

Senior Power BI consultant(Contract)

The ArchCo (Asset Management)
09.2024 - Current

Senior Power BI Developer(Contract)

Reassured (Insurance)
12.2022 - 08.2024

Senior Data Consultant (Contract)

Ascent (Microsoft Gold Partner Cosultancy)
11.2021 - 12.2022

Senior Data/Power BI Engineer (Contract)

Mango Solutions (DataScience Consulting)
07.2021 - 11.2021

Azure BI/ POWER BI DEVELOPER

NHS Property Services
08.2018 - 07.2021

BI DEVELOPER/ ANALYST

Queen Mary University of London
08.2013 - 07.2018

SQL DATABASE DEVELOPER

Sports Alliance Ltd
07.2012 - 06.2013

DATABASE DEVELOPER

Ratchit Solutions Ltd, East London
05.2009 - 06.2012

NET DEVELOPER

ICS
05.2007 - 03.2009

IT SYSTEM SUPPORT ENGINEER

Miraj Financial Services
04.2006 - 04.2007

SOFTWARE DEVELOPER

LCC Infotech Solution
06.2001 - 01.2005

MASTERS DEGREE - Computer Science

Matrix Institute of Computer Technology

BACHELOR OF SCIENCE - Chemistry

Gujarat University

Certification

  • Microsoft Certified: Power BI Data Analyst (PL-300)
  • Microsoft Certified: Azure Data Engineer Associate
  • Microsoft Certified: Power Platform Developer (PL-400)
  • Databricks Generative AI accreditation
Diptesh Patel