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.