SUMMARY

• Highly motivated Confidential BI developer with 7 years of IT experience and Business Intelligence Technologies experience and expertise in SQL Server Development.
• Developed the Data model with snowflake schema and star schema.
• Strong technical knowledge in MS SQL Server development and experience MicrosoftBI Tools.
• Solid knowledge of Power BI Desktop & Power BI service.
• Hands on experience in Extraction, Transformation and Loading ETL processes to acquire and load data from internal and external sources using SSIS, Import Export, BCP and Bulk Insert.
• Extensively used Joins and Sub - Queries to simplify complex queries involving multiple tables and established relationships between tables using Foreign Key and Primary Key constraints.
• Experienced in transforming complex business logic into Database design and maintaining it by using SQL tools such as Stored Procedures, User Defined Functions, Views, Data Modeling and DTS.
• Expert in database creation, maintenance, monitoring, backups and recoveries using SQL Server Agent, Import/Export Wizard and Maintenance Plans.
• Responsible for building Power BI Dashboards using Tabular Models. Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
• Worked on Azure Data Factory for loading Azure SQL database.
• Strong experience in Azure Analysis service Tabular cube.
• Worked on data modeling (by using both snowflake schema and Star schema ).
• Experienced in Azure SQL and creating external tables for cross referencing across different Azure Database.
• Experienced in extracting data from different sources and loading to Azure SQL Database through ADF.
• Worked on refreshing data across database of Azure SQL by calling Stored procedures through ADF.
• Strong experience in writing different complex Azure SQL queries for querying data.
• Worked on Preparing Power App templates for different user requirements. And created different Power Apps which enable users to perform different actions.
• Good work experience in setting up Confidential Azure Logic Apps.
• Extract dataset from different data source including SQL Server, excel and flat file prepare datasets forPower BI
• Strong experience in Extraction, Transformation and Loading (ETL) using SQL Server integration Services (SSIS) on SQL Server, File System, Oracle Databases.
• Experienced in integrating Power App and Power BI.
• Experienced in pulling data from Azure Data Lake to Azure SQL DB by using Azure Data Bricks.
• Experienced in project management with my most recent project.
• Experienced in taking requirements from the Client organize that and sharing with the team and divining for the team members accordingly on daily bases.

PROFESSIONAL EXPERIENCE

BI Lead Engineer

Confidential, Redmond, WA

Responsibilities:

• Extract data from different sources and transfer it Azure SQL database by using Azure Data Factory.
• Developed the Data model ( by using Snow flex Schema ) based on business requirement.
• Setup Azure Data Factory pipeline for loading Data from different sources and load it to the Azure SQL database
• Develop Azure Analysis Service Tabular cube.
• Write different complex TSQL queries for creating data feeds, validation and data extraction.
• Setup Azure Logic App for Schedule refresh of Azure SQL database stored procedures and Azure analysis service tabular cube, Python.
• Worked in writing different Dax and SQL formulas for querying both the Tabular cube and Azure SQL database.
• Prepared different Power App templates for different user requirements. And created different Power Apps which has different control Features.
• Write complex TSQL statements and stored procedures for querying the backend database.
• Write TSQL statements for data validation and extraction.
• Load data from different sources to SQL sever database by using SSIS.
• Develop Power BI reporting from SQL server database.
• Worked on developing complex Power BI dashboard which can support different business.
• Write complex DAX queries for creating different power BI measures and to implement Row-Level Security.
• Developed Power BI report which contains different Bookmarks, filters, slicers, pages, visualizations and publishing.
• Experienced in Power BI performance improvement by using different methods.

Environment: MS Azure SQL, MS Azure Analysis service, ADF(Azure Data Factory), MS Logic App, MS Power Apps, MS-SQL Server 2019, MS SQL Server Data Tools 2019(SSDT), Power BI, MS office 2017, MS Excel, and Visual Studio 2019

BI Developer

Confidential, Seattle, WA

Responsibilities:

• Extracted data from heterogeneous sources and transferred to OLAP using SQL Server Integration Services (SSIS). worked in writing DAX queries against SSAS Cubes/Tabular Models/ Power BI data models for analysis.
• Designed and developed backend SQL Database objects such as Tables, stored procedures, Functions, Triggers, Views, index & roles.
• Created SSIS package to extract data from heterogeneous sources.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Used DAX to create calculated column and Measure to enrich the data model and to compute business formula.
• Involved in the design and development of the SSAS cubes.
• Worked in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server using SSIS.
• Created multiple data visualization solution for initial Power BIenvironment business preview.

Environment: MS-SQL Server 2017, MS SQL Server Data Tools 2017(SSDT), Power BI, XML, MS office 2016, MS Excel, and Visual Studio 2017

Power BI Developer

Confidential, Seattle WA

Responsibilities:

• Extract Transform Load (ETL) development using SQL Server 2008 Integration Services (SSIS).
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Created complex Stored Procedures, Triggers, Cursors, Tables, Indexes, Analytics, Views and SQL Joins and other statements for various applications, maintained referential integrity and implemented complex business logic.
• Create reports in Power BI utilizing the SSAS Tabular Model
• Design and write elastic queries to access data across database
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Designed and implemented SSAS Tabular Cube and Used DAX scripting to access data from Tabular Model.

Environment: MS SQL Server 2016, SSIS 2014 R2/2014, SSRS 2008R2/2014, T-SQL Windows Sever 2014, SQL Server Management Studio,SQL Profiler

SQL BI Developer

Confidential, Seattle WA

Responsibilities:

• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Designed, developed, modified and enhanced the database structures and database objects.
• Developed logical and physical data models, designed data access strategies and write SQL code to access and manipulate data stored in databases.
• Created ETL packages to validate, extract, transform and load data to databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Performance monitored and tuned TSQL queries

Environment: T-SQL Windows Sever 2014, SQL Server Management Studio,SQL Profiler.