Shaik Thahera Banu

⮚ Having BI reporting experience, as a Power BI Developer and SSRS Reporting Analyst (Power BI Desktop and Power BI Service)
⮚ Proficient in designing interactive reports and dashboards using Power BI Desktop & publishing reports.
⮚ Extensively worked on performing the ETL Activities in Power Query.
⮚ Good Experience in filtering the Unwanted Data in Power Query.
⮚ Develop reports using Microsoft Reporting Services (SSRS) from a variety of data sources including Analysis Services Cubes and relational databases.
⮚ Modify/Create/maintain and optimize ETL processes using SSIS.
⮚ Create Data extraction and Import programs using SSIS.
⮚ Implement user stories and help train the team
⮚ Extensively used transformations like add column, split column, pivot column, unpivot column, changing data type, Merge queries and Append queries.
⮚ Good Knowledge in doing Data Modeling in Power Pivot Model.
⮚ Familiar to write the DAX queries in Power BI, creating calculated measures, computed columns and table using DAX.
⮚ Good knowledge in different Categories of DAX functions like Time Intelligence Function, Filter Functions, Date Functions, Logical Functions, Text Functions, Number and Statistical Functions for creating new information.
⮚ Having valuable experience with Visual level, Page level, Report level and Drill Through filters for filtering the data in a Report.
⮚ Having good experience in creating Parameters, Hierarchies, sorting, grouping, binning and Drilldown Reports.
⮚ Good at creating native visualizations (table, matrix, kpi, gauge, various types of charts, and maps) and custom visualizations (Multi Slicer and Hierarchy Slicer, Histograms, Shape maps, Dual KPI, Bullet Chart, Heat Maps.
⮚ Good knowledge on Power BI Service for creating APP Workspaces and adding the Members to APP Workspace to Manage the Content.
⮚ Worked on On-Premise Data Gateway to Refresh and Schedule Refresh the Data in the Dataset.
⮚ Good experience in publishing the Reports and Dashboards to Power BI Service along the outputs with applying row level security.
⮚ Hands on Experience on writing SQL Queries as part of testing the Data.
⮚ Good knowledge on Data warehouse concepts like Star schema, snow-flake schemas etc.
⮚ Good experience in creating sample POC for Client.
⮚ Having Software Development Life Cycle (SDLC) knowledge and familiar to Agile and Scrum Methodology
⮚ Good exposure on Tabular Data Model and SSIS
⮚ Self-motivated team player with good communication, Analytical, Problem

Participated in requirements meetings and Scrum Calls to understand the Report Requirements
Identified and Documented detailed business rules
Used Power Query / Query Editor for Data transformation as per the reporting needs
Created Data Model in Power Pivot by Establishing the Relationship Between the tables
Created New Columns and New Measures over data models for the purpose of enhancing Power BI visuals using DAX
Participated in weekly, daily meetings, reviews meeting as well as communicating with business teams
Integrated Custom Visuals based on business requirements using Power BI desktop
Created Hierarchies and Drilldown Reports
Created Microsoft Power BI Dashboards in Power BI Service using Reports
Installed and Configured Data Gateways to Refresh and Schedule Refresh the Dataset
Managed access of Reports, Dashboards and Data for individual users using roles
Implemented Row Level Security as part of Security
Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports
Good experience in creating sample POC for Client

Defining the scope of the project
Gathering business requirements
Doing analysis and documents
Importing the data from data sources and preparing the data as per user requirement
Building the relationships between the various data sets in power pivot
Created new columns, new measures and conditional columns using DAX functions
Implementing the solutions from Changing Manual work to Automation work using Power apps

Extracting data from different kind of source systems into Power query and then cleansing the data by applying business rules and loading it into Power Pivot
Building the relationships between the various data sets in power pivot
Created new columns, new measures and conditional columns using DAX functions
Created different filters like visual level filters and page level filters and report level filters as per reporting needs
Designed and deployed reports with Drill Down and Dropdown menu option
Created various visualizations like donut chart, Pie chart and Bar graph, Tree map and water fall charts and Card Visualizations
Developed at least two - three visual options for each report for discussion with stakeholders and customers
Publishing reports to Power BI server and providing the access to required users
Implemented Row Level Security as part of Security
Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports

Responsible for defining the scope of the project, gathering business requirements, doing analysis and documents
Importing the data from data sources and preparing the data as per user requirement
Building the relationships between the various data sets in power pivot
Created new columns, new measures and conditional columns using DAX functions
Created different filters like visual level filters and page level filters and report level filters as per reporting needs
Expertise in various visualizations like donut chart, Pie chart and Bar graph, Tree map and water fall charts and Card Visualizations
Designed diverse types of reports like drill down, drill through, And Sync Slicer
Developed custom report tool tips for different reports to showcase the multiple data points in one report
Created various Customized and interactive Reports and Dashboards in Power BI
Publishing reports to Power BI server and providing the access to required users
Involved in creation of SSIS packages using various kinds of Sources and Destinations

Working with different departments for preparing the reports using Excel tools like VLOOKUP, PIVOT TABLE, INDEX, MATCH…etc
Responsible for updating Reports in the Internal Portal and communicating the same to the Team and Leadership team
Streamlining workflow to enhance Efficiency innovatively for reputed activities
Working with worksheet functions, Pivot Table & Charts
Process daily, weekly, and monthly reporting
Analyzing the raw data using Advance Excel formulas
To do the comparative analysis & document the reports for the higher management using functions like V-LOOKUP, CONDITIONAL FORMATTING, DATA VALIDATION, SUM IF, COUNT IF, INDEX MATCH...etc
Spread sheet Consolidation using Consolidation function
Reports analysis and creating Dash boards with power point presentations