Prudhvi

Professional Experience:

 Having Around 4+ Years of Professional IT Experience with Business Intelligence tools like Power BI (Power BI Desktop and Power BI Service, SSIS, SSMS, Power Automate), Share Point.

 Experience in connecting with multiple data sources like SQL Server, and Excel from Power BI to build complex Datasets.

 Extensively worked on performing the ETL Activities in Power Query.

 Good Experience in Filtering the Unwanted Data in Power Query.

 Extensively used transformations like Merge Queries, Append Queries, Pivoting the Column, UN Pivoting Columns, Adding Custom Columns, Splitting the Columns, Merging the Columns etc.

 Extensive Experience in doing Data Modelling in Power Pivot Model.

 Good Experience in Creating Star & Snow Flake Schemas in Power pivot Model.

 Extensively worked on Enhancing the Data Model by Creating New Columns, New Measure and New Tables using DAX Expressions.  Extensively used different Categories of DAX functions like Time Intelligence Function, Filter Functions, Date Functions, Logical Functions, Text Functions, Number and Statistical Functions for Creating New Information.

 Extensively worked in Power View for Presenting the Data in Graphical Format using Different Visualizations in Power BI.

 Hands on Experience with Visual level, Page level, Report level and Drill Through filters for filtering the data in a Report.

 Good Experience in Creating Hierarchies and Drilldown Reports.

 Good Experience in sorting the Data in Visualizations, Grouping and Binning the Data in Power BI.

 Extensive Experience in Creating APP Workspaces and adding the Members to Workspace to Manage the Content in Power BI Service.

 Experience in publishing the Reports to Power BI Service and setting up the Necessary connections.

 Extensive Experience in Creating the Dashboards using Multiple Reports.

 Worked on On-Premise Data Gateway to Refresh and Schedule Refresh the Data in the Dataset.

 Implemented ROW LEVEL SECURITY (RLS) as part ofsecurity in Power BI.

 Experience in sharing the Reports and Dashboards with End Users.

 Worked on SSIS package, import/Export for transferring the Data from Database (Excel, Oracle And text format Data) to SQL Server.

 Worked on the Testing the Reports & Dashboards and prepared the test cases. And uploading on to Microsoft SharePoint.

 Worked on the Duplication of data set avoided by change in the existing logic and moved all the reports into Respective Workspaces.

 Worked on the Performance Improvement in the existing PBI Reports Like unwanted/unused columns removed in the existing PBI Reports and moved all the reports into Respective Workspaces.

 Worked on the Database Migration process and changed the server Names & Database Names into Existing PBI Reports. And Testing the Data & Functionality of the Reports.

 Worked on the Power Automation, Transferring the Visuals Data in Excel Sheets and Excel Sheets Placed into the Microsoft SharePoint.

 Excellent Communication, Presentation, Interpersonal, Strong Troubleshooting and Organization Skills.