Roles and Responsibilities• Responsible for creation of dashboards and interactive visual reports using Power Bi and performing DAX queries.• Customer communication to understand the requirements, report design and reviews.• Responsible for KPI and insights identification and controls recommendations.Use Case I: Development of Monitoring Analysis Platform• Developed report having executive summary, Market summary and Member’s data• Generated demo database to showcase trends as per client requirement using assumed numbers• Showcased Actual vs Target Metric %, Performance Trends, Cards showing YoY % increase, etc.

*Power Bi*• Power BI developer having Experience in Creating reports & dashboards using DAX.• Worked on Power BI Visuals including Tree Map, Funnel, Line Chart.• Knowledge of working with Map Reports and Stacked Reports.• Worked on Power Query Lists, Tables and Records.• Worked on DAX Measures and Calculations.• Worked on Power BI Cloud Publishing.• Dashboard and Dataset Refresh using Gateways.• Created Scorecards, Bookmarks, ToolTip, conditional formatting.• Worked on Power BI Licenses and Gateway Types• Scheduled Automatic refresh and scheduling refresh in power bi service.• Weekly presentation to the business users about the reports and their changes as required.• Created Drill Down Reports, Drill Through Report by Region.• Worked on all types of filters, sync slicers and edit interaction• Worked on Row Level Security, Creation of workspace*SQL Server*• Conversant with SQL coding including worked on Operators like Select, Insert, Alter, Update, Delete, Joins,Union, Case statement & Various Functions etc.Use Case I: *Sales Performance Report*• Developed report having sales Statistics like Actual vs Target revenue, Variance to target sales• Cards displaying Total sales, Sales by region, Actual Category mix, etc.• Number of Client base State wise• Year Wise, Month wise, Day Wise sales performance History chart using hierarchy• Display of above data Year wise by selecting Filter and using slicer for respective countriesUse Case II: *Product Trends Report*• Designed & Developed reporting data module for sales trends for range of products• Report having details of Customer reports, Invoice details, Product overview, Sales and quantity sold• Top 10 customers and rankings, Year on year trends, Shipment details, etc.