Talent's Information
-
Location
Ahmedabad, India
-
Rate
$12.0 per Hour
-
Experience
5 Year
-
Languages Known
English,Hindi
Available for
Background Verification
40 Hr/Week
About SHIVAKUMAR
I wish to take up a challenging position in the IT industry in the Software Development field where my knowledge, Skills and experience are of value, and where it shall be enhanced and utilized to the highest degree.
Tech Stack Expertise
-
Oracle
Oracle SQL
1 Years
Work Experience
Power Bi Developer
- January 2019 - February 2023 - 4 Year
- India
Projects
Sweep Analysis- AB-Inbev
- January 2019 - January 2020 - 13 Months
Technologies
Role & Responsibility
Anheuser-Busch InBev commonly known as AB InBev, is a Belgian multinational drink and brewing company based in Leuven, Belgium. It is the world's largest brewer and is considered one of the largest fast-moving consumer goods companies in the world. Sweep analysis is a plant efficiency indicator tool which was created from past history data of the resource utilizations. It was mainly focused on improving the optimum utilization of resources such as water, electricity, heat and power.
Responsibilities:
Gathering the requirements from the Business users and understanding the functionality & business rules.
Preparing functional design document, requirement document & technical design document for reports.
Building, publishing customized interactive reports and dashboards, report scheduling using Power BI service.
Executed and tested required queries and reports before publishing.
Designed and developed various analytical reports from multiple Data Sources in Power BI Desktop.
Interacting with business stakeholders to understand their decision-making parameters, analyzing the available data to build Dashboards and managing the delivery.
Implementing user level security to restrict the data by group level and user level.
Publishing dashboards to tableau server and managing the security for users.
KPI Dash Board
- June 2021 - January 2022 - 8 Months
Technologies
Role & Responsibility
-
This is to notify the trade and public at large that DABUR INDIA LIMITED, (hereinafter referred to as “DABUR”), a Company incorporated under the Companies Act, 1956 having its Registered Office at 8/3, Asaf Ali Road, New Delhi – 110002 and Corporate Office Kaushambi, Ghaziabad – 201 010 (UP) INDIA, being manufacturers of wide variety of products including ayurvedic medicines, food, herbal, home care, personal care products and exclusive owners of all intellectual property rights.
Responsibilities:
Responsible for gathering requirements for POWER BI reports from business users and executives.
Gathering the requirements from the Business users and understanding the functionality & business rules.
Preparing functional design document, requirement document & technical design document for reports.
Present the analysis to internal and external teams and Explain data from a business perspective and relevance to Key Performance Indicators (KPI). Delivering reports to Business team on timely manner
Effectively used Power Query and DAX for calculations
Used POWER BI Filter like visual Level filters and page level filters
Build Pages with Slicers for Quick filters, Generated Report Level filters while handling huge volumes of data.
Experience in creating different visualizations using Bars, Lines and Pies, Maps, Gantts, Bubbles, and Highlight tables and Matrix
Effectively used POWER BI joins like inner join and outer joins and left anti and right anti joins
Reports
- May 2022 - January 2023 - 9 Months
Technologies
Role & Responsibility
Design and development of Power BI dashboard and Reports for Zomato.
Imported Data from SQL Server DB to Power BI to generate reports.
Implemented Data cleaning, Scrubbing and other Business rules using Power Query.
Working with bookmarks, Sync Slicers, Paginated tooltips, Drill through.
Using Map Visuals to map the business locations.
Created calculated columns, Measures in power bi desktop as per the requirement.
Worked on dataset refresh and scheduled database refresh.
Involved in building access control using Row Level Security.
Performance tuning of reports and resolving issues.
Worked with Apps to integrated reports.
Soft Skills
Industry Expertise
Education
in Bachelor of Electronics and Communication Engineer
Gujarat University- June 2013 - June 2017
