Rahul Kumar Dubey Email & Phone Number

Bengaluru, Karnataka, India

Delivered comprehensive 24/7 support for technologies including Power BI, Power Automate, Power Apps, AI, Pyspark, and Azure• Managing a team, overseeing the entire project lifecycle from knowledge transfer to final handover• Leverage existing skills in data ingestion, on-demand querying, data modeling, and data visualization within Microsoft Fabric interface.Ownership of delivery forecasting, variance analysis. Worked closely with Stakeholders and Functional leaders to create Ready… Show more Delivered comprehensive 24/7 support for technologies including Power BI, Power Automate, Power Apps, AI, Pyspark, and Azure• Managing a team, overseeing the entire project lifecycle from knowledge transfer to final handover• Leverage existing skills in data ingestion, on-demand querying, data modeling, and data visualization within Microsoft Fabric interface.Ownership of delivery forecasting, variance analysis. Worked closely with Stakeholders and Functional leaders to create Ready to Integration and Ready for Deployment dates Show less

Bengaluru, Karnataka, India

• Designed Data Model and analyzed data requirements needed to support the business processes within the scope of corresponding information system in organization.• Collaborated with various regions team, business users, and data engineers to develop and manage complex data warehouse solutions and databases• Leverage existing skills in data ingestion, on-demand querying, data modeling, and data visualization within Microsoft Fabric interface.• Designed various dashboard to match… Show more • Designed Data Model and analyzed data requirements needed to support the business processes within the scope of corresponding information system in organization.• Collaborated with various regions team, business users, and data engineers to develop and manage complex data warehouse solutions and databases• Leverage existing skills in data ingestion, on-demand querying, data modeling, and data visualization within Microsoft Fabric interface.• Designed various dashboard to match with the client BI needs with available and custom visuals on Power BI.• Ingested Data from various source system to ADLS GEN 2 with the help of ADF Pipelines.• Designed SQL views in Azure Synapse from the transformed data stored in Final layer of ADLS GEN2 so that it can be consumed by Data Analysts in Power-BI.• Transformed raw data in Azure DataBricks using SQL and Pyspark that is Ingested from source systems as per Business requirements and stored the data in delta tables in ADLS GEN2.• Automated system processes to improve operational efficiency by 40% and lower costs• Developed and implemented ETL processes to improve data quality, resulting in a 20% increase in data accuracy Show less

India

• Worked extensively in Power Bi report creating data model for Power BI.• Developed DAX commands to pull up more calculated data out of the table.• Collaborated with Analytics and BI teams to develop globally adopted metrics and reporting-on-demand solutions, reducing manual data analysis by over 50%.• Supported and troubleshooted ETL processes, including data extraction, transformation, and loading, ensuring data integrity and optimal performance.• Designed KPI dashboards… Show more • Worked extensively in Power Bi report creating data model for Power BI.• Developed DAX commands to pull up more calculated data out of the table.• Collaborated with Analytics and BI teams to develop globally adopted metrics and reporting-on-demand solutions, reducing manual data analysis by over 50%.• Supported and troubleshooted ETL processes, including data extraction, transformation, and loading, ensuring data integrity and optimal performance.• Designed KPI dashboards using Power BI data visualizations charts/slicers, schedule refresh and data clean-up.• Developed data models that streamlined data processing pipelines in the Azure environment, resulting in an increase of 30% in productivity.• Generated drill down, drill through, matrix reports and parameterized reports using expression to calculate, group, filter using Power BI.• Trained a team of 15 data analysts in best practices for data analysis and visualization, improving team productivity by 30%. Show less

Bengaluru Area, India

• Designed and developed time tracking utilization report with effective performance management program to track employee productivity, billability and utilization.• Normalizing and modeling datasets to build aggregates, which enables BUs to take better business decisions.• Supported end to end KPI process from validating data points at different phases of the KPI cycle to publishing reports at different levels useful for people across management hierarchies.• Designed metric and… Show more • Designed and developed time tracking utilization report with effective performance management program to track employee productivity, billability and utilization.• Normalizing and modeling datasets to build aggregates, which enables BUs to take better business decisions.• Supported end to end KPI process from validating data points at different phases of the KPI cycle to publishing reports at different levels useful for people across management hierarchies.• Designed metric and visualized report to identify cost center wise forecast and actual travel cost.• Supported L4/L5 level leadership in center performance review, automation of KPI Reports Show less

Bengaluru Area, India

• Worked on developing DataMart for Tesco Retail Website using Data Warehousing/Data Mining.• Created Data warehouse, data marts, stored procedures, triggers for setting up reporting database.• Automated 5 end user reports using VBA and VB Script. Fine tuning database and server settings

India

> Corporate and strategic planning and forecasting model roll rate model.> Dashboard Design as per timelines and goals of operations team.> Developed and created TSQL (DDL, DML, TCL and DCL) queries, objects, indexes, complex stored procedure, tasks, triggers and CTE.

B-Tech, Ece, 6.5 Cgpa

Activities and Societies: Winner of Hurdle Race at division level. Champion of inter college cricket team. Represented in Football.

Master Of Business Administration - Mba, It And Systems, 6.0