SUMMARY

• Data modeling and mining, Reports and data visualization, ETL, DAX
• Querying databases using SQL programming language.
• In - depth knowledge in various RDBMS concepts like database, schemas, tables, data type constraints, views, indexes, stored procedures, variables, user defined functions, triggers, CTE (Common Table Expression) etc.
• Hands on expertise with Microsoft Azure platform (Azure Data Factory/Storage Account)
• Experience with backup, restore, recovery and high availability strategies for on -premise and Microsoft Azure environments.

PROFESSIONAL EXPERIENCE

Confidential

POWER BI DEVELOPER

Responsibilities:

• Prepare, test, deliver, maintain and troubleshoot reports, analytics and interactive intelligence in systems across the client s organization.
• Designed data visualizations and determine the best way to present data to end users using drilldowns, tables, matrix, list, parameters, sub reports, gauges, graphs, charts and other intuitive graphical add - ons.
• Design and deploy reports and data visualizations using SSRS and Power BI.
• Developed multiple dashboards, analytical reports, KPIs and interactive reports based on business requirements using SSRS to support executive business needs.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps
• Explored data in a variety of ways and across multiple visualizations using Power BI
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Published reports and dashboards using Power BI
• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie chart, bar graphs and density charts.
• Generated various weekly, monthly, and quarterly sales reports for different business needs using SSAS and Power BI.
• Prepare, test, deliver, maintain, and troubleshoot reports, analytics, and interactive intelligence in systems across the client s organization
• Hands on expertise with Microsoft Azure platform (Azure Data Factory/Storage Account)
• Experience with backup, restore, recovery and high availability strategies for on -premise and Microsoft Azure environments.
• Writing T-SQL Queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views. Execution Plan, SQL Profiler, and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases. I am v proficient in using temporary DB structures like temporary tables, table variables, and Common Table Expressions (CTE).
• BI & Reporting (Power BI expert, SSAS, SSRS, PowerPivot and SharePoint):
• Migrated and recreated existing dimensions and cubes using star schema on SQL Server 2008 to achieve the efficiency of SQL Server Analysis (SSAS).
• Generated parameterized, cascading, linked reports, sub-reports, drill down reports, drill through reports and graphical reports with stored procedures in MS SQL environment as well as dashboards using SSRS 2012 and 2016 and visual studio 2010 to 2017.
• Implement Azure data services including Azure data lake, Azure data factory and Azure analysis services and Azure data warehouse.
• Experience in Migration of Existing apps and services to Azure.
• Experience in designing and development of pipelines in Azure data factory to fetch the data from upstream.
• Data migration from on-premise to cloud (Blob storage, Azure synapse analytics, data lake) using ADF.

ENVIRONMENT: MS SQL Server2012, Power BI, SSRS, SSIS, SSAS and Excel, Azure, Azure Devops.