Prabhash Kumar

• Designed and owned enterprise semantic models integrating cloud data sources into governed Power BI datasets supporting cross-functional analytics and executive reporting.
• Built Dataflows, aggregation layers, and reusable DAX frameworks enabling scalable, consistent KPI definitions across teams.
• Implemented performance optimization through star-schema modeling, incremental refresh, and aggregation strategies, improving report responsiveness and refresh reliability.
• Partnered with data engineering and business teams to convert analytical requirements into production-grade BI architectures rather than one-off dashboards.

Key Enterprise Analytics Platforms Delivered

Enterprise Resource & Productivity Analytics Platform

• Architected a centralized platform tracking system utilization, bandwidth consumption, application usage, and user productivity across the organization.
• Enabled leadership to identify performance bottlenecks, peak-load patterns, and optimization opportunities , driving enterprise-wide efficiency improvements.

OTT Content Performance & Revenue Intelligence Platform

• Built a show-level performance system tracking watch time, impressions, and revenue across a large OTT content catalog.
• Delivered weekly and monthly comparative views supporting ad sales, content strategy, and partnership monetization .

Broadcast & Digital Ad Inventory Management System

• Designed an inventory planning platform providing current and 45-day forward visibility into ad slot availability at half-hour, hourly, and program-slot granularity .
• Enabled sales teams to optimize inventory allocation and maximize revenue realization .

Competitor & Market Intelligence Analytics Platform

• Architected a competitive intelligence system tracking Fair Share, Market Share, Fill Rate, Channel GRP, and advertiser presence across networks.
• Built multi-dimensional slicing by Target Group, Genre, Sub-genre, Advertiser Group, and Market Segments .
• Implemented advertiser gap analysis and peer benchmarking to identify new revenue opportunities and sales performance gaps.

Distribution & Pricing Intelligence Platform (Write-Back Enabled BI)

• Built a distribution roadmap and pricing platform covering all markets, distributors, and point-of-sale locations .
• Implemented secure, parameterized write-back from Power BI enabling real-time updates to pack pricing, channel inclusion, and penetration metrics .
• Delivered a single source of truth for market performance and competitor pricing , supporting data-driven pricing strategies .

Enterprise Performance Analytics Platform (Prism Replacement)

• Led development of a next-generation Power BI platform replacing a legacy analytics website for network, channel, show, and episode-level performance analysis .
• Architected a DirectQuery semantic model using parameterized backend table functions , enabling high-performance, real-time filtering without bulky data imports.
• Built hierarchical analytics (Network → Channel → Show → Episode) across 10+ years of historical data with GRP, Market Share, Watch Time, and Impressions .
• Designed a highly interactive user experience with Market, Genre, and Target Group filtering and executed a phased enterprise rollout .

• Led architecture and delivery of enterprise Power BI platforms across multiple healthcare analytics programs supporting large user bases.
• Designed centralized semantic models and governed datasets enabling consistent KPIs across projects.
• Implemented RLS, workspace governance, and dataset ownership models for secure, multi-tenant BI access.
• Integrated Azure data pipelines and cloud data warehouses into Power BI using optimized SQL and refresh strategies.
• Introduced calculation groups, composite models, drill-throughs, and bookmarks to improve platform scalability and performance.

• Built automated executive dashboards for credit card operations tracking processing volumes, defect rates, and operational KPIs .
• Designed analytics web applications integrating Python, SQL, and Power BI to track trainee performance, grading, and compliance.
• Developed data quality and plagiarism detection frameworks using Python and SQL with reporting layers in Power BI.