Project Name : AIG
Client : American Insurance Group, USA
Role : Power BI Developer
Environment : Power BI, SQL Server
Duration : Feb 2022 to till date
American Insurance Group, Inc. - also known as AIG - is an American multinational insurance corporation with more than 88 million customers in 130 countries. AIG companies employ over 64,000 people in 90 countries. The company operates through three businesses: AIG Property Casualty, AIG Life and Retirement and United Guaranty Corporation (UGC).
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.
Project#2:
Client : Carlsberg
Role : Power BI Developer
Environment : Power BI, SSAS, SSRS, SQL Server
Duration : May 2020 to feb 2022
Hybrid BI system is introduced to deliver commercial reporting and analytics for western Europe countries .Our user base will consist of sales reps, sales managers and commercial back-office users including controllers. The project includes zone wise reports of sales, employee and product details. The margins and annual growth is to be compared in a period of time.
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