Summary
Overview
Work History
Education
Skills
Websites
Certification
Volunteering And Leadership
Awards And Scholarships
Timeline
Generic

Aditya Sahay

BHAGALPUR

Summary

Data Engineer with expertise in Microsoft Fabric, focused on building scalable data pipelines and integrating diverse data sources. Proficient in designing data models and optimizing performance to support business intelligence using Power BI, Spark, and Data Factory. Experienced in SQL Server development, SSAS Tabular Model creation, and data visualization. Strong skills in DAX, M-Query, and ADF, with a commitment to delivering results and fostering growth.

Overview

4
4
years of professional experience
1
1
Certification

Work History

Technical Lead

Hcl Tech
Noida
07.2022 - Current
  • Leading 4 team member/Fresher
  • Developer for Power BI Team
  • Estimation and planning.
  • Interacting with the design and analysis team to understand business requirements and the complexity of reports.
  • Analysis and development of complex reports, dashboards, and DAX queries, and then SSRS report for the same dashboard.
  • Support to all stages of testing team.

Project

Project 1.Application Developer/DBArchitect PSC- (Business Analysis Application For Hcl)
Sql Sever Coding in backend "Requirement Analysis "Release Process and Deployment
Led the optimization of SQL Server coding in backend, resulting in a 20% boost in
application performance, ultimately enhancing user experience and operational
efficiency.
• Project -2 ERS Analytics Client : Internal
• Power BI report Developer
• Project Description :
ERS Analytics - • Data Modeling &Dashboarding • Paginated Report • Data Defects/issue
fixing and implementation of new requirements. • Data Quality Assurance. • Dealing with
huge data with different data sources.
• Project 3: Maximo KPI - Client: Maximo

• Power BI Developer

• Technologies Used: SSAS, Microsoft Power BI, SQL Server Database, DAX, and SQL.
• Project Summary -
Created Power BI reports and SSRS report Individually. Integrate Power BI Report &SSRS
Report with Power Bi Slicer to develop 2 lakh data Download facility for User.
• Project 4. Productive Analysis Unit Client: Internal. Managed data from the Metric tool, conducting thorough unit testing to guarantee 100% accuracy of the Power BI report for informed business decisions.

•DE For Leap PCI: Designed and developed Lakehouse architecture using Microsoft Fabric for centralized, scalable data storage and analytics.

  • Built robust data pipelines using Dataflows Gen2 and Pipelines for ingesting data from on-premises and cloud sources (SQL, APIs, Excel, and SharePoint).
  • Created Delta tables for transactional and analytical workloads, leveraging Notebooks with PySpark and SQL.
  • Developed semantic models and Power BI datasets directly on top of Lakehouse (DirectLake mode) for high-performance analytics.

Software Engineer -Data Analytics

Siemens Eda(Mentor Graphics)
Noida
06.2021 - 02.2022

• Project Title : Workflow History (Resource Allocation)
• Power BI Developer

Technologies Used : SSAS (Tabular Model) , Microsoft Power BI, SSRS, DAX, SQL
Project Summary to create UI documents in collaboration with functional team and build
Power BI reports and dashboards and a SSRS report for the resource management
department

• Roles & Responsibilities :
Developer for Power BI Team • Estimation and planning. • Interacting with design &
analysis team to understand business requirements and complexity of Reports. • Analysis
and development of complex Reports, Dashboards and DAX Queries and then SSRS
report for the same dashboard. • Support to all stages of testing team.

Education

Bachelor Of Engineering - Electronics And Communication

Birla Institute Of Technology,Mesra
Ranchi
08.2020

SSCE -

Techno Mission International School
Bhagalpur
05.2015

SSE -

Navyug Vidyalaya
Bhagalpur
05.2013

Skills

  • Microsoft Fabric
  • ADF (MS FABRIC)
  • PySpark
  • Microsoft Power BI
  • SSRS
  • Dax
  • SQL
  • ADF (MS FABRIC)
  • Databricks
  • Synapse
  • Python
  • Azure ML
  • Business Intelligence
  • PBI Dashboard
  • Data integration and Migration
  • Data Visualization
  • Microsoft Analysis Services
  • Microsoft SQL Server
  • Performance Tuning
  • SQL Server Reporting Services

Certification

  • Networking, CISCO
  • Data Analytics With Power Bi, Percipio

Volunteering And Leadership

HCLTech, Leading 4 team member/Fresher

Awards And Scholarships

Best Performer Award, Exceptional Performer Rating at HCLTech

Timeline

Technical Lead

Hcl Tech
07.2022 - Current

Software Engineer -Data Analytics

Siemens Eda(Mentor Graphics)
06.2021 - 02.2022

Bachelor Of Engineering - Electronics And Communication

Birla Institute Of Technology,Mesra

SSCE -

Techno Mission International School

SSE -

Navyug Vidyalaya
Aditya Sahay