Power Bi Sql Server

Mayuriben Patel

***************@*****.*** Dallas, TX

405-***-**** Green Card

EXPERIENCE SUMMARY:

MSBI and Power Bi Developer with strong experience over 7 years in Design, Development and Deployment of Business Intelligence solutions.

Experienced in working with development teams, Business analysts and interacting with end-users.

Published Power BI Reports in the required originations and made Power BI Dashboards available in Web clients and mobile apps.

Extensive experience with SQL Server with DAX Functions Such as SUMX, CALCULATE, ALLEXCEPT, FILTER Functions.

Experience in Writing Complex T-SQL Queries, Dynamic-queries, Sub-queries, Co-related sub queries, Complex joins.

Experienced in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS 2012/2016/2017 across various environments.

Expert in designing Enterprise reports using SQL Server Reporting Services and Excel Pivot

Created SSRS projects and reports in BIDS, sort and toggle object visibility to modified report, assigned item level permissions and site security roles created report schedules and subscriptions.

Worked under Agile Methodology throughout the project, performed decisive role in developing and planning as well as coordinating with assigned sprints.

Expertise in Power BI Desktop, Power BI Service with Pro and Premium capacities.

Comfortable in working with filters, calculated columns, measures, relationships and transformations of edit query section. Worked on Power BI Template.

Scheduling the Data Refresh through Power BI Gateway and Scheduled Reports Weekly and Monthly basis as per the Client Requirements.

Worked on-premises gateway to refresh the data sources & creating a live connection with tabular /Multi-dimensional Model SSAS.

Implemented the Row-level security (RLS) with Power BI Reports.

Created multiple dashboards using Power BI Desktop, Power Query and Power View and deployed them.

Experience in developing complex reports using cascade parameters, drill down and drill through reports, matrix reports, sub reports, parameterized reports, Ad-Hoc and charts using SQL Server Reporting Services (SSRS) based on requirements.

Experienced in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all etc.

Strong knowledge and experience in error handling of SSIS packages using transactions, check points (Package restart ability features), break points and error logging procedures.

Excellent experience in Data Analysis, Data Cleansing, Data Verification using complex SQL query.

Expert in creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc. using Power BI.

Generated context filters and data source filters while handling large volume of data using Power BI.

Experience in database programming in writing Stored procedures, User Defined Data Types, Triggers, Constraints, Indexes, CTEs and Batch Scripts using T-SQL/PL-SQL.

Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Physical & Logical Data Modeling- Relational, Multi-Dimensional Modeling Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using Analysis Services.

Utilized Power Query in Power Bi to pivot and un-pivot the data model for data cleansing and data massaging.

Having experience with Azure DevOps, TFS (Team Foundation Server) and GitHub.

TECHNICAL SUMMARY:

Databases : SQL Server 2012 /2016/2017

ETL Tools : SQL Server 2012 /2016/2017 Integration Services (SSIS)

OLAP Tools : SQL Server 2012 /2016/2017 Analysis Services (SSAS)

Reporting Tools : SQL Server Reporting Services (SSRS)

Visualiation Tools : Power BI, Power Pivot, Power View

Ticketing Tools : JIRA and ServiceNow

WORK EXPERIENCE:

Company : Cooks Children Health Plan, Fort Worth, TX

Role : BI Developer

Duration : Oct 2020 – Present

Environment : SSIS, SSRS and SQL SERVER, Power BI

Roles & Responsibilities:

Designing, developing and maintaining business intelligence solutions. Crafting and executing queries upon request for data. Presenting information though reports and visualization.

Managed project insights through Azure DevOps to track the list of assignments and provide daily updates on progress.

Optimized SQL queries, stored procedures, views.

Create and customize simple visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges and single-number cards.

Developed calculated columns and measures using DAX in Power BI.

Worked on-premises gateway to refresh the data sources & creating a live connection with tabular /Multi-dimensional Model SSAS.

Scheduled Reports Weekly and Monthly basis as per the Client Requirements.

Implemented the Row-level security (RLS) with Power BI Reports.

Worked with Azure Data Studio, Azure Data factory for Orchestration, SQL Azure, creating resource groups, subscriptions, build and release definitions.

Used DAX table functions including FILTER, ALL, VALUES, DISTINCT and RELATEDTABLE.

Published Power BI Reports in the required origination s and Made Power BI Dashboards available in Web clients.

Used Power BI Gateways to keep the dashboards and reports up to date.

In Power BI developed reports by different time intelligence like year to data (YTD), Month to date (MTD), same period last year.

Designed SSIS packages to import and transform data between databases and external data sources using various transformations like Data conversion, File system task, Row counts, OLE DB Source, OLE DB Destination, OLE DB Command, Merge Join, Look up, Sort, Data flow task.

Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.

Project #2

Company : Emblem Health - Farmington, CT

Role : BI Developer

Duration : Mar 2019 – Sept 2020

Environment : Power BI, SSIS 2012, SSRS 2012 and SQL SERVER 2012

Roles & Responsibilities:

Gathered requirements from the business users, created technical specification documents.

Documented all work, so user can easily understand the flow of process.

Designed diverse types of Power BI reports like Drilldown, Drill through and Sync Slicer.

Developed custom report Tooltips for different Reports and Dashboards in Power BI.

Created various customized and interactive Reports and Dashboards in power BI.

Publishing reports to Power BI Service and providing the access to required users.

Created Table, Matrix, trend lines, bar, card, gauge, slicer etc. and Custom visuals using Power Bi.

Developed and rendered monthly, weekly and daily reports as per the requirement and gave roles, user access with respect to security in Report Manager.

Developed different types of Tabular Reports, Matrix Reports, Chart and Graphs, Reports that aggregate data, Reports containing parameters and group, Reports containing Totals and Subtotals, Drill-down reports and ad-hoc reports using SSRS.

Responsible for programming, testing, debugging, and documenting simple to moderately complex ETL applications (SSIS) under direct supervision.

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.

Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.

Improved ETL performance, optimization on SSIS packages.

Involved in the designing, development, modification and enhancing the database structures and database objects.

Project #3

Company : Quest Diagnostics - Dallas, TX

Role : MS SQL Server Developer/SSIS/SSRS

Duration : Aug 2017 - Feb 2019

Environment : SSIS, SSRS and SQL SERVER

Roles& Responsibilities:

Involved in gathering the user requirements.

Performed tasks like execute SQL task, data flow task, file system task for ETL process.

Worked Extensively on ETL process using SSIS package.

Created Back-end validations using Insert/ Update and Delete triggers.

Part of Relational Data Warehouse Designs and effectively identified and created Facts and Dimensions tables.

Coordinated with DBA in creating and managing tables, indexes, triggers and privileges.

Designed production and sales dashboard for Sales and procurement departments using Power BI.

Using Microsoft Power BI for data visualization.

Created new measures and new calculated columns for reports and dashboard analysis.

Created data visualizations using various visual objects (Line chart, Bar chart, Tree map, Single card, KPI, Map, Pie chart, custom visuals).

Published reports and dashboards to the Power BI service.

Created Parameterized Report, Dashboard Report, linked report and Sub Report by Year, Quarter, Month, and Week.

Created Drill Down Reports, Drill Through Report by Region.

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

Weekly presentation to the business users about the reports and their changes as required.

Worked on transformations that are available in Power BI query editor.

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

Shared the dashboards among multiple users in the group.

Project #4

Company : BeneCard, Orlando, FL

Role : MS SQL Server Developer/SSIS/SSRS

Duration : Aug 2015 - Feb 2017

Environment : SSIS, SSRS and SQL SERVER

Roles& Responsibilities:

Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (Flat files, Excel, Oracle DB2, and SQL Server).

Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse.

Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.

Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes.

Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Send Mail Task, Package Execution task to achieve business needs.

Created and modified various complex Stored Procedures used in the application using T-SQL.

Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.

Wrote complex Expressions for SSRS with Conditional Formatting.

Responsible for Deployment of the report using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.

Created different Parameterized Reports like standard parameter reports, Cascading Parameterized reports

Created subscriptions to provide reports on a daily/weekly/monthly/Quarterly and Yearly basis.

EDUCATIONAL QUALIFICATION:

Bachelors in Computer Science

Contact this candidate