Sai Kiran Arva

Sai Kiran Arva

Power Bi Developer
India

About Me

A highly motivated Business Intelligence (BI) Professional with 4 .8 years of relevant experience in PowerBI out of total 4+ yrs experience in IT industry. Extensive experience in the design, development, implementation,…

Experience

Software Developer

Innosoft Datalinks Pvt Ltd
Dec 2019 - Present · 6 years 6 months

My roles and responsibilities is data validation testing to prepare test case document and involved in role level security as user also see their data. I have created complex reports and implemented parent child hierarchy security also. I have also involved in l1 l2 and administration supporting activities in my current project.

Software Engineer

Inosoft Datalinks Pvt Ltd
Dec 2019 - Present · 6 years 7 months

Worked as a Software Engineer in Inosoft Datalinks Pvt Ltd from December 2019 to till date.

Power BI Developer

Carlsberg
Dec 2019 - Feb 2022 · 2 years 2 months

Create and develop Power BI visuals and data models as required.
Building Power BI dashboards and doing ad hoc reporting.
Experience in developing Visualization reports using Power BI as per client requirement.
Visualize data, author reports Publish and schedule automated refresh of reports.
Using DAX for Power BI Reports.
Designed the Reports with Conditional formatting.
Created calculated columns to simplify the data.
Prepared Weekly Status Reports and shared with the Onsite Managers.
Created Named Calculations and Named Queries in the Data Source view based on business requirement
Created Dimensions, Measure Groups with Custom formats.
Good experience on Sorting Attribute by another attribute based on requirement
Created Named Sets using MDX Expressions
Created Calculated Measures and maintaining using folders in the Cube
Added new dimension, new partition or new business logic to existing SSAS Cube
Created MDX Queries to pull data for SSRS reports
Created Parameterized, Cascading and Drill Through Reports and Drill Down and Sub Reports .

Cognos BI migration to Power BI Developer

American Insurance Group, USA
Mar 2022

Develop and maintain Tables, Views, and Queries in SQL server as data sources for Power BI reports.
Created Dashboard Reports to display multiple reports in single page.
Transform and model data to create interactive visualizations that provide insights into the organization' Confidential data with Power BI Desktop.
Create and optimize advanced queries, data models and report designs to standardize dashboards throughout the organization.
Configure and maintain Power BI service (app.powerbi.com) to share content with business users.
Publish the reports into Power BI service by creating and managing app workspaces and apps.
Configure and manage Premium Capacity in the Power BI service to share apps to the business users.
Install and maintain On-premises gateway to provide secure data transfer between on-premises data and the Power BI service.
Assist and Train other developers in accessing the enterprise gateways.
Implement an efficient refresh process using REST API instead of the traditional Scheduled Refresh process.
Upgrade legacy workspaces to new workspaces for better management of content access.
Create more centralized datasets in order to reuse the existing datasets in the service thereby avoiding the refresh of duplicated datasets.
Carry out various Power BI service administrator activities such as configuring governance policies, creating and managing security groups, monitoring usage metrics for dashboards/reports, auditing Power BI logs using 0365 Security & Compliance Center, and provisioning of licenses, capacities, and organizational resources.
Participate in different levels of Testing (Unit testing, QA testing and UAT testing) to deliver quality data in the Dashboards.
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.
Created various Customized and interactive Reports and Dashboards in Power BI.
Publishing reports to Power BI server and providing the access to required users.
Installing and configuring Data Gateway to pull data from on-premises databases
Having experience in Power Query to transform the data within Power BI.
Created Bookmarks to move from one page to other page based on requirement like moving forward and backward navigation.

Skills

Application Programming Interface (API) C++ Language (C++) Java JavaScript Development Jira Oracle Python Scrum Software Engineering Web Service Database GIT Version Control (GIT) LINUS Procedures Jenkins Power BI Power BI Desktop Power BI Service Power Query DAX SQL M queries MDX SSAS Tableau Microsoft Excel Cognos BI 11 Analytics ServiceNow Windows 7 Windows 10 Azure Database Azure Data Factory REST API DAX Studio ETL Data Modeling Dimensional Modeling Star Schema Snowflake Schema Tabular Data Models Data Visualization Dashboard Development Report Development Data Warehousing Unit Testing QA Testing UAT Testing Security Groups User Permissions Premium Capacity On-premises Gateway Power Pivot Conditional Formatting Drill Down Drill Through Sub Reports Parameterized Reports Cascading Reports Stored Procedures Triggers Functions Indexes Views Tables
Report this Profile?