OnBenchMark Logo


Software Engineer
Location Hyderabad
Total Views39
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
  • work from
    Work FromOffsite
  • check list
    CategoryInformation Technology & Services
  • back in time
    Last Active OnMay 07, 2024
Key Skills
SQLPower BISQL Server

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





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.







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 

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