Naga Tejaswi

Having 2.7 years of experience as a POWER BI Developer and SQL Server 2022. Having 1.7 years of experience as MIS Executive (Non-IT). Used various sources to pull data into Power BI such as SQL. Server,Excel.Transforming data into power query editor for cleaning and modifying. Providing relationships between data sets in power pivot for creating structured data which help in visualization. Expert knowledge in creating Drill through reports, Drill down reports, Parameterized reports. Created Dashboards with different styles using Power BI components like Pie charts, Bar charts, Line, KPI Visuals, etc. Wrote calculated columns, Measures queries in power bi desktop to show good data analysis techniques. Good knowledge of various DAX functions of Power BI technology. Automated Power Query refresh using Gateways. Published reports into Power BI publisher and scheduled the data sets, providing row level security. Created Workspace and content packs for business users to view the developed reports. Scheduled Automatic refresh and scheduling refresh in power bi service. Weekly presentation to the business users about the reports and their changes as required. Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily. Worked on all types of transformations that are available in Power bi query editor. Environment: SQL Server 2012/2008 R2/2008, T-SQL, Power BI. Mainly using VLOOKUP and pivot tables and filters for generating reports Preparing daily reports and sending to the banks which related to LIC policies of the customers in Karvy

Project #1 : Wipro - GSK Data & Analytics

Role : Power BI Developer

Environment : Power BI, SQL Server.

• Involved discussion with business users for gathering the requirements and driving daily call with clients and Translating End- User requirements into Efficient Dashboards.Knowledge on DAX creating Measures and Calculated Columns and used diff types of slicers. Import data from different data sources to create Power BI Reports and Dashboards.Developed and maintained multiple Power BI dashboards/reports and content packs. Knowledge on Power Query Lists, Tables and Records.Able to design complex queries for Power BI Report Visualizations.Creating, developing, and deploying data reports and dashboards for large volumes of data in Power BI. Implement Row Level Security (RLS) as per requirement. Develop Visual Level Filters, Report Level Filters, and Page Level Filters in Power BI.Scheduled Automatic refresh and scheduling refresh in Power BI service. Publishing reports to Power BI server and providing access to required users.

Project#2 : Imperial Oil

Role :Power BI Developer

Environment : SQL Server, Power BI

Involved with business users for gathering the requirements & calls with clients. Experienced in Developing, Implementing, Documenting, Monitoring, and maintaining the Data Warehouse Extracts, Transformations Load.Experience with creating reports and dashboards using Power BI.Connected MySQL to created Power BI reports- Matrix, Bar Charts, Line Charts, Pie Charts, Donut Chart and stacked Bar Chart etc. Created Dashboards apply the filters Drill through & Drill Down functions and created tooltip on sheet level as per requirement. As per the data we are using Aggregate Functions and Filter Functions and Time & Date Functions and Logical Functions using Data Analysis Expressions (DAX).Creating Calculated Columns and Measures with DAX.Created Bookmark Pane applies to the actions on view details and Text/ Matrix Tables.Implement Row Level Security (RLS) as per requirement. Experience in Publish of Power BI reports to Power BI server.