Harish Kumar Dhanabalan
Chennai
Summary
A dedicated and results-driven professional with overall 3 years of experience in data management, analysis, and reporting to facilitate successful business solutions. Proficiently engaged in Power BI and MSBI projects, extensively utilizing ETL and reporting tools such as Power BI Desktop, Power BI Service, and SQL Server.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Power BI Developer
SMG Infotech Pvt. Ltd.
Hyderabad
05.2021 - Current
- Having 3 years of experience in Business Intelligence (BI), specializing in Power BI Desktop, Power BI Service, and SQL Server
- Proficient in Microsoft Advanced Excel
- Good Experience on Power Query, Power Pivot, Power View and DAX functions
- Development of Reports & Dashboards in Power BI Desktop and BI Service
- Importing and verifying data from various sources into Power BI Desktop
- Data modeling and relationship maintenance using different joins
- Proficient in creating and merging queries, as well as working on calculated tables and measures using DAX functions
- Designing various visualizations, such as Line, Bar, Table, Pie, Matrix table, Area, Tree map, Waterfall, Funnel, Clustered & Stacked, and more
- Creating interactive visualizations like slicers for data filtering
- Developing hierarchies for drilling down data and implementing drill through filters
- Applying conditional formatting and advanced formatting of tooltip filters
- Publishing and sharing reports & dashboards on Power BI Service, including gateway configuration for on-premises data access
- Implement functionality of existing systems Ability to work in-groups as well as independently with minimal supervision
- Proficient in SQL queries relevant to Power BI
- Experience in deploying and scheduling daily refreshes.
Education
M.Tech. -
VIT University
04-2021
B.E. -
Velammal Engineering College
04-2019
Skills
- Power Bi Desktop
- Power Bi Services
- ETL
- Data Modelling
- DAX
- Advanced Excel
- MySQL
- Python
- Data mining and analysis
- MS Office
- SSAS and SSIS
- Power Bi Reports
- Data Modelling
- M Query
- Security Integration
- SQL mastery
- Statistics
- pySpark
- Power Automate
- Data Warehousing
- GIT
- VSTS
- Documentation
Certification
- Google Data Analytics
Project-1
Roles & Responsibilities
PROJECT: GILBANE DOMAIN: REAL ESTATE
DURATION: JUL 2021- JAN 2023
At Gilbane, I play a crucial role in advancing our analytical capabilities for assessing and rating employee productivity. This project involves leveraging Power BI to enhance data visualization, reporting, and analytical tools that support our mission for providing independent and reliable information.
· Good Experience on Power Query, Power Pivot, Power View and DAX functions. Creating a drill down and drill through reports.
· Loading the data from development system to staging environment.
· Extracting data from multiple sources like flat files, Excel, and SQL server and validating data and loading into Final Destination.
· Created charts like Lines, Pie, Bar, Scatter, Area, Tree map, Map, Filled map, Gauge, Funnel, Single Card, Multi row card, Slicer etc.
· Used Quick Measure functionality to create Filters, Time Intelligence and Totals.
· Used Edit Interaction functionality to create Interaction between Visuals.
· Developing Visualization reports and Dashboards using Power BI.
· Have good Experience to Implement RLS as part of security.
· Working on DAX functions like Date & Time, Information, Filter & Value, Logical, and Text.
· Working with gateways and scheduling the refresh and Creating reports and dashboards.
· Involved in installing and configuring gateway services for Power Bi Desktop.
· Updating weekly status and keeping track of overall development status for the project.
Project-2
Roles & Responsibilities
PROJECT: ORVIS DOMAIN: ECOMMERCE
DURATION: MAR 2023- PRESENT
As a Power BI Developer at Orvis, you will play a crucial role in transforming raw data into actionable insights that drive business decisions. You will be working closely with cross-functional teams to understand their reporting needs, designing visually compelling and interactive reports, and ensuring data accuracy and integrity.
· Good Experience on Power Query, Power Pivot, Power View and DAX functions. Creating a drill down and drill through reports.
· Loading the data from development system to staging environment.
· Extracting data from multiple sources like flat files, Excel, and SQL server and validating data and loading into Final Destination.
· Created charts like Lines, Pie, Bar, Scatter, Area, Tree map, Map, Filled map, Gauge, Funnel, SingleCard, Multi row card, Slicer etc.
· Used Quick Measure functionality to create Filters, Time Intelligence and Totals.
· Used Edit Interaction functionality to create Interaction between Visuals.
· Developing Visualization reports and Dashboards using Power BI.
· Have good Experience to Implement RLS as part of security.
· Working on DAX functions like Date & Time, Information, Filter & Value, Logical, and Text.
· Working with gateways and scheduling the refresh and Creating reports and dashboards.
· Involved in installing and configuring gateway services for Power Bi Desktop.
· Updating weekly status and keeping track of overall development status for the project
Timeline
Power BI Developer
SMG Infotech Pvt. Ltd.
05.2021 - Current
M.Tech. -
VIT University
B.E. -
Velammal Engineering College
Similar Profiles
T. JEEVAN KUMART. JEEVAN KUMAR
Accessibility Testing at SMG infotech pvtAccessibility Testing at SMG infotech pvt
Imran RImran R
Cloud DevOps Engineer at PTS Consultancy Services Pvt LtdCloud DevOps Engineer at PTS Consultancy Services Pvt Ltd
Panthangi RamyaPanthangi Ramya
Security Analyst at SMG INFOTECH PRIVATE LIMITEDSecurity Analyst at SMG INFOTECH PRIVATE LIMITED
Monika KMonika K
Billing Operation at ToastBilling Operation at Toast
V Madhwaraj RaoV Madhwaraj Rao
Senior Consultant at Infosys LimitedSenior Consultant at Infosys Limited