Deevaker G.

Power BI and MSBI Consultant

Delhi , India

Experience: 8 Years

Deevaker

Delhi , India

Power BI and MSBI Consultant

36000 USD / Year

Immediate: Available

8 Years

Now you can Instantly Chat with Deevaker!

Chat Now

About Me

Over 8+ years of IT experience as a MSBI Developer 2008/2012/2016 in various Industry verticals like Finance, Medical and Retail.
Advance Data Modeling using DAX, Power Query/Edit Query in Power BI Desktop and working with Custom ...
Applying dynamic Security on Power BI Dashboards as per user logged in user to PowerBI.com
Power BI Embedded with Azure
Power BI Dashboard from various data sources like Survey data, google analytics data, Dynamic CRM, SharePoint, on premises SQL Server Database, Excel, DAT, CSV data configuring/using Power BI Enterprise Gateway for live dashboards
Power BI tools – Power BI Desktop, Power Pivot, Power Query, Power View, Power Map, Power BI Dashboard, calculated columns and calculated measures using DAX, data modeling
Power BI: Consultant.
Experienced in Database Modeling and Database Architecture based on functional requirements and system design of the client using RDBMS concepts and constructs
Extensive experience in MS SQL Server 2008/2012/2016, Business Intelligence in MS SQL Server Integration Services(SSIS), MS SQL Server Reporting Services(SSRS), and MS SQL Server Analysis Services(SSAS)(Tabular).
Expert in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from different data sources like notepad, DAT files and Excel.
Hands on experience in developing & deploying cubes using SQL Server Analysis Services involving Tabular data.
Experienced in designing and developing large amounts of enterprise reports (Power BI) using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Data Cleansing, Relational Database models and Data integrity, and SQL joins

Skills

Positions

Data Analysts

Data Scientist

Business Analysts

Data Engineer

Portfolio Projects

Creating Power BI Dashboard and reports for Internally Quality

Contribute

Develop database design and build complex queries, stored procedure and create power bi reports.

Description

The scope of project is to create a automated power bi report which shows insights of employee internal performance.

- We built a SSIS package which reads data from different excel sources and loads into the table

- Stored procedures to generate scorecard.

- Power bi report to show team wise/ employee wise report card

Show More Show Less

Contribute

My role was to handle the complete project with the help of a designer. Here I was responsible for creating layout, connecting database, writing queries, deploying project.

Description

Creating reports using Excel/Power view/power pivot/charts etc.

Show More Show Less

Quality Analysis & Testing application.

Contribute

Handling both front end & back end issue related to SQL etc. Quality Analysis & Testing application. Provide technical support for usability issues and critical problems, as needed.

Description

Developing web applications using C#, SQL Server, SSIS and reporting using Microsoft excel; Writing Business Logic and Stored Procedure.

Show More Show Less

Design, create, implement, modify, maintain and support existing reports.

Contribute

Gather requirements, understand the specific business needs and solution design.

Description

Gather requirements, understand the specific business needs and solution design
Independently analyse, solve, and correct issues in real time, providing problem resolution end-to-end.
Assist developers with complex query tuning and schema refinement.
Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
Refine and automate regular processes and track issues.
Based on historical data, to forecast the outcome of implementing certain business strategies.
Analyze the business data to categorize facts and provide a true picture to performance.
Responsibilities were with client interactions to understand requirements, preparation of requirement traceability matrix, Dashboards.
Design, create, implement, modify, maintain and support existing reports.
Schedule and deliver reports based on the specified timetable (daily, weekly, monthly) in a data warehouse environment.

Show More Show Less

Description

Technically assisting the team of 15 in their day today challenges.
Developing Power BI Dashboard and MSBI (SSIS, SSAS, SSRS) packages and reports.
Experience in Financial and Sales data analysis
Building complex T-SQL Queries, Stored procedures, optimization.
Advance Data Modelling using DAX, Power Query/Edit Query in Power BI Desktop and working with Custom Visuals.
Applying dynamic Security on Power BI Dashboards as per user logged in user to PowerBI.com
Power BI Embedded with Azure
Power BI Dashboard from various data sources like Survey data, google analytics data, Dynamic CRM, SharePoint, on premises SQL Server Database, Excel dat, CSV data
configuring/using Power BI Enterprise Gateway for live dashboards