Kumar B

About Kumar B

As an experienced Data Engineer with over 8 years in the IT industry, I specialize in…

Experience

1. Associate Business Analyst

   Mphasis

   Dec 2024 — Present · Bangalore Urban, IN

   Project: Success Dashboard and Partner Compensation Dashboard• Connected to SQL Server and Power BI Dataflows to extract and transform large sales datasets ensuring consistency and accuracy.• Designed interactive dashboards to monitor sales pipeline, revenue targets, and achievement rates across regions, products, and teams.• Built advanced DAX measures to calculate Year-to-Date (YTD), Quarter-to-Date (QTD), and Month-to-Date (MTD) sales performance for success tracking.• Developed partner compensation models by integrating sales achievement data with incentive/commission rules.• Automated commission calculations using SQL procedures + Power BI measures, minimizing manual errors.• Implemented drill-through reports enabling stakeholders to view partner-wise sales contribution and payout history.• Optimized the data model with star schema design, reducing load times and improving performance for large datasets.• Applied Row-Level Security (RLS) to restrict sensitive financial and sales data based on user roles (Sales Manager, Regional Head, Partner).• Set up scheduled data refreshes via Power BI Service, ensuring dashboards reflected real-time partner performance and incentive payouts.• Added trend analysis visuals (sales vs. target, compensation vs. performance) to provide actionable insights for leadership decisions.• Conducted quality checks and performance tuning to ensure reports ran smoothly without query bottleneck.

Education

• M.V.J. College Of Engineering

  Bachelor of Engineering

  2013

• MVJ College of Engineering, Bangalore, India

  Bachelor of Engineering