OnBenchMark Logo

Venkat (RID : 6bz5lde61t6z)

designation   Power Bi Developer

location   Location : Delhi, India

experience   Experience : 6 Year

rate   Rate: $15 / Hourly

Availability   Availability : Immediate

Work From   Work From : Any

designation   Category : Information Technology & Services

Shortlisted : 12
Total Views : 159
Key Skills
Power BI Power Center dashboards dax Table Matrix Bar Pie Card
Discription

VenkatPower BI Developer

Objective:

To achieve excellence in the Technological arena, by constantly taking up challenging

assignments and continuously upgrade skills to keep pace with the rapidly changing environment. I would like to make best use of my acquired skills with an opportunity to improve on the same and contribute to the growth of the firm in every way I can.

Professional Synopsis:

  • 6.8 Years of IT Experience in Development and Support as certified profession (MS Power BI certified profession) in Development, Data warehouse, Test and Production Environments on various business domains.
  • Create Visualizations and Report for requested projects.
  • Experience on Power BI (Desktop and Service) along with DAX.
  • Worked on Append Query and Merge Query with joins (Left, Right, inner).
  • Worked on the Power BI reports & dashboards source data from SQL database, SAP BWA, Snowflake or SharePoint or flat files etc.
  • Used Table, Matrix, Bar, Pie, Card, Gauge , Slicers visualizations
  • Worked on Custom Visualizations like multi slicer and Hierarchy slicer.
  • Worked on DAX expressions like filters, Aggregate, Mathematical or Date function etc.
  • Created New Calculated Column and Measure using DAX Expression.
  • Comfortable in working with filters/calculated columns/measures/relationships and transformations of Edit Query section.
  • Having knowledge in Power BI report server & Power Apps
  • Published/shared the reports by creating Content Pack/Sharing the Pbix file.
  • Creation and Modification Database objectives like Table, Triggers, Views, Sequences and Synonyms as required.
  • Managing the centralized On-Premises Gateway in RDP Server.
  • Understanding and collecting requirements from business user side and business analyst and try to convert that requirement to SQL.
  • Involved in requirement gathering, analysis, design, development, deployment and supports
  • Having knowledge on Snowflake Data Wearhouse

Work Experience:

    • Working in Anika Technologies as Senior Consultant for PWC Jan-22 to still date
    • Worked in HPE as BI Consultant Feb-20 to Dec 21
    • Worked in Capgemini India Ltd as BI Consultant from Feb 2017 to 2020.

Education:

    • Completed B.com Degree in computers and MBA.

Project #3

Client : PWC

Roll : MS Power BI Developer

    • Working on handling huge data from snowflake data warehouse to power bi as Import query and developing new reports and publishing report to service and handling new user access.
    • Created data model and data type and data cleaning active.
    • Worked on summarized and union tables.
    • Working on merge and append and calculated columns and measure.
    • Loading data from different data source and created data model.
    • Creating interactive visual and KPI’s and setup incremental refresh.
    • Setup weekly twice schedule refresh and implemented the organizational RLS.
    • Analyzing issues which raised by app level users and fixing that and redeploying report.
    • Working on test environment after developing dashboard and prepared test cases as proof.
    • Preparing user manuals and detailed document of dashboard and placing this into share point.
    • Installing enterprise gateway in RDP and connect multiple reports to the gateway for scheduling refreshing and giving gateway access to the multiple users.
    • Enable the power bi schedule refresh in power automate.

Technical Expertise:

Tool : MS Power BI

Database : Sql Database & Snowflake DW

Client Tools : SQL Developer and Snowflake DW

Language : SQL & Python

Project 2#

Client : Unilever

Roll : MS Power BI Consultant

Date : June - 2016 to 2020

Client Description:

Unilever is a multinational corporation selling consumer goods including foods, beverages, cleaning agents and personal care products. Unilever is a dual-listed company consisting of Unilever NV in Rotterdam and Unilever PLC in London.

Roles and Responsibilities:

    • Working on SAAS tabular module live connection and direct Query.
    • Writing measure & Calculated columns in AS tabular module.
    • Providing RLS security and giving access to users.
    • Create Relationship in the tabular module.
    • Deploying AS code data in to SSMS and process the cube to pull the data in to power bi reports.
    • Creating and designing multiple reports with different pages and based on the KPI’s selection data need to populate.
    • Designing interacting with client to take new requirement.
    • Resolving user issue on the daily basis for production data on time.
    • Worked on edit queries for merge and append the multiple tables and add new columns and transform and manage parameter and changing the data type.
    • Creating Bookmarks and conditional field value.
    • Resolving user incident while doing UAT testing and preparing unit test document.
    • Contributed in the development of knowledge documentation.
    • Designed power BI visualization Maps, KPI, bar charts and pic charts and water fall charts.
    • Worked in Incremental refresh in Power bi and Giving App level access to end users.
    • Created Page level RLS and given access at RLS level.
    • Data Loads and resolving Issues.
    • Creating pull request and deploying data through pipeline in azure data factory.
    • Preparing the test cases document as part unit testing before user doing user acceptance test.
 
Matching Resources
My Project History & Feedbacks
Copyright© Cosette Network Private Limited All Rights Reserved
Submit Query
WhatsApp Icon
Loading…

stuff goes in here!