Dhruv (RID : 474kwbrsbmh)

designation   Power BI Developer

location   Location : Bangalore

experience   Experience : 5 Year

rate   Rate: $12 / Hourly

Availability   Availability : Immediate

Work From   Work From : Offsite

designation   Category : Information Technology & Services

Last Active: 30+ Days ago
Shortlisted : 0
Total Views : 58
Key Skills
SQL Java Linux
Discription

4+ years | Dhruv Singh | Power BI Developer

Technical Skills:

Languages:

 Sql & Java

IDE:

Microsoft Power Bi

Database

SQL Server

Cloud Sources

SharePoint And Web Connections

Others (Basics)

Hadoop, Hive, Pig, HDFS, MS-Excel, Data Warehousing Concepts

Operating Systems:

Windows & Linux


Project Experience

Project 1

Kavi Poultry Groups Bi       

Description:

The Project was on the Poultry company Kavi groups one of the leading Poultry in south India, the purpose of the project was to collect data from different sources and create report as the requirement of the client and to create dashboard for the separate wing of the poultry like the Hatchery, Breeder, Broiler and Feed Mill. The dashboard created were-                                                         

●       Kavi Performance P&L Dashboard                                                                                                 

●       Breeder Performance Technical analysis      

●       Broiler Performance Technical analysis      

●       Hatchery Performance Technical analysis      

●       Flock Analysis

●       Kavi Feed Mill Dashboard

The dashboard had a lot of data flowing with no column name all the data had to be assorted along filtering of columns according to the requirement and performing calculations to have aggregated columns along with extracting dates from the name of the source data normally as excel files. Changing of data types and creation and deletion of column as per business requirements. Along with using Custom Visuals for date Hierarchy at visual level and also using complex DAX to achieve the solution for the clients.

Had also Performed Performance Tuning for the Dashboard along with change of path from remote server to SharePoint folder.

 

Responsibilities :

Evaluate business requirements & perform impact analysis Design and develop Power BI dashboards as per the business requirement.

Preparing system and unit test plan to ensure all the business logic and implemented correctly.

Perform Root cause analysis for defects and fix as per the business rules.

Involved extensively in Requirement elicitation and analysis.

 

Team Size

5

Project Duration

2 Years

 

 

Project 2

Good pack Pvt Ltd                          

Description:

The Project is about a logistic company Good pack, Good pack is a global logistics provider servicing industry that require safe, protective, cost efficient packaging and supply chain solutions. I created a Inventory Dashboard for the company having reports like-

●       Discrepancy report

●       Ownership and Under ship Quantity 

●       Global depot Inventory.

Responsibilities :

The dashboard had to be made as per the requirements of the client had various complicated DAX and also dealt with Report level Page level and visual level filters along with Dynamic Columns. Involved use of buttons and also a Content page which could be used to reach to any report just by clicking on the button, also the reports had buttons to reach the home page or any desired page possible. The reports also used forecasting Techniques to know about the trends and the coming demand of the logistic company in coming future. The report was made keeping in mind that there is no need for performance tuning in future and the data model was apt and the DAX used were not creating any performance issue, Performance Analyzer was used to show the client the speed of the report and there were no unnecessary lags and the dashboard is as light as possible.   

 

Team Size

6

Project Duration

1.6 Year

 

 

 

 

Project 3

Lead to Market Analysis     

Description:

Data surveying project was focused on the problems faced by their client because of Covid-19. So a complete, crisp and descriptive visualization was needed to Analyze the problems, effects, and to prevent all the issues their customers were facing. 

Responsibilities :

●       Prepared data sets, statistical reports and computer applications to support financial analysis work.

●       Developed and presented data to other members of the organization as part of Requirement gathering for the Product.

●       Developed Power BI model. 

●       Designed and documented the entire Architecture of Power Bi POC.

●       Expertise in writing complex DAX functions in Power BI. 

●       Used various sources to pull data into Power BI such as SQL Server, Share point and Hadoop.

Team Size

 4

Project Duration

1 Year

 


 

 
Matching Resources
My Project History & Feedbacks
Copyright : 2022 – OnBenchMark All Right Reserved.
Loading…

stuff goes in here!