Power Bi

Neelima Annabhimoju

Email ID: ***********@*****.***

Phone No: 469-***-****

Summary:

8+ years of IT experience in complete Software Development Life Cycle and Agile Methodologies including Requirement Analysis, Design, Development, testing, and Implementation.

Experience in Business Intelligence (BI), data analytics and data visualization technologies including development of reports and dashboards using MS Power BI, SSRS and Qlik Sense

Experience in communicating with stakeholders, Subject Matter Experts (SMEs), and end-users to better understand, analyze, communicate, and validate requirements.

Experienced in developing Power BI Reports and dashboards from multiple data sources using data blending

Experienced in creating Power BI reports and Dashboards using Power View, Power Query, Power Pivot, and Power Maps

Experienced in building the C-Level executive dashboards with KPI’s

Integrated Dashboards into applications using Embedded Analytics

Experienced in SQL and DAX(Data Analysis Expressions) languages

Experienced in MS SQL server and Microsoft BI Tools

Built and deployed end to end ETL Process to load data into SQL database from flat files, Excel sheets using SSIS

Experienced in SSRS ( SQL server Reporting Services) reports and dashboards development

Used SSMS (SQL Server Management Studio) to connect SQL server and power BI Desktop

Worked with Query Editor to connect to different data sources and work on Data models. Created new Calculated Tables, Calculated Columns, and Measures in Power Bi

Experience in developing custom reports, and different types of Tabular Reports, Matrix

Created relationships between different tables from different data sources.

Worked with Power BI Service for creating Dashboards and sharing them with business users.

Worked with DAX formulae for creating variables like Previous Year, Month, Previous Quarter, etc.

Extensively involved in the design of a Dashboard to display all customer-related information.

Developed all the visualizations which are requested by the business users using Power BI.

Designed and developed the Power BI solution to create reports, visualizations, and dashboards as per the business requirements and published enterprise.

While designing the Power BI reports and dashboards, the measures are created using the DAX programming language. Writing all the calculations using DAX formulas.

Scheduled the data refresh for dashboards and reports to show the updated data.

Expertise in Performance Tuning, Debugging, and Optimizing Analytics Dashboards / Reports

Ensured compliance with company policies and procedures, federal rules, and regulations including HIPAA.

Created a dashboard by leveraging techniques such as parameters, groups, and calculations for a granular and drill-down into reports.

Used Filters so that the data can be analyzed based on different dimensions

Used Power Query, Pivot tables, vlookup, macros and formulas in MS Excel

Designed and developed Qlik Sense data model and dashboards

Connected to data source and selected the required tables to join them in data manager

Implemented Set Analysis to provide the custom functionality and aggregation calculations

Education:

MCA (Master of Computer Applications): Osmania University, Hyderabad, India

B.Sc. (Bachelor of Science) Computer Science: Osmania University, Hyderabad, India

Certifications:

Microsoft certified Power BI Data Analyst Associate (PL-300)

Technologies:

BI Tools

MS Power BI, Power Query, SSRS (SQL Server Reporting Services), SSIS (SQL Server Integration Services), SSMS (SQL Server Management Studio), MS Visual Studio, Qlik Sense and MS Excel

Databases

MS SQL Server, Oracle, MS Access and MS Share Point Lists

Languages

SQL, HTML, C, Power BI DAX, Power Query formula M (Mash Up) Language and Qlik Sense Set Analysis Expressions

Platforms

MS Azure, Windows and Virtual Servers

WORK EXPERIENCE:

Client: Health Help (Houston, Texas). Mar 2022 - Current

Role: Power BI Developer

Responsibilities:

Performed requirement analysis, design and development of the reports and dashboards in Power BI

Used different connectivity modes like import mode, direct query connectivity

Developed Power BI reports and dashboards by connecting to variety of data sources such as: CSV files, MS Excel, MS Access, MS SQL server, Folders and Web

Developed various solution driven dashboards by using different chart types including Pie Charts, Donut charts, Bar Charts, Tree Maps, Matrix, Line Charts, Area Charts, and Scatter Plots

Implemented several DAX functions for various fact calculations for efficient data visualization

Used KPIs, Gauges, cards and multi row cards

Filtered data using slicers and drill through filters

Used buttons, tool tip pages, bookmark navigators

Used Power Pivot, Power View and Power Map to visualize reports and dashboards

Worked on Dimensional modeling, Star schema and snow flake schema in Power BI

Used Power BI, Power Query to extract data from external sources and modify data to certain format

Used power Query editor to perform the transformations like append, merge and duplicate removal

Used data profiling tools including Column profile, column quality and column distribution.

Rigorously tested the reports and dashboards

Distributed the reports and dashboards using Power BI Service

Created data flows in workspaces and apps in Power BI Service

Involved in configuring, deploying, and publishing developed reports from Power BI desktop to Power BI Service

Developed reports in Power BI report server (RS) and published to Report server on-premise

Did Query Folding using SQL Server as data source to Optimize Performance

Did performance tuning of reports and dashboards to run faster using Performance analyzer

Transformed raw data to valuable and meaningful insights in the form of appealing dashboards and reports.

Assigned row level security(RLS) with Power BI

Used Power Pivot, Power View and Power Map to visualize reports and dashboards

Deployed web embedded Power BI dashboards refreshed using gateways by using workspace

Created applicable dashboards, Charts, Tabular reports, Matrix reports, and Graphs as per customer requirements

Created calculated columns, measures and worked on slowly changing dimensions.

Used SSMS (SQL Server Management Studio) to connect SQL server and power BI Desktop

Used Power Query, Pivot tables, vlookup, macros and formulas in MS Excel

Followed the best practices in development and testing of the reports

Environment: Power BI Desktop, Power BI Service, SQL, Microsoft Excel, MS Access, MS Visual Studio.

Client: Moffitt Cancer Centre (Tampa, FL) Jan 2020 – Feb 2022

Role: Business Intelligence Developer

Responsibilities:

Gathered requirements from stakeholders and creating complex SQL queries

Performed all sorts of ETL and metrics aggregations at the report level in Power BI using power query and M-code.

Built the relationship between various data sources in Power BI and transformed the data based on requirements.

Created new calculated columns and DAX measures and applied business rules to color code the metrics.

Developed rich visualizations like donut charts, pie-chart, bar graphs, staked area charts, etc.

Written several DAX queries using inbuilt functions in Power BI like dynamic calendar and customized it.

Created all sorts of frequency filters using DAX such as daily, weekly, monthly, and yearly.

Scheduled and automated the report refresh on the Power BI server and monitored them to deliver

Optimized the Power BI reports and improved the performance of dashboards by fine tuning the DAX.

Implemented row level security to restrict the data to a set of users in Power BI.

Designed and built several dashboards involving KPIs and trend charts comparing cumulative vs. actual values to depict the client’s overall business needs.

Built the relationship between various data sources in Power BI and transformed the data based on requirements.

Developed operational, analytical dashboards and data visualization reports using Power BI.

Developed rich visualizations like donut charts, pie-chart, bar graphs, stacked area charts, etc.

Collaborated with governance teams to enable consistent and accurate reporting for the business by designing and implementing custom reporting and visualizations such as bar graphs, line graphs, pie charts, bullet graphs, whisker plots, crosstabs, waterfall charts, funnel graphs, etc.

Created several reports involving drill down, drill through filters, and parameterized functionalities in Power BI.

Created SSIS process design architecting the flow of data from various sources to target.

Designed SSIS Packages to transfer data from various sources of the Company into the database that was modeled and designed.

Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.

Create a Master Package to run different other ETL in one Master package. Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.

Create different SSRS Reports based on the user’s requirements.

Troubleshoot any kind of data issues or validation issues.

Bug fixes in SSIS, SSRS, and stored procedures as necessary.

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

Environment: Power BI Desktop, MS SQL, Microsoft Visual Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL

Client: Broad ridge Financial Solutions, Raymore, MO Sep 2017 – Nov 2019

Role: Power BI Developer

Responsibilities:

Utilized datasets in Power BI service for refreshing data and implementing gateway.

Configured Power BI Enterprise gateway to keep the dashboards and reports up to date.

Worked with Power BI mobile app and created mobile layouts to view reports and dashboards effectively.

Contributed in building reports in Power BI from scratch.

Developed and maintained multiple Power BI dashboards/reports and content packs.

Responsible for building Power BI dashboards using tabular and multidimensional models.

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

Solid experience in building interactive reports, dashboards, integrating modeling results and strong Data Visualization design skills and analytic background by using Power BI

Created complex dashboard using parameters, sets, groups, and calculations and drill down and drill up in worksheets and customization using filters and actions.

Designed end user documentation for training and reference purposes.

Environment: Power BI Desktop, Power BI Service, DAX, MS SQL Server, SQL Server Management Studio (SSMS), MS Excel.

Client: Huntington National Bank, Cincinnati, OH May 2015 – Aug 2017

Role: Qlik Sense Reports and Dashboards Developer

Responsibilities:

Designed and developed Qlik Sense reports and dashboards

Connected to data source and selected the required tables to join them in data manager

Used Data Load editor to modify and load data from various data sources

Created dimensions and measures

Developed Dashboards using different Qlik sense charts like Line Chart, Bar Chart, Pie Chart, Combo chart, Scatter plot chart and Gauge chart

Used Pivot tables for representing the multiple dimensions in the analysis of data

Developed graphs to summarize the outlying data points to perform exploratory data analysis

Used Filters so that the data can be analyzed based on different dimensions

Used Set Analysis to provide the custom functionality and aggregation calculations

Used KPIs with set modifier to give the snapshot summary of aggregations

Used bookmarks to save the filtered data for future reference

Used storytelling features to help transform raw data into a compelling story that communicates insights, trends, and patterns effectively

Tested the dashboards by searching the data points using Associative search and smart search

Environment: Qlik Sense, MS SQL Server and MS Excel

Contact this candidate