Ritesh Deshmukh Email & Phone Number

Pune, Maharashtra, India

• Having Good Experience on Power BI Desktop and Service Development and worked on the Power BI Reports & Dashboards with SQL Server and Excel • Develop Power BI reports and effective dashboards after gathering and translating end user requirements.• Imported data from multiple data sources into BI Tools, created relationships between data, created calculated columns and measures using DAX Query.• Implemented ROW LEVEL SECURITY (RLS) as part of security in Power BI.• Experience in MS Power BI concepts like Data Modeling, DAX Functions, creation of Power BI charts &Graphs(Guage, Slicers, Funnel, KPI, Matrix, and Custom Visualizations).• Having experience in creating different charts like Line chart, bar chart, table, matrix table, area chart, scattered chart, tree map, gauge chart.• Used slice and Dice, Drill Down, Drill Up, Visual filters, Cascading list of values etc.• Experience in creating maps like filled map, shape map and having experience in using filters like page, visual, report and drill through filters.• Published the report by creating content Pack and sharing PBIX file.• Having experience in creating Dashboards based on client requirements.• Implemented Power BI gateway different source to matching analysis criteria and further modelling for Power BI.• Working on MS SQL Server and writing queries to pull the data.• Extensively used Derive Column, Data Conversion, Conditional Split and Aggregate transformations.• Good Knowledge of various data base objects like Stored Procedures, Views, Indexes.• Implemented performance tuning on various levels

Mumbai, Maharashtra, India

• Creating Power Bi reports and deploying to Power BI service• Calculating Total no of bookings, Quotes, invoices, and access logs.• Created Month on months graphs for deep understanding by using time intelligence DAX functions.• Created Customer churn analysis Report to analyze the customer retention.• Creating Country adoption Report, Support Analysis Report, Monthly and fortnightly review report.• Strong hands-on experience in designing and developing dashboards/charts/stories using data joining/ blending.• Designed, developed Reports, Dashboards, Workbooks, Stories and Worksheets using Scatter Plots, Tree Maps, Donut Chart, Bar Graph, Pie Charts, funnel, Line Charts and Motion Charts etc.• Created interactive Dashboards with Quick/Context Filters, Parameters, different Table calculations, Multiple column /Measures using DAX, Blended and Dual axis, Filter/Highlight/URL Actions, Forecast.• Formatting Worksheet and Data using Legends, Marks, Colors, Size and Alignment• Experience on Development of Dashboards for Key Performance Indicators for the top management.• Designed report for displaying top/bottom customer/product dynamically using TOPN / RANKX functions using DAX Calculations.• Have knowledge on DAX, DWH, SQL Facts and Dimension Tables.• Excellent Leadership Skills, Customer Communication, Team Coordination, problem solving skills and good decision-making capabilities.

Pune

• Creating Power Bi reports and deploying to Power BI service• Creating a drill down and drill through reports.• Have good Experience to Implement RLS as part of security.• Working on DAX functions like Date & Time, Filter & Value, Logical, and Text functions.• Understand Report Specification document and designing the reports based on Report Specification document which meets the client requirements.• Deploying the generated reports on production server.• Created Power BI reports and published the power BI reports in power bi services.Project#1:

Bachelor Of Engineering - Be

12Th, Computer Science, First Class

10Th, Science, Distinction