Power Bi Developer

SAMUEL GENJI Phone:+91-814*******

Power BI Developer Email:***********@*****.***

PROFILE SUMMARY

Having Total 3.8 years of experience in Power Bi developer(Power Query Editor,DAX,Power BI Service).

Having experience in Power BI, Fabric BI Support and admin activities.

Having Knowledge on Tableau, Power BI Report Builder.

Having good experience in gathering data from different data sources like SQL and Excel, import into Power BI Desktop.

Having good experience in extracting the datasource Direct and Import mode.

Having good experience in Power Query,Power Pivot,and Power View for creating Effective reports and dashboards in Power BI.

Good expertise in Power query level Merge and Append Query operations.

Having good experience in the Datamodeling part i.e. resolving many-to-many relationships.

Good experience in creating a visual like Stacked bar charts, Clustered bar charts, lines, pie charts, donut charts, cards, multi-cards, tables, and matrices.

Created a forecasting dashboard integrating Tableau with Python, enabling accurate revenue predictions.

Implemented row-level security and user-level permissions on Tableau Server to ensure data confidentiality.

Used DAX expressions like Logical,Aggregate,and Time Intelligence & Date Functions to create business Calculations based on requirements.

Worked on visual interactions using edit interactions to make a few visual effect data based on the requirement.

Migrated legacy Excel reports to Tableau, streamlining reporting processes and increasing data accuracy.

Publishing the reports into PowerBI Services and sharing the dashboards with the Users.

Having good skills in troubleshooting On-Premises Gateway to refresh the dashboards and reports. Good exposure to SQL.

Hands-on experience in the implementation of Common Table Expressions(CTE).

Implementation of Rank functions,Temporary Tables,Table variables,and String functions.By using SQL server agent scheduling the SQL jobs.

PROFESSIONAL EXPERIENCE

Working as a Power Bi Developer in Cognizant from February 2022 to till today

Reporting Tools:

Reporting Tools : Power BI Desktop, Tableau, Microsoft Excel, SSRS, SSAS,ETL.

Database : SQL Server

ETL Tools : Power Query / Power BI/Power BI Service, Dax.

Technical Skills : PowerBI, Tableau, SQL,DAX,SSRS,SSIS,, AdvanceExcel,

Python,Snowflake,Data Ware House Concepts,Visualization & Dashboards.

EDUCATION

B.sc (Computer Science) in Andhra University,Visakhapatnam in 2021 .

PROJECTS

Project #2:

Project : United Healthcare Insurance Reporting.

Client : United Healthcare

Environment : Power BI, SQL Server,Dax, Power Query

Role : Report Developer

Duration : June 2024 to Till Date

Description :

United Healthcare Insurance company selling insurance and financial products through independent insurance agents and financial advisors nationwide. United Healthcare offers a comprehensive mix of products that help individual; organizations and companies protect the things they value and profit from financial opportunities. United Healthcare products include auto, home, life and business insurance. investments such as mutual funds, annuities and stock purchase plans, retirement plans for businesses, trust services, and surety bonds

Roles &Responsibilities:

Perform ETL activities and data modeling using Power BI.

Run created SQL script to get data updated in the SQL server.

Creating multiple pages of interactive report based on requirement given by Stakeholders and publishing into service workspace. Creating dashboard for easy access of executive summary and other key metrics

Created dashboards integrating Tableau with live database connections, helping optimize stock levels and reduce waste by 25%.

Created conditional formatting to show table visually.

Creating Top 10 accounts, YTD, YOY growth and Plan comparison with previous year for all available metrics using DAX computed measures and columns.

Designed dashboards for retail outlets to monitor daily sales, customer traffic, and conversion rates, enhancing decision-making for store managers.

Debugging the report issues and solving them if any error occurs on new refresh.

Creating deep insights to analyze and increase the headcount and hours contribution by pillars.

Creating drilldown, drill through, Page navigation, bookmark, selections, actions, multiple filters, sync slicers and visual interactions to give better data analytics with the available data.

Analyzing the report performance using performance analyze and fixing the laggings.

Granting report and workspace access basis requirement in Power BI Service.

Frequency of scheduled data refresh will perform on weekly basis using SQL Server

Project #1:

Project : Sales and Services

Client : LLC group, USA

Environment : Power BI Desktop, Dax, Power Query, Power Pivot, Tableau

Role : Power BI Developer

Duration : Feb 2022 to May 2024

Description:

LLC is a producer of quality aluminum ladders and custom access solutions. We produce a variety of flatbed truck ladders including the Trucker, a portable ladder that can be customized for a variety of trailer applications. The management wants to analyse the data using power bi reports. Here we need to develop dashboard reports as per user requirement.

Roles &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.

Designed Tableau dashboards to track carbon emissions and energy usage, supporting sustainability initiatives.

Created Dimensions, Measure Groups with Custom formats.

Good experience on Sorting Attribute by another attribute based on requirement.

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.

(SAMUEL GENJI)

Place: Hyderabad

Contact this candidate