Skip to content
View pushpendraptkr's full-sized avatar
🎯
Focusing
🎯
Focusing

Block or report pushpendraptkr

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
pushpendraptkr/README.md

Hi 👋, I'm Pushpendra Patkar

Application Support Engineer | IT Operations | ServiceNow • Incident Management • SQL • Linux • Windows | 3+ Years at HCLTech | Open to Work

Application Support and IT Operations professional with 3+ years of experience in incident management, ticket triage and routing, server health checks, and maintenance support at HCLTech. Hands-on with ServiceNow, SQL, Linux, Windows troubleshooting, Excel and Power BI. Microsoft PL-300 certified. Seeking Application Support, IT Support and Production Support roles. Available to join immediately.


🚀 Skills

  • 📊 Microsoft Excel
  • 📈 Power BI
  • 🗄️ SQL (MySQL)
  • 🔄 Power Query
  • 📋 MIS Reporting
  • 📉 Dashboard Development
  • 📑 Data Analysis
  • 🎯 KPI Reporting
  • 🛠️ ServiceNow
  • 🐧 Linux (Basic)

📂 Featured Projects

📊 Excel Service Operations Dashboard

Interactive dashboard built using Microsoft Excel.

Features

  • KPI Cards
  • Pivot Tables & Pivot Charts
  • Interactive Slicers
  • Timeline Filter
  • SLA Compliance Monitoring
  • Team Performance Analysis
  • Customer Satisfaction (CSAT)
  • Escalation Rate Analysis

🔗 Repository: https://github.com/pushpendraptkr/excel-service-operations-dashboard


📊 Featured Projects

📌 Customer Support Operations Analytics Dashboard

Tools: Power BI, DAX, Power Query, Star Schema, Data Modeling

Built an interactive Power BI dashboard to analyze customer support operations using a Star Schema data model. The dashboard includes KPI tracking, SLA monitoring, CSAT analysis, FCR, productivity metrics, drill-through reports, dynamic titles, and interactive visualizations to support operational decision-making.

Key Features

  • 📈 Executive Operations Overview
  • 👨‍💼 Agent Performance Dashboard
  • 🔍 Agent Drill-through Analysis
  • 📊 Interactive KPI Cards
  • 📌 DAX Measures
  • ⭐ Star Schema Data Model
  • 🎯 Business Insights

🔗 Repository: https://github.com/pushpendraptkr/customer-support-operations-dashboard


📈 Cement Sales Dashboard (Excel)

Business dashboard created using Excel for sales analysis.

Features

  • Sales Trend Analysis
  • Revenue Analysis
  • State-wise Sales
  • Company Performance
  • Interactive Dashboard
  • Pivot Tables & Charts

🔗 Repository: https://github.com/pushpendraptkr/cement-sales-dashboard-excel


🎯 Currently Learning

  • Advanced SQL
  • Power BI (DAX)
  • Python for Data Analysis
  • Data Engineering Fundamentals

📜 Certifications

  • Microsoft PL-300: Power BI Data Analyst
  • Tutedude Data Analytics Certification
  • IBM SQL Certification
  • Excel Dashboard & Reporting

📫 Connect With Me


⭐ Thank you for visiting my profile. Feel free to explore my projects and connect with me!

Pinned Loading

  1. excel-service-operations-dashboard excel-service-operations-dashboard Public

    Interactive Service Operations Dashboard built in Microsoft Excel using Pivot Tables, Pivot Charts, Slicers, Timeline, and KPI Cards.

    1

  2. customer-support-operations-dashboard customer-support-operations-dashboard Public

    Customer Support Operations Analytics Dashboard | Power BI | DAX | Power Query | Data Modeling | KPI Reporting | Business Intelligence

    1

  3. cement-sales-dashboard-excel cement-sales-dashboard-excel Public

    Excel-based sales analytics dashboard for monitoring revenue, volume, product performance, and regional sales trends.