Role : BI Developer

Environment : Power BI, SQL Server, Excel, SSAS

Period : April 2020 to till date

The Procter & Gamble Company is an American multinational consumer goods corporation headquartered in Cincinnati, Ohio, founded in 1837 by William Procter and James Gamble.

The scope of this project was to generate timely reports based on these reports performance, profitability, revenue, notifications of key business issues and many more that will help identify the profitability of the institution at various levels. We used to pull the data from various sources like excel, flat file and from other sources and load into our database by using daily scheduled jobs.

Responsibilities:

Involved in configuring gateways and performing schedule refresh for dashboards.

Involved in importing data from developed excel into power bi desktop using get data option.

Implemented Visual Level, Page level, report level filters and pinning in dashboards.

Written simple DAX calculation as per the requirement to maintain business measures.

Worked on report permissions and dashboard permissions to provide access to different users.

Used Quick insights to get various types of visuals to match the requirements.

Experience on relationship tab to provide cardinality between fact and dimension tables.

Involved creating effective reports, dashboards, and publishing into Power bi service.

Creating the roles for the dashboards, sharing the developed dashboards to the client in power BI

Experience in creating content pack library for sharing the dashboards and reports to the colleagues.

Involved in pinning the dashboards and sharing the developed dashboards to the client.

Shared dashboards with various users across business based on their country level applied roles to restrict data to specific region.

Created visual interactions using edit interactions to make few visual to effect data based on requirement.

Worked on manage relationships to make all tables have active relations in between fact and dimension tables.

Role : BI Developer

Environment : Power BI, SQL Server, Excel

Period : March 2019 to April 2020

Henkel is a German chemical and consumer goods company headquartered in Dusseldorf, Germany. It is a multinational company active both in the consumer and industrial sector. Founded in 1876, the company is organized into three globally operating business units (Laundry & Home Care, Beauty Care, Adhesive Technologies) and is known for brands such as Loctite, Persil, and Fa amongst others.

Responsibilities

Created different types of reports and dash boards using Power BI.

Created dashboards using Power BI Desktop which includes drillings, sorts etc.

Created Filters and apply conditional formatting based on user requirement.

Created scheduling the reports using Enterprise Gateway.

Created Slicer and measures and columns in Power BI Desktop.

Ensure timely delivery &quality of delivery by adhering to Quality process

Role : Power BI Developer

Environment : Power BI, SQL Server, Excel

Period : March 2018 to February 2019

Myer is a retail chain of discount stores operating in Australia. Myer has more than 130 stores Australia. The main aim of the Project is for extracting the data from different sources and transforms the data by using Integration Services transformations and loading into Data Warehouse. This is a data warehousing application made for the analysis and reporting purpose of the sales and marketing company. The dimensional modeling used in this project is star schema.

Responsibilities

Understand Report Specification Document and designing the reports based on Report Specification document which meets the client requirements.

Understand Requirement, Analyzing Systems and Source Databases.

Experience with creating reports and dashboards using Power BI.

Connect to multiple datasets to bring all the relevant data together in one place and create reports that provide a consolidated view of the different sources.

Connected Impala Data base & SQL Server database to created Power BI reports- Matrix, Bar Charts, Line Charts, Pie Charts, Donut Chart, and Bubble and stacked Bar Chart etc.

Creating Report level apply Report, Page level filters in power bi.

Created Bookmark Pane applies to the actions on view details and Text/ Matrix Tables.

Created Data modeling, calculated fields like Periodic Calculations and Aggregate Calculations.

Created and Designing on Dashboard Formatting, Alignment, Add Images, Shapes and Reset Button

Created Dashboards apply the filters Drill through functions and created tooltip on sheet level as per requirement

Experience in Publish of Power BI reports to Power BI service.