My Work

Projects & Professional Contributions

A selection of professional projects I've designed and built at ICICI Lombard — spanning data lake architecture, real-time APIs, and automation systems. These are enterprise-grade, production systems serving large-scale BFSI operations.

Featured Projects

01
Automation · BFSI
Python Automation for Open Architecture Framework
ICICI Lombard General Insurance

Automated the regulatory SLR calculation process across insurance products — transforming a slow, manual workflow into a near real-time, daily-refresh system.

  • Reduced processing time from 7 days to ~2 days with daily, MTD & YTD refresh
  • Eliminated manual intervention across multiple insurance product lines
  • Built reusable Python automation modules aligned to Open Architecture standards
  • Reduced overall manual effort by ~70%
Python Azure Databricks PySpark Automation BFSI Regulatory
Production · Internal
View Profile
02
Data Platform · Azure
Enterprise Data Lake Platform
ICICI Lombard General Insurance

End-to-end enterprise Data Lake built on Azure and Databricks, ingesting 30+ sources across the organisation using a scalable Medallion architecture.

  • Designed ingestion architecture for 30+ sources — databases, APIs, and flat files
  • Implemented Bronze / Silver / Gold Medallion layers with Delta Lake
  • Built reusable ingestion frameworks reducing onboarding time for new sources
  • Platform owner managing Databricks workspace for 50+ users with Unity Catalog & cost governance
Azure Databricks Delta Lake Azure Synapse ADLS Unity Catalog Python SQL Medallion Architecture
Production · Internal
View Profile
03
API Development · Real-Time
Customer Eligibility API
ICICI Lombard General Insurance

A high-performance eligibility determination system using CDC-based processing, Cosmos DB, and Azure Functions — consumed directly by customer-facing mobile applications.

  • Built large base datasets using CDC logic for near real-time customer data freshness
  • Stored eligible customer records in Cosmos DB for low-latency API reads
  • Exposed via Azure Function APIs integrated into mobile applications
  • Designed customer identity mapping (Cluster ID) to unify lead & customer records
Azure Functions Cosmos DB CDC REST APIs Python Databricks Delta Lake
Production · Internal
View Profile
04
Real-Time · ML Scoring
Real-Time Event Scoring Platform
ICICI Lombard General Insurance

Migrated a batch scoring system to near real-time event processing — enabling live business rule scoring across 9 features with integrated OCR-based document verification.

  • Migrated from 15-minute batch to near real-time event ingestion & scoring
  • Enabled real-time scoring for 9 business features simultaneously
  • Integrated OCR-based document validation into the scoring pipeline
  • Integrated Data Lake with marketing (SMS/Email/IVR) and call-centre systems
Real-Time Processing Azure Databricks OCR Python PySpark Event Streaming Business Rules
Production · Internal
View Profile

More on GitHub

Explore my open-source projects including Flask apps, Django deployments, Android apps, and Python tools.

github.com/MitulPanchal