Prabhakar Chinta

Around 8 years of total experience in IT with last 4 years of experience in Power BI and SQL and T-SQL.

Having 4 Years’ Experience in Data warehouse, SQL Server Integration Services (SSIS) and Hands of experience in Power BI Service.

Exposure in creating different types of reports such as Cross-Tab, Drill-down and Sub reports, Parameterized and cascading reports Written stored procedures in SQL Server in order to generate reports. Developed Power BI model used for retail reporting Implemented dynamic calculations using the DAX functions like calculate, filter, min, max, sum, count, MTD, QTD, YTD, and Cumulative Total etc. Expertise in writing complex DAX functions in Power BI and Power Pivot.

Developed different types of reports like line chart, bar charts, Pie chart, Table, Drill through, calendar type reports, donut reports, drill down reports, matrix reports etc. Created Workspace for business users to view the developed reports. Having experience on scheduling the reports for dynamic refresh.

Created New Calculated column and Measures using DAX Expressions Worked on many Transformations such as Lookup, Conditional Split, Merge, Multicast, Derived Column, OLEDB Command and Row Count Etc.

Excellent knowledge of using variables and expressions in SSIS packages Good knowledge on Data Transformations. Hands on experience in writing and implementation of the Stored Procedures, Functions, Views, Joins, Sub - Queries, CTE’S, indexes, Triggers using SQL & T-SQL Good understanding of Data Modelling - Dimensions and Fact Tables and its relationships.

Worked on the project with combination of SQL Server and MSBI (SSIS) and Power BI Good understanding of Data Warehousing Concepts includes Dimension, Fact Tables, Schemas and its relationships.

Hands of experience in Extract Transform Load (ETL) development using SQL Server, Integration Services (SSIS).

Excellent knowledge on Full Loading and Incremental Loading with SSIS Experience in Developing ETL Packages using SSIS. Ability to learn and adapt to new tools.