Seshadri Pullannagari

I have a 4.8 years of experience in Power BI Desktop, Power BI Service, SQL Server, and SSAS Tabular Model,ADF I have gained expertise in creating various custom visualizations such as Bullet Chart, Chiclet Slicer, and Gauge Chart, as well as default charts like Lines, Pies, Tree Map, Slicer, Bar Chart, and Funnel Chart in Power BI. My experience also includes data modeling in Tabular Model using SSAS and creating partitions at the cube level. Additionally, I am skilled in implementing filters, slicers, and various charts to develop interactive Power BI Dashboards and Reports for business users. I am proficient in using Data Gateway to view dashboards in the Power BI Mobile version. In Power BI Desktop, I excel at extracting Date functions in Edit Query and creating data models for reports. Furthermore, I have expertise in creating and utilizing different types of filters such as page level, visual level, report level, and drill-through filters. I have also utilized the Time Series Wizard to compare results between previous and current time periods. Importing data from multiple sources into BI Tools and establishing relationships between data is another area of my proficiency. I have created calculated columns and measures using DAX Query. Moreover, I have designed accurate Data Models and added calculated DAX measures on top of datasets as required. In terms of database administration, I have experience in server monitoring using SentryOneTool, executing change requests on production servers, providing different permissions to users based on client requests (logins), creating server-level database jobs, and scheduling jobs based on client requirements. Additionally,i have supporting knowledge of Azure Data Factory.

1.Project Name                          :   HUL (Product Procurement)

   Client                                        :   Unilever

   Environment                           :   PowerQuery, Power Bi Desktop, Excel, SharePoint,SSAS, SQL Servers

   Databases                              :   SQLServer

   Role                                           :   Power BI Developer

Project Description: Unilever is a multinational consumer goods company that produces food, beverages, cleaning agents, and personal care products. It was founded in 1929 when the British soap maker Lever Brothers and Dutch margarine producer Margarine Unis merged. Unilever has around 400 brands, including 11 "billion-dollar brands, " each achieving more than €1 billion in annual sales. Unilever's brands operate in five business groups

Responsibilities:

· Involved in client interaction and in developing and supporting the reporting application.

· Created and Managed OLAP Cubes using SSAS

· Involved in designing cubes in the SSAS environment using Snowflake and Star Schemas

· Ensure timely delivery & quality of delivery by adhering to Quality Processes.

· Involved in working with complex data types.

· Work closely with business stakeholders to understand their requirements and translate them into technical specifications in BRD.

·  Connect Power BI to various data sources (e.g., SQL databases, Excel files, cloud services).

· Implement ETL (Extract, Transform, Load) processes to integrate data from multiple sources.

· Data Transformation: Use Power Query and DAX (Data Analysis Expressions) to transform and aggregate data.

·  Create and manage data models to ensure data is organized and optimized for reporting.

·  Create visually appealing and insightful charts, graphs, and other visual elements to represent data

·  Design and develop interactive reports and dashboards using Power BI.

·  Manage and automate data refresh schedules to keep reports up to date.

·  Implement data security measures, including row-level security and data masking.

2.Project Name  :  Factor AI

   Client               :  IntelliTide

  Environment    :  PowerBI, Powerbi Service, Sharepoint,Power Query

  Database          : SQL Server,Sharepoint, Excel

  Role                 :  BI Developer
Project Description: IntelliTide is a Houston, Texas-based company that provides data management, analytics, and digital transformation solutions to businesses. Their services include Product information management and master data management, AI and business intelligence, and Enterprise applications

Responsibilities:

· Responsible for defining the scope of the project, gathering business requirements, and doing analysis and documents.

· Importing the data from data sources and preparing the data as per user requirements.

· Having experience in Power Query to transform the data within Power BI

· 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 page level filters and report level filters as per reporting needs.

· Expertise in various visualizations like donut charts, Pie charts Bar graphs, Tree maps waterfall charts, and Card Visualizations.

· Developed custom report tooltips 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 the Power BI server and providing access to required users.

· Installing and configuring Data Gateway to pull data from on-premises databases

3.Project Name    :  RFA Internal projects (AIRE, RFA Operational)

   Client                :   RFA

   Environment    :   PowerBI, Powerbi Service, Sharepoint, Power Query

   Database           :  SQLServer,

   Role                    :  Power BI Developer

Project Description: RFA has evolved into an institutional-quality IT, financial cloud, and cyber-security services provider to the investment management sector. We take pride in redefining the future of technological support. Through our R&D, DevOps, automation, and machine-learning capabilities, RFA provides clients with customized workflow and IT strategies to bring tomorrow’s edge, today. Serving over 800 clients across seven global locations, RFA brings together a seasoned executive team and over 200 highly skilled consultant technicians to provide clients with best-in-class technology solutions and automated business processes, supported by expert staff 24/7/365.

Responsibilities:

· Connecting to the data from SQL Server and different data sources.

· Experience in Importing Power BI reports from the Power BI Desktop to the Power BI service.

· As per the client's requirements, rendering the Reports in the form of Excel formats.

· Good at Sharing the dashboards & providing the security of the Power BI reports and Exporting /analyzing the data to Excel.

· Extensively used for Bookmarks and Selection pane to show all the visuals on a single page.

· Installed and Configured Power BI Gateways to keep the dashboards and reports up to date by scheduling the Refresh

· Creating a Drill down and Drill through Reports.

· Implemented RLS (Row Level Security) for the reports.

· Created calculated columns to simplify the data.

· Working on DAX functions like Date &Time, Information, Filter &Value, Logical, and Text functions.

· Prepared weekly status reports and shared with the onsite managers.

· Working on MS SQL Server and writing queries to pull the data.

· Created database objects such as tables, views, and indexes.

· Written logical SQL queries using joins, and subqueries.

4.Project Name         : TowerBrook Capital Partners (U.K.) LLP

   Client                        :  RFA

   Environment           : PowerBI, PowerBi Service, Sharepoint, Power Query

   Database                  : SQLServer, Excel

   Role                         : Power BI Developer

Project Description: TowerBrook Capital Partners (U.K.) LLP operates as an investment management firm. The Company invests in healthcare, auto, food, oil and gas, mining, and insurance sectors. Towerbrook Capital Partners operates in Europe.

Responsibilities:

· Involved in developing User-friendly Screens By using the Power App

· Preparing the Table schemes by using the Dataverse Database

· Implemented different types of reports using Power BI desktop, like vertical and cross-tab reports and dashboards

· Created Slicers in Power BI

· Reports using Power BI desktop which includes drillings, sorts, etc

· Created filters and apply conditional formatting based on the user requirements.

· Worked on measures and columns in Power BI Desktop.

· Involved in scheduling the reports using Enterprise Gateway.

· Ensure timely delivery & quality of delivery by adhering to Quality Processes.

5.Project              :   AIM Specialty Insurance

   Client                :   AIM Specialty Health, USA

   Environment    :  Power BI, PowerQuery,Power Services

   Database          :  SqlServer ,SSAS

   Role                    :  Power BI Developer

Project Description: AIM Specialty Health provides clinical solutions that drive appropriate, safe and affordable care. Serving more than 50 million members across 50 states, D.C., and US territories, AIM promotes optimal care through use of evidence-based clinical guidelines and real-time decision support for both providers and their patients. Our platform, featuring a sophisticated clinical rules engine from Applied Pathways (a wholly owned subsidiary of AIM), delivers significant cost of care savings across an expanding set of clinical domains, including radiology, cardiology, oncology, specialty drugs, sleep medicine, musculoskeletal care, and genetic testing.

Responsibilities:

· Implemented different types of reports using Power BI desktop, like vertical and cross-tab reports and dashboards

· Created Slicers in Power BI

· Reports using Power BI desktop which includes drillings, sorts, etc

· Created filters and applied conditional formatting based on the user requirements.

· Worked on measures and columns in Power BI Desktop.

· Involved in scheduling the reports using Enterprise Gateway.

· Ensure timely delivery & quality of delivery by adhering to Quality Processes.

• Developed over 50 reports and dashboards resulting in a 30% increase in operational efficiency.
• Collaborated with cross-functional teams to identify data sources and streamline data collection resulting in a 25% reduction in report development time.

PL-300