Summary
Overview
Work History
Education
Skills
Websites
Languages
Accomplishments
Timeline
Generic

Koyal Roy

Mumbai(Relocating to Dubai In Oct 2025)

Summary

Seasoned Solutions architect and Delivery Lead with expertise of 12 years in Databricks(Azure,AWS), PySpark, Delta Lake and Data mesh concepts , Microservices, Azure DataFactory, Warehouse , modelling & Visualizations, Power Platform . Proven ability to collaborate with cross-functional teams to design technical practices, roadmaps and solutions architectures aligned with business requirements. Enabled Data Platform Modernization majorly in Healthcare, Food & Beverage Industry, Logistics Aiming to leverage my technical skills and proven track record of architecting and delivering high-impact solutions to drive data domain initiatives and contribute to strategic decision- making processes

Overview

12
12
years of professional experience

Work History

Analytics Manager

Mondelez International
Mumbai
08.2023 - Current
  • Architected a unified data platform that enabled the successful delivery of 10+ analytics projects across 3 business units within 12 months, reducing time-to-insight by 25%. Implemented reusable, configuration-driven Databricks notebooks to standardize Medallion architecture pipelines with automated workflows, modular libraries, and CI/CD deployment. Spearheaded Unity Catalog governance, setting up a scalable meta-store and region-specific workspace access models, improving data access compliance and audit readiness by 20%.
  • Successfully worked on Feature evaluation of DLT, Autoloader, Delta Sharing, Lakehouse Federation, AI/BI Genie, DBRX LLM with clear focus on technical compliance and data security.
  • Worked with Databricks(US team) directly in adoption and onboarding of DLT (Delta Live Table) framework along with Confluent Kafka team for streaming use cases through scalable Microservices architecture.
  • Created roadmap in partnership with global stakeholders across US, EU in successful implementation of pilot Databricks data domain project on AWS with application teams.

Lead Analyst

XPO Logistics
Mumbai
10.2020 - 09.2023
  • Successfully led a team of 10+ developers across locations in Conversion of SQL ETL SPs to PySpark, spark SQL Notebooks using Databricks, with revised architectural patterns between traditional warehouse to spark framework through analysis on execution physical plans, DAG analysis, optimizing shuffles, join modifications, liquid clustering, purge strategy(variable history retention), job cluster sizing, partition determination and configure storage patterns of parquets in Delta Lake format in ADLS.
  • Designed daily incremental load pipelines in Azure Data Factory, implement backup and archiving stages in Data Lake, connecting to disparate sources, and increase pipeline reusability through parameterization, variables, and dynamic content usage.
  • Worked in performance tuning of entire ELT pipeline reducing execution time by 30%.
  • Designed KPI definitions for 10 PowerBI and paginated reports.

Previous Experiences
11.2013 - 09.2020
  • As Platform Owner for Power BI Reporting at a leading GCC Bank, I oversaw vendor partnerships, guided internal teams for report delivery, and provided end-to-end technical solutions (15+ dashboards).
  • In a subsequent Techno-functional Consultant role, I drove stakeholder alignment, architected data solutions using Azure Data Factory, Azure Analysis Services, and Power BI, and led the migration of on-premises DWH to Microsoft Azure PaaS-ensuring automated ETL, self-service BI, and agile delivery.

Education

Bachelor of Technology - Computer Scienece

Future Institute of Engineering And Management
Kolkata
05.2013

Skills

  • Data architecture
  • Azure Data Factory (ETL)
  • Lake house, Delta Lake,data warehouse
  • Storage: S3, ADLS
  • Semantic modeling and Power BI
  • Apache Spark
  • Databricks Unity Catalog
  • Delta Live Table (DLT)
  • streaming - Kafka
  • Performance tuning
  • Microservices, Docker, Kubernetes
  • CI/CD
  • git
  • NoSQL databases
  • RAG
  • Agentic framework
  • Team leadership
  • Stakeholder engagement

Languages

English
First Language
English
Proficient (C2)
C2

Accomplishments

Received NAT TECH Global award (1st from XPO India) recognition. - Aug 2022 (XPO logistics)

Received Operational Excellence award – Q2 2022 (XPO Logistics)

Received Special Impact Award – Q2 2021 (XPO Logistics)

Received Best Team Member certification in 2019 for Internal Project at KPMG

Received Best Team Member certification in 2018 for the Ab Inbev CUB project (KPMG)

Timeline

Analytics Manager

Mondelez International
08.2023 - Current

Lead Analyst

XPO Logistics
10.2020 - 09.2023

Previous Experiences
11.2013 - 09.2020

Bachelor of Technology - Computer Scienece

Future Institute of Engineering And Management
Koyal Roy