Rakesh

Power BI Developer with 7+ years of experience delivering enterprise-grade BI and Analytics solutions, specializing in Power BI, Microsoft Fabric, SQL, DAX, Power Query, and Data Modelling. Proven ability to transform complex business requirements into scalable semantic models, high-impact dashboards, and actionable insights.

Lead Power BI Developer - ProArch IT Solutions

(2025-07)

Client: Almunajem Foods

• Designed and delivered demand-planning dashboards for Forecast Accuracy, Forecast Bias, Statistical Forecast, Consensus Forecast, Actual Demand, and Revenue Impact.
• Developed advanced DAX measures for rolling 12-month analytics, YTD calculations, forecast accuracy/bias, and dynamic time-intelligence reporting.
• Built slicer-driven forecast comparison logic to switch dynamically between Statistical Forecast and Consensus Forecast.
• Developed forecast heatmaps and KPI-driven dashboards across product, region, and channel dimensions to highlight planning trends and exceptions.
• Designed interactive Power BI reports using KPI cards, matrices, tables, charts, drill-downs, and slicers to support business decision-making.
• Partnered with business stakeholders to gather requirements, validate KPI definitions, document logic, and deliver reporting solutions.
• Optimized semantic models, DAX measures, SQL queries, and report layouts to improve performance and user experience.
• Implemented Row-Level Security and Azure AD/Entra group-based access in Power BI Service.

Sr. Power BI Developer - ProArch IT Solutions

(2025-12 - 2026-04)

Client: Clicket Valley

• Developed Power BI reporting solutions in Microsoft Fabric for high-frequency industrial IoT telemetry and operational analytics.
• Designed semantic models for minute-level streaming data and optimized the model/report experience for responsive visual performance.
• Built analytical visuals combining real-time operational metrics with dynamic baseline curves to support operational monitoring.
• Applied advanced DAX, Power Query transformations, drill-throughs, bookmarks, buttons, hierarchies, and interactive navigation.

Sr. Power BI Developer - ProArch IT Solutions

(2024-11 - 2025-02)

Client: CDNY

• Designed a scalable multi-model Power BI enterprise reporting architecture across Executive, Enrolment, Finance, and SLT reporting domains.
• Built Power Query data integration logic combining multi-source SQL forecast data with enterprise fact data for rolling predictive analysis.
• Developed optimized DAX using DATESBETWEEN, EDATE, EOMONTH, and other time-intelligence patterns for variance and cumulative analysis.
• Resolved complex data-modelling scenarios involving many-to-many relationships, role-playing dimensions, and USERELATIONSHIP.
• Improved report performance by leveraging database-optimized SQL Server views and implementing dynamic Row-Level Security.

Power BI Developer - Tezo IT Solutions

(2021-08 - 2023-10)

Client: Itron Inc.

• Developed Power BI and Paginated Reports for business reporting, including invoice reporting and role-based data access using RLS.
• Built dimensional models by integrating fact and dimension data through SQL views and SSAS sources.
• Developed DAX calculations using filter, date/time, time-intelligence, logical, and text functions.
• Performed SQL and DAX query optimization and improved report usability through effective page layouts and interactive navigation.
• Created Power Query transformations including Merge, Append, Derived Column, Split, and Aggregate operations.

Azure Data Engineer & Power BI Developer - Tezo IT Solutions Grant Thornton

(2023-04 - 2024-02)

Client: Grant Thorton

• Developed and maintained Azure Data Factory pipelines for data integration between Azure and on-premises sources.
• Configured integration runtimes, linked services, datasets, control-flow/data-flow activities, incremental loads, and pipeline monitoring.
• Implemented audit tracking and archival processes to improve pipeline reliability and operational control.

Power BI Developer - Acmetek

(2018-11 - 2021-06)

• Developed analytical Power BI reports and transformed multi-source data using Power Query for optimized reporting datasets.
• Created Power BI data models and reporting structures aligned with business requirements and reporting workflows.
• Optimized long-running SQL queries using execution plans, SQL Server Profiler, and indexing techniques.
• Configured Power BI Enterprise and Personal Gateways and supported Power BI Service reporting operations.

Master of Computer Science - Computer Science - JNTU Hyderabad