Power Bi Azure Data

HABIB SHAIK Mobile: +1-669-***-****

************@*****.***

PROFESSIONAL SUMMARY:

I have 12+ years of experience in the IT industry, primarily focusing on BI tools, such as Microsoft Power BI Development and Services, Tableau, QlikView, and Alteryx.

7+ years of extensive Power BI experience in developing Reports/Dashboards in Power BI Desktop and Power BI Services and 3.8 years of Experience in Tableau 9. x and 10. X and 2+ Years of Experience in 2+ Qlik Administration.

Experience in the Azure Data Bricks and Azure Data Factory.

Expert knowledge of architecting and developing Power BI solutions by configuring the data security assigning the licenses and sharing the reports and dashboards with the different user groups in the organization.

Integrated Power ON Visual Planner Service into Power BI to enable write-back functionality across various data sources.

Delivered Power ON planning, data management, and data collection features, including Read/Write in Pivot Tables, Goal-Seek, and Smart Formulas.

Designed interactive Power ON visuals for adjusting numbers using drag-and-drop capabilities with mouse or touch screen.

Enhanced analysis with Power ON by supporting multi-metric views, including Actual, Forecast, and Planning data in a single matrix. Import data from multiple data sources and create automated reports in Power BI after cleaning and preprocessing the data.

Implemented Power ON client-side calculations and layouts for dynamic and flexible data analysis.

Enabled real-time updates across related visuals and data points using Power ON Visual Planner for synchronized insights.

Incorporated collaborative features in Power ON, such as comments, remarks, and annotations on specific data points.

Provided Power ON solutions for planning in domains like Expense, Revenue, Sales, Supply, Demand, Inventory, and HR.

Create reports in Power BI by importing data from the SQL database using write queries according to the business requirement.

Modify datasets using DAX query, Merge statements, Refresh Schedule, Row-level security, and Modelling within Power BI.

Provide recommendations and Business Insights based on analytics in Power BI.

Work on enhancements, security models, and ad-hoc reports based on the management required to create the reports in Power BI.

Critically evaluates information gathered from multiple sources, reconciles conflicts, and abstracts up from low-level information in Power BI.

Expert in Power BI and ability to program in DAX query language to modify data for reporting.

Experience in creating visualizations, interactive dashboards, reports, and data stories using Tableau, and Power BI.

Experience in developing custom reports and creating various types of reports like on-demand, drill down, Drill-through, Table, Matrix, Chart, Sub Reports, Ad hoc Reports, dynamic grouping, Crosstab, graphical, and distributed Reports in multiple formats in Power BI.

Experience in Microsoft BI Tools (SSIS/SSAS/Power BI)

Expertise in Visualizing and Analyzing Data using Power BI with cloud-based applications.

Experience with Microsoft Power BI, DAX expressions, Power View, and Power Query integrated with SharePoint.

Expert in creating Effective Reports using visualizations and Dashboards using Power BI.

Experience in creating custom visuals using R Script.

Experience in creating measures and calculated columns using DAX in Power BI.

Good Experience in transforming and cleansing the data in Power Query.

Expert in implementing Row-level security (RLS) for user authentication in Power Bl.

Good knowledge of Power BI Embedded functionality to embed Power BI reports into their web apps.

Experience in working with Larger Datasets using Power BI premium.

Expertise in creating object-level security in cubes using the Power BI External tool Tabular Editor.

Expertise in creating Dashboard Reports to support end users using Cognos BI.

Experienced and passionate developer implementing new emerging Microsoft-related technologies like PowerApps.

Migrated reports from Tableau, and Cognos to Power BI.

Worked with data models with complex relationships in Power BI and connected different data sources to the Power BI desktop.

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

Used M language to create Custom, Conditional columns, and Append files from the SP folder in Power Query.

Good Experience with Azure Data Factory (ADF).

Creating Stored Procedures and Scheduling them in Azure Environment

Scheduling Pipelines and monitoring the data movement from source to destinations

Good knowledge of RDBMS concepts and constructs along with Database object creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, and User Defined Functions.

Experience in developing Spark applications using Spark-SQL in Databricks for data extraction, transformation, and aggregation from multiple file formats for Analyzing& transforming the data to uncover insights into customer usage patterns.

Extract Transform and Load data from source Systems to Azure Data Storage services using a combination of Azure Data factory, T-SQL, Spark SQL, and U-SQL Azure Data Lake Analytics. Data ingestion to one or more azure services (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in Azure Databricks

Knowledge to Develop Spark applications using pyspark and spark SQL for data extraction, transformation, and aggregation from multiple file formats for analyzing and transforming the data to uncover insight into customer usage patterns.

Hands-on experience in developing SQL Scripts for automation

Responsible for estimating the cluster size, monitoring, and troubleshooting the Spark data bricks cluster.

Experience in OLTP and OLAP design, development, testing, implementation, and support of enterprise data warehouse.

Strong understanding of Dimensional Modeling technique, Multi-Dimensional Database Schemas like Star and Snowflake Schema, Fact and Dimensional tables, and DW concepts.

Experience in T-SQL, Creating and developing new database objects like Tables, Views, and Indexes.

TECHNICAL SKILLS:

BI Tools

MS Power BI, Power On, Tableau, QlikView, SSRS, Power Apps, Azure Analysis Services (AAS), Microsoft Flow, MDX, DAX.

Databases

MS SQL Server 2008/2005, Oracle 11g/10g/9i/8i, DB2 v8.1.

Languages

Power Query (M Language), SQL

Scheduling Tools

Autosys, Control-M, TWS (Tivoli Work Scheduler)

Operating Systems

Windows, UNIX, MS-DOS

PROFESSIONAL EXPERIENCE:

PROJECT NAME:

CDK Global, Atmanica Technologies LLC June 2023 to Till Date

Senior BI Consultant

Responsibilities:

Highly experienced in Performance tuning with various techniques like Aggregate Awareness, configuring and managing Aggregations within Power Bl.

Enabled real-time updates across related visuals and data points using Power ON Visual Planner for synchronized insights.

Incorporated collaborative features in Power ON, such as comments, remarks, and annotations on specific data points.

Provided Power ON solutions for planning in domains like Expense, Revenue, Sales, Supply, Demand, Inventory, and HR.

Maintained data security by utilizing Power ON Visual Planner with Row-Level Security (RLS) for all modifications.

Optimized workflows by leveraging Power ON tools for statistical, operational, and financial planning activities.

Optimize and best possible solutions are given while creating Calculated Columns/ Measures/Tables with appropriate techniques having the best performance.

Dynamic Row-level security (RLS), both Static and Dynamic with hierarchies was implemented successfully on Power BI Service (Cloud).

Daily working on custom-calculated columns and parameters on Power Query with M code.

Working with data models with complex relationships in Power BI and connecting different data sources to the Power BI desktop.

Solid experience on both Cloud and on-premises servers to deploy Power BI Dashboards and maintain normal and Row level Security.

Creating Datasets on Power BI Service to avoid "Data Set Silos" and creating different environments for Dev/QA/Prod Swap using Deployment Pipelines.

Implementing a composite model for the best performance for the size of the very large-scale dataset in terabytes.

Working closely with Power BI Admin to incorporate Deployment pipelines for various environments for dev/QA / Prod on Power BI Premium capacity.

Commendable experience in modeling, creating relationships, and selecting appropriate data storage modes using Power Pivot in Power BI.

Data Flows have been created with self-service Data preparation to help other BI Reports as a single source and ready to use the dataset.

Data Folding and Query reduction techniques and Data Silos have been taken care of while implementing Steps with transformations on Power Query.

Generated Drill down, drill through, Matrix Reports, and Parameterized reports using expressions to calculate, group, filter, and parameterize reports using Power BI.

Both Query Parameters and Report parameters including what if Analysis parameters have been created.

Building the pipelines to copy the data from source to destination in Azure Data Factory

Working on Configuring and Upgrading the On-Premises Data gateway between various Data sources like SQL Server to Azure Analysis Services and Power BI service.

Working on creating dependencies of activities in Azure Data factory.

Creating Stored Procedures and Scheduling them in Azure Environment

Monitoring Produced and Consumed Data Sets of ADF

Creating Pipelines with GUI in Azure Data Factory

Scheduling Pipelines and monitoring the data movement from source to destinations Scheduled Jobs in ADF Pipelines.

Experience in Developing ETL solutions using Spark SQL in Azure Databricks for data extraction, transformation and aggregation from multiple file formats and data sources for analyzing & transforming the data to uncover insights into the customer usage patterns.

Experience working on NiFi to ingest data from various sources, transform, enrich and load data into various destinations (kafka, databases etc)

Building the pipelines to copy the data from source to destination in Azure Data Factory.

Daily activities on working with MS SQL Server.

Environment: MS Power BI, Power On, Azure SQL, SQL Server, Data Visualization.

PROJECT NAME: National Grid, IBM India Private Limited May 2021 to Sep 2022

Advisory Development Analyst

Responsibilities:

Experienced in working with DAX commands to pull up more calculated data out of the tables.

Command in the creation of Calculated Columns/Measures/Tables with appropriate techniques having the best performance.

Dynamic Row-level security (S) was implemented successfully on Power BI Service (Cloud)

Worked with gateways to schedule the report and data using different gateways

Worked with data models with complex relationships in Power Band and connected different data sources to Power Desktop.

Published many reports and visualizations created for the Power service and thereby developed dashboards.

Experienced in Data Modeling used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations.

Created complex Custom View using SQL Developer to create data sets for Power BI dashboards.

Experienced in working with DAX commands to pull up more calculated data out of the tables.

Published many reports and visualizations created for the Power service and thereby developed dashboards.

Made Power BI reports more interactive and activated by using storytelling features such as bookmarks, selection panes, and drill-through filters also created custom visualizations using "R-Programming Language".

Utilized Power BI to create various analytical dashboards that help business users get a quick insight into the data.

Published and maintained workspaces in Power BI Service, allotted the time refresh for the data, and maintained the apps and workbooks.

Used DAX functions to create measure and calculated fields to analyze data for logical visualization and used Power Queries to transform the data.

Converted the Boulder Tables from Excel to Power BI with better Graphs and visualizations for the understanding and improvement of the business.

Used Data Analysis Expressions (DAX) to create measures and calculated fields to analyze data and to create time intelligence.

Used Data Analysis Expressions DAX to create custom calculations in PowerPivot for Microsoft Excel workbooks and Analysis Services tabular model projects.

Made Power BI reports more interactive and activated by using storytelling features such as bookmarks, selection panes, drill-through filters, etc.

Environment: MS Power BI, ADF, Azure Analysis Services, MS SQL Server, Jira, Power Apps.

PROJECT NAME: GSK, Tech Mahindra

Senior Software Engineer March-2020 to May-2021

Responsibilities:

Expertise in writing complex DAX functions in Power BI and Power Pivot.

Shared reports/dashboards by creating Content Packs and creating reports to view in Power BI Mobile.

Involved in configuring Gateway for Power BI to access on-premises data and Monitored Scheduled Datasets Refresh.

Interacting with onsite counterparts and businesses directly to understand the requirements.

Developed metrics, attributes, filters, reports, and dashboards, and created advanced chart types, visualizations, and complex calculations to manipulate the data.

Designed and developed Power BI graphical and visualization solutions based on business requirements.

Experience with advanced power BI topics such as complex calculations, table

calculations, geographic mapping, and performance optimization.

Experience in publishing Power BI reports on dashboards Power BI servers in and Power BI and Power BI Mobile App.

Collaborates with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements.

Developing and updating the database as well as merging collected information from old to new systems as required.

Developed Power BI model used for financial reporting of P & L and Headcount.

Designed and documented the entire Architecture of Power BI POC.

Expertise in writing complex DAX functions in Power BI and Power Pivot.

Automated Power Query refresh using PowerShell script and Windows task scheduler.

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

Installed and configured Enterprise gateway and Personal gateway in Power BI service.

Created Workspace and content packs for business users to view the developed reports.

Scheduled Automatic refresh and scheduling refresh in power BI service.

Wrote calculated columns, and Measures queries on the Power BI desktop to show good data analysis techniques.

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

Worked on all kinds of reports such as Yearly, Quarterly, Monthly, and Daily.

Worked on all types of transformations that are available in the Power BI query editor.

Environment: MS Power BI, SQL Server, SSIS, Jira.

PROJECT NAME: Unilever, Capgemini Aug- 2019 to March-2020

BI Developer

Responsibilities:

Created and administrated workspaces for each project on Power BI service and published the reports from Power BI Desktop to Power BI Services workspace.

Utilized Power BI to create various analytical dashboards that help business users get a quick insight into the data Installed Data Gateway and configured schedule plans for Data Refresh of Power BI reports.

Created ad-hoc reports such as YTD, YOY, MTD, and MOM analysis for the income statement, and cash flow by requests from business units.

Implemented report integration among Power BI, Tableau, SSRS, and Python reports.

Implemented Tableau for visualizations and views including scatter plots, box plots, heatmaps, tree maps, donut charts, highlight tables, word clouds, reference lines, etc.

Generated complex reports in Tableau using multiple functionalities including context filters, hierarchies, parameters, LOD Expressions, time intelligence, etc.

Built interacting and storytelling dashboards in Tableau workbooks using dashboard actions

Published Tableau workbook on Tableau Server and set report refresh.

Good knowledge of RDBMS concepts and constructs along with Database object creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, and User Defined Functions.

Experience in OLTP and OLAP design, development, testing, implementation, and support of enterprise data warehouse.

Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).

Strong understanding of Dimensional Modeling technique, Multi-Dimensional Database Schemas like Star and Snowflake Schema, Fact and Dimensional tables, and DW concepts.

Experience in T-SQL, Creating and developing new database objects like Tables, Views, and Indexes.

Environment: MS Power BI, Tableau, Informatica PowerCenter 9.6.1, Oracle 11g/12c, Microsoft SQL Server Management Studio 2012, SSRS, SSIS, Business Objects 4.1, HP Client, Microsoft Visio, MS Office, UNIX, Windows 10 Operating System.

PROJECT NAME: CUNA, Syntel India Private Limited July-2017 to July-2019

Associate Consultant

Responsibilities:

•Implemented Tableau for visualizations and views including scatter plots, box plots, heatmaps, tree maps, donut charts, highlight tables, word clouds, reference lines, etc.

•Generated complex reports in Tableau using multiple functionalities including context filters, hierarchies, parameters, LOD Expressions, time intelligence, etc.

•Built interacting and storytelling dashboards in Tableau workbooks using dashboard actions

Published Tableau workbook on Tableau Server and set report refresh.

•Interacting with Business analysts and on-site coordinates for requirement analysis

•Worked as ETL Developer involved in the development of ETL process using Informatica to load data from source EBS database into the target Oracle database.

•Designing and developing mappings to extract data from diverse sources including flat files.

•Designed and Developed the Sales Order Aggregate to resolve the performance Issues.

•Successfully solved Tracks assigned Before Deadlines

•Involved in the testing process throughout the project.

•Involved in debugging the data mismatches fixing those and preparing proper analysis documents for the mismatches.

•Worked on a Production Clone instance for the same project based on the client's request and handed over to the client in a couple of weeks including the data validation.

•Worked on Migration from DEV environment to QA and Production Environment

•Performed unit testing.

Environment: Tableau, Informatica PowerCenter 8.1, Business Objects 6.0, Oracle 10g, SQL Loader, PL/SQL, DB2, UNIX Shell Programming, Linux, and Windows NT

PROJECT NAME: BskyB, Accenture June-2015 to June-2017

Software Engineering Analyst

Responsibilities:

•Developing Reports as per the Mockup provided by the client.

•Code review of Juniors

•Developing Reports as per Business Requirements.

•Providing resolution to incurred issues.

•Testing of report functionality and preparing Unit test cases/Results.

•Migration document preparation.

•Conducted requirement gathering session to gather and understand the requirements of the business users.

•Conducted regular walk through with the client to identify the gaps and to get a clear understanding of the requirements and acceptance criteria (definition of done)

•Eliciting requirements, evaluating information gathered from multiple sources, reconcile conflicts and converting high level information into detailed level information.

•Working as liaison among stakeholders in order to analyze and design business process and system applications.

•Elaborated the user requirements by developing prototypes, wireframes and screen mockups.

•Analyzed business user requirements, analyzed data, and designed software solutions in Tableau Desktop based on the requirements.

•Developed and reviewed custom SQL queries with use of joins clauses (inner, left, right) in Tableau desktop to validate and reconcile data.

•Worked as Tableau Server Administrator and Tableau desktop developer. Responsible for Preparing the Report Design specifications based on the User's requirement.

•Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint.

•Implemented security configuration including user / group setup, permissions, security roles, configuration of trusted ticket authentication and Creating epics and user stories.

Environment: Tableau, SQL Server.

PROJECT NAME: Medtronic, CitrusInfo Aug- 2012 to May-2015

Software Associate

•Responsibilities:

•Defined best practices for Tableau report development.

•Good comprehension of ideas for example, Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact & Dimensional Tables.

•Involved in making dashboards and reports in Tableau 8.2, 9.3 & 10.4 Made report plans on

•ableau server.

•ctively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 9 desktop/Server.

•Created modified reports utilizing different diagram sorts like content tables, bar, pie, Heat maps, line graphs, Area outlines, disseminate plot, double mixes diagrams in Tableau.

•Designed Tableau Data Extracts for improving visualizations perform better.

•Strong learning and comprehension of SQL and capacity to write SQL queries.

•Knowledge in reporting the testing procedure using MS-Office instruments including MS-Word, MS-Excel, and MS-Project.

•In depth knowledge of Software Development Life Cycle (SDLC)

•Knowledge of Agile, Waterfall and Scrum methodologies of client's business Processes.

•Gathered business requirements from client and utilized CIML (Unified Modeling Language) in which various diagrams such as Sequence, Flow chart, Activity, Class, use cases and E-R diagrams are prepared.

•Excellent technical writing skills to create Business Requirements Document (3RD), Functional Specifications Document (FSD) and Prototyping.

•Excellent business, communication, and presentation skills.

•bility to work both independent and in team environment.

•Experience in academic counseling, teaching to students of high school and higher education. Experience in administration and management work.

•Worked on moving Tableau Dashboard from Development to Production Live Environment.

•Worked broadly with Advance Investigation Actions, Calculations, Parameters, Background pictures, Maps, Trend Lines, Statistics, and Log Axes. Groups, chains of command, sets to make point of interest level synopsis report and Dashboard using Tableau's Advanced Capabilities.

Environment: Tableau, SQL Server.

CERTIFICATION:

•Certified Power BI Developer.

•Certified ITIL Foundation Certificate in IT Service Management.

Education:

•Master’s in Cloud Computing, Campbellsville university, Louisville, Kentucky.

Contact this candidate