Summary
Overview
Work History
Education
Skills
Websites
Certification
Disclaimer
Timeline
Generic

Kashish Bhatnagar

Senior Developer (Data & BI)
Dubai

Summary

Data Engineer with 8+ years of experience in building scalable data solutions. Expertise in Azure Data Factory and Databricks to design and orchestrate robust ETL pipelines and cloud data workflows. Led seamless cloud migrations and optimized SQL processes for high-performance data integration. Built dynamic data models and automated reports to deliver insights and drive strategic decisions. Strong experience in OTT viewership analysis, using data to enhance user retention and engagement.

Overview

9
9
years of professional experience
6
6
years of post-secondary education
4
4
Certifications

Work History

Senior BI Developer

OSN
Dubai
06.2024 - Current
  • Increased user satisfaction by optimizing existing BI systems through performance tuning, troubleshooting, and bug resolution.
  • Minimized inaccurate reporting through rigorous quality assurance testing for all developed reports and dashboards before deployment.
  • Built and managed data pipelines using Azure Data Factory and SSIS to migrate data from Oracle to Azure Synapse.
  • Led migration from SSIS to Databricks, enabling scalable, cloud-based data processing.
  • Developed Power BI reports with Power Query, integrating and transforming data from multiple sources.
  • Created optimized data models with relationships and hierarchies in Power BI.
  • Wrote DAX measures and time intelligence functions for KPIs and trend analysis.
  • Designed interactive dashboards with drill-downs, slicers, and custom visuals.
  • Developed efficient SQL queries, stored procedures, and views for clean and fast data access.
  • Managed Power BI Service and configured on-premises gateways for secure, real-time refreshes.

Senior Consultant

Xebia
Dubai
02.2022 - 06.2024
  • Working as a Senior BI Developer in a client-facing role, leading BI development and support while managing an offshore team.
  • Developed ETL pipelines, reports, and dashboards using Microsoft BI Stack and Power BI.
  • Delivered end-to-end Power BI solutions, including interactive dashboards and paginated reports.
  • Led migration from legacy SSIS to Azure Data Factory and Databricks, improving scalability and maintainability.
  • Utilized Spark SQL in Databricks for efficient data processing and transformation.
  • Migrated data from Google BigQuery and Google Cloud to Azure Synapse, ensuring seamless integration and performance optimization.
  • Implemented data governance strategies, including data security, user-level access, data quality checks, and source-to-target mapping.

Data Analyst

WSP Consultancy
Noida
10.2020 - 02.2022
  • Collaborated directly with UK-based clients to gather business requirements, write technical specifications, and present data-driven insights using Power BI.
  • Designed and developed interactive Power BI dashboards to monitor key environmental metrics such as carbon emissions and dip levels.
  • Automated ETL workflows using complex SQL scripts and stored procedures in Azure SQL to streamline data ingestion and cleansing.
  • Modeled data using fact and dimension tables, and applied DAX for calculated columns and KPIs in Power BI’s data model.
  • Utilized Power Query Editor for data transformation and cleansing at the report level.
  • Created dynamic visualizations including bar charts, treemaps, ArcGIS maps, and KPI cards for interactive reporting.
  • Deployed reports via Power BI Service and configured on-premises data gateway for scheduled data refreshes.

Data Analyst

EasyRewardz Software Services
Gurgaon
11.2019 - 10.2020
  • Worked with clients (Carters, Soch, William Penn, VLCC) on retail analytics, customer segmentation, and cohort analysis.
  • Conducted market basket analysis, customer lifetime value (CLV), and campaign performance analysis using MySQL.
  • Optimized SQL queries for campaign data processing and insights into customer engagement and sales performance.
  • Automated data updates with SQL Events for age and anniversary age calculations.
  • Designed Power BI dashboards with dynamic visualizations (bar charts, pie charts, treemaps, and filled maps).
  • Applied DAX for KPI calculation, trend analysis, and forecasting.
  • Implemented Row-Level Security (RLS) in Power BI for personalized data access.

Software Engineer

NIIT Technologies
Noida
07.2017 - 10.2019
  • Worked with Python libraries (NumPy, Pandas) and SQL for data cleaning and KPI extraction in the insurance sector.
  • Analyzed and visualized insurance sales data using Power BI, creating dimensions, fact tables, and calculating KPIs with DAX.
  • Built interactive Power BI dashboards and reports for executive insights into insurance performance.
  • Gained exposure to data warehousing concepts such as DataMart, OLAP, OLTP, Star Schema, and Snowflake Schema.
  • Wrote complex SQL queries and stored procedures for efficient report data extraction.
  • Worked with Azure Blob Storage and Azure Data Lakes for data ingestion and processing.
  • Implemented efficient dimension modeling and optimized Slowly Changing Dimensions (SCD) strategies to improve data warehouse performance and data accuracy.

Data Analyst Consultant

Yashwasin Technologies Pvt Ltd
Noida
05.2016 - 06.2017
  • Analyzed financial datasets (Mutual Funds) to extract business insights.
  • Used Python (NumPy, Pandas, BeautifulSoup) for data scraping, cleaning, and ingestion into SQL Server.
  • Wrote SQL queries and stored procedures for Power BI data extraction.
  • Created Power BI reports on Mutual Fund performance.
  • Gained exposure to Azure Data Factory components, including Blob Storage, Data Lakes, pipelines, and transformations.

Education

B. TECH - CSE branch

Noida Institute of Engineering And Technology
Noida
01.2013 - 01.2017

HIGHER SECONDARY -

CBSE
Moradabad
04.2012 - 03.2013

SECONDARY -

CBSE
Moradabad
04.2010 - 03.2011

Skills

SQL

Azure Data Factory

Spark SQL

Power BI

SSIS

Azure Synapse

undefined

Certification

Took online training of SSIS from Udemy.

Disclaimer

I hereby declare that all the information given above is correct to the best of my knowledge.

Timeline

Senior BI Developer

OSN
06.2024 - Current

Senior Consultant

Xebia
02.2022 - 06.2024

Data Analyst

WSP Consultancy
10.2020 - 02.2022

Data Analyst

EasyRewardz Software Services
11.2019 - 10.2020

Software Engineer

NIIT Technologies
07.2017 - 10.2019

Data Analyst Consultant

Yashwasin Technologies Pvt Ltd
05.2016 - 06.2017

B. TECH - CSE branch

Noida Institute of Engineering And Technology
01.2013 - 01.2017

HIGHER SECONDARY -

CBSE
04.2012 - 03.2013

SECONDARY -

CBSE
04.2010 - 03.2011

Similar Profiles

CREATE PROFILE
Kashish BhatnagarSenior Developer (Data & BI)