Mohit Bhakat

▸ Led zero-downtime migration of 500+ tables across 15+ databases from Apache Hive metastore to
Databricks Unity Catalog — delivered on schedule with 100% data integrity via automated PySpark
reconciliation framework.
▸ Architected Unity Catalog three-level namespace replacing legacy Hive two-level structure; enforced fine
grained row-level and column-level security aligned with HIPAA and Microsoft internal governance policy.
▸ Implemented enterprise data lineage tracking, automated PII classification, and audit-ready governance
framework for HIPAA-regulated consumer healthcare data.
▸ Migrated all PySpark workloads from Hive-context to Unity Catalog-aware Spark sessions — 100% workload
compatibility, zero production incidents.
▸ Produced stakeholder migration runbooks, rollback playbooks, and knowledge transfer documentation for
Microsoft CDCN engineering and governance teams.

Client: Wells Fargo | Treasury Management & Client Insights Platform | Financial Services
Tech Stack: Azure Synapse Analytics, Azure Databricks, Delta Lake, PySpark, RabbitMQ, Redis, ADF, Power BI,
Dataverse
▸ Architected Medallion (Bronze/Silver/Gold) platform on Azure Databricks processing multi-terabyte
transactional and client datasets across 10+ distributed banking systems with 99.5% SLA compliance.
▸ Cut end-to-end Spark pipeline processing time by 40% via partition pruning, adaptive query execution, and
Delta OPTIMIZE — reducing nightly batch window from ~6 hours to ~3.5 hours.
▸ Implemented Redis caching for AI-generated client insights, cutting dashboard response time by 45% and
eliminating downstream query load on Synapse.
▸ Built PySpark ML anomaly detection and transaction risk scoring for near real-time fraud monitoring —
reducing manual risk review workload by 20%.
▸ Led and mentored cross-functional onshore/offshore team of 18+ engineers on distributed data engineering,
streaming patterns, and enterprise AI best practices.
▸ Designed high-availability and disaster recovery architecture for business-critical analytical workloads,
including backup strategies, failover planning, and resilient distributed processing.

▸ Engineered Medallion architecture on Azure Databricks ingesting from Cosmos DB through multiple
transformation layers, enabling scalable enterprise analytics across P&Gs global IT operations.
▸ Delivered GenAI solution using LLM APIs orchestrated via Databricks notebooks to automate transaction
summaries, anomaly alerts, and compliance reports — cutting analyst report-prep time by ~30%.
▸ Designed Snowflake data objects and ETL pipelines integrating SAP BI into Snowflake, improving query
performance and reducing ETL failure rates.
▸ Implemented Unity Catalog for enterprise data cataloging, PII classification, and lineage tracking —
achieving regulatory compliance across global P&G operational datasets.
▸ Automated Airflow DAG CI/CD, improving deployment reliability and compressing release cycles from weekly
to daily.

IFRS Compliance & Financial Reporting PL/SQL,
▸ Designed Talend ETL processes transforming financial data across jurisdictions to meet IFRS compliance and
cross-border regulatory reporting standards.
▸ Led POC migration from Oracle BI to Tableau — enabling self-service analytics and reducing BI dependency
on IT from days to hours.

▸ Designed Oracle Warehouse Builder ETL and data warehouse solutions for Citibank wealth management —
supporting client reporting and portfolio management for investment banking.
▸ Analyzed UK copper-to-fiber migration network requirements for British Telecom, planning new site builds
and resolving downstream control system faults across UK exchanges.
▸ First in 2010 TCS batch to achieve Oracle OCA certification; received award for leading a 22-member team
across 2 parallel simultaneously (2014). Served as representing TCS delivery at the
client site.