Diptesh Patel

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

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.

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.

• 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

• 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

• 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

• 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.

• Developed comprehensive database solutions for custom web applications using SQL Server.
• Designed and implemented data models and analytical structures to enhance system performance.

• Developed client web projects using SQL Server and .NET/C#
• Revamped Microsoft Certification (MCSD.net)

• Improved system functionality by diagnosing and resolving complex technical issues, Administered database systems.

• Developed and implemented software applications for commercial, private, and public clients across various sectors.
• Utilised VB 6 & PL/SQL and Oracle technologies