import React, { useState, useMemo } from 'react'; import { Search, Users, BookOpen, BarChart3, ChevronDown, ChevronUp, User, Building2, Briefcase, TrendingUp } from 'lucide-react'; import { BarChart, Bar, PieChart, Pie, Cell, XAxis, YAxis, CartesianGrid, Tooltip, Legend, ResponsiveContainer } from 'recharts'; const CompetencyPortal = () => { const [activeTab, setActiveTab] = useState('dashboard'); const [selectedEmployee, setSelectedEmployee] = useState(''); const [expandedCompetency, setExpandedCompetency] = useState(null); const [searchTerm, setSearchTerm] = useState(''); const [filterJobFamily, setFilterJobFamily] = useState('All'); const [filterBU, setFilterBU] = useState('All'); // Employee Data const employees = [ { name: "Venkatadri Karuppampalayam Ranganathan", designation: "Chief Commercial Officer", department: "Commercial", bu: "Commercial", jobFamily: "Commercial Leadership" }, { name: "Thiagarajan Subbiah", designation: "Head Commercial Excellence", department: "Commercial", bu: "Commercial", jobFamily: "Commercial Excellence & Strategy" }, { name: "Sameer Vasudev Kulkarni", designation: "Assistant General Manager", department: "Commercial", bu: "Commercial", jobFamily: "General Supply Chain Support" }, { name: "Vikas Kumar", designation: "Senior Manager", department: "Commercial", bu: "Commercial", jobFamily: "General Supply Chain Support" }, { name: "Manali Vilasrao Pawar", designation: "Management Trainee", department: "Commercial", bu: "Commercial", jobFamily: "General Supply Chain Support" }, { name: "Pratham Singh", designation: "Management Trainee", department: "Commercial", bu: "Commercial", jobFamily: "General Supply Chain Support" }, { name: "Samir Dhiren Shah", designation: "Head Supply Chain Management - Mithapur", department: "SCM", bu: "Mithapur", jobFamily: "General Supply Chain Support" }, { name: "Venkatakrishnan Balakrishnan", designation: "General Manager", department: "Logistics", bu: "Ahmedabad", jobFamily: "Logistics General Operations" }, { name: "Jignesh Harshavadan Vasavada", designation: "Assistant General Manager", department: "Logistics", bu: "Mithapur", jobFamily: "Logistics General Operations" }, { name: "Maheshkumar Vijaykumar Zala", designation: "Manager", department: "Logistics", bu: "Mithapur", jobFamily: "Logistics General Operations" }, { name: "Nilesh Wagh", designation: "Manager", department: "Logistics", bu: "Mithapur", jobFamily: "Logistics General Operations" }, { name: "Urvishkumar Solanki", designation: "Deputy Manager", department: "Logistics", bu: "Ahmedabad", jobFamily: "Logistics General Operations" }, { name: "Tribhuvan Kumar Pandey", designation: "Deputy Manager", department: "Logistics", bu: "Mithapur", jobFamily: "Logistics General Operations" }, { name: "Mukesh Munjabhai Hathia", designation: "Assistant Manager", department: "Logistics", bu: "Mithapur", jobFamily: "Logistics General Operations" }, { name: "Devesh Mishra", designation: "Assistant Manager", department: "Logistics", bu: "Mithapur", jobFamily: "Logistics General Operations" }, { name: "Jashwant Shankar Nayak", designation: "Management Trainee", department: "Logistics", bu: "Mithapur", jobFamily: "Logistics General Operations" }, { name: "Sanket Jagannath Kirve", designation: "Officer", department: "Logistics", bu: "Ahmedabad", jobFamily: "Logistics General Operations" }, { name: "D M Modi", designation: "Deputy General Manager", department: "Purchase", bu: "Mithapur", jobFamily: "Procurement General" }, { name: "Kartik Bhanushankar Joshi", designation: "Manager", department: "Purchase", bu: "Mithapur", jobFamily: "Procurement General" }, { name: "Subrata Ghosh", designation: "Manager", department: "Purchase", bu: "Mithapur", jobFamily: "Procurement General" }, { name: "Manish Mancharam Ramavat", designation: "Manager", department: "Purchase", bu: "Mithapur", jobFamily: "Procurement General" }, { name: "Sujit Ranchhodbhai Patel", designation: "Manager", department: "Purchase", bu: "Mithapur", jobFamily: "Procurement General" }, { name: "Jayesh Gopalbhai Kotecha", designation: "Deputy Manager", department: "Purchase", bu: "Mithapur", jobFamily: "Procurement General" }, { name: "Harsh Gangabhai Parmar", designation: "Deputy Manager", department: "Purchase", bu: "Mithapur", jobFamily: "Procurement General" }, { name: "Rahul Shankar Waswani", designation: "Deputy Manager", department: "Purchase", bu: "Mithapur", jobFamily: "Procurement General" }, { name: "Tushar Bhikhubhai Modi", designation: "Assistant Manager", department: "Purchase", bu: "Mithapur", jobFamily: "Procurement General" }, { name: "Alpesh Chauhan", designation: "Assistant Manager", department: "Purchase", bu: "Mithapur", jobFamily: "Procurement General" }, { name: "Bhagyashree Singha", designation: "Assistant Manager", department: "Purchase", bu: "Mithapur", jobFamily: "Procurement General" }, { name: "Mohan Mangaldas Gokani", designation: "Senior Manager", department: "Raw Materials Sourcing and Chartering", bu: "Mithapur", jobFamily: "Raw Material Sourcing & Chartering Operations" }, { name: "Paras Gupta", designation: "Deputy Manager", department: "Raw Materials Sourcing and Chartering", bu: "Mithapur", jobFamily: "Raw Material Sourcing & Chartering Operations" }, { name: "Akanksha Chaudhary", designation: "Assistant Manager", department: "Raw Materials Sourcing and Chartering", bu: "Mithapur", jobFamily: "Raw Material Sourcing & Chartering Operations" }, { name: "Jatinder Dubey", designation: "General Manager", department: "Purchase", bu: "Mithapur", jobFamily: "Procurement General" }, { name: "Jignesh Bipin Jani", designation: "Manager", department: "Purchase", bu: "Mithapur", jobFamily: "Procurement General" }, { name: "K Satish", designation: "Head", department: "Stores", bu: "Mithapur", jobFamily: "Stores & Inventory Leadership" }, { name: "Uma Shankar Barathi Umakanthan", designation: "Head Supply Chain Management - Cuddalore and Mambattu", department: "SCM", bu: "Cuddalore and Mambattu", jobFamily: "General Supply Chain Support" }, { name: "Bhimashankar Manmathappa Halge", designation: "Deputy Manager", department: "Logistics", bu: "Mambattu", jobFamily: "Logistics General Operations" }, { name: "Atla Kanaka Durga Prasad Reddy", designation: "Officer", department: "Logistics", bu: "Mambattu", jobFamily: "Logistics General Operations" }, { name: "Sravan Kumar Vemuri", designation: "Officer", department: "Purchase", bu: "Mambattu", jobFamily: "Procurement General" }, { name: "Gopi Kottapalli", designation: "Officer", department: "Purchase", bu: "Mambattu", jobFamily: "Procurement General" }, { name: "Natarajan Sundaravel", designation: "Officer", department: "Stores", bu: "Mambattu", jobFamily: "Stores & Inventory Operations" }, { name: "Venkatesaperumal Pazhanivel", designation: "Senior Officer", department: "Logistics", bu: "Cuddalore", jobFamily: "Logistics General Operations" }, { name: "Soundarapandian Subramaniyan", designation: "Officer", department: "Purchase", bu: "Cuddalore", jobFamily: "Procurement General" } ]; // Competency Dictionary const competencies = [ { name: "Purchase Order Processing & PR-PO Lifecycle", category: "Procurement", definition: "Involves executing and managing end-to-end purchase requisition to purchase order (PR-PO) cycles using SAP Ariba or SAP ECC. Includes validating PRs, vendor mapping, PO creation, approval routing, and ensuring delivery adherence as per procurement SLAs and governance.", levels: { L1: "Understands PR-PO workflow and assists in data entry, coding, and documentation under supervision.", L2: "Independently creates, tracks, and closes POs in SAP Ariba/Hana; ensures adherence to approval matrices and timelines.", L3: "Reviews PR-PO cycle time, identifies bottlenecks, and optimizes order execution through automation or analytics.", L4: "Defines PO governance frameworks, automates PR-PO reporting, and harmonizes global procurement processes." } }, { name: "Supplier Relationship Management (SRM)", category: "Procurement", definition: "Ability to manage supplier communication, onboarding, and performance in line with Tata Chemicals' Supplier Code of Conduct. Uses Ariba Supplier Lifecycle Performance (SLP) for registration, compliance checks, and performance dashboards.", levels: { L1: "Supports supplier registration and assists in vendor communication.", L2: "Manages supplier follow-ups, performance feedback, and compliance renewals through Ariba SLP.", L3: "Leads supplier performance reviews, risk assessments, and improvement plans.", L4: "Establishes strategic supplier partnership models, supplier scorecards, and supplier innovation programs." } }, { name: "Contract Management & Compliance", category: "Procurement", definition: "Ability to draft, review, and administer contracts within approved templates and clauses, ensuring adherence to commercial, legal, and risk frameworks. Involves working with Ariba Contract Workspace and Legal for lifecycle management and audit compliance.", levels: { L1: "Understands basic contract structures and supports data entry and filing.", L2: "Prepares contracts and ensures clause compliance, renewals, and repository updates in Ariba CLM.", L3: "Negotiates complex clauses (indemnity, LDs, termination) and monitors compliance with internal audit teams.", L4: "Defines contract governance frameworks, implements digital CLM systems, and mitigates enterprise-level contract risks." } }, { name: "Negotiation & Commercials", category: "Procurement", definition: "Capability to conduct negotiations on price, payment terms, delivery, and other commercial parameters, ensuring cost-effective and sustainable sourcing. Involves applying total cost of ownership (TCO) analysis and negotiation strategies.", levels: { L1: "Supports in gathering data for negotiations and observes discussions.", L2: "Conducts routine negotiations for indirect or consumable categories independently.", L3: "Leads strategic negotiations across high-value categories using analytics and benchmarking.", L4: "Defines negotiation playbooks, mentors teams, and influences enterprise-level sourcing outcomes." } }, { name: "SAP Ariba / e-Procurement Operations", category: "Procurement", definition: "Expertise in managing sourcing and procurement activities within SAP Ariba including RFx creation, supplier collaboration, PR-PO execution, and invoice processing. Ensures data accuracy, approvals, and integration with SAP Hana.", levels: { L1: "Navigates basic Ariba functions (PR creation, approvals, GRN inputs).", L2: "Manages sourcing events, POs, and vendor communications within Ariba modules.", L3: "Optimizes Ariba workflows and reporting dashboards; trains others.", L4: "Defines global process templates and automation within Ariba ecosystem." } }, { name: "RFx & Sourcing Execution", category: "Procurement", definition: "Involves designing and managing competitive bidding (RFQ/RFP) processes for direct and indirect categories using e-sourcing tools (Ariba Sourcing). Includes technical evaluation coordination, bid tabulation, and award recommendation.", levels: { L1: "Understands sourcing process and assists in preparing RFQs.", L2: "Runs RFx events independently for assigned categories.", L3: "Designs sourcing strategies and ensures compliance to governance.", L4: "Defines sourcing frameworks and harmonizes global tendering processes." } }, { name: "Spend Analytics & MIS Reporting", category: "Procurement", definition: "Ability to extract, analyze, and present procurement and spend data using SAP, Ariba, or Power BI dashboards to support decision-making and audit readiness.", levels: { L1: "Understands data extraction from SAP reports and supports MIS preparation.", L2: "Generates spend reports, validates data, and prepares dashboards for category reviews.", L3: "Analyzes spend patterns for savings and compliance; mentors juniors on reporting accuracy.", L4: "Defines spend taxonomy, dashboards, and governance reporting for leadership." } }, { name: "Category Management", category: "Procurement", definition: "Ability to segment spend categories, develop sourcing strategies, and drive cost, risk, and supplier performance improvement.", levels: { L1: "Understands spend categories and supports category data updates.", L2: "Executes category plans under supervision, tracking cost reduction and compliance KPIs.", L3: "Develops category strategies, leads sourcing initiatives, and tracks strategic KPIs.", L4: "Defines enterprise category strategy and cross-plant sourcing playbooks." } }, { name: "Cost Optimization & TCO Analysis", category: "Procurement", definition: "Involves identifying and executing cost improvement initiatives using TCO principles – considering logistics, inventory, quality, and lifecycle costs.", levels: { L1: "Understands basic cost drivers and supports cost data collection.", L2: "Conducts TCO analysis for key spends and supports savings documentation.", L3: "Leads cost optimization workshops with suppliers; quantifies and validates savings.", L4: "Defines enterprise-level cost optimization strategies and TCO frameworks." } }, { name: "Contractual Risk & Governance", category: "Procurement", definition: "Ability to identify and mitigate contractual, supplier, and process risks through governance reviews, audit readiness, and compliance frameworks.", levels: { L1: "Understands standard risk parameters in procurement.", L2: "Maintains supplier compliance and audit documentation.", L3: "Conducts risk assessments and defines mitigation plans for critical suppliers.", L4: "Designs risk governance frameworks and cross-functional control mechanisms." } }, { name: "Export Documentation & Compliance", category: "Logistics", definition: "Ability to prepare and manage export shipping documents (Invoice, Packing List, B/L, LC compliance, ARE-1, Drawback forms) and ensure adherence to DGFT and customs regulations. Involves use of SAP Export Module and coordination with CHA and ports.", levels: { L1: "Understands basic export documents and assists in data entry or filing.", L2: "Prepares and submits export documentation accurately; tracks approvals and export incentives.", L3: "Reviews export documentation processes for accuracy and cycle time; resolves customs/CHA issues.", L4: "Designs export compliance frameworks, interfaces SAP—ICEGATE systems, and ensures audit readiness for all export operations." } }, { name: "Import Documentation & Compliance", category: "Logistics", definition: "Involves managing import clearance documentation (Bill of Entry, GSTR forms, LC and insurance docs) and coordination with customs, CHA, and port authorities for timely clearance. Requires knowledge of customs valuation, duty structures, and DGFT policies.", levels: { L1: "Understands basic import documents and assists in CHA coordination.", L2: "Prepares import clearance documents and tracks shipment release timelines.", L3: "Resolves import duty disputes and ensures BOE accuracy through customs and CHA coordination.", L4: "Designs import compliance frameworks, manages duty optimization strategies, and ensures regulatory audit compliance." } }, { name: "Freight Management & Chartering Coordination", category: "Logistics", definition: "Involves managing freight contracts and logistics for export/import shipments. Includes freight rate negotiation, transporter coordination, and cost monitoring. For bulk shipments, coordinates chartering (vessel bookings) and maritime logistics through shipping agents.", levels: { L1: "Understands freight planning and assists in transporter bookings.", L2: "Manages freight bookings, tracks shipments, and monitors freight costs.", L3: "Negotiates freight rates and optimizes routing; ensures cost-to-serve alignment.", L4: "Defines freight strategy and chartering frameworks; leads global freight optimization and vendor partnerships." } }, { name: "Transport Planning & Secondary Distribution", category: "Logistics", definition: "Ability to plan and execute secondary dispatches from plants to depots, distributors, or customers. Involves vehicle allocation, route optimization, tracking dashboards (SAP TMS), and coordination with transporters to ensure timely delivery.", levels: { L1: "Understands transport planning and assists in vehicle booking.", L2: "Plans transport independently and tracks dispatches using SAP TMS.", L3: "Optimizes transport routes and costs; manages transporter performance.", L4: "Defines transport strategy and implements automation for logistics efficiency." } }, { name: "Voyage & Chartering Coordination", category: "Logistics", definition: "Expertise in managing vessel chartering for import/export bulk cargo including charter party agreements, demurrage/detention management, vessel nomination, and liaison with shipping lines and agents. Involves freight calculation and voyage documentation.", levels: { L1: "Understands voyage terms and assists in documentation.", L2: "Coordinates vessel bookings and tracks voyage schedules.", L3: "Manages charter party terms and resolves demurrage/detention claims.", L4: "Defines chartering strategy and optimizes shipping costs at enterprise level." } }, { name: "Carrier & Vendor Management", category: "Logistics", definition: "Capability to manage relationships with transporters, freight forwarders, CHAs, and logistics service providers. Involves performance evaluation, rate negotiations, contract renewals, and ensuring compliance with SLAs and safety standards.", levels: { L1: "Supports vendor coordination and documentation.", L2: "Manages vendor communication and performance tracking.", L3: "Evaluates vendor performance and leads contract negotiations.", L4: "Defines vendor management frameworks and strategic logistics partnerships." } }, { name: "Shipment Tracking & Claims Management", category: "Logistics", definition: "Involves tracking shipments through GPS/TMS tools, managing exceptions (delays, damages), and processing insurance claims or freight recovery. Ensures real-time visibility and proactive issue resolution.", levels: { L1: "Understands tracking tools and supports claim documentation.", L2: "Tracks shipments and manages routine claims independently.", L3: "Analyzes exception trends and improves tracking processes.", L4: "Defines shipment visibility strategy and claims management framework." } }, { name: "Cost-to-Serve & Freight Optimization", category: "Logistics", definition: "Ability to analyze logistics costs per route, customer, or product and identify optimization opportunities. Uses freight analytics, benchmarking, and consolidation strategies to reduce costs.", levels: { L1: "Understands cost components and supports data collection.", L2: "Calculates cost-to-serve and prepares basic analysis.", L3: "Identifies cost reduction opportunities and implements optimization projects.", L4: "Defines cost-to-serve frameworks and drives strategic freight optimization." } }, { name: "Safety & Compliance for Transport", category: "Logistics", definition: "Ensures adherence to transportation safety norms (overloading, hazmat handling, driver compliance) and regulatory requirements (RTO, pollution norms). Involves incident reporting and coordination with SHE teams.", levels: { L1: "Understands transport safety norms and supports compliance checks.", L2: "Ensures transporter compliance and documents safety incidents.", L3: "Leads safety audits and improvement initiatives with transporters.", L4: "Defines transport safety standards and compliance frameworks." } }, { name: "GRN & Material Receipt (SAP MIGO)", category: "Stores", definition: "Involves receiving materials against purchase orders, conducting physical and quality inspections, and recording Goods Receipt Notes (GRN) in SAP MM using MIGO transaction. Ensures quantity accuracy, documentation, and timely system updates.", levels: { L1: "Understands GRN process and assists in material receipt under supervision.", L2: "Executes GRN independently in SAP MM; ensures accurate quantity and quality checks.", L3: "Reviews GRN cycle time and quality exceptions; coordinates with QA and procurement for issue resolution.", L4: "Defines GRN governance and integrates automated receipt systems (barcode/RFID) with SAP MM." } }, { name: "Inventory Accuracy & Cycle Counts", category: "Stores", definition: "Capability to maintain accurate stock records through periodic cycle counts, physical verification, and reconciliation against SAP stock data. Involves investigating variances and implementing corrective actions.", levels: { L1: "Assists in cycle counting and recording stock differences.", L2: "Conducts physical verification and reconciles data with SAP MM records.", L3: "Analyzes variance trends and drives improvement in stock accuracy and controls.", L4: "Defines stock accuracy policy and automates cycle count scheduling and analytics dashboards." } }, { name: "Material Issue & Requisition Management", category: "Stores", definition: "Involves issuing materials against production or maintenance requisitions using SAP MB1A/MB1B transactions. Ensures proper authorization, documentation, and inventory updates in real-time.", levels: { L1: "Understands material issue workflow and supports documentation.", L2: "Issues materials accurately through SAP transactions; ensures records match physical movement.", L3: "Streamlines issue process and improves traceability through barcode or handheld terminal integration.", L4: "Defines issue and return governance and implements digital tools for material traceability and consumption analysis." } }, { name: "SAP MM / Inventory Systems Operations", category: "Stores", definition: "Ability to operate SAP MM (Materials Management) module for material master management, stock status, GRN, MIGO, MB1A/MB1B transactions, and MIS reporting. Ensures system data integrity and compliance with process workflows.", levels: { L1: "Navigates SAP MM for stock inquiries and GRN entry.", L2: "Executes inventory transactions (MIGO, MB1A/B, stock transfer) independently.", L3: "Identifies system improvement opportunities and provides user training.", L4: "Leads SAP MM process optimization, interfaces with BTP analytics, and standardizes global inventory workflows." } }, { name: "Store Housekeeping & HSE Compliance", category: "Stores", definition: "Ensures proper material storage, housekeeping, and safety compliance (SHE standards) including segregation of hazardous materials, labeling, ventilation, and spill control. Maintains store hygiene and statutory documentation.", levels: { L1: "Follows housekeeping and PPE norms under supervision.", L2: "Maintains material racks, labeling, and compliance documentation.", L3: "Implements 5S and SHE improvements; mentors store staff in safety best practices.", L4: "Defines store safety and layout standards, conducts audits, and integrates SHE dashboards." } }, { name: "Stock Valuation & Slow/Non-Moving Management", category: "Stores", definition: "Ability to analyze stock valuation, identify slow-moving/obsolete items, and propose disposal or reclassification actions in SAP MM. Involves coordination with finance for provisioning and audit reporting.", levels: { L1: "Understands valuation methods and supports obsolete stock tagging.", L2: "Monitors slow-moving inventory and updates reports for management review.", L3: "Leads analysis of inventory health, valuation, and working capital optimization.", L4: "Defines inventory valuation policy and leads cross-functional reviews for disposal and optimization." } }, { name: "Warehouse Layout & Space Optimization", category: "Stores", definition: "Ability to plan and manage warehouse layout for efficient space utilization, material access, and safety. Uses tools such as AutoCAD or digital WMS to optimize racking and flow.", levels: { L1: "Understands basic store layout and material placement.", L2: "Manages material arrangement and reallocation based on inflow/outflow.", L3: "Designs optimized layouts and implements lean storage techniques.", L4: "Defines layout standards and implements WMS or automation for warehouse management." } }, { name: "Process Improvement & Governance", category: "Cross-Functional", definition: "Ability to identify inefficiencies in procurement, logistics, or inventory processes, suggest improvements, and implement standardized operating procedures. Involves knowledge of SOP drafting, process audits, and system workflow optimization in SAP/Ariba.", levels: { L1: "Understands SOPs and supports documentation.", L2: "Identifies process gaps and suggests improvements; maintains SOP adherence.", L3: "Leads improvement projects across functions; standardizes reporting and workflow efficiency.", L4: "Defines governance frameworks and drives automation and lean transformation across the supply chain." } }, { name: "Stakeholder Management & Collaboration", category: "Cross-Functional", definition: "Capability to effectively engage with internal stakeholders (production, finance, QA, SCM, projects) and external partners (suppliers, customers, logistics providers) to achieve shared outcomes.", levels: { L1: "Understands stakeholder needs and supports communication.", L2: "Manages coordination independently with limited supervision.", L3: "Anticipates stakeholder requirements, resolves conflicts, and ensures alignment of priorities.", L4: "Defines collaboration models and stakeholder engagement frameworks across plants and geographies." } }, { name: "Commercial Analytics & MIS", category: "Cross-Functional", definition: "Ability to analyze data related to pricing, spend, freight, or inventory using SAP reports, Excel, Power BI, or BTP dashboards. Provides insights for cost reduction, policy compliance, and decision support.", levels: { L1: "Understands basic data structures and supports report preparation.", L2: "Prepares regular MIS reports and validates data accuracy from SAP/Ariba.", L3: "Develops dashboards and insights to support decision-making and continuous improvement.", L4: "Defines enterprise analytics KPIs, data models, and reporting governance across SCM." } }, { name: "Pricing & Commercial Analysis", category: "Cross-Functional", definition: "Involves analyzing product pricing, cost structures, margins, and market competitiveness using SAP SD or Power BI. Supports decision-making on sales pricing and contract renewals.", levels: { L1: "Understands pricing structures and supports data gathering.", L2: "Analyzes pricing trends and prepares margin and variance reports.", L3: "Leads pricing analysis for strategic accounts and provides business insights.", L4: "Defines pricing strategy frameworks and leads digital pricing analytics implementation." } }, { name: "Documentation, Compliance & Audit Readiness", category: "Cross-Functional", definition: "Ensures all procurement, logistics, and inventory transactions are documented and compliant with internal controls, audit requirements, and statutory standards. Maintains digital documentation using SAP attachments, DMS, or WMS systems to ensure audit readiness and data integrity.", levels: { L1: "Prepares and files supporting documents as per SOP and assists in audit record organization.", L2: "Ensures transaction-level documentation accuracy and compliance; retrieves records for audits or inspections.", L3: "Leads documentation audits, standardizes retention practices, and ensures compliance with internal and statutory requirements.", L4: "Defines enterprise documentation and compliance policy; drives digital documentation systems (DMS/WMS) for audit traceability and automation." } }, { name: "Coordination & Communication", category: "Cross-Functional", definition: "Ability to coordinate operational information flow across departments and ensure timely communication using digital platforms like SAP Workflow, MS Teams, or email.", levels: { L1: "Responds promptly to internal requests and updates.", L2: "Independently coordinates task completion and updates relevant stakeholders.", L3: "Anticipates dependencies and ensures proactive communication across functions.", L4: "Defines communication standards, dashboards, and escalation mechanisms for enterprise coordination." } }, { name: "System Data Entry & Accuracy", category: "Cross-Functional", definition: "Ensures correct and timely data entry into SAP, Ariba, or TMS for procurement, logistics, and inventory transactions. Maintains master data integrity and supports audit readiness.", levels: { L1: "Understands transaction fields and performs data entry under supervision.", L2: "Executes system updates independently and validates data accuracy.", L3: "Monitors data quality reports and ensures master data integrity across modules.", L4: "Defines master data governance and ensures digital integration across systems." } }, { name: "Problem Escalation & Resolution", category: "Cross-Functional", definition: "Ability to identify issues during operations (e.g., PO delays, shipment exceptions, system errors) and escalate them through appropriate channels (helpdesk, CBSL ProCare, or line management) for timely resolution.", levels: { L1: "Identifies issues and informs supervisor promptly.", L2: "Escalates issues through correct channels with relevant documentation.", L3: "Analyzes recurring issues and proposes permanent fixes.", L4: "Defines escalation protocols, SLAs, and leads digital ticketing improvements (BTP/ProCare Helpdesk)." } }, { name: "Basic Supply Chain Execution", category: "Cross-Functional", definition: "Understanding of end-to-end supply chain flows including planning, procurement, logistics, and order fulfilment. Supports transactional activities and cross-department coordination.", levels: { L1: "Understands supply chain process flow and dependencies.", L2: "Executes assigned operational tasks across procurement/logistics under supervision.", L3: "Supports integrated process optimization and identifies improvement opportunities.", L4: "Defines integrated supply chain processes and cross-functional operating models." } }, { name: "Risk Management & Business Continuity", category: "Cross-Functional", definition: "Ability to anticipate, assess, and mitigate operational risks across procurement, logistics, and inventory management. Includes contingency planning, alternate sourcing, buffer planning, and supplier redundancy. Integrates risk registers within SCM governance, audit, and business continuity frameworks.", levels: { L1: "Understands operational risk factors and reporting mechanisms in daily supply chain activities.", L2: "Tracks and reports risk indicators across procurement, logistics, and inventory; supports mitigation actions and escalation.", L3: "Leads risk review meetings, coordinates contingency plans, and ensures alignment with business continuity requirements at plant or regional level.", L4: "Defines enterprise-wide risk and continuity frameworks integrating SCM governance, supplier resilience, and audit systems." } } ]; // Competency Mapping - COMPLETE DATA (290 mappings) const competencyMapping = [ { employee: "Venkatadri Karuppampalayam Ranganathan", competency: "Contract Management & Compliance", level: "L4 Expert" }, { employee: "Venkatadri Karuppampalayam Ranganathan", competency: "Commercial Analytics & MIS", level: "L4 Expert" }, { employee: "Venkatadri Karuppampalayam Ranganathan", competency: "Pricing & Commercial Analysis", level: "L4 Expert" }, { employee: "Venkatadri Karuppampalayam Ranganathan", competency: "Spend Analytics & MIS Reporting", level: "L4 Expert" }, { employee: "Venkatadri Karuppampalayam Ranganathan", competency: "Export Documentation & Compliance", level: "L4 Expert" }, { employee: "Venkatadri Karuppampalayam Ranganathan", competency: "Freight Management & Chartering Coordination", level: "L3 Advanced" }, { employee: "Venkatadri Karuppampalayam Ranganathan", competency: "Import Documentation & Compliance", level: "L3 Advanced" }, { employee: "Venkatadri Karuppampalayam Ranganathan", competency: "RFx & Sourcing Execution", level: "L4 Expert" }, { employee: "Thiagarajan Subbiah", competency: "Contract Management & Compliance", level: "L4 Expert" }, { employee: "Thiagarajan Subbiah", competency: "Commercial Analytics & MIS", level: "L4 Expert" }, { employee: "Thiagarajan Subbiah", competency: "Pricing & Commercial Analysis", level: "L4 Expert" }, { employee: "Thiagarajan Subbiah", competency: "Spend Analytics & MIS Reporting", level: "L4 Expert" }, { employee: "Thiagarajan Subbiah", competency: "Export Documentation & Compliance", level: "L4 Expert" }, { employee: "Thiagarajan Subbiah", competency: "Freight Management & Chartering Coordination", level: "L3 Advanced" }, { employee: "Thiagarajan Subbiah", competency: "Voyage & Chartering Coordination", level: "L3 Advanced" }, { employee: "Thiagarajan Subbiah", competency: "Cost Optimization & TCO Analysis", level: "L4 Expert" }, { employee: "Sameer Vasudev Kulkarni", competency: "Contractual Risk & Governance", level: "L4 Expert" }, { employee: "Sameer Vasudev Kulkarni", competency: "Freight Management & Chartering Coordination", level: "L4 Expert" }, { employee: "Sameer Vasudev Kulkarni", competency: "Transport Planning & Secondary Distribution", level: "L4 Expert" }, { employee: "Sameer Vasudev Kulkarni", competency: "Voyage & Chartering Coordination", level: "L4 Expert" }, { employee: "Sameer Vasudev Kulkarni", competency: "Risk Management & Business Continuity", level: "L4 Expert" }, { employee: "Sameer Vasudev Kulkarni", competency: "Process Improvement & Governance", level: "L3 Advanced" }, { employee: "Sameer Vasudev Kulkarni", competency: "Coordination & Communication", level: "L3 Advanced" }, { employee: "Sameer Vasudev Kulkarni", competency: "Documentation, Compliance & Audit Readiness", level: "L4 Expert" }, { employee: "Vikas Kumar", competency: "Contractual Risk & Governance", level: "L3 Advanced" }, { employee: "Vikas Kumar", competency: "Freight Management & Chartering Coordination", level: "L3 Advanced" }, { employee: "Vikas Kumar", competency: "Transport Planning & Secondary Distribution", level: "L3 Advanced" }, { employee: "Vikas Kumar", competency: "Voyage & Chartering Coordination", level: "L2 Working" }, { employee: "Vikas Kumar", competency: "Risk Management & Business Continuity", level: "L2 Working" }, { employee: "Vikas Kumar", competency: "Process Improvement & Governance", level: "L2 Working" }, { employee: "Vikas Kumar", competency: "Coordination & Communication", level: "L2 Working" }, { employee: "Manali Vilasrao Pawar", competency: "Contractual Risk & Governance", level: "L2 Working" }, { employee: "Manali Vilasrao Pawar", competency: "Freight Management & Chartering Coordination", level: "L2 Working" }, { employee: "Manali Vilasrao Pawar", competency: "Transport Planning & Secondary Distribution", level: "L1 Foundational" }, { employee: "Manali Vilasrao Pawar", competency: "Voyage & Chartering Coordination", level: "L1 Foundational" }, { employee: "Manali Vilasrao Pawar", competency: "Risk Management & Business Continuity", level: "L1 Foundational" }, { employee: "Pratham Singh", competency: "Contractual Risk & Governance", level: "L2 Working" }, { employee: "Pratham Singh", competency: "Freight Management & Chartering Coordination", level: "L2 Working" }, { employee: "Pratham Singh", competency: "Transport Planning & Secondary Distribution", level: "L1 Foundational" }, { employee: "Pratham Singh", competency: "Voyage & Chartering Coordination", level: "L1 Foundational" }, { employee: "Pratham Singh", competency: "Risk Management & Business Continuity", level: "L1 Foundational" }, { employee: "Samir Dhiren Shah", competency: "Contractual Risk & Governance", level: "L4 Expert" }, { employee: "Samir Dhiren Shah", competency: "Freight Management & Chartering Coordination", level: "L4 Expert" }, { employee: "Samir Dhiren Shah", competency: "Transport Planning & Secondary Distribution", level: "L4 Expert" }, { employee: "Samir Dhiren Shah", competency: "Voyage & Chartering Coordination", level: "L4 Expert" }, { employee: "Samir Dhiren Shah", competency: "Risk Management & Business Continuity", level: "L4 Expert" }, { employee: "Samir Dhiren Shah", competency: "Process Improvement & Governance", level: "L3 Advanced" }, { employee: "Samir Dhiren Shah", competency: "Coordination & Communication", level: "L3 Advanced" }, { employee: "Samir Dhiren Shah", competency: "Stakeholder Management & Collaboration", level: "L4 Expert" }, { employee: "Venkatakrishnan Balakrishnan", competency: "Export Documentation & Compliance", level: "L4 Expert" }, { employee: "Venkatakrishnan Balakrishnan", competency: "Freight Management & Chartering Coordination", level: "L4 Expert" }, { employee: "Venkatakrishnan Balakrishnan", competency: "Transport Planning & Secondary Distribution", level: "L4 Expert" }, { employee: "Venkatakrishnan Balakrishnan", competency: "Carrier & Vendor Management", level: "L4 Expert" }, { employee: "Venkatakrishnan Balakrishnan", competency: "Shipment Tracking & Claims Management", level: "L4 Expert" }, { employee: "Venkatakrishnan Balakrishnan", competency: "Cost-to-Serve & Freight Optimization", level: "L3 Advanced" }, { employee: "Venkatakrishnan Balakrishnan", competency: "Safety & Compliance for Transport", level: "L3 Advanced" }, { employee: "Venkatakrishnan Balakrishnan", competency: "Documentation, Compliance & Audit Readiness", level: "L4 Expert" }, { employee: "Jignesh Harshavadan Vasavada", competency: "Export Documentation & Compliance", level: "L4 Expert" }, { employee: "Jignesh Harshavadan Vasavada", competency: "Freight Management & Chartering Coordination", level: "L4 Expert" }, { employee: "Jignesh Harshavadan Vasavada", competency: "Transport Planning & Secondary Distribution", level: "L4 Expert" }, { employee: "Jignesh Harshavadan Vasavada", competency: "Carrier & Vendor Management", level: "L4 Expert" }, { employee: "Jignesh Harshavadan Vasavada", competency: "Shipment Tracking & Claims Management", level: "L4 Expert" }, { employee: "Jignesh Harshavadan Vasavada", competency: "Cost-to-Serve & Freight Optimization", level: "L3 Advanced" }, { employee: "Jignesh Harshavadan Vasavada", competency: "Safety & Compliance for Transport", level: "L3 Advanced" }, { employee: "Jignesh Harshavadan Vasavada", competency: "System Data Entry & Accuracy", level: "L4 Expert" }, { employee: "Maheshkumar Vijaykumar Zala", competency: "Export Documentation & Compliance", level: "L3 Advanced" }, { employee: "Maheshkumar Vijaykumar Zala", competency: "Freight Management & Chartering Coordination", level: "L3 Advanced" }, { employee: "Maheshkumar Vijaykumar Zala", competency: "Transport Planning & Secondary Distribution", level: "L3 Advanced" }, { employee: "Maheshkumar Vijaykumar Zala", competency: "Carrier & Vendor Management", level: "L2 Working" }, { employee: "Maheshkumar Vijaykumar Zala", competency: "Shipment Tracking & Claims Management", level: "L2 Working" }, { employee: "Maheshkumar Vijaykumar Zala", competency: "Cost-to-Serve & Freight Optimization", level: "L2 Working" }, { employee: "Maheshkumar Vijaykumar Zala", competency: "Safety & Compliance for Transport", level: "L2 Working" }, { employee: "Nilesh Wagh", competency: "Export Documentation & Compliance", level: "L3 Advanced" }, { employee: "Nilesh Wagh", competency: "Freight Management & Chartering Coordination", level: "L3 Advanced" }, { employee: "Nilesh Wagh", competency: "Transport Planning & Secondary Distribution", level: "L3 Advanced" }, { employee: "Nilesh Wagh", competency: "Carrier & Vendor Management", level: "L2 Working" }, { employee: "Nilesh Wagh", competency: "Shipment Tracking & Claims Management", level: "L2 Working" }, { employee: "Nilesh Wagh", competency: "Cost-to-Serve & Freight Optimization", level: "L2 Working" }, { employee: "Nilesh Wagh", competency: "Safety & Compliance for Transport", level: "L2 Working" }, { employee: "Urvishkumar Solanki", competency: "Export Documentation & Compliance", level: "L3 Advanced" }, { employee: "Urvishkumar Solanki", competency: "Freight Management & Chartering Coordination", level: "L3 Advanced" }, { employee: "Urvishkumar Solanki", competency: "Transport Planning & Secondary Distribution", level: "L3 Advanced" }, { employee: "Urvishkumar Solanki", competency: "Carrier & Vendor Management", level: "L2 Working" }, { employee: "Urvishkumar Solanki", competency: "Shipment Tracking & Claims Management", level: "L2 Working" }, { employee: "Urvishkumar Solanki", competency: "Cost-to-Serve & Freight Optimization", level: "L2 Working" }, { employee: "Urvishkumar Solanki", competency: "Safety & Compliance for Transport", level: "L2 Working" }, { employee: "Tribhuvan Kumar Pandey", competency: "Export Documentation & Compliance", level: "L3 Advanced" }, { employee: "Tribhuvan Kumar Pandey", competency: "Freight Management & Chartering Coordination", level: "L3 Advanced" }, { employee: "Tribhuvan Kumar Pandey", competency: "Transport Planning & Secondary Distribution", level: "L3 Advanced" }, { employee: "Tribhuvan Kumar Pandey", competency: "Carrier & Vendor Management", level: "L2 Working" }, { employee: "Tribhuvan Kumar Pandey", competency: "Shipment Tracking & Claims Management", level: "L2 Working" }, { employee: "Tribhuvan Kumar Pandey", competency: "Cost-to-Serve & Freight Optimization", level: "L2 Working" }, { employee: "Tribhuvan Kumar Pandey", competency: "Safety & Compliance for Transport", level: "L2 Working" }, { employee: "Mukesh Munjabhai Hathia", competency: "Export Documentation & Compliance", level: "L3 Advanced" }, { employee: "Mukesh Munjabhai Hathia", competency: "Freight Management & Chartering Coordination", level: "L3 Advanced" }, { employee: "Mukesh Munjabhai Hathia", competency: "Transport Planning & Secondary Distribution", level: "L3 Advanced" }, { employee: "Mukesh Munjabhai Hathia", competency: "Carrier & Vendor Management", level: "L2 Working" }, { employee: "Mukesh Munjabhai Hathia", competency: "Shipment Tracking & Claims Management", level: "L2 Working" }, { employee: "Mukesh Munjabhai Hathia", competency: "Cost-to-Serve & Freight Optimization", level: "L2 Working" }, { employee: "Mukesh Munjabhai Hathia", competency: "Safety & Compliance for Transport", level: "L2 Working" }, { employee: "Devesh Mishra", competency: "Export Documentation & Compliance", level: "L3 Advanced" }, { employee: "Devesh Mishra", competency: "Freight Management & Chartering Coordination", level: "L3 Advanced" }, { employee: "Devesh Mishra", competency: "Transport Planning & Secondary Distribution", level: "L3 Advanced" }, { employee: "Devesh Mishra", competency: "Carrier & Vendor Management", level: "L2 Working" }, { employee: "Devesh Mishra", competency: "Shipment Tracking & Claims Management", level: "L2 Working" }, { employee: "Devesh Mishra", competency: "Cost-to-Serve & Freight Optimization", level: "L2 Working" }, { employee: "Devesh Mishra", competency: "Safety & Compliance for Transport", level: "L2 Working" }, { employee: "Jashwant Shankar Nayak", competency: "Export Documentation & Compliance", level: "L2 Working" }, { employee: "Jashwant Shankar Nayak", competency: "Freight Management & Chartering Coordination", level: "L2 Working" }, { employee: "Jashwant Shankar Nayak", competency: "Transport Planning & Secondary Distribution", level: "L1 Foundational" }, { employee: "Jashwant Shankar Nayak", competency: "Carrier & Vendor Management", level: "L1 Foundational" }, { employee: "Jashwant Shankar Nayak", competency: "Shipment Tracking & Claims Management", level: "L1 Foundational" }, { employee: "Sanket Jagannath Kirve", competency: "Export Documentation & Compliance", level: "L2 Working" }, { employee: "Sanket Jagannath Kirve", competency: "Freight Management & Chartering Coordination", level: "L2 Working" }, { employee: "Sanket Jagannath Kirve", competency: "Transport Planning & Secondary Distribution", level: "L2 Working" }, { employee: "Sanket Jagannath Kirve", competency: "Carrier & Vendor Management", level: "L2 Working" }, { employee: "Sanket Jagannath Kirve", competency: "Shipment Tracking & Claims Management", level: "L1 Foundational" }, { employee: "Sanket Jagannath Kirve", competency: "Cost-to-Serve & Freight Optimization", level: "L1 Foundational" }, { employee: "D M Modi", competency: "Purchase Order Processing & PR-PO Lifecycle", level: "L4 Expert" }, { employee: "D M Modi", competency: "Supplier Relationship Management (SRM)", level: "L4 Expert" }, { employee: "D M Modi", competency: "Contract Management & Compliance", level: "L4 Expert" }, { employee: "D M Modi", competency: "Negotiation & Commercials", level: "L4 Expert" }, { employee: "D M Modi", competency: "SAP Ariba / e-Procurement Operations", level: "L4 Expert" }, { employee: "D M Modi", competency: "Spend Analytics & MIS Reporting", level: "L3 Advanced" }, { employee: "D M Modi", competency: "Category Management", level: "L3 Advanced" }, { employee: "D M Modi", competency: "Problem Escalation & Resolution", level: "L4 Expert" }, { employee: "Kartik Bhanushankar Joshi", competency: "Purchase Order Processing & PR-PO Lifecycle", level: "L3 Advanced" }, { employee: "Kartik Bhanushankar Joshi", competency: "Supplier Relationship Management (SRM)", level: "L3 Advanced" }, { employee: "Kartik Bhanushankar Joshi", competency: "Contract Management & Compliance", level: "L3 Advanced" }, { employee: "Kartik Bhanushankar Joshi", competency: "Negotiation & Commercials", level: "L2 Working" }, { employee: "Kartik Bhanushankar Joshi", competency: "SAP Ariba / e-Procurement Operations", level: "L2 Working" }, { employee: "Kartik Bhanushankar Joshi", competency: "Spend Analytics & MIS Reporting", level: "L2 Working" }, { employee: "Kartik Bhanushankar Joshi", competency: "Category Management", level: "L2 Working" }, { employee: "Subrata Ghosh", competency: "Purchase Order Processing & PR-PO Lifecycle", level: "L3 Advanced" }, { employee: "Subrata Ghosh", competency: "Supplier Relationship Management (SRM)", level: "L3 Advanced" }, { employee: "Subrata Ghosh", competency: "Contract Management & Compliance", level: "L3 Advanced" }, { employee: "Subrata Ghosh", competency: "Negotiation & Commercials", level: "L2 Working" }, { employee: "Subrata Ghosh", competency: "SAP Ariba / e-Procurement Operations", level: "L2 Working" }, { employee: "Subrata Ghosh", competency: "Spend Analytics & MIS Reporting", level: "L2 Working" }, { employee: "Subrata Ghosh", competency: "Category Management", level: "L2 Working" }, { employee: "Manish Mancharam Ramavat", competency: "Purchase Order Processing & PR-PO Lifecycle", level: "L3 Advanced" }, { employee: "Manish Mancharam Ramavat", competency: "Supplier Relationship Management (SRM)", level: "L3 Advanced" }, { employee: "Manish Mancharam Ramavat", competency: "Contract Management & Compliance", level: "L3 Advanced" }, { employee: "Manish Mancharam Ramavat", competency: "Negotiation & Commercials", level: "L2 Working" }, { employee: "Manish Mancharam Ramavat", competency: "SAP Ariba / e-Procurement Operations", level: "L2 Working" }, { employee: "Manish Mancharam Ramavat", competency: "Spend Analytics & MIS Reporting", level: "L2 Working" }, { employee: "Manish Mancharam Ramavat", competency: "Category Management", level: "L2 Working" }, { employee: "Sujit Ranchhodbhai Patel", competency: "Purchase Order Processing & PR-PO Lifecycle", level: "L3 Advanced" }, { employee: "Sujit Ranchhodbhai Patel", competency: "Supplier Relationship Management (SRM)", level: "L3 Advanced" }, { employee: "Sujit Ranchhodbhai Patel", competency: "Contract Management & Compliance", level: "L3 Advanced" }, { employee: "Sujit Ranchhodbhai Patel", competency: "Negotiation & Commercials", level: "L2 Working" }, { employee: "Sujit Ranchhodbhai Patel", competency: "SAP Ariba / e-Procurement Operations", level: "L2 Working" }, { employee: "Sujit Ranchhodbhai Patel", competency: "Spend Analytics & MIS Reporting", level: "L2 Working" }, { employee: "Sujit Ranchhodbhai Patel", competency: "Category Management", level: "L2 Working" }, { employee: "Jayesh Gopalbhai Kotecha", competency: "Purchase Order Processing & PR-PO Lifecycle", level: "L3 Advanced" }, { employee: "Jayesh Gopalbhai Kotecha", competency: "Supplier Relationship Management (SRM)", level: "L3 Advanced" }, { employee: "Jayesh Gopalbhai Kotecha", competency: "Contract Management & Compliance", level: "L3 Advanced" }, { employee: "Jayesh Gopalbhai Kotecha", competency: "Negotiation & Commercials", level: "L2 Working" }, { employee: "Jayesh Gopalbhai Kotecha", competency: "SAP Ariba / e-Procurement Operations", level: "L2 Working" }, { employee: "Jayesh Gopalbhai Kotecha", competency: "Spend Analytics & MIS Reporting", level: "L2 Working" }, { employee: "Jayesh Gopalbhai Kotecha", competency: "Category Management", level: "L2 Working" }, { employee: "Harsh Gangabhai Parmar", competency: "Purchase Order Processing & PR-PO Lifecycle", level: "L3 Advanced" }, { employee: "Harsh Gangabhai Parmar", competency: "Supplier Relationship Management (SRM)", level: "L3 Advanced" }, { employee: "Harsh Gangabhai Parmar", competency: "Contract Management & Compliance", level: "L3 Advanced" }, { employee: "Harsh Gangabhai Parmar", competency: "Negotiation & Commercials", level: "L2 Working" }, { employee: "Harsh Gangabhai Parmar", competency: "SAP Ariba / e-Procurement Operations", level: "L2 Working" }, { employee: "Harsh Gangabhai Parmar", competency: "Spend Analytics & MIS Reporting", level: "L2 Working" }, { employee: "Harsh Gangabhai Parmar", competency: "Category Management", level: "L2 Working" }, { employee: "Rahul Shankar Waswani", competency: "Purchase Order Processing & PR-PO Lifecycle", level: "L3 Advanced" }, { employee: "Rahul Shankar Waswani", competency: "Supplier Relationship Management (SRM)", level: "L3 Advanced" }, { employee: "Rahul Shankar Waswani", competency: "Contract Management & Compliance", level: "L3 Advanced" }, { employee: "Rahul Shankar Waswani", competency: "Negotiation & Commercials", level: "L2 Working" }, { employee: "Rahul Shankar Waswani", competency: "SAP Ariba / e-Procurement Operations", level: "L2 Working" }, { employee: "Rahul Shankar Waswani", competency: "Spend Analytics & MIS Reporting", level: "L2 Working" }, { employee: "Rahul Shankar Waswani", competency: "Category Management", level: "L2 Working" }, { employee: "Tushar Bhikhubhai Modi", competency: "Purchase Order Processing & PR-PO Lifecycle", level: "L3 Advanced" }, { employee: "Tushar Bhikhubhai Modi", competency: "Supplier Relationship Management (SRM)", level: "L3 Advanced" }, { employee: "Tushar Bhikhubhai Modi", competency: "Contract Management & Compliance", level: "L3 Advanced" }, { employee: "Tushar Bhikhubhai Modi", competency: "Negotiation & Commercials", level: "L2 Working" }, { employee: "Tushar Bhikhubhai Modi", competency: "SAP Ariba / e-Procurement Operations", level: "L2 Working" }, { employee: "Tushar Bhikhubhai Modi", competency: "Spend Analytics & MIS Reporting", level: "L2 Working" }, { employee: "Tushar Bhikhubhai Modi", competency: "Category Management", level: "L2 Working" }, { employee: "Alpesh Chauhan", competency: "Purchase Order Processing & PR-PO Lifecycle", level: "L3 Advanced" }, { employee: "Alpesh Chauhan", competency: "Supplier Relationship Management (SRM)", level: "L3 Advanced" }, { employee: "Alpesh Chauhan", competency: "Contract Management & Compliance", level: "L3 Advanced" }, { employee: "Alpesh Chauhan", competency: "Negotiation & Commercials", level: "L2 Working" }, { employee: "Alpesh Chauhan", competency: "SAP Ariba / e-Procurement Operations", level: "L2 Working" }, { employee: "Alpesh Chauhan", competency: "Spend Analytics & MIS Reporting", level: "L2 Working" }, { employee: "Alpesh Chauhan", competency: "Category Management", level: "L2 Working" }, { employee: "Bhagyashree Singha", competency: "Purchase Order Processing & PR-PO Lifecycle", level: "L3 Advanced" }, { employee: "Bhagyashree Singha", competency: "Supplier Relationship Management (SRM)", level: "L3 Advanced" }, { employee: "Bhagyashree Singha", competency: "Contract Management & Compliance", level: "L3 Advanced" }, { employee: "Bhagyashree Singha", competency: "Negotiation & Commercials", level: "L2 Working" }, { employee: "Bhagyashree Singha", competency: "SAP Ariba / e-Procurement Operations", level: "L2 Working" }, { employee: "Bhagyashree Singha", competency: "Spend Analytics & MIS Reporting", level: "L2 Working" }, { employee: "Bhagyashree Singha", competency: "Category Management", level: "L2 Working" }, { employee: "Mohan Mangaldas Gokani", competency: "Export Documentation & Compliance", level: "L3 Advanced" }, { employee: "Mohan Mangaldas Gokani", competency: "Freight Management & Chartering Coordination", level: "L3 Advanced" }, { employee: "Mohan Mangaldas Gokani", competency: "Transport Planning & Secondary Distribution", level: "L3 Advanced" }, { employee: "Mohan Mangaldas Gokani", competency: "Carrier & Vendor Management", level: "L2 Working" }, { employee: "Mohan Mangaldas Gokani", competency: "Shipment Tracking & Claims Management", level: "L2 Working" }, { employee: "Mohan Mangaldas Gokani", competency: "Cost-to-Serve & Freight Optimization", level: "L2 Working" }, { employee: "Mohan Mangaldas Gokani", competency: "Safety & Compliance for Transport", level: "L2 Working" }, { employee: "Paras Gupta", competency: "Export Documentation & Compliance", level: "L3 Advanced" }, { employee: "Paras Gupta", competency: "Freight Management & Chartering Coordination", level: "L3 Advanced" }, { employee: "Paras Gupta", competency: "Transport Planning & Secondary Distribution", level: "L3 Advanced" }, { employee: "Paras Gupta", competency: "Carrier & Vendor Management", level: "L2 Working" }, { employee: "Paras Gupta", competency: "Shipment Tracking & Claims Management", level: "L2 Working" }, { employee: "Paras Gupta", competency: "Cost-to-Serve & Freight Optimization", level: "L2 Working" }, { employee: "Paras Gupta", competency: "Safety & Compliance for Transport", level: "L2 Working" }, { employee: "Akanksha Chaudhary", competency: "Export Documentation & Compliance", level: "L3 Advanced" }, { employee: "Akanksha Chaudhary", competency: "Freight Management & Chartering Coordination", level: "L3 Advanced" }, { employee: "Akanksha Chaudhary", competency: "Transport Planning & Secondary Distribution", level: "L3 Advanced" }, { employee: "Akanksha Chaudhary", competency: "Carrier & Vendor Management", level: "L2 Working" }, { employee: "Akanksha Chaudhary", competency: "Shipment Tracking & Claims Management", level: "L2 Working" }, { employee: "Akanksha Chaudhary", competency: "Cost-to-Serve & Freight Optimization", level: "L2 Working" }, { employee: "Akanksha Chaudhary", competency: "Safety & Compliance for Transport", level: "L2 Working" }, { employee: "Jatinder Dubey", competency: "Purchase Order Processing & PR-PO Lifecycle", level: "L4 Expert" }, { employee: "Jatinder Dubey", competency: "Supplier Relationship Management (SRM)", level: "L4 Expert" }, { employee: "Jatinder Dubey", competency: "Contract Management & Compliance", level: "L4 Expert" }, { employee: "Jatinder Dubey", competency: "Negotiation & Commercials", level: "L4 Expert" }, { employee: "Jatinder Dubey", competency: "SAP Ariba / e-Procurement Operations", level: "L4 Expert" }, { employee: "Jatinder Dubey", competency: "Spend Analytics & MIS Reporting", level: "L3 Advanced" }, { employee: "Jatinder Dubey", competency: "Category Management", level: "L3 Advanced" }, { employee: "Jatinder Dubey", competency: "Basic Supply Chain Execution", level: "L4 Expert" }, { employee: "Jignesh Bipin Jani", competency: "Purchase Order Processing & PR-PO Lifecycle", level: "L3 Advanced" }, { employee: "Jignesh Bipin Jani", competency: "Supplier Relationship Management (SRM)", level: "L3 Advanced" }, { employee: "Jignesh Bipin Jani", competency: "Contract Management & Compliance", level: "L3 Advanced" }, { employee: "Jignesh Bipin Jani", competency: "Negotiation & Commercials", level: "L2 Working" }, { employee: "Jignesh Bipin Jani", competency: "SAP Ariba / e-Procurement Operations", level: "L2 Working" }, { employee: "Jignesh Bipin Jani", competency: "Spend Analytics & MIS Reporting", level: "L2 Working" }, { employee: "Jignesh Bipin Jani", competency: "Category Management", level: "L2 Working" }, { employee: "K Satish", competency: "GRN & Material Receipt (SAP MIGO)", level: "L4 Expert" }, { employee: "K Satish", competency: "Inventory Accuracy & Cycle Counts", level: "L4 Expert" }, { employee: "K Satish", competency: "Material Issue & Requisition Management", level: "L4 Expert" }, { employee: "K Satish", competency: "SAP MM / Inventory Systems Operations", level: "L4 Expert" }, { employee: "K Satish", competency: "Store Housekeeping & HSE Compliance", level: "L4 Expert" }, { employee: "K Satish", competency: "Stock Valuation & Slow/Non-Moving Management", level: "L3 Advanced" }, { employee: "K Satish", competency: "Warehouse Layout & Space Optimization", level: "L3 Advanced" }, { employee: "K Satish", competency: "Risk Management & Business Continuity", level: "L4 Expert" }, { employee: "Uma Shankar Barathi Umakanthan", competency: "Contractual Risk & Governance", level: "L4 Expert" }, { employee: "Uma Shankar Barathi Umakanthan", competency: "Freight Management & Chartering Coordination", level: "L4 Expert" }, { employee: "Uma Shankar Barathi Umakanthan", competency: "Transport Planning & Secondary Distribution", level: "L4 Expert" }, { employee: "Uma Shankar Barathi Umakanthan", competency: "Voyage & Chartering Coordination", level: "L4 Expert" }, { employee: "Uma Shankar Barathi Umakanthan", competency: "Risk Management & Business Continuity", level: "L4 Expert" }, { employee: "Uma Shankar Barathi Umakanthan", competency: "Process Improvement & Governance", level: "L3 Advanced" }, { employee: "Uma Shankar Barathi Umakanthan", competency: "Coordination & Communication", level: "L3 Advanced" }, { employee: "Bhimashankar Manmathappa Halge", competency: "Export Documentation & Compliance", level: "L3 Advanced" }, { employee: "Bhimashankar Manmathappa Halge", competency: "Freight Management & Chartering Coordination", level: "L3 Advanced" }, { employee: "Bhimashankar Manmathappa Halge", competency: "Transport Planning & Secondary Distribution", level: "L3 Advanced" }, { employee: "Bhimashankar Manmathappa Halge", competency: "Carrier & Vendor Management", level: "L2 Working" }, { employee: "Bhimashankar Manmathappa Halge", competency: "Shipment Tracking & Claims Management", level: "L2 Working" }, { employee: "Bhimashankar Manmathappa Halge", competency: "Cost-to-Serve & Freight Optimization", level: "L2 Working" }, { employee: "Bhimashankar Manmathappa Halge", competency: "Safety & Compliance for Transport", level: "L2 Working" }, { employee: "Atla Kanaka Durga Prasad Reddy", competency: "Export Documentation & Compliance", level: "L2 Working" }, { employee: "Atla Kanaka Durga Prasad Reddy", competency: "Freight Management & Chartering Coordination", level: "L2 Working" }, { employee: "Atla Kanaka Durga Prasad Reddy", competency: "Transport Planning & Secondary Distribution", level: "L2 Working" }, { employee: "Atla Kanaka Durga Prasad Reddy", competency: "Carrier & Vendor Management", level: "L2 Working" }, { employee: "Atla Kanaka Durga Prasad Reddy", competency: "Shipment Tracking & Claims Management", level: "L1 Foundational" }, { employee: "Atla Kanaka Durga Prasad Reddy", competency: "Cost-to-Serve & Freight Optimization", level: "L1 Foundational" }, { employee: "Sravan Kumar Vemuri", competency: "Purchase Order Processing & PR-PO Lifecycle", level: "L2 Working" }, { employee: "Sravan Kumar Vemuri", competency: "Supplier Relationship Management (SRM)", level: "L2 Working" }, { employee: "Sravan Kumar Vemuri", competency: "Contract Management & Compliance", level: "L2 Working" }, { employee: "Sravan Kumar Vemuri", competency: "Negotiation & Commercials", level: "L2 Working" }, { employee: "Sravan Kumar Vemuri", competency: "SAP Ariba / e-Procurement Operations", level: "L1 Foundational" }, { employee: "Sravan Kumar Vemuri", competency: "Spend Analytics & MIS Reporting", level: "L1 Foundational" }, { employee: "Gopi Kottapalli", competency: "Purchase Order Processing & PR-PO Lifecycle", level: "L2 Working" }, { employee: "Gopi Kottapalli", competency: "Supplier Relationship Management (SRM)", level: "L2 Working" }, { employee: "Gopi Kottapalli", competency: "Contract Management & Compliance", level: "L2 Working" }, { employee: "Gopi Kottapalli", competency: "Negotiation & Commercials", level: "L2 Working" }, { employee: "Gopi Kottapalli", competency: "SAP Ariba / e-Procurement Operations", level: "L1 Foundational" }, { employee: "Gopi Kottapalli", competency: "Spend Analytics & MIS Reporting", level: "L1 Foundational" }, { employee: "Natarajan Sundaravel", competency: "GRN & Material Receipt (SAP MIGO)", level: "L2 Working" }, { employee: "Natarajan Sundaravel", competency: "Inventory Accuracy & Cycle Counts", level: "L2 Working" }, { employee: "Natarajan Sundaravel", competency: "Material Issue & Requisition Management", level: "L2 Working" }, { employee: "Natarajan Sundaravel", competency: "SAP MM / Inventory Systems Operations", level: "L2 Working" }, { employee: "Natarajan Sundaravel", competency: "Store Housekeeping & HSE Compliance", level: "L1 Foundational" }, { employee: "Natarajan Sundaravel", competency: "Stock Valuation & Slow/Non-Moving Management", level: "L1 Foundational" }, { employee: "Venkatesaperumal Pazhanivel", competency: "Export Documentation & Compliance", level: "L2 Working" }, { employee: "Venkatesaperumal Pazhanivel", competency: "Freight Management & Chartering Coordination", level: "L2 Working" }, { employee: "Venkatesaperumal Pazhanivel", competency: "Transport Planning & Secondary Distribution", level: "L2 Working" }, { employee: "Venkatesaperumal Pazhanivel", competency: "Carrier & Vendor Management", level: "L2 Working" }, { employee: "Venkatesaperumal Pazhanivel", competency: "Shipment Tracking & Claims Management", level: "L1 Foundational" }, { employee: "Venkatesaperumal Pazhanivel", competency: "Cost-to-Serve & Freight Optimization", level: "L1 Foundational" }, { employee: "Soundarapandian Subramaniyan", competency: "Purchase Order Processing & PR-PO Lifecycle", level: "L2 Working" }, { employee: "Soundarapandian Subramaniyan", competency: "Supplier Relationship Management (SRM)", level: "L2 Working" }, { employee: "Soundarapandian Subramaniyan", competency: "Contract Management & Compliance", level: "L2 Working" }, { employee: "Soundarapandian Subramaniyan", competency: "Negotiation & Commercials", level: "L2 Working" }, { employee: "Soundarapandian Subramaniyan", competency: "SAP Ariba / e-Procurement Operations", level: "L1 Foundational" }, { employee: "Soundarapandian Subramaniyan", competency: "Spend Analytics & MIS Reporting", level: "L1 Foundational" } ]; // Calculate metrics const totalEmployees = employees.length; const totalJobFamilies = [...new Set(employees.map(e => e.jobFamily))].length; const totalCompetencies = competencies.length; const jobFamilyDistribution = useMemo(() => { const dist = {}; employees.forEach(emp => { dist[emp.jobFamily] = (dist[emp.jobFamily] || 0) + 1; }); return Object.entries(dist).map(([name, value]) => ({ name, value })); }, []); const departmentDistribution = useMemo(() => { const dist = {}; employees.forEach(emp => { dist[emp.department] = (dist[emp.department] || 0) + 1; }); return Object.entries(dist).map(([name, value]) => ({ name, value })); }, []); const proficiencyDistribution = useMemo(() => { const dist = { 'L1 Foundational': 0, 'L2 Working': 0, 'L3 Advanced': 0, 'L4 Expert': 0 }; competencyMapping.forEach(mapping => { dist[mapping.level] = (dist[mapping.level] || 0) + 1; }); return Object.entries(dist).map(([name, value]) => ({ name, value })); }, []); const COLORS = ['#0088FE', '#00C49F', '#FFBB28', '#FF8042', '#8884D8', '#82CA9D']; // Filtered employees const filteredEmployees = useMemo(() => { return employees.filter(emp => { const matchesSearch = emp.name.toLowerCase().includes(searchTerm.toLowerCase()); const matchesJobFamily = filterJobFamily === 'All' || emp.jobFamily === filterJobFamily; const matchesBU = filterBU === 'All' || emp.bu === filterBU; return matchesSearch && matchesJobFamily && matchesBU; }); }, [searchTerm, filterJobFamily, filterBU]); const uniqueJobFamilies = ['All', ...new Set(employees.map(e => e.jobFamily))]; const uniqueBUs = ['All', ...new Set(employees.map(e => e.bu))]; // Get employee competencies const getEmployeeCompetencies = (employeeName) => { return competencyMapping.filter(m => m.employee === employeeName); }; // Get competency details const getCompetencyDetails = (competencyName) => { return competencies.find(c => c.name === competencyName); }; return (
{/* Header */}

Tata Chemicals Limited

Supply Chain Functional Competency Framework

{totalEmployees}
Team Members
{/* Navigation Tabs */}
{/* Main Content */}
{/* Dashboard Tab */} {activeTab === 'dashboard' && (
{/* Key Metrics */}

Total Employees

{totalEmployees}

Job Families

{totalJobFamilies}

Total Competencies

{totalCompetencies}

{/* Charts */}
{/* Job Family Distribution */}

Employees by Job Family

{/* Proficiency Distribution */}

Competency Proficiency Distribution

`${name}: ${(percent * 100).toFixed(0)}%`} outerRadius={80} fill="#8884d8" dataKey="value" > {proficiencyDistribution.map((entry, index) => ( ))}
{/* Department Overview */}

Department Distribution

{departmentDistribution.map((dept, idx) => (
{dept.value}
{dept.name}
))}
)} {/* Employee View Tab */} {activeTab === 'employees' && (
{/* Employee Selection */}
{/* Employee Details */} {selectedEmployee && (() => { const employee = employees.find(e => e.name === selectedEmployee); const empCompetencies = getEmployeeCompetencies(selectedEmployee); return (
{/* Employee Info Card */}

{employee.name}

Designation

{employee.designation}

Department

{employee.department}

Business Unit

{employee.bu}

Job Family

{employee.jobFamily}

{/* Competencies Table */}

Competencies ({empCompetencies.length})

{empCompetencies.map((mapping, idx) => { const comp = getCompetencyDetails(mapping.competency); const isExpanded = expandedCompetency === `${selectedEmployee}-${idx}`; return (
setExpandedCompetency(isExpanded ? null : `${selectedEmployee}-${idx}`)} >

{mapping.competency}

{comp?.category}

{mapping.level} {isExpanded ? : }
{isExpanded && comp && (
Definition

{comp.definition}

{Object.entries(comp.levels).map(([level, desc]) => (
{level}

{desc}

))}
)}
); })}
); })()}
)} {/* Competency Framework Tab */} {activeTab === 'competencies' && (
{/* Category Filter */}
{['All', 'Procurement', 'Logistics', 'Stores', 'Cross-Functional'].map(cat => ( ))}
{/* Competencies Grid */}
{competencies .filter(comp => searchTerm === '' || comp.category.includes(searchTerm)) .map((comp, idx) => { const isExpanded = expandedCompetency === `comp-${idx}`; return (
setExpandedCompetency(isExpanded ? null : `comp-${idx}`)} >

{comp.name}

{comp.category}

{comp.definition}

{isExpanded ? : }
{isExpanded && (

Proficiency Levels

{Object.entries(comp.levels).map(([level, desc]) => (
{level}

{desc}

))}
)}
); })}
)} {/* Analytics Tab */} {activeTab === 'analytics' && (
{/* Filters */}

Filters

setSearchTerm(e.target.value)} placeholder="Search by name..." className="w-full px-4 py-2 border border-slate-300 rounded-lg focus:ring-2 focus:ring-blue-500" />
{/* Filtered Results */}

Employee List ({filteredEmployees.length} employees)

{filteredEmployees.map((emp, idx) => { const compCount = getEmployeeCompetencies(emp.name).length; return ( ); })}
Name Designation Department BU Job Family Competencies
{emp.name} {emp.designation} {emp.department} {emp.bu} {emp.jobFamily} {compCount} competencies
{/* Summary Stats */}

Filtered Employees

{filteredEmployees.length}

Avg Competencies per Employee

{filteredEmployees.length > 0 ? (filteredEmployees.reduce((sum, emp) => sum + getEmployeeCompetencies(emp.name).length, 0) / filteredEmployees.length).toFixed(1) : 0}

Total Competency Mappings

{filteredEmployees.reduce((sum, emp) => sum + getEmployeeCompetencies(emp.name).length, 0)}

)}
{/* Footer */}
); }; export default CompetencyPortal;