Power Bi Sql Server

SQL/BI Developer

Saroja

Email: **********@*****.*** Contact: 832-***-****

Professional Summary:

Having 6+ Years of experience in database design, development and implementation of business intelligence solutions, I have expertise in both Azure and AWS cloud platforms.

Experience working with Azure SQL Database, AWS Redshift, SQL Server, Power BI, SQL Server integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).

Expert in creating interactive Power BI reports and dashboards using MS Power BI desktop and Power BI service. Strong experience with DAX (Data Analysis Expressions) and Power Query.

Experience in utilizing the Power BI Import, Direct Query and Live connection methods for various reports.

Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.

Experience in Data Cleansing, Data Scrubbing and Data Migration also created Indexed Views, complex Stored Procedures, to facilitate efficient data manipulation and data consistency.

Extensive Experience in creating, configuring, and Fine-tuning ETL workflows/SSIS Packages designed between Homogeneous and Heterogeneous Systems using SSIS.

Experience in query optimization & performance tuning used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.

Experience in building SSAS Tabular Models, creating calculated columns and measures using DAX. And utilizing them as data source for Power BI reports with Live Connection.

Experienced in Building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence using SQL Server Analysis Services (SSAS).

Experience in creating MDX query in SSAS cubes for various calculated members, KPI and various actions such as drill through, reporting etc.

Experience in Migrating Data from an older version to newer version of MS SQL Server 2016.

Expertise in resolving SQL Reporting services (SSRS) and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, OLAP and Sub reports in Business Intelligence Development Studio.

Hands on Experience in Data Migration from MS SQL Server to Azure SQL Database.

Strong team player with great verbal, written communication, and interpersonal skills. Technical Skills:

Databases and Azure Cloud

Tools

Microsoft SQL Server, Azure SQL Database, Azure Synapse, AWS Redshift

Programming Languages T-SQL, Python, pyspark

Tools & Packages SQL Server Management studio, Visual Studio BI Tools AWS Glue, ADF, Power BI, SSRS, SSIS, SSAS Application Packages Microsoft Office Suite, MS Outlook, Microsoft Office SharePoint Operating Systems Windows, Linux

Education: Bachelors in computer science

Professional Experience:

Client: World Travel Inc, Gilbertsville, PA Mar 2023- Present Role: SQL BI Developer/DBA

Responsibilities:

Wrote complex queries using T-SQL to create joins, sub queries, functions, and correlated sub queries to retrieve data from the database.

Created and executed SQL Server Integration Service (SSIS) packages to populate data from the various data sources, created packages for different data loading operations for many applications.

Designing, developing, and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.

Implemented ETL pipelines using AWS Glue to automate data extraction, transformation, and loading processes, improving data availability and reliability.

Extensively involved in the design and development of dashboards and reports using Power BI.

Published and shared them with business users.

Cleaned, transformed, and prepared data using Power Query Editor (M-language) and developed complex measures and columns using DAX (Data Analysis Expressions) while report creation.

Developed complex SQL Queries, stored procedures, common table expressions (CTE’s) to support Power BI and SSRS reports.

Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.

Installed and configured Enterprise Gateway and Personal Gateway in Power BI Services and used

Power BI Gateway to keep the various dashboards and reports up to date.

Used various SSIS tasks such as Conditional split, Derived column, data validation checks etc. during staging, before loading the data into various sources.

Successfully migrated SSIS packages from development to test and production environment using SSIS Configuration files and development wizard.

Involved in the creation of Tabular models using SQL Server Analysis Services (SSAS), processing them, and utilizing them as data source for Power BI reports.

Worked on various dashboards and reports using Power BI and Created Mockups and Prepared monthly Operations report.

Tools and Technologies: Power BI, T-SQL, MS SQL Server 2016/2014, SSRS, SSIS, SSAS Client: Loan Care, Virginia Beach, VA May 2021- Feb 2023 Role: SQL BI Developer

Responsibilities:

Worked with business users to gather in-depth business requirements and keep track of changes in their requirements.

Extensively involved in the design and development of dashboards and reports using Power BI. Published and shared them with business users.

Cleaned, transformed, and prepared data using Power Query Editor (M-language) and developed complex measures and columns using DAX (Data Analysis Expressions) while report creation.

Developed complex SQL Queries, stored procedures, common table expressions (CTE’s) to support Power BI and SSRS reports.

Created and executed SQL Server Integration Service (SSIS) packages to populate data from the various data sources, created packages for different data loading operations for many applications.

Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.

Installed and configured Enterprise Gateway and Personal Gateway in Power BI Services and used Power BI Gateway to keep the various dashboards and reports up to date.

Designed and implemented effective database solutions (Azure Blob storage) to store and retrieve data. Migrated data from SQL Server to Azure SQL Database.

Used various SSIS tasks such as Conditional split, Derived column, data validation checks etc. during staging, before loading the data into various sources.

Successfully migrated SSIS packages from development to test and production environment using SSIS Configuration files and development wizard.

Involved in the creation of Tabular models using SQL Server Analysis Services (SSAS), processing them, and utilizing them as data source for Power BI reports.

Worked on various financial related dashboards and reports using Power BI and Created Mockups and Prepared monthly Operations report comparing financial and operation metrics.

Designing, developing, and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.

Weekly presentation to the business users about the reports and their changes as required. Tools and Technologies: Power BI, Azure, T-SQL, MS SQL Server 2016/2014, SSRS, SSIS, SSAS Client: Simple Health, FL Dec 2018 – April 2021

Role: MSBI Developer

Responsibilities:

Wrote complex queries using T-SQL to create joins, sub queries, functions, and correlated sub queries to retrieve data from the database.

Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.

Created type 1 and type 2 slowly changing dimensions.

Created mapping tables to find out the missing attributes for the ETL process.

Created VB.Net, C# Script for Data Flow and Error Handling using Script component in SSIS.

Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.

Involved in writing Query for generating drill down reports, identified and worked with the parameters to generate parameterized reports along with extensively used global variables, expressions and functions.

Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.

Used SQL Server Profiler to trace the slow running queries and the server activity. Automated and enhanced daily administrative tasks including database backup and recovery.

Created various jobs using SQL Server Agent.

Used Multiple Measures like Individual Axes, Blended Axes, and Dual Axes. Migrated reports from SSRS to Power BI.

Created multiple reports Power BI in Drill mode using tables, financial tables, crosses tabs and chart.

Create reports in Power BI preview portal utilizing the SSAS Tabular.

Transformed and combined the data using Query Editor in the Power BI Tools and Technologies: Power BI, MS SQL Server 2014/2016, SSRS, T-SQL, SSIS, SSAS

Contact this candidate