Talent's Information
-
Location
Bengaluru, India
-
Rate
$10.0 per Hour
-
Experience
4 Year
-
Languages Known
English,Hindi
Available for
About Govardhan J
4+ Years of Professional IT Experience with Business Intelligence tools like Power BI Desktop, Power Query Editor and Power BI Service.
Proficient on administrating SQL Server by creating database, providing the login and permission to developers.
Proficient on SQL Queries like Functions, Store Procedure's, Joins, Indexes, creating tables with constraints, Views and CTE.
Proficient with ETL processes and tools and the ability to extract, transform, and load data from different sources into Power BI.
Proficient in writing SQL queries for testing and retrieving data, including stored procedures, functions, joins, indexes, views, and CTEs.
Proficient designing and developing Power BI reports and dashboards using Azure Synapse, Zuul, and SQL as a data source.
Proficient in extracting the data from various data sources by using various types of connection modes like Import, Direct Query and Live Connection modes.
Participating in the full software development lifecycle, including requirements gathering, design, development, testing, and deployment.
Proficient in extracting the data from various data sources into Power BI desktop and worked on all type of transformations that are available in Power Query Editor and to generate Reports and Dashboards.
Proficient in analytical thinking for translating data into informative visuals and reports.
Proficient in using Power BI Filters, Edit interactions, Drill through, Manage Parameters, Groups, Hierarchies, Conditional Formatting and Custom visuals.
Proficient in strong Technical skills in Power BI Desktop and Power BI Services, especially expertise in Power BI Data Modelling and DAX Functions, Those functions are useful to analysis business trend.
Proficient on developing visual reports, KPI scorecards, and dashboards using Power BI desktop.
Proficient in creating Bookmarks by using Bookmarks pane and Selection pane as for the requirements and also experience in creating buttons and navigations.
Proficient in using publish option publishing our reports to Power BI Service into the workspaces and sharing with end users.
Proficient on applying Row Level Security (RLS) and Configure target workspace with Management Gateway to refresh and schedule refresh the Data in the Dataset.
Proficient knowledge about setting subscriptions, alerts, refresh schedules.
Experience with complex, high volume, multi-dimensional data based on unstructured, structured, and streaming datasets.
Experience in the technical implementation of analytics with Power BI Technology.
Proficient on building a wireframe using Power BI Templates will give the design to end-users or project owners.
Excellent communication skills and be able to collaborate effectively with both technical and non-technical stakeholders to understand their reporting needs and provide recommendations on how to best use Power BI to achieve their goals.
I have excellent presentation, Strong interpersonal skills, strong troubleshooting and organization skills.
Work Experience
Power Bi Developer
- January 2019 - April 2023 - 4 Year
- India
Projects
American Multinational Telecommunications.
- March 2021 - March 2023 - 25 Months
-
AT&T operates as a carrier of both fixed telephone and mobile networks in the US and also offers telecoms services elsewhere. It is the largest telecoms operator in the world by revenue.
RESPONSIBILITIES:
Involved in reviewing business requirements and analysing data sources from Excel/SQL Server for design, development, testing of reporting and analysis projects within Power BI Desktop.
Created new sets added and removed data using the tooltip, combined and compared multiple sets.
Created Power BI scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
Used a variety of new Quick Filter options to display the values as drop-down lists, sliders searches.
Experienced in advanced features of Power BI such as calculated fields, parameters and sets to support data analysis and data mining. Tested Dashboard for data accuracy and functionality.
Involved in creating dashboards and reports in Power BI.
Retail Management Services.
- May 2019 - March 2021 - 23 Months
The main aim of developing this automation retail management system is to bring the customers into the store and fulfil their buying needs. In simpler words, automated retail management software application helps customers to shop and retailers to do business without any difficulty.
RESPONSIBILITIES:
Excel data-sets and gave overview to client.
Wrote SQL quires based on tables and created views.
Import Data from SQL Server to Power BI and created relationships based on requirement.
Created new calculated column, Measure and Calculated tables.
Worked on DAX functions like aggregated functions, Filter functions, Iterate functions, Mathematical functions, Text functions and Time Intelligence functions.
Used Bar chart, Line chart, Card, Matrix and Tables for better visualization.
Worked on custom visualization like Multi slicer and Hierarchy slicer.
Worked on Bookmarks Pane and Selection pane for multiple report visualization in single page.
Implement Row Level Security on require reports and given to permissions.
Logistics Management.
- November 2018 - May 2019 - 7 Months
-
Lineage Logistics is an international warehousing and logistics company owned by Bay Grove, LLC. As the world's largest refrigerated warehousing company, it has around 200 facilities in North America, Europe and Asia.
RESPONSIBILITIES:
Involved in collect the technical specification document and data analysing the user requirement.
Connected data from excel datasets designing, developing and implementing power bi reports.
Crafting and executing queries upon request of data.
Worked on the measures according to the business logic in power bi desktop using data analysis expression.
Worked on DAX functions like Logical functions, String functions, Text functions and Time Intelligence functions.
Creating various visuals like bar chart, column chart, line chart, combo chart, waterfall chart, funnel chart, scatter chart, pie chart, Donut chart, tree map chart gauge, card, slicer and so on.
Worked on the Visual level filter, Page level filter, Report level filter and Drill through level filter.
Creating interactivity between the users and dashboards with the help of slicers and interactions to compare the data against different views.
Publishing reports into Power BI Services and worked on creating Dashboard by pinning visuals of the reports.
Soft Skills
Industry Expertise
Education
Computer Science - in B SC
Karnataka University- June 2014 - June 2017
