Senior BI & Analytics Engineer

Real Work. Real Impact.

8+ years of end-to-end BI delivery — from Oracle-to-Snowflake migrations to AI-powered reporting with Microsoft Fabric and MCP Server integrations.

business DEFTeam Solutions
corporate_fare Infosys Limited
200+
Dashboards
30%
Faster Processing
25%
Less Manual Work
8+
Years Experience

Featured Case Study

Snowflake Microsoft Fabric Oracle Power BI DAX

Oracle → Snowflake + Microsoft Fabric Migration

End-to-end enterprise data platform modernization at DEFTeam Solutions — migrating legacy Oracle ETL to Snowflake and Microsoft Fabric, reducing data processing time by 30% while enabling real-time analytics.

2021 – Present
error

The Challenge

  • Legacy Oracle ETL pipelines causing slow data refresh cycles and reporting delays.
  • Fragmented data sources across Oracle, REST APIs, and SharePoint with no unified layer.
  • Manual reporting workflows consuming 15+ hours per week with no governance framework.
architecture

The Strategy

  • Migrated legacy Oracle logic to Snowflake with query optimization and star-schema redesign.
  • Built new ETL pipelines in Microsoft Fabric / Azure Data Factory sourcing Oracle, Snowflake, APIs & JSON.
  • Applied AI Copilot to automate insight summarization, cutting manual effort by 25%.
verified

Key Outcomes

30%

Reduction in data processing time via Snowflake optimization

25%

Less manual effort via AI Copilot automation

20%

Reporting efficiency improvement across business teams

Project Portfolio

dashboard
2021–Present

Enterprise BI Dashboard Suite

Public, operational, geospatial, and financial dashboards in Power BI for DEFTeam Solutions clients. Leveraged Copilot to enhance data exploration, delivering a 35% reduction in ad-hoc data access requests.

Power BI MS Fabric DAX Copilot
trending_up 35% fewer ad-hoc requests DEFTeam Solutions
account_tree
2022–Present

BI & Analytics Pipeline (Fabric Migration)

Migrated legacy Oracle + IBM DataStage ETL to Microsoft Fabric and Azure Data Factory. Built unified pipelines extracting from Oracle, Snowflake, REST APIs, SharePoint, and JSON for real-time lakehouse analytics.

MS Fabric Oracle Snowflake Azure Data Factory
trending_up 30% faster processing DEFTeam Solutions
smart_toy
2024–Present

AI Prompt Engineering & Copilot Automation

Applied AI Prompt Engineering and Microsoft Copilot to automate insight summarization and reporting workflows across Power BI Service. Reduced manual effort by 25% and cut ad-hoc data requests by 35%.

AI Prompting Copilot Power BI Power Automate
trending_up 25% manual effort saved DEFTeam Solutions
map
2021–2023

Geospatial & Location Analytics

Integrated QGIS geospatial data and custom maps into Power BI and Spotfire dashboards. Enabled location-based operational intelligence for field teams and executive regional reporting.

QGIS Power BI Spotfire Custom Maps
location_on Location Intelligence DEFTeam Solutions
shield_lock
2016–2020

Enterprise Power BI Governance at Infosys

Developed and maintained 200+ Power BI and Spotfire dashboards at Infosys for global enterprise clients. Implemented RLS, workspace governance, and Power Automate workflows saving 15+ hours/week.

Power BI Spotfire RLS Power Automate
trending_up 15+ hrs/week saved Infosys Limited
sync_alt
2016–2020

IBM DataStage ETL Pipelines

Designed and implemented ETL workflows using IBM DataStage at Infosys, integrating data from relational databases, REST APIs, and JSON feeds. Authored complex SQL views and stored procedures for ad-hoc analytics.

IBM DataStage SQL Server REST APIs JSON
data_object Multi-source Integration Infosys Limited

Work Experience

work
  • Own end-to-end Power BI analytics delivery, designing and deploying dashboards for multiple business teams, improving reporting efficiency by 20%.
  • Lead direct client interactions for requirement gathering, KPI definition, and dashboard walkthroughs — translating discussions into SRDs and Power BI mockups.
  • Migrated legacy Oracle ETL logic to Snowflake, reducing data processing time by 30% through query optimization and semantic model restructuring.
  • Built data integration workflows using Microsoft Fabric / Azure Data Factory sourcing from Oracle, Snowflake, REST APIs, and JSON.
  • Administered Power BI Service with Row-Level Security (RLS), workspace governance, performance tuning, and deployment pipelines.
  • Applied AI Prompt Engineering and Microsoft Copilot to automate insight summarization, cutting manual effort by 25%.
  • Developed geospatial dashboards integrating QGIS and custom maps into Power BI and Spotfire for field team intelligence.
Power BI MS Fabric Snowflake Oracle Copilot / AI RLS QGIS
work_history
  • Developed and maintained 200+ Power BI and Spotfire dashboards for global enterprise clients, improving decision-making by 10%.
  • Designed and implemented ETL workflows using IBM DataStage and Power BI Dataflows, integrating data from relational DBs, REST APIs, and JSON feeds.
  • Authored complex SQL queries, views, and stored procedures supporting ad-hoc analytics and standardized enterprise reporting.
  • Automated report refresh and distribution using Power Automate, saving 15+ hours per week.
  • Trained 20+ business users and junior team members on Power BI and Spotfire, driving self-service BI adoption.
Power BI Spotfire IBM DataStage SQL Power Automate
school
Jul 2012 – May 2016

B.Tech — Computer Science & Engineering

Dr. APJ Abdul Kalam Technical University (AKTU), Uttar Pradesh, India

Certifications

psychology

AI Prompt Engineering

UpGrad · 2025

bar_chart

Microsoft Power BI — Masterclass

Udemy · 2024

verified

TIBCO Certified — Spotfire

TIBCO · 2022

In Progress
hub

Microsoft Fabric DP-600

Udemy · 2025

Let's Build Smarter BI Together.

Open to Senior BI Engineer, Analytics Engineer, and BI Architect opportunities — India and remote globally.

mail Contact Me LinkedIn
homeHome grid_viewWork articleResume psychologySkills menu_bookBlog contact_supportContact