Vidit Singhal
Skills
Data Analysis & Reporting
  • •Data Cleaning, EDA, KPI Reporting, Trend Analysis
  • •Business Insights, Report Automation
  • •Interactive Dashboards Development (Excel / BI Concepts)
  • •Data Storytelling, KPI Dashboards, Charts & Graphs.
Soft Skills
  • •Root-Cause Investigation, Incident Analysis
  • •Communication & Presentation
  • •Cross-Functional Collaboration
Technical Skills
  • •SQL: Joins, CTEs, Window Functions, Aggregations, SQL Queries Optimization
  • •Excel: VLOOKUP, XLOOKUP, IF, IFS, Pivot Tables, Conditional Formatting
  • •Databases: MySQL, Schema Design, CRUD, Constraints
  • •Tools & Concepts: ETL, Data Modeling, Performance Reporting
  • •Data Visualization: IBM Cognos Analytics, Google Looker, Excel
Projects

Sales & Service Dashboard Development

Data Visualization and Dashboards with Excel and Cognos | IBM Coursera
  • •Developed 2+ interactive Sales and Service dashboards using Excel, IBM Cognos Analytics, and Google Looker Studio to analyze dealer and model-level performance.
    • Dec 2025 – Dec 2025
  • •Created 5+ KPI visualizations including profit, quantity sold, average sales, recalls, and customer sentiment using bar, line, column, treemap, heatmap, and combo charts.
  • •Designed 2+ structured dashboards for dealer-wise and model-wise performance analysis and exported reports for business presentation.
  • •Skills: IBM Cognos Analytics, Google Looker Studio, Microsoft Excel, Data Visualization, Dashboard Design, KPI Analysis

    • Fleet Inventory Data Cleaning & Analysis

    Excel Basics for Data Analysis | IBM Coursera
  • •Cleaned and prepared a 1,000+ record fleet inventory dataset by removing duplicates, fixing missing values, correcting formats, and standardizing department names.
    • Nov 2025 – Nov 2025
  • •Analyzed inventory data using 3+ Pivot Tables and AutoSum functions to generate department-wise and equipment-wise insights.
  • •Structured data into 3+ Excel tables to support accurate analysis and reporting.
  • •Skills: Microsoft Excel, Data Cleaning, Data Preparation, Pivot Tables, Descriptive Analysis

    • Credit Card Fraud Detection Analysis

    Introduction to Data Analytics | IBM Coursera
  • •Analyzed historical 1,000+ credit card transaction data to identify patterns associated with fraudulent activity.
    • Nov 2025 – Nov 2025
  • •Assessed data quality issues and detected anomalies such as abnormal transaction frequency and high-value transactions.
  • •Interpreted visual trends to support fraud-risk identification using descriptive analytics.
  • •Skills: Descriptive Analytics, Fraud Analysis, Data Quality Assessment, Anomaly Detection, Exploratory Data Analysis
    • Work Experience

    Bharti Airtel Ltd (Diversified network and infra solutions pvt. ltd)

    NOC Engineer
  • •Monitored network KPIs across 150+ nodes, maintaining 99.5% SLA compliance and reducing downtime by 12%.
    • Mar 2024 – Apr 2025Manesar, Haryana
  • •Collaborated with cross-functional NOC, field, and escalation teams to resolve 120+ monthly P2P, RF, and MPLS link incidents, improving resolution time by 17%.
  • •Coordinated with operations and reporting teams for weekly KPI reports using Excel Pivot Tables, reducing preparation time by 20% and improving reporting consistency.
    • Education

    Bachelor of Technology (B.Tech) | Electronics and Communication Engineering

    Ajay Kumar Garg Engineering College, AKTU
    2019 – 2023Ghaziabad, Uttar Pradesh
    Certificates
    Introduction to SQL – Simplilearn
    Data Analytics Essentials — IBM (Coursera)
    Excel Basics for Data Analysis — IBM (Coursera)
    Data Visualization and Dashboards with Excel and Cognos — IBM (Coursera)