Venkatesh

Venkatesh

BI Developer
India

نبذة عني

Having 5+ years of IT industry experience in Business Intelligence Tool on Power BI, SQL Server DAX, SSAS

الخبرة

Bi Developer

Zensar
May 2021 - حتى الآن · 5 سنوات 2 أشهر

 Worked in Power Bi Desktop and Power Bi Service
 Having good experience in Microsoft Power BI Reporting Tool
 Having good experience in DAX query Language
 Having good experience on SQL Server Concepts Procedures and Functions
 Good experience with SQL Server 2008/2014
 Experience in working with SSAS tabular cubes
 Involved in designing cubes in SSAS using Snowflake and Star Schemas
 Created Rich visualized Pie & Line Charts, Tree Map, Tabular and Matrix Reports Using Power BI
 Created, maintained & scheduled various reports in Power BI Desktop
 Published Power BI reports from Power BI desktop to Power BI service
 Extensive Knowledge in SSAS partitions, Roles and KPIs.

BI Developer

Cisco Systems, Inc

Create a Tabular SSAS Cubes which required for a Power bi Reports.
Created Cascading Reports, Drill down and Drill through Reports by Using Power BI.
Extensively worked on Power BI Personal Gateways and Enterprise Gateways.
Created rich visualized Dashboards in Power BI.
Create and manage the Power bi reports and Dashboards which are required for business analysis and to make new events.
Extensively involved on the SSAS storage, partitions and aggregations.
Created, maintained & scheduled various reports in Power BI Desktop.
Published Power BI reports from Power BI desktop to Power BI service.
Creating Actions, KPI’s etc.
Analyze the given requirement and convert into working reports and dashboards.
Train business users on how to use the report for pulling out data for their respective market/cluster and how-to pull-out pain areas to do easy validation.
Good Experience configuring gateways and scheduled Power BI Reports.
Implemented different types of filters in Power BI.
Expert in cleansing data from files by using Transformations, Calculated fields, Power Query’s and DAX Functions.
Having good experience in transform the data using Power BI Desktop
Created Database Objects like tables, Views, joins, functions, as per the Business requirements.
Code validation as per client requirement.
Wrote SQL Queries using Joins, Sub Queries and correlated sub-Queries to retrieve data from the database.
Published Power BI reports from Power BI desktop to Power BI service.
Creating Actions, KPI’s etc.
Analyze the given requirement and convert into working reports and dashboards.
Good Experience configuring gateways and scheduled Power BI Reports

BI Developer

Total Media

Building, publishing customized interactive reports and dashboards, report scheduling using Power BI.
Analysis the requirement documents to develop the Reports and Dashboards.
Planning the estimates. Hence assigning the user stories to the team for development and unit testing.
Developed custom reports and deploying the PBI service to multiple clients’ organizations.
Designed Power BI data visualization utilizing Matrix tabs, maps, Trending, pie, bar and density charts.
Hands on experience of data mart scripts in SQL.
Explored data in a variety of ways and across multiple visualizations using Power BI.
Strategic expertise in design of experiments, data collection, analysis and visualization.
Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
Created Data Warehouse schema to deploy fact and dimension table and defined Referenced relationships with the measure groups and fact tables.
Write a required DAX query performance of Hierarchies and Fact Dimensions.
Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.
Extensive SQL querying on Staging, Data warehouse and Data Mart.
Explored data in a variety of ways and across multiple visualizations using Power BI.
Store all source code in the Team Foundation Server (TFS) and update development status in the TFS timely.
Created Landing pages in PBI where it will redirect to multiple reports by one click
Implemented different types of filters in Power BI.

BI Developer

Kmart

Interacted with end-users to collect requirements and acquire the necessary domain knowledge to become a subject matter expert.
Understanding source systems and customer requirements.
Worked with Dashboards style of reports using all the Power BI components.
Worked with Pages and Page Visualizations in Power Bi Desktop.
Created Dashboards style of reports using Power Bi Desktop Visualizations like Bar Chart, Line Chart, Area Chart and Slicer etc.
Created the reports using charts like Pie, Bar, Line, KPI Visuals, Custom visuals, etc.
Charts are used in making reports more user-friendly in analysis purposes.
Developed User Interactive Reports as business needs.
Published reports into Power BI publisher and schedule the data sets.
Shared dashboards to users through Office 365, Content Packs.
Developed complex SQL queries and create stored procedures to fetch data for reporting and to accomplish several computations.

المهارات

الذكاء التجاري المتكامل لغة الاستعلامات الهيكلية (SQL) لغة الاستعلامات الهيكلية نموذج البيانات مزود بيانات SQL Server من مايكروسوفت خدمات تكامل SQL Server خدمات تقارير SQL Server باور بي آي تابلو SQL Server DAX SSAS SSRS Microsoft SQL Server 2012 Microsoft SQL Server 2016 Power BI Desktop Power BI Service Power Query TFS MS SQL Stored Procedures Data Warehousing Data Mart Data Migration Data Visualization Dashboards Reports KPI Cascading Reports Drill Down Drill Through Gateways Filters Calculated Fields Joins Subqueries Correlated Subqueries Views Functions Tabular SSAS Cubes
الإبلاغ عن هذا الملف الشخصي؟