About Me
A highly motivated Business Intelligence (BI) Professional with 4 .8 years of relevant experience in PowerBI out of total 4+ yrs experience in IT industry. Extensive experience in the design, development, implementation,…
A highly motivated Business Intelligence (BI) Professional with 4 .8 years of relevant experience in PowerBI out of total 4+ yrs experience in IT industry. Extensive experience in the design, development, implementation, testing, and maintenance of PowerBI solutions. Comprehensive knowledge and exposure to different phases of Software Development Life Cycle (SDLC). Expert in writing DAX, SQL, and M queries. Strong command over all visual types, data modelling, ETL using Power Query Editor, measures calculated columns. Proficient with other Microsoft Business Intelligence (BI) platforms including SQL Server Analysis Services (SSAS). Vast experience in the development of Power BI reports and dashboards using Power BI Desktop. Publish the reports and dashboards to the Power BI cloud service for end user consumption. Expert in creating performance tuning methods on calculated measures/columns using DAX studio & Capable of tuning queries for optimized performance. Experienced in configuring and maintaining Power BI service (app.powerbi.com) for content sharing managing the Premium Capacity of Power BI. Expert in installing and maintaining On-premises gateway to provide secure data transfer between on-premises data and the cloud service. Proficient in carrying out administrator activities such as creating and managing security groups, assigning user permissions, monitoring usage metrics for dashboards, and auditing logs using 0365 Security & Compliance Center. Created Data extracts for better performance and accessing data offline. Implemented role-based security as part of user level security in Power BI. Experienced in creating Tables, Views, Stored Procedures, Triggers, Functions, and Indexes with extensive use of SQL. Strong Command over Dimensional Modeling and Designing of STAR, SNOWFLAKE Schemas. Proficient in the design, development, and implementation of Tabular Data Models in SSAS. Passionate towards learning and suggesting best practices in the area of Business Intelligence.. Basic Experience of Tableau Regarding data visualization, analysis, and dashboard creation etc. Very good communicator, listener, and team player.
Experience
Software Developer
My roles and responsibilities is data validation testing to prepare test case document and involved in role level security as user also see their data. I have created complex reports and implemented parent child hierarchy security also. I have also involved in l1 l2 and administration supporting activities in my current project.
Software Engineer
Worked as a Software Engineer in Inosoft Datalinks Pvt Ltd from December 2019 to till date.
Power BI Developer
Create and develop Power BI visuals and data models as required.
Building Power BI dashboards and doing ad hoc reporting.
Experience in developing Visualization reports using Power BI as per client requirement.
Visualize data, author reports Publish and schedule automated refresh of reports.
Using DAX for Power BI Reports.
Designed the Reports with Conditional formatting.
Created calculated columns to simplify the data.
Prepared Weekly Status Reports and shared with the Onsite Managers.
Created Named Calculations and Named Queries in the Data Source view based on business requirement
Created Dimensions, Measure Groups with Custom formats.
Good experience on Sorting Attribute by another attribute based on requirement
Created Named Sets using MDX Expressions
Created Calculated Measures and maintaining using folders in the Cube
Added new dimension, new partition or new business logic to existing SSAS Cube
Created MDX Queries to pull data for SSRS reports
Created Parameterized, Cascading and Drill Through Reports and Drill Down and Sub Reports .
Cognos BI migration to Power BI Developer
Develop and maintain Tables, Views, and Queries in SQL server as data sources for Power BI reports.
Created Dashboard Reports to display multiple reports in single page.
Transform and model data to create interactive visualizations that provide insights into the organization' Confidential data with Power BI Desktop.
Create and optimize advanced queries, data models and report designs to standardize dashboards throughout the organization.
Configure and maintain Power BI service (app.powerbi.com) to share content with business users.
Publish the reports into Power BI service by creating and managing app workspaces and apps.
Configure and manage Premium Capacity in the Power BI service to share apps to the business users.
Install and maintain On-premises gateway to provide secure data transfer between on-premises data and the Power BI service.
Assist and Train other developers in accessing the enterprise gateways.
Implement an efficient refresh process using REST API instead of the traditional Scheduled Refresh process.
Upgrade legacy workspaces to new workspaces for better management of content access.
Create more centralized datasets in order to reuse the existing datasets in the service thereby avoiding the refresh of duplicated datasets.
Carry out various Power BI service administrator activities such as configuring governance policies, creating and managing security groups, monitoring usage metrics for dashboards/reports, auditing Power BI logs using 0365 Security & Compliance Center, and provisioning of licenses, capacities, and organizational resources.
Participate in different levels of Testing (Unit testing, QA testing and UAT testing) to deliver quality data in the Dashboards.
Responsible for defining the scope of the project, gathering business requirements, doing analysis and documents.
Importing the data from data sources and preparing the data as per user requirement.
Building the relationships between the various data sets in power pivot.
Created new columns, new measures and conditional columns using DAX functions.
Created different filters like visual level filters and page level filters and report level filters as per reporting needs.
Expertise in various visualizations like donut chart, Pie chart and Bar graph, Tree map and water fall charts and Card Visualizations.
Designed diverse types of reports like drill down, drill through, And Sync Slicer.
Created various Customized and interactive Reports and Dashboards in Power BI.
Publishing reports to Power BI server and providing the access to required users.
Installing and configuring Data Gateway to pull data from on-premises databases
Having experience in Power Query to transform the data within Power BI.
Created Bookmarks to move from one page to other page based on requirement like moving forward and backward navigation.