---

💼 VDart CX Performance Management Dashboard

An enterprise-grade Full Stack Performance Management System built during my internship at VDart GCC, designed to streamline employee performance tracking, reporting, and communication across CX, CSM, RD, and RM teams.

This project was developed single-handedly within one month and recognized by the CX Team, earning a LinkedIn repost from VDart’s official page and a performance shoutout for exceptional delivery and impact.

---

🚀 Project Overview

This project serves as a centralized performance tracking and communication dashboard for multiple departments within VDart GCC. It integrates data collection, analytics, automation, and internal communication — all inside one responsive full-stack web application.

The platform features role-based dashboards, real-time data updates, Excel integration, and automated calculations to simplify workforce and productivity management.

---

🧩 Major Modules

👥 1. CX Dashboard

• Tracks overall team KPIs and performance metrics.
• Displays totals, averages, and percentages dynamically.
• Excel file uploads for large data ingestion and automated updates.

💼 2. CSM Dashboard

• Section-wise data input with Save, Undo, and Version History Tracker.
• Partial save and recovery support (auto backup).
• Manager vs. Employee view segregation.

📊 3. RD & RM Dashboards

• Department-specific performance tracking.
• Auto-calculated totals and percentage contribution.
• Graphical data representation and export support.

📤 4. Excel Integration & JSON Sync

• Upload Excel files → convert to JSON → auto-update SQL database.
• Dynamic data refresh across all dashboards after upload.
• Real-time aggregation (totals, averages, completion %).

💬 5. In-Built Messenger & Notifications

• Real-time message sending between employees, managers, and admins.
• Department-based and custom employee-specific chat.
• Email notifications triggered automatically for new queries or updates.

🕒 6. Version Control & History

• Full Undo / Redo system with record-level tracking.
• View, restore, or backup previous data states easily.

---

⚙️ Key Features

✅ Fully Responsive UI (HTML5, CSS3, JavaScript) ✅ Role-Based Access (Manager / Employee / Admin) ✅ Auto Calculations (Totals, Percentages, Ratios) ✅ Section-Based Form Saving and Undo ✅ SQL Data Store with JSON Sync ✅ Excel Upload & Parsing (Automated Data Injection) ✅ Version History and Backup System ✅ Inbuilt Messenger with Mail Notifications ✅ Log Management & Activity Tracking ✅ Clean Modular Code Architecture

---

🛠️ Tech Stack

Category	Technologies Used
Frontend	HTML5, CSS3, JavaScript
Backend	PHP (Core PHP)
Database	MySQL
Integration	Excel to JSON + SQL Sync
Additional	AJAX, PHP Mailer, Custom Log System

---

🗂️ Folder Structure

VDart-Dashboard/
│
├── RD/                  # Regional Dashboard
├── RMD/                 # RM Dashboard
├── CSM/                 # CSM Dashboard
├── Template/            # Predefined Layouts
├── assets/              # CSS, JS, and Icons
├── data/                # JSON & Backup Data Files
├── logs/                # User Activity & Error Logs
├── uploads/             # Uploaded Excel/Media Files
│
├── index.php            # Main Dashboard Entry
├── login.php            # Login Page
├── logout.php           # Logout & Session End
├── form-cx.php          # CX Data Entry Form
├── notification.php     # Mail & Alerts Module
├── spreadsheets.php     # Excel Upload & Parser
├── version-history.php  # Undo/Redo Tracker
├── settings.php         # Admin Configurations
├── query.php            # Messenger / Query Handler
├── app-logs.php         # System Log Viewer
└── README.md            # Project Documentation

---

🧠 Workflow

1. Employee Login → Access dashboard → Update assigned section → Save or Undo changes.
2. Manager Dashboard → View team data, approve or modify entries.
3. Excel Upload → Parse → JSON → SQL → Auto Reflect on Dashboards.
4. Messenger → Send message → All CX, CSM, RD, RM notified via email.
5. Backup & Version Control → Retrieve or restore past data anytime.

---

🏆 Achievements

• 🏅 Developed Single-Handedly in 1 Month
• 💬 Received official CX Team Shoutout for performance.
• 💼 Recognized by VDart GCC as an impactful internal automation tool.
• 🔁 Featured on VDart’s LinkedIn Company Page for innovation.
• 💰 Earned a ₹5,000 Incentive Reward for delivery excellence.

---

💡 Future Enhancements

• Real-time chart analytics with Chart.js.
• Role-based API endpoints for external integration.
• Automated report generation (PDF/Excel).
• Enhanced notification via Microsoft Teams/Slack integration.
• Cloud-based backup storage and multi-user concurrency handling.

---

🧾 License

This project is a proprietary VDart GCC Internal Application — built as part of internship work. Reproductions or commercial use require prior approval.

---

Developed with 💻 Passion & Precision by Vignesh G

Intern @ VDart GCC — Recognized by CX Team for Innovation & Excellence.

---