PROFESSIONAL SUMMARY:

• 6+ years of progressive experience in Business Analysis, Reporting and Dash - boarding for enterprise wide applications using Power BI and Tableau.
• Experience in full dashboard development lifecycle from gathering requirements and designing solutions, through developing code / reports, to testing and release / deployment.
• Experience in loading data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
• Familiar with Power BI Dataflows, Power Apps, Data modeling, Power automate, Row Level Security.
• Experience in developing various SSIS packages to extract data from different heterogeneous sources like flat files, Oracle, SAP, SQL Server etc.
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members in SQL Server Analysis Services (SSAS).
• K nowledge on Azure Data Explorer and Kusto Query Language (KQL)
• Strong analytical and problem-solving skills and good knowledge of Data Warehouse and BI Infrastructure.
• Strong Knowledge in dimensional Star Schema and Snowflakes Schema .
• Strong working knowledge of Microsoft Office Excel

TECHNICAL PROFILE:

Operating System: Win 07 & 10, Windows 2003 server

Environment: Power BI, Tableau 7,8.1,9.3,2019.4

Databases: SQL Server, Azure Data Factory (ADF), Azure Data Explorer (ADE)

Tool: Tableau, Power BI, Excel

ETL Tool: SQL Server Integration service (SSIS)

PROFESSIONAL EXPERIENCE:

Confidential

Data Analyst

Responsibilities:

• Understand the business requirements and develop data models accordingly by taking care of the resources.
• Created DAX Queries to generate computed columns in Power BI.
• Created Row level security with power BI and integration with power BI service portal.
• Work with Azure Data explorer and use Kusto Query Language (KQL) for querying
• Created reports using dynamic column selection, conditional formatting, sorting, and grouping
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send mail task etc.
• Worked on all types of transformations that are available in Power BI Query editor.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps, Power Apps
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Used Dataflows, Power Automate features to work efficiently for further dashboards
• Involved in creating new stored procedures and optimizing existing queries and stored procedures.

Confidential

Power BI Developer

Responsibilities:

• Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.
• Designed and worked on extraction, Transformation and Loading (ETL) process by pulling up large volume of data from various data sources using SSIS.
• Created Dax Queries to generate computed columns in Power BI.
• Creating Row level security with power BI and integration with power BI service portal.
• Developed Quote Win Ratio, profit analysis, sales/service backlog reports and dashboards by products and customers.
• Evaluation/design/development/deployment of additional technologies and automation for managed services on Azure
• Designed SSIS packages to transfer the data from flat files, Access database and excel documents to the Staging Area in SQL Server 2012.
• Written stored procedures and used them in packages.
• Created reports using time intelligence calculations and functions.

Confidential, TX

Power BI Developer

Tools: Used: SQL Server, Power BI

Responsibilities:

• Used the Power BI interface to effectively create powerful visualizations.
• Generated computed tables in Power BI by using DAX.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and Cubes in Analysis Services (SSAS).
• Developed reports and Dashboards from multiple data sources using Data blending.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Representing data using the Cross Tabs, Scatter Plots, Geographic Maps, Pie Charts, Bar Charts and Tree Maps.
• Combine the visualizations into Interactive Dashboards and publish them to the web

Confidential

Tableau Developer

Responsibilities:

• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Analyzing the requirement by working closely with onsite Business Analyst.
• Created different dashboards like Executive summary, conversion status, days outstanding, ACG call details, Sales Performance for the CS to PS Conversion.
• Involved in Creating BRD, LLD and HLD for the VOD-DAI and Netflix Project.
• Effectively used data blending feature for different sources.
• Used LOD Expressions to place the reference lines in required place
• Wrote and executed complex T-SQL queries using SQL Management Studio for back end data validation testing.

Confidential

Tableau Developer

Tools: Tableau 8.1

Responsibilities:

• Created different chart objects like Bar Chart, Line Chart, Text Tables, Tree Maps and Scatter Plot.
• Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema design (Star Schema) and maintenance.
• Developed and maintained various cubes using MDX complex queries in SSAS.
• Used Sets, Bins, Parameters, Aggregate Functions, Filters.
• Use Tableau Desktop to analyze and obtain insights into large data sets.
• Preparing Dashboards using calculations, parameters in Tableau.