Shiva Kumar P

Shiva Kumar P

Power Bi Developer
India
Tamil, English, Hindi

نبذة عني

Having 4.5 years of experience in working with BI technology tools like Microsoft Power BI, MS SQL Server.

الخبرة

Bi Developer

Modern Infotech data services
Feb 2020 - حتى الآن · 6 سنوات 5 أشهر

Gather the requirements from client and prepare the documents.Then Identify the KPI of the project requirements Using the KPI, Analyse the data and find the table and key fieldWe connect the various data sources like SQL, oracle, excel, csvetc. Using the data architecture followed by a company I will start to design, develop, and deploy.Once the data is imported, it will follow the ETL process and using Dax functions will try to optimize data for better performance. Then I will create reports, dashboards and KPI and once production is completed, I will test theproduct for data accuracy before deployment

POWER BI DEVELOPER

Modern Infotech Data Services
حتى الآن

Extensively used Custom Visuals from Power BI Custom Visuals Blog to meet the requirements.
Worked with Import Data source, Direct Query, and Live Connections in Power BI.
Worked with Calculated Column and Measure using DAX Expression.
Worked with Merge and Append Queries in Power BI.
Created Custom Visualizations and interactive Charts, Edit Interactions, and Sync Slicers.
Shared Power BI reports using Content Packs and Apps.
Worked with Power BI Service, Workspaces, and Edit dashboards.
Implemented Row Level Security.
Implemented filters, slicers, and various charts.
Used On-premises data gateway to schedule the daily data refresh to source files.
Created Bar Charts, Pie Charts, Line Charts, Tree Map, and Matrix Reports using Power BI.
Published Power BI reports from Power BI Desktop to Power BI Service.
Worked on ETL processes to clean, shape, and transform data into meaningful insights.

MS POWER BI DEVELOPER

Servier Pharmaceuticals
Jul 2021 - Nov 2022 · 1 سنة 4 أشهر

Participated with business analysis activities to gather the required reporting and dashboard requirements.
Developed reports and dashboards in the form of charts, maps, graphs, tables, and matrix using BI tool.
Designed Drill Down, Drill Through, line chart, and bookmark reports.
Scheduled data refresh as per client requirements and set up the time.
Created users, changed passwords, and handled tenant settings.
Designed and implemented ETL processes for data extraction, transformation, and loading for Power BI analytics.
Worked on creating row level security as per the requirement.

MS POWER BI DEVELOPER

Indigo Paints
Jan 2023

Designed and developed interactive and visually appealing Power BI reports and dashboards using Power BI Desktop and Power BI Service.
Executed SQL queries for data extraction and integration between Power BI and underlying databases.
Applied best practices in data visualization design to present complex data clearly and understandably.
Designed Power BI reports with a focus on responsive design for various screen sizes and resolutions.
Implemented ETL methodologies to ensure data integrity and accessibility for Power BI analytics.
Conducted trend analysis and implemented forecasting models within Power BI.

المهارات

كوجنوس لغة الاستعلامات الهيكلية (SQL) لغة الاستعلامات الهيكلية خدمات تقارير SQL Server كليك فيو تابلو Microsoft Power BI DAX Microsoft SQL Server Interactive Charts Maps Bookmarks Drill Down Drill Through Calculated Columns Measures Data Modeling Relationships Remove Rows Replace Values Split Column Date & Time Column KPI Reports YTD Reports QTD Reports MTD Reports Stacked Bar Chart Stacked Column Chart Table Heatmap Data Analysis Expressions Power BI Gateway Text Files MS Excel SharePoint Oracle Flat File ETL Agile Methodology Scrum DirectQuery Live Connections Merge Queries Append Queries Power BI Service Workspaces Edit Dashboards Row Level Security Content Packs Apps On-premises Data Gateway Bar Chart Card Donut Chart Funnel Chart Gauge
الإبلاغ عن هذا الملف الشخصي؟