Summary
Overview
Work History
Education
Skills
Projectshandled
Languages
Timeline
Generic

Dibyajyoti Parija

Summary

  • Having 4+ years of Professional experience In IT industry, working on Power BI and SQL Server.
  • Having good experience extracting the data from different data sources like SQL and Excel import into Power BI Desktop.
  • Having good experience analyzing Business Requirement Document (BRD).
  • Having good experience extract the data source Direct and Import mode.
  • Having good experience in Power query, Power pivot and Power view for creating the Effective reports in Power BI.
  • Good experience on Power query level Merge and Append Query operations.
  • Having good experience on Data modeling part i.e. resolving the many to many relationships.
  • Good Experience in creating a visuals like Stacked bar chart, Clustered bar chart, Pie chart, Donut chart, Card, Multi card, Table and Matrix.
  • Good experience on creating Bookmark, Buttons and Selection pane.
  • Experience in creating dashboards using Power BI visualization
  • Creating content packs and creating roles to implement Row Level Security (RLS) for the reports.
  • Expertise in Power BI Filters, Interactions, KPI, Bookmarks, Parameters, Groups, hierarchies, Conditional Formatting, Custom Visuals.
  • Used DAX expressions like Filter, Aggregate, and Time Intelligence & Date Functions to create business calculations based on requirements.
  • Experience in transforming the data using Power Query like Replace Values, Split Columns, Merge Columns, Pivot, Unpivot, Append Quarries, Merge Quarries and Conditional Columns.
  • Worked on visual interactions using edit interactions to make few visual to effect data based on requirement.
  • Formed various measures and calculated columns utilizing DAX in Power BI to answer business questions.
  • Performed time series analysis using DAX expressions in Power BI.
  • Deployed the Power BI reports to Power BI services and pinned visuals to make dashboards out of it.
  • Having good Experience on creating dashboards and sharing with Users.
  • Hands on Experience on gathering and translating End User requirements into Reports & Dashboards. Including Analysis, Design, Development of Reports and Dashboards.
  • Having good skills in trouble shooting On-Premises Gateway to refresh the dashboards and reports.
  • Good Experience in publishing Reports to Power BI Services and setting up the necessary connection details and Scheduling.
  • Good experience on DDL, DML, DQL Commands in SQL Server.
  • Experience on writing complex queries using Joins and Sub Queries to retrieve data from database.

Overview

5
5
years of professional experience

Work History

Power BI Developer

BAXAAR36 ONLINE SERVICES PVT.LTD.
04.2020 - 02.2024

Tester Intern

MILESTONE SOFTTECH PVT.LTD
08.2019 - 03.2020

Education

Skills

  • Power BI desktop

  • SQL, DAX

  • MS SQL Server

  • Power BI

Projectshandled

  • Client Quality Dashboard, Power BI Developer (Team Member), Microsoft Power BI, I was working as a power bi developer so I got lot of opportunity end to end like requirement and gathering data. Our client did not give actual data they gave me the requirement Based on requirement. We are go to the data base we need to check which table are Use we need to pull out right table this is very big challenging. So, once we bring the data in to the schema in my project, I used Star schema it is easier compare to another schema. After created schema brought the data lots of transformation There as text transformation, column transformation then we Merge or append table as well. In visualization part I now which data required which type of Chart starting with column chart donut chart table slicer. After this service level in premium axis through publish the Report. I was able to rls, schedule refresh in all phase.
  • Customer Analytics, Power BI Developer (Team Member), Power BI, Customer analysis reveals regional customers' product sales and earnings. Analytical users can use it to analyze regional business expansion across the geographies to divide profits among clients and get insightful information. Upon employing the correct visuals and data structures, they can receive a lot of information.

Languages

English
Advanced (C1)
Hindi
Upper intermediate (B2)

Timeline

Power BI Developer

BAXAAR36 ONLINE SERVICES PVT.LTD.
04.2020 - 02.2024

Tester Intern

MILESTONE SOFTTECH PVT.LTD
08.2019 - 03.2020

Similar Profiles

CREATE PROFILE
Dibyajyoti Parija