Diptesh Patel

• Established ArchCo centre of excellence platform utilising Microsoft Fabric and Power BI for business analysis.
• Designed and developed interactive Power BI dashboards for Asset Management, Finance, Marketing, and Compliance.
• Enabled Copilot and AI functionality within Power BI to automate report generation through Q&A prompts.
• Created and managed diverse semantic models to centralise and standardise data across reports.
• Enhanced business performance by leveraging advanced reporting capabilities throughout the organisation.

Outline

Senior Power BI SME to collaborate with Reassured stakeholders to gather requirements and translate into effective data-driven solutions

Key Responsibilities

• Design, develop, and implement robust Central Data Platform Hub using Azure cloud, Databricks and Microsoft Fabric Power BI Analytics framework.
• Create and manage varied semantic models in databricks Lakehouse, used Python notebooks to standardize data
• Follow Agile delivery/DevOps methodology to apply incremental change to overall data platform
• Helped Digital department to unlock insight of Digital policy sales analysis like Policy Conversion Rate trend, Drop-Off Performance, Customer policy sales demographics
• Work with Marketing department to helping to get insight for Lead Optimization to increase lead conversion rate, Lead Cost Analysis
• Helped Sales Team by building near real-time Streaming data from Confluent to delve into Sales Performance report to track Sales agent and team Revenue tracker, Sales call log reporting
• Client Servicing EMS dashboard to identified early Policy cancellation and SMS messaging text analysis to minimize loss revenue
• Finance cash & claw back reporting, P&L Report, Headcount reporting
• Design and align on mock-ups using varied tools to build enhanced Power BI dashboard with real data and other data models.
• Prepare documentations (process and technical) to enable proper knowledge transfer of both process and solution to data team

Outline

Provided high-level analytic solutions as part of Ascent Data Practice team to multiple clients on projects and effectively manage client's needs

Key Responsibilities

• Lead data technology strategy of Power BI & developing roadmap, wireframe and proof of concept to helping client's to make pragmatic decisions.
• Developed optimised user experiences through collaboration with multi-disciplinary client's stakeholders
• Follow Agile Scrum methodology & Sprint planning in solution delivery to collaborate & prioritize workloads with cross team.

Client's project:

• Medical Drug Research Trail Client : Worked with Power BI Embedded Analytics to visualize custom Charts like Drug trial history on timeline series, comparison of milestone for multiple drugs in client's Angular JS web application
• Facilities Management Client : Extracts Azure Data lake source files from Salesforce (Pipeline, commercial contract details Sales) and transform using Databricks to deliver Group Executive dashboards using their & create stunning dashboard like Supplier Payment statistics, Inflation & Pass-through, Net Debt & Cash Flow, National Minimum Wage Analytics , Expenses Dashboard Followed IBCS Best standard Practices and Utilize Advanced custom power BI Visualization like charticulator, xViz, infoRivor.
• Sports Client : Build England Women's Cricket team Performance BI dashboard, used Power App to make better and fast performance tuning decision, pitch side real time player engagements dashboard to Inform decision making for coach and players, based on historical data

Outline

Work with cross functional team of Data scientist and Data Engineer at Mango Solution for E-Commerce Sales Analysis, Customer purchase trend, Product recommendation solutions

Key Responsibilities

• 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 behaviour, High v Low value customers, 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 PowerBI data model
• Analysed data and produced modelling to identify Customer trends and product sales efficiencies.

Outline

Develop and deliver BI and Data Analytics solutions for NHS Property services which meet corporate priorities as part of development team

Key Responsibilities

• Design compelling dashboards to Provide actionable commercial insights for Finance (increased profit/decreased cost/reduced Value at Risk), Asset Management (Property, Lease, FM Dashboard), HR, Customer Service and Data Governance in PowerBI Dashboard and Reports.
• Build and managed Enterprise Data Hub (EDH) for cross-system, historical, and ad- hoc reporting using Azure solution of IaaS, Paas, Saas components.
• Used Azure Data Factory, Azure Logic Apps, Azure Function app to Ingest relevant data of Property(Horizon), finance(Dynamics Nav) , Customer services(Microsoft Dynamics) source systems to Azure SQL DB and BI Data Warehouse.
• Build complex dashboard for Lease finance calculations for IFRS16 Audit, Headlease and sublease using Power Query, Dax, M formulas in Power BI.
• Build NHSPS Covid Reporting dashboard for lateral flow self-tests and PCR tests taken at NHS test center logged through PowerApps into Enterprise Data Hub.
• Design Disposal Programme dashboard to delve cash and sales profit performance insight, Disposal properties analysis by Region, Stats visualization by Market Value, Timeline measures for Contract Exchange date (forecast v Actual).

Outline

Build DW Multidimensional Analysis Model for a Queen Mary University wide Enterprise Data Warehouse covering Student Lifecycle Reporting (Enrolment, Admission, Application etc.)

Key Responsibilities

• Implemented Tabular Model Analysis Services (SSAS) solution for identifying students at risk of dropping out for Student Retention Project to Analysis Data on PowerBI, Power view dashboard and drilldown to SSRS Reports
• Design and build E-Learning Analytics Tabular Model and PowerBI Dashboard for Analyzing Student learning activity and Performance measurements for ELU department
• Implemented MDM strategies and DQS solutions utilizing MDS(Master Data Services) tools
• Develop BI Self Service Model for Senior Power Users and Admin staff

Enhanced Training Courses at QMUL:

• Dimensional Modelling Kimball Agile Data warehouse Design Training by Lawrence Corr
• Microsoft Business Intelligence End to End with SQL Server 2012 and SharePoint 2013.

Outline

Responsible for development and implementation of custom database systems for SRM Console built on Silverlight/.Net Technologies of client system

Key Responsibilities

• Developed and Maintain ETL Processes and Reporting system for clients to Create and manage Marketing Campaigns, Club-Wide Reporting and BI Tools activities
• Build high Scalable Database Integration for Third Party API Tools like CommCorp, Colestream for Email and Messaging functionality
• Identified and Resolved daily issues by monitoring Error Reporting Dashboard in order to ensure database flow works consistently.

Outline

Worked for custom database driven web application and database solution

Key Responsibilities

• Database for the core business process of the system using Sql server
• Identified data issues and provided recommendations for resolution to ensure optimal performance.
• Designed and developed Data model and analytical data structures.

Outline

Enhance Microsoft Certification(MCSD.net ) Training

Key Responsibilities

• Worked with Microsoft ADO.NET, Sql Databse Object and tools
• Worked on Web projects within the company using SQl Server & .NET/ C#
• Development and remote/local debugging using VS.NET 2003 IDE.
• Install and Manage SQL Server Development of SQL Server 2000/2005

Outline

Produced an end-to-end employee monitoring & management solution, Included analysis and development of time-sheet system, asset usage monitoring

Key Responsibilities

• Worked with internal and external clients for import and normalization of third-party data
• Assisted new and existing clients with integration and data conversion activities

Outline

Played a key Role in developing and implementing software applications, Enterprise Application Services to e-business solutions for commercial, private and public clients and organizations across many Sectors

Key Responsibilities

• Experience of Windows Application software development using Visual Basic 6 and form designing using PL/SQL, Oracle technologies.