Power Bi Sql Server

Zobiada Rukshanara

SQL BI/Power BI Developer

Email: *****************@*****.*** Phone: 469-***-**** Address: Aubrey, TX – 76227

Summary:

Over 6+ Years of extensive IT experience as a Microsoft SQL Server Developer in creating Business Intelligence Solutions like SSIS, SSAS, SSRS, MicroStrategy, Tableau and Power BI and expertise in designing and implementing Relational Database model as per business needs

Experience in publishing Power BI Desktop reports to the Power BI service. Deployed Power BI Pro for Business users to view reports on the service and local report server. Had good Experience in publishing and sharing BI objects in Power BI Workspace, designed and maintained Power BI dashboard in Power BI App. Reports to Tableau dashboards connecting to SQL server.

Expertise in QlikView, QlikSense, Microsoft SQL server, MSBI Tools (SSIS, SSRS, SSAS) and UNIX scripting.

Expertise in designing and developing QlikView and QlikSense dashboards, Reports and Analytical worksheets by extracting data from various sources like Sales Force, SQL Server, Oracle, SAP, Flat Files, Excel files, XML Files.

Expert at developing ETL interfaces using SSIS and enterprise reports using SSRS utilizing the latest versions and features.

Expert in Cerner Command Language (CCL) for creating extracts and reports.

Expert - level programming skills in analytical scripting languages such as R Programming, Python, SQL, Pyspark.

Strong development skills with Azure Data Lake, Azure Data Factory, SQL Data Warehouse Azure Blob, Azure Storage Explorer.

Experience in developing apps using PowerApps and Confidential Flow (Power Automate) and Power BI Embedded, Power BI REST API, Logic Apps and PowerShell for automation.

Hands on experience in SQL/Snow SQL of Oracle/SQL Server/Snowflake.

Proficient in the Microsoft Business Intelligence (MSBI) stack, including SQL Server 2012/2014/2016,2017/2019 SSIS, SSAS, and SSRS.

Excellent in Design of ETL SSIS Packages for integrating data using OLE DB connection from sources like (Excel, CSV, Oracle, flat file,) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Merge and Union all.

Used R & Python, SAS, Tableau, Power BI and SQL for data cleaning, data visualization, risk analysis and predictive analytics.

Experience in working Confidential Azure cloud platform in components of ADF, ADL and Azure SQL & Datawarehouse.

Strong command of T-SQL for querying and manipulating data within SQL Server databases.

Hands-on Experience in Data Migration from MS SQL Server to Oracle ERP Systems.

Highly experienced in whole cycle of DTS/SQL server integration services (SSIS, SSAS, SSRS, Power BI, QlikView) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers Business Analysis.

Worked on Insurance projects in Health Care industry, Medical Claims Experience.

Good understanding of Normalization/Denormalization, Normal Form, and database design methodology.

Knowledge of full Software Development Life Cycle, including code reviews, source control management and working knowledge of Agile.

Strong knowledge of Data Marts, Data warehouse, ODS, OLAP, OLTP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snowflake Modeling, Fact and Dimensions Tables.

Built and published interactive reports and dashboards using Tableau Desktop and Tableau Server.

Experience in Tableau Desktop, Power BI for data visualization, Reporting and Analysis; Cross tab, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.

Experience with full development cycle of a Data Warehouse, including requirements gathering, design, UAT, and Deployment.

Experience in developing Power BI Reports with KPI Metrics for senior leadership to view the Metrics values and developed BI data mapping and BI objects (dashboards, reports, analysis, visualizations, metrics, security) design documents using Power BI.

Expert in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages using SSIS, Import, Export Data, Bulk Insert, and BCP utilities.

Technical Skills:

Operating Systems: Windows Server 2016/2012/2008, UNIX.

Databases: Power BI desktop/service, BI Stack (Power pivot, Power query, Power map), Snowflake, MS SQL Server 2019/2017/2016/2014/2012, MS Access, Oracle 19c/18c/12c/11g/10g/ 9i.

Language: T-SQL, ASP.net, CCL, C, C++, Python, HTML, Java.

Power BI Tools: Power BI Desktop, Power BI Embedded, Power BI Gateway, Power Query, DAX, Power BI App, SSIS, SSRS, SSAS.

Application Packages: MS Office 2013/2007 (Word, Excel, Power Point, Access).

Data Modelling Tools: MS Office Suite, Microsoft Visio, IBM Rationale Rose, ER Modelling, Erwin, Power Pivot.

Work Experience:

SQL/BI Developer Nov/2023 – Present

PRECISIONxtract, Indianapolis, IN

Responsibilities:

Design, develop, and administer scalable data systems to assess data quality and relevance for analytics and reporting.

Lead data cleaning and integration of complex healthcare datasets, establishing a reliable foundation for analytics and client-facing applications.

Work on a Business Intelligence team to design and develop Crystal Reports and QlikView Dashboards, supporting a wide range of healthcare data needs. Contributed across the full SDLC as both Programmer/Analyst and Business Analyst.

Program ad hoc SQL queries and reports based on evolving client requirements, ensuring timely and accurate data delivery.

Created new reports and data extracts using CCL (Cerner Command Language).

Created Parameterized reports, Cross-Tab reports, Drill down reports using Qlik view.

Develop and manage advanced ETL pipelines to ingest, transform, and load large datasets across multiple systems.

Manage and optimize large-scale databases across multiple environments (SQL Server, Oracle, Snowflake, and Azure SQL Database) to handle terabytes of data while ensuring high performance and data integrity.

Migrate SQL Server databases to SQL Azure Database using SQL Azure Migration Wizard. Deployed application to Azure Cloud.

Involved in various performance tuning of slow running CCL reports.

Develop QlikView and QlikSense objects like Multi Boxes, Straight tables, Pivot tables, Containers, Line charts, Bar charts, Combo charts, Scatter charts, Line objects, Pie charts, Button.

Analyzed the existing QlikView data model and script logics for the existing QlikView applications.

Write a python-based SQL generator that helped speed up a weekly reporting from several days.

Work with EPIC and Clarity databases for everyday workflow.

Extract, Transform and Load data in the appropriate way to be ingested into Epic by multiple processes. (HL7 messaging and integration, CCDs and DMS systems also used.)

Integrate data from varied sources using SSIS – SQL Server, Azure Data Lake, Spreadsheets and Flat Files

Migrate databases/instances from SQL Server 2012 to SQL Server 2019 version.

Design and maintain relational databases using platforms like Microsoft SQL Server, Oracle, or MySQL.

Use SQL Server Management Studio (SSMS) to manage, develop, and administer SQL Server databases, ensuring optimal performance and database integrity.

Create ETL packages with different data sources (SQL Server, Oracle, Teradata, Access, Flat Files, Excel source files, XML file) and then loaded the data into destinate ion tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).

Conduct peer reviews and quality checks to maintain high data integrity and consistency in project deliverables.

Communicate system performance, storage, and security issues directly with Solution Architects to drive timely resolutions.

Document and present data processes in a clear, logical format to enable reuse and cross-team understanding.

Involve in extracting the data using SSIS from OLTP and OLAP.

Environment: MS SQL Server 2019/2017/2016/2014/2012, Microsoft Visual Studio, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Microsoft Office SharePoint Server, XML, Oracle, ASP.Net, and C#.

SQL/Power BI Developer Nov/2022 - Oct/2023

RAYUS Radiology, St. Louis Park, MN

Responsibilities

Utilized Agile methodology throughout the project, including participation in daily Scrum meetings, bi-weekly sprint planning, and backlog refinement sessions.

Developed and maintained large-scale reporting solutions using SSRS, Power BI, and Tableau, pulling data from large data sources and ensuring timely and accurate delivery of reports to stakeholders.

Wrote data queries in DAX and SQL and Expertise in writing Complex Dax functions in Power BI and Power Pivot.

Configurated and Deployed of all reports across various SDLC environments and deployed the packages to production using XML package configuration.

Created CCL Scripts to do various Data-fix operations on the backend of Cerner remove any errors caused by incorrect documentation.

Developed T-SQL, QlikView Scripts for extraction, cleansing and transforming data sets.

Used Power BI, Power Pivot to developed data analysis phototype, and used Power View and Power Map to visual.

Experience in getting data from different data sources like SharePoint, Excel, CSV, APIs etc., and transforming raw data as per requirement.

Created CCL Scripts for Powerchart to bring in Patient useful data on to the banner bar and to create pre completed notes useful for Providers.

Took part in creating Star Schema, Snowflake dimensional schema in MS analysis services (SSAS).

Developed Power BI reports and SSRS reports by querying RDBMS (SQL Server and Oracle) to provide actionable insights for decision-making.

Performed database administration tasks, including backup/restore, security management, and query optimization using SSMS.

Effectively visualized data (dashboards, reports, etc.) in QlikView, Qlik Sense and MicroStrategy for different business users and requirement

Imported Data from SQL Server DB Azure SQL DB to Power BI for generating Reports.

Set up Microsoft Flow (Power Automate) to provide auto-approval and status update features based on predefined criteria.

Added new users and applied roles in the QNXT UI in the Development and UAT Environments.

Experienced in integration of various data sources like DB2, Green Plum, SQL Server, MySQL, and Flat Files.

Designed, developed, and delivered business intelligence solutions using SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).

Developed application in PowerApps using Common Data Service CDS, Flow, Excel, Forms and SharePoint online.

Generate ad-hoc reports in excel Power Pivot and shared them using Power BI to the decision makers for strategy planning.

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

Created and modified several Unix Shell Scripts according to the changing needs of project and client requirements.

Environment: Microsoft Power BI, Tableau, Power (Gateways, Pivot, Service, Desktop, Apps) Microsoft Excel, Shell Scripts, APIs, CVC, SharePoint, Teradata, MS Access, SQL Server 2019/2017/2016/2014/2012, HTML.

Power BI Developer Feb/2019 – Oct/2022

Ecolab, Saint Paul, MN

Responsibilities:

Developed various solution driven views and dashboards by developing different chart types including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots in Power BI.

Gathered data from various external sources (Oracle) into a data warehousing system (Enterprise Cube) with the help of ETL process.

Developed interactive reports and dashboards using tools like Power BI, Tableau, or QlikView to enable data visualization and insights.

Used various sources to pull data into Power BI such as SQL Server, oracle.

Involved in installation of Power BI Report Server.

Developed reports to visually explore data and create an interactive report Excel and Power BI.

Based on business requirements, develop complex SQL queries with Joins and T-SQL, Stored Procedure, Views, Triggers to implement the business rules and transformations.

By using Power BI desktop connected to various data sources, working with different visualizations.

Developed and published reports and dashboards using Power BI and written effective DAX formulas and expressions.

Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging

Installed, managed and administrated SQL Server 2019/2017/2016/2014/2012 Databases.

Created Power BI Reports using the Tabular SSAS models as source data in Power BI desktop and publish reports to service.

Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.

Designed different types of KPI's for percentage growth in different fields and compared over the period of time and designed aggregations and pre-calculations in SSAS.

Involved in designing partitions in cubes to improve performance using SSAS.

MDX programming, DAX expressions, analysis and business forecasts.

Implemented OLAP cubes, facts, and dimensions for providing summarized and aggregate views of large database sets.

Extract data from various sources like DB2, Oracle, Flat Files, and XML Files and loaded them into Fact and Dimension tables of the Datawarehouse.

Experience with, power pivot and dashboard designer.

Troubleshoot and support reports in Power BI workspaces whenever there are issues in production.

Environment: MS SQL Server, (SSIS), (SSAS), (SSMA), Oracle, T-SQL, Power Bi Desktop, Power Bi Pro.

Education:

Master of Science Technology & Engineering.

Bachelor of Science Technology & Engineering.

Licenses & certifications:

PLP Learning (Precision Learning Platform)

Microsoft Excel-Intermediate

Udemy

A complete course in SQL with SQL server

Udemy

Data Warehouse Developer-SQL Server/ETL/SSIS/SSAS/SSRS/T-SQL

Udemy

SQL Server Integration Services (SSIS)-A Introduction

Contact this candidate