Pawan Jadhav PMP® — Data Engineering & Analytics

Azure

ADLS • ADF • Databricks • Synapse • Azure SQL • Functions • Key Vault • DevOps Pipelines

• FHIR → Bronze/Silver/Gold on Databricks (PySpark) with Delta + Medallion.
• ADF-based ELT to Synapse/Snowflake with dynamic, parameterized datasets.
• Serverless Functions for micro-batch ingestion and DQ execution.

AWS

S3 • Glue • DMS • Lambda • Step Functions • Athena • EMR • IAM

• CDC via DMS → S3 → Glue ETL with partitioning & compaction (Parquet).
• Lambda + Step Functions orchestrating serverless workflows.
• Athena views for ad-hoc analytics; cost-optimized lifecycle policies.

FHIR ETL — Spark to Snowflake

Built an automated ETL framework for ingesting FHIR-compliant JSON data using PySpark and Snowflake Streams/Tasks. Implemented SCD2 for Member/Provider tables, dbt tests, and lineage tracking.

Impact: 2.5× faster loads, improved auditability, and ~30% cost optimization.

Healthcare Claims — Anomaly Detection

Developed an anomaly detection pipeline using ICD-10 CM and utilization signals to flag potential fraud, waste, and abuse. Includes profiling, feature engineering, and BI dashboards for SIU/integrity teams.

Impact: Reduced false positives by ~18%; faster case triage and review.

Pricing & Margin Analytics

Designed ELT pipelines that integrate product, sales, discount, and cost data to compute net price, margin, and KPIs. Snowflake marts power exec dashboards for segment, customer, and SKU-level profitability.

Impact: Report runtime improved from 11m → 90s; 40% faster KPI analysis.

Transaction Fraud Analytics

Built near-real-time fraud detection workflows leveraging event streams and anomaly detection in Snowflake and Python. Features transaction velocity, merchant risk, device fingerprint, and geo anomalies for scoring.

Impact: Reduced investigation time by ~35%; improved detection recall by ~15%.

Warehouse Inventory & Replenishment ETL

End-to-end ETL pipeline integrating WMS, ERP, and POS data into curated inventory models on Snowflake / Databricks. Calculates inventory positions, reorder points, and safety stock by SKU–location with dbt tests and lineage.

Impact: Designed to reduce stockouts and excess inventory through data-driven replenishment.

Transportation Route & Cost Optimization

Ingests shipment, carrier, and telematics (GPS) data to build lane-level KPIs such as cost-per-mile, cost-per-drop, and transit reliability. Uses Spark & Snowflake to power interactive dashboards for carrier and route benchmarking.

Impact: Enables optimization of freight spend and routing decisions across the network.

Policy & Claims Data Vault

Designed a policy–claims data vault on Snowflake integrating policy admin, billing, and claims systems. Built hubs, links, and satellites to support 360° policy/insured view and downstream star schemas.

Impact: Simplified lineage and faster enablement of new actuarial & reporting use cases.

Pricing & Underwriting Risk Analytics

Built ELT pipelines to create exposure, premium, and loss triangles by segment, product, and geography. Supports pricing adequacy, loss ratio, and retention analysis for underwriting and actuarial teams.

Impact: Reduced manual spreadsheet work and accelerated pricing review cycles.

Clickstream & Conversion Funnel Analytics

Ingests web events, sessions, and cart actions into a curated funnel model (visit → view → add-to-cart → checkout → purchase). Enables drop-off analysis by channel, device, and campaign.

Impact: Exposed high-drop funnels and improved conversion experiments.

Product Recommendation & Personalization Mart

Built a user–item interaction mart combining orders, views, and wishlists for recommendation engines (collaborative filtering / “customers also bought”). Serves real-time feature sets to downstream models.

Impact: Framework ready for A/B testing of personalized recommendations.