Harpal Sinh Jhala

6 groups · 34 skillsCircle area shows how many skills a group holds.

• p_01featured · ai

  Sales · Microsoft Fabric

  AI Sales Analytics

  Fabric lakehouse to an interactive D3 dashboard. Analysis, design and code produced by Claude Code agents that I directed and reviewed.

  • Microsoft Fabric
  • OneLake
  • T-SQL
  • Python
  • D3.js
  • Claude Code

  Explore Live: AI Sales AnalyticsCase Study: AI Sales Analytics
• p_02

  Quick Commerce · Power BI

  Blinkit Pulse Analytics

  Quick-commerce analytics on 5,000 Blinkit sample orders: sales, the 15-minute delivery promise, customer experience and marketing ROAS, on a star schema with 44 DAX measures in ₹ lakh / crore.

  • Power BI
  • DAX
  • Power Query
  • Python
  • Claude Code

  Explore Live: Blinkit Pulse AnalyticsCase Study: Blinkit Pulse Analytics
• p_03

  Public Safety · AI-built report

  Car Theft Analytics + AI

  New Zealand vehicle theft analysis on 4,553 records. I designed the star schema and 28 DAX measures. Claude Code built the 5-page report and theme under my direction.

  • Power BI
  • DAX
  • Power Query
  • Claude Code

  Explore Live: Car Theft Analytics + AICase Study: Car Theft Analytics + AI
• p_04

  Real Estate

  Real Estate Brokerage Analytics

  Profitability and client segmentation model that identified 30% of total revenue tied to NPAs, plus property performance and sales trends across verticals.

  • SQL
  • Power BI
  • DAX

  Explore Live: Real Estate Brokerage AnalyticsCase Study: Real Estate Brokerage Analytics
• p_05

  Capital Markets

  Stock Brokerage Analytics

  Segment-wise trade and revenue analytics to find high potential HNI clients, with active and passive client tracking that helped RMs prioritise advisory effort.

  • SQL
  • Power BI
  • DAX

  Explore Live: Stock Brokerage AnalyticsCase Study: Stock Brokerage Analytics
• p_06

  People Analytics

  HR Management Analytics

  Workforce analytics covering attrition patterns, hiring funnel and headcount trends. Early warning indicators surfaced to HR leadership, 20% attrition reduction.

  • SQL
  • Power BI

  Explore Live: HR Management AnalyticsCase Study: HR Management Analytics

Client work under NDA. Outcomes shared, data never.

• MENA · Insurance

  via WhiteBlue Cloud Services

  Qatar Insurance Group

  Reporting turnaround cut

  90%+

  before

  48h

  after

  2h

  C-suite Power BI reports

  14

  • Reports for the CFO, Senior VP and C-suite: profitability, claims ratio, loss ratio and disease burden.
  • Power BI to PowerPoint automation took a 2 day task to under 2 hours.
  • Built to UAE data governance and compliance standards.

• India · BFSI

  Kunvarji Group

  Brokerage revenue

  +15%

  Real estate revenue found in NPAs

  30%

  Analyst team led

  3

  • Architected the master enterprise data warehouse on SQL Server: views, stored procedures, ETL.
  • Inactive account analytics that helped relationship managers win back revenue.

• India · Renewable energy

  via WhiteBlue Cloud Services

  Adani Green Energy

  Energy plants on one view

  1,000+

  • 5 Power BI reports on real-time cash flow and operational KPIs.
  • One semantic model with drill-through, so KPIs match across every report.

• US · Mortgage servicing

  via Azimuth

  Bank of America

  Dashboard figures

  SQL-verified

  • SQL validation of mortgage servicing analytics for Azimuth clients, including Bank of America.
  • Reconciled source data against dashboard outputs to confirm every reported figure.

• Infrastructure

  via WhiteBlue Cloud Services

  Ports efficiency model

  Planning for senior leadership

  Clearer CAPEX

  • Reporting model that reduced CAPEX planning uncertainty for senior leadership.

1. Mar 2025 – Present

   1 yr 7 moscurrent

   Senior Data Analyst

   WhiteBlue Cloud Services

   Champion of Customer Trust 2025

   Executive BI and data validation for MENA insurance, US mortgage servicing, renewable energy and ports clients.

   ClientsQatar Insurance GroupBank of America (via Azimuth)Adani Green Energy

   • 14 C-suite reports

     Power BI for the CFO, Senior VP and C-suite at QIC: profitability, claims, loss ratio, disease burden. Built to UAE data governance standards.

   • 2 days → 2 hrs

     Automated the Power BI to PowerPoint client reporting pipeline, a 90%+ turnaround cut.

   • 1,000+ energy plants

     5 Power BI reports tracking real-time cash flow and operational KPIs for Adani Green Energy.

   • BofA figures verified

     SQL validation and reconciliation of US mortgage servicing dashboards for Azimuth clients, including Bank of America.

   StackSQLPower BIDAXPower QueryAzure Data Lake

2. Feb 2024 – Mar 2025

   1 yr 1 mo

   BI Developer

   Kunvarji Group (Techaxion)

   Star Performer 2024

   Data warehouse and BFSI reporting across stock brokerage, real estate and insurance.

   • Master EDW

     Led architecture of the enterprise data warehouse: tables, views, stored procedures and ETL on SQL Server.

   • +15% revenue

     Inactive account analytics that lifted brokerage revenue.

   • 30% in NPAs

     Reporting that showed 30% of real estate revenue was locked in non-performing assets.

   • Team of 3

     Led analysts through requirements, sprint planning and Power BI delivery.

   StackSQL ServerSSMSETLPower BIDAX

3. Sep 2022 – Sep 2023

   1 yr

   Data Analyst

   BYJU'S

   Reporting and data quality for the Academics department.

   • Automated

     Power BI reports and reporting pipelines that replaced manual reporting across business units.

   • Clean ERP data

     SQL integration, transformation and validation for ERP data.

   StackSQLPower BIExcel

1. me

   step_01

   Direct

   I define the business question, the grain and the data model before any code exists.

   -- question: which clients went inactive?
   -- grain: one row per client per month
   -- model: star schema, 1 fact + dims

2. AI agents

   step_02

   Accelerate

   AI agents draft the SQL, DAX, pipelines and report UI in minutes, not days.

   > claude: draft MoM % measure in DAX
   > claude: build the Python export
   ✓ drafts ready for review

3. me

   step_03

   Verify

   I reconcile every number against source, because executives act on it.

   SELECT SUM(amount) FROM source;
   -- compare with dashboard total
   ✓ match, or back to drafting

doesn't match the source? back to step_02

• 25
  2025

  Champion of Customer Trust

  WhiteBlue Cloud Services

  For BI delivery to Qatar Insurance Group across MENA insurance reporting.

• 24
  2024

  Star Performer

  Kunvarji Group

  For BI delivery and business impact across multiple verticals.