Skip to content
View Hardik2993's full-sized avatar
0 followers · 2 following

Block or report Hardik2993

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
Hardik2993/README.md

Hi, I'm Hardik Khodiyar 👋

Data Analyst | SQL • Tableau • Power BI • Python

I transform complex operational data into clear metrics, automated reports, and actionable business insights.

About Me

  • Data Analyst with 9.5+ years of overall professional experience and 3+ years focused on data analytics
  • Experienced in operational analytics, KPI reporting, dashboard development, data validation, and process improvement
  • Skilled in translating business requirements into SQL queries, reports, dashboards, and measurable performance indicators
  • Currently based in India and open to relocation opportunities in Germany
  • Interested in Data Analyst, Business Intelligence Analyst, and Reporting Analyst roles

Technical Skills

Area Tools and Technologies
Data Analysis SQL, Microsoft Excel, Data Validation, Trend Analysis
Data Visualization Tableau, Power BI
Reporting SSRS, Tableau Cloud, Operational and Executive Dashboards
Databases Microsoft SQL Server, SSMS
Programming Python for Data Analysis
Data Integration SSIS, ETL Concepts
Version Control Git, GitHub

Areas of Expertise

  • KPI and operational performance reporting
  • Average Handle Time and productivity analysis
  • Turnaround Time and SLA measurement
  • Business requirement analysis
  • Dashboard design and development
  • Report automation and optimization
  • Data quality investigation and reconciliation
  • Stakeholder communication and documentation

Featured Project

Insurance Operations KPI Dashboard

An end-to-end operational analytics portfolio project using a public-safe synthetic dataset with 1,800 completed work orders.

Tools: SQL Server, Tableau-ready data model, Microsoft Excel, Git and GitHub

Key features:

  • Reusable SQL scripts for data loading, validation, KPI analysis, and dashboard reporting
  • Analysis of productivity, billable hours, AHT, TAT, SLA, quality, and rework
  • Formula-driven Excel validation workbook and KPI summary
  • Tableau dashboard design specifications and calculated-field definitions
  • Complete data dictionary, methodology, assumptions, and privacy documentation

View the complete project repository →

Projects in Development

  • Average Handle Time and Productivity Analysis
  • Process Standardization Impact Study
  • Global Headcount and Attrition Dashboard

Currently Developing

  • Advanced Power BI dashboard development
  • Python for data cleaning, analysis, and automation
  • Data storytelling and executive-level visualization

Connect With Me

Open to Data Analyst, Business Intelligence Analyst, and Reporting Analyst opportunities in Germany.

Pinned Loading

  1. insurance-operations-kpi-dashboard insurance-operations-kpi-dashboard Public

    End-to-end SQL and Tableau analytics project for monitoring operational productivity, AHT, TAT, SLA performance, and business trends.

    TSQL 1

  2. executive-workforce-operations-dashboard executive-workforce-operations-dashboard Public

    Power BI portfolio project analyzing workforce, productivity, operational performance, and profitability using synthetic data.

    1