OnBenchMark Logo

Chaitanya

Software Engineer
placeholder
Location Hyderabad
view-icon
Total Views39
availability
Shortlist0
back in time
Member since30+ Days ago
 back in time
Contact Details
phone call {{contact.cdata.phone}}
phone call {{contact.cdata.email}}
Candidate Information
  • User Experience
    Experience 4 Year
  • Cost
    Hourly Rate$6
  • availability
    AvailabilityImmediate
  • work from
    Work FromOffsite
  • check list
    CategoryInformation Technology & Services
  • back in time
    Last Active OnMay 07, 2024
Key Skills
SQLPower BISQL Server
Summary

Project #1:

 

Project Name   : AIG

Client                 : American Insurance Group, USA      

Role                   : Power BI Developer

Environment    : Power BI, SQL Server

Duration            : Feb 2022 to till date

 

 


Description:

 

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).

 

 


Responsibilities:

 

*      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

 


Descriprtion:

         

            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.

 


Responsibilities:

 

*     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 

Copyright© Cosette Network Private Limited All Rights Reserved
Submit Query
WhatsApp Icon