Durga Rao J

• Having around 4 Years 08 months of Professional IT Experience with Business Intelligence tools like Power BI (Power BI Desktop and Power BI Service, Power BI Report Builder), IBM Cognos, Tableau and Database like SQL Server(MS-SQL) and ETL Tools like Informatica and Azure Data Factory(ADF).
• Good knowledge on Data Modeling to model the data as per business requirements to build Schema.
• Expertise in importing data from multiple data sources into Power BI using Live Connection as well as Import data connectivity mode and Direct-Query data connectivity mode.
• Used different Categories of DAX functions for Data Preparation like Calculated columns, Calculated measures and tables.
• Worked on On-Premises Data Gateway to Refresh and Schedule Refresh the Data in the dataset by configuring, connecting and assigning these gateways.
• Good knowledge on Data Warehousing Concepts, Normalization of tables using Primary Keys & Foreign keys with Dimensional data modeling,
• Experience in Creating APP Work spaces and adding the Members to APP Workspace to Manage the Content in Power BI Service.
• Valuable experience in various filters like Report level, Page level , Visual level , Drill through filters and Handling different types of Visual Interactions.
• Experience on creating Hierarchies to create flexible Drill-Down reports, Parameters, Buttons and bookmarks to change the output in the reports dynamically.
• Expertise in Creating Data Visualizations like Matrix, Table, Charts, Gauge, Cards, Trend charts, KPI's and Maps.
• Implemented and assigned Row level security (RLS) by restricting the users for the data access.
• Creation of Dashboards by extracting the high level visuals from multiple reports and Dataset refresh using gateways.
• Experience in sharing the Reports and Dashboards with End Users.
• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution

From: Dec 2019 to Nov 2020
Role: Technical Member
Client: Bayer
Project Description:
Bayer is a Life Science company with more than a 150-year global history and core competencies in the areas of agriculture and healthcare with their innovative products, by contributing to finding solutions to some of the major challenges of time, and Scores of pharmaceuticals, dyes, acetates, synthetic rubbers, plastics, fibers, insecticides, and other chemicals.
RESPONSIBILITIES:
1.Developed Interactive Power BI reports, visualizations with drill-down reports and dashboards with both Web & Mobile supported layouts as per the business requirements.
2.Used Filters to generate Drill through and Drill down reports, slicers for drop down option to filter the data on-canvas.
3.Uses different types of DAX functions to create various measures, columns and use of advance calculations for reports
4.Usage of visualizations like tree map, cards, Pie and donut charts, clustered bar and column charts, ribbon chart for effective business decisions.
5.Scheduled the data refresh for dashboards and reports using Data Gateways to show the live data
Hands on experience of Creating Data Models as per report requirements

From:- Jan 2021 to Dec 2022
Role: Power BI Developer
Client: Tesco PLC
Project Description:
Tesco Plc (Tesco) is a multinational retailer of general merchandise. The company carries out business through multi-format stores and online. It operates stores in various formats differentiated by size and range of products sold, including large, small, dotcom only and one- stop. Dynamically drill into your customer sales data and reveal instant insights to drive decision making and resource allocation. This project helps to analyze the business transactions and information.
RESPONSIBILITIES:
1.Participated in requirements meetings and Scrum Calls to understand the Report Requirements.
Involved in Identification and Documentation of detailed business rules.
2.Used Power Query / Query Editor for Data transformation/Data Cleansing as per the reporting needs using Mashup language.
3.Created Data Model in Power Pivot by Establishing the Relationship Between the tables by deriving the data to Fact & Dimension tables using Primary & Foreign Keys.
4.Created New information on top of the data model like New Columns and New Measures over data models for the purpose of enhancing Power BI visuals using DAX.
5.Developed at least two - three visual options for each report for discussion with stakeholders and customers.
6.Created Hierarchies and Drill down Reports.
7.Installed and Configured Data Gateways to Refresh and Schedule Refresh the Dateset.
8.Managed access of Reports, Dashboards and Data for individual users using roles.

From: Jan 2023 to Dec 2023
Role: Power BI Developer
Client: HOSPIOL
Project Description:
Hospiol is a Hospital Management System (HMS), a hospital information system is a software solution that helps a hospital or medical care facility to manage its operations. In other words, it is an integrated solution that helps and manage hospital resources and function efficiently by integrating multiple hospital departments into one single network
RESPONSIBILITIES:
1.Analyzing Source data and understanding the business requirements and involved in data collection from multiple data sources by writing SQL queries.
2.Involved in Data Cleansing activites by using Power BI Inbuilt ETL tool known as Power Query using Mashup language for minimal Transformations and pushed the overal major transformations into SQL database to maintain Query folding.
3.Created calculated columns and measures using DAX based on business need.
Constructing or ensuring appropriate Data Model/ Schema before report development for Better Performance of Report.
4.Building and generating Interactive reports with the help of Power View and Power BI Service and also involved in creating effective interactive reports like drill down reports & dashboards, and publishing into Power BI Service.
5.Created reports with various visualizations required and implemented business logic's & Row level security.
6.Involved in database design, creating tables, writing stored procedures.
7.Involved in UI Changes in the Dashboard Reports based on the client requirements and also involved in the requirement analysis, documenting requirement specifications.
8.Published/shared the reports by creating a App Workspaces in app.powerbi.com and sharing this Apps with end users.

From: Feb2024 to Present
Role: Power BI Consultant
Client: ADP India Pvt.Ltd
Project Description:
ADP is a comprehensive global provider of cloud-based Human Capital Management solutions and Business Process Outsourcing (BPO) services, analytics and compliance expertise
RESPONSIBILITIES:
1.Analyzing Source data and understanding the business requirements and involved in data collection from multiple data sources by writing SQL queries.
2.Creating a Query for Data cleansing using the Query Editor Window in Power BI by using Mashup language.
3.Constructing or ensuring appropriate Data Model/Schema before report development by connecting the data from different sources like on-premise sources and also cloud sources like SharePoint for Better Performance of Report.
4.Created calculated columns and measures using DAX based on business needs.
Building and generating Interactive reports with the help of Power View and Power BI Service.
5.Involved in creating effective reports, drill down reports & dashboards, and publishing into Power BI Service.
6.Created reports with various visualizations required and implementing business logic's & Row level security.
7.Involved in database design, creating tables, writing stored procedures.
8.Made UI Changes in the Dashboard Reports based on the client requirements.
9.Involved in the requirement analysis, documenting requirement specifications with Product specialist, Team Members.
10.Involved in importing data from SQL Server into power bi desktop using get data option by writing SQl queries with multiple connectivity modes like Import and Direct query as per the requirement.
11.Published/shared the reports by creating a App Workspaces in app.powerbi.com and sharing this Apps with end users.
12.nvolved in UAT of reports and Bug fixes and provided support for both existing reports and new power bi reports.
13.Involved in Migrating the reports from other BI tools like SAP BO and Tableau into Power BI by understanding the logics in the both and implemented the same in Power bi.

I hereby declare that the information mentioned above is true to the best of my knowledge